CN114943525A - Multi-dimensional data checking system - Google Patents
Multi-dimensional data checking system Download PDFInfo
- Publication number
- CN114943525A CN114943525A CN202210707263.0A CN202210707263A CN114943525A CN 114943525 A CN114943525 A CN 114943525A CN 202210707263 A CN202210707263 A CN 202210707263A CN 114943525 A CN114943525 A CN 114943525A
- Authority
- CN
- China
- Prior art keywords
- data
- bill
- business
- service
- unit
- 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.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/10—Office automation; Time management
- G06Q10/103—Workflow collaboration or project management
Landscapes
- Business, Economics & Management (AREA)
- Human Resources & Organizations (AREA)
- Strategic Management (AREA)
- Engineering & Computer Science (AREA)
- Entrepreneurship & Innovation (AREA)
- Operations Research (AREA)
- Economics (AREA)
- Marketing (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- Physics & Mathematics (AREA)
- General Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Theoretical Computer Science (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a checking system of multidimensional data, which comprises: the source bill analysis module is used for checking data of the business bill from the dimensionality of the source bill after the business is finished so as to check the data on the final business bill by analyzing the data on the source bill; the process flow analysis module is used for carrying out data check on the process bills corresponding to each business process in the business generation process; and the path multipoint comparison and analysis module is used for simulating each bill possibly appearing in the service generation process before the service is started, and comparing and analyzing the simulation result and the actual process data in the service generation process. The multi-dimensional data checking system provided by the invention checks the service data from different dimensions through the source single analysis module, the process flow analysis module and the path multi-point comparison analysis module, and can achieve the effects of high efficiency, low error rate and high detection rate; and various types of business document data checking are supported.
Description
Technical Field
The invention relates to the technical field of data checking, in particular to a multi-dimensional data checking system.
Background
In a scene of checking the business document, whether the business is abnormal or not is judged through data checking of a source document, a process document and a final business document.
At present, when a business document is checked, the check is generally performed by adopting a final result, a total result and other modes. The final result and the total result are calculated through manual calculation or program calculation, the manual calculation efficiency is low, the error rate is high, the program calculation efficiency is high, and the error rate is low.
Therefore, a checking system for multidimensional data is needed.
Disclosure of Invention
The present invention is directed to a system for collating multidimensional data, which solves the above-mentioned problems of the prior art, and can collate data from a plurality of dimensions to ensure the correctness of the data.
The invention provides a checking system of multi-dimensional data, which comprises:
the source bill analysis module is used for checking data of the business bill from the dimensionality of the source bill after the business is finished so as to check the data on the final business bill by analyzing the data on the source bill;
the process flow analysis module is used for carrying out data check on the process bills corresponding to each business process in the business generation process;
and the path multipoint comparison and analysis module is used for simulating each bill possibly appearing in the service generation process before the service is started, and comparing and analyzing the simulation result and the actual process data in the service generation process.
The system for checking multidimensional data as described above, preferably, the source document analysis module includes a source document tracing unit, a data processing unit, and a source single-dimensional analysis unit, wherein:
the source receipt tracing unit is used for tracing all source receipts corresponding to the final business receipt according to the final business receipt;
the data processing unit is used for processing and summarizing data of all traced source documents;
and the source single-dimension analysis unit is used for comparing the data collected by the data processing unit with the data corresponding to the final service bill, and if the deviation of the data collected by the data processing unit and the data corresponding to the final service bill exceeds a first preset threshold value, the final service bill is abnormal.
The system for checking multidimensional data as described above, wherein preferably, the process flow analysis module includes a service node definition unit, a process data conversion unit and a process data analysis unit, wherein:
the service node definition unit is used for defining service nodes in the service generation process according to a preset rule;
the process data conversion unit is used for determining data conversion rules of the data to be analyzed at each service node;
and the process data analysis unit is used for analyzing whether the business bill generated in each business process is abnormal or not according to the data conversion rule.
The system for checking multidimensional data as described above, wherein preferably, the preset rule includes that a node where data to be analyzed changes during a service occurrence process is used as a service node during the service occurrence process.
The system for checking multidimensional data as described above, wherein the service nodes defined by the service node definition unit preferably include quantity conversion, quantity splitting, price discounting and manual adjustment.
The system for checking multidimensional data as described above, wherein preferably the data to be analyzed includes the number of single materials, unit price of single materials, number of final products, unit price of final products, and total price of final products.
The system for checking multidimensional data as described above, wherein preferably, the path multipoint comparison and analysis module includes a circulation path analysis unit, a document simulation unit and a path multipoint analysis unit, wherein:
the flow path analysis unit is used for analyzing the flow path of the business document based on each business process according to the preset business to obtain the flow path of the data corresponding to each material in the business generation process;
the bill simulation unit is used for simulating all bills corresponding to each service node on a service bill circulation path;
the path multipoint analysis unit is used for comparing a bill simulation result of the bill simulation unit with actual process data in a service occurrence process, and if the deviation of the bill simulation result and the actual process data exceeds a second preset threshold value, the actual process data is abnormal.
The multi-dimensional data checking system checks the service data from different dimensions through the source single analysis module, the process flow analysis module and the path multi-point comparison analysis module, and can achieve the effects of high efficiency, low error rate and high detection rate; various types of business document data checking are supported; data checking of business documents after complex circulation flows is supported; the comparison between the preset service path simulation and the actual service operation result is supported; supporting multi-type and self-defined process nodes and a self-defined node data comparison algorithm; the functions of self-defined analysis results, log inspection and the like can be expanded and supported; the method can solve the problems of low manual accounting efficiency and high error rate and the problem that the actual service error cannot be detected due to homologous sources in a program accounting algorithm.
Drawings
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention will be further described with reference to the accompanying drawings, in which:
FIG. 1 is a block diagram of an embodiment of a system for reconciling multidimensional data provided by the present invention;
fig. 2 is a schematic diagram of a working process of the multidimensional data collation system provided by the present invention.
Detailed Description
Various exemplary embodiments of the present disclosure will now be described in detail with reference to the accompanying drawings. The description of the exemplary embodiments is merely illustrative and is in no way intended to limit the disclosure, its application, or uses. The present disclosure may be embodied in many different forms and is not limited to the embodiments described herein. These embodiments are provided so that this disclosure will be thorough and complete, and will fully convey the scope of the disclosure to those skilled in the art. It should be noted that: the relative arrangement of parts and steps, the composition of materials, numerical expressions and numerical values set forth in these embodiments are to be construed as merely illustrative, and not as limitative, unless specifically stated otherwise.
As used in this disclosure, "first", "second": and the like, do not denote any order, quantity, or importance, but rather are used to distinguish one element from another. The word "comprising" or "comprises", and the like, means that the element preceding the word covers the element listed after the word, and does not exclude the possibility that other elements are also covered. "upper", "lower", and the like are used merely to indicate relative positional relationships, and when the absolute position of the object being described is changed, the relative positional relationships may also be changed accordingly.
In the present disclosure, when a specific component is described as being located between a first component and a second component, there may or may not be intervening components between the specific component and the first component or the second component. When it is described that a specific component is connected to other components, the specific component may be directly connected to the other components without having an intervening component, or may be directly connected to the other components without having an intervening component.
All terms (including technical or scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this disclosure belongs unless specifically defined otherwise. It will be further understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense unless expressly so defined herein.
Techniques, methods, and apparatus known to those of ordinary skill in the relevant art may not be discussed in detail, but are intended to be part of the specification where appropriate.
As shown in fig. 1 and fig. 2, the system for collating multidimensional data provided in this embodiment includes:
the source bill analysis module 1 is used for checking data of the business bill from the dimensionality of the source bill after the business is finished so as to check the data on the final business bill by analyzing the data on the source bill;
the process flow analysis module 2 is used for carrying out data check on the process bills corresponding to each business process in the business generation process;
and the path multipoint comparison and analysis module 3 is used for simulating each bill possibly appearing in the service generation process before the service starts, and comparing and analyzing the simulation result and the actual process data in the service generation process.
The source bill analysis module 1 comprises a source bill tracing unit, a data processing unit and a source single dimension analysis unit, wherein:
the source receipt tracing unit is used for tracing all source receipts corresponding to the final business receipt according to the final business receipt;
the data processing unit is used for processing and summarizing data of all traced source documents;
the source single-dimension analysis unit is used for comparing the data collected by the data processing unit with the data corresponding to the final business document, and if the deviation of the data collected by the data processing unit and the data corresponding to the final business document exceeds a first preset threshold (for example, is +/-5%), the final business document is abnormal.
The source sheet analysis module 1 performs analysis after the fact. As shown in fig. 2, in the source document 001, the number of the materials a is 30, and the number of the materials B is 12; in the source document 002, the amount of the material a is 15, and the amount of the material B is 18. According to the normal process flow, 4 manufacturing processes are required, 30 finished products should be produced, and the number of finished products in the final business document a should be 30. The source document analysis module 1 can check the manufactured product quantity of the final business document a by analyzing the quantity on the source document. If the two numbers are not right, the result is abnormal.
Further, the process flow analysis module 2 includes a service node definition unit, a process data conversion unit and a process data analysis unit, wherein:
the service node definition unit is used for defining service nodes in the service generation process according to a preset rule;
the process data conversion unit is used for determining data conversion rules of the data to be analyzed at each service node;
and the process data analysis unit is used for analyzing whether the business documents generated in each business process are abnormal or not according to the data conversion rule.
Specifically, the preset rule includes that a node where data to be analyzed changes in a service generation process is used as a service node in the service generation process. For example, a node which is to track the amount of the material during the service process and may change the amount of the material is defined as a service node; for example, if the material quantity is not changed by the process, the process is considered not to be a service node; for another example, a defect may be generated in the process, the amount of the material may be changed, and the node may be defined as a service node.
The service nodes defined by the service node definition unit comprise quantity conversion, quantity splitting, price discount and manual adjustment. The data to be analyzed includes the number of single materials, unit price of the single materials, the number of final finished products, unit price of the final finished products, and total price of the final finished products. It should be noted that, the data to be analyzed in the present invention is not particularly limited.
The process flow analysis module 2 analyzes in the same thing, as shown in fig. 2, the source document 001 and the source document 002 are still taken as an example for explanation, the manufacturing process is totally divided into 4 steps (material conversion, quantity splitting, price discount, manual adjustment), in the 4 business processes, after the first business process (material conversion), the material a is converted into the material a01, the material B is converted into the material B01, and the material conversion list 101 and the material conversion list 102 are correspondingly generated. According to the normal process, the conversion ratio of the material A to the material A01 is assumed to be 1: 3, the conversion ratio of the material B to the material B01 is 1: 4, the number of the material a01 in the material conversion unit 101 should be 135(45 × 3), and the number of the material B01 in the material conversion unit 102 should be 120 (30 × 4). The process flow analysis module 2 can check whether an abnormality occurs in the process by analyzing the number on the process document. The analysis process in other steps in the manufacturing process is similar to this, and is not described in detail here.
In specific implementation, a user can define a plurality of process document conversion nodes through which a business document passes according to business requirements; meanwhile, the data comparison algorithm of each document conversion node can be customized, so that the monitoring of the data conversion form in the process is enhanced.
Furthermore, the path multipoint comparison and analysis module 3 includes a circulation path analysis unit, a document simulation unit and a path multipoint analysis unit, wherein:
the flow path analysis unit is used for analyzing the flow path of the business bill based on each business process according to the preset business to obtain the flow path of the data corresponding to each material in the business generation process;
the bill simulation unit is used for simulating all bills corresponding to each service node on a service bill circulation path;
the path multipoint analysis unit is used for comparing a bill simulation result of the bill simulation unit with actual process data in a service occurrence process, and if a deviation between the bill simulation result and the actual process data exceeds a second preset threshold (for example, +/-5%), the actual process data is abnormal.
The path multipoint comparison and analysis module 3 analyzes in advance, as shown in fig. 2, it is still described by taking a source document 001 and a source document 002 as examples, and according to a normal manufacturing process, the path multipoint comparison and analysis module can analyze in advance, in a material conversion link, 2 documents should be generated, the quantity 135 of the material a01 and the quantity 120 of the material B01 are respectively recorded, then the business processes 2, 3 and 4 are continuously simulated, the quantity of the documents in each step is calculated in advance, and the quantity of the final business document a is calculated in advance. Through the path multipoint comparison and analysis module 3, a data path can be pre-calculated before manufacturing begins, comparison can be carried out on each service node, and abnormal problems in production can be discovered at any time.
It can be understood by those skilled in the art that the specific implementation procedures of the source single analysis module 1, the process flow analysis module 2 and the path multipoint comparison analysis module 3 can be implemented by Java, Python and other programming languages.
The multi-dimensional data checking system provided by the embodiment of the invention checks the service data from different dimensions through the source single analysis module, the process flow analysis module and the path multi-point comparison analysis module, and can achieve the effects of high efficiency, low error rate and high detection rate; various types of business document data check are supported; data checking of business documents after complex circulation flows is supported; the comparison between the preset service path simulation and the actual service operation result is supported; supporting multi-type and self-defined process nodes and a self-defined node data comparison algorithm; the functions of self-defined analysis results, log inspection and the like can be expanded and supported; the method can solve the problems of low manual accounting efficiency and high error rate and the problem that the program accounting algorithm cannot detect actual service errors due to homology.
Thus, various embodiments of the present disclosure have been described in detail. Some details well known in the art have not been described in order to avoid obscuring the concepts of the present disclosure. It will be fully apparent to those skilled in the art from the foregoing description how to practice the presently disclosed embodiments.
Although some specific embodiments of the present disclosure have been described in detail by way of example, it should be understood by those skilled in the art that the foregoing examples are for purposes of illustration only and are not intended to limit the scope of the present disclosure. It will be understood by those skilled in the art that various changes may be made and equivalents may be substituted for elements thereof without departing from the scope and spirit of the present disclosure. The scope of the present disclosure is defined by the appended claims.
Claims (7)
1. A system for collation of multidimensional data, comprising:
the source bill analysis module is used for checking data of the business bill from the dimensionality of the source bill after the business is finished so as to check the data on the final business bill by analyzing the data on the source bill;
the process flow analysis module is used for carrying out data check on the process bills corresponding to each business process in the business generation process;
and the path multipoint comparison and analysis module is used for simulating each bill possibly appearing in the service generation process before the service is started, and comparing and analyzing the simulation result and the actual process data in the service generation process.
2. The system for checking multidimensional data according to claim 1, wherein the source document analysis module includes a source document tracing unit, a data processing unit and a source document single-dimensional analysis unit, wherein:
the source receipt tracing unit is used for tracing all source receipts corresponding to the final business receipt according to the final business receipt;
the data processing unit is used for processing and summarizing data of all traced source documents;
and the source single-dimension analysis unit is used for comparing the data collected by the data processing unit with the data corresponding to the final service bill, and if the deviation of the data collected by the data processing unit and the data corresponding to the final service bill exceeds a first preset threshold value, the final service bill is abnormal.
3. The system for reconciling multidimensional data of claim 1 wherein the process flow analysis module comprises a service node definition unit, a process data conversion unit and a process data analysis unit, wherein:
the service node definition unit is used for defining service nodes in the service generation process according to a preset rule;
the process data conversion unit is used for determining data conversion rules of the data to be analyzed at each service node;
and the process data analysis unit is used for analyzing whether the business bill generated in each business process is abnormal or not according to the data conversion rule.
4. The system for collating multidimensional data according to claim 3, wherein said predetermined rule includes a node where data to be analyzed changes during a service occurrence process as a service node during the service occurrence process.
5. The system for reconciling multidimensional data of claim 3 wherein the service nodes defined by the service node definition unit comprise quantity conversion, quantity splitting, price discounting, and manual adjustment.
6. The system for reconciling multidimensional data as recited in claim 3, wherein the data to be analyzed comprises a quantity of a single material, a unit price of a single material, a quantity of a final finished product, a unit price of a final finished product, and a total price of a final finished product.
7. The system for reconciling multidimensional data of claim 1 wherein the path multipoint comparison analysis module comprises a circulation path analysis unit, a document simulation unit and a path multipoint analysis unit, wherein:
the flow path analysis unit is used for analyzing the flow path of the business bill based on each business process according to the preset business to obtain the flow path of the data corresponding to each material in the business generation process;
the bill simulation unit is used for simulating all bills corresponding to each service node on a service bill circulation path;
the path multipoint analysis unit is used for comparing a bill simulation result of the bill simulation unit with actual process data in a service occurrence process, and if the deviation of the bill simulation result and the actual process data exceeds a second preset threshold value, the actual process data is abnormal.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210707263.0A CN114943525A (en) | 2022-06-21 | 2022-06-21 | Multi-dimensional data checking system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202210707263.0A CN114943525A (en) | 2022-06-21 | 2022-06-21 | Multi-dimensional data checking system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114943525A true CN114943525A (en) | 2022-08-26 |
Family
ID=82910672
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202210707263.0A Pending CN114943525A (en) | 2022-06-21 | 2022-06-21 | Multi-dimensional data checking system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114943525A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117216593A (en) * | 2023-11-07 | 2023-12-12 | 青岛港国际股份有限公司 | Automatic inventory system and inventory method for assets |
-
2022
- 2022-06-21 CN CN202210707263.0A patent/CN114943525A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117216593A (en) * | 2023-11-07 | 2023-12-12 | 青岛港国际股份有限公司 | Automatic inventory system and inventory method for assets |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108664010A (en) | Generating set fault data prediction technique, device and computer equipment | |
| CN111177655B (en) | Data processing method and device and electronic equipment | |
| CN102073912A (en) | Data quality control method, device and system | |
| CN103366123A (en) | Software risk assessment method based on defect analysis | |
| CN113297051B (en) | Log analysis processing method and device | |
| EP3690658B1 (en) | Method for detecting repair-necessary motherboards and device using the method | |
| CN114943525A (en) | Multi-dimensional data checking system | |
| CN112685324A (en) | Method and system for generating test scheme | |
| Beller et al. | The last line effect | |
| Al-Sabbagh et al. | Selective regression testing based on big data: comparing feature extraction techniques | |
| CN113051180A (en) | Test task monitoring method, device, equipment and storage medium | |
| CN102103539A (en) | Z-specification-based test case generating method | |
| CN116303380B (en) | Data quality checking method, equipment and medium in monitoring service | |
| CN106569944A (en) | Constraint-tree-based onboard software test data analysis method | |
| CN109359748A (en) | Management method, terminal and the computer readable storage medium of Maintenance plan | |
| CN111179077B (en) | Stock abnormal transaction identification method and system | |
| JP2008198123A (en) | Fault detection system and fault detection program | |
| CN114926008A (en) | Data quality evaluation method and system | |
| CN113255096A (en) | High-loss line abnormal distribution area positioning method and system based on forward stepwise regression | |
| CN114139853A (en) | Steel structure product list processing method and device based on big data | |
| CN111382059A (en) | Code quality evaluation method and system | |
| CN116431474B (en) | Security configuration item constraint extraction method of program source code based on static analysis | |
| CN113434408B (en) | Unit test case sequencing method based on test prediction | |
| CN112035364B (en) | Function test result evaluation method and device | |
| Sand et al. | Holistic production analysis for actuator manufacturing using data mining |
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 | ||
| CB03 | Change of inventor or designer information | ||
| CB03 | Change of inventor or designer information |
Inventor after: Wang Jiashou Inventor after: Yu Zhongjiang Inventor after: Ni Chaoxia Inventor after: Li Xinming Inventor after: Li Ligang Inventor after: Li Zhongtai Inventor after: Luo Hui Inventor after: Yang Shaoping Inventor after: Gan Zhixiong Inventor after: Yu Yang Inventor after: Tang Jun Inventor after: Li Chun Inventor after: Liu Qiyan Inventor after: Yang Chuanzhen Inventor after: Tao Gang Inventor after: Yang Fan Inventor after: Zhao Guiyan Inventor after: Chen Xiaowei Inventor before: Wang Jiashou Inventor before: Yu Zhongjiang Inventor before: Ni Chaoxia Inventor before: Li Xinming Inventor before: Li Ligang Inventor before: Li Zhongtai Inventor before: Luo Hui Inventor before: Yang Shaoping Inventor before: Gan Zhixiong Inventor before: Yu Yang Inventor before: Tang Jun Inventor before: Li Chun Inventor before: Liu Qiyan Inventor before: Yang Chuanzhen Inventor before: Tao Gang Inventor before: Yang Fan Inventor before: Zhao Yanmei Inventor before: Chen Xiaowei |