Data governance method and system for multi-source financial data

Abstract

The present invention discloses a data governance method and system for multi-source financial data, and belongs to the technical field of financial data governance. The present invention comprises: S10: determining the type of work order to be improved by the budget unit; S20: selecting whether to guide the budget unit to improve the work order of the determined work order type; S30: analyzing the obstacles existing when the budget integration system manages abnormal financial data; S40: predicting the work order processing time of the budget unit; S50: managing the actual financial data reported by the budget unit; S60: connecting the two forms obtained after deduplication processing. The present invention analyzes the obstacles to the governance of abnormal financial data through the data quality and data utilization of financial data. During the analysis process, the common situations between financial data and the loss of financial data during transmission are taken into account to ensure that the analysis results are more accurate.

Description

Technical Field

[0001] The present invention relates to the technical field of financial data management, and specifically to a data management method and system for multi-source financial data. Background Art

[0002] Financial data comes from multiple subsystems, including the budget system for managing budgets and the cashier system for managing financial expenditures. However, each system exists independently, which means that it is impossible to automatically integrate data between different subsystems.

[0003] Nowadays, due to the low commonality between financial data, there are problems such as poor feedback on financial data issues, untimely processing of financial data issues, and difficulty in solving financial data problems. In order to achieve all-round service and stable operation of the core business system operation guarantee work, it is necessary to uniformly manage the above-mentioned problems, so as to promote the automatic resolution of user problems and provide decision-making support for user solutions. Summary of the invention

[0004] The purpose of the present invention is to provide a data governance method and system for multi-source financial data to solve the problems raised in the above-mentioned background technology.

[0005] In order to solve the above technical problems, the present invention provides the following technical solution: a data governance method for multi-source financial data, the method comprising:

[0006] S10: Input the actual financial data reported by the budget unit to the service desk and the financial data planned by the budget unit within the cycle into the budget integration system. The budget integration system analyzes whether it is necessary to manage the input actual financial data according to the existence of abnormal financial data of the budget unit, and determines the type of work order to be improved by the budget unit based on the sources of abnormal financial data and deviation financial data of the budget unit;

[0007] S20: The budget integration system selects whether to guide the budget unit to improve the work order of the determined work order type according to the abnormal financial data and deviation financial data of the budget unit;

[0008] S30: Based on the work order completed in S20, analyze the obstacles that exist when the budget integration system manages abnormal financial data;

[0009] S40: Analyze the real-time impact of abnormal financial data on the budget unit, and predict the work order processing time of the budget unit based on the expected completion time of the work order entered in the work order;

[0010] S50: The budget integration system sends the work order to the staff of the matching service desk at the predicted work order processing time. The staff enters the governance obstacles of the abnormal financial data analyzed into the work order. The budget integration system governs the actual financial data reported by the budget unit according to the work order for secondary entry processing, and expresses the actual financial data obtained after governance in the form of a form to obtain a governance financial form;

[0011] S60: The staff will store the problem descriptions, governance obstacles of each problem, and solutions to each problem in the work order for secondary entry processing into the knowledge base. Based on the overlapping parts of the governance financial form and the actual financial form, the staff will perform single-table deduplication processing on the governance financial form and the actual financial form respectively, and connect the two forms obtained after deduplication, thereby connecting multi-source financial data into a wide table, which is convenient for quickly locking the governance methods of the same budget unit at different times.

[0012] Further, the S10 includes:

[0013] S101: reporting the actual financial data of the budget unit within the period and the financial data planned by the budget unit within the period to the service desk, and the service desk inputs the reported financial data into the budget integration system, and the budget integration system respectively represents the input actual financial data and the financial data planned by the budget unit within the period in the form of tables, thereby obtaining the actual financial table and the planned financial table of the budget unit;

[0014] S102: The budget integration system compares the actual financial form of the budget unit with the planned financial form, and obtains abnormal financial data in the actual financial form and abnormal time of the abnormal financial data. If the budget unit has abnormal financial data, it is considered that the budget integration system needs to manage the input actual financial data. If the budget unit does not have abnormal financial data, it is considered that the budget integration system does not need to manage the input actual financial data.

[0015] S103: Determine the deviation financial data of the abnormal financial data according to the abnormal time of the abnormal financial data, and determine the type of work order to be completed by the user according to the sources of the abnormal financial data and the deviation financial data;

[0016] If the abnormal financial data and the deviant financial data come from the service industry, the type of work order that the user needs to complete is a service work order. If the abnormal financial data and the deviant financial data come from the manufacturing industry, the type of work order that the user needs to complete is an implementation work order. If the abnormal financial data and the deviant financial data come from the research and development industry, the type of work order that the user needs to complete is a research and development work order.

[0017] Furthermore, the specific method for determining the deviation financial data of the abnormal financial data is:

[0018] The acquired abnormal financial data are stored in a set M in chronological order, where M = {x1, x2, ..., xn}, and xn represents the abnormal financial data stored in the nth storage position in the set M;

[0019] The abnormal financial data xj stored in the j-th storage position in the set M is obtained, where j=1, 2, ..., n, and represents the number corresponding to each storage position in the set M, and n represents the total number of storage positions in the set M. The column name of the column where the abnormal financial data xj is located is obtained in the actual financial form, and the associated column name of the obtained column name is determined. The specific determination method is: if the obtained column name and another column name randomly selected in the actual financial form exist in the same operation, then the randomly selected column name is called the associated column name of the obtained column name;

[0020] In the actual financial form, the column where the associated column name is located is intercepted to obtain multiple actual financial sub-forms, and the multiple actual financial sub-forms are cross-connected. The new table obtained after the cross-connection is recorded as Table A, and the same type of operation is performed on each row of data in Table A. If the result of the same type of operation = abnormal financial data xj, then the financial data recorded in the corresponding row of Table A is called the deviation financial data of the abnormal financial data xj.

[0021] Further, the S20 includes:

[0022] The budget integration system transmits the abnormal financial data and deviation financial data of the budget unit to the budget unit. The budget unit feeds back the description of the problems encountered in each abnormal time period to the budget integration system based on the received information. The budget integration system searches for related problems of the received problems in the knowledge base and feeds back the knowledge of the related problems found to the budget unit.

[0023] When abnormal financial data exists, abnormal time period = [T′ xj ,T xj ], where T xj represents the acquisition time of the abnormal financial data stored in the jth storage location in the set M, T′ xj The earliest acquisition time of the deviation financial data representing the abnormal financial data xj;

[0024] When there is no deviation in the abnormal financial data, the abnormal time period = [T" xj ,T xj ], where T″ xj represents the initial search time for abnormal financial data xj;

[0025] If the budget unit can solve the problems encountered in each abnormal time period based on the received knowledge, the budget integration system will guide the budget unit to consult the knowledge of related issues. If the budget unit cannot solve the problems encountered in each abnormal time period based on the received knowledge, the budget integration system will guide the budget unit to enter the budget unit contact person, budget unit contact information, expected completion time of the work order, the work content of the budget unit in each abnormal time period, the budget unit name, and a description of the budget unit's unresolved problems into the work order of the determined work order type.

[0026] By searching for deviant financial data, it is helpful to determine the work order type of the budget unit and to improve the work order content of the budget unit, thereby ensuring the accuracy of the work order content.

[0027] Further, the S30 includes:

[0028] S301: According to the description of the unresolved problem of the budget unit recorded in the work order, the abnormal work content of the budget unit in each abnormal time period is obtained, and the financial data used by the budget unit in each abnormal work content is obtained, and the obtained financial data is put into a set N, N = {y1, y2, ..., ym}, ym represents the financial data stored in the mth storage position in the set N;

[0029] S302: Numbering each financial data stored in the set N, the numbering result is: i = 1, 2, ..., m; m represents the total number of financial data stored in the set N, according to the formula K yi ={1-[(F yi -f yi ) / F yi ]}×E yi The utilization of the financial data numbered i is calculated, where F yi represents the actual number of times the financial data numbered i is used, f yi Indicates the number of times the financial data numbered i is used as deviation financial data, E yi represents the accessibility coefficient of the financial data numbered i, K yi Indicates the utilization of financial data numbered i;

[0030] S303: When 0.7≤K yi ≤1, according to the formula H yi =(1 / m)×∑(R yiyu )×E yi The quality assessment index of the financial data numbered i is calculated, where E yi Indicates the completeness of the financial data numbered i, u = 1, 2, ..., m and u ≠ i, R yiyu =1 or Ryiyu =0, when R yiyu = 0, indicating that the database containing the financial data numbered i and the database containing the financial data numbered u do not support sharing. yiyu =1, it means that the database where the financial data numbered i is located and the database where the financial data numbered u is located support sharing, ∑ represents the summation symbol, the subscript of ∑ is i=1, and the superscript is m. When i=u, R yuyu =1;

[0031] S304: If 0≤H yi <0.8 and 0.7≤K yi ≤1, it is considered that the governance obstacle of abnormal fiscal data is that the quality of fiscal data numbered i is too low. If 0.8≤H yi ≤1 and 0.7≤K yi ≤1, it is considered that the governance obstacle of abnormal fiscal data is the abnormal fiscal data numbered i. If 0≤K yi <0.7, the governance obstacle of abnormal fiscal data is considered to be the abnormal fiscal data numbered i.

[0032] Through the data quality and data utilization of financial data, the governance obstacles of abnormal financial data are analyzed, and the governance obstacles of abnormal financial data are determined essentially, ensuring that the governance process of abnormal financial data can proceed smoothly, further improving the governance effect of the system on financial data;

[0033] Further, the S40 includes:

[0034] S401: In the next cycle, the total number of times s that the budget unit calls the financial data numbered i at time t it To obtain, according to W t =(1 / m)×∑[1-exp(-s it )] predicts the impact coefficient of abnormal fiscal data on the budget unit at time t, where the subscript of ∑ is i=1, the superscript is m, exp represents an exponential function with e as the base and e=2.72;

[0035] S402: When 0≤W t ≤0.6, then the budget unit's work order processing time = T-β×T. If 0.6<W t ≤1, then the work order handling time of the budget unit = β×t+t, where β is a constant and 0<β<0.3, and T represents the expected completion time of the work order entered by the budget unit in the work order.

[0036] Furthermore, the specific method of S50 for managing the actual financial data reported by the budget unit is:

[0037] When it is analyzed that the governance obstacle of abnormal financial data is that the quality of financial data numbered i is too low, the operation data of financial data numbered i is obtained, and according to the operation principle of financial data numbered i, the financial data numbered i is recalculated through the obtained operation data, and the financial data numbered i is replaced by the financial data obtained by the recalculation.

[0038] When the governance obstacle of the analyzed abnormal financial data is the abnormal financial data numbered i, the financial data numbered i is re-acquired at the acquisition source of the financial data numbered i, and the financial data numbered i is replaced by the re-acquired financial data.

[0039] Furthermore, the specific method of performing single-table deduplication processing on the governance financial form and the actual financial form based on the overlapped parts of the governance financial form and the actual financial form in S60 is:

[0040] Perform inner join on the governance finance form and the actual finance form to obtain the overlapping parts between the governance finance form and the actual finance form, delete the contents identical to the obtained overlapping parts in the governance finance form to obtain the governance finance sub-form, delete the contents identical to the obtained overlapping parts in the actual finance form to obtain the actual finance form 1, and connect the obtained governance finance sub-form with the actual finance form 1 by full join.

[0041] A data management system for multi-source financial data, the system comprising a work order type determination module, a work order improvement module, a management obstacle analysis module, a work order processing time prediction module, a financial data management module and a multi-source financial data connection module;

[0042] The work order type determination module is used to input the actual financial data reported by the budget unit to the service desk, as well as the financial data planned by the budget unit within the cycle, into the budget integration system. The budget integration system analyzes whether it is necessary to manage the input actual financial data according to the existence of abnormal financial data of the budget unit, and determines the work order type to be improved for the budget unit in combination with the sources of the abnormal financial data and deviation financial data of the budget unit;

[0043] The work order improvement module is used to select whether to guide the budget unit to improve the work order of the determined work order type according to the abnormal financial data and deviation financial data of the budget unit;

[0044] The governance obstacle analysis module is used to analyze the obstacles existing when the budget integration system governs abnormal financial data based on the work order transmitted by the work order improvement module;

[0045] The work order processing time prediction module is used to analyze the real-time impact of abnormal financial data on the budget unit, and predict the work order processing time of the budget unit in combination with the expected completion time of the work order entered in the work order;

[0046] The financial data governance module sends the work order to the staff of the matching service desk at the predicted work order processing time through the budget integration system. The staff enters the governance obstacles of the analyzed abnormal financial data into the work order. The budget integration system governs the actual financial data reported by the budget unit according to the work order for secondary entry processing, and represents the actual financial data obtained after governance in the form of a form to obtain a governance financial form;

[0047] The multi-source financial data connection module is used to perform single-table deduplication processing on the governance financial form and the actual financial form respectively, and connect the two forms obtained after the deduplication processing.

[0048] Compared with the prior art, the beneficial effects achieved by the present invention are:

[0049] 1. The present invention guides users to determine the type of work order to be submitted by searching for deviations from abnormal financial data. It also guides users to improve the content of the work order to be submitted by combining the knowledge of related issues found by the budget integration system in the knowledge base, which is conducive to providing decision-making support for users to automatically solve problems, and solves the problem of poor feedback on financial data issues.

[0050] 2. The present invention analyzes the obstacles to the management of abnormal financial data through the data quality and data utilization of financial data. The common situations among financial data and the loss of financial data in the transmission process are taken into account during the analysis process, so as to ensure that the analysis results are more accurate, which is conducive to helping the budget integration system to quickly manage abnormal financial data, further improving the system's management effect on multi-source financial data, and helping to reduce the difficulty of solving financial data problems.

[0051] 3. The present invention predicts the processing time of the work orders submitted by the staff to the budget units by means of the real-time impact coefficient of abnormal financial data on the budget units and the expected completion time of the budget units, thereby ensuring that the financial data can be processed in a timely manner. At the same time, the problem descriptions in the work orders, the governance obstacles of each problem, and the solutions to each problem are stored in the knowledge base, which is conducive to improving the rate at which users automatically solve financial problems.

[0052] 4. The present invention integrates multi-source financial data based on the results of deduplication of a single table, making it easy to quickly lock the governance methods of the same budget unit at different times. BRIEF DESCRIPTION OF THE DRAWINGS

[0053] The accompanying drawings are used to provide a further understanding of the present invention and constitute a part of the specification. Together with the embodiments of the present invention, they are used to explain the present invention and do not constitute a limitation of the present invention. In the accompanying drawings:

[0054] Figure 1 It is a schematic diagram of the workflow of the data governance method and system of multi-source financial data of the present invention;

[0055] Figure 2 It is a structural diagram of the working principles of the data governance method and system for multi-source financial data of the present invention. DETAILED DESCRIPTION

[0056] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0057] See also Figure 1 and Figure 2 The present invention provides a technical solution: a data governance method for multi-source financial data, the method comprising:

[0058] S10: Input the actual financial data reported by the budget unit to the service desk and the financial data planned by the budget unit within the cycle into the budget integration system. The budget integration system analyzes whether it is necessary to manage the input actual financial data according to the existence of abnormal financial data of the budget unit, and determines the type of work order to be improved by the budget unit based on the sources of abnormal financial data and deviation financial data of the budget unit;

[0059] S10 includes:

[0060] S101: Report the actual financial data of the budget unit within the period, including financial revenue data, financial expenditure data and cash flow. Cash flow refers to the balance of the inflow (revenue) of cash and cash equivalents of the budget unit within a certain period minus the outflow (expenditure), and the financial data planned by the budget unit within the period to the service desk. The service desk includes the municipal service desk, the district service desk and the town service desk. The service desk inputs the reported financial data into the budget integration system. The budget integration system refers to the unified budget management rules as the core, and the unified management rules are embedded in the information system to realize the dynamic reflection and effective control of the whole process of budget management. The budget integration system represents the input actual financial data and the financial data planned by the budget unit within the period in the form of tables, respectively, to obtain the actual financial table and the planned financial table of the budget unit. The table format of the actual financial table and the planned financial table is the same;

[0061] S102: The budget integration system compares the actual financial form of the budget unit with the planned financial form, obtains abnormal financial data in the actual financial form and the abnormal time of the abnormal financial data, randomly selects a table in the financial form, and obtains the financial data in the selected table in the actual financial form and the planned financial form. If the financial data obtained from the actual financial form is greater than the financial data obtained from the planned financial form, the financial data obtained from the actual financial form is called abnormal financial data. If the budget unit has abnormal financial data, it is considered that the budget integration system needs to manage the input actual financial data. If the budget unit does not have abnormal financial data, it is considered that the budget integration system does not need to manage the input actual financial data.

[0062] S103: Determine the deviation financial data of the abnormal financial data according to the abnormal time of the abnormal financial data, and the specific method is as follows:

[0063] The acquired abnormal financial data are stored in a set M in chronological order, where M = {x1, x2, ..., xn}, and xn represents the abnormal financial data stored in the nth storage position in the set M;

[0064] The abnormal financial data xj stored in the j-th storage position in the set M is obtained, where j=1, 2, ..., n, and represents the number corresponding to each storage position in the set M, and n represents the total number of storage positions in the set M. The column name of the column where the abnormal financial data xj is located is obtained in the actual financial form, and the associated column name of the obtained column name is determined. The specific determination method is: if the obtained column name and another column name randomly selected in the actual financial form exist in the same operation, then the randomly selected column name is called the associated column name of the obtained column name, and the other column names refer to the column names in the actual financial form other than the obtained column name;

[0065] In the actual financial form, the column where the associated column name is located is intercepted to obtain multiple actual financial subforms, and the multiple actual financial subforms are cross-connected. The cross-connection processing method is: randomly select two actual financial subforms from the multiple actual financial subforms, connect each row of data in one of the actual financial subforms with each row of data in the other actual financial subform to obtain a new table a, connect each row of data in the new table a with each row of data in an actual financial subform randomly selected from the remaining multiple actual financial subforms to obtain a new table b, and repeat the above operation until the remaining multiple All actual financial sub-tables in the actual financial sub-table are selected, and finally table A is obtained. The remaining multiple actual financial sub-tables refer to the actual financial sub-tables other than the two selected actual financial sub-tables in the obtained multiple actual financial sub-tables. The new table obtained after the cross-connection processing is recorded as table A. The same type of operation processing is performed on each row of data in table A. If the result of the same type of operation processing = abnormal financial data xj, then the financial data recorded in the corresponding row of table A is called the deviation financial data of the abnormal financial data xj. If the data c, b, and d satisfy the operation b+c=d, then the same type of operation of the operation b+c=d is db=c, dc=b or b+c=d;

[0066] Determine the type of work order that needs to be completed by the user based on the sources of abnormal and deviated financial data;

[0067] If the abnormal financial data and the deviation financial data come from the service industry, the type of work order to be completed by the user is a service work order; if the abnormal financial data and the deviation financial data come from the manufacturing industry, the type of work order to be completed by the user is an implementation work order; if the abnormal financial data and the deviation financial data come from the R&D industry, the type of work order to be completed by the user is a R&D work order;

[0068] S20: The budget integration system selects whether to guide the budget unit to improve the work order of the determined work order type according to the abnormal financial data and deviation financial data of the budget unit;

[0069] The S20 includes:

[0070] The budget integration system transmits the abnormal financial data and deviation financial data of the budget unit to the budget unit. The budget unit will feedback the description of the problems encountered in each abnormal time period to the budget integration system based on the received information. The budget integration system searches for related issues of the received issues in the knowledge base and calculates the budget unit’s abnormal financial data and deviation financial data in [T′ xj ,T xj ] time period and a random question stored in the knowledge base. If the text similarity is ≥ 0.8, the corresponding question stored in the knowledge base is considered to be the budget unit in [T′ xj ,Txj ] The related issues of the issues encountered during the time period, the text similarity calculation method is the existing technology, and the knowledge of the related issues found is fed back to the budget unit;

[0071] When abnormal financial data exists, abnormal time period = [T′ xj ,T xj ], where T xj represents the acquisition time of the abnormal financial data stored in the jth storage location in the set M, T′ xj The earliest acquisition time of the deviation financial data representing the abnormal financial data xj;

[0072] When there is no deviation in the abnormal financial data, the abnormal time period = [T" xj ,T xj ], where T″ xj represents the initial search time for abnormal financial data xj;

[0073] If the budget unit can solve the problems encountered in each abnormal time period based on the received knowledge, the budget integration system will guide the budget unit to consult the knowledge of related issues. If the budget unit cannot solve the problems encountered in each abnormal time period based on the received knowledge, the budget integration system will guide the budget unit to provide the budget unit contact person, budget unit contact information, expected completion time of the work order, work content of the budget unit in each abnormal time period, and budget unit name.

[0074] And the description of the unresolved problems of the budget unit is entered into the work order that determines the work order type;

[0075] S30: Based on the work order completed in S20, analyze the obstacles that exist when the budget integration system manages abnormal financial data;

[0076] S30 includes:

[0077] S301: According to the description of the unresolved problem of the budget unit recorded in the work order, the abnormal work content of the budget unit in each abnormal time period is obtained, and the abnormal work content is the work content corresponding to the unresolved problem. The financial data used by the budget unit in each abnormal work content is obtained, and the obtained financial data is put into a set N, N = {y1, y2, ..., ym}, ym represents the financial data stored in the mth storage position in the set N;

[0078] S302: Numbering each financial data stored in the set N, the numbering result is: i = 1, 2, ..., m; m represents the total number of financial data stored in the set N, according to the formula K yi ={1-[(F yi -fyi ) / F yi ]}×E yi The utilization of the financial data numbered i is calculated, where F yi represents the actual number of times the financial data numbered i is used, f yi Indicates the number of times the financial data numbered i is used as deviation financial data, E yi represents the accessibility coefficient of the financial data numbered i. The accessibility coefficient refers to the access frequency of the financial data numbered i. K yi Indicates the utilization of financial data numbered i;

[0079] S303: When 0.7≤K yi ≤1, according to the formula H yi =(1 / m)×∑(R yiyu )×E yi The quality assessment index of the financial data numbered i is calculated, where E yi Indicates the completeness of the financial data numbered i, u = 1, 2, ..., m and u ≠ i, R yiyu =1 or R yiyu =0, when R yiyu = 0, indicating that the database containing the financial data numbered i and the database containing the financial data numbered u do not support sharing. yiyu =1, it means that the database where the financial data numbered i is located and the database where the financial data numbered u is located support sharing, ∑ represents the summation symbol, the subscript of ∑ is i=1, and the superscript is m. When i=u, R yuyu =1;

[0080] S304: If 0≤H yi <0.8 and 0.7≤K yi ≤1, it is considered that the governance obstacle of abnormal fiscal data is that the quality of fiscal data numbered i is too low. If 0.8≤H yi ≤1 and 0.7≤K yi ≤1, it is considered that the governance obstacle of abnormal fiscal data is the abnormal fiscal data numbered i. If 0≤K yi <0.7, then the governance obstacle of abnormal fiscal data is considered to be the abnormal fiscal data numbered i;

[0081] S40: Analyze the real-time impact of abnormal financial data on the budget unit, and predict the work order processing time of the budget unit based on the expected completion time of the work order entered in the work order;

[0082] S40 includes:

[0083] S401: In the next cycle, the total number of times s that the budget unit calls the financial data numbered i at time tit To obtain, according to W t =(1 / m)×∑[1-exp(-s it )] predicts the impact coefficient of abnormal fiscal data on the budget unit at time t, where the subscript of ∑ is i=1, the superscript is m, exp represents an exponential function with e as the base and e=2.72;

[0084] S402: When 0≤W t ≤0.6, then the budget unit's work order processing time = T-β×T. If 0.6<W t ≤1, then the budget unit's work order handling time = β×t+t, where β is a constant and 0<β<0.3, and T represents the expected completion time of the work order entered by the budget unit in the work order;

[0085] S50: The budget integration system sends the work order to the staff of the matching service desk at the predicted work order processing time. The staff enters the governance obstacles of the abnormal financial data analyzed into the work order. The budget integration system manages the actual financial data reported by the budget unit based on the work order for secondary entry processing. The specific method is as follows:

[0086] When it is analyzed that the governance obstacle of abnormal financial data is that the quality of financial data numbered i is too low, the operation data of financial data numbered i is obtained, and the operation data refers to the financial data participating in the operation process of financial data numbered i. According to the operation principle of financial data numbered i, the financial data numbered i is recalculated through the obtained operation data, and the financial data numbered i is replaced by the financial data obtained by the recalculation.

[0087] When the governance obstacle of the analyzed abnormal financial data is the abnormal financial data numbered i, the financial data numbered i is re-acquired at the acquisition source of the financial data numbered i, and the financial data numbered i is replaced by the re-acquired financial data;

[0088] The actual financial data obtained after governance is expressed in the form of a table to obtain a governance financial table;

[0089] S60: The staff will store the problem descriptions, governance obstacles of each problem, and solutions of each problem in the work order for secondary entry processing into the knowledge base. Based on the overlapped parts of the governance financial form and the actual financial form, the staff will perform single-table deduplication processing on the governance financial form and the actual financial form respectively. The specific method is as follows:

[0090] Perform inner join on the governance finance form and the actual finance form. Inner join is one of the most commonly used join methods. This join method only selects the data that matches each other in the two tables to obtain the overlapped part between the governance finance form and the actual finance form. In the governance finance form, delete the content that is the same as the overlapped part obtained to obtain the governance finance subform. In the actual finance form, delete the content that is the same as the overlapped part obtained to obtain the actual finance form 1. Use the full join method to connect the obtained governance finance subform with the actual finance form 1. The full join is to list all the data in the two tables.

[0091] Afterwards, the staff will connect the two forms obtained after deduplication.

[0092] The data management system for multi-source financial data includes a work order type determination module, a work order improvement module, a management obstacle analysis module, a work order processing time prediction module, a financial data management module, and a multi-source financial data connection module;

[0093] The work order type determination module is used to input the actual financial data reported by the budget unit to the service desk, as well as the financial data planned by the budget unit within the cycle, into the budget integration system. The budget integration system analyzes whether it is necessary to manage the input actual financial data based on the existence of abnormal financial data of the budget unit, and determines the work order type to be improved for the budget unit based on the sources of the abnormal financial data and deviation financial data of the budget unit;

[0094] The work order improvement module is used to select whether to guide the budget unit to improve the work order of a certain work order type according to the abnormal financial data and deviation financial data of the budget unit;

[0095] The governance obstacle analysis module is used to analyze the obstacles that exist when the budget integration system governs abnormal financial data based on the work orders transmitted by the work order improvement module;

[0096] The work order processing time prediction module is used to analyze the real-time impact of abnormal financial data on the budget unit, and to predict the work order processing time of the budget unit based on the expected completion time of the work order entered in the work order;

[0097] The financial data governance module sends the work order to the staff of the matching service desk at the predicted work order processing time through the budget integration system. The staff enters the governance obstacles of the abnormal financial data analyzed into the work order. The budget integration system governs the actual financial data reported by the budget unit based on the work order for secondary entry processing, and presents the actual financial data obtained after governance in the form of a form to obtain a governance financial form;

[0098] The multi-source financial data connection module is used to perform single-table deduplication processing on the governance financial form and the actual financial form respectively, and connect the two forms obtained after deduplication processing.

[0099] Example 1: Assume that the acquired column name is w, and there is an operation between the financial data w1 corresponding to the column name w, the financial data e1 corresponding to the column name e, and the financial data f1 corresponding to the column name f: e1+f1=w1, then the column name f and the column name e are called the associated column names of the column name w;

[0100] From the above, we can know that the actual financial subform E and the actual financial subform F can be obtained through the actual financial form. The two actual financial subforms are converted into sets, and E = {45, 34, 57} and F = {55, 67, 45} are obtained respectively. Then the new table A = {(45, 55), (34, 67), (57, 45)} is obtained. Let the set form of the actual financial subform corresponding to the column name w be W = {100, 101, 112}, where 100 is the abnormal financial data of the actual financial form;

[0101] According to the operation: e1+f1=w1, after performing the same operation on the new table A, we get 45+56=100, 34+67=101, 57+45=112, among which 45+55=100. Therefore, the deviation financial data of the abnormal financial data 100 is 45 in the actual financial sub-table E and 55 in the actual financial sub-table F.

[0102] It should be noted that, in this article, relational terms such as first and second, etc. are only used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any such actual relationship or order between these entities or operations. Moreover, the terms "include", "comprise" or any other variants thereof are intended to cover non-exclusive inclusion, so that a process, method, article or device including a series of elements includes not only those elements, but also other elements not explicitly listed, or also includes elements inherent to such process, method, article or device.

[0103] Finally, it should be noted that the above description is only a preferred embodiment of the present invention and is not intended to limit the present invention. Although the present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art can still modify the technical solutions described in the aforementioned embodiments or replace some of the technical features therein by equivalents. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention shall be included in the protection scope of the present invention.

Claims

1. A data governance method for multi-source financial data, characterized by: The method comprises: S10: Input the actual financial data reported by the budget unit to the service desk and the financial data planned by the budget unit within the cycle into the budget integration system. The budget integration system analyzes whether it is necessary to manage the input actual financial data according to the existence of abnormal financial data of the budget unit, and determines the type of work order to be improved by the budget unit based on the sources of abnormal financial data and deviation financial data of the budget unit; The S10 includes: S101: reporting the actual financial data of the budget unit within the period and the financial data planned by the budget unit within the period to the service desk, and the service desk inputs the reported financial data into the budget integration system, and the budget integration system respectively represents the input actual financial data and the financial data planned by the budget unit within the period in the form of tables, thereby obtaining the actual financial table and the planned financial table of the budget unit; S102: The budget integration system compares the actual financial form of the budget unit with the planned financial form, and obtains abnormal financial data in the actual financial form and abnormal time of the abnormal financial data. If the budget unit has abnormal financial data, it is considered that the budget integration system needs to manage the input actual financial data. If the budget unit does not have abnormal financial data, it is considered that the budget integration system does not need to manage the input actual financial data. S103: Determine the deviation financial data of the abnormal financial data according to the abnormal time of the abnormal financial data, and the specific method is as follows: The acquired abnormal financial data are stored in a set M in chronological order, where M = {x1, x2, ..., xn}, and xn represents the abnormal financial data stored in the nth storage position in the set M; The abnormal financial data xj stored in the j-th storage position in the set M is obtained, where j=1, 2, ..., n, and represents the number corresponding to each storage position in the set M, and n represents the total number of storage positions in the set M. The column name of the column where the abnormal financial data xj is located is obtained in the actual financial form, and the associated column name of the obtained column name is determined. The specific determination method is: if the obtained column name and another column name randomly selected in the actual financial form exist in the same operation, then the randomly selected column name is called the associated column name of the obtained column name; In the actual financial table, the column where the associated column name is located is intercepted to obtain multiple actual financial sub-tables, and the multiple actual financial sub-tables are cross-connected. The new table obtained after the cross-connection processing is recorded as Table A. The same type of operation processing is performed on each row of data in Table A. If the result of the same type of operation processing = abnormal financial data xj, the financial data recorded in the corresponding row of Table A is called the deviation financial data of the abnormal financial data xj; Determine the type of work order that needs to be completed by the user based on the sources of abnormal and deviated financial data; If the abnormal financial data and the deviation financial data come from the service industry, the type of work order to be completed by the user is a service work order; if the abnormal financial data and the deviation financial data come from the manufacturing industry, the type of work order to be completed by the user is an implementation work order; if the abnormal financial data and the deviation financial data come from the R&D industry, the type of work order to be completed by the user is a R&D work order; S20: The budget integration system selects whether to guide the budget unit to improve the work order of the determined work order type according to the abnormal financial data and deviation financial data of the budget unit; S30: Based on the work order completed in S20, analyze the obstacles that exist when the budget integration system manages abnormal financial data; S40: Analyze the real-time impact of abnormal financial data on the budget unit, and predict the work order processing time of the budget unit based on the expected completion time of the work order entered in the work order; S50: The budget integration system sends the work order to the staff of the matching service desk at the predicted work order processing time. The staff enters the governance obstacles of the abnormal financial data analyzed into the work order. The budget integration system governs the actual financial data reported by the budget unit according to the work order for secondary entry processing, and expresses the actual financial data obtained after governance in the form of a form to obtain a governance financial form; S60: The staff will store the problem descriptions, governance obstacles of each problem, and solutions of each problem in the work order for secondary entry processing into the knowledge base. Based on the overlapping parts of the governance financial form and the actual financial form, the staff will perform single-table deduplication processing on the governance financial form and the actual financial form respectively, and connect the two forms obtained after deduplication processing.

2. The data governance method for multi-source financial data according to claim 1 is characterized by: The S20 includes: The budget integration system transmits the abnormal financial data and deviation financial data of the budget unit to the budget unit. The budget unit feeds back the description of the problems encountered in each abnormal time period to the budget integration system based on the received information. The budget integration system searches for related problems of the received problems in the knowledge base and feeds back the knowledge of the related problems found to the budget unit. When abnormal financial data exists, abnormal time period = [T′ xj ,T xj ], where T xj represents the acquisition time of the abnormal financial data stored in the jth storage location in the set M, T′ xj The earliest acquisition time of the deviation financial data representing the abnormal financial data xj; When there is no deviation in the abnormal financial data, the abnormal time period = [T" xj ,T xj ], where T″ xj represents the initial search time for abnormal financial data xj; If the budget unit can solve the problems encountered in each abnormal time period based on the received knowledge, the budget integration system will guide the budget unit to consult the knowledge of related issues. If the budget unit cannot solve the problems encountered in each abnormal time period based on the received knowledge, the budget integration system will guide the budget unit to enter the budget unit contact person, budget unit contact information, expected completion time of the work order, the work content of the budget unit in each abnormal time period, the budget unit name, and a description of the budget unit's unresolved problems into the work order of the determined work order type.

3. The data governance method for multi-source financial data according to claim 2 is characterized by: The S30 includes: S301: According to the description of the unresolved problem of the budget unit recorded in the work order, the abnormal work content of the budget unit in each abnormal time period is obtained, and the financial data used by the budget unit in each abnormal work content is obtained, and the obtained financial data is put into a set N, N = {y1, y2, ..., ym}, ym represents the financial data stored in the mth storage position in the set N; S302: Perform numbering processing on each financial data stored in the set N. The numbering processing result is: i=1,2,…,m; m represents the total number of financial data stored in set N. According to formula K yi ={1-[(F yi -f yi ) / F yi ]}×E yi The utilization of the financial data numbered i is calculated, where F yi represents the actual number of times the financial data numbered i is used, f yi Indicates the number of times the financial data numbered i is used as deviation financial data, E yi represents the accessibility coefficient of the financial data numbered i, K yi Indicates the utilization of financial data numbered i; S303: When 0.7≤K yi ≤1, according to the formula H yi =(1 / m)×∑(R yiyu )×E yi The quality assessment index of the financial data numbered i is calculated, where E yi Indicates the completeness of the financial data numbered i, u = 1, 2, ..., m and u ≠ i, R yiyu =1 or R yiyu =0, when R yiyu = 0, indicating that the database containing the financial data numbered i and the database containing the financial data numbered u do not support sharing. yiyu =1, it means that the database where the financial data numbered i is located and the database where the financial data numbered u is located support sharing, ∑ represents the summation symbol, the subscript of ∑ is i=1, and the superscript is m. When i=u, R yuyu =1; S304: If 0≤H yi <0.8 and 0.7≤K yi ≤1, it is considered that the governance obstacle of abnormal fiscal data is that the quality of fiscal data numbered i is too low. If 0.8≤H yi ≤1 and 0.7≤K yi ≤1, it is considered that the governance obstacle of abnormal fiscal data is the abnormal fiscal data numbered i. If 0≤K yi <0.7, the governance obstacle of abnormal fiscal data is considered to be the abnormal fiscal data numbered i.

4. The data governance method for multi-source financial data according to claim 3 is characterized by: The S40 includes: S401: In the next cycle, the total number of times s that the budget unit calls the financial data numbered i at time t it To obtain, according to W t =(1 / m)×∑[1-exp(-s it )] predicts the impact coefficient of abnormal fiscal data on the budget unit at time t, where the subscript of ∑ is i=1, the superscript is m, exp represents an exponential function with e as the base and e=2.72; S402: When 0≤W t ≤0.6, then the budget unit's work order processing time = T-β×T. If 0.6<W t ≤1, then the work order handling time of the budget unit = β×t+t, where β is a constant and 0<β<0.3, and T represents the expected completion time of the work order entered by the budget unit in the work order.

5. The data governance method for multi-source financial data according to claim 4 is characterized by: The specific method of S50 for managing the actual financial data reported by the budget unit is: When it is analyzed that the governance obstacle of abnormal financial data is that the quality of financial data numbered i is too low, the operation data of financial data numbered i is obtained, and according to the operation principle of financial data numbered i, the financial data numbered i is recalculated through the obtained operation data, and the financial data numbered i is replaced by the financial data obtained by the recalculation. When the governance obstacle of the analyzed abnormal financial data is the abnormal financial data numbered i, the financial data numbered i is re-acquired at the acquisition source of the financial data numbered i, and the financial data numbered i is replaced by the re-acquired financial data.

6. The data governance method for multi-source financial data according to claim 5 is characterized by: The specific method of performing single-table deduplication processing on the governance financial form and the actual financial form based on the overlapped parts of the governance financial form and the actual financial form in S60 is as follows: Perform inner join on the governance finance form and the actual finance form to obtain the overlapping parts between the governance finance form and the actual finance form, delete the contents identical to the obtained overlapping parts in the governance finance form to obtain the governance finance sub-form, delete the contents identical to the obtained overlapping parts in the actual finance form to obtain the actual finance form 1, and connect the obtained governance finance sub-form with the actual finance form 1 by full join.

7. A data management system for multi-source financial data applied to the data management method for multi-source financial data according to any one of claims 1 to 6, characterized in that: The system includes a work order type determination module, a work order improvement module, a governance obstacle analysis module, a work order disposal time prediction module, a financial data governance module and a multi-source financial data connection module; The work order type determination module is used to input the actual financial data reported by the budget unit to the service desk, as well as the financial data planned by the budget unit within the cycle, into the budget integration system. The budget integration system analyzes whether it is necessary to manage the input actual financial data according to the existence of abnormal financial data of the budget unit, and determines the work order type to be improved for the budget unit in combination with the sources of the abnormal financial data and deviation financial data of the budget unit; The work order improvement module is used to select whether to guide the budget unit to improve the work order of the determined work order type according to the abnormal financial data and deviation financial data of the budget unit; The governance obstacle analysis module is used to analyze the obstacles existing when the budget integration system governs abnormal financial data based on the work order transmitted by the work order improvement module; The work order processing time prediction module is used to analyze the real-time impact of abnormal financial data on the budget unit, and predict the work order processing time of the budget unit in combination with the expected completion time of the work order entered in the work order; The financial data governance module sends the work order to the staff of the matching service desk at the predicted work order processing time through the budget integration system. The staff enters the governance obstacles of the analyzed abnormal financial data into the work order. The budget integration system governs the actual financial data reported by the budget unit according to the work order for secondary entry processing, and represents the actual financial data obtained after governance in the form of a form to obtain a governance financial form; The multi-source financial data connection module is used to perform single-table deduplication processing on the governance financial form and the actual financial form respectively, and connect the two forms obtained after the deduplication processing.

Images