Electronic device, method for filing and processing data sheet, and storage medium

Abstract

The present invention relates to an electronic device, a data table archiving processing method and a storage medium. The electronic device includes a memory and a processor connected to the memory, and the memory stores processing operations that can be run on the processor. system, when the processing system is executed by the processor, the following steps are implemented: establishing a monitoring table for monitoring each data table in the FAS financial database, and analyzing the change information of the data magnitude of each data table based on the monitoring table; When the data level of a data table becomes larger and meets the preset conditions, a prompt message containing the current information of the data table is generated; the processing rule set based on the current information of the data table is obtained, and the data table is processed based on the processing rule Do archiving. The invention can timely process the data tables with too large data magnitude in the FAS financial database, archive them, improve the system performance, and facilitate the management and maintenance of the system.

Description

technical field [0001] The invention relates to the technical field of databases, in particular to an electronic device, a method for archiving and processing a data table, and a storage medium. Background technique [0002] With the use of the FAS (Financial Accounting Standards) financial system, there will be more and more data tables with large data magnitudes. For example, some data tables have a data magnitude of one million, or even a small amount of data. The data level of the table has reached tens of millions or more than 100 million. If the data level of the data table is too large, it will affect the system performance such as query efficiency. In the existing technology, the existing data storage structure can be changed by sub-database sub-table and other schemes to solve the problem of more data in the database. However, considering the complexity of the data itself and the association between data in the FAS financial system, adopt This kind of scheme is mor...

AI Technical Summary

Problems solved by technology

[0002] With the use of the FAS (Financial Accounting Standards) financial system, there will be more and more data tables with large data magnitudes. For example, some data tables have a data magnitude of one million, or even a small amount of data. The data level of the table has reached tens of millions or more than 100 million. If the data level of the data table is too large, it will affect the query efficiency and other system performance.

In the existing technology, the existing data storage structure can be changed by sub-database sub-table and other schemes to solve the problem of more data in the database. However, considering the complexity of the data itself and the association between data in the FAS financial system, adopt This kind of scheme is more complicated to operate and has a greater impact on the existing system, so it cannot be applied in practice. Therefore, timely processing of single tables with large data volumes in the FAS financial system to improve system performance has become an unsolved problem The problem

Images