Control method and device of data system, readable storage medium and data system
By applying preset and custom inspection rules to the enterprise database, the problems of time-consuming and inefficient monitoring of business and financial data have been solved, thereby improving the efficiency of data auditing and accelerating the enterprise IPO process.
Patent Information
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2022-09-20
- Publication Date
- 2026-03-17
AI Technical Summary
During a company's IPO process, monitoring business and financial data is time-consuming, inefficient, and labor-intensive, and is prone to errors and confusion, which affects the company's progress.
By applying preset and custom inspection rules to the target database, data credentials are checked and stored to ensure their validity, prevent the storage of data that does not conform to the rules, and provide data adjustment schemes for completion and data matching processing to ensure data accuracy and consistency.
It improved data review efficiency, reduced human resources and costs, and ensured data consistency and facilitated the rapid progress of the company's IPO process.
Smart Images

Figure CN115907631B_ABST
Abstract
Description
Technical Field
[0001] This invention relates to the field of data processing technology, and more specifically, to a control method, apparatus, readable storage medium, and data system for a data system. Background Technology
[0002] The IPO (Initial Public Offering) process requires the collection and monitoring of a company's business and financial data. However, the monitoring of this data is labor-intensive, time-consuming, inefficient, and costly. It can also lead to data errors, causing internal data inconsistencies and delays in the IPO process. Summary of the Invention
[0003] The present invention aims to solve at least one of the technical problems existing in the prior art or related art.
[0004] Therefore, the first aspect of the present invention is to provide a control method for a data system.
[0005] A second aspect of the present invention is to provide a control device for a data system.
[0006] A third aspect of the present invention is to provide a control device for a data system.
[0007] A fourth aspect of the present invention is to provide a readable storage medium.
[0008] The fifth aspect of the present invention is to provide a data system.
[0009] In view of this, according to a first aspect of the present invention, a control device for a data system is proposed. The data system includes a target database, and the control method for the data system includes: when a first data credential is stored in the target database, determining a first inspection result of the first data credential according to a preset inspection rule; when the first inspection result meets a first preset condition, determining a second inspection result of the first data credential according to a first custom inspection rule; and when the second inspection result meets a second preset condition, storing the first data credential as a target data credential.
[0010] The execution subject of the data system control method provided by this invention can be a control device, or it can be determined according to actual usage requirements, and no specific limitation is made here. To more clearly describe the data system control method provided by this invention, the following description uses a control device as the execution subject.
[0011] This technical solution provides a data system control method for an enterprise's business and financial data system. The data system includes a target database, which is the enterprise's business and financial database and is used as a repository for storing and managing the enterprise's internal business and financial data.
[0012] Furthermore, the control device performs data query processing on the target database to determine that the target database stores a first data credential, wherein the first data credential is a data credential imported into the target database from an external data source.
[0013] Furthermore, the control device checks the validity of the first data credential according to the preset check rules and obtains the first check result of the first data credential. The first check result is the result of checking the first data credential according to the preset check rules. It should be noted that the preset check rules are pre-stored check rules, which include a number of common incompatible monitoring rules. The first check result can indicate whether the first data credential conforms to the preset check rules.
[0014] Furthermore, when the control device determines that the first inspection result meets the first preset condition, it indicates that the first inspection result is a valid result, and thus indicates that the first data certificate meets the preset inspection rules, wherein the first preset condition specifically means that the first inspection result is a valid result.
[0015] Furthermore, if the first inspection result meets the first preset condition, the control device checks the validity of the first data credential according to the first custom inspection rule and obtains the second inspection result of the first data credential. The second inspection result is the result of checking the first data credential according to the first custom inspection rule. It should be noted that the first custom inspection rule is a user-defined inspection rule, and the second inspection result can indicate whether the first data credential meets the first custom inspection rule.
[0016] Furthermore, when the control device determines that the second inspection result meets the second preset condition, it indicates that the second inspection result is a valid result, and thus indicates that the second data certificate meets the first custom inspection rule, wherein the second preset condition specifically means that the second inspection result is a valid result.
[0017] Furthermore, if the second inspection result meets the second preset condition, the control device can determine that the first data certificate is a valid data certificate, indicating that the first data certificate needs to be retained, and store the first data certificate as the target data certificate in the target database, wherein the target data certificate is the data certificate that needs to be retained.
[0018] The data system control method in this technical solution checks the first data voucher using preset inspection rules and a first custom inspection rule, and then stores the first data voucher as the target data voucher. Compared with post-querying of the first data voucher, the data system control method provided by this technical solution can avoid non-compliant business in advance, reduce the work of modifying the target data voucher later, save a lot of human resources, improve the review efficiency of the first data voucher, and at the same time, ensure the consistency of data in the target database, avoiding the problem of needing a lot of effort to verify data inconsistencies caused by data modification, thereby ensuring the rapid progress of the company's IPO process.
[0019] The control method for the data system according to the present invention may further include the following additional technical features:
[0020] In the above technical solution, the control method of the data system further includes: generating a second data credential according to a preset inspection rule when the target database does not store the first data credential; determining a third inspection result of the second data credential according to a second custom inspection rule; and storing the second data credential as the target data credential when the third inspection result meets the third preset condition.
[0021] In this technical solution, if the control device determines that the first data credential is not stored in the target database, the control device can control the data system to create a second data credential according to preset inspection rules. The second data credential is a newly generated data credential. It should be noted that creating the second data credential according to the preset inspection rules ensures that the second data credential conforms to the preset inspection rules.
[0022] Furthermore, the control device checks the validity of the second data credential according to the second custom check rule and obtains a third check result. The third check result is the result of checking the second data credential according to the second custom check rule. It should be noted that the second custom check rule is a check rule defined by other users, and the third check result can indicate whether the third data credential conforms to the second custom check rule.
[0023] Furthermore, if the third inspection result meets the third preset condition, the control device can determine that the second data credential is a valid data credential, indicating that the second data credential needs to be retained, and store the second data credential as the target data credential in the target database.
[0024] The data system control method in this technical solution checks the first data certificate through a second custom check rule, and then stores the second data certificate as the target data certificate. This ensures that the newly created second data certificate conforms to the second custom check rule, avoids the problem of subsequent data modification of the second data certificate, saves a lot of manpower costs, and improves the review efficiency of the second data certificate.
[0025] In the above technical solution, the control method of the data system further includes: obtaining a data list in the target database, the data list including multiple data indicators, determining the target data indicator among the multiple data indicators; and generating a first data adjustment scheme for the data list when the value of the target data indicator is less than a preset value.
[0026] In this technical solution, the target database can store a data list, which is a form including multiple data indicators. After the target data indicator is selected from the multiple data indicators, the control device can confirm the degree of completion of the target data indicator.
[0027] Specifically, when the value of the target data indicator is less than the preset value, it means that the target data indicator has not been completed and needs to be improved. When the value of the target data indicator is greater than or greater than the preset value, it means that the target data indicator has been completed. The preset value is a pre-set indicator value.
[0028] Furthermore, when the value of the target data indicator is less than the preset value, the control device can generate a first data adjustment scheme for the data list. The target data indicator in the data list can be adjusted and improved through the first data adjustment scheme, wherein the first data adjustment scheme is an adjustment scheme for the target data indicator.
[0029] The data system control method in this technical solution determines the target data indicators in the data list and provides a first data adjustment scheme when the value of the target data indicator is less than the preset value. This ensures the completion of the target data indicators in the data list, avoids the problem of affecting the company's IPO process due to the failure to complete the target data indicators, and improves the company's data adjustment efficiency.
[0030] In the above technical solution, the control method of the data system also includes: determining the completion degree of the data list based on multiple data indicators; and generating a second data adjustment scheme for the data list based on the completion degree of the data list.
[0031] In this technical solution, the control device can determine the completion level of a data list based on the completion status of multiple data indicators, where the completion level refers to the degree of completion of the data list. Specifically, the data list includes multiple data indicators, and the control device can confirm the completion level of the data list by identifying the completed data indicators among these multiple data indicators.
[0032] Furthermore, the control device can generate a second data adjustment scheme for the data list based on the completion level of the data list. The completion level of the data list can be adjusted and improved through the second data adjustment scheme, which is an adjustment scheme for the completion level of the data list.
[0033] The data system control method in this technical solution ensures the overall completeness of the data list by determining its completion level and providing a second data adjustment plan based on that level. This avoids the problem of the data list not meeting the standard and affecting the company's IPO process, while also improving the efficiency of the company's business rectification.
[0034] In the above technical solution, the control method of the data system also includes: acquiring data charts and data templates from the target database; performing data matching processing on the data charts and data templates to identify abnormal data in the data charts.
[0035] In this technical solution, the target database can store data charts and data templates, and the control device can acquire the data charts and data templates in the target database. The data charts are charts that include multiple types of data, and the data templates are data icon templates that include standard data.
[0036] Furthermore, the data charts include normal data and abnormal data. The control device performs data matching processing on the data charts according to the data template, checks the accuracy of the data in the data charts, and obtains the abnormal data in the data charts, where abnormal data is data containing errors.
[0037] Furthermore, the control device can adjust abnormal data in the data charts, modifying the abnormal data into normal data.
[0038] The data system control method in this technical solution performs data matching processing on data charts based on data templates to obtain abnormal data in the data charts, ensuring the integrity and accuracy of the data charts, reducing the workload of manual verification of data in the data charts, and improving the data verification efficiency of the data charts.
[0039] In this technical solution, the control method of the data system also includes: connecting the target database and the external database through an external data interface to obtain data from the external database; and storing the data from the external database in the target database.
[0040] In this technical solution, the data system is equipped with an external interface. The control device connects the target database and the external database through the external interface. The external database is the database of other companies.
[0041] Furthermore, after the target database and the external database are connected, the control device can read data from the external database and store the data from the external database in the target database.
[0042] The data system control method in this technical solution connects the target database and the external database through an external interface, and stores the data from the external database in the target database. This ensures the accuracy of the associated transaction data, reduces the time required to collect external transaction data, saves a significant amount of labor costs, and improves the efficiency of acquiring external data.
[0043] According to a second aspect of the present invention, a control device for a data system is provided. The data system includes a target database. The control device includes: a first processing module, configured to determine a first inspection result of the first data credential according to a preset inspection rule when the database stores the first data credential; the first processing module is further configured to determine a second inspection result of the first data credential according to a first custom inspection rule when the first inspection result meets a first preset condition; and the first processing module is further configured to store the first data credential as a target data credential when the second inspection result meets a second preset condition.
[0044] This technical solution provides a data system control method for an enterprise's business and financial data system. The data system includes a target database, which is the enterprise's business and financial database and is used as a repository for storing and managing the enterprise's internal business and financial data.
[0045] Furthermore, the first processing module performs data query processing on the target database to determine that the target database stores a first data credential, wherein the first data credential is a data credential imported from an external data source into the target database.
[0046] Furthermore, the first processing module checks the validity of the first data credential according to the preset check rules and obtains the first check result of the first data credential. The first check result is the result of checking the first data credential according to the preset check rules. It should be noted that the preset check rules are pre-stored check rules, which include a number of common incompatible monitoring rules. The first check result can indicate whether the first data credential conforms to the preset check rules.
[0047] Furthermore, when the first processing module determines that the first inspection result meets the first preset condition, it indicates that the first inspection result is a valid result, and thus indicates that the first data voucher meets the preset inspection rules. Specifically, the first preset condition is that the first inspection result is a valid result.
[0048] Furthermore, if the first check result meets the first preset condition, the first processing module checks the validity of the first data credential according to the first custom check rule and obtains the second check result of the first data credential. The second check result is the result of checking the first data credential according to the first custom check rule. It should be noted that the first custom check rule is a user-defined check rule, and the second check result can indicate whether the first data credential meets the first custom check rule.
[0049] Furthermore, when the first processing module determines that the second inspection result meets the second preset condition, it indicates that the second inspection result is a valid result, and thus indicates that the second data voucher meets the first custom inspection rule. Specifically, the second preset condition is that the second inspection result is a valid result.
[0050] Furthermore, if the second inspection result meets the second preset conditions, the first processing module can determine that the first data credential is a valid data credential, indicating that the first data credential needs to be retained, and store the first data credential as the target data credential in the target database, wherein the target data credential is the data credential that needs to be retained.
[0051] The control device of the data system in this technical solution checks the first data certificate through preset inspection rules and a first custom inspection rule, and then stores the first data certificate as the target data certificate. Compared with the subsequent query of the first data certificate, the control method of the data system provided in this embodiment can avoid business that does not conform to the rules in advance, reduce the work of modifying the target data certificate in the future, save a lot of human resources, improve the review efficiency of the first data certificate, and at the same time, ensure the consistency of data in the target database, avoid the problem of needing a lot of effort to verify data inconsistencies caused by data modification, and thus ensure the rapid progress of the company's IPO process.
[0052] According to a third aspect of the present invention, a control device for a data system is provided, comprising a processor and a memory, wherein the memory stores a program or instructions, which, when executed by the processor, implement the steps of the data system control method as described in any of the above-described technical solutions. Therefore, this control device possesses all the beneficial effects of the data system control method in any of the above-described technical solutions, which will not be elaborated further here.
[0053] According to a fourth aspect of the present invention, a readable storage medium is provided on which a program or instructions are stored, which, when executed by a processor, implement the control method of the data system as described in any of the above-described technical solutions. Therefore, this readable storage medium possesses all the beneficial effects of the control method of the data system in any of the above-described technical solutions, which will not be elaborated further here.
[0054] According to a fifth aspect of the present invention, a data system is provided, comprising: a control device for a data system as defined in the second aspect above, or a control device for a data system as defined in the third aspect above, and / or a readable storage medium as defined in the fourth aspect above, thus having all the beneficial technical effects of the control device for a data system as defined in the second aspect above, or the control device for a data system as defined in the third aspect above, or the readable storage medium as defined in the fourth aspect above, which will not be elaborated further here.
[0055] Additional aspects and advantages of the invention will become apparent in the following description or may be learned by practice of the invention. Attached Figure Description
[0056] The above and / or additional aspects and advantages of the present invention will become apparent and readily understood from the description of the embodiments taken in conjunction with the following drawings, in which:
[0057] Figure 1 One of the flowcharts of the control method for the data system in the first embodiment of the present invention is shown;
[0058] Figure 2 A second schematic flowchart of the control method for the data system in the first embodiment of the present invention is shown;
[0059] Figure 3 A third schematic flowchart of the control method for the data system in the first embodiment of the present invention is shown;
[0060] Figure 4 The fourth schematic flowchart of the control method of the data system in the first embodiment of the present invention is shown;
[0061] Figure 5 Fifth of the flowcharts illustrating the control method of the data system in the first embodiment of the present invention is shown;
[0062] Figure 6 A flowchart of the control method for the data system in the first embodiment of the present invention is shown in diagram six.
[0063] Figure 7 One of the structural block diagrams of the control device of the data system according to a second embodiment of the present invention is shown;
[0064] Figure 8 A schematic diagram of the credential review process for the control device of the data system in a second embodiment of the present invention is shown;
[0065] Figure 9 A second structural block diagram of the control device for the data system in the second embodiment of the present invention is shown;
[0066] Figure 10 A schematic diagram of the intelligent analysis of the control device of the data system in the second embodiment of the present invention is shown;
[0067] Figure 11 A schematic diagram of intelligent data analysis of the control device of the data system in the second embodiment of the present invention is shown;
[0068] Figure 12 A schematic diagram of related transactions of the control device of the data system in the second embodiment of the present invention is shown;
[0069] Figure 13 A structural block diagram of the control device for the data system in the third embodiment of the present invention is shown;
[0070] Figure 14 A block diagram of the data system according to the fifth embodiment of the present invention is shown. Detailed Implementation
[0071] To better understand the above-mentioned objectives, features, and advantages of the present invention, the present invention will be further described in detail below with reference to the accompanying drawings and specific embodiments. It should be noted that, unless otherwise specified, the embodiments of the present invention and the features thereof can be combined with each other.
[0072] Many specific details are set forth in the following description in order to provide a full understanding of the invention. However, the invention may also be practiced in other ways different from those described herein, and therefore the scope of protection of the invention is not limited to the specific embodiments disclosed below.
[0073] The following is combined Figures 1 to 14 The control method, apparatus, readable storage medium, and data system of the data system provided in this application will be described in detail through specific embodiments and application scenarios.
[0074] The execution subject of the data system control method provided by this invention can be a control device, or it can be determined according to actual usage requirements, and no specific limitation is made here. To more clearly describe the data system control method provided by this invention, the following description uses a control device as the execution subject.
[0075] Example 1:
[0076] like Figure 1 As shown, the first embodiment of the present invention provides a control method for a data system, the data system including a target database, and the control method for the data system includes:
[0077] Step 102: If the first data credential is stored in the target database, determine the first check result of the first data credential according to the preset check rules;
[0078] Step 104: If the first inspection result meets the first preset condition, determine the second inspection result of the first data voucher according to the first custom inspection rule;
[0079] Step 106: If the second inspection result meets the second preset conditions, store the first data certificate as the target data certificate.
[0080] This embodiment provides a control method for a data system used in an enterprise's business and financial data system. The data system includes a target database, which is the enterprise's business and financial database and is used as a repository for storing and managing the enterprise's internal business and financial data.
[0081] Furthermore, the control device performs data query processing on the target database to determine that the target database stores a first data credential, wherein the first data credential is a data credential imported into the target database from an external data source, and the external data source is a data source outside the data system.
[0082] Furthermore, the control device checks the validity of the first data credential according to the preset check rules and obtains the first check result of the first data credential. The first check result is the result of checking the first data credential according to the preset check rules. It should be noted that the preset check rules are pre-stored check rules, which include a number of common incompatible monitoring rules. The first check result can indicate whether the first data credential conforms to the preset check rules.
[0083] Furthermore, when the control device determines that the first inspection result meets the first preset condition, it indicates that the first inspection result is a valid result, and thus indicates that the first data certificate meets the preset inspection rules, wherein the first preset condition specifically means that the first inspection result is a valid result.
[0084] Furthermore, if the first inspection result meets the first preset condition, the control device checks the validity of the first data credential according to the first custom inspection rule and obtains the second inspection result of the first data credential. The second inspection result is the result of checking the first data credential according to the first custom inspection rule. It should be noted that the first custom inspection rule is a user-defined inspection rule, and the second inspection result can indicate whether the first data credential meets the first custom inspection rule.
[0085] Furthermore, when the control device determines that the second inspection result meets the second preset condition, it indicates that the second inspection result is a valid result, and thus indicates that the second data certificate meets the first custom inspection rule, wherein the second preset condition specifically means that the second inspection result is a valid result.
[0086] Furthermore, if the second inspection result meets the second preset condition, the control device can determine that the first data certificate is a valid data certificate, indicating that the first data certificate needs to be retained, and store the first data certificate as the target data certificate in the target database, wherein the target data certificate is the data certificate that needs to be retained.
[0087] In some embodiments, the first data credential may specifically be a loan slip, expense report, transaction record, or other credential. The preset check rule may specifically be an incompatibility monitoring rule for an enterprise's IPO (Initial Public Offering). When the first data credential does not conform to the preset check rule, it indicates that the first data credential is invalid, and the control device will not store the first data credential in the target database.
[0088] In some other embodiments, the first custom check rule may specifically be that the user who saves the first data credential and the user who reviews it cannot be the same user. When the control device determines that the user who saves the first data credential and the user who reviews it are the same user, it indicates that the first data credential is invalid and the control device will not store the first data credential in the target database.
[0089] The data system control method in this embodiment checks the first data voucher using preset inspection rules and a first custom inspection rule, and then stores the first data voucher as the target data voucher. Compared with the subsequent query of the first data voucher, the data system control method provided in this embodiment can avoid non-compliant business in advance, reduce the work of modifying the target data voucher later, save a lot of human resources, improve the review efficiency of the first data voucher, and at the same time ensure the consistency of data in the target database, avoiding the problem of needing a lot of effort to verify data inconsistencies caused by data modification, thereby ensuring the rapid progress of the company's IPO process.
[0090] like Figure 2As shown, in any of the above embodiments, the control method of the data system includes:
[0091] Step 202: If the target database does not store the first data credential, generate the second data credential according to the preset check rules;
[0092] Step 204: Determine the third inspection result of the second data credential based on the second custom inspection rule;
[0093] Step 206: If the third inspection result meets the third preset condition, store the second data voucher as the target data voucher.
[0094] In this embodiment, if the control device determines that the first data credential is not stored in the target database, the control device can control the data system to create a second data credential according to a preset inspection rule. The second data credential is a newly generated data credential. It should be noted that creating the second data credential according to the preset inspection rule ensures that the second data credential conforms to the preset inspection rule.
[0095] Furthermore, the control device checks the validity of the second data credential according to the second custom check rule and obtains a third check result. The third check result is the result of checking the second data credential according to the second custom check rule. It should be noted that the second custom check rule is a check rule defined by other users, and the third check result can indicate whether the third data credential conforms to the second custom check rule.
[0096] Furthermore, if the third inspection result meets the third preset condition, the control device can determine that the second data credential is a valid data credential, indicating that the second data credential needs to be retained, and store the second data credential as the target data credential in the target database.
[0097] The control method of the data system in this embodiment checks the first data certificate through a second custom check rule, and then stores the second data certificate as the target data certificate. This ensures that the newly created second data certificate conforms to the second custom check rule, avoids the problem of subsequent data modification of the second data certificate, saves a lot of manpower costs, and improves the review efficiency of the second data certificate.
[0098] like Figure 3 As shown, in any of the above embodiments, the control method of the data system includes:
[0099] Step 302: Obtain the data list in the target database. The data list includes multiple data indicators. Determine the target data indicator among the multiple data indicators.
[0100] Step 304: If the value of the target data indicator is less than the preset value, generate the first data adjustment plan for the data list.
[0101] In this embodiment, the target database can store a data list, which is a form including multiple data indicators. After the target data indicator is selected from the multiple data indicators, the control device can confirm the completion level of the target data indicator.
[0102] Specifically, when the value of the target data indicator is less than the preset value, it means that the target data indicator has not been completed and needs to be improved. When the value of the target data indicator is greater than or greater than the preset value, it means that the target data indicator has been completed. The preset value is a pre-set indicator value.
[0103] Furthermore, when the value of the target data indicator is less than the preset value, the control device can generate a first data adjustment scheme for the data list. The target data indicator in the data list can be adjusted and improved through the first data adjustment scheme, wherein the first data adjustment scheme is an adjustment scheme for the target data indicator.
[0104] In some embodiments, the preset value may be a standard value for the audit points of a company's IPO.
[0105] The data system control method in this embodiment determines the target data indicators in the data list and provides a first data adjustment scheme when the value of the target data indicator is less than the preset value. This ensures the completion of the target data indicators in the data list, avoids the problem of affecting the company's IPO process due to the failure to complete the target data indicators, and improves the company's data adjustment efficiency.
[0106] like Figure 4 As shown, in any of the above embodiments, the control method of the data system includes:
[0107] Step 402: Obtain the data list in the target database. The data list includes multiple data indicators. Determine the target data indicator among the multiple data indicators.
[0108] Step 404: Determine the completion rate of the data list based on multiple data indicators;
[0109] Step 406: Based on the completion status of the data list, generate a second data adjustment plan for the data list.
[0110] In this embodiment, the control device can determine the completion level of the data list based on the completion status of multiple data indicators, wherein the completion level refers to the degree of completion of the data list. Specifically, the data list includes multiple data indicators, and the control device can confirm the completion level of the data list by identifying the completed data indicators among the multiple data indicators.
[0111] Furthermore, the control device can generate a second data adjustment scheme for the data list based on the completion level of the data list. The completion level of the data list can be adjusted and improved through the second data adjustment scheme, which is an adjustment scheme for the completion level of the data list.
[0112] In some embodiments, the control device may determine that the completion rate of the data list is 100% when it determines that multiple data indicators of the data list have been completed.
[0113] The data system control method in this embodiment determines the completeness of the data list and provides a second data adjustment scheme based on the completeness of the data list, thereby ensuring the overall completeness of the data list and avoiding the problem of affecting the company's IPO process due to the incompleteness of the data list. At the same time, it improves the efficiency of the company's business rectification.
[0114] like Figure 5 As shown, in any of the above embodiments, the control method of the data system includes:
[0115] Step 502: Obtain data charts and data templates from the target database;
[0116] Step 504: Perform data matching processing on the data chart and data template to identify abnormal data in the data chart.
[0117] In this embodiment, the target database can store data charts and data templates, and the control device can acquire the data charts and data templates in the target database. The data charts are charts that include multiple types of data, and the data templates are data icon templates that include standard data.
[0118] Furthermore, the data charts include normal data and abnormal data. The control device performs data matching processing on the data charts according to the data template, checks the accuracy of the data in the data charts, and obtains the abnormal data in the data charts, where abnormal data is data containing errors.
[0119] Furthermore, the control device can adjust abnormal data in the data charts, modifying the abnormal data into normal data.
[0120] In some embodiments, data charts may specifically be accounting statements, abnormal data may specifically be audit exception entries in accounting statements, and data templates may specifically be standard accounting statement templates.
[0121] In some other embodiments, the control device can display abnormal data in data charts and trace the source of the abnormal data.
[0122] The control method of the data system in this embodiment performs data matching processing on the data charts according to the data template, obtains abnormal data in the data charts, ensures the integrity and accuracy of the data charts, reduces the workload of manual verification of data in the data charts, and improves the data verification efficiency of the data charts.
[0123] like Figure 6 As shown, in any of the above embodiments, the control method of the data system includes:
[0124] Step 602: Connect the target database and the external database through the external data interface to obtain data from the external database;
[0125] Step 604: Store the data from the external database in the target database.
[0126] In this embodiment, the data system is equipped with an external interface, and the control device connects the target database and the external database through the external interface. The external database is the database of other companies.
[0127] Furthermore, after the target database and the external database are connected, the control device can read data from the external database and store the data from the external database in the target database.
[0128] In some embodiments, the external database may specifically be the database of an affiliated enterprise, wherein the affiliated enterprise may specifically be a subsidiary of the same group or a cooperative company with which it has a transaction relationship.
[0129] The control method of the data system in this embodiment connects the target database and the external database through an external interface, and stores the data of the external database in the target database. This ensures the accuracy of the associated transaction data, reduces the collection time for obtaining external transaction data, saves a lot of labor costs, and improves the efficiency of obtaining external data.
[0130] Example 2:
[0131] like Figure 7 As shown, in a second embodiment of the present invention, a control device for a data system is provided. The control device 700 for the data system includes:
[0132] The first processing module 702 is used to determine the first inspection result of the first data voucher according to preset inspection rules when the first data voucher is stored in the database.
[0133] The first processing module 702 is further configured to determine the second inspection result of the first data credential according to the first custom inspection rule if the first inspection result meets the first preset conditions.
[0134] The first processing module 702 is further configured to store the first data voucher as the target data voucher if the second inspection result meets the second preset conditions.
[0135] This embodiment provides a control method for a data system used in an enterprise's business and financial data system. The data system includes a target database, which is the enterprise's business and financial database and is used as a repository for storing and managing the enterprise's internal business and financial data.
[0136] Furthermore, the first processing module 702 performs data query processing on the target database to determine that the target database stores a first data credential, wherein the first data credential is a data credential imported from an external data source into the target database.
[0137] Furthermore, the first processing module 702 checks the validity of the first data credential according to the preset check rules and obtains the first check result of the first data credential. The first check result is the result of checking the first data credential according to the preset check rules. It should be noted that the preset check rules are pre-stored check rules, which include a number of common incompatible monitoring rules. The first check result can indicate whether the first data credential conforms to the preset check rules.
[0138] Furthermore, when the first processing module 702 determines that the first inspection result meets the first preset condition, it indicates that the first inspection result is a valid result, and thus indicates that the first data voucher meets the preset inspection rules, wherein the first preset condition specifically means that the first inspection result is a valid result.
[0139] Furthermore, if the first check result meets the first preset condition, the first processing module 702 checks the validity of the first data credential according to the first custom check rule and obtains the second check result of the first data credential. The second check result is the result of checking the first data credential according to the first custom check rule. It should be noted that the first custom check rule is a user-defined check rule, and the second check result can indicate whether the first data credential meets the first custom check rule.
[0140] Furthermore, when the first processing module 702 determines that the second inspection result meets the second preset condition, it indicates that the second inspection result is a valid result, and thus indicates that the second data voucher meets the first custom inspection rule, wherein the second preset condition specifically means that the second inspection result is a valid result.
[0141] Furthermore, if the second inspection result meets the second preset conditions, the first processing module 702 can determine that the first data credential is a valid data credential, indicating that the first data credential needs to be retained, and store the first data credential as the target data credential in the target database, wherein the target data credential is the data credential that needs to be retained.
[0142] In some embodiments, the first data credential may specifically be a loan slip, expense report, transaction record, or other credential. The preset check rule may specifically be an incompatibility monitoring rule for an enterprise's IPO (Initial Public Offering). When the first data credential does not conform to the preset check rule, it indicates that the first data credential is invalid, and the control device will not store the first data credential in the target database.
[0143] In some other embodiments, the first custom check rule may specifically be that the user who saves the first data credential and the user who reviews it cannot be the same user. When the control device determines that the user who saves the first data credential and the user who reviews it are the same user, it indicates that the first data credential is invalid and the control device will not store the first data credential in the target database.
[0144] In some other embodiments, the processing procedure of the first processing module 702 may be specifically as follows: Figure 8 The processing procedure shown is as follows: Specifically, the data system determines whether the IPO Assistant is started. The IPO Assistant is a terminal application. After the IPO Assistant is started, a first custom check rule is added. The first custom check rule can be specifically that the user who saves the first data credential and the user who reviews it cannot be the same user. The scheduling time of the first custom check rule is set. First, the data system performs an automatic check according to the preset check rule. After determining that the first data credential meets the preset check rule, the data system then checks the first data credential according to the first custom check rule. After determining that the first data credential meets the first custom check rule, the data system stores the first data credential.
[0145] In this embodiment, the control device of the data system checks the first data certificate using preset inspection rules and a first custom inspection rule, and then stores the first data certificate as the target data certificate. Compared with the subsequent query of the first data certificate, the control method of the data system provided in this embodiment can avoid non-compliant business in advance, reduce the work of modifying the target data certificate in the future, save a lot of human resources, improve the review efficiency of the first data certificate, and at the same time ensure the consistency of data in the target database, avoiding the problem of needing a lot of effort to verify data inconsistencies caused by data modification, thereby ensuring the rapid progress of the company's IPO process.
[0146] In any of the above embodiments, the control device 700 of the data system includes:
[0147] The first processing module 702 is used to generate a second data credential according to preset checking rules when the target database does not store the first data credential.
[0148] The first processing module 702 is also used to determine the third inspection result of the second data credential based on the second custom inspection rule;
[0149] The first processing module 702 is also used to store the second data voucher as the target data voucher if the third inspection result meets the third preset conditions.
[0150] In this embodiment, the processing procedure of the first processing module 702 can be specifically as follows: Figure 8 The processing procedure shown is as follows: the control data system creates a second data credential according to a preset inspection rule, and then checks the second data credential according to a second custom inspection rule to determine whether the user who saves the second data credential and the user who reviews it are the same user. If the user who saves the second data credential and the user who reviews it are not the same user, the second data credential is stored.
[0151] In this embodiment, the control device of the data system checks the first data certificate through a second custom check rule, and then stores the second data certificate as the target data certificate. This ensures that the newly created second data certificate conforms to the second custom check rule, avoids the problem of subsequent data modification of the second data certificate, saves a lot of manpower costs, and improves the review efficiency of the second data certificate.
[0152] like Figure 9 As shown, in any of the above embodiments, the control device 700 of the data system includes:
[0153] The second processing module 704 is used to obtain a data list in the target database, the data list includes multiple data indicators, and determine the target data indicator among the multiple data indicators.
[0154] The second processing module 704 is also used to generate a first data adjustment scheme for the data list when the value of the target data indicator is less than the preset value.
[0155] In this embodiment, the processing procedure of the second processing module 704 can be specifically as follows: Figure 10 The processing procedure shown is as follows: Specifically, the data list can be a self-inspection list, and multiple data indicators can be multiple optional items in the self-inspection list. The second processing module 704 can be used to select items to check after the data list is imported and pre-made. After the selection is completed, the second processing module 704 automatically generates a first data adjustment plan by comparing the completion status of the selected items with the pre-made IPO audit focus points. The first data adjustment plan can be specifically a rectification opinion. After confirming that the parameters are set to synchronous push, the first data adjustment plan is pushed to the data system.
[0156] In this embodiment, the control device of the data system determines the target data indicators in the data list and provides a first data adjustment scheme when the value of the target data indicator is less than the preset value. This ensures the completion of the target data indicators in the data list, avoids the problem of affecting the company's IPO process due to the failure to complete the target data indicators, and improves the company's data adjustment efficiency.
[0157] In any of the above embodiments, the control device 700 of the data system includes:
[0158] The second processing module 704 is used to determine the completion rate of the data list based on multiple data indicators;
[0159] The second processing module 704 is also used to generate a second data adjustment scheme for the data list based on the completion status of the data list.
[0160] In this embodiment, the processing procedure of the second processing module 704 can be specifically as follows: Figure 10 The processing procedure shown is as follows: Specifically, the data list can be a self-check list, and multiple data indicators can be multiple optional items in the self-check list. The second processing module 704 can be used to select items to check from the multiple optional items in the self-check list after the data list is imported and prefabricated. After the selection is completed, it is determined whether the selected items meet the requirements. After it is determined that the selected items meet the requirements, the completion rate is automatically calculated.
[0161] In this embodiment, the control device of the data system determines the completeness of the data list and provides a second data adjustment scheme based on the completeness of the data list, thereby ensuring the overall completeness of the data list and avoiding the problem of affecting the company's IPO process due to the incompleteness of the data list. At the same time, it improves the efficiency of the company's business rectification.
[0162] like Figure 9 As shown, in any of the above embodiments, the control device 700 of the data system includes:
[0163] The third processing module 706 is used to obtain data charts and data templates from the target database;
[0164] The third processing module 706 is also used to perform data matching processing on data charts and data templates to identify abnormal data in the data charts.
[0165] In this embodiment, the processing procedure of the third processing module 706 can be specifically as follows: Figure 11 The processing procedure shown specifically includes the third processing module 706, which comprises data sources, back-end management, and front-end functions. The data sources can obtain data from the financial module, such as accounts receivable, accounts payable, general ledger, expense reimbursement, and cash and bank data. The financial module is also connected to online banking payment and the bank-enterprise cloud. The front-end, namely the fund flow display platform, can display data such as marking abnormal funds, analyzing the composition of fund flows, marking large fund flows, monitoring results, and audit points and suggestions. The back-end management includes parameter settings and an intelligent analysis platform. The third processing module 706 can be used to extract data from the data source terminal, process the data in the back-end management, and then send it to the front-end for display. The front-end allows for penetration and tracing of data sources.
[0166] In this embodiment, the control device of the data system performs data matching processing on the data charts according to the data template, obtains abnormal data in the data charts, ensures the integrity and accuracy of the data charts, reduces the workload of manual verification of data in the data charts, and improves the data verification efficiency of the data charts.
[0167] like Figure 9 As shown, in any of the above embodiments, the control device 700 of the data system includes:
[0168] The data acquisition module 708 is used to connect to the target database and the external database through an external data interface to acquire data from the external database.
[0169] The data acquisition module 708 is also used to store data from an external database in the target database.
[0170] In this embodiment, the processing procedure of the data acquisition module 708 can be specifically as follows: Figure 12The processing procedure shown is as follows: Specifically, the data acquisition module 708 connects to the external database of the external management company through an external interface, stores the data from the external database in the target database, and automatically generates related company files through background scheduling and synchronization with the IPO assistant. These related company files are then sent to the data analysis platform for data parsing and processing. The data acquisition module 708 can also connect to the ERP system (Enterprise Resource Planning system) to acquire general ledger data, payment data, accounts receivable, accounts payable, and other data from the ERP system. Simultaneously, the data analysis platform can display related data analysis on the front end to trace the source within the ERP system.
[0171] In this embodiment, the control device of the data system connects to the target database and the external database through an external interface, and stores the data from the external database in the target database. This ensures the accuracy of the associated transaction data, reduces the collection time for obtaining external transaction data, saves a lot of labor costs, and improves the efficiency of obtaining external data.
[0172] Example 3:
[0173] like Figure 13 As shown, in a third embodiment of the present invention, a control device for a data system is provided. The control device 1300 includes a processor 1302 and a memory 1304. The memory 1304 stores a program or instructions, which, when executed by the processor 1302, implement the steps of the data system control method as described in any of the above-described technical solutions. Therefore, this data system possesses all the beneficial effects of the data system control method in any of the above-described technical solutions, which will not be elaborated further here.
[0174] Example 4:
[0175] In a fourth embodiment of the present invention, a readable storage medium is provided on which a program is stored. When the program is executed by a processor, it implements the control method of the data system as described in any of the above embodiments, and thus has all the beneficial technical effects of the control method of the data system in any of the above embodiments.
[0176] Among them, readable storage media include read-only memory (ROM), random access memory (RAM), magnetic disks, or optical disks.
[0177] Example 5:
[0178] A fifth embodiment of the present invention provides a data system comprising: a control device for the data system as described in any of the above embodiments, and / or a readable storage medium as described in any of the above embodiments, thus having all the beneficial technical effects of the control device for the data system as described in any of the above embodiments, and / or the readable storage medium as described in any of the above embodiments, which will not be elaborated further here.
[0179] like Figure 14 As shown, in any of the above embodiments, the data system 1400 includes:
[0180] External data, storing interfaces of related companies;
[0181] IPO Assistant includes functional modules such as related companies, incompatibility, self-check checklist, intelligent analysis, basic settings, automatic monitoring engine, and centralized operations;
[0182] An ERP system includes functional modules such as cost management, financial management, supply chain management, production management, and capital management.
[0183] The supporting platforms include a regulatory platform, Power BI (a data visualization tool), a process engine, and a data scheduling platform.
[0184] In this embodiment, the IPO assistant can synchronize data with external data and extract data from the ERP system. It can also send rules and suggested solutions to the ERP system. In addition, through the ERP system, it can conduct traceability and joint investigation in the bank-enterprise cloud, procurement cloud, or tax cloud. Through the data system of this embodiment, a lot of manpower costs are saved, the efficiency of data verification is improved, and thus the rapid progress of the company's IPO process is guaranteed.
[0185] It should be clarified that in the claims, description, and accompanying drawings of this invention, the term "plural" refers to two or more. Unless otherwise explicitly defined, the terms "upper," "lower," etc., indicate the orientation or positional relationship based on the orientation or positional relationship shown in the accompanying drawings, and are only for the convenience of describing the invention and simplifying the description process, not to indicate or imply that the device or element referred to must have the described specific orientation, or be constructed and operated in a specific orientation. Therefore, these descriptions should not be construed as limiting the invention. The terms "connection," "installation," "fixing," etc., should be interpreted broadly. For example, "connection" can be a fixed connection between multiple objects, a detachable connection between multiple objects, or an integral connection; it can be a direct connection between multiple objects or an indirect connection between multiple objects through an intermediate medium. For those skilled in the art, the specific meaning of the above terms in this invention can be understood based on the specific circumstances of the above data.
[0186] In the claims, description, and accompanying drawings of this invention, the terms "one embodiment," "some embodiments," "specific embodiment," etc., refer to a specific feature, structure, material, or characteristic described in connection with that embodiment or example, which is included in at least one embodiment or example of the invention. In the claims, description, and accompanying drawings of this invention, illustrative expressions of the above terms do not necessarily refer to the same embodiment or example. Furthermore, the specific features, structures, materials, or characteristics described may be combined in any suitable manner in one or more embodiments or examples.
[0187] The above are merely preferred embodiments of the present invention and are not intended to limit the present invention. Various modifications and variations can be made to the present invention by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc., made within the spirit and principles of the present invention should be included within the scope of protection of the present invention.
Claims
1. A control method of a data system, characterized by, The data system comprises a target database, and a control method of the data system comprises: storing a first data credential in the target database; determining a first check result of the first data credential according to a preset check rule; determining a second check result of the first data credential according to a first customized check rule when the first check result meets a first preset condition; storing the first data credential as a target data credential when the second check result meets a second preset condition; generating a second data credential according to the preset check rule when the target database does not store the first data credential; determining a third check result of the second data credential according to a second customized check rule; storing the second data credential as the target data credential when the third check result meets a third preset condition; The first check result is used to indicate whether the first data credential meets the preset check rule, and the second check result is used to indicate whether the first data credential meets the first customized check rule. When the second check result meets the second preset condition, the first data credential is stored in the target database as the target data credential; 2. The control method of a data system according to claim 1, wherein, A first customized check rule is added, the first customized check rule is specifically that a saving user and an auditing user of the first data credential cannot be the same user, and a scheduling time of the first customized check rule is set. The control method of the data system further comprises: obtaining a data list in the target database, the data list comprising a plurality of data indicators, and determining a target data indicator in the plurality of data indicators; 3. The control method of a data system according to claim 2, wherein, generating a first data adjustment scheme of the data list when a numerical value of the target data indicator is less than a preset numerical value. The control method of the data system further comprises: determining a completion degree of the data list according to the plurality of data indicators; 4. The control method of a data system according to claim 1, wherein, generating a second data adjustment scheme of the data list according to the completion degree of the data list. The control method of the data system further comprises: obtaining a data chart and a data template in the target database; 5. The control method of a data system according to claim 1, wherein, performing data matching processing on the data chart and the data template to determine abnormal data in the data chart. The control method of the data system further comprises: connecting the target database and an external database through an external data interface to obtain data of the external database; 6. A control device for a data system, characterized in that storing the data of the external database in the target database. The data system comprises a target database, and a control device of the data system comprises: a first processing module configured to determine a first check result of a first data credential according to a preset check rule when the first data credential is stored in the target database; the first processing module is further configured to determine a second check result of the first data credential according to a first customized check rule when the first check result meets a first preset condition; The first processing module is further configured to store the first data credential as a target data credential if the second check result meets a second preset condition. The second data credential is generated according to the preset check rule if the target database does not store the first data credential; A third check result of the second data credential is determined according to a second self-defined check rule; The second data credential is stored as the target data credential if the third check result meets a third preset condition; The first check result is used to indicate whether the first data credential meets the preset check rule, and the second check result is used to indicate whether the first data credential meets the first self-defined check rule. The first data credential is stored in the target database as the target data credential if the second check result meets the second preset condition.
7. A control device for a data system, characterized in that Comprising: A processor; A memory, the memory storing programs or instructions, the processor implementing the steps of the control method of the data system according to any one of claims 1 to 5 when executing the programs or instructions in the memory.
8. A readable storage medium, characterized by, The programs or instructions are stored on the readable storage medium, and the programs or instructions are executed by the processor to implement the steps of the control method of the data system according to any one of claims 1 to 5.
9. A data system, characterized by Comprising: The control device of the data system according to claim 6 or 7; And / or The readable storage medium according to claim 8.
Citation Information
Patent Citations
Examination method and system for responsible investigation
CN110826825A
Accounting software special for checking accounts of managed party for management party
CN112419032A
Report content verification method and system, computer equipment and storage medium
CN112559817A
Data processing method and device, terminal equipment and computer readable storage medium
CN112612817A
Method for generating accounting vouchers from multi-service scene data based on different accounting criteria
CN114493814A