CN107870981B - Electronic device, data sheet filing method and storage medium - Google Patents
Electronic device, data sheet filing method and storage medium Download PDFInfo
- Publication number
- CN107870981B CN107870981B CN201710916067.3A CN201710916067A CN107870981B CN 107870981 B CN107870981 B CN 107870981B CN 201710916067 A CN201710916067 A CN 201710916067A CN 107870981 B CN107870981 B CN 107870981B
- Authority
- CN
- China
- Prior art keywords
- data
- data table
- magnitude
- processing rule
- service type
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3003—Monitoring arrangements specially adapted to the computing system or computing system component being monitored
- G06F11/302—Monitoring arrangements specially adapted to the computing system or computing system component being monitored where the computing system component is a software system
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/30—Monitoring
- G06F11/3065—Monitoring arrangements determined by the means or processing involved in reporting the monitored data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/12—Accounting
- G06Q40/125—Finance or payroll
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Engineering & Computer Science (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Accounting & Taxation (AREA)
- Data Mining & Analysis (AREA)
- Computing Systems (AREA)
- Quality & Reliability (AREA)
- Development Economics (AREA)
- Mathematical Physics (AREA)
- Economics (AREA)
- Marketing (AREA)
- Strategic Management (AREA)
- Technology Law (AREA)
- General Business, Economics & Management (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention relates to an electronic device, a data sheet filing processing method and a storage medium, wherein the electronic device comprises a memory and a processor connected with the memory, a processing system capable of running on the processor is stored in the memory, and the processing system realizes the following steps when being executed by the processor: establishing a monitoring table for monitoring each data table in an FAS financial database, and analyzing the change information of the data magnitude of each data table based on the monitoring table; when the data magnitude of the data table is increased and meets a preset condition, generating a prompt message containing the current information of the data table; and acquiring a processing rule set based on the current information of the data table, and filing the data table based on the processing rule. The invention can process the data table with overlarge data magnitude in the FAS financial database in time, archive the data table, improve the system performance and facilitate the management and maintenance of the system.
Description
Technical Field
The invention relates to the technical field of databases, in particular to an electronic device, a data sheet filing method and a storage medium.
Background
With the use of the fas (financial Accounting standards) financial system, more and more data tables have large data levels, for example, the data level of a part of the data tables reaches millions, even a small number of data tables reaches tens of millions or hundreds of millions, and the large data level of the data tables affects the system performance such as query efficiency. In the prior art, a scheme of changing an existing data storage structure by a scheme of database division and table division and the like can be adopted to solve the problem of more data in a database, but considering the complexity of data and the association between the data in the FAS financial system, the scheme is more complex to operate and has larger impact on the existing system, so that the scheme cannot be applied in practice, and therefore, a single table with a larger data magnitude in the FAS financial system is processed in time to improve the system performance to be solved.
Disclosure of Invention
The invention aims to provide an electronic device, a data table archiving processing method and a storage medium, and aims to timely process a data table with an overlarge data magnitude in an FAS financial database so as to archive the data table.
In order to achieve the above object, the present invention provides an electronic device, which includes a memory and a processor connected to the memory, wherein the memory stores a processing system capable of running on the processor, and when executed by the processor, the processing system implements the following steps:
s101, establishing a monitoring table for monitoring each data table in an FAS financial database, and analyzing the change information of the data magnitude of each data table based on the monitoring table;
s102, when the data magnitude of the data table is increased and meets a preset condition, generating a prompt message containing the current information of the data table;
s103, acquiring a processing rule set based on the current information of the data table, and filing the data table based on the processing rule.
Preferably, the analyzing the change information of the data magnitude of each data table based on the monitoring table in step S101 includes:
acquiring the data magnitude of each data table in an FAS database in the monitoring table at regular time, and analyzing whether the data magnitude of each data table reaches a preset threshold value or not; or
And acquiring the data magnitude of each data table in an FAS database in the monitoring table at regular time, calculating the amplification of the data magnitude of each data table in a preset time interval, and analyzing whether the amplification of the data magnitude of each data table reaches a preset amplitude or not.
Preferably, the current information of the data table includes type information, the type information includes a service type and a non-service type, the processing rule includes a first processing rule and a second processing rule, and the step S103 includes:
if the service type of the data table is a non-service type, acquiring a first processing rule set based on the non-service type, and filing the data table based on the first processing rule;
and if the service type of the data table is the service type, acquiring a second processing rule set based on the service type, and filing the data table based on the second processing rule.
Preferably, the first processing rule includes: allocating tasks to the data table, transplanting data in the data table to a corresponding filing table based on the allocated task timing, or reserving a predetermined part of data in the data table, and transplanting other data which is not reserved to the corresponding filing table based on the allocated task timing;
the second processing rule includes: distributing tasks to the data table, reserving a predetermined part of data in the data table, and transplanting other data which are not reserved to the corresponding filing table based on the distributed task timing.
In order to achieve the above object, the present invention further provides a method for archiving and processing a data table, where the method includes:
s1, 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;
s2, when the data magnitude of the data sheet is increased and meets the preset conditions, generating a prompt message containing the current information of the data sheet;
s3, a processing rule set based on the current information of the data table is acquired, and the data table is filed based on the processing rule.
Preferably, the analyzing the change information of the data magnitude of each data table based on the monitoring table in step S1 includes:
acquiring the data magnitude of each data table in an FAS database in the monitoring table at regular time, and analyzing whether the data magnitude of each data table reaches a preset threshold value or not; or
And acquiring the data magnitude of each data table in an FAS database in the monitoring table at regular time, calculating the amplification of the data magnitude of each data table in a preset time interval, and analyzing whether the amplification of the data magnitude of each data table reaches a preset amplitude or not.
Preferably, the current information of the data table includes type information, the type information includes a service type and a non-service type, the processing rule includes a first processing rule and a second processing rule, and the step S3 includes:
if the service type of the data table is a non-service type, acquiring a first processing rule set based on the non-service type, and filing the data table based on the first processing rule;
and if the service type of the data table is the service type, acquiring a second processing rule set based on the service type, and filing the data table based on the second processing rule.
Preferably, the first processing rule includes: allocating tasks to the data table, transplanting data in the data table to a corresponding filing table based on the allocated task timing, or reserving a predetermined part of data in the data table, and transplanting other data which is not reserved to the corresponding filing table based on the allocated task timing;
the second processing rule includes: distributing tasks to the data table, reserving a predetermined part of data in the data table, and transplanting other data which are not reserved to the corresponding filing table based on the distributed task timing.
Preferably, when the data is transplanted to the corresponding filing table, the data is also subjected to association processing, combination processing and/or classified storage.
The present invention also provides a computer readable storage medium having stored thereon a processing system, which when executed by a processor implements the steps of the above-described method for data sheet archiving processing.
The invention has the beneficial effects that: the invention establishes the monitoring table for monitoring the data magnitude of each data table in the FAS financial database, acquires the preset processing rule or reminds maintenance personnel to set the corresponding processing rule on site when the data magnitude of the data table is changed greatly or increased greatly, and files the data table according to the processing rule.
Drawings
FIG. 1 is a schematic diagram of an alternative application environment according to various embodiments of the present invention;
FIG. 2 is a flowchart illustrating an embodiment of a method for archiving a data table according to the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the description relating to "first", "second", etc. in the present invention is for descriptive purposes only and is not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In addition, technical solutions between various embodiments may be combined with each other, but must be realized by a person skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination should not be considered to exist, and is not within the protection scope of the present invention.
FIG. 1 is a schematic diagram of an application environment of the method for archiving and processing a data table according to the preferred embodiment of the present invention. The application environment schematic diagram includes an electronic device 1 and a terminal device 2. The electronic apparatus 1 may perform data interaction with the terminal device 2 through a suitable technology such as a network, a near field communication technology, and the like.
The terminal device 2 includes, but is not limited to, any electronic product capable of performing man-machine interaction with a user through a keyboard, a mouse, a remote controller, a touch panel, or a voice control device, for example, a mobile device such as a Personal computer, a tablet computer, a smart phone, a Personal Digital Assistant (PDA), a game machine, an interactive web Television (IPTV), a smart wearable device, a navigation device, or the like, or a fixed terminal such as a Digital TV, a desktop computer, a notebook, a server, or the like. The terminal device 2 is used for receiving an instruction for establishing a monitoring table and sending the instruction to the electronic device, and receiving a processing rule set by a maintenance worker on site, and the like.
The electronic apparatus 1 is a device capable of automatically performing numerical calculation and/or information processing in accordance with a command set in advance or stored. The electronic device 1 may be a computer, or may be a single network server, a server group composed of a plurality of network servers, or a cloud composed of a large number of hosts or network servers based on cloud computing, where cloud computing is one of distributed computing and is a super virtual computer composed of a group of loosely coupled computers.
In the present embodiment, the electronic device 1 may include, but is not limited to, a memory 11, a processor 12, and a network interface 13, which are communicatively connected to each other through a system bus, wherein the memory 11 stores a processing system operable on the processor 12. It is noted that fig. 1 only shows the electronic device 1 with components 11-13, but it is to be understood that not all shown components are required to be implemented, and that more or less components may be implemented instead.
The storage 11 includes a memory and at least one type of readable storage medium. The memory provides cache for the operation of the electronic device 1; the readable storage medium may be a non-volatile storage medium such as flash memory, a hard disk, a multimedia card, a card type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), a Read Only Memory (ROM), an Electrically Erasable Programmable Read Only Memory (EEPROM), a Programmable Read Only Memory (PROM), a magnetic memory, a magnetic disk, an optical disk, etc. In some embodiments, the readable storage medium may be an internal storage unit of the electronic apparatus 1, such as a hard disk of the electronic apparatus 1; in other embodiments, the non-volatile storage medium may also be an external storage device of the electronic apparatus 1, such as a plug-in hard disk provided on the electronic apparatus 1, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), and the like. In this embodiment, the readable storage medium of the memory 11 is generally used for storing an operating system and various application software installed in the electronic device 1, such as a program code of a processing system in an embodiment of the present invention. Further, the memory 11 may also be used to temporarily store various types of data that have been output or are to be output.
The processor 12 may be a Central Processing Unit (CPU), controller, microcontroller, microprocessor, or other data Processing chip in some embodiments. The processor 12 is generally configured to control the overall operation of the electronic apparatus 1, such as performing control and processing related to data interaction or communication with the terminal device 2. In this embodiment, the processor 12 is configured to run the program code stored in the memory 11 or process data, for example, run a processing system.
The network interface 13 may comprise a wireless network interface or a wired network interface, and the network interface 13 is generally used for establishing a communication connection between the electronic apparatus 1 and other electronic devices. In this embodiment, the network interface 13 is mainly used to connect the electronic apparatus 1 with one or more terminal devices 2, and establish a data transmission channel and a communication connection between the electronic apparatus 1 and the one or more terminal devices 2.
The processing system is stored in the memory 11 and includes at least one computer readable instruction stored in the memory 11, the at least one computer readable instruction being executable by the processor 12 to implement the method of the embodiments of the present application; and the at least one computer readable instruction may be divided into different logic blocks depending on the functions implemented by the respective portions.
In one embodiment, the processing system described above, when executed by the processor 12, performs the following steps:
step S101, establishing a monitoring table for monitoring each data table in an FAS financial database, and analyzing the change information of the data magnitude of each data table based on the monitoring table;
in this embodiment, the FAS financial database has a large number of data tables, and a monitoring table is established to monitor each data table. The monitoring table includes names, data levels, type information, and time information of data tables, for example, the monitoring table records names of data tables to be monitored in the form of table 1 and table 2 … table n, and records corresponding data levels, type information, and time information after the name of each data table, for example, for table 1, the monitoring table records one or more data levels after table 1 at each predetermined time. Each data table has corresponding type information, including service type and non-service type, to distinguish whether the data table is a service data table or a non-service data table.
In this embodiment, each data table in the FAS financial database may be monitored in real time, for example, the data magnitude of each data table is recorded over time, or each data table in the FAS financial database is monitored at regular time, preferably, the data table is monitored at regular time, for example, the data magnitude of each data table is captured every 1 hour or 5 hours, or the time for capturing the data magnitude of each data table is set according to the actual situation of each data table, and the captured data magnitude is recorded in the monitoring table.
In the FAS financial database, if new data is added to a certain data table, the data level of the data table is increased. When the change information of the data magnitude of a certain data table is analyzed, preferably, the data magnitude of each data table in the FAS database in the monitoring table can be acquired at regular time, and whether the data magnitude of each data table reaches a preset threshold value, for example, whether the data magnitude reaches a million level is analyzed; or acquiring the data magnitude of each data table in the FAS database in the monitoring table at preset time intervals, calculating the amplification of the data magnitude of each data table, analyzing whether the amplification of the data magnitude of each data table reaches a preset amplitude, for example, analyzing whether the amplification of the data magnitude of a certain data table for two consecutive months reaches a preset threshold (for example, the amplification is 100%) with one month as a time interval.
Step S102, when the data magnitude of the data table is increased and meets a preset condition, generating a prompt message containing the current information of the data table;
in this embodiment, when the data magnitude of the data table becomes larger and meets a preset condition, for example, the data magnitude of the data table becomes larger and reaches a preset threshold, or the data magnitude becomes larger and the amplification of a preset time interval reaches a preset threshold, a prompt message including current information of the data table is generated, where the current information of the data table includes a name, the data magnitude, and type information of the data table. The prompt message is used for reminding maintenance personnel to process the data sheet.
The prompt message may be sent to a predetermined terminal in a predetermined format and perform a prompt, or sent to a mobile terminal worn by a maintenance person and perform a prompt, where the predetermined format of the prompt message is, for example, "table 1, data magnitude, and type information.
Step S103 acquires a processing rule set based on the current information of the data table, and performs filing processing on the data table based on the processing rule.
In an embodiment, the processing rule may be preset by a maintainer, and includes a plurality of types, each processing rule is associated with data magnitude and type information of the data table, after a prompt message including current information of the data table is generated, the preset processing rule is automatically obtained based on the current information in the prompt message, and the data table is archived based on the processing rule. In other embodiments, the processing rules may be set on site by the maintenance staff, that is, when the maintenance staff receives a prompt message for a data table in the FAS financial database, the maintenance staff sets corresponding processing rules for the data table based on the data magnitude and type information of the data table, and performs archive processing on the data table based on the processing rules.
The processing rule may be to archive the data table periodically, or may be to archive all the data tables directly.
Compared with the prior art, the embodiment establishes the monitoring table for monitoring the data magnitude of each data table in the FAS financial database, acquires the preset processing rule or reminds maintenance personnel to set the corresponding processing rule on site when the data volume level of the data table is larger or the amplification is larger, and files the data table according to the processing rule.
In a preferred embodiment, on the basis of the above embodiment of fig. 1, the step S103 includes: if the service type of the data table is a non-service type, acquiring a first processing rule set based on the non-service type, and filing the data table based on the first processing rule; and if the service type of the data table is the service type, acquiring a second processing rule set based on the service type, and filing the data table based on the second processing rule.
In an embodiment, the processing rule includes a first processing rule preset by a maintenance person and a second processing rule set by the maintenance person on site, and the type information includes a service type (e.g. a reimbursement bill, a statement of credit, or an invoice, etc.) and a non-service type (e.g. an approval record table, etc.): if the service type of the data table is a non-service type, acquiring a first processing rule corresponding to the non-service type setting, and filing the data table based on the first processing rule; and if the service type of the data table is the service type, acquiring a second processing rule corresponding to the service type setting, and filing the data table based on the second processing rule. The embodiment provides a flexible mode for setting the processing rules, so that the data table with large data magnitude is filed according to the processing rules based on different practical situations.
Preferably, the first processing rule comprises: allocating tasks to the data table, transplanting data in the data table to a corresponding filing table based on the allocated task timing, or reserving a predetermined part of data in the data table, and transplanting other data which is not reserved to the corresponding filing table based on the allocated task timing; the second processing rule includes: distributing tasks to the data table, reserving a predetermined part of data in the data table, and transplanting other data which are not reserved to the corresponding filing table based on the distributed task timing. In other embodiments, other processing rules may be set, such as directly filing all the data in the data table into an archive table, etc., which are not illustrated herein.
In this embodiment, the task assigned to the data table may be, for example, periodically transplanting the data of the last year in the data table to the archive table every day until all the data of the last year in the data table are transplanted to the archive table; or, part of data of the previous year in the data table is reserved, and other data of the previous year is periodically transplanted to the filing table every day until all the part of data is transplanted to the filing table.
In the specific implementation process, when the data in the data table is archived, the associated data can be associated, the repeated data can be merged, and the data can be classified and stored according to the storage value of the data, so that the storage and the subsequent utilization are facilitated.
As shown in fig. 2, fig. 2 is a schematic flowchart of an embodiment of a method for archiving a data table, where the method for archiving a data table includes the following steps:
step S1, 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;
in this embodiment, the FAS financial database has a large number of data tables, and a monitoring table is established to monitor each data table. The monitoring table includes names, data levels, type information, and time information of data tables, for example, the monitoring table records names of data tables to be monitored in the form of table 1 and table 2 … table n, and records corresponding data levels, type information, and time information after the name of each data table, for example, for table 1, the monitoring table records one or more data levels after table 1 at each predetermined time. Each data table has corresponding type information, including service type and non-service type, to distinguish whether the data table is a service data table or a non-service data table.
In this embodiment, each data table in the FAS financial database may be monitored in real time, for example, the data magnitude of each data table is recorded over time, or each data table in the FAS financial database is monitored at regular time, preferably, the data table is monitored at regular time, for example, the data magnitude of each data table is captured every 1 hour or 5 hours, or the time for capturing the data magnitude of each data table is set according to the actual situation of each data table, and the captured data magnitude is recorded in the monitoring table.
In the FAS financial database, if new data is added to a certain data table, the data level of the data table is increased. When the change information of the data magnitude of a certain data table is analyzed, preferably, the data magnitude of each data table in the FAS database in the monitoring table can be acquired at regular time, and whether the data magnitude of each data table reaches a preset threshold value, for example, whether the data magnitude reaches a million level is analyzed; or acquiring the data magnitude of each data table in the FAS database in the monitoring table at preset time intervals, calculating the amplification of the data magnitude of each data table, analyzing whether the amplification of the data magnitude of each data table reaches a preset amplitude, for example, analyzing whether the amplification of the data magnitude of a certain data table for two consecutive months reaches a preset threshold (for example, the amplification is 100%) with one month as a time interval.
Step S2, when the data magnitude of the data sheet is increased and meets the preset condition, generating a prompt message containing the current information of the data sheet;
in this embodiment, when the data magnitude of the data table becomes larger and meets a preset condition, for example, the data magnitude of the data table becomes larger and reaches a preset threshold, or the data magnitude becomes larger and the amplification of a preset time interval reaches a preset threshold, a prompt message including current information of the data table is generated, where the current information of the data table includes a name, the data magnitude, and type information of the data table. The prompt message is used for reminding maintenance personnel to process the data sheet.
The prompt message may be sent to a predetermined terminal in a predetermined format and perform a prompt, or sent to a mobile terminal worn by a maintenance person and perform a prompt, where the predetermined format of the prompt message is, for example, "table 1, data magnitude, and type information.
In step S3, a processing rule set based on the current information of the data table is acquired, and the data table is filed based on the processing rule.
In an embodiment, the processing rule may be preset by a maintainer, and includes a plurality of types, each processing rule is associated with data magnitude and type information of the data table, after a prompt message including current information of the data table is generated, the preset processing rule is automatically obtained based on the current information in the prompt message, and the data table is archived based on the processing rule. In other embodiments, the processing rules may be set on site by the maintenance staff, that is, when the maintenance staff receives a prompt message for a data table in the FAS financial database, the maintenance staff sets corresponding processing rules for the data table based on the data magnitude and type information of the data table, and performs archive processing on the data table based on the processing rules.
The processing rule may be to archive the data table periodically, or may be to archive all the data tables directly.
Compared with the prior art, the embodiment establishes the monitoring table for monitoring the data magnitude of each data table in the FAS financial database, acquires the preset processing rule or reminds maintenance personnel to set the corresponding processing rule on site when the data volume level of the data table is larger or the amplification is larger, and files the data table according to the processing rule.
In a preferred embodiment, on the basis of the embodiment of fig. 2, the step S3 includes: if the service type of the data table is a non-service type, acquiring a first processing rule set based on the non-service type, and filing the data table based on the first processing rule; and if the service type of the data table is the service type, acquiring a second processing rule set based on the service type, and filing the data table based on the second processing rule.
In an embodiment, the processing rule includes a first processing rule preset by a maintenance person and a second processing rule set by the maintenance person on site, and the type information includes a service type (e.g. a reimbursement bill, a statement of credit, or an invoice, etc.) and a non-service type (e.g. an approval record table, etc.): if the service type of the data table is a non-service type, acquiring a first processing rule corresponding to the non-service type setting, and filing the data table based on the first processing rule; and if the service type of the data table is the service type, acquiring a second processing rule corresponding to the service type setting, and filing the data table based on the second processing rule. The embodiment provides a flexible mode for setting the processing rules, so that the data table with large data magnitude is filed according to the processing rules based on different practical situations.
Preferably, the first processing rule comprises: allocating tasks to the data table, transplanting data in the data table to a corresponding filing table based on the allocated task timing, or reserving a predetermined part of data in the data table, and transplanting other data which is not reserved to the corresponding filing table based on the allocated task timing; the second processing rule includes: distributing tasks to the data table, reserving a predetermined part of data in the data table, and transplanting other data which are not reserved to the corresponding filing table based on the distributed task timing. In other embodiments, other processing rules may be set, such as directly filing all the data in the data table into an archive table, etc., which are not illustrated herein.
In this embodiment, the task assigned to the data table may be, for example, periodically transplanting the data of the last year in the data table to the archive table every day until all the data of the last year in the data table are transplanted to the archive table; or, part of data of the previous year in the data table is reserved, and other data of the previous year is periodically transplanted to the filing table every day until all the part of data is transplanted to the filing table.
In the specific implementation process, when the data in the data table is archived, the associated data can be associated, the repeated data can be merged, and the data can be classified and stored according to the storage value of the data, so that the storage and the subsequent utilization are facilitated.
The present invention also provides a computer readable storage medium having stored thereon a processing system, which when executed by a processor implements the steps of the above-described method for data sheet archiving processing.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner. Based on such understanding, the technical solutions of the present invention may be embodied in the form of a software product, which is stored in a storage medium (such as ROM/RAM, magnetic disk, optical disk) and includes instructions for enabling a terminal device (such as a mobile phone, a computer, a server, an air conditioner, or a network device) to execute the method according to the embodiments of the present invention.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (8)
1. An electronic device, comprising a memory and a processor connected to the memory, wherein the memory stores a processing system operable on the processor, and the processing system when executed by the processor implements the following steps:
s101, establishing a monitoring table for monitoring each data table in the FAS financial database, analyzing change information of data magnitude of each data table based on the monitoring table, where analyzing change information of data magnitude of each data table based on the monitoring table in step S101 includes:
acquiring the data magnitude of each data table in an FAS database in the monitoring table at regular time, and analyzing whether the data magnitude of each data table reaches a preset threshold value or not; or
The data magnitude of each data table in an FAS database in the monitoring table is obtained regularly, the amplification of the data magnitude of each data table in a preset time interval is calculated, and whether the amplification of the data magnitude of each data table reaches a preset amplitude or not is analyzed;
s102, when the data magnitude of the data table is increased and meets a preset condition, generating a prompt message containing the current information of the data table, wherein the increasing of the data magnitude of the data table and the meeting of the preset condition comprise: the data magnitude of the data table is increased and reaches a preset threshold value, or the data magnitude is increased and the amplification of a preset time interval reaches the preset threshold value;
s103, acquiring a processing rule set based on the current information of the data table, and filing the data table based on the processing rule.
2. The electronic device according to claim 1, wherein the current information of the data table includes type information, the type information includes a service type and a non-service type, the processing rule includes a first processing rule and a second processing rule, the step S103 includes:
if the service type of the data table is a non-service type, acquiring a first processing rule set based on the non-service type, and filing the data table based on the first processing rule;
and if the service type of the data table is the service type, acquiring a second processing rule set based on the service type, and filing the data table based on the second processing rule.
3. The electronic device of claim 2, wherein the first processing rule comprises: allocating tasks to the data table, transplanting data in the data table to a corresponding filing table based on the allocated task timing, or reserving a predetermined part of data in the data table, and transplanting other data which is not reserved to the corresponding filing table based on the allocated task timing;
the second processing rule includes: distributing tasks to the data table, reserving a predetermined part of data in the data table, and transplanting other data which are not reserved to the corresponding filing table based on the distributed task timing.
4. A method of data table archiving processing, the method comprising:
s1, creating a monitoring table for monitoring each data table in the FAS financial database, analyzing the change information of the data magnitude of each data table based on the monitoring table, where the analyzing the change information of the data magnitude of each data table based on the monitoring table in step S1 includes:
acquiring the data magnitude of each data table in an FAS database in the monitoring table at regular time, and analyzing whether the data magnitude of each data table reaches a preset threshold value or not; or
The data magnitude of each data table in an FAS database in the monitoring table is obtained regularly, the amplification of the data magnitude of each data table in a preset time interval is calculated, and whether the amplification of the data magnitude of each data table reaches a preset amplitude or not is analyzed;
s2, when the data magnitude of the data table is increased and meets a preset condition, generating a prompt message containing the current information of the data table, wherein the increasing of the data magnitude of the data table and the meeting of the preset condition include: the data magnitude of the data table is increased and reaches a preset threshold value, or the data magnitude is increased and the amplification of a preset time interval reaches the preset threshold value;
s3, a processing rule set based on the current information of the data table is acquired, and the data table is filed based on the processing rule.
5. The method of claim 4, wherein the current information of the data table includes type information, the type information includes a service type and a non-service type, the processing rule includes a first processing rule and a second processing rule, the step S3 includes:
if the service type of the data table is a non-service type, acquiring a first processing rule set based on the non-service type, and filing the data table based on the first processing rule;
and if the service type of the data table is the service type, acquiring a second processing rule set based on the service type, and filing the data table based on the second processing rule.
6. The method of claim 5, wherein the first processing rule comprises: allocating tasks to the data table, transplanting data in the data table to a corresponding filing table based on the allocated task timing, or reserving a predetermined part of data in the data table, and transplanting other data which is not reserved to the corresponding filing table based on the allocated task timing;
the second processing rule includes: distributing tasks to the data table, reserving a predetermined part of data in the data table, and transplanting other data which are not reserved to the corresponding filing table based on the distributed task timing.
7. The method for filing processing of data table according to claim 6, wherein when the data is migrated to the corresponding filing table, the data is further associated, merged and/or classified for storage.
8. A computer-readable storage medium, having stored thereon a processing system, which when executed by a processor, carries out the steps of the method of data table archiving processing according to any one of claims 4 to 7.
Priority Applications (2)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710916067.3A CN107870981B (en) | 2017-09-30 | 2017-09-30 | Electronic device, data sheet filing method and storage medium |
| PCT/CN2018/089708 WO2019062189A1 (en) | 2017-09-30 | 2018-06-03 | Electronic device, method and system for conducting data table filing processing, and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710916067.3A CN107870981B (en) | 2017-09-30 | 2017-09-30 | Electronic device, data sheet filing method and storage medium |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107870981A CN107870981A (en) | 2018-04-03 |
| CN107870981B true CN107870981B (en) | 2021-10-22 |
Family
ID=61752728
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710916067.3A Active CN107870981B (en) | 2017-09-30 | 2017-09-30 | Electronic device, data sheet filing method and storage medium |
Country Status (2)
| Country | Link |
|---|---|
| CN (1) | CN107870981B (en) |
| WO (1) | WO2019062189A1 (en) |
Families Citing this family (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107870981B (en) * | 2017-09-30 | 2021-10-22 | 平安科技（深圳）有限公司 | Electronic device, data sheet filing method and storage medium |
| CN109815094B (en) * | 2019-01-04 | 2023-01-10 | 平安科技（深圳）有限公司 | Data table monitoring method, device, equipment and computer readable storage medium |
| CN110362531A (en) * | 2019-06-17 | 2019-10-22 | 众安在线财产保险股份有限公司 | A kind of automatic archiving method and device |
| CN110457255B (en) * | 2019-07-05 | 2023-11-21 | 中国平安人寿保险股份有限公司 | Method, server and computer readable storage medium for archiving data |
| CN110888774B (en) * | 2019-11-07 | 2023-06-23 | 中盈优创资讯科技有限公司 | HBASE-based big data report processing method and device |
| CN111190898B (en) * | 2019-11-25 | 2023-07-14 | 泰康保险集团股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN113448939A (en) * | 2020-03-24 | 2021-09-28 | 北京有限元科技有限公司 | Data archiving and storing method and device and storage medium |
| CN112817834B (en) * | 2021-01-22 | 2022-11-01 | 上海哔哩哔哩科技有限公司 | Data table evaluation method and device |
| CN112783732B (en) * | 2021-01-29 | 2023-10-10 | 中国农业银行股份有限公司 | Database table capacity monitoring method and device |
| CN112988664B (en) * | 2021-03-11 | 2023-05-30 | 中国平安财产保险股份有限公司 | Data archiving method, device, equipment and storage medium |
| CN113821501B (en) * | 2021-08-12 | 2023-05-16 | 马上消费金融股份有限公司 | Data archiving method and device |
| CN116756089B (en) * | 2023-08-21 | 2023-11-03 | 湖南云档信息科技有限公司 | File archiving scheme forming method, system and storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
| CN101364897A (en) * | 2008-09-17 | 2009-02-11 | 中兴通讯股份有限公司 | System for historical data archiving and implementing method |
| CN101639839A (en) * | 2008-07-30 | 2010-02-03 | 中兴通讯股份有限公司 | Method for searching multi-archive file based on temporary table |
| CN102930062A (en) * | 2012-11-30 | 2013-02-13 | 南京富士通南大软件技术有限公司 | Rapid horizontal extending method for databases |
| CN103106247A (en) * | 2012-12-31 | 2013-05-15 | 普天新能源有限责任公司 | Data dump method and system |
| CN103514295A (en) * | 2013-10-10 | 2014-01-15 | 中国电子科技集团公司第十五研究所 | Method and device for archiving historical data |
| CN104899491A (en) * | 2015-05-28 | 2015-09-09 | 广东欧珀移动通信有限公司 | Data transfer method and apparatus thereof |
| CN106446271A (en) * | 2016-10-20 | 2017-02-22 | 焦点科技股份有限公司 | Design method of BI data interface |
Family Cites Families (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090198699A1 (en) * | 2008-01-31 | 2009-08-06 | International Business Machines Corporation | Remote space efficient repository |
| US8782369B2 (en) * | 2011-11-15 | 2014-07-15 | Lsi Corporation | Apparatus to manage efficient data migration between tiers |
| US9396131B1 (en) * | 2013-02-08 | 2016-07-19 | Workday, Inc. | Dynamic three-tier data storage utilization |
| CN104462461B (en) * | 2014-12-16 | 2017-09-29 | 用友网络科技股份有限公司 | The method and device of investigation processing empty value is carried out to list |
| CN104636483A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Data monitoring method |
| CN106156038B (en) * | 2015-03-26 | 2019-11-29 | 腾讯科技（深圳）有限公司 | Date storage method and device |
| CN104881477B (en) * | 2015-06-03 | 2018-09-21 | 上海新炬网络信息技术股份有限公司 | A kind of application data space uses evaluation method |
| CN107870981B (en) * | 2017-09-30 | 2021-10-22 | 平安科技（深圳）有限公司 | Electronic device, data sheet filing method and storage medium |
-
2017
- 2017-09-30 CN CN201710916067.3A patent/CN107870981B/en active Active
-
2018
- 2018-06-03 WO PCT/CN2018/089708 patent/WO2019062189A1/en active Application Filing
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101639839A (en) * | 2008-07-30 | 2010-02-03 | 中兴通讯股份有限公司 | Method for searching multi-archive file based on temporary table |
| CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
| CN101364897A (en) * | 2008-09-17 | 2009-02-11 | 中兴通讯股份有限公司 | System for historical data archiving and implementing method |
| CN102930062A (en) * | 2012-11-30 | 2013-02-13 | 南京富士通南大软件技术有限公司 | Rapid horizontal extending method for databases |
| CN103106247A (en) * | 2012-12-31 | 2013-05-15 | 普天新能源有限责任公司 | Data dump method and system |
| CN103514295A (en) * | 2013-10-10 | 2014-01-15 | 中国电子科技集团公司第十五研究所 | Method and device for archiving historical data |
| CN104899491A (en) * | 2015-05-28 | 2015-09-09 | 广东欧珀移动通信有限公司 | Data transfer method and apparatus thereof |
| CN106446271A (en) * | 2016-10-20 | 2017-02-22 | 焦点科技股份有限公司 | Design method of BI data interface |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107870981A (en) | 2018-04-03 |
| WO2019062189A1 (en) | 2019-04-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107870981B (en) | Electronic device, data sheet filing method and storage medium | |
| CN108848039B (en) | Server, message distribution method and storage medium | |
| US9507946B2 (en) | Program vulnerability identification | |
| CN109241772B (en) | Invoice block chain recording method, invoice block chain recording device, block chain gateway server and invoice block chain recording medium | |
| CN112507027A (en) | Incremental data synchronization method, device, equipment and medium based on Kafka | |
| CN110168529A (en) | Date storage method, device and storage medium | |
| CN108134696A (en) | A kind of micro services configuration update method and device | |
| CN111399909A (en) | Service system data distribution processing method, device and storage medium | |
| CN113780991A (en) | Dynamic cost control method and device for construction engineering project and electronic equipment | |
| CN112506486A (en) | Search system establishing method and device, electronic equipment and readable storage medium | |
| CN104881454A (en) | Updating method and system of parameter | |
| CN111274256A (en) | Resource control method, device, equipment and storage medium based on time sequence database | |
| CN113391901A (en) | RPA robot management method, device, equipment and storage medium | |
| CN111694505B (en) | Data storage management method, device and computer readable storage medium | |
| CN111881252A (en) | Work report processing method and device, computer equipment and storage medium | |
| CN103270520A (en) | Importance class based data management | |
| CN110737727B (en) | Data processing method and system | |
| CN109743179A (en) | A kind of electronics license signs and issues method on demand | |
| CN112416934A (en) | hive table incremental data synchronization method and device, computer equipment and storage medium | |
| CN110569114B (en) | Service processing method, device, equipment and storage medium | |
| CN110443441B (en) | Rule efficiency monitoring method, device, computer equipment and storage medium | |
| CN110347546B (en) | Dynamic adjustment method, device, medium and electronic equipment for monitoring task | |
| CN115471215B (en) | Business process processing method and device | |
| CN110471730A (en) | Methods of exhibiting, system, big screen system and medium based on Echarts | |
| CN115794804A (en) | Engineering internal control data visualization processing system and method based on big data technology |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |