Index-driven data filling table processing method, device and terminal equipment

Abstract

The application provides a kind of based on index-driven data report form processing method, device and terminal equipment, it is related to big data technical field, method includes: in response to the operation instruction of user, the report serial number of the data report form to be filled and index serial number are generated;In the case where it is determined that the index serial number corresponding to the report serial number of the data report form to be filled does not exist in the report index reference index table, or it is determined that the index serial number corresponding to the report serial number of the data report form to be filled exists in the report index reference index table and the obtained index serial number is different from the index serial number of the data report form to be filled, the report data input by user is acquired, target data report form is generated, and the report serial number of the data report form to be filled and corresponding index serial number are used to update the report index reference index table, and the report index reference index table at least includes the index serial number corresponding to different report serial number.The application effectively improves the compilation efficiency of data report form.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of big data, in particular to a data reporting form processing method based on index driving, a data reporting form processing device based on index driving and a terminal device. BACKGROUND

[0002] Large enterprises need to accelerate the standardization of enterprise data and data governance in the process of digital transformation. However, in large listed companies involving multiple business segments, especially those with a large number of subsidiaries, complex business and large differences in industry nature, based on traditional reporting technology, multiple different systems may repeat reporting. At present, the traditional reporting data collection, storage and management is to collect data, store reporting data and manage the sharing and use of reporting data based on reporting forms, which may cause the same index to be reported repeatedly in different systems, and it is difficult to support data query according to the index. SUMMARY

[0003] The purpose of the embodiments of the present application is to provide a data reporting form processing method, device and terminal device based on index driving, to solve the problem that the prior art is difficult to support data query according to the index.

[0004] In order to achieve the above-mentioned purpose, the first aspect of the present application provides a data reporting form processing method based on index driving, comprising:

[0005] In response to the operation instruction of the user, a reporting sequence number of a to-be-reported data reporting form and a corresponding index sequence number are generated, the reporting sequence number is used to represent the reporting system code, the reporting form code, the subform number and the metadata code of the to-be-reported data reporting form, and the index sequence number is used to represent the index code corresponding to the metadata, the dimension corresponding to the index code and the value.

[0006] In the case where it is determined that the index sequence number corresponding to the reporting sequence number of the to-be-reported data reporting form does not exist in the preset reporting index reference index table, or it is determined that the index sequence number corresponding to the reporting sequence number of the to-be-reported data reporting form exists in the reporting index reference index table and the obtained index sequence number is different from the index sequence number of the to-be-reported data reporting form, the reporting data input by the user is acquired, a target data reporting form is generated, and the reporting sequence number of the to-be-reported data reporting form and the corresponding index sequence number are used to update the reporting index reference index table, the reporting index reference index table at least includes the index sequence number corresponding to different reporting sequence numbers.

[0007] Optionally, the index sequence number in the reporting index reference index table is used to point to the storage location of the reporting data corresponding to the index sequence number in the preset database; the method further comprises:

[0008] In a case where it is determined that the index sequence number corresponding to the filling sequence number of the data filling table to be filled exists in the filling index reference index table and the index sequence number obtained is the same as the index sequence number of the data filling table to be filled, the corresponding filling data is obtained from the preset database through the index sequence number in the filling index reference index table.

[0009] Optionally, after the filling data input by the user is obtained and the target data filling table is generated, the method further comprises:

[0010] storing the filling data input by the user into the preset database, and establishing a mapping relationship between the index sequence number of the data filling table to be filled and the storage location of the filling data in the preset database.

[0011] Optionally, in response to the operation instruction of the user, the filling sequence number and the corresponding index sequence number of the data filling table to be filled are generated, comprising:

[0012] obtaining the filling system code, the filling table code, the sub-table number, the metadata code, the index code corresponding to the metadata, the dimension and the dimension value of the data filling table to be filled according to the operation instruction of the user, performing encryption processing on the filling system code, the filling table code, the sub-table number and the metadata code of the data filling table to be filled, and obtaining the filling sequence number of the data filling table to be filled; and performing encryption processing on the index code, the dimension and the dimension value of the data filling table to be filled, and obtaining the index sequence number of the data filling table to be filled.

[0013] Optionally, the filling index reference index table further comprises:

[0014] a filling table type identifier, a metadata name, a report library table code, a modifier and a modification time;

[0015] The report library table code is a code of the filling table type identifier, the filling table code and the sub-table number.

[0016] Optionally, the encryption processing on the index code, the dimension and the dimension value of the data filling table to be filled to obtain the index sequence number of the data filling table to be filled comprises:

[0017] constructing a dimension-dimension value combination array comprising the dimension and the corresponding dimension value;

[0018] determining the sorting number of each dimension corresponding to the index code of the data filling table to be filled in the preset dimension sorting table, and arranging the dimension-dimension value combination array obtained in ascending order or descending order according to the sorting number of each dimension in the preset dimension sorting table;

[0019] performing encryption processing on the index code of the data filling table to be filled and the dimension-dimension value combination array arranged in order to obtain the index sequence number of the data filling table to be filled.

[0020] Optionally, the reporting index reference index table is updated with the reporting serial number of the data reporting form to be filled out and the corresponding index serial number, including:

[0021] The reporting index reference index table is queried, if the reporting index reference index table has an index serial number identical to the index serial number of the data reporting form to be filled out, and the reporting serial number corresponding to the index serial number in the reporting index reference index table is different from the reporting serial number of the data reporting form to be filled out, alarm information of repeated configuration is generated.

[0022] The second aspect of the present application provides a data reporting form processing device based on index driving, which applies the data reporting form processing method based on index driving described above, including:

[0023] The serial number generation module is configured to generate the reporting serial number of the data reporting form to be filled out and the corresponding index serial number in response to the operation instruction of the user, the reporting serial number is used to represent the reporting system code, the reporting form code, the subform number and the metadata code of the data reporting form to be filled out, and the index serial number is used to represent the index code corresponding to the metadata, the dimension and the value corresponding to the index code;

[0024] The reporting form generation module is configured to obtain the reporting data input by the user, generate a target data reporting form, and update the reporting index reference index table with the reporting serial number of the data reporting form to be filled out and the corresponding index serial number in the case that it is determined that the reporting index reference index table does not have the index serial number corresponding to the reporting serial number of the data reporting form to be filled out, or it is determined that the reporting index reference index table has the index serial number corresponding to the reporting serial number of the data reporting form to be filled out and the obtained index serial number is different from the index serial number of the data reporting form to be filled out, the reporting index reference index table at least includes the index serial numbers corresponding to different reporting serial numbers.

[0025] The third aspect of the present application provides a computer readable medium, the computer readable medium stores a computer program, the computer program is executed by a processor to realize the data reporting form processing method based on index driving described above.

[0026] The fourth aspect of the present application provides a terminal device, including a memory, a processor and a computer program stored in the memory and executable on the processor, the processor executes the computer program to realize the data reporting form processing method based on index driving described above.

[0027] The embodiments provided by the present application have the following beneficial effects:

[0028] By means of the pre-established filling index reference index table, the filling table is associated with the index, the filling serial number of the data filling table and the corresponding index serial number are generated according to the operation instruction of the user, the corresponding filling data can be quickly obtained through the filling index reference index table when the filling table is prepared, and the index table and the corresponding filling data are automatically updated when the corresponding filling data cannot be directly obtained according to the filling index reference index table, so that the preparation efficiency of the data filling table is effectively improved.

[0029] Other features and advantages of the embodiments or implementations of the present application will be described in detail in the following specific implementation part. BRIEF DESCRIPTION OF DRAWINGS

[0030] The accompanying drawings are included to provide a further understanding of the embodiments of the present application, and constitute a part of the specification, and are used together with the following specific implementation to explain the embodiments of the present application, but do not constitute a limitation on the embodiments of the present application. In the drawings:

[0031] Figure 1 A method flow chart of an index-driven data filling table processing method according to an embodiment of the present application is schematically shown;

[0032] Figure 2 A schematic block diagram of an index-driven data filling table processing device according to an embodiment of the present application is schematically shown;

[0033] Figure 3 A terminal device structure schematic diagram according to an embodiment of the present application is schematically shown.

[0034] MARKED FOR EXPLANATION

[0035] 10-terminal device, 100-processor, 101-memory, 102-computer program. DETAILED DESCRIPTION

[0036] The specific implementation of the embodiments of the present application will be described in detail below in combination with the drawings. It should be understood that the specific implementation described herein is only used to illustrate and explain the embodiments of the present application, and is not used to limit the embodiments of the present application.

[0037] As shown in Figure 1 The first aspect of the present embodiment provides an index-driven data filling table processing method, comprising:

[0038] In response to the operation instruction of the user, the filling serial number of the to-be-filled data filling table and the corresponding index serial number are generated, the filling serial number is used to represent the filling system code, the filling table code, the subtable number and the metadata code of the to-be-filled data filling table, and the index serial number is used to represent the index code corresponding to the metadata, the dimension corresponding to the index code and the value.

[0039] In a case where it is determined that the preset reference index table of the reporting indicator does not exist corresponding to the reporting serial number of the data reporting table to be filled in, or it is determined that the reference index table of the reporting indicator exists corresponding to the reporting serial number of the data reporting table to be filled in and the obtained reporting serial number of the reporting indicator is different from the reporting serial number of the data reporting table to be filled in, the reporting data input by the user is acquired, the target data reporting table is generated, and the reference index table of the reporting indicator is updated with the reporting serial number of the data reporting table to be filled in and the corresponding reporting serial number of the reporting indicator. The reference index table of the reporting indicator at least includes the reporting serial number corresponding to the reporting indicator.

[0040] Thus, the present embodiment associates the reporting table with the reporting indicator through the pre-established reference index table of the reporting indicator, generates the reporting serial number of the data reporting table and the corresponding reporting serial number of the reporting indicator according to the operation instruction of the user, and can quickly acquire the corresponding reporting data through the reference index table of the reporting indicator when compiling the reporting table, and automatically updates the index table and the corresponding reporting data when the corresponding reporting data cannot be directly acquired according to the reference index table of the reporting indicator, thereby effectively improving the compiling efficiency of the data reporting table.

[0041] It can be understood that the method of the present embodiment can be applied to a data reporting tool. First, the reporting tool acquires standard indicator definitions, dimension definitions and the like from a data governance platform. The standard indicator definitions, dimension definitions and the like are uniformly managed by an indicator control function of the data governance platform, the indicator control platform provides indicator definitions including indicator classification, indicator business attribute, indicator technical attribute, indicator management attribute and the like, and provides dimension definitions including dimension value coding and dimension value; wherein the standard indicator definitions and dimension definitions have been pre-stored in a data lake. The data lake provides an interface related to indicators and dimensions, and the reporting tool reads the standard indicator directory and indicator definitions, the dimension directory and dimension definitions through the interface.

[0042] It can be understood that in the present embodiment, the operation instruction of the user can be a configuration instruction of the reporting table, for example, the operation instruction can be a selection instruction of the indicator and the dimension through a related control, which is not limited herein. When configuring the reporting table, each reporting application can configure the reference standard indicator and dimension, configure on demand, and does not need to be configured for non-indicator data such as detailed and text classes. The reporting table supports multiple sub-tables, which are divided into one-dimensional sub-tables, two-dimensional sub-tables and row expansion sub-tables, wherein the indicator dimension configuration of the row expansion sub-table is the same as that of the two-dimensional sub-table.

[0043] Among them, one-dimensional sub-table can be configured as: each cell respectively references index, dimension and dimension value; two-dimensional sub-table / row expansion sub-table is divided into two kinds of index on sub-table row and column, if the index is on the sub-table row, for example, the row of the report form is the index of commercial coal resource quantity, commercial coal sales quantity and other indexes, and the column is self-production / external purchase, integration / non-integration, plan / achievement and other dimensions, then each metadata of the sub-table row respectively references index, dimension and dimension value, and the sub-table column references other dimensions and dimension values, and the column dimension and the row dimension will not overlap; if the index is on the sub-table column, then each metadata of the sub-table column respectively references index, dimension and dimension value, and the sub-table row references other dimensions and dimension values.

[0044] In the design of the report form, the index can be selected from the standard index list, the index list can be displayed in hierarchical classification according to the theme domain, the index can be located by fuzzy search according to the index code name, the index definition, that is, the index business attribute, the index technical attribute, the index management attribute and the like can be viewed by selecting the index, so as to facilitate the report form compiling user to distinguish whether the reference is accurate. When the dimension configuration is referenced, the dimension and the dimension value can be selected from the dimension list, the dimension list can be browsed, the dimension can be located by fuzzy search according to the dimension code name, the dimension value list can be viewed by selecting the dimension, and the dimension value can be selected, and one index can select multiple dimensions. When the reference index configuration is saved, the reference index configuration information is stored to the index reference configuration table of the relational report library, and the content includes the report form code, the sub-table number, the row / column flag, the metadata code, the reference index code, the reference dimension, the updater and the update time, wherein the format of the reference dimension is "dimension 1: dimension value 1, dimension 2: dimension value 2…", and the order is according to the dimension sorting number. The dimension sorting table and the reference dimension table are automatically updated when the reference index configuration is saved, the dimension sorting table is globally unified, and the fields include the report form system code, the dimension code and the sorting number, the sorting number is used to specify the dimension arrangement order of the report form index data; the reference dimension table is globally unified, and the fields include the report form system code, the dimension code, the dimension value code and the dimension value serial number, and the dimension value referenced by each report form system is recorded. The dimension code newly referenced by the report form system is inserted into the dimension sorting table, and the sorting number in the system is incremented, if the dimension code in the system exists, no processing is performed; the reference dimension table is updated, the dimension and the dimension value code newly referenced by the report form system are inserted, and the dimension value serial number is incremented. The report form compiling user can also view the index dimension referenced by each metadata of each sub-table, and view the index definition and the dimension definition.

[0045] In this embodiment, according to the operation instruction of the user when compiling the to-be-reported data report, the reporting system code, the reporting table code, the subtable number, the metadata code, the index code corresponding to the metadata, the dimension corresponding to the index code, and the dimension value and other data of the user compiling the to-be-reported data report are obtained, and the reporting sequence number and the index sequence number of the to-be-reported data report currently compiled by the user are automatically generated according to the preset rule. It can be understood that the metadata can be divided into row metadata or column metadata according to the specific compilation of the reporting table; the reporting system code can be the code of the reporting system currently logged in by the user or the code of the reporting system manually selected by the user; the reporting table code represents the code of the to-be-reported data report currently compiled, the subtable number is the code of the subtable in the to-be-reported data report, each reporting table can include several subtables, each subtable can include several metadata, each metadata can correspond to one or more indexes, each index can correspond to one or more dimensions, and each dimension corresponds to a dimension value.

[0046] The reporting sequence number and the corresponding index sequence number of the to-be-reported data report are generated by the method: obtaining the reporting system code, the reporting table code, the subtable number, the metadata code, the index code corresponding to the metadata, the dimension corresponding to the index code, and the dimension value of the to-be-reported data report according to the operation instruction of the user, encrypting the reporting system code, the reporting table code, the subtable number, and the metadata code of the to-be-reported data report obtained, to obtain the reporting sequence number of the to-be-reported data report; and encrypting the index code, the dimension, and the dimension value of the to-be-reported data report obtained, to obtain the index sequence number of the to-be-reported data report. In this embodiment, the encryption algorithm uses the MD5 encryption algorithm.

[0047] Specifically, the index code, the dimension, and the dimension value of the to-be-reported data report obtained are encrypted to obtain the index sequence number of the to-be-reported data report, including: constructing a dimension-dimension value combination array including the dimension and the corresponding dimension value; determining the sorting number of each dimension corresponding to the index code of the to-be-reported data report in the preset dimension sorting table, and arranging the obtained dimension-dimension value combination array in ascending order or descending order according to the sorting number of each dimension in the preset dimension sorting table; and encrypting the index code of the to-be-reported data report and the dimension-dimension value combination array after sorting to obtain the index sequence number of the to-be-reported data report.

[0048] The dimension-dimension value combination is to arrange the dimensions of the row metadata or the column metadata in front and back according to the order numbers in the dimension order table. For example, if the order numbers of the dimensions in the dimension order table are 1-10, the dimensions are arranged in ascending order as dimension 1, dimension 2, dimension 3, dimension 10, and the dimension-dimension value combination array is combined in the form of "dimension 1: dimension value 1, dimension 2: dimension value 2, dimension 10: dimension value 10". The index sequence number is obtained by MD5 encryption of the array of [index code, (dimension 1: dimension value 1, dimension 2: dimension value 2, dimension 10: dimension value 10)]. It can be understood that if there are multiple indexes, the data form can be {[index code 1, (dimension 1: dimension value 1, dimension 2: dimension value 2, dimension 10: dimension value 10)], [index code 2, (dimension 1: dimension value 1, dimension 2: dimension value 2, dimension 10: dimension value 10)]... [index code n, (dimension 1: dimension value 1, dimension 2: dimension value 2, dimension 10: dimension value 10)]}.

[0049] The filing index reference table further includes a filing table type identifier, a metadata name, a report library table code, a modifier, and a modification time. The report library table code is a code of the filing table type identifier, a filing table code, and a subtable number. In a specific example, the filing index reference table includes the following fields: an index code, a dimension-dimension value combination code, a filing system code, a filing table code, a subtable number, a column metadata code (i.e., a report library table field code), a column metadata name (i.e., a report library table field name), and / or a row metadata code, a report library table code (i.e., a filing table type identifier + a filing table code + a subtable number), a modifier, a modification time, MD1, and MD2. MD1 and MD2 are a pair of sequence numbers. MD1, i.e., a filing sequence number, is a string processed by MD5 of the filing system code, the report table code, the subtable number, the column metadata code, and / or the row metadata code, which is used as a basis for updating records. MD2, i.e., an index sequence number, is a string processed by MD5 of the index code and the dimension-dimension value combination code, which is used as a basis for checking the repeatability of the filing index reference. MD1 and MD2 correspond to each other.

[0050] The index sequence number in the index table is also used to point to the storage location of the corresponding reporting data of the index sequence number in the preset database, that is, the user can find the corresponding MD2 through the index table, and MD2 is used to index the storage location of the corresponding reporting data in the database. In this embodiment, the database is a data lake relational database. If it is determined through the query that there is no MD1 in the index table that is the same as the MD1 of the reporting table of the to-be-reported data, it indicates that there is no pre-stored reporting table with the same configuration in the index table. If it is determined through the query that there is MD1 in the index table that is the same as the MD1 of the reporting table of the to-be-reported data, but the corresponding MD2 is different from the MD2 of the reporting table of the to-be-reported data, it indicates that there is no index information of the reporting data corresponding to MD2 in the index table. At this time, the user needs to manually input the reporting data, and the system receives the reporting data input by the user and generates a new target data reporting table.

[0051] If it is determined that the index sequence number corresponding to the reporting sequence number of the reporting table of the to-be-reported data exists in the reporting index reference index table and the obtained index sequence number is the same as the index sequence number of the reporting table of the to-be-reported data, the corresponding reporting data is obtained from the preset database through the index sequence number in the reporting index reference index table. For example, if it is determined through the query that there is MD1 in the index table that is the same as the MD1 of the reporting table of the to-be-reported data, and the corresponding MD2 is the same as the MD2 of the reporting table of the to-be-reported data, it indicates that there is index information of the reporting table with the same configuration in the index table. At this time, the corresponding reporting data is obtained from the database through MD2 in the index table and is automatically filled into the corresponding dimension and value position.

[0052] If there is no index information with the same configuration as the reporting table of the to-be-reported data in the index table, after obtaining the reporting data input by the user and generating a target data reporting table, the method further comprises: storing the reporting data input by the user in the preset database, and establishing a mapping relationship between the index sequence number of the reporting table of the to-be-reported data and the storage location of the reporting data in the preset database. In the case where there is no index information with the same configuration as the reporting table of the to-be-reported data in the index table, the index information of the reporting table of the to-be-reported data, such as the index sequence number of the reporting table of the to-be-reported data, the dimension and value combination code, the reporting system code, the reporting table code, the sub-table number, the column metadata code, the column metadata name, and / or the row metadata code, the report library table code, the modifier, the modification time, MD1 and MD2, are used to update the index table. For example, if there is no index information of the reporting table of the to-be-reported data in the index table, a new index information is directly added in the index table. After updating the index table, the reporting data input by the user is also stored in the database, and a mapping relationship between the reporting data and MD2 is established.

[0053] The updating of the filling index table with the filling serial number and the corresponding index serial number of the data filling report form includes: querying the filling index table, if there is an index serial number same as the index serial number of the data filling report form in the filling index table, and the filling serial number corresponding to the index serial number in the filling index table is different from the filling serial number of the data filling report form, generating an alarm information of repeated configuration.

[0054] When updating the index table, the filling index reference redundancy check is automatically performed: when saving the filling index reference configuration of the data filling report form, the system automatically checks whether there is a repeated configuration, to avoid the same index dimension being repeatedly filled in different filling applications. The checking rule is as follows: generating MD1 and MD2 according to the filling index reference configuration information to be saved, querying the fields in the filling index table which are same as MD2 and different from MD1, if there is, generating a prompt information: xx index (xx dimension 1 / xx value 1, xx dimension 2 / xx value 2) has been referenced by xx filling report system xx report xx (column metadata name), please reconfigure.

[0055] The embodiment also provides the browsing of the filling index. Specifically, the standard index directory and index definition referenced by the current filling application can be hierarchically classified and browsed according to the theme domain, the index related dimension and the associated filling report form can be viewed. For example, the index code list can be obtained from the filling index reference index table according to the filling system code, then the index related attribute can be obtained by associating the index definition table, the index list can be displayed hierarchically classified according to the theme domain, the index definition can be viewed by selecting the index; the index related dimension can be viewed: the dimension value combination code can be obtained from the filling index reference index table according to the index code and the filling system code, the associated dimension can be obtained, and then the dimension name and the dimension value name can be obtained by associating the dimension definition; and the index associated filling report form can be viewed: the report code can be obtained from the filling index reference index table according to the index code and the filling system code, the report name can be obtained by associating the report information registration table, and the report code and the report name can be displayed in the list. Meanwhile, the group filling index browsing is also provided: the standard index directory and index definition referenced by all filling applications using the filling tool of the embodiment can be hierarchically classified and browsed according to the theme domain, the index related dimension, the associated filling system and the filling report form can be viewed. The same standard index can be referenced by multiple filling applications, but the related dimensions should be different, or the dimensions are same but the dimension values are different.

[0056] The embodiment also provides management of the reported main data. The reported main data management mainly maintains the mapping relationship between the organizations of each reported application and the main data of the MDM organization, and when converting the reported data into standardized index data, the main data mapping relationship needs to be converted into a standard organization code. Specifically, the mapping relationship is imported and maintained in the reporting tool, and the attribute is set as the reported main data. For the organization mapping relationship, an additional attribute ORG is added. The reported main data information is uniformly stored in the data lake relational database, and the data table is named as MDM_reported system code_main data code. The mapping relationship of the reported main data is maintained by each reported application, and is uniformly registered in the data governance platform. The main data mapping relationship is registered in the data governance platform by calling the data governance platform interface.

[0057] The reported user fills in the report form, and when saving the reported data, the reported data including the reported organization and the reported period is stored in the data lake relational database. The data table corresponding to the report form is automatically created, and the data table is named as the report form code + sub-table number. If the report form has multiple sub-tables, multiple data tables are correspondingly created. The field column includes two parts of fixed column and metadata column. The fixed column includes the organization code of the reported data, the period, the report form row code, the update time, etc. The metadata column is automatically created according to the column metadata of the report form. The field code uses the column metadata code, the field name uses the column metadata name, and the number of metadata columns depends on the number of column metadata of the report form.

[0058] When the report form information is registered, the reported form information and the reported form metadata information stored in the data lake report database are registered. The registered report form information mainly includes the reported system code, the reported form code, the reported form name, the reported data table creation time, and the reported form metadata information mainly includes the reported system code, the reported form code, the sub-table number, the reported column metadata code, and the reported column metadata name.

[0059] When the application system queries the reported data based on the index, the index sequence number is composed based on the index code, the dimension, etc., the reported index reference index table is associated to obtain the reported sequence number, and then the index data is associated and read from the relational report database. When other systems use the reported index data of the system, the reported index data is provided through the interface and obtained from the relational report database based on the index code, the dimension, etc. In this way, the demand side obtains the latest reported index data. The data service interface is uniformly managed in the data service platform of the data center.

[0060] In the embodiment, the user can also browse the reported index data according to the theme domain classification, view the number of reported indexes and the index data volume statistics, and facilitate the information management department to master the number of reported indexes of the whole group. Specifically, it includes:

[0061] Current application indicator data filling report: In the filling application, the indicator directory is classified and browsed according to the theme domain, the indicator definition is viewed, the indicator related dimension is viewed, and the indicator data is viewed according to different dimensions / dimension values. When viewing, the filling serial number MD1 and the indicator serial number MD2 are loaded at the same time, the report library table code, column metadata code and row metadata code are obtained from the filling indicator reference index table according to the indicator serial number MD2, and then the corresponding data in the report library table is obtained as the indicator data, and the indicator data is displayed in the form of a list.

[0062] Group filling indicator data browsing: The indicator directory of all filling applications is classified and browsed according to the theme domain, the indicator definition is viewed, the indicator related dimension is viewed, and the indicator data is viewed according to different dimensions / dimension values. Similar to the current application filling indicator data browsing, the difference lies in that the filling system code is not limited.

[0063] Filling indicator number statistics: The number of indicators of each theme domain is viewed, and the statistical results are displayed behind the tree node name, such as a two-level theme domain (20) indicating that the number of indicators of the two-level theme domain is 20.

[0064] The embodiment also provides filling indicator data query, including:

[0065] Filling indicator data query: The filling indicator data query is convenient for users to query filling data according to indicators and dimensions. The difference between the filling indicator data query and the data visualization lies in that the former only provides data query and simply lists the query results, the core is that users can find the data, can export, do not pay attention to the style, do not issue reports, and users can export the query results and then process them into reports; the latter queries data and displays them as reports or graphics.

[0066] According to the theme domain, the indicator code, the indicator name, the commonly used dimension, the other dimension and the like, the indicator attributes and the indicator data are queried, wherein the commonly used dimension can be configured, the other dimension: the user can search the dimension according to the dimension name in the dimension list, can check multiple dimensions; multiple commonly used dimensions and other dimensions can be checked as query filtering options; the user can filter and query data according to indicators and dimension values.

[0067] Specifically, the index list: according to the filling index reference index table, the filling system code is used to obtain the index code, the index definition table is associated, the index name is displayed according to the user's selected theme domain, and the user can check multiple indexes; Common dimensions: can be configured in system metadata, and the user can check multiple common dimensions / dimension values as conditions; Other dimensions: filter the dimension sorting table according to the filling system code, display according to the sorting number, and exclude common dimensions. The user can check multiple other dimensions / dimension values as conditions; Dimension value display: according to the dimension value code referenced in the dimension table, these are referenced dimension values, and the list only displays these; Index data query: according to the multiple indexes and multiple dimensions / dimension values checked by the user, the dimensions / dimension values are sorted and combined according to the dimension sorting number, then the index code and the dimension value combination code are processed by MD5 to obtain the index serial number, the filling serial number and the related report library table code, column metadata code and row metadata code are found from the filling index reference index table according to the index serial number, and then the corresponding data is obtained from the report library table as the index data. The index data is displayed in the form of a list.

[0068] The embodiment also provides a filling index data interface, which is used to sort and combine the dimensions according to the dimension sorting table (not limited to the filling system code, that is, all filling system index data can be searched) in order according to the dimension sorting number, then the index code and the dimension value combination code are processed by MD5 to obtain the index serial number, the filling serial number and the related report library table code, column metadata code and row metadata code are found from the filling index reference index table according to the index serial number, and then the corresponding data is obtained from the report library table as the index data, and the index data array is returned.

[0069] The embodiment also performs quality management, security management and sharing management on the filling index data. The filling index data quality management is guaranteed by each application system through data checking and the like. The security management of the filling index data mainly includes filling index data access control, filling index data hierarchical and classified storage, sensitive index data encrypted storage, filling data use application and authorization management, and the like, and is uniformly managed by the data lake. The sharing of the filling index data is realized by the data service of the data center, and is uniformly managed by the data center. The reuse rate statistics of the filling index data are performed according to the objects and service times of the data service provided by the data center, and are uniformly managed by the data center.

[0070] As shown in Figure 2 The second aspect of the present application provides an index-driven data filling table processing device, which applies the index-driven data filling table processing method described above, and includes:

[0071] The sequence number generation module is configured to generate a filling sequence number of the data filling table to be filled and a corresponding index sequence number in response to an operation instruction of a user, the filling sequence number being used to represent a filling system code, a filling table code, a sub-table number and a metadata code of the data filling table to be filled, and the index sequence number being used to represent an index code corresponding to the metadata, and dimensions and dimension values corresponding to the index code;

[0072] The filling table generation module is configured to, in a case where it is determined that the index sequence number corresponding to the filling sequence number of the data filling table to be filled does not exist in the preset filling index reference index table or that the index sequence number corresponding to the filling sequence number of the data filling table to be filled exists in the filling index reference index table and the obtained index sequence number is different from the index sequence number of the data filling table to be filled, acquire filling data input by the user, generate a target data filling table, and update the filling index reference index table with the filling sequence number of the data filling table to be filled and the corresponding index sequence number, the filling index reference index table at least including index sequence numbers corresponding to different filling sequence numbers.

[0073] The third aspect of the present application provides a computer readable medium, the computer readable medium storing a computer program, the computer program being executed by a processor to implement the above-mentioned index-driven data filling table processing method.

[0074] As shown in Figure 3 The fourth aspect of the present application provides a terminal device, which includes a memory, a processor, and a computer program stored in the memory and executable on the processor, the processor implementing the above-mentioned index-driven data filling table processing method when executing the computer program.

[0075] As shown in Figure 3 is a schematic diagram of a terminal device provided by an embodiment of the present application. As shown in Figure 3 The terminal device 10 of this embodiment includes a processor 100, a memory 101, and a computer program 102 stored in the memory 101 and executable on the processor 100. The processor 100 implements the steps in the above-mentioned method embodiments when executing the computer program 102. Alternatively, the processor 100 implements the functions of the modules / units in the above-mentioned device embodiments when executing the computer program 102.

[0076] Illustratively, the computer program 102 can be divided into one or more modules / units, which are stored in the memory 101 and executed by the processor 100 to complete the present application. One or more modules / units can be a series of computer program instruction segments capable of completing a specific function, which are used to describe the execution process of the computer program 102 in the terminal device 10. For example, the computer program 102 can be divided into a data acquisition module and a prediction module.

[0077] The terminal device 10 can be a desktop computer, a notebook computer, a palm computer, a cloud server, and the like. The terminal device 10 can include, but is not limited to, a processor 100 and a memory 101. Those skilled in the art can understand that the terminal device 10 can include more or less components, or combine some components, or different components, for example, the terminal device can also include an input / output device, a network access device, a bus, and the like. Figure 3 The terminal device 10 is only an example and does not constitute a limitation on the terminal device 10, and can include more or less components than the diagram, or combine some components, or different components, for example, the terminal device can also include an input / output device, a network access device, a bus, and the like.

[0078] The processor 100 can be a central processing unit (CPU), and can also be other general-purpose processors, a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field-programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components, and the like. The general-purpose processor can be a microprocessor or the processor can also be any conventional processor.

[0079] The memory 101 can be an internal storage unit of the terminal device 10, such as a hard disk or a memory of the terminal device 10. The memory 101 can also be an external storage device of the terminal device 10, such as a plug-in hard disk, a smart media card (SMC), a secure digital (SD) card, a flash card, and the like. Further, the memory 101 can include both the internal storage unit and the external storage device of the terminal device 10. The memory 101 is used to store computer programs and other programs and data required by the terminal device 10. The memory 101 can also be used to temporarily store data that has been output or will be output.

[0080] Those skilled in the art can clearly understand that, for the convenience and brevity of description, only the above-mentioned division of each functional unit and module is exemplified, and in actual application, the above-mentioned functions can be completed by different functional units and modules according to needs, that is, the internal structure of the device is divided into different functional units or modules to complete all or part of the above-described functions. Each functional unit and module in the embodiment can be integrated in one processing unit, or each unit can be physically present separately, or two or more units can be integrated in one unit. The integrated unit can be realized in the form of hardware or in the form of software functional unit. In addition, the specific names of each functional unit and module are only for the convenience of mutual distinction, and do not limit the protection scope of the present application. The specific working process of the unit and module in the above system can refer to the corresponding process in the foregoing method embodiment, which will not be repeated here.

[0081] In summary, the present embodiment associates the report form with the indicators, after the user fills in the report, the report indicator data is stored in the data lake standardized indicator database, facilitating the sharing and use of the report indicator data, realizing one-time reporting and multiple reuse; at the same time, the report data is stored in the data lake report database, facilitating other business applications based on the report form data by each application system; through unified management of the report indicators, the report personnel is avoided from repeatedly reporting in different application systems. At the same time, the preparation and reporting efficiency of the report data table is effectively improved.

[0082] Those skilled in the art will appreciate that embodiments of the application can be a method, a system or a computer program product. Accordingly, the application can take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the application can take the form of a computer program product on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROMs, optical storage media, etc.) having computer-usable program code embodied in the medium.

[0083] It should also be noted that the terms "comprising", "including", or any other variant thereof are intended to cover non-exclusive inclusion, so that processes, methods, articles or devices that include a series of elements not only include those elements, but also include other elements not explicitly listed, or inherent to such processes, methods, articles or devices. Without more limitations, the element defined by the statement "including a" does not exclude the presence of additional identical elements in the process, method, article or device including the element.

[0084] The above merely provides an example of the present application, and is not intended to limit the present application. For those skilled in the art, the present application can have various modifications and changes. Any modifications, equivalent replacements, improvements, etc. made within the spirit and principle of the present application shall fall into the scope of claims of the present application.

Claims

1. A method for processing a data reporting form based on an index drive, characterized in that, The method comprises the following steps: in response to the operation instruction of the user, generating the filling sequence number of the data filling table to be filled and the corresponding index sequence number, wherein the filling sequence number is used to represent the filling system code, the filling table code, the sub-table number and the metadata code of the data filling table to be filled, and the index sequence number is used to represent the index code corresponding to the metadata, the dimension corresponding to the index code and the dimension value; in the case that it is determined that the index sequence number corresponding to the filling sequence number of the data filling table to be filled does not exist in the preset filling index reference index table or that the index sequence number corresponding to the filling sequence number of the data filling table to be filled exists in the filling index reference index table and the obtained index sequence number is different from the index sequence number of the data filling table to be filled, obtaining the filling data input by the user, generating a target data filling table, and updating the filling index reference index table with the filling sequence number of the data filling table to be filled and the corresponding index sequence number, wherein the filling index reference index table at least comprises the index sequence numbers corresponding to different filling sequence numbers; in response to the operation instruction of the user, generating the filling sequence number of the data filling table to be filled and the corresponding index sequence number, comprising: obtaining the filling system code, the filling table code, the sub-table number, the metadata code, the index code corresponding to the metadata, the dimension corresponding to the index code and the dimension value of the data filling table to be filled according to the operation instruction of the user, performing encryption processing on the filling system code, the filling table code, the sub-table number and the metadata code of the data filling table to be filled to obtain the filling sequence number of the data filling table to be filled, and performing encryption processing on the index code, the dimension and the dimension value of the data filling table to be filled to obtain the index sequence number of the data filling table to be filled, wherein the encryption processing is MD5 encryption processing, and the filling sequence number and the index sequence number correspond to each other; performing encryption processing on the index code, the dimension and the dimension value of the data filling table to be filled to obtain the index sequence number of the data filling table to be filled, comprising: constructing a dimension-dimension value combination array comprising the dimension and the corresponding dimension value; determining the order numbers of each dimension corresponding to the index code of the data filling table to be filled in the preset dimension order table, and arranging the obtained dimension-dimension value combination array in ascending order or descending order according to the order numbers of each dimension in the preset dimension order table; performing encryption processing on the index code of the data filling table to be filled and the arranged dimension-dimension value combination array to obtain the index sequence number of the data filling table to be filled.

2. The index-driven data entry form processing method according to claim 1, characterized in that, The index sequence number in the filling index reference index table is used to point to the storage position of the filling data corresponding to the index sequence number in the preset database; the method further comprises: in the case that it is determined that the index sequence number corresponding to the filling sequence number of the data filling table to be filled exists in the filling index reference index table and the obtained index sequence number is the same as the index sequence number of the data filling table to be filled, obtaining the corresponding filling data from the preset database through the index sequence number in the filling index reference index table.

3. The index-driven data entry form processing method of claim 1, wherein, After obtaining the filling data input by the user and generating the target data filling table, the method further comprises: The user inputted filling data is stored in a preset database, and a mapping relationship between an index serial number of a to-be-filled data filling form and a storage location of the filling data in the preset database is established.

4. The index-driven data entry form processing method of claim 1, wherein, The filling index reference index table further includes: a filling form type identifier, a metadata name, a report library table code, a modifier, and a modification time; The report library table code is a code of the filling form type identifier, the filling form code, and the subtable number.

5. The index-driven data entry form processing method of claim 1, wherein, The filling index reference index table is updated with the filling serial number of the to-be-filled data filling form and the corresponding index serial number, including: The filling index reference index table is queried, and if the filling index reference index table includes an index serial number identical to the index serial number of the to-be-filled data filling form and the filling serial number corresponding to the index serial number in the filling index reference index table is different from the filling serial number of the to-be-filled data filling form, an alarm information of duplicate configuration is generated.

6. An index-driven data entry form processing apparatus that applies the index-driven data entry form processing method according to any one of claims 1 to 5, characterized by The sequence number generation module is configured to generate, in response to an operation instruction of a user, a filling serial number of a to-be-filled data filling form and a corresponding index serial number, the filling serial number being used to represent a filling system code, a filling form code, a subtable number, and a metadata code of the to-be-filled data filling form, and the index serial number being used to represent an index code corresponding to the metadata, a dimension corresponding to the index code, and a value corresponding to the dimension; The filling form generation module is configured to, in a case where it is determined that the preset filling index reference index table does not include an index serial number corresponding to the filling serial number of the to-be-filled data filling form or it is determined that the filling index reference index table includes an index serial number corresponding to the filling serial number of the to-be-filled data filling form and the obtained index serial number is different from the index serial number of the to-be-filled data filling form, acquire filling data inputted by a user, generate a target data filling form, and update the filling index reference index table with the filling serial number of the to-be-filled data filling form and the corresponding index serial number, the filling index reference index table at least including index serial numbers corresponding to different filling serial numbers. The computer program, when executed by a processor, implements the index-driven data filling form processing method of any one of claims 1-5.

7. A computer readable medium storing a computer program, characterized in that, The processor, when executing the computer program, implements the index-driven data filling form processing method of any one of claims 1-5.

8. A terminal device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that, ​

Images