Storage method and device based on single index template
Through the storage method based on a single indicator template, single indicators are stored centrally in the regulatory reporting system, which solves the problems of wasted storage and surge in data caused by hollow data in a single indicator report, and realizes efficient management and storage of single indicators.
Patent Information
- Application Number
- CN202510109053.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2025-01-23
- Publication Date
- 2025-05-16
AI Technical Summary
There are a large number of single-indicator reports in the regulatory reporting system, but most single-indicators are empty data, resulting in waste of disk storage and a surge in data volume, making it difficult to conduct efficient query and management.
Using a storage method based on a single indicator template, all indicator values are written into the indicator list, and these lists are recorded in the same total list, and loop into the single indicator template to determine the fixed indicator values used for single indicator pairs.
By centralizing single indicators in a template table, useless empty indicators are eliminated and the number of tables is reduced, and a unified management and efficient storage of single indicators is achieved.
Smart Images
Figure CN120011364A_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of data processing technology, and in particular to a storage method and device based on a single indicator template. Background Art
[0002] At present, there are a large number of single-indicator reports in the regulatory reporting system, but on average, only about 50% of the single indicators in each report have logic and values, and the rest are empty data. For each report, a corresponding table space is required, which will waste a lot of disk storage; and the upstream table data used by the indicator is huge. Connecting all of them to the regulatory reporting system will cause a surge in the daily data volume of the regulatory system, so the single indicator logic needs to be pre-placed in the company's data warehouse system to relieve disk pressure. Due to the expansion of the company's business, the amount of data has increased rapidly year by year, and the reports in the regulatory reporting system have also increased rapidly, making it difficult to query and manage single indicators in the reports.
[0003] In summary, how to uniformly manage single indicators to ensure efficient storage of data is an urgent problem that technical personnel in this field need to solve. Summary of the invention
[0004] In view of this, the present application provides a storage method and device based on a single indicator template, aiming to uniformly manage a single indicator to ensure efficient storage of data.
[0005] In a first aspect, the present application provides a storage method based on a single indicator template, comprising:
[0006] Get indicator values;
[0007] Writing the indicator value into the indicator list;
[0008] Record all of the said indicator lists in one master list;
[0009] Looping the total list, inserting the total list into the single indicator template at one time;
[0010] A fixed indicator value for the single indicator pair is determined according to the single indicator template.
[0011] Optionally, after recording all the indicator lists in the same general list, the method further includes:
[0012] Determine whether there are any indicator values that have not been written into the indicator list;
[0013] If yes, writing the indicator value not written into the indicator list into the indicator list;
[0014] If not, loop through the total list and insert the total list into the single indicator template at one time.
[0015] Optionally, the indicator list includes report name, indicator name, indicator horizontal coordinate, indicator vertical coordinate, indicator value and accounting date.
[0016] Optionally, get multiple fixed indicator values, including:
[0017] Automatically run the data within the preset period range to get the indicator value according to the preset SQL statement.
[0018] Optionally, determining the fixed indicator value for the single indicator pair according to the single indicator template includes:
[0019] According to the report name, accounting date, indicator horizontal coordinate and indicator vertical coordinate of the single indicator in the indicator list, the fixed indicator value corresponding to the single indicator is obtained.
[0020] In a second aspect, the present application provides a storage device based on a single indicator template, comprising:
[0021] The acquisition module is used to obtain the indicator value;
[0022] A first writing module, used for writing the indicator value into an indicator list;
[0023] A recording module, used for recording all the indicator lists in a same general list;
[0024] A first inserting module, used for looping the total list and inserting the total list into the single indicator template at one time;
[0025] A determination module is used to determine a fixed indicator value for a single indicator pair according to the single indicator template.
[0026] Optionally, the device further comprises:
[0027] A judging module, used for judging whether there are any indicator values that have not been written into the indicator list;
[0028] A second writing module, configured to write the indicator value that is not written into the indicator list into the indicator list;
[0029] The second inserting module is used for, if not, looping the total list and inserting the total list into the single indicator template at one time.
[0030] Optionally, the acquisition module includes:
[0031] The acquisition unit is used to automatically run the data within a preset period range to run the indicator value according to the preset SQL statement.
[0032] Optionally, the indicator list includes report name, indicator name, indicator horizontal coordinate, indicator vertical coordinate, indicator value and accounting date.
[0033] Optionally, the determining module includes:
[0034] The determination unit is used to obtain the fixed indicator value corresponding to the single indicator according to the report name, accounting date, indicator horizontal coordinate and indicator vertical coordinate of the single indicator in the indicator list.
[0035] In a third aspect, an embodiment of the present application provides a computer device, comprising: a memory, a processor, and a computer program stored in the memory and executable on the processor; when the processor executes the computer program, it implements the storage method based on a single indicator template as described in any one of the implementation methods in the first aspect of the embodiment of the present application.
[0036] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium, in which instructions are stored. When the instructions are executed on a terminal device, the terminal device executes a storage method based on a single indicator template as described in any implementation method in the first aspect of the embodiment of the present application.
[0037] The present application provides a storage method based on a single indicator template. When executing the method, first obtain the indicator value, then write the indicator value into the indicator list, then record all indicator lists in the same general list, then loop the general list, insert the general list into the single indicator template at one time, and finally, determine the fixed indicator value for the single indicator according to the single indicator template. In this way, the single indicators of all reports are concentrated in a template table, and useless empty indicators are eliminated, which greatly reduces the number of tables, and an indicator can be stored independently by using the parameters in the indicator list. Single indicators can be managed uniformly to ensure efficient storage of data. BRIEF DESCRIPTION OF THE DRAWINGS
[0038] In order to more clearly illustrate the technical solutions in this embodiment or the prior art, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present application. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0039] Figure 1 A flowchart of a storage method based on a single indicator template provided in an embodiment of the present application;
[0040] Figure 2 A flowchart of another storage method based on a single indicator template provided in an embodiment of the present application;
[0041] Figure 3 A schematic diagram of the structure of a storage device based on a single indicator template provided in an embodiment of the present application;
[0042] Figure 4 A schematic diagram of the structure of a computer device provided in an embodiment of the present application. DETAILED DESCRIPTION
[0043] The following will be combined with the drawings in the embodiments of the present application to clearly and completely describe the technical solutions in the embodiments of the present application. The present application provides a storage method and device for a single indicator template, which is used in the field of data processing technology. The above is only an example and does not limit the application field of the method and device name provided in the present application.
[0044] At present, there are a large number of single-indicator reports in the regulatory reporting system, but on average, only about 50% of the single indicators in each report have logic and values, and the rest are empty data. For each report, a corresponding table space is required, which will waste a lot of disk storage; and the upstream table data used by the indicator is huge. Connecting all of them to the regulatory reporting system will cause a surge in the daily data volume of the regulatory system, so the single indicator logic needs to be pre-placed in the company's data warehouse system to relieve disk pressure. Due to the expansion of the company's business, the amount of data has increased rapidly year by year, and the reports in the regulatory reporting system have also increased rapidly, making it difficult to query and manage single indicators in the reports.
[0045] After research, the inventor proposed the technical solution of this application. First, the indicator value is obtained, and then the indicator value is written into the indicator list. Then, all the indicator lists are recorded in the same general list. Then, the general list is looped and the general list is inserted into the single indicator template at one time. Finally, the fixed indicator value used for the single indicator is determined according to the single indicator template. In this way, the single indicators of all reports are concentrated in a template table, and useless empty indicators are eliminated, which greatly reduces the number of tables. In addition, an indicator can be stored independently by using the parameters in the indicator list. Single indicators can be managed uniformly to ensure efficient storage of data.
[0046] In order to enable those skilled in the art to better understand the present application, the present application is further described in detail below in conjunction with the accompanying drawings and specific implementation methods. Obviously, the described embodiments are only a part of the embodiments of the present application, rather than all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of the present application. It should be noted that, for ease of description, only the parts related to the relevant invention are shown in the accompanying drawings. In the absence of conflict, the embodiments in the present application and the features in the embodiments can be combined with each other.
[0047] See also Figure 1 , Figure 1 A flowchart of a storage method based on a single indicator template provided in an embodiment of the present application includes:
[0048] S101: Obtain indicator values.
[0049] The data is automatically run within a preset period range to get the index value according to a preset SQL statement. For example, the data can be automatically run in the early morning every day and the index value can be run according to a preset SQL statement.
[0050] S102: Write the indicator value into the indicator list.
[0051] A single indicator is a single value that is not associated with other data in the report, such as the amount of primary assets, the amount of cash outflow, etc. Based on the common characteristics of single indicators: (1) report name; (2) indicator name; (3) horizontal axis in the report; (4) vertical axis in the report; (5) indicator value; (6) accounting date, the indicator can be located and determined based on these six parameters.
[0052] Each single indicator is in a fixed report and report position. Since the data is run every day, the accounting date needs to be recorded. Each single indicator is recorded in the [report name, indicator name, horizontal axis, vertical axis, indicator value, accounting date] list.
[0053] S103: Record all indicator lists in the same general list.
[0054] The indicator lists obtained in S102 are recorded in a general list: [[report name 1, accounting date, indicator horizontal coordinate 1, indicator vertical coordinate 1, indicator value 1], [report name 2, accounting date, indicator horizontal coordinate 2, indicator vertical coordinate 2, indicator value 2], ...].
[0055] S104: looping the total list and inserting the total list into the single indicator template at one time.
[0056] Loop through the total list, turn it into a SQL statement, insert it into the indicator template at one time, and automatically synchronize the data to the indicator template of the regulatory reporting system.
[0057] S105: Determine a fixed indicator value for a single indicator pair according to the single indicator template.
[0058] The corresponding fixed indicator value can be obtained for each single indicator in each report according to the report name, accounting date, horizontal and vertical coordinates, which can greatly improve the efficiency of obtaining indicator values.
[0059] In the embodiment provided in the present application, the indicator value is first obtained, and then the indicator value is written into the indicator list, then all the indicator lists are recorded in the same general list, then the general list is looped, and the general list is inserted into the single indicator template at one time, and finally, the fixed indicator value for the single indicator is determined according to the single indicator template. In this way, the single indicators of all reports are concentrated in a template table, and useless empty indicators are eliminated, which greatly reduces the number of tables, and an indicator can be stored independently by using the parameters in the indicator list. Single indicators can be managed uniformly to ensure efficient storage of data.
[0060] See also Figure 2 , Figure 2 A flowchart of another storage method based on a single indicator template provided in an embodiment of the present application includes:
[0061] The implementation of step S201 is the same as that of step 101 , and the implementation of steps S205 and S206 are the same as that of steps S104 and S105 , which will not be described in detail here.
[0062] S202: Write the indicator value into the indicator list.
[0063] The indicator value is written into the indicator list. If there are indicator values that have not been written into the indicator list, the indicator values that have not been written into the indicator list are written into the indicator list.
[0064] S203: Record all indicator lists in the same general list.
[0065] The indicator lists obtained in S102 are recorded in a general list: [[report name 1, accounting date, indicator horizontal coordinate 1, indicator vertical coordinate 1, indicator value 1], [report name 2, accounting date, indicator horizontal coordinate 2, indicator vertical coordinate 2, indicator value 2], ...].
[0066] S204: Determine whether there are any indicator values that have not been written into the indicator list.
[0067] It is determined whether there are any indicator values that have not been written into the indicator list. If so, step S202 is executed; if not, step S205 is executed.
[0068] The above is some specific implementation of a storage method based on a single indicator template provided by the embodiment of the present application. Based on this, the present application also provides a corresponding device. The device provided by the embodiment of the present application will be introduced from the perspective of functional modularization.
[0069] See also Figure 3 , Figure 3 A schematic diagram of a storage device based on a single indicator template provided in an embodiment of the present application is provided. The storage device 300 based on a single indicator template includes:
[0070] An acquisition module 310 is used to acquire an indicator value;
[0071] A first writing module 320, used to write the indicator value into an indicator list;
[0072] A recording module 330, used for recording all the indicator lists in the same general list;
[0073] A first inserting module 340 is used to loop the total list and insert the total list into the single indicator template at one time;
[0074] The determination module 350 is used to determine the fixed indicator value used for the single indicator pair according to the single indicator template.
[0075] Optionally, the device 300 further includes:
[0076] A judging module, used for judging whether there are any indicator values that have not been written into the indicator list;
[0077] A second writing module, configured to write the indicator value that is not written into the indicator list into the indicator list;
[0078] The second inserting module is used for, if not, looping the total list and inserting the total list into the single indicator template at one time.
[0079] Optionally, the acquisition module 310 includes:
[0080] The acquisition unit is used to automatically run the data within a preset period range to run the indicator value according to the preset SQL statement.
[0081] Optionally, the indicator list includes report name, indicator name, indicator horizontal coordinate, indicator vertical coordinate, indicator value and accounting date.
[0082] Optionally, the determining module 350 includes:
[0083] The determination unit is used to obtain the fixed indicator value corresponding to the single indicator according to the report name, accounting date, indicator horizontal coordinate and indicator vertical coordinate of the single indicator in the indicator list.
[0084] The embodiments of the present application also provide corresponding devices and computer storage media for implementing the solutions provided by the embodiments of the present application.
[0085] like Figure 4As shown, the computer device 01 is in the form of a general computing device. The components of the computer device 01 may include but are not limited to: one or more processors or processing units 03, a system memory 08, and a bus 04 connecting different system components (including the system memory 08 and the processing unit 03).
[0086] Bus 04 represents one or more of several types of bus structures, including a memory bus or memory controller, a peripheral bus, a graphics acceleration port, a processor or a local bus using any of a variety of bus structures. For example, these architectures include but are not limited to Industry Standard Architecture (ISA) bus, Micro Channel Architecture (MAC) bus, Enhanced ISA bus, Video Electronics Standards Association (VESA) local bus and Peripheral Component Interconnect (PCI) bus.
[0087] The computer device 01 typically includes a variety of computer system readable media. These media can be any available media that can be accessed by the computer device 01, including volatile and non-volatile media, removable and non-removable media.
[0088] The system memory 08 may include computer system readable media in the form of volatile memory, such as random access memory (RAM) 09 and / or cache memory 10. The computer device 01 may further include other removable / non-removable, volatile / non-volatile computer system storage media. By way of example only, the storage system 11 may be used to read and write non-removable, non-volatile magnetic media ( Figure 4 not shown, usually called a "hard drive"). Although Figure 4 Not shown in the figure, a disk drive for reading and writing a removable non-volatile disk (e.g., a "floppy disk"), and an optical disk drive for reading and writing a removable non-volatile optical disk (e.g., a CD-ROM, a DVD-ROM, or other optical media) may be provided. In these cases, each drive may be connected to the bus 04 via one or more data medium interfaces. The memory 08 may include at least one program product having a set (e.g., at least one) of program modules that are configured to perform the functions of the various embodiments of the present invention.
[0089] A program / utility 12 having a set (at least one) of program modules 13 may be stored, for example, in the memory 08, such program modules 13 including but not limited to an operating system, one or more application programs, other program modules, and program data, each of which or some combination thereof may include an implementation of a network environment. The program modules 13 generally perform the functions and / or methods of the embodiments described herein.
[0090] The computer device 01 may also communicate with one or more external devices 02 (e.g., keyboard, pointing device, display 07, etc.), one or more devices that enable a user to interact with the computer device 01, and / or any device that enables the computer device 01 to communicate with one or more other computing devices (e.g., network card, modem, etc.). Such communication may be performed via input / output (I / O) interface 06. Furthermore, the computer device 01 may also communicate with one or more networks (e.g., local area network (LAN), wide area network (WAN) and / or public network, such as the Internet) via network adapter 05. Figure 4 As shown, the network adapter 05 communicates with other modules of the computer device 01 via the bus 04. It should be understood that although Figure 4 Not shown, other hardware and / or software modules may be used in conjunction with computer device 01, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.
[0091] The processor unit 03 executes various functional applications and data processing by running the programs stored in the system memory 08, for example, implementing a storage method based on a single indicator template provided in an embodiment of the present application.
[0092] 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. In the absence of further restrictions, the elements defined by the sentence "comprise a ..." do not exclude the existence of other identical elements in the process, method, article or device including the elements.
[0093] Through the description of the above implementation methods, it can be known that those skilled in the art can clearly understand that all or part of the steps in the above-mentioned embodiment method can be implemented by means of software plus a general hardware platform. Based on such an understanding, the technical solution of the present application can be embodied in the form of a software product, which can be stored in a storage medium, such as a read-only memory (ROM) / RAM, a magnetic disk, an optical disk, etc., including a number of instructions for a computer device (which can be a personal computer, a server, or a network communication device such as a router) to execute the methods described in each embodiment of the present application or some parts of the embodiments.
[0094] Each embodiment in this specification is described in a progressive manner, and the same and similar parts between the embodiments can be referred to each other, and each embodiment focuses on the differences from other embodiments. In particular, for the device embodiment, since it is basically similar to the method embodiment, the description is relatively simple, and the relevant parts can be referred to the partial description of the method embodiment. Some or all of the modules can be selected according to actual needs to achieve the purpose of the scheme of this embodiment. Ordinary technicians in this field can understand and implement it without paying creative work.
[0095] The above description is merely an exemplary embodiment of the present application and is not intended to limit the protection scope of the present application.
Claims
1. A storage method based on a single indicator template, characterized in that: include: Get indicator values; Writing the indicator value into the indicator list; Record all of the said indicator lists in one master list; Looping the total list, inserting the total list into the single indicator template at one time; A fixed indicator value for the single indicator pair is determined according to the single indicator template.
2. The method according to claim 1, characterized in that After recording all the indicator lists in the same general list, the method further includes: Determine whether there are any indicator values that have not been written into the indicator list; If yes, writing the indicator value not written into the indicator list into the indicator list; If not, loop through the total list and insert the total list into the single indicator template at one time.
3. The method according to claim 1, characterized in that The indicator list includes a report name, an indicator name, an indicator horizontal coordinate, an indicator vertical coordinate, an indicator value, and an accounting date.
4. The method according to claim 1, characterized in that Get multiple fixed indicator values, including: Automatically run the data within the preset period range to get the indicator value according to the preset SQL statement.
5. The method according to claim 3, characterized in that: The step of determining the fixed indicator value for the single indicator pair according to the single indicator template includes: According to the report name, accounting date, indicator horizontal coordinate and indicator vertical coordinate of the single indicator in the indicator list, the fixed indicator value corresponding to the single indicator is obtained.
6. A storage device based on a single indicator template, characterized in that: include: The acquisition module is used to obtain the indicator value; A first writing module, used for writing the indicator value into an indicator list; A recording module, used for recording all the indicator lists in a same general list; A first inserting module, used for looping the total list and inserting the total list into the single indicator template at one time; A determination module is used to determine a fixed indicator value for a single indicator pair according to the single indicator template.
7. The device according to claim 1, characterized in that The device also includes: A judging module, used for judging whether there are any indicator values that have not been written into the indicator list; A second writing module, configured to write the indicator value that is not written into the indicator list into the indicator list; The second inserting module is used for, if not, looping the total list and inserting the total list into the single indicator template at one time.
8. The device according to claim 6, characterized in that The acquisition module comprises: The acquisition unit is used to automatically run the data within a preset period range to run the indicator value according to the preset SQL statement.
9. A computer device, characterized in that: include: A memory, a processor, and a computer program stored in the memory and executable on the processor. When the processor executes the computer program, the storage method based on a single indicator template as described in any one of claims 1 to 5 is implemented.
10. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores instructions, and when the instructions are executed on a terminal device, the terminal device executes the storage method based on a single indicator template as described in any one of claims 1 to 5.