CN115840771A - Data processing system - Google Patents
Data processing system Download PDFInfo
- Publication number
- CN115840771A CN115840771A CN202310109536.6A CN202310109536A CN115840771A CN 115840771 A CN115840771 A CN 115840771A CN 202310109536 A CN202310109536 A CN 202310109536A CN 115840771 A CN115840771 A CN 115840771A
- Authority
- CN
- China
- Prior art keywords
- data
- preset
- filled
- generated
- target
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data processing system, which is used for acquiring a target data table and an intermediate processing data table corresponding to the target data table, and further stores a trusted database, a processor and a memory storing a section of computer program, wherein the memory also stores a preset configuration table, a preset template table, a preset intermediate processing data table and a preset target data table, the preset template table at least comprises a cell to be filled, and when the processor executes the section of computer program, the following steps are realized: acquiring a to-be-filled data list corresponding to all to-be-filled cells, processing the to-be-filled data list based on a target configuration table, and acquiring a final data packet, wherein a user configures based on a preset configuration table to acquire the target configuration table; the accuracy of the target data is achieved through the method, the operation efficiency is greatly improved, and the operation time is saved.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a data processing system.
Background
The data processing field is an important branch of the computer field, along with the development of a big data era, the data volume is larger and larger, the data processing is more and more complex, meanwhile, the precision of the processed data is higher and higher, and the speed of obtaining the processed data is higher and higher; at present, a semi-automatic and semi-manual mode is often used for calculating complex and large data quantity, but the calculation is carried out manually, so that on one hand, the calculation time is long, on the other hand, the manual cost is high, and the accuracy of calculated data is difficult to guarantee; for example, an insurance company carries out quantitative assessment of the assets and liabilities every quarter, a quantitative assessment report of asset and liabilities management needs to be formed and sent to a supervision department, the quantitative assessment report comprises four parts, namely basic information, time limit structure matching, cost and income matching and cash flow matching, the design data volume is huge, index calculation is complex, most insurance companies carry out semi-automatic semi-manual report based on Excel at present, one insurance company generally needs one week of time for making a quantitative assessment report of asset and liabilities management, and data accuracy is difficult to guarantee.
Disclosure of Invention
Aiming at the technical problems, the technical scheme adopted by the invention is as follows: a data processing system is used for acquiring a target data table and an intermediate processing data table corresponding to the target data table, wherein the intermediate processing data table is a calculation process required for acquiring the target data table, and the target data table and the intermediate processing data table contain data of a preset threshold type.
The system is provided with a processor and a trusted database which are in communication connection.
The system is provided with a memory for storing a section of computer program, and the memory is also provided with a preset configuration table, a preset template table, a preset intermediate processing data table and a preset target data table, wherein the preset template table at least comprises a cell to be filled.
Wherein, when the processor executes the piece of computer program, the following steps are implemented:
and S100, acquiring a data list to be filled corresponding to all the cells to be filled.
And S200, processing the data list to be filled based on the target configuration table to obtain a final data packet, wherein the user configures based on a preset configuration table to obtain the target configuration table.
Wherein, the step of S200 further comprises the following steps:
s201, inquiring from a trusted database based on the data list to be filled, and acquiring data to be generated corresponding to the cell to be generated so as to acquire the data list to be generated.
S202, processing is carried out according to a first preset rule based on the data list to be filled and the data list to be generated, and an intermediate processing data list A = { A } corresponding to a preset intermediate processing data list is obtained 1 ，A 2 ，…，A j ，…，A n }，A j Is the jth intermediate processed data, j has a value ranging from 1 to n, and n is the number of intermediate processed data.
And S203, calculating the intermediate processing data list A according to a second preset rule based on the target configuration table, and acquiring target data corresponding to the preset target data table.
And S204, performing data packing on the preset intermediate processing data table after the intermediate processing data list is filled and the preset target data table after the target data is filled, and acquiring a final data packet.
The invention has at least the following beneficial effects: the invention provides a data processing system for acquiring a target data table and an intermediate processing data table corresponding to the target data table, wherein the acquired target data has large data volume and more target data types, the system stores a preset configuration table, a trusted database, a preset template table, a preset intermediate processing data table and a preset target data table, and a processor realizes the following steps: the method comprises the steps of obtaining data to be filled corresponding to all cells to be filled, inquiring from a credible database based on the data to be filled, obtaining data to be generated, calculating according to a first preset rule based on the data to be filled and the data to be generated, obtaining an intermediate processing data list corresponding to a preset intermediate processing data list, calculating according to a second preset rule based on a target configuration list, obtaining target data corresponding to a preset target data list, packing the preset target data list after the target data is filled and the preset intermediate processing data list after the intermediate processing data is filled, obtaining a final data packet, and accordingly achieving the purpose that a user only inputs a minimum amount of data.
Drawings
In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required to be used in the description of the embodiments are briefly introduced below, and it is obvious that the drawings in the description below are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained according to the drawings without creative efforts.
Fig. 1 is a flowchart of a data processing system according to an embodiment of the present invention when executing a computer program.
Detailed Description
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It is noted that the terms first, second and the like in the description and in the claims of the present invention and in the drawings described above are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It is to be understood that the data so used is interchangeable under appropriate circumstances such that the embodiments of the invention described herein are capable of operation in other sequences than those illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or server that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
The embodiment of the invention provides a data processing system for acquiring a target data table and an intermediate processing data table corresponding to the target data table, wherein the intermediate processing data table is a calculation process required for acquiring the target data table, and the target data table and the intermediate processing data table both comprise data fields with preset threshold values.
Specifically, the data fields in the target data table and the intermediate processing data table may be determined according to actual needs of users.
The system is provided with a processor and a trusted database which are in communication connection.
The system is provided with a memory for storing a section of computer program, and the memory is also provided with a preset configuration table, a preset template table, a preset intermediate processing data table and a preset target data table, wherein the preset template table at least comprises one cell to be filled and at least one cell to be generated.
Wherein, as shown in fig. 1, when the processor executes the computer program, the following steps are implemented:
and S100, acquiring a data list to be filled corresponding to all the cells to be filled.
Specifically, in S100, the data list to be filled in is manually input.
Further, in S100, the data list to be filled in further includes preset target associated data that is automatically generated according to a third preset rule, where the preset target associated data may be determined according to actual requirements. Illustratively, the present invention is configured to obtain a target data table of a certain company, where the target data is target business data, and the target business data may be asset data, product information data, and the like of the company, and the data to be filled is original input data related to the target business data, for example, the data to be processed is data that can be obtained without calculation or with simple calculation, and the data to be filled may be original asset data, basic employee information data, product sales data, and the like of the company.
Further, in S100, the data list to be filled out further includes default values assigned by the system according to a fourth preset rule.
Specifically, those skilled in the art know that any method for acquiring data to be filled according to preset target associated data in the prior art belongs to the protection scope of the present invention, and details are not repeated herein.
Further, after S100, the method further includes: and checking the data list to be filled and returning a preset modification instruction.
It can be understood that after the data to be filled corresponding to all the cells to be filled are obtained, verification is performed, and when the data to be filled of any cell to be filled is incorrect after verification, a preset modification instruction is returned, wherein the preset modification instruction indicates the path position of the cell to be filled.
And S200, processing the data list to be filled based on the target configuration table to obtain a final data packet, wherein the user configures based on a preset configuration table to obtain the target configuration table.
Specifically, the target configuration table can be configured by a user according to actual needs; illustratively, a user may select a preset configuration from a preset configuration table, use the selected configuration as a target configuration table, and obtain a type of target data required by the user and a calculation process corresponding to the target data based on the target configuration table.
Wherein, the step of S200 further comprises the following steps:
s201, inquiring from a trusted database based on the data list to be filled, and acquiring data to be generated corresponding to the cell to be generated so as to acquire the data list to be generated.
Specifically, it is understood that the data to be filled out at least includes data that is not retrieved in the trusted database and is needed to be used in a subsequent process, and data used for retrieving in the trusted database to obtain data to be generated.
Further, after the to-be-generated data list is obtained, the to-be-generated data is filled in a preset intermediate processing data table according to a preset position.
Specifically, those skilled in the art know that any method in the prior art for obtaining the data to be generated by querying from the trusted database based on the data list to be filled belongs to the protection scope of the present invention, and details are not described here.
Furthermore, when the to-be-generated data corresponding to the to-be-generated cell cannot be queried in the trusted database, whether the to-be-generated data is used by the first preset rule is judged, and the following steps are executed:
s2011, when all the first preset rules do not use the data to be generated, the blank of the cell to be generated is reserved, otherwise, S2012 is executed.
And S2012, inputting the data to be generated of the cell to be generated in the preset template table by the user, and if the data to be generated does not have the associated field in the preset template table, inputting the data to be generated of the cell to be generated in the preset intermediate processing data table by the user.
Specifically, if the data to be generated has no associated field in the preset template table, the user directly inputs the data to be generated of the cell to be generated in the preset intermediate processing data table.
S2013, updating the first preset rule using the data to be generated.
Specifically, the updating the first preset rule using the data to be generated is to update the corresponding position of the cell to be generated referred to in the first preset rule to the corresponding position of the corresponding cell to be generated referred to in the preset template table or the intermediate processing data table.
Further, when the data list to be filled in and the data list to be generated both contain data corresponding to a certain cell in a preset template table, the data list to be filled in is prior to the data list to be generated for processing according to a first preset rule.
Based on this, when the to-be-generated data corresponding to the to-be-generated cell cannot be queried in the trusted database, firstly, a judgment is made to judge whether a first preset rule uses the to-be-generated data, when all the first preset rules do not use the to-be-generated data, the to-be-generated data is not important, and the to-be-generated data is not used in the calculation of target data, so that the blank of the to-be-generated cell can be reserved.
S202, processing is carried out according to a first preset rule based on the data list to be filled and the data list to be generated, and an intermediate processing data list A = { A } corresponding to a preset intermediate processing data list is obtained 1 ，A 2 ，…，A j ，…，A n }，A j Is the jth intermediate processed data, j has a value ranging from 1 to n, and n is the number of intermediate processed data.
Specifically, the preset intermediate processing data table is one or more.
Specifically, the first preset rules corresponding to at least two types of intermediate processing data are different.
Further, the first preset rule is a first processing rule based on the position paths of the cells to be filled and the cells to be generated, and the first processing rule is preset according to actual needs.
Specifically, the intermediate processing data is intermediate processing data obtained by processing based on the original input data, and illustratively, the intermediate processing data may be intermediate asset income data obtained by processing the original asset data and the product sales data according to a first preset rule.
And S203, calculating the intermediate processing data list A according to a second preset rule based on the target configuration table, and acquiring target data corresponding to the preset target data table.
Specifically, the target data is calculated and obtained according to a second preset rule based on one or more intermediate processing data lists.
Further, the second preset rule is a second processing rule based on a position path of a cell corresponding to a preset intermediate processing data table, and the second processing rule may be set according to actual needs.
And S204, performing data packaging on the preset intermediate processing data table filled with the intermediate processing data list and the preset target data table filled with the target data to obtain a final data packet.
In a preferred embodiment of the present invention, the present invention is used for generating the asset segment of the quantitative assessment table of the liabilities of the insurance company in each quarter, in this case, the target data table contains all data fields of the asset segment of the quantitative assessment table of the liabilities specified by the regulatory body, such as internal rate of return, high, medium and low asset transition size, and the first processing rule and the second processing rule are specified algorithms specified by the regulatory body.
In summary, the present invention provides a data processing system for acquiring a target data table and an intermediate processing data table corresponding to the target data table, where the acquired target data has a large data volume and a large number of types of target data, the system stores a preset configuration table, a trusted database, a preset template table, a preset intermediate processing data table, and a preset target data table, and a processor implements the following steps: the method comprises the steps of obtaining data to be filled corresponding to all cells to be filled, inquiring from a credible database based on the data to be filled, obtaining data to be generated, calculating according to a first preset rule based on the data to be filled and the data to be generated, obtaining an intermediate processing data list corresponding to a preset intermediate processing data list, calculating according to a second preset rule based on a target configuration list, obtaining target data corresponding to a preset target data list, packing the preset target data list after the target data is filled and the preset intermediate processing data list after the intermediate processing data is filled, obtaining a final data packet, and accordingly achieving the purpose that a user only inputs a minimum amount of data.
In a preferred embodiment, the invention is used for generating the asset end part of the asset and debt quantitative evaluation table of an insurance company in each quarter, namely in the preferred embodiment, a user downloads a preset template table, manually fills information such as inventory asset detail, economic scene hypothesis, investable cash flow and configuration hypothesis information, uploads the filled preset template table, the system automatically fills in a cell to be generated according to a trusted database, calculates according to the trusted database and calculation logic, obtains a filled intermediate calculation table, automatically checks asset information, and finally generates a quantitative evaluation result, and the user can download a complete quantitative evaluation table according to the requirement.
Although some specific embodiments of the present invention have been described in detail by way of example, it should be understood by those skilled in the art that the above examples are for illustration only and are not intended to limit the scope of the invention. It will also be appreciated by those skilled in the art that various modifications may be made to the embodiments without departing from the scope and spirit of the invention. The scope of the invention is defined by the appended claims.
Claims (9)
1. A data processing system is characterized by being used for acquiring a target data table and an intermediate processing data table corresponding to the target data table, wherein the target data is target service data, the target service data is asset data and product information data, the intermediate processing data table is a calculation process required for acquiring the target data table, and the target data table and the intermediate processing data table comprise data fields with preset threshold values;
the system is provided with a processor and a trusted database which are in communication connection;
the system is provided with a memory for storing a section of computer program, and the memory is also provided with a preset configuration table, a preset template table, a preset intermediate processing data table and a preset target data table, wherein the preset template table at least comprises a cell to be filled;
wherein, when the processor executes the piece of computer program, the following steps are implemented:
s100, acquiring a to-be-filled data list corresponding to all to-be-filled cells, wherein the to-be-filled data are original asset data, basic employee information data and product sales data;
s200, processing a to-be-filled data list based on a target configuration table to obtain a final data packet, wherein a user configures based on a preset configuration table to obtain the target configuration table;
wherein, the step of S200 further comprises the following steps:
s201, inquiring from a trusted database based on the data list to be filled, and acquiring data to be generated corresponding to the cell to be generated so as to acquire a data list to be generated;
s202, processing is carried out according to a first preset rule based on the data list to be filled and the data list to be generated, and an intermediate processing data list A = { A } corresponding to a preset intermediate processing data list is obtained 1 ，A 2 ，…，A j ，…，A n }，A j J is the jth intermediate processing data, the value range of j is 1 to n, and n is the number of the intermediate processing data;
s203, calculating the intermediate processing data list A according to a second preset rule based on the target configuration table to obtain target data corresponding to a preset target data table;
and S204, performing data packaging on the preset intermediate processing data table filled with the intermediate processing data list and the preset target data table filled with the target data to obtain a final data packet.
2. The system according to claim 1, wherein the data list to be filled in is manually input in S100.
3. The system according to claim 1, wherein in S100, the to-be-filled data list is further generated automatically according to a third preset rule from preset target associated data.
4. The system according to claim 1, wherein in S100, the data list to be filled out further comprises default values assigned by the system according to a fourth preset rule.
5. The system according to claim 1, wherein the target data is processed and obtained according to a second preset rule based on an intermediate processing data list corresponding to one or more preset intermediate processing data tables.
6. The system according to claim 1, wherein in S202, the first preset rules corresponding to at least two types of intermediate processing data are different.
7. The system according to claim 1, wherein in S201, when the trusted database does not inquire about the data to be generated of the cell to be generated, it is determined whether the first preset rule uses the cell to be generated, and the following steps are executed:
s2011, when all the first preset rules do not use the data to be generated, reserving a blank of the cell to be generated, otherwise, executing S2012;
s2012, inputting the data to be generated of the cell to be generated in a preset template table by a user;
if the data to be generated has no associated field in the preset template table, the user inputs the data to be generated of the cell to be generated in a preset intermediate processing data table;
s2013, updating the first preset rule using the data to be generated.
8. The system of claim 1, further comprising after S100: and checking the data list to be filled and returning a preset modification instruction.
9. The system according to claim 1, wherein when the to-be-filled data list and the to-be-generated data list both contain data corresponding to a cell in a preset template table, the to-be-filled data list is prioritized over the to-be-generated data list for processing according to a first preset rule.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310109536.6A CN115840771B (en) | 2023-02-14 | 2023-02-14 | Data processing system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202310109536.6A CN115840771B (en) | 2023-02-14 | 2023-02-14 | Data processing system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN115840771A true CN115840771A (en) | 2023-03-24 |
| CN115840771B CN115840771B (en) | 2023-04-28 |
Family
ID=85579624
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202310109536.6A Active CN115840771B (en) | 2023-02-14 | 2023-02-14 | Data processing system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN115840771B (en) |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150370776A1 (en) * | 2014-06-18 | 2015-12-24 | Yokogawa Electric Corporation | Method, system and computer program for generating electronic checklists |
| US20170357628A1 (en) * | 2016-06-08 | 2017-12-14 | j5 International IP Corporation | Spreadsheet-Based Form Design and Data Input |
| CN110473080A (en) * | 2019-07-30 | 2019-11-19 | 阿里巴巴集团控股有限公司 | A kind of report processing method, device and computer equipment |
| CN111125067A (en) * | 2019-12-31 | 2020-05-08 | 中国银行股份有限公司 | Data maintenance method and device |
| CN113485781A (en) * | 2021-07-23 | 2021-10-08 | 中国建设银行股份有限公司 | Report generation method and device, electronic equipment and computer readable medium |
| CN115061721A (en) * | 2022-07-12 | 2022-09-16 | 平安科技（深圳）有限公司 | Report generation method and device, computer equipment and storage medium |
-
2023
- 2023-02-14 CN CN202310109536.6A patent/CN115840771B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150370776A1 (en) * | 2014-06-18 | 2015-12-24 | Yokogawa Electric Corporation | Method, system and computer program for generating electronic checklists |
| US20170357628A1 (en) * | 2016-06-08 | 2017-12-14 | j5 International IP Corporation | Spreadsheet-Based Form Design and Data Input |
| CN110473080A (en) * | 2019-07-30 | 2019-11-19 | 阿里巴巴集团控股有限公司 | A kind of report processing method, device and computer equipment |
| CN111125067A (en) * | 2019-12-31 | 2020-05-08 | 中国银行股份有限公司 | Data maintenance method and device |
| CN113485781A (en) * | 2021-07-23 | 2021-10-08 | 中国建设银行股份有限公司 | Report generation method and device, electronic equipment and computer readable medium |
| CN115061721A (en) * | 2022-07-12 | 2022-09-16 | 平安科技（深圳）有限公司 | Report generation method and device, computer equipment and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN115840771B (en) | 2023-04-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Gabrel et al. | Linear programming with interval right hand sides | |
| CN111340148B (en) | Training method of business classification model, business classification method and terminal | |
| CN107590123A (en) | Vehicle-mounted middle place context reference resolution method and device | |
| CN108170759A (en) | Method, apparatus, computer equipment and the storage medium of tip-offs about environmental issues processing | |
| Ochoa et al. | A survey on scalability and performance concerns in extended product lines configuration | |
| Zhang et al. | Hesitant fuzzy methods for multiple criteria decision analysis | |
| CN110874528A (en) | Text similarity obtaining method and device | |
| Kahalé | Superreplication of financial derivatives via convex programming | |
| Wagner et al. | Consistent monitoring of cointegrating relationships: The US housing market and the subprime crisis | |
| CN112036631A (en) | Purchasing quantity determination method, device, equipment and storage medium | |
| Guo et al. | Robust spectral risk optimization when the subjective risk aversion is ambiguous: a moment-type approach | |
| Bodnar et al. | Mean-variance efficiency of optimal power and logarithmic utility portfolios | |
| CN108664605A (en) | A kind of model evaluation method and system | |
| CN117787550A (en) | Index processing method and device based on incremental calculation model and electronic equipment | |
| Stahl et al. | Name your own price on data marketplaces | |
| CN115840771B (en) | Data processing system | |
| CN111522840A (en) | Label configuration method, device, equipment and computer readable storage medium | |
| Chen et al. | Inference for a mean-reverting stochastic process with multiple change points | |
| CN112988698A (en) | Data processing method and device | |
| CN114925919A (en) | Service resource processing method and device, computer equipment and storage medium | |
| Wen | The Brownian plane with minimal neck baby universe | |
| Cheng et al. | An efficient service discovery algorithm for counting bloom filter-based service registry | |
| CN111913945A (en) | Data management method and device and storage medium | |
| Amigó et al. | FORMULAS FOR THE TOPOLOGICAL ENTROPY OF MULTIMODAL MAPS BASED ON MIN-MAX SYMBOLS. | |
| CN110569435A (en) | Intelligent dual-ended recommendation engine system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |