CN107870981A - Electronic installation, the method and storage medium of tables of data filing processing - Google Patents
Electronic installation, the method and storage medium of tables of data filing processing Download PDFInfo
- Publication number
- CN107870981A CN107870981A CN201710916067.3A CN201710916067A CN107870981A CN 107870981 A CN107870981 A CN 107870981A CN 201710916067 A CN201710916067 A CN 201710916067A CN 107870981 A CN107870981 A CN 107870981A
- Authority
- CN
- China
- Prior art keywords
- data
- tables
- processing
- magnitude
- filing
- 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.)
- Granted
Links
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)
- Accounting & Taxation (AREA)
- Finance (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Quality & Reliability (AREA)
- Computing Systems (AREA)
- Economics (AREA)
- General Business, Economics & Management (AREA)
- Mathematical Physics (AREA)
- Technology Law (AREA)
- Strategic Management (AREA)
- Software Systems (AREA)
- Marketing (AREA)
- Development Economics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The present invention relates to a kind of electronic installation, the method and storage medium of tables of data filing processing, the electronic installation includes memory and the processor being connected with the memory, the processing system that can be run on the processor is stored with the memory, following steps are realized when the processing system is by the computing device：The monitoring table being monitored to each tables of data in FAS financial databases is established, the change information of the data magnitude based on the monitoring each tables of data of table analysis；When the data magnitude for having tables of data becomes big and meets default condition, generation includes the prompting message of the tables of data current information；The processing rule based on tables of data current information setting is obtained, filing processing is carried out to the tables of data based on the processing rule.The present invention can the excessive tables of data of data magnitude in timely processing FAS financial databases, filed, lifting system performance, be easy to the management and maintenance of system.
Description
Technical field
The present invention relates to database technical field, more particularly to a kind of method of electronic installation, tables of data filing processing and
Storage medium.
Background technology
With the use of FAS (Financial Accounting Standards) financial system, have increasing
The data magnitude of tables of data becomes very big, such as the data magnitude of some tables of data has reached million, or even has a small amount of
The data magnitude of tables of data has reached necessarily or crossed hundred million, and the data magnitude of tables of data is excessive to influence the systematicness such as search efficiency
Energy.In the prior art, the scheme that the schemes such as table change available data storage organization can be divided using point storehouse to solve in database
The problem of data are more, it is contemplated that the complexity that data associate in itself and between data in FAS financial systems, using this kind
Scheme operation is more complicated, it is larger that existing system is impacted, thus can not be applied in practice, thus, to FAS financial systems
The larger single table of middle data magnitude carries out timely processing, to improve systematic function as there is the problem of to be solved.
The content of the invention
It is an object of the invention to provide a kind of electronic installation, the method and storage medium of tables of data filing processing, it is intended to
The excessive tables of data of data magnitude, is filed in timely processing FAS financial databases.
To achieve the above object, the present invention provides a kind of electronic installation, the electronic installation include memory and with it is described
The processor of memory connection, is stored with the processing system that can be run on the processor, the processing in the memory
Following steps are realized when system is by the computing device：
S101, the monitoring table being monitored to each tables of data in FAS financial databases is established, based on the monitoring table
Analyze the change information of the data magnitude of each tables of data；
S102, when the data magnitude for having tables of data becomes big and meets default condition, generation is current comprising the tables of data
The prompting message of information；
S103, the processing rule based on tables of data current information setting is obtained, based on the processing rule to the tables of data
Carry out filing processing.
Preferably, the change information of the data magnitude based on the monitoring each tables of data of table analysis in the step S101
Including：
The data magnitude of each tables of data in table in FAS databases is monitored described in timing acquisition, analyzes each tables of data
Data magnitude whether reach predetermined threshold value；Or
The data magnitude of each tables of data in table in FAS databases is monitored described in timing acquisition, calculates each tables of data
Data magnitude whether interior amplification, the amplification for analyzing the data magnitude of each tables of data reach default in predetermined time interval
Amplitude.
Preferably, the tables of data current information includes type information, and the type information includes type of service and non-industry
Service type, the processing rule, which includes the first processing rule and second processing rule, the step S103, to be included：
If the type of service of tables of data is non-traffic type, obtain at first based on the non-traffic type set
Reason rule, filing processing is carried out to the tables of data based on the first processing rule；
If the type of service of tables of data is type of service, the second processing rule based on type of service setting are obtained
Then, filing processing is carried out to the tables of data based on the second processing rule.
Preferably, the first processing rule includes：Distribution task, will based on the task timing distributed to the tables of data
Data migration in the tables of data is into corresponding filing table, or retains partial data predetermined in the tables of data, and is based on
The task timing distributed is by the data migration that other are not retained into corresponding filing table；
The second processing rule includes：Distribution task retains partial data predetermined in the tables of data to the tables of data,
And based on being distributed for task regularly by the data migration that other are not retained into corresponding filing table.
To achieve the above object, the present invention also provides a kind of method of tables of data filing processing, and methods described includes：
S1, the monitoring table being monitored to each tables of data in FAS financial databases is established, based on the monitoring table point
Analyse the change information of the data magnitude of each tables of data；
S2, when the data magnitude for having tables of data becomes big and meets default condition, generation is currently believed comprising the tables of data
The prompting message of breath；
S3, the processing rule based on tables of data current information setting is obtained, the tables of data is entered based on the processing rule
Row filing is handled.
Preferably, the change information bag of the data magnitude based on the monitoring each tables of data of table analysis in the step S1
Include：
The data magnitude of each tables of data in table in FAS databases is monitored described in timing acquisition, analyzes each tables of data
Data magnitude whether reach predetermined threshold value；Or
The data magnitude of each tables of data in table in FAS databases is monitored described in timing acquisition, calculates each tables of data
Data magnitude whether interior amplification, the amplification for analyzing the data magnitude of each tables of data reach default in predetermined time interval
Amplitude.
Preferably, the tables of data current information includes type information, and the type information includes type of service and non-industry
Service type, the processing rule, which includes the first processing rule and second processing rule, the step S3, to be included：
If the type of service of tables of data is non-traffic type, obtain at first based on the non-traffic type set
Reason rule, filing processing is carried out to the tables of data based on the first processing rule；
If the type of service of tables of data is type of service, the second processing rule based on type of service setting are obtained
Then, filing processing is carried out to the tables of data based on the second processing rule.
Preferably, the first processing rule includes：Distribution task, will based on the task timing distributed to the tables of data
Data migration in the tables of data is into corresponding filing table, or retains partial data predetermined in the tables of data, and is based on
The task timing distributed is by the data migration that other are not retained into corresponding filing table；
The second processing rule includes：Distribution task retains partial data predetermined in the tables of data to the tables of data,
And based on being distributed for task regularly by the data migration that other are not retained into corresponding filing table.
Preferably, when by data migration into corresponding filing table, processing, merging treatment also are associated to the data
And/or classification preserves.
The present invention also provides a kind of computer-readable recording medium, and processing is stored with the computer-readable recording medium
System, the processing system realize the step of above-mentioned tables of data files the method for processing when being executed by processor.
The beneficial effects of the invention are as follows：The present invention establishes the data magnitude to each tables of data in FAS financial databases
The monitoring table being monitored, when the larger or amplification of data magnitude change for having tables of data is larger, obtain processing rule set in advance
Then or processing rule corresponding to maintenance personal's site setup is reminded, filing processing is carried out to tables of data according to the processing rule,
The present invention can the excessive tables of data of data magnitude in timely processing FAS financial databases, filed, lifting system
Can, it is easy to the management and maintenance of system.
Brief description of the drawings
Fig. 1 is each optional application environment schematic diagram of embodiment one of the present invention；
Fig. 2 is the schematic flow sheet of the embodiment of method one of tables of data of the present invention filing processing.
Embodiment
In order to make the purpose , technical scheme and advantage of the present invention be clearer, it is right below in conjunction with drawings and Examples
The present invention is further elaborated.It should be appreciated that specific embodiment described herein is only to explain the present invention, not
For limiting the present invention.Based on the embodiment in the present invention, those of ordinary skill in the art are not before creative work is made
The every other embodiment obtained is put, belongs to the scope of protection of the invention.
It should be noted that the description for being related to " first ", " second " etc. in the present invention is only used for describing purpose, and can not
It is interpreted as indicating or implies its relative importance or imply the quantity of the technical characteristic indicated by indicating.Thus, define " the
One ", at least one this feature can be expressed or be implicitly included to the feature of " second ".In addition, the skill between each embodiment
Art scheme can be combined with each other, but must can be implemented as basis with those of ordinary skill in the art, when technical scheme
With reference to occurring conflicting or will be understood that the combination of this technical scheme is not present when can not realize, also not in application claims
Protection domain within.
As shown in fig.1, it is the application environment schematic diagram of the preferred embodiment of the method for tables of data filing processing of the present invention.
The application environment schematic diagram includes electronic installation 1 and terminal device 2.Electronic installation 1 can pass through network, near-field communication technology etc.
Suitable technology carries out data interaction with terminal device 2.
The terminal device 2, which includes, but not limited to any one, to pass through keyboard, mouse, remote control, touch with user
The mode such as plate or voice-operated device carries out the electronic product of man-machine interaction, for example, personal computer, tablet personal computer, smart mobile phone,
Personal digital assistant (Personal Digital Assistant, PDA), game machine, IPTV (Internet
Protocol Television, IPTV), intellectual Wearable, the movable equipment of guider etc., or such as
The fixed terminal of digital TV, desktop computer, notebook, server etc..Terminal device 2 establishes the finger of monitoring table to receive
Make and be sent to electronic installation, and receive the processing rule of attendant's site setup etc..
The electronic installation 1 be it is a kind of can according to the instruction for being previously set or storing, it is automatic carry out numerical computations and/
Or the equipment of information processing.The electronic installation 1 can be computer, can also be single network server, multiple networks clothes
It is engaged in the server group either cloud being made up of a large amount of main frames or the webserver based on cloud computing of device composition, wherein cloud computing
It is one kind of Distributed Calculation, a super virtual computer being made up of the computer collection of a group loose couplings.
In the present embodiment, electronic installation 1 may include, but be not limited only to, and can be in communication with each other connection by system bus
Memory 11, processor 12, network interface 13, memory 11 are stored with the processing system that can be run on the processor 12.Need
, it is noted that Fig. 1 illustrate only the electronic installation 1 with component 11-13, it should be understood that being not required for implementing to own
The component shown, what can be substituted implements more or less components.
Wherein, memory 11 includes internal memory and the readable storage medium storing program for executing of at least one type.Inside save as the fortune of electronic installation 1
Row provides caching；Readable storage medium storing program for executing can be if flash memory, hard disk, multimedia card, card-type memory are (for example, SD or DX memories
Deng), random access storage device (RAM), static random-access memory (SRAM), read-only storage (ROM), electric erasable can compile
Journey read-only storage (EEPROM), programmable read only memory (PROM), magnetic storage, disk, CD etc. it is non-volatile
Storage medium.In certain embodiments, readable storage medium storing program for executing can be the internal storage unit of electronic installation 1, such as the electronics
The hard disk of device 1；In further embodiments, the non-volatile memory medium can also be that the external storage of electronic installation 1 is set
Plug-in type hard disk that is standby, such as being equipped with electronic installation 1, intelligent memory card (Smart Media Card, SMC), secure digital
(Secure Digital, SD) blocks, flash card (Flash Card) etc..In the present embodiment, the readable storage medium storing program for executing of memory 11
It is generally used for operating system and types of applications software that storage is installed on electronic installation 1, such as the place in one embodiment of the invention
Program code of reason system etc..Export or will export each in addition, memory 11 can be also used for temporarily storing
Class data.
The processor 12 can be in certain embodiments central processing unit (Central Processing Unit,
CPU), controller, microcontroller, microprocessor or other data processing chips.The processor 12 is generally used for controlling the electricity
The overall operation of sub-device 1, such as perform the control and processing related to the terminal device 2 progress data interaction or communication
Deng.In the present embodiment, the processor 12 is used to run the program code stored in the memory 11 or processing data, example
Such as run processing system.
The network interface 13 may include radio network interface or wired network interface, and the network interface 13 is generally used for
Communication connection is established between the electronic installation 1 and other electronic equipments.In the present embodiment, network interface 13 is mainly used in electricity
Sub-device 1 is connected with one or more terminal devices 2, and data are established between electronic installation 1 and one or more terminal devices 2
Transmission channel and communication connection.
Processing system is stored in memory 11, including at least one computer-readable finger being stored in memory 11
Order, at least one computer-readable instruction can be performed by processor device 12, to realize the method for each embodiment of the application；With
And at least one computer-readable instruction is different according to the function that its each several part is realized, can be divided into different logic moulds
Block.
In one embodiment, following steps are realized when above-mentioned processing system is performed by the processor 12：
Step S101, the monitoring table being monitored to each tables of data in FAS financial databases is established, based on the prison
Control the change information of the data magnitude of each tables of data of table analysis；
In the present embodiment, there is a fairly large number of tables of data in FAS financial databases, establish monitoring table with to each data
Table is monitored.Wherein, in table is monitored, including the title of tables of data, data magnitude, type information and temporal information, for example,
The title for recording each tables of data to be monitored in table in the form of table 1, table 2 ... table n is monitored, is referred to as in the name of each tables of data
Afterwards, data magnitude, type information and temporal information corresponding to record, such as table 1, one is recorded after table 1 in monitoring table
It is individual or it is multiple its each predetermined time data magnitude.Each tables of data has corresponding type information, including business
Type and non-traffic type, it is business datum table or non-traffic tables of data to distinguish the tables of data.
In the present embodiment, each tables of data in FAS financial databases can be monitored in real time, such as by each number
Change with time and recorded according to the data magnitude of table, or timing is carried out to each tables of data in FAS financial databases
Monitoring, it is preferable that regularly tables of data is monitored, such as every 1 hour or 5 hours data volumes for catching each tables of data
Level, or time for catching its data magnitude etc., the data magnitude that will be captured are set according to the actual conditions of each tables of data
It is recorded in monitoring table.
In FAS financial databases, if some tables of data adds new data, the data magnitude of the tables of data becomes
Greatly.When for the change information of a certain spreadsheet analysis its data magnitude, it is preferable that FAS in table can be monitored with timing acquisition
Whether the data magnitude of each tables of data in database, the data magnitude for analyzing each tables of data reach predetermined threshold value, such as
Whether data magnitude reaches million grades；Or obtain each tables of data in monitoring table in FAS databases every preset time
Data magnitude, the amplification of the data magnitude of each tables of data is calculated, whether the amplification for analyzing the data magnitude of each tables of data reaches
It is time interval to predetermined amplitude, such as with one month, analyzing the data volume level of a certain tables of data, continuously bimestrial amplification is
It is no to reach predetermined threshold value (such as amplification is 100%).
Step S102, when the data magnitude for having tables of data becomes big and meets default condition, generation includes the tables of data
The prompting message of current information；
In the present embodiment, when the data magnitude for having tables of data becomes big and meets default condition, such as the number of tables of data
Become big according to magnitude and reach default threshold value, or data magnitude becomes big and prefixed time interval amplification and reaches default threshold value
When, generation includes the prompting message of the tables of data current information, and wherein tables of data current information includes title, the data of tables of data
Magnitude and type information.The prompting message is used to remind attendant to handle tables of data.
Wherein, the prompting message can be sent in predetermined terminal and being reminded in a pre-defined format, or be sent
On the mobile terminal worn to attendant and reminded, the predetermined form of the prompting message is, for example, " table 1, data volume
Level * *, type information * * ".
Step S103, the processing rule based on tables of data current information setting is obtained, based on the processing rule to the number
Filing processing is carried out according to table.
Wherein, in one embodiment, it can be that attendant is set in advance to handle rule, and it includes a variety of, each processing
Rule association corresponding with the data magnitude and type information of tables of data, the prompting message of the tables of data current information is included in generation
Afterwards, processing rule set in advance is obtained based on the current information in the prompting message automatically, based on the processing rule to the number
Filing processing is carried out according to table.In other embodiments, the processing rule can be that attendant scene is configured, that is, work as dimension
When shield civilian receives the prompting message for the tables of data in FAS financial databases, data magnitude and type based on tables of data
Information sets out corresponding processing rule to the tables of data, and filing processing is carried out to the tables of data based on the processing rule.
Wherein, it can be that periodically tables of data is filed or directly carried out total data table to handle rule
Filing etc..
Compared with prior art, the present embodiment is established grading to the data volume of each tables of data in FAS financial databases
The monitoring table of row monitoring, when the larger or amplification of data magnitude change for having tables of data is larger, obtain processing rule set in advance
Or processing rule corresponding to maintenance personal's site setup is reminded, filing processing is carried out to tables of data according to the processing rule, this
Embodiment can the excessive tables of data of data magnitude in timely processing FAS financial databases, filed, lifting system
Can, it is easy to the management and maintenance of system.
In a preferred embodiment, on the basis of above-mentioned Fig. 1 embodiment, the step S103 includes：If data
The type of service of table is non-traffic type, then the first processing rule based on the non-traffic type set is obtained, based on this
First processing rule carries out filing processing to the tables of data；If the type of service of tables of data is type of service, acquisition is based on institute
The second processing rule of type of service setting is stated, filing processing is carried out to the tables of data based on the second processing rule.
In one embodiment, processing rule includes attendant's the first processing rule set in advance and attendant scene
Second processing rule is configured, type information includes type of service (such as expense report, render an account list or invoice etc.) and non-traffic
Type (such as approval record table etc.)：If the type of service of tables of data is non-traffic type, acquisition is based on the non-traffic class
First processing rule corresponding to type setting, filing processing is carried out to the tables of data based on the first processing rule；If tables of data
Type of service is type of service, then obtains based on second processing rule corresponding to type of service setting, based on this at second
Reason rule carries out filing processing to the tables of data.The present embodiment provides the flexible mode for setting processing rule so that data volume
The big tables of data of level is filed according to the processing rule based on different actual conditions.
Preferably, the first processing rule includes：Distribution task is counted this based on the task timing distributed to the tables of data
According to the data migration in table into corresponding filing table, or retain partial data predetermined in the tables of data, and be based on dividing
The task timing matched somebody with somebody is by the data migration that other are not retained into corresponding filing table；Second processing rule includes：Distribution
Task retains partial data predetermined in the tables of data, and do not enter other based on the task timing distributed to the tables of data
The data migration that row retains is into corresponding filing table.In other examples, other processing rules can be set, such as
Directly the data in the tables of data are all filed into filing table, etc., no longer illustrate one by one herein.
In the present embodiment, it for example can be daily periodically by previous year in the tables of data to distribute to the task of tables of data
Data migration to file table in, until by all data migrations of the previous year of the tables of data into the filing table；Or protect
The partial data of previous year in the tables of data is stayed, other data of previous year are periodically migrated in filing table daily, directly
Extremely the partial data is all migrated in the filing table.
In specific implementation process, when the data in tables of data are filed, associated data can be carried out
The data repeated are merged processing, and the value for preservation according to data by association process, and preservation etc. of classifying is carried out to data
Deng in favor of preservation and follow-up utilization.
As shown in Fig. 2 Fig. 2 is the schematic flow sheet of the embodiment of method one of tables of data of the present invention filing processing, the data
The method of table filing processing comprises the following steps：
Step S1, the monitoring table being monitored to each tables of data in FAS financial databases is established, based on the monitoring
The change information of the data magnitude of each tables of data of table analysis；
In the present embodiment, there is a fairly large number of tables of data in FAS financial databases, establish monitoring table with to each data
Table is monitored.Wherein, in table is monitored, including the title of tables of data, data magnitude, type information and temporal information, for example,
The title for recording each tables of data to be monitored in table in the form of table 1, table 2 ... table n is monitored, is referred to as in the name of each tables of data
Afterwards, data magnitude, type information and temporal information corresponding to record, such as table 1, one is recorded after table 1 in monitoring table
It is individual or it is multiple its each predetermined time data magnitude.Each tables of data has corresponding type information, including business
Type and non-traffic type, it is business datum table or non-traffic tables of data to distinguish the tables of data.
In the present embodiment, each tables of data in FAS financial databases can be monitored in real time, such as by each number
Change with time and recorded according to the data magnitude of table, or timing is carried out to each tables of data in FAS financial databases
Monitoring, it is preferable that regularly tables of data is monitored, such as every 1 hour or 5 hours data volumes for catching each tables of data
Level, or time for catching its data magnitude etc., the data magnitude that will be captured are set according to the actual conditions of each tables of data
It is recorded in monitoring table.
In FAS financial databases, if some tables of data adds new data, the data magnitude of the tables of data becomes
Greatly.When for the change information of a certain spreadsheet analysis its data magnitude, it is preferable that FAS in table can be monitored with timing acquisition
Whether the data magnitude of each tables of data in database, the data magnitude for analyzing each tables of data reach predetermined threshold value, such as
Whether data magnitude reaches million grades；Or obtain each tables of data in monitoring table in FAS databases every preset time
Data magnitude, the amplification of the data magnitude of each tables of data is calculated, whether the amplification for analyzing the data magnitude of each tables of data reaches
It is time interval to predetermined amplitude, such as with one month, analyzing the data volume level of a certain tables of data, continuously bimestrial amplification is
It is no to reach predetermined threshold value (such as amplification is 100%).
Step S2, when the data magnitude for having tables of data becomes big and meets default condition, generation is worked as comprising the tables of data
The prompting message of preceding information；
In the present embodiment, when the data magnitude for having tables of data becomes big and meets default condition, such as the number of tables of data
Become big according to magnitude and reach default threshold value, or data magnitude becomes big and prefixed time interval amplification and reaches default threshold value
When, generation includes the prompting message of the tables of data current information, and wherein tables of data current information includes title, the data of tables of data
Magnitude and type information.The prompting message is used to remind attendant to handle tables of data.
Wherein, the prompting message can be sent in predetermined terminal and being reminded in a pre-defined format, or be sent
On the mobile terminal worn to attendant and reminded, the predetermined form of the prompting message is, for example, " table 1, data volume
Level * *, type information * * ".
Step S3, the processing rule based on tables of data current information setting is obtained, based on the processing rule to the data
Table carries out filing processing.
Wherein, in one embodiment, it can be that attendant is set in advance to handle rule, and it includes a variety of, each processing
Rule association corresponding with the data magnitude and type information of tables of data, the prompting message of the tables of data current information is included in generation
Afterwards, processing rule set in advance is obtained based on the current information in the prompting message automatically, based on the processing rule to the number
Filing processing is carried out according to table.In other embodiments, the processing rule can be that attendant scene is configured, that is, work as dimension
When shield civilian receives the prompting message for the tables of data in FAS financial databases, data magnitude and type based on tables of data
Information sets out corresponding processing rule to the tables of data, and filing processing is carried out to the tables of data based on the processing rule.
Wherein, it can be that periodically tables of data is filed or directly carried out total data table to handle rule
Filing etc..
Compared with prior art, the present embodiment is established grading to the data volume of each tables of data in FAS financial databases
The monitoring table of row monitoring, when the larger or amplification of data magnitude change for having tables of data is larger, obtain processing rule set in advance
Or processing rule corresponding to maintenance personal's site setup is reminded, filing processing is carried out to tables of data according to the processing rule, this
Embodiment can the excessive tables of data of data magnitude in timely processing FAS financial databases, filed, lifting system
Can, it is easy to the management and maintenance of system.
In a preferred embodiment, on the basis of above-mentioned Fig. 2 embodiment, the step S3 includes：If tables of data
Type of service be non-traffic type, then obtain the first processing rule based on the non-traffic type set, based on this
One processing rule carries out filing processing to the tables of data；If the type of service of tables of data is type of service, obtain based on described
The second processing rule of type of service setting, filing processing is carried out based on the second processing rule to the tables of data.
In one embodiment, processing rule includes attendant's the first processing rule set in advance and attendant scene
Second processing rule is configured, type information includes type of service (such as expense report, render an account list or invoice etc.) and non-traffic
Type (such as approval record table etc.)：If the type of service of tables of data is non-traffic type, acquisition is based on the non-traffic class
First processing rule corresponding to type setting, filing processing is carried out to the tables of data based on the first processing rule；If tables of data
Type of service is type of service, then obtains based on second processing rule corresponding to type of service setting, based on this at second
Reason rule carries out filing processing to the tables of data.The present embodiment provides the flexible mode for setting processing rule so that data volume
The big tables of data of level is filed according to the processing rule based on different actual conditions.
Preferably, the first processing rule includes：Distribution task is counted this based on the task timing distributed to the tables of data
According to the data migration in table into corresponding filing table, or retain partial data predetermined in the tables of data, and be based on dividing
The task timing matched somebody with somebody is by the data migration that other are not retained into corresponding filing table；Second processing rule includes：Distribution
Task retains partial data predetermined in the tables of data, and do not enter other based on the task timing distributed to the tables of data
The data migration that row retains is into corresponding filing table.In other examples, other processing rules can be set, such as
Directly the data in the tables of data are all filed into filing table, etc., no longer illustrate one by one herein.
In the present embodiment, it for example can be daily periodically by previous year in the tables of data to distribute to the task of tables of data
Data migration to file table in, until by all data migrations of the previous year of the tables of data into the filing table；Or protect
The partial data of previous year in the tables of data is stayed, other data of previous year are periodically migrated in filing table daily, directly
Extremely the partial data is all migrated in the filing table.
In specific implementation process, when the data in tables of data are filed, associated data can be carried out
The data repeated are merged processing, and the value for preservation according to data by association process, and preservation etc. of classifying is carried out to data
Deng in favor of preservation and follow-up utilization.
The present invention also provides a kind of computer-readable recording medium, and processing is stored with the computer-readable recording medium
System, the processing system realize the step of above-mentioned tables of data files the method for processing when being executed by processor.
The embodiments of the present invention are for illustration only, do not represent the quality of embodiment.
Through the above description of the embodiments, those skilled in the art can be understood that above-described embodiment side
Method can add the mode of required general hardware platform to realize by software, naturally it is also possible to by hardware, but in many cases
The former is more preferably embodiment.Based on such understanding, technical scheme is substantially done to prior art in other words
Going out the part of contribution can be embodied in the form of software product, and the computer software product is stored in a storage medium
In (such as ROM/RAM, magnetic disc, CD), including some instructions to cause a station terminal equipment (can be mobile phone, computer, clothes
Be engaged in device, air conditioner, or network equipment etc.) perform method described in each embodiment of the present invention.
The preferred embodiments of the present invention are these are only, are not intended to limit the scope of the invention, it is every to utilize this hair
The equivalent structure or equivalent flow conversion that bright specification and accompanying drawing content are made, or directly or indirectly it is used in other related skills
Art field, is included within the scope of the present invention.
Claims (10)
1. a kind of electronic installation, it is characterised in that the electronic installation includes memory and the processing being connected with the memory
Device, the processing system that can be run on the processor is stored with the memory, the processing system is by the processor
Following steps are realized during execution：
S101, the monitoring table being monitored to each tables of data in FAS financial databases is established, based on the monitoring table analysis
The change information of the data magnitude of each tables of data；
S102, when the data magnitude for having tables of data becomes big and meets default condition, generation includes the tables of data current information
Prompting message；
S103, obtains the processing rule based on tables of data current information setting, and the tables of data is carried out based on the processing rule
Filing is handled.
2. electronic installation according to claim 1, it is characterised in that the monitoring table analysis is based in the step S101
The change information of the data magnitude of each tables of data includes：
The data magnitude of each tables of data in table in FAS databases is monitored described in timing acquisition, analyzes the number of each tables of data
Whether reach predetermined threshold value according to magnitude；Or
The data magnitude of each tables of data in table in FAS databases is monitored described in timing acquisition, calculates the number of each tables of data
According to magnitude, whether interior amplification, the amplification for analyzing the data magnitude of each tables of data reach default width in predetermined time interval
Degree.
3. electronic installation according to claim 1 or 2, it is characterised in that the tables of data current information is believed including type
Breath, the type information include type of service and non-traffic type, and the processing rule is included at the first processing rule and second
Reason rule, the step S103 include：
If the type of service of tables of data is non-traffic type, the first processing rule based on the non-traffic type set are obtained
Then, filing processing is carried out to the tables of data based on the first processing rule；
If the type of service of tables of data is type of service, the second processing rule based on type of service setting, base are obtained
Filing processing is carried out to the tables of data in the second processing rule.
4. electronic installation according to claim 3, it is characterised in that the first processing rule includes：Distribution task is extremely
The tables of data, based on being distributed for task regularly by the data migration in the tables of data into corresponding filing table, or retain
Predetermined partial data in the tables of data, and based on the task timing distributed by the data migration that other are not retained to right
In the filing table answered；
The second processing rule includes：Distribution task retains partial data predetermined in the tables of data, and base to the tables of data
In being distributed for task regularly by the data migration that other are not retained into corresponding filing table.
A kind of 5. method of tables of data filing processing, it is characterised in that methods described includes：
S1, the monitoring table being monitored to each tables of data in FAS financial databases is established, it is each based on the monitoring table analysis
The change information of the data magnitude of individual tables of data；
S2, when the data magnitude for having tables of data becomes big and meets default condition, generation includes the tables of data current information
Prompting message；
S3, the processing rule based on tables of data current information setting is obtained, the tables of data is returned based on the processing rule
Shelves processing.
6. the method for tables of data filing processing according to claim 5, it is characterised in that based on described in the step S1
Monitoring the change information of the data magnitude of each tables of data of table analysis includes：
The data magnitude of each tables of data in table in FAS databases is monitored described in timing acquisition, analyzes the number of each tables of data
Whether reach predetermined threshold value according to magnitude；Or
The data magnitude of each tables of data in table in FAS databases is monitored described in timing acquisition, calculates the number of each tables of data
According to magnitude, whether interior amplification, the amplification for analyzing the data magnitude of each tables of data reach default width in predetermined time interval
Degree.
7. the method for the tables of data filing processing according to claim 5 or 6, it is characterised in that the tables of data is currently believed
Breath includes type information, and the type information includes type of service and non-traffic type, and the processing rule includes the first processing
Rule and second processing rule, the step S3 include：
If the type of service of tables of data is non-traffic type, the first processing rule based on the non-traffic type set are obtained
Then, filing processing is carried out to the tables of data based on the first processing rule；
If the type of service of tables of data is type of service, the second processing rule based on type of service setting, base are obtained
Filing processing is carried out to the tables of data in the second processing rule.
8. the method for tables of data filing processing according to claim 7, it is characterised in that the first processing rule bag
Include：Distribution task is to the tables of data, based on being distributed for task regularly by the data migration in the tables of data to corresponding filing
In table, or retain partial data predetermined in the tables of data, and do not retained other based on the task timing distributed
Data migration to it is corresponding filing table in；
The second processing rule includes：Distribution task retains partial data predetermined in the tables of data, and base to the tables of data
In being distributed for task regularly by the data migration that other are not retained into corresponding filing table.
9. the method for tables of data according to claim 8 filing processing, it is characterised in that by data migration to corresponding
When filing in table, also the data are associated with processing, merging treatment and/or classification and is preserved.
10. a kind of computer-readable recording medium, it is characterised in that be stored with processing system on the computer-readable recording medium
System, the tables of data filing processing as any one of claim 5 to 9 is realized when the processing system is executed by processor
The step of method.
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 true CN107870981A (en) | 2018-04-03 |
| CN107870981B 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) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019062189A1 (en) * | 2017-09-30 | 2019-04-04 | 平安科技（深圳）有限公司 | Electronic device, method and system for conducting data table filing processing, and storage medium |
| CN109815094A (en) * | 2019-01-04 | 2019-05-28 | 平安科技（深圳）有限公司 | Monitoring method, device, equipment and the computer readable storage medium of tables of data |
| CN110362531A (en) * | 2019-06-17 | 2019-10-22 | 众安在线财产保险股份有限公司 | A kind of automatic archiving method and device |
| CN110457255A (en) * | 2019-07-05 | 2019-11-15 | 中国平安人寿保险股份有限公司 | Method, server and the computer readable storage medium of data filing |
| CN111190898A (en) * | 2019-11-25 | 2020-05-22 | 泰康保险集团股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN112817834A (en) * | 2021-01-22 | 2021-05-18 | 上海哔哩哔哩科技有限公司 | Data table evaluation method and device |
Families Citing this family (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110888774B (en) * | 2019-11-07 | 2023-06-23 | 中盈优创资讯科技有限公司 | HBASE-based big data report processing method and device |
| CN113448939A (en) * | 2020-03-24 | 2021-09-28 | 北京有限元科技有限公司 | Data archiving and storing method and device and storage medium |
| 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 (13)
| 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 |
| US20090198699A1 (en) * | 2008-01-31 | 2009-08-06 | International Business Machines Corporation | Remote space efficient repository |
| 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 |
| US20130124780A1 (en) * | 2011-11-15 | 2013-05-16 | Lsi Corporation | Apparatus to manage efficient data migration between tiers |
| CN103514295A (en) * | 2013-10-10 | 2014-01-15 | 中国电子科技集团公司第十五研究所 | Method and device for archiving historical data |
| CN104881477A (en) * | 2015-06-03 | 2015-09-02 | 上海新炬网络信息技术有限公司 | Estimation method for application data space usage |
| CN104899491A (en) * | 2015-05-28 | 2015-09-09 | 广东欧珀移动通信有限公司 | Data transfer method and apparatus thereof |
| US20160259565A1 (en) * | 2013-02-08 | 2016-09-08 | Workday, Inc. | Dynamic three-tier data storage utilization |
| CN106156038A (en) * | 2015-03-26 | 2016-11-23 | 腾讯科技（深圳）有限公司 | Date storage method and device |
| CN106446271A (en) * | 2016-10-20 | 2017-02-22 | 焦点科技股份有限公司 | Design method of BI data interface |
Family Cites Families (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| 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 |
| 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 (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20090198699A1 (en) * | 2008-01-31 | 2009-08-06 | International Business Machines Corporation | Remote space efficient repository |
| 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 |
| US20130124780A1 (en) * | 2011-11-15 | 2013-05-16 | Lsi Corporation | Apparatus to manage efficient data migration between tiers |
| 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 |
| US20160259565A1 (en) * | 2013-02-08 | 2016-09-08 | Workday, Inc. | Dynamic three-tier data storage utilization |
| CN103514295A (en) * | 2013-10-10 | 2014-01-15 | 中国电子科技集团公司第十五研究所 | Method and device for archiving historical data |
| CN106156038A (en) * | 2015-03-26 | 2016-11-23 | 腾讯科技（深圳）有限公司 | Date storage method and device |
| CN104899491A (en) * | 2015-05-28 | 2015-09-09 | 广东欧珀移动通信有限公司 | Data transfer method and apparatus thereof |
| CN104881477A (en) * | 2015-06-03 | 2015-09-02 | 上海新炬网络信息技术有限公司 | Estimation method for application data space usage |
| CN106446271A (en) * | 2016-10-20 | 2017-02-22 | 焦点科技股份有限公司 | Design method of BI data interface |
Non-Patent Citations (2)
| Title |
|---|
| HIROYUKI KAWANO: "Hierarchical Storage Systems and File Formats for Web Archiving", 《2011 21ST INTERNATIONAL CONFERENCE ON SYSTEMS ENGINEERING》 * |
| 庞永峰 等: "多媒体电子病历的设计与实现", 《太原理工大学学报》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2019062189A1 (en) * | 2017-09-30 | 2019-04-04 | 平安科技（深圳）有限公司 | Electronic device, method and system for conducting data table filing processing, and storage medium |
| CN109815094A (en) * | 2019-01-04 | 2019-05-28 | 平安科技（深圳）有限公司 | Monitoring method, device, equipment and the computer readable storage medium of tables of data |
| 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 |
| CN110457255A (en) * | 2019-07-05 | 2019-11-15 | 中国平安人寿保险股份有限公司 | Method, server and the computer readable storage medium of data filing |
| CN110457255B (en) * | 2019-07-05 | 2023-11-21 | 中国平安人寿保险股份有限公司 | Method, server and computer readable storage medium for archiving data |
| CN111190898A (en) * | 2019-11-25 | 2020-05-22 | 泰康保险集团股份有限公司 | Data processing method and device, electronic equipment and storage medium |
| CN112817834A (en) * | 2021-01-22 | 2021-05-18 | 上海哔哩哔哩科技有限公司 | Data table evaluation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107870981B (en) | 2021-10-22 |
| WO2019062189A1 (en) | 2019-04-04 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107870981A (en) | Electronic installation, the method and storage medium of tables of data filing processing | |
| EP3413212A1 (en) | Random forest model training method, electronic apparatus and storage medium | |
| CN103984726B (en) | A kind of local correction method of data base's implement plan | |
| CN101945353B (en) | Method and system for remote adjustment of system resources | |
| CN106897141A (en) | The processing method and processing device of information | |
| CN102377790A (en) | Method and device for pushing data | |
| CN108770017B (en) | Dynamic equalization method and system for wireless resources | |
| CN105101270A (en) | Traffic managing device and traffic managing method for terminal | |
| CN104636240B (en) | A kind of acquisition methods and terminal of information report | |
| CN106815254A (en) | A kind of data processing method and device | |
| CN103701920A (en) | Method for configuring virtual application server under cloud environment | |
| CN106293541A (en) | A kind of blog management method storing system and system | |
| CN101556586A (en) | Method, system and device of automatic data collection | |
| CN106020722A (en) | Method, device and system for deduplication of repeated data of cloud storage system | |
| CN103685517A (en) | Storage hierarchical scheduling method and system based on service class characteristics | |
| WO2016197458A1 (en) | Traffic control method and apparatus | |
| CN115291806A (en) | Processing method, processing device, electronic equipment and storage medium | |
| CN102629267A (en) | Data processing method and data processing module | |
| CN102446172B (en) | Data service processing method and device adopting same | |
| CN109144666A (en) | A kind of method for processing resource and system across cloud platform | |
| CN108805725A (en) | Risk case confirmation method, server and computer readable storage medium | |
| CN108989088A (en) | A kind of log method for uploading and communication equipment | |
| CN114356712A (en) | Data processing method, device, equipment, readable storage medium and program product | |
| CN107797851A (en) | Method for scheduling task, device and mobile terminal | |
| CN103391318A (en) | Data processing method, client side, server side and device |
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 |