WO2019062189A1 - Electronic device, method and system for conducting data table filing processing, and storage medium - Google Patents
Electronic device, method and system for conducting data table filing processing, and storage medium Download PDFInfo
- Publication number
- WO2019062189A1 WO2019062189A1 PCT/CN2018/089708 CN2018089708W WO2019062189A1 WO 2019062189 A1 WO2019062189 A1 WO 2019062189A1 CN 2018089708 W CN2018089708 W CN 2018089708W WO 2019062189 A1 WO2019062189 A1 WO 2019062189A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- data
- data table
- processing
- processing rule
- service type
- Prior art date
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
Definitions
- the present application relates to the field of database technologies, and in particular, to an electronic device, a data table archival processing method, a system, and a storage medium.
- the purpose of the present application is to provide an electronic device, a data table archiving processing method, a system and a storage medium, which aim to timely process a data table of an excessively large data size in the FAS financial database for archiving.
- the present application provides an electronic device including a memory and a processor coupled to the memory, the memory storing a processing system operable on the processor, the processing The system implements the following steps when executed by the processor:
- S101 Establish a monitoring table for monitoring each data table in the FAS financial database, and analyze, according to the monitoring table, data change information of each data table;
- the present application further provides a method for data table archiving processing, the method comprising:
- S3 Obtain a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
- the present application further provides a system for data table archiving processing, including:
- An analysis module configured to establish a monitoring table for monitoring each data table in the FAS financial database, and analyzing data change information of each data table based on the monitoring table;
- a generating module configured to generate a prompt message including current information of the data table when the data level of the data table becomes large and meets a preset condition
- the archiving module is configured to obtain a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
- the present application also provides a computer readable storage medium having stored thereon a processing system, the processing system being executed by a processor to implement the steps of the data table archiving process described above.
- the present application establishes a monitoring table for monitoring the data magnitude of each data table in the FAS financial database, and obtains a preset when the data level of the data table becomes larger or increases greatly.
- the application can timely process the data table of the data level of the FAS financial database, and archive it to improve the system. Performance, easy to manage and maintain the system.
- FIG. 1 is a schematic diagram of an optional application environment of each embodiment of the present application.
- FIG. 2 is a schematic flowchart diagram of an embodiment of a method for archiving data table of the present application.
- first, second and the like in the present application are for the purpose of description only, and are not to be construed as indicating or implying their relative importance or implicitly indicating the number of technical features indicated. .
- features defining “first” and “second” may include at least one of the features, either explicitly or implicitly.
- the technical solutions between the various embodiments may be combined with each other, but must be based on the realization of those skilled in the art, and when the combination of the technical solutions is contradictory or impossible to implement, it should be considered that the combination of the technical solutions does not exist. Nor is it within the scope of protection required by this application.
- FIG. 1 it is a schematic diagram of an application environment of a preferred embodiment of the method for archiving data table of the present application.
- the application environment diagram includes an electronic device 1 and a terminal device 2.
- the electronic device 1 can perform data interaction with the terminal device 2 through a suitable technology such as a network or a near field communication technology.
- the terminal device 2 includes, but is not limited to, any electronic product that can interact with a user through a keyboard, a mouse, a remote controller, a touch panel, or a voice control device, for example, a personal computer, a tablet computer, or a smart phone. , Personal Digital Assistant (PDA), game consoles, Internet Protocol Television (IPTV), smart wearable devices, navigation devices, etc., or mobile devices such as digital TVs, desktop computers, Fixed terminal for notebooks, servers, etc.
- PDA Personal Digital Assistant
- IPTV Internet Protocol Television
- the terminal device 2 is configured to receive an instruction to establish a monitoring table and send it to the electronic device, and receive a processing rule set by the maintenance personnel on site.
- the electronic device 1 is an apparatus capable of automatically performing numerical calculation and/or information processing in accordance with an instruction set or stored in advance.
- the electronic device 1 may be a computer, a single network server, a server group composed of multiple network servers, or a cloud-based cloud composed of a large number of hosts or network servers, where cloud computing is a type of distributed computing.
- a super virtual computer consisting of a group of loosely coupled computers.
- the electronic device 1 may include, but is not limited to, a memory 11 communicably connected to each other through a system bus, a processor 12, and a network interface 13, and the memory 11 stores a processing system operable on the processor 12. It should be noted that FIG. 1 only shows the electronic device 1 having the components 11-13, but it should be understood that not all illustrated components may be implemented, and more or fewer components may be implemented instead.
- the memory 11 includes a memory and at least one type of readable storage medium.
- the memory provides a cache for the operation of the electronic device 1;
- the readable storage medium may be, for example, a flash memory, a hard disk, a multimedia card, a card type memory (eg, SD or DX memory, etc.), a random access memory (RAM), a static random access memory (SRAM).
- a non-volatile storage medium such as 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, or the like.
- the readable storage medium may be an internal storage unit of the electronic device 1, such as a hard disk of the electronic device 1; in other embodiments, the non-volatile storage medium may also be external to the electronic device 1.
- a storage device such as a plug-in hard disk equipped with an electronic device 1, a smart memory card (SMC), a Secure Digital (SD) card, a flash card, or the like.
- the readable storage medium of the memory 11 is generally used to store an operating system installed in the electronic device 1 and various types of application software, such as program codes of the processing system in an embodiment of the present application. Further, the memory 11 can 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 typically used to control the overall operation of the electronic device 1, such as performing control and processing related to data interaction or communication with the terminal device 2.
- the processor 12 is configured to run program code or process data stored in the memory 11, such as running a processing system or the like.
- the network interface 13 may comprise a wireless network interface or a wired network interface, which is typically used to establish a communication connection between the electronic device 1 and other electronic devices.
- the network interface 13 is mainly used to connect the electronic device 1 with one or more terminal devices 2, and establish a data transmission channel and a communication connection between the electronic device 1 and 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 methods of various embodiments of the present application; At least one computer readable instruction may be classified as a different logic module depending on the functions implemented by its various parts.
- Step S101 establishing a monitoring table for monitoring each data table in the FAS financial database, and analyzing data change information of each data table based on the monitoring table;
- 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 including the name of the data table, the data magnitude, the type information, and the time information
- the monitoring table records the names of the data tables to be monitored in the form of Table 1, Table 2, Table n, After the name of each data table, the corresponding data magnitude, type information, and time information are recorded.
- Table 1 one or more data magnitudes of each of the predetermined times are recorded in Table 1 after the monitoring table.
- Each data table has corresponding type information, including a service type and a non-service type, to distinguish whether the data table is a business data table or a non-business data table.
- each data table in the FAS financial database can be monitored in real time, for example, the data magnitude of each data table is recorded with time, or each data table in the FAS financial database is periodically monitored, preferably. Ground, the data table is monitored regularly, for example, the data level of each data table is captured every 1 hour or 5 hours, or the time of capturing the data level according to the actual situation of each data table, etc., the captured data will be captured. The magnitude is recorded in the monitoring table.
- the data magnitude of each data table in the FAS database in the monitoring table may be periodically obtained, and whether the data magnitude of each data table reaches a preset threshold is analyzed. For example, whether the data level reaches a million level; or obtain the data magnitude of each data table in the FAS database in the monitoring table every preset time, calculate the data magnitude increase of each data table, and analyze the data of each data table. Whether the increase of the magnitude reaches the preset range, for example, one month as the time interval, whether the increase of the data level of a certain data table for two consecutive months reaches a preset threshold (for example, an increase of 100%).
- Step S102 when the data level of the data table becomes large and the preset condition is met, generating a prompt message including current information of the data table;
- the data level of the data table becomes large and the preset condition is met, for example, the data level of the data table becomes large and reaches a preset threshold, or the data level becomes large and the preset time interval is reached.
- a prompt message containing the current information of the data table is generated, wherein the current information of the data table includes the name of the data table, the data magnitude, and the type information.
- the prompt message is used to remind the maintenance personnel to process the data table.
- the prompt message may be sent to the predetermined terminal in a predetermined format and sent to the mobile terminal and sent to the mobile terminal worn by the maintenance personnel, and the predetermined format of the prompt message is, for example, “Table 1, data volume level”. **, type information**".
- Step S103 Acquire a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
- the processing rule may be preset by the maintenance personnel, and includes multiple types, and each processing rule is associated with the data magnitude and the type information of the data table, and the prompt for generating the current information of the data table is generated. After the message, the preset processing rule is automatically acquired based on the current information in the prompt message, and the data table is archived based on the processing rule.
- the processing rule may be set by the maintenance personnel on site, that is, when the maintenance clerk receives the prompt message for the data table in the FAS financial database, the data is based on the data magnitude and type information of the data table. The table sets the corresponding processing rule, and the data table is archived based on the processing rule.
- the processing rule may be that the data table is archived periodically, or all the data tables may be directly archived.
- the present embodiment establishes a monitoring table for monitoring the data magnitude of each data table in the FAS financial database.
- the pre-set is obtained.
- the processing rule or the maintenance personnel is required to set corresponding processing rules on the spot, and the data table is archived according to the processing rule.
- This embodiment can timely process the data table of the FAS financial database with excessive data size and archive it. Improve system performance and facilitate system management and maintenance.
- the step S103 includes: if the service type of the data table is a non-service type, acquiring the first set based on the non-service type Processing a rule, performing an archiving process on the data table based on the first processing rule; if the service type of the data table is a service type, acquiring a second processing rule set based on the service type, based on the second processing rule The data table is archived.
- the processing rule includes a first processing rule preset by the maintenance personnel and a second processing rule set by the maintenance personnel on the spot
- the type information includes a service type (such as a reimbursement form, a bill or an invoice, etc.) and a non-service type. (for example, an approval record table, etc.): if the service type of the data table is a non-service type, obtaining a first processing rule corresponding to the non-service type setting, and archiving the data table based on the first processing rule; If the service type of the data table is a service type, the second processing rule corresponding to the service type setting is obtained, and the data table is archived based on the second processing rule.
- This embodiment provides a flexible manner of setting processing rules, so that data tables with large data levels are archived according to processing rules based on different actual situations.
- the first processing rule comprises: assigning a task to the data table, migrating the data in the data table to a corresponding archive table based on the assigned task timing, or retaining a predetermined partial data in the data table, and based on The assigned task timing migrates other unreserved data into the corresponding archive table;
- the second processing rule includes: assigning a task to the data table, retaining a predetermined portion of the data in the data table, and timing based on the assigned task Migrate other data that has not been retained to the corresponding archive table.
- other processing rules may be set, such as directly archiving all the data in the data table into the archive table, and so on, which will not be exemplified herein.
- the task assigned to the data table may be, for example, periodically migrating the data of the previous year in the data table to the archive table, until all the data of the previous year of the data table is migrated into the archive table. Or, retain part of the data from the previous year in the data table, and periodically migrate other data from the previous year to the archive table every day until all the data is migrated to the archive table.
- the associated data when the data in the data table is archived, the associated data can be correlated, the repeated data can be combined, and the data can be classified and saved according to the preservation value of the data, etc. To facilitate preservation and subsequent use.
- FIG. 2 is a schematic flowchart of an embodiment of a data table archiving process according to an embodiment of the present application.
- the method for archiving the data table includes the following steps:
- Step S1 Establish a monitoring table for monitoring each data table in the FAS financial database, and analyze data change information of each data table based on the monitoring table;
- 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 including the name of the data table, the data magnitude, the type information, and the time information
- the monitoring table records the names of the data tables to be monitored in the form of Table 1, Table 2, Table n, After the name of each data table, the corresponding data magnitude, type information, and time information are recorded.
- Table 1 one or more data magnitudes of each of the predetermined times are recorded in Table 1 after the monitoring table.
- Each data table has corresponding type information, including a service type and a non-service type, to distinguish whether the data table is a business data table or a non-business data table.
- each data table in the FAS financial database can be monitored in real time, for example, the data magnitude of each data table is recorded with time, or each data table in the FAS financial database is periodically monitored, preferably. Ground, the data table is monitored regularly, for example, the data level of each data table is captured every 1 hour or 5 hours, or the time of capturing the data level according to the actual situation of each data table, etc., the captured data will be captured. The magnitude is recorded in the monitoring table.
- the data magnitude of each data table in the FAS database in the monitoring table may be periodically obtained, and whether the data magnitude of each data table reaches a preset threshold is analyzed. For example, whether the data level reaches a million level; or obtain the data magnitude of each data table in the FAS database in the monitoring table every preset time, calculate the data magnitude increase of each data table, and analyze the data of each data table. Whether the increase of the magnitude reaches the preset range, for example, one month as the time interval, whether the increase of the data level of a certain data table for two consecutive months reaches a preset threshold (for example, an increase of 100%).
- Step S2 when the data level of the data table becomes large and the preset condition is met, generating a prompt message including the current information of the data table;
- the data level of the data table becomes large and the preset condition is met, for example, the data level of the data table becomes large and reaches a preset threshold, or the data level becomes large and the preset time interval is reached.
- a prompt message containing the current information of the data table is generated, wherein the current information of the data table includes the name of the data table, the data magnitude, and the type information.
- the prompt message is used to remind the maintenance personnel to process the data table.
- the prompt message may be sent to the predetermined terminal in a predetermined format and sent to the mobile terminal and sent to the mobile terminal worn by the maintenance personnel, and the predetermined format of the prompt message is, for example, “Table 1, data volume level”. **, type information**".
- Step S3 Obtain a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
- the processing rule may be preset by the maintenance personnel, and includes multiple types, and each processing rule is associated with the data magnitude and the type information of the data table, and the prompt for generating the current information of the data table is generated. After the message, the preset processing rule is automatically acquired based on the current information in the prompt message, and the data table is archived based on the processing rule.
- the processing rule may be set by the maintenance personnel on site, that is, when the maintenance clerk receives the prompt message for the data table in the FAS financial database, the data is based on the data magnitude and type information of the data table. The table sets the corresponding processing rule, and the data table is archived based on the processing rule.
- the processing rule may be that the data table is archived periodically, or all the data tables may be directly archived.
- the present embodiment establishes a monitoring table for monitoring the data magnitude of each data table in the FAS financial database.
- the pre-set is obtained.
- the processing rule or the maintenance personnel is required to set corresponding processing rules on the spot, and the data table is archived according to the processing rule.
- This embodiment can timely process the data table of the FAS financial database with excessive data size and archive it. Improve system performance and facilitate system management and maintenance.
- the step S3 includes: if the service type of the data table is a non-service type, acquiring the first set based on the non-service type Processing a rule, performing an archiving process on the data table based on the first processing rule; if the service type of the data table is a service type, acquiring a second processing rule set based on the service type, based on the second processing rule The data table is archived.
- the processing rule includes a first processing rule preset by the maintenance personnel and a second processing rule set by the maintenance personnel on the spot
- the type information includes a service type (such as a reimbursement form, a bill or an invoice, etc.) and a non-service type. (for example, an approval record table, etc.): if the service type of the data table is a non-service type, obtaining a first processing rule corresponding to the non-service type setting, and archiving the data table based on the first processing rule; If the service type of the data table is a service type, the second processing rule corresponding to the service type setting is obtained, and the data table is archived based on the second processing rule.
- This embodiment provides a flexible manner of setting processing rules, so that data tables with large data levels are archived according to processing rules based on different actual situations.
- the first processing rule comprises: assigning a task to the data table, migrating the data in the data table to a corresponding archive table based on the assigned task timing, or retaining a predetermined partial data in the data table, and based on The assigned task timing migrates other unreserved data into the corresponding archive table;
- the second processing rule includes: assigning a task to the data table, retaining a predetermined portion of the data in the data table, and timing based on the assigned task Migrate other data that has not been retained to the corresponding archive table.
- other processing rules may be set, such as directly archiving all the data in the data table into the archive table, and so on, which will not be exemplified herein.
- the task assigned to the data table may be, for example, periodically migrating the data of the previous year in the data table to the archive table, until all the data of the previous year of the data table is migrated into the archive table. Or, retain part of the data from the previous year in the data table, and periodically migrate other data from the previous year to the archive table every day until all the data is migrated to the archive table.
- the associated data when the data in the data table is archived, the associated data can be correlated, the repeated data can be combined, and the data can be classified and saved according to the preservation value of the data, etc. To facilitate preservation and subsequent use.
- the present application also provides a computer readable storage medium having stored thereon a processing system, the processing system being executed by a processor to implement the steps of the data table archiving process described above.
- the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better.
- Implementation Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk,
- the optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.
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 application relates to an electronic device, a method and system for conducting data table filing processing, and a storage medium. The electronic device comprises a memory and a processor connected to the memory; a processing system, which can be operated on the processor, is stored in the memory; and the processing system is executed by the processor to implement the following steps: establishing a monitoring table for monitoring each data table in an FAS financial database, and analyzing, based on the monitoring table, change information about a data magnitude of each data table; when the data magnitude of a data table increases and satisfies a pre-set condition, generating a prompt message which contains current information about the data table; and acquiring a processing rule which is set on the basis of the current information about the data table, and based on the processing rule, conducting filing processing on the data table. According to the present application, data tables with excessive data magnitudes in an FAS financial database can be processed in a timely manner and filed, thereby improving the system performance and facilitating the management and maintenance of a system.
Description
优先权申明Priority claim
本申请基于巴黎公约申明享有2017年09月30日递交的申请号为CN 2017109160673、名称为“电子装置、数据表归档处理的方法及存储介质”中国专利申请的优先权,该中国专利申请的整体内容以参考的方式结合在本申请中。This application is based on the priority of the Chinese Patent Application entitled "Electronic Device, Method of Data Archive Processing and Storage Media", filed on September 30, 2017, with the application number of CN 2017109160673, which is filed on September 30, 2017. The content is incorporated herein by reference.
本申请涉及数据库技术领域,尤其涉及一种电子装置、数据表归档处理的方法、***及存储介质。The present application relates to the field of database technologies, and in particular, to an electronic device, a data table archival processing method, a system, and a storage medium.
随着FAS(Financial Accounting Standards)财务***的使用,会有越来越多的数据表的数据量级变得很大,例如有一部分数据表的数据量级达到了百万,甚至有少量的数据表的数据量级达到了千万或者过亿,数据表的数据量级过大会影响查询效率等***性能。现有技术中,可以采用分库分表等方案改变现有数据存储结构的方案来解决数据库中数据较多的问题,但是考虑到FAS财务***中数据本身及数据之间关联的复杂性,采用该种方案操作较复杂、对现有***冲击较大,因而无法在实际中进行应用,由此,对FAS财务***中数据量级较大的单表进行及时处理,以提高***性能成为有待解决的问题。With the use of the financial system of FAS (Financial Accounting Standards), more and more data tables will become of a large data size. For example, some data tables have a data size of millions or even a small amount of data. The data level of the table reaches tens of millions or billions, and the data level of the data table is too large to affect the system performance such as query efficiency. In the prior art, the solution of changing the existing data storage structure by using a scheme such as a sub-division table can be used to solve the problem of more data in the database, but considering the complexity of the data itself and the association between the data in the FAS financial system, This kind of scheme is more complicated in operation and has a greater impact on the existing system, so it cannot be applied in practice. Therefore, timely processing of a single table with a large data size in the FAS financial system to improve system performance becomes a problem to be solved. The problem.
发明内容Summary of the invention
本申请的目的在于提供一种电子装置、数据表归档处理的方法、***及存储介质,旨在及时处理FAS财务数据库中数据量级过大的数据表,以将其进行归档。The purpose of the present application is to provide an electronic device, a data table archiving processing method, a system and a storage medium, which aim to timely process a data table of an excessively large data size in the FAS financial database for archiving.
为实现上述目的,本申请提供一种电子装置,所述电子装置包括存储器及与所述存储器连接的处理器,所述存储器中存储有可在所述处理器上运行的处理***,所述处理***被所述处理器执行时实现如下步骤:To achieve the above object, the present application provides an electronic device including a memory and a processor coupled to the memory, the memory storing a processing system operable on the processor, the processing The system implements the following steps when executed by the processor:
S101,建立对FAS财务数据库中的各个数据表进行监控的监控表,基于所述监控表分析各个数据表的数据量级的变化信息;S101: Establish a monitoring table for monitoring each data table in the FAS financial database, and analyze, according to the monitoring table, data change information of each data table;
S102,当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;S102. When a data level of the data table becomes larger and meets a preset condition, generating a prompt message that includes current information of the data table.
S103,获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。S103. Acquire a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
为实现上述目的,本申请还提供一种数据表归档处理的方法,所述方法包括:To achieve the above objective, the present application further provides a method for data table archiving processing, the method comprising:
S1,建立对FAS财务数据库中的各个数据表进行监控的监控表,基于所述监控表分析各个数据表的数据量级的变化信息;S1, establishing a monitoring table for monitoring each data table in the FAS financial database, and analyzing data change information of each data table based on the monitoring table;
S2,当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;S2, when the data level of the data table becomes large and meets the preset condition, generating a prompt message including current information of the data table;
S3,获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。S3: Obtain a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
为实现上述目的,本申请还提供一种数据表归档处理的***,包括:To achieve the above objective, the present application further provides a system for data table archiving processing, including:
分析模块,用于建立对FAS财务数据库中的各个数据表进行监控的监控表,基于所述监控表分析各个数据表的数据量级的变化信息;An analysis module, configured to establish a monitoring table for monitoring each data table in the FAS financial database, and analyzing data change information of each data table based on the monitoring table;
生成模块,用于当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;a generating module, configured to generate a prompt message including current information of the data table when the data level of the data table becomes large and meets a preset condition;
归档模块,用于获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。The archiving module is configured to obtain a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
本申请还提供一种计算机可读存储介质,所述计算机可读存储介质上存 储有处理***,所述处理***被处理器执行时实现上述的数据表归档处理的方法的步骤。The present application also provides a computer readable storage medium having stored thereon a processing system, the processing system being executed by a processor to implement the steps of the data table archiving process described above.
本申请的有益效果是:本申请建立对FAS财务数据库中的各个数据表的数据量级进行监控的监控表,在有数据表的数据量级变较大或增幅较大时,获取预先设定的处理规则或者提醒维修人员现场设置对应的处理规则,根据该处理规则对数据表进行归档处理,本申请能够及时处理FAS财务数据库中数据量级过大的数据表,将其进行归档,提升***性能,便于***的管理及维护。The beneficial effects of the present application are: the present application establishes a monitoring table for monitoring the data magnitude of each data table in the FAS financial database, and obtains a preset when the data level of the data table becomes larger or increases greatly. The processing rule or remind the maintenance personnel to set the corresponding processing rules on the spot, and archive the data table according to the processing rule. The application can timely process the data table of the data level of the FAS financial database, and archive it to improve the system. Performance, easy to manage and maintain the system.
图1为本申请各个实施例一可选的应用环境示意图;1 is a schematic diagram of an optional application environment of each embodiment of the present application;
图2为本申请数据表归档处理的方法一实施例的流程示意图。FIG. 2 is a schematic flowchart diagram of an embodiment of a method for archiving data table of the present application.
为了使本申请的目的、技术方案及优点更加清楚明白,以下结合附图及实施例,对本申请进行进一步详细说明。应当理解,此处所描述的具体实施例仅用以解释本申请,并不用于限定本申请。基于本申请中的实施例,本领域普通技术人员在没有做出创造性劳动前提下所获得的所有其他实施例,都属于本申请保护的范围。In order to make the objects, technical solutions, and advantages of the present application more comprehensible, the present application will be further described in detail below with reference to the accompanying drawings and embodiments. It is understood that the specific embodiments described herein are merely illustrative of the application and are not intended to be limiting. All other embodiments obtained by a person of ordinary skill in the art based on the embodiments of the present application without departing from the inventive scope are the scope of the present application.
需要说明的是,在本申请中涉及“第一”、“第二”等的描述仅用于描述目的,而不能理解为指示或暗示其相对重要性或者隐含指明所指示的技术特征的数量。由此,限定有“第一”、“第二”的特征可以明示或者隐含地包括至少一个该特征。另外,各个实施例之间的技术方案可以相互结合,但是必须是以本领域普通技术人员能够实现为基础,当技术方案的结合出现相互矛盾或无法实现时应当认为这种技术方案的结合不存在,也不在本申请要求的 保护范围之内。It should be noted that the descriptions of "first", "second" and the like in the present application are for the purpose of description only, and are not to be construed as indicating or implying their relative importance or implicitly indicating the number of technical features indicated. . Thus, features defining "first" and "second" may include at least one of the features, either explicitly or implicitly. In addition, the technical solutions between the various embodiments may be combined with each other, but must be based on the realization of those skilled in the art, and when the combination of the technical solutions is contradictory or impossible to implement, it should be considered that the combination of the technical solutions does not exist. Nor is it within the scope of protection required by this application.
参阅图1所示,是本申请数据表归档处理的方法的较佳实施例的应用环境示意图。该应用环境示意图包括电子装置1及终端设备2。电子装置1可以通过网络、近场通信技术等适合的技术与终端设备2进行数据交互。Referring to FIG. 1 , it is a schematic diagram of an application environment of a preferred embodiment of the method for archiving data table of the present application. The application environment diagram includes an electronic device 1 and a terminal device 2. The electronic device 1 can perform data interaction with the terminal device 2 through a suitable technology such as a network or a near field communication technology.
所述终端设备2包括,但不限于,任何一种可与用户通过键盘、鼠标、遥控器、触摸板或者声控设备等方式进行人机交互的电子产品,例如,个人计算机、平板电脑、智能手机、个人数字助理(Personal Digital Assistant,PDA)、游戏机、交互式网络电视(Internet Protocol Television,IPTV)、智能式穿戴式设备、导航装置等等的可移动设备,或者诸如数字TV、台式计算机、笔记本、服务器等等的固定终端。终端设备2用以接收建立监控表的指令并发送给电子装置,以及接收维护人员现场设置的处理规则等。The terminal device 2 includes, but is not limited to, any electronic product that can interact with a user through a keyboard, a mouse, a remote controller, a touch panel, or a voice control device, for example, a personal computer, a tablet computer, or a smart phone. , Personal Digital Assistant (PDA), game consoles, Internet Protocol Television (IPTV), smart wearable devices, navigation devices, etc., or mobile devices such as digital TVs, desktop computers, Fixed terminal for notebooks, servers, etc. The terminal device 2 is configured to receive an instruction to establish a monitoring table and send it to the electronic device, and receive a processing rule set by the maintenance personnel on site.
所述电子装置1是一种能够按照事先设定或者存储的指令,自动进行数值计算和/或信息处理的设备。所述电子装置1可以是计算机、也可以是单个网络服务器、多个网络服务器组成的服务器组或者基于云计算的由大量主机或者网络服务器构成的云,其中云计算是分布式计算的一种,由一群松散耦合的计算机集组成的一个超级虚拟计算机。The electronic device 1 is an apparatus capable of automatically performing numerical calculation and/or information processing in accordance with an instruction set or stored in advance. The electronic device 1 may be a computer, a single network server, a server group composed of multiple network servers, or a cloud-based cloud composed of a large number of hosts or network servers, where cloud computing is a type of distributed computing. A super virtual computer consisting of a group of loosely coupled computers.
在本实施例中,电子装置1可包括,但不仅限于,可通过***总线相互通信连接的存储器11、处理器12、网络接口13,存储器11存储有可在处理器12上运行的处理***。需要指出的是,图1仅示出了具有组件11-13的电子装置1,但是应理解的是,并不要求实施所有示出的组件,可以替代的实施更多或者更少的组件。In the present embodiment, the electronic device 1 may include, but is not limited to, a memory 11 communicably connected to each other through a system bus, a processor 12, and a network interface 13, and the memory 11 stores a processing system operable on the processor 12. It should be noted that FIG. 1 only shows the electronic device 1 having the components 11-13, but it should be understood that not all illustrated components may be implemented, and more or fewer components may be implemented instead.
其中,存储器11包括内存及至少一种类型的可读存储介质。内存为电子装置1的运行提供缓存;可读存储介质可为如闪存、硬盘、多媒体卡、卡型存储器(例如,SD或DX存储器等)、随机访问存储器(RAM)、静态随机访问存储器(SRAM)、只读存储器(ROM)、电可擦除可编程只读存储器 (EEPROM)、可编程只读存储器(PROM)、磁性存储器、磁盘、光盘等的非易失性存储介质。在一些实施例中,可读存储介质可以是电子装置1的内部存储单元,例如该电子装置1的硬盘;在另一些实施例中,该非易失性存储介质也可以是电子装置1的外部存储设备,例如电子装置1上配备的插接式硬盘,智能存储卡(Smart Media Card,SMC),安全数字(Secure Digital,SD)卡,闪存卡(Flash Card)等。本实施例中,存储器11的可读存储介质通常用于存储安装于电子装置1的操作***和各类应用软件,例如本申请一实施例中的处理***的程序代码等。此外,存储器11还可以用于暂时地存储已经输出或者将要输出的各类数据。The memory 11 includes a memory and at least one type of readable storage medium. The memory provides a cache for the operation of the electronic device 1; the readable storage medium may be, for example, a flash memory, a hard disk, a multimedia card, a card type memory (eg, SD or DX memory, etc.), a random access memory (RAM), a static random access memory (SRAM). A non-volatile storage medium such as 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, or the like. In some embodiments, the readable storage medium may be an internal storage unit of the electronic device 1, such as a hard disk of the electronic device 1; in other embodiments, the non-volatile storage medium may also be external to the electronic device 1. A storage device, such as a plug-in hard disk equipped with an electronic device 1, a smart memory card (SMC), a Secure Digital (SD) card, a flash card, or the like. In this embodiment, the readable storage medium of the memory 11 is generally used to store an operating system installed in the electronic device 1 and various types of application software, such as program codes of the processing system in an embodiment of the present application. Further, the memory 11 can also be used to temporarily store various types of data that have been output or are to be output.
所述处理器12在一些实施例中可以是中央处理器(Central Processing Unit,CPU)、控制器、微控制器、微处理器、或其他数据处理芯片。该处理器12通常用于控制所述电子装置1的总体操作,例如执行与所述终端设备2进行数据交互或者通信相关的控制和处理等。本实施例中,所述处理器12用于运行所述存储器11中存储的程序代码或者处理数据,例如运行处理***等。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 typically used to control the overall operation of the electronic device 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 program code or process data stored in the memory 11, such as running a processing system or the like.
所述网络接口13可包括无线网络接口或有线网络接口,该网络接口13通常用于在所述电子装置1与其他电子设备之间建立通信连接。本实施例中,网络接口13主要用于将电子装置1与一个或多个终端设备2相连,在电子装置1与一个或多个终端设备2之间建立数据传输通道和通信连接。The network interface 13 may comprise a wireless network interface or a wired network interface, which is typically used to establish a communication connection between the electronic device 1 and other electronic devices. In this embodiment, the network interface 13 is mainly used to connect the electronic device 1 with one or more terminal devices 2, and establish a data transmission channel and a communication connection between the electronic device 1 and one or more terminal devices 2.
处理***存储在存储器11中,包括至少一个存储在存储器11中的计算机可读指令,该至少一个计算机可读指令可被处理器器12执行,以实现本申请各实施例的方法;以及,该至少一个计算机可读指令依据其各部分所实现的功能不同,可被划为不同的逻辑模块。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 methods of various embodiments of the present application; At least one computer readable instruction may be classified as a different logic module depending on the functions implemented by its various parts.
在一实施例中,上述处理***被所述处理器12执行时实现如下步骤:In an embodiment, when the processing system is executed by the processor 12, the following steps are implemented:
步骤S101,建立对FAS财务数据库中的各个数据表进行监控的监控表, 基于所述监控表分析各个数据表的数据量级的变化信息;Step S101, establishing a monitoring table for monitoring each data table in the FAS financial database, and analyzing data change information of each data table based on the monitoring table;
本实施例中,FAS财务数据库中具有数量较多的数据表,建立监控表以对各个数据表进行监控。其中,在监控表中,包括数据表的名称、数据量级、类型信息及时间信息,例如,监控表中以表1、表2…表n的形式记录所要监控的各数据表的名称,在每一数据表的名称之后,记录对应的数据量级、类型信息及时间信息,例如对于表1,监控表中在表1之后记录一个或者多个其在各个预定的时间的数据量级。每一数据表都有对应的类型信息,包括业务类型及非业务类型,以区分该数据表是业务数据表还是非业务数据表。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. Wherein, in the monitoring table, including the name of the data table, the data magnitude, the type information, and the time information, for example, the monitoring table records the names of the data tables to be monitored in the form of Table 1, Table 2, Table n, After the name of each data table, the corresponding data magnitude, type information, and time information are recorded. For example, for Table 1, one or more data magnitudes of each of the predetermined times are recorded in Table 1 after the monitoring table. Each data table has corresponding type information, including a service type and a non-service type, to distinguish whether the data table is a business data table or a non-business data table.
本实施例中,可以实时对FAS财务数据库中的各个数据表进行监控,例如将各个数据表的数据量级随时间的变化进行记录,或者定时对FAS财务数据库中的各个数据表进行监控,优选地,定时对数据表进行监控,例如每隔1小时或者5小时捕捉各个数据表的数据量级,或者根据每个数据表的实际情况设置捕捉其数据量级的时间等,将捕捉到的数据量级记录在监控表中。In this embodiment, each data table in the FAS financial database can be monitored in real time, for example, the data magnitude of each data table is recorded with time, or each data table in the FAS financial database is periodically monitored, preferably. Ground, the data table is monitored regularly, for example, the data level of each data table is captured every 1 hour or 5 hours, or the time of capturing the data level according to the actual situation of each data table, etc., the captured data will be captured. The magnitude is recorded in the monitoring table.
在FAS财务数据库中,若某个数据表增加了新的数据,则该数据表的数据量级变大。在针对某一数据表分析其数据量级的变化信息时,优选地,可以定时获取监控表中FAS数据库中的各个数据表的数据量级,分析各个数据表的数据量级是否达到预设阈值,例如数据量级是否达到百万级;或者每隔预设时间获取监控表中FAS数据库中的各个数据表的数据量级,计算各个数据表的数据量级的增幅,分析各个数据表的数据量级的增幅是否达到预设幅度,例如以一个月为时间间隔,分析某一数据表的数据量级连续两个月的增幅是否达到预设阈值(例如增幅为100%)。In the FAS financial database, if a new data is added to a data table, the data level of the data table becomes larger. When analyzing the change information of the data magnitude for a certain data table, preferably, the data magnitude of each data table in the FAS database in the monitoring table may be periodically obtained, and whether the data magnitude of each data table reaches a preset threshold is analyzed. For example, whether the data level reaches a million level; or obtain the data magnitude of each data table in the FAS database in the monitoring table every preset time, calculate the data magnitude increase of each data table, and analyze the data of each data table. Whether the increase of the magnitude reaches the preset range, for example, one month as the time interval, whether the increase of the data level of a certain data table for two consecutive months reaches a preset threshold (for example, an increase of 100%).
步骤S102,当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;Step S102, when the data level of the data table becomes large and the preset condition is met, generating a prompt message including current information of the data table;
本实施例中,当有数据表的数据量级变大且满足预设的条件时,例如数据表的数据量级变大且达到预设的阈值,或者数据量级变大且预设时间间隔 的增幅达到预设的阈值时,生成包含该数据表当前信息的提示消息,其中数据表当前信息包括数据表的名称、数据量级及类型信息。该提示消息用于提醒维护人员对数据表进行处理。In this embodiment, when the data level of the data table becomes large and the preset condition is met, for example, the data level of the data table becomes large and reaches a preset threshold, or the data level becomes large and the preset time interval is reached. When the increase reaches the preset threshold, a prompt message containing the current information of the data table is generated, wherein the current information of the data table includes the name of the data table, the data magnitude, and the type information. The prompt message is used to remind the maintenance personnel to process the data table.
其中,该提示消息可以以预定的格式发送至预定的终端上并进行提醒,或者发送至维护人员佩戴的移动终端上并进行提醒,该提示消息的预定的格式例如为“表1、数据量级**、类型信息**”。The prompt message may be sent to the predetermined terminal in a predetermined format and sent to the mobile terminal and sent to the mobile terminal worn by the maintenance personnel, and the predetermined format of the prompt message is, for example, “Table 1, data volume level”. **, type information**".
步骤S103,获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。Step S103: Acquire a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
其中,在一实施例中,处理规则可以是维护人员预先设定的,其包括多种,各处理规则与数据表的数据量级及类型信息对应关联,在生成包含该数据表当前信息的提示消息后,基于该提示消息中的当前信息自动获取预先设定的处理规则,基于该处理规则对该数据表进行归档处理。在其他实施例中,该处理规则可以是维护人员现场进行设置的,即当维护文员收到针对FAS财务数据库中的数据表的提示消息时,基于数据表的数据量级及类型信息对该数据表设置出相应的处理规则,基于该处理规则对该数据表进行归档处理。In an embodiment, the processing rule may be preset by the maintenance personnel, and includes multiple types, and each processing rule is associated with the data magnitude and the type information of the data table, and the prompt for generating the current information of the data table is generated. After the message, the preset processing rule is automatically acquired 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 rule may be set by the maintenance personnel on site, that is, when the maintenance clerk receives the prompt message for the data table in the FAS financial database, the data is based on the data magnitude and type information of the data table. The table sets the corresponding processing rule, and the data table is archived based on the processing rule.
其中,处理规则可以是定期对数据表进行归档,也可以是直接将全部数据表进行归档等。The processing rule may be that the data table is archived periodically, or all the data tables may be directly archived.
与现有技术相比,本实施例建立对FAS财务数据库中的各个数据表的数据量级进行监控的监控表,在有数据表的数据量级变较大或增幅较大时,获取预先设定的处理规则或者提醒维修人员现场设置对应的处理规则,根据该处理规则对数据表进行归档处理,本实施例能够及时处理FAS财务数据库中数据量级过大的数据表,将其进行归档,提升***性能,便于***的管理及维护。Compared with the prior art, the present embodiment establishes a monitoring table for monitoring the data magnitude of each data table in the FAS financial database. When the data level of the data table becomes larger or increases, the pre-set is obtained. The processing rule or the maintenance personnel is required to set corresponding processing rules on the spot, and the data table is archived according to the processing rule. This embodiment can timely process the data table of the FAS financial database with excessive data size and archive it. Improve system performance and facilitate system management and maintenance.
在一优选的实施例中,在上述图1的实施例的基础上,所述步骤S103包括:若数据表的业务类型为非业务类型,则获取基于所述非业务类型设定的的第一处理规则,基于该第一处理规则对该数据表进行归档处理;若数据表的业务类型为业务类型,则获取基于所述业务类型设定的第二处理规则,基于该第二处理规则对该数据表进行归档处理。In a preferred embodiment, on the basis of the foregoing embodiment of FIG. 1, the step S103 includes: if the service type of the data table is a non-service type, acquiring the first set based on the non-service type Processing a rule, performing an archiving process on the data table based on the first processing rule; if the service type of the data table is a service type, acquiring a second processing rule set based on the service type, based on the second processing rule The data table is archived.
在一实施例中,处理规则包括维护人员预先设定的第一处理规则及维护人员现场进行设置第二处理规则,类型信息包括业务类型(例如报销单、报账单或***等)及非业务类型(例如审批记录表等):若数据表的业务类型为非业务类型,则获取基于所述非业务类型设定对应的第一处理规则,基于该第一处理规则对该数据表进行归档处理;若数据表的业务类型为业务类型,则获取基于所述业务类型设定对应的第二处理规则,基于该第二处理规则对该数据表进行归档处理。本实施例提供灵活的设置处理规则的方式,使得数据量级大的数据表按照基于不同的实际情况的处理规则进行归档。In an embodiment, the processing rule includes a first processing rule preset by the maintenance personnel and a second processing rule set by the maintenance personnel on the spot, and the type information includes a service type (such as a reimbursement form, a bill or an invoice, etc.) and a non-service type. (for example, an approval record table, etc.): if the service type of the data table is a non-service type, obtaining a first processing rule corresponding to the non-service type setting, and archiving the data table based on the first processing rule; If the service type of the data table is a service type, the second processing rule corresponding to the service type setting is obtained, and the data table is archived based on the second processing rule. This embodiment provides a flexible manner of setting processing rules, so that data tables with large data levels are archived according to processing rules based on different actual situations.
优选地,第一处理规则包括:分配任务至该数据表,基于所分配的任务定时将该数据表中的数据移植至对应的归档表中,或者保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中;第二处理规则包括:分配任务至该数据表,保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中。在其他的实施例中,可以设置其他的处理规则,例如直接将该数据表中的数据全部归档至归档表中,等等,此处不再一一举例说明。Preferably, the first processing rule comprises: assigning a task to the data table, migrating the data in the data table to a corresponding archive table based on the assigned task timing, or retaining a predetermined partial data in the data table, and based on The assigned task timing migrates other unreserved data into the corresponding archive table; the second processing rule includes: assigning a task to the data table, retaining a predetermined portion of the data in the data table, and timing based on the assigned task Migrate other data that has not been retained to the corresponding archive table. In other embodiments, other processing rules may be set, such as directly archiving all the data in the data table into the archive table, and so on, which will not be exemplified herein.
在本实施例中,分配至数据表的任务例如可以是每天定期将该数据表中上一年度的数据移植至归档表中,直至将该数据表的上一年度所有数据移植至该归档表中;或者,保留该数据表中上一年度的部分数据,将上一年度的其他数据每天定期移植至归档表中,直至将该部分数据全部移植至该归档表中。In this embodiment, the task assigned to the data table may be, for example, periodically migrating the data of the previous year in the data table to the archive table, until all the data of the previous year of the data table is migrated into the archive table. Or, retain part of the data from the previous year in the data table, and periodically migrate other data from the previous year to the archive table every day until all the data is migrated to the archive table.
在具体实施过程中,在将数据表中的数据进行归档时,可以将有联系的数据进行关联处理,将重复的数据进行合并处理,以及根据数据的保存价值,对数据进行分类保存等等,以利于保存及后续的利用。In the specific implementation process, when the data in the data table is archived, the associated data can be correlated, the repeated data can be combined, and the data can be classified and saved according to the preservation value of the data, etc. To facilitate preservation and subsequent use.
如图2所示,图2为本申请数据表归档处理的方法一实施例的流程示意图,该数据表归档处理的方法包括以下步骤:As shown in FIG. 2, FIG. 2 is a schematic flowchart of an embodiment of a data table archiving process according to an embodiment of the present application. The method for archiving the data table includes the following steps:
步骤S1,建立对FAS财务数据库中的各个数据表进行监控的监控表,基于所述监控表分析各个数据表的数据量级的变化信息;Step S1: Establish a monitoring table for monitoring each data table in the FAS financial database, and analyze data change information of each data table based on the monitoring table;
本实施例中,FAS财务数据库中具有数量较多的数据表,建立监控表以对各个数据表进行监控。其中,在监控表中,包括数据表的名称、数据量级、类型信息及时间信息,例如,监控表中以表1、表2…表n的形式记录所要监控的各数据表的名称,在每一数据表的名称之后,记录对应的数据量级、类型信息及时间信息,例如对于表1,监控表中在表1之后记录一个或者多个其在各个预定的时间的数据量级。每一数据表都有对应的类型信息,包括业务类型及非业务类型,以区分该数据表是业务数据表还是非业务数据表。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. Wherein, in the monitoring table, including the name of the data table, the data magnitude, the type information, and the time information, for example, the monitoring table records the names of the data tables to be monitored in the form of Table 1, Table 2, Table n, After the name of each data table, the corresponding data magnitude, type information, and time information are recorded. For example, for Table 1, one or more data magnitudes of each of the predetermined times are recorded in Table 1 after the monitoring table. Each data table has corresponding type information, including a service type and a non-service type, to distinguish whether the data table is a business data table or a non-business data table.
本实施例中,可以实时对FAS财务数据库中的各个数据表进行监控,例如将各个数据表的数据量级随时间的变化进行记录,或者定时对FAS财务数据库中的各个数据表进行监控,优选地,定时对数据表进行监控,例如每隔1小时或者5小时捕捉各个数据表的数据量级,或者根据每个数据表的实际情况设置捕捉其数据量级的时间等,将捕捉到的数据量级记录在监控表中。In this embodiment, each data table in the FAS financial database can be monitored in real time, for example, the data magnitude of each data table is recorded with time, or each data table in the FAS financial database is periodically monitored, preferably. Ground, the data table is monitored regularly, for example, the data level of each data table is captured every 1 hour or 5 hours, or the time of capturing the data level according to the actual situation of each data table, etc., the captured data will be captured. The magnitude is recorded in the monitoring table.
在FAS财务数据库中,若某个数据表增加了新的数据,则该数据表的数据量级变大。在针对某一数据表分析其数据量级的变化信息时,优选地,可以定时获取监控表中FAS数据库中的各个数据表的数据量级,分析各个数据表的数据量级是否达到预设阈值,例如数据量级是否达到百万级;或者每隔预设时间获取监控表中FAS数据库中的各个数据表的数据量级,计算各个数 据表的数据量级的增幅,分析各个数据表的数据量级的增幅是否达到预设幅度,例如以一个月为时间间隔,分析某一数据表的数据量级连续两个月的增幅是否达到预设阈值(例如增幅为100%)。In the FAS financial database, if a new data is added to a data table, the data level of the data table becomes larger. When analyzing the change information of the data magnitude for a certain data table, preferably, the data magnitude of each data table in the FAS database in the monitoring table may be periodically obtained, and whether the data magnitude of each data table reaches a preset threshold is analyzed. For example, whether the data level reaches a million level; or obtain the data magnitude of each data table in the FAS database in the monitoring table every preset time, calculate the data magnitude increase of each data table, and analyze the data of each data table. Whether the increase of the magnitude reaches the preset range, for example, one month as the time interval, whether the increase of the data level of a certain data table for two consecutive months reaches a preset threshold (for example, an increase of 100%).
步骤S2,当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;Step S2, when the data level of the data table becomes large and the preset condition is met, generating a prompt message including the current information of the data table;
本实施例中,当有数据表的数据量级变大且满足预设的条件时,例如数据表的数据量级变大且达到预设的阈值,或者数据量级变大且预设时间间隔的增幅达到预设的阈值时,生成包含该数据表当前信息的提示消息,其中数据表当前信息包括数据表的名称、数据量级及类型信息。该提示消息用于提醒维护人员对数据表进行处理。In this embodiment, when the data level of the data table becomes large and the preset condition is met, for example, the data level of the data table becomes large and reaches a preset threshold, or the data level becomes large and the preset time interval is reached. When the increase reaches the preset threshold, a prompt message containing the current information of the data table is generated, wherein the current information of the data table includes the name of the data table, the data magnitude, and the type information. The prompt message is used to remind the maintenance personnel to process the data table.
其中,该提示消息可以以预定的格式发送至预定的终端上并进行提醒,或者发送至维护人员佩戴的移动终端上并进行提醒,该提示消息的预定的格式例如为“表1、数据量级**、类型信息**”。The prompt message may be sent to the predetermined terminal in a predetermined format and sent to the mobile terminal and sent to the mobile terminal worn by the maintenance personnel, and the predetermined format of the prompt message is, for example, “Table 1, data volume level”. **, type information**".
步骤S3,获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。Step S3: Obtain a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
其中,在一实施例中,处理规则可以是维护人员预先设定的,其包括多种,各处理规则与数据表的数据量级及类型信息对应关联,在生成包含该数据表当前信息的提示消息后,基于该提示消息中的当前信息自动获取预先设定的处理规则,基于该处理规则对该数据表进行归档处理。在其他实施例中,该处理规则可以是维护人员现场进行设置的,即当维护文员收到针对FAS财务数据库中的数据表的提示消息时,基于数据表的数据量级及类型信息对该数据表设置出相应的处理规则,基于该处理规则对该数据表进行归档处理。In an embodiment, the processing rule may be preset by the maintenance personnel, and includes multiple types, and each processing rule is associated with the data magnitude and the type information of the data table, and the prompt for generating the current information of the data table is generated. After the message, the preset processing rule is automatically acquired 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 rule may be set by the maintenance personnel on site, that is, when the maintenance clerk receives the prompt message for the data table in the FAS financial database, the data is based on the data magnitude and type information of the data table. The table sets the corresponding processing rule, and the data table is archived based on the processing rule.
其中,处理规则可以是定期对数据表进行归档,也可以是直接将全部数据表进行归档等。The processing rule may be that the data table is archived periodically, or all the data tables may be directly archived.
与现有技术相比,本实施例建立对FAS财务数据库中的各个数据表的数据量级进行监控的监控表,在有数据表的数据量级变较大或增幅较大时,获取预先设定的处理规则或者提醒维修人员现场设置对应的处理规则,根据该处理规则对数据表进行归档处理,本实施例能够及时处理FAS财务数据库中数据量级过大的数据表,将其进行归档,提升***性能,便于***的管理及维护。Compared with the prior art, the present embodiment establishes a monitoring table for monitoring the data magnitude of each data table in the FAS financial database. When the data level of the data table becomes larger or increases, the pre-set is obtained. The processing rule or the maintenance personnel is required to set corresponding processing rules on the spot, and the data table is archived according to the processing rule. This embodiment can timely process the data table of the FAS financial database with excessive data size and archive it. Improve system performance and facilitate system management and maintenance.
在一优选的实施例中,在上述图2的实施例的基础上,所述步骤S3包括:若数据表的业务类型为非业务类型,则获取基于所述非业务类型设定的的第一处理规则,基于该第一处理规则对该数据表进行归档处理;若数据表的业务类型为业务类型,则获取基于所述业务类型设定的第二处理规则,基于该第二处理规则对该数据表进行归档处理。In a preferred embodiment, on the basis of the foregoing embodiment of FIG. 2, the step S3 includes: if the service type of the data table is a non-service type, acquiring the first set based on the non-service type Processing a rule, performing an archiving process on the data table based on the first processing rule; if the service type of the data table is a service type, acquiring a second processing rule set based on the service type, based on the second processing rule The data table is archived.
在一实施例中,处理规则包括维护人员预先设定的第一处理规则及维护人员现场进行设置第二处理规则,类型信息包括业务类型(例如报销单、报账单或***等)及非业务类型(例如审批记录表等):若数据表的业务类型为非业务类型,则获取基于所述非业务类型设定对应的第一处理规则,基于该第一处理规则对该数据表进行归档处理;若数据表的业务类型为业务类型,则获取基于所述业务类型设定对应的第二处理规则,基于该第二处理规则对该数据表进行归档处理。本实施例提供灵活的设置处理规则的方式,使得数据量级大的数据表按照基于不同的实际情况的处理规则进行归档。In an embodiment, the processing rule includes a first processing rule preset by the maintenance personnel and a second processing rule set by the maintenance personnel on the spot, and the type information includes a service type (such as a reimbursement form, a bill or an invoice, etc.) and a non-service type. (for example, an approval record table, etc.): if the service type of the data table is a non-service type, obtaining a first processing rule corresponding to the non-service type setting, and archiving the data table based on the first processing rule; If the service type of the data table is a service type, the second processing rule corresponding to the service type setting is obtained, and the data table is archived based on the second processing rule. This embodiment provides a flexible manner of setting processing rules, so that data tables with large data levels are archived according to processing rules based on different actual situations.
优选地,第一处理规则包括:分配任务至该数据表,基于所分配的任务定时将该数据表中的数据移植至对应的归档表中,或者保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中;第二处理规则包括:分配任务至该数据表,保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中。在其他的实施例中,可以设置其他的处理规则,例如直接将 该数据表中的数据全部归档至归档表中,等等,此处不再一一举例说明。Preferably, the first processing rule comprises: assigning a task to the data table, migrating the data in the data table to a corresponding archive table based on the assigned task timing, or retaining a predetermined partial data in the data table, and based on The assigned task timing migrates other unreserved data into the corresponding archive table; the second processing rule includes: assigning a task to the data table, retaining a predetermined portion of the data in the data table, and timing based on the assigned task Migrate other data that has not been retained to the corresponding archive table. In other embodiments, other processing rules may be set, such as directly archiving all the data in the data table into the archive table, and so on, which will not be exemplified herein.
在本实施例中,分配至数据表的任务例如可以是每天定期将该数据表中上一年度的数据移植至归档表中,直至将该数据表的上一年度所有数据移植至该归档表中;或者,保留该数据表中上一年度的部分数据,将上一年度的其他数据每天定期移植至归档表中,直至将该部分数据全部移植至该归档表中。In this embodiment, the task assigned to the data table may be, for example, periodically migrating the data of the previous year in the data table to the archive table, until all the data of the previous year of the data table is migrated into the archive table. Or, retain part of the data from the previous year in the data table, and periodically migrate other data from the previous year to the archive table every day until all the data is migrated to the archive table.
在具体实施过程中,在将数据表中的数据进行归档时,可以将有联系的数据进行关联处理,将重复的数据进行合并处理,以及根据数据的保存价值,对数据进行分类保存等等,以利于保存及后续的利用。In the specific implementation process, when the data in the data table is archived, the associated data can be correlated, the repeated data can be combined, and the data can be classified and saved according to the preservation value of the data, etc. To facilitate preservation and subsequent use.
本申请还提供一种计算机可读存储介质,所述计算机可读存储介质上存储有处理***,所述处理***被处理器执行时实现上述的数据表归档处理的方法的步骤。The present application also provides a computer readable storage medium having stored thereon a processing system, the processing system being executed by a processor to implement the steps of the data table archiving process described above.
上述本申请实施例序号仅仅为了描述,不代表实施例的优劣。The serial numbers of the embodiments of the present application are merely for the description, and do not represent the advantages and disadvantages of the embodiments.
通过以上的实施方式的描述,本领域的技术人员可以清楚地了解到上述实施例方法可借助软件加必需的通用硬件平台的方式来实现,当然也可以通过硬件,但很多情况下前者是更佳的实施方式。基于这样的理解,本申请的技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来,该计算机软件产品存储在一个存储介质(如ROM/RAM、磁碟、光盘)中,包括若干指令用以使得一台终端设备(可以是手机,计算机,服务器,空调器,或者网络设备等)执行本申请各个实施例所述的方法。Through the description of the above embodiments, those skilled in the art can clearly understand that the foregoing embodiment method can be implemented by means of software plus a necessary general hardware platform, and of course, can also be through hardware, but in many cases, the former is better. Implementation. Based on such understanding, the technical solution of the present application, which is essential or contributes to the prior art, may be embodied in the form of a software product stored in a storage medium (such as ROM/RAM, disk, The optical disc includes a number of instructions for causing a terminal device (which may be a mobile phone, a computer, a server, an air conditioner, or a network device, etc.) to perform the methods described in various embodiments of the present application.
以上仅为本申请的优选实施例,并非因此限制本申请的专利范围,凡是利用本申请说明书及附图内容所作的等效结构或等效流程变换,或直接或间接运用在其他相关的技术领域,均同理包括在本申请的专利保护范围内。The above is only a preferred embodiment of the present application, and is not intended to limit the scope of the patent application, and the equivalent structure or equivalent process transformations made by the specification and the drawings of the present application, or directly or indirectly applied to other related technical fields. The same is included in the scope of patent protection of this application.
Claims (20)
- 一种电子装置,其特征在于,所述电子装置包括存储器及与所述存储器连接的处理器,所述存储器中存储有可在所述处理器上运行的处理***,所述处理***被所述处理器执行时实现如下步骤:An electronic device, comprising: a memory and a processor coupled to the memory, wherein the memory stores a processing system operable on the processor, the processing system being The processor implements the following steps when it executes:S101,建立对FAS财务数据库中的各个数据表进行监控的监控表,基于所述监控表分析各个数据表的数据量级的变化信息;S101: Establish a monitoring table for monitoring each data table in the FAS financial database, and analyze, according to the monitoring table, data change information of each data table;S102,当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;S102. When a data level of the data table becomes larger and meets a preset condition, generating a prompt message that includes current information of the data table.S103,获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。S103. Acquire a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
- 根据权利要求1所述的电子装置,其特征在于,所述步骤S101中基于所述监控表分析各个数据表的数据量级的变化信息包括:The electronic device according to claim 1, wherein the analyzing the change information of the data magnitude of each data table based on the monitoring table in the step S101 comprises:定时获取所述监控表中FAS数据库中的各个数据表的数据量级,分析各个数据表的数据量级是否达到预设阈值;或者Obtaining, at a time, the data magnitude of each data table in the FAS database in the monitoring table, and analyzing whether the data magnitude of each data table reaches a preset threshold; or定时获取所述监控表中FAS数据库中的各个数据表的数据量级,计算各个数据表的数据量级在预定的时间间隔内的增幅,分析各个数据表的数据量级的增幅是否达到预设幅度。Regularly obtaining the data magnitude of each data table in the FAS database in the monitoring table, calculating the increase of the data magnitude of each data table in a predetermined time interval, and analyzing whether the data level of each data table increases by a preset amount. Amplitude.
- 根据权利要求1或2所述的电子装置,其特征在于,所述数据表当前信息包括类型信息,所述类型信息包括业务类型及非业务类型,所述处理规则包括第一处理规则及第二处理规则,所述步骤S103包括:The electronic device according to claim 1 or 2, wherein the data table current information includes type information, the type information includes a service type and a non-service type, and the processing rule includes a first processing rule and a second Processing the rule, the step S103 includes:若数据表的业务类型为非业务类型,则获取基于所述非业务类型设定的的第一处理规则,基于该第一处理规则对该数据表进行归档处理;If the service type of the data table is a non-service type, acquiring a first processing rule that is set based on the non-service type, and performing archiving processing on the data table based on the first processing rule;若数据表的业务类型为业务类型,则获取基于所述业务类型设定的第二处理规则,基于该第二处理规则对该数据表进行归档处理。If the service type of the data table is a service type, the second processing rule set based on the service type is obtained, and the data table is archived based on the second processing rule.
- 根据权利要求3所述的电子装置,其特征在于,所述第一处理规则包 括:分配任务至该数据表,基于所分配的任务定时将该数据表中的数据移植至对应的归档表中,或者保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中;The electronic device according to claim 3, wherein the first processing rule comprises: assigning a task to the data table, and migrating the data in the data table to a corresponding archive table based on the assigned task timing, Or retain a predetermined portion of the data in the data table, and migrate other unreserved data to the corresponding archive table based on the assigned task timing;所述第二处理规则包括:分配任务至该数据表,保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中。The second processing rule includes: assigning a task to the data table, retaining a predetermined portion of data in the data table, and migrating other unreserved data to a corresponding archive table based on the assigned task timing.
- 根据权利要求4所述的电子装置,其特征在于,在将数据移植至对应的归档表中时,所述处理***被所述处理器执行时实现如下步骤:对该数据进行关联处理、合并处理和/或分类保存。The electronic device according to claim 4, wherein when the data is transplanted into the corresponding archive table, the processing system is executed by the processor to implement the following steps: performing association processing and merging processing on the data. And / or classified to save.
- 一种数据表归档处理的方法,其特征在于,所述方法包括:A method for data table archiving processing, the method comprising:S1,建立对FAS财务数据库中的各个数据表进行监控的监控表,基于所述监控表分析各个数据表的数据量级的变化信息;S1, establishing a monitoring table for monitoring each data table in the FAS financial database, and analyzing data change information of each data table based on the monitoring table;S2,当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;S2, when the data level of the data table becomes large and meets the preset condition, generating a prompt message including current information of the data table;S3,获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。S3: Obtain a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
- 根据权利要求6所述的数据表归档处理的方法,其特征在于,所述步骤S1中基于所述监控表分析各个数据表的数据量级的变化信息包括:The method for processing data table archiving according to claim 6, wherein the analyzing the change information of the data magnitude of each data table based on the monitoring table in the step S1 comprises:定时获取所述监控表中FAS数据库中的各个数据表的数据量级,分析各个数据表的数据量级是否达到预设阈值;或者Obtaining, at a time, the data magnitude of each data table in the FAS database in the monitoring table, and analyzing whether the data magnitude of each data table reaches a preset threshold; or定时获取所述监控表中FAS数据库中的各个数据表的数据量级,计算各个数据表的数据量级在预定的时间间隔内的增幅,分析各个数据表的数据量级的增幅是否达到预设幅度。Regularly obtaining the data magnitude of each data table in the FAS database in the monitoring table, calculating the increase of the data magnitude of each data table in a predetermined time interval, and analyzing whether the data level of each data table increases by a preset amount. Amplitude.
- 根据权利要求6或7所述的数据表归档处理的方法,其特征在于,所述数据表当前信息包括类型信息,所述类型信息包括业务类型及非业务类 型,所述处理规则包括第一处理规则及第二处理规则,所述步骤S3包括:The data table archival processing method according to claim 6 or 7, wherein the data table current information includes type information, the type information includes a service type and a non-service type, and the processing rule includes a first process. The rule and the 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 that is set based on the non-service type, and performing archiving processing on the data table based on the first processing rule;若数据表的业务类型为业务类型,则获取基于所述业务类型设定的第二处理规则,基于该第二处理规则对该数据表进行归档处理。If the service type of the data table is a service type, the second processing rule set based on the service type is obtained, and the data table is archived based on the second processing rule.
- 根据权利要求8所述的数据表归档处理的方法,其特征在于,所述第一处理规则包括:分配任务至该数据表,基于所分配的任务定时将该数据表中的数据移植至对应的归档表中,或者保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中;The method of data table archiving processing according to claim 8, wherein the first processing rule comprises: assigning a task to the data table, and transplanting data in the data table to a corresponding one based on the assigned task timing Archive the table, or retain the predetermined part of the data in the data table, and transplant other unreserved data to the corresponding archive table based on the assigned task timing;所述第二处理规则包括:分配任务至该数据表,保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中。The second processing rule includes: assigning a task to the data table, retaining a predetermined portion of data in the data table, and migrating other unreserved data to a corresponding archive table based on the assigned task timing.
- 根据权利要求9所述的数据表归档处理的方法,其特征在于,在将数据移植至对应的归档表中时,还对该数据进行关联处理、合并处理和/或分类保存。The method of data table archival processing according to claim 9, wherein when the data is migrated to the corresponding archive table, the data is also subjected to association processing, merge processing, and/or classification storage.
- 一种数据表归档处理的***,其特征在于,包括:A system for data table archiving processing, comprising:分析模块,用于建立对FAS财务数据库中的各个数据表进行监控的监控表,基于所述监控表分析各个数据表的数据量级的变化信息;An analysis module, configured to establish a monitoring table for monitoring each data table in the FAS financial database, and analyzing data change information of each data table based on the monitoring table;生成模块,用于当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;a generating module, configured to generate a prompt message including current information of the data table when the data level of the data table becomes large and meets a preset condition;归档模块,用于获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。The archiving module is configured to obtain a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
- 根据权利要求11所述的数据表归档处理的***,其特征在于,所述分析模块具体用于:The system for data table archiving processing according to claim 11, wherein the analysis module is specifically configured to:定时获取所述监控表中FAS数据库中的各个数据表的数据量级,分析各 个数据表的数据量级是否达到预设阈值;或者Obtaining, at a time, the data magnitude of each data table in the FAS database in the monitoring table, and analyzing whether the data magnitude of each data table reaches a preset threshold; or定时获取所述监控表中FAS数据库中的各个数据表的数据量级,计算各个数据表的数据量级在预定的时间间隔内的增幅,分析各个数据表的数据量级的增幅是否达到预设幅度。Regularly obtaining the data magnitude of each data table in the FAS database in the monitoring table, calculating the increase of the data magnitude of each data table in a predetermined time interval, and analyzing whether the data level of each data table increases by a preset amount. Amplitude.
- 根据权利要求11或12所述的数据表归档处理的***,其特征在于,所述数据表当前信息包括类型信息,所述类型信息包括业务类型及非业务类型,所述处理规则包括第一处理规则及第二处理规则,所述归档模块具体用于,若数据表的业务类型为非业务类型,则获取基于所述非业务类型设定的的第一处理规则,基于该第一处理规则对该数据表进行归档处理;若数据表的业务类型为业务类型,则获取基于所述业务类型设定的第二处理规则,基于该第二处理规则对该数据表进行归档处理。The data table archival processing system according to claim 11 or 12, wherein the data table current information includes type information, the type information includes a service type and a non-service type, and the processing rule includes a first process. a rule and a second processing rule, the archiving module is specifically configured to: if the service type of the data table is a non-service type, obtain a first processing rule that is set based on the non-service type, based on the first processing rule The data table is archived; if the service type of the data table is a service type, a second processing rule set based on the service type is obtained, and the data table is archived based on the second processing rule.
- 根据权利要求13所述的数据表归档处理的***,其特征在于,所述第一处理规则包括:分配任务至该数据表,基于所分配的任务定时将该数据表中的数据移植至对应的归档表中,或者保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中;The system for data table archiving processing according to claim 13, wherein the first processing rule comprises: assigning a task to the data table, and transplanting data in the data table to a corresponding one based on the assigned task timing Archive the table, or retain the predetermined part of the data in the data table, and transplant other unreserved data to the corresponding archive table based on the assigned task timing;所述第二处理规则包括:分配任务至该数据表,保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中。The second processing rule includes: assigning a task to the data table, retaining a predetermined portion of data in the data table, and migrating other unreserved data to a corresponding archive table based on the assigned task timing.
- 根据权利要求14所述的数据表归档处理的***,其特征在于,所述归档模块进一步用于在将数据移植至对应的归档表中时,还对该数据进行关联处理、合并处理和/或分类保存。The system of data table archiving processing according to claim 14, wherein the archiving module is further configured to perform association processing, merge processing, and/or data migration when the data is migrated to the corresponding archive table. Classified save.
- 一种计算机可读存储介质,其特征在于,所述计算机可读存储介质上存储有处理***,所述处理***被处理器执行时实现步骤:A computer readable storage medium, wherein the computer readable storage medium stores a processing system, and when the processing system is executed by the processor, the steps are:S101,建立对FAS财务数据库中的各个数据表进行监控的监控表,基于所述监控表分析各个数据表的数据量级的变化信息;S101: Establish a monitoring table for monitoring each data table in the FAS financial database, and analyze, according to the monitoring table, data change information of each data table;S102,当有数据表的数据量级变大且满足预设的条件时,生成包含该数据表当前信息的提示消息;S102. When a data level of the data table becomes larger and meets a preset condition, generating a prompt message that includes current information of the data table.S103,获取基于该数据表当前信息设定的处理规则,基于该处理规则对该数据表进行归档处理。S103. Acquire a processing rule set based on current information of the data table, and perform archiving processing on the data table based on the processing rule.
- 根据权利要求16所述的计算机可读存储介质,其特征在于,所述步骤S101中基于所述监控表分析各个数据表的数据量级的变化信息包括:The computer readable storage medium according to claim 16, wherein the analyzing the change information of the data magnitude of each data table based on the monitoring table in the step S101 comprises:定时获取所述监控表中FAS数据库中的各个数据表的数据量级,分析各个数据表的数据量级是否达到预设阈值;或者Obtaining, at a time, the data magnitude of each data table in the FAS database in the monitoring table, and analyzing whether the data magnitude of each data table reaches a preset threshold; or定时获取所述监控表中FAS数据库中的各个数据表的数据量级,计算各个数据表的数据量级在预定的时间间隔内的增幅,分析各个数据表的数据量级的增幅是否达到预设幅度。Regularly obtaining the data magnitude of each data table in the FAS database in the monitoring table, calculating the increase of the data magnitude of each data table in a predetermined time interval, and analyzing whether the data level of each data table increases by a preset amount. Amplitude.
- 根据权利要求16或17所述的计算机可读存储介质,其特征在于,所述数据表当前信息包括类型信息,所述类型信息包括业务类型及非业务类型,所述处理规则包括第一处理规则及第二处理规则,所述步骤S103包括:The computer readable storage medium according to claim 16 or 17, wherein the data table current information includes type information, the type information includes a service type and a non-service type, and the processing rule includes a first processing rule. And the 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 that is set based on the non-service type, and performing archiving processing on the data table based on the first processing rule;若数据表的业务类型为业务类型,则获取基于所述业务类型设定的第二处理规则,基于该第二处理规则对该数据表进行归档处理。If the service type of the data table is a service type, the second processing rule set based on the service type is obtained, and the data table is archived based on the second processing rule.
- 根据权利要求18所述的计算机可读存储介质,其特征在于,所述第一处理规则包括:分配任务至该数据表,基于所分配的任务定时将该数据表中的数据移植至对应的归档表中,或者保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中;The computer readable storage medium of claim 18, wherein the first processing rule comprises: assigning a task to the data table, and migrating data in the data table to a corresponding archive based on the assigned task timing In the table, or retain a predetermined part of the data in the data table, and transplant other unreserved data to the corresponding archive table based on the assigned task timing;所述第二处理规则包括:分配任务至该数据表,保留该数据表中预定的部分数据,并基于所分配的任务定时将其他未进行保留的数据移植至对应的归档表中。The second processing rule includes: assigning a task to the data table, retaining a predetermined portion of data in the data table, and migrating other unreserved data to a corresponding archive table based on the assigned task timing.
- 根据权利要求19所述的计算机可读存储介质,其特征在于,在将数据移植至对应的归档表中时,所述处理***被所述处理器执行时实现如下步骤:对该数据进行关联处理、合并处理和/或分类保存。The computer readable storage medium according to claim 19, wherein when the data is migrated into the corresponding archive table, the processing system is executed by the processor to implement the following steps: correlating the data , merge processing and/or classification saving.
Applications Claiming Priority (2)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710916067.3 | 2017-09-30 | ||
CN201710916067.3A CN107870981B (en) | 2017-09-30 | 2017-09-30 | Electronic device, data sheet filing method and storage medium |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2019062189A1 true WO2019062189A1 (en) | 2019-04-04 |
Family
ID=61752728
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
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 |
Country Status (2)
Country | Link |
---|---|
CN (1) | CN107870981B (en) |
WO (1) | WO2019062189A1 (en) |
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110888774A (en) * | 2019-11-07 | 2020-03-17 | 中盈优创资讯科技有限公司 | Big data report processing method and device based on HBASE |
CN112783732A (en) * | 2021-01-29 | 2021-05-11 | 中国农业银行股份有限公司 | Database table capacity monitoring method and device |
CN112988664A (en) * | 2021-03-11 | 2021-06-18 | 中国平安财产保险股份有限公司 | Data archiving method, device, equipment and storage medium |
CN113448939A (en) * | 2020-03-24 | 2021-09-28 | 北京有限元科技有限公司 | Data archiving and storing method and device and storage medium |
CN113821501A (en) * | 2021-08-12 | 2021-12-21 | 马上消费金融股份有限公司 | Data archiving method and device |
CN116756089A (en) * | 2023-08-21 | 2023-09-15 | 湖南云档信息科技有限公司 | File archiving scheme forming method, system and storage medium |
Families Citing this family (6)
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 |
CN111190898B (en) * | 2019-11-25 | 2023-07-14 | 泰康保险集团股份有限公司 | Data processing method and device, electronic equipment and storage medium |
CN112817834B (en) * | 2021-01-22 | 2022-11-01 | 上海哔哩哔哩科技有限公司 | Data table evaluation method and device |
Citations (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
CN104462461A (en) * | 2014-12-16 | 2015-03-25 | 用友软件股份有限公司 | Form null value check processing method and device |
CN104636483A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Data monitoring method |
CN106446271A (en) * | 2016-10-20 | 2017-02-22 | 焦点科技股份有限公司 | Design method of BI data interface |
CN107870981A (en) * | 2017-09-30 | 2018-04-03 | 平安科技(深圳)有限公司 | Electronic installation, the method and storage medium of tables of data filing processing |
Family Cites Families (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20090198699A1 (en) * | 2008-01-31 | 2009-08-06 | International Business Machines Corporation | Remote space efficient repository |
CN101639839B (en) * | 2008-07-30 | 2011-10-26 | 中兴通讯股份有限公司 | Method for searching multi-archive file based on temporary table |
CN101364897A (en) * | 2008-09-17 | 2009-02-11 | 中兴通讯股份有限公司 | System for historical data archiving and implementing method |
US8782369B2 (en) * | 2011-11-15 | 2014-07-15 | Lsi Corporation | Apparatus to manage efficient data migration between tiers |
CN102930062B (en) * | 2012-11-30 | 2016-04-13 | 南京富士通南大软件技术有限公司 | The method of the quick horizontal extension of a kind of database |
CN103106247A (en) * | 2012-12-31 | 2013-05-15 | 普天新能源有限责任公司 | Data dump method and system |
US9396131B1 (en) * | 2013-02-08 | 2016-07-19 | Workday, Inc. | Dynamic three-tier data storage utilization |
CN103514295B (en) * | 2013-10-10 | 2016-09-28 | 中国电子科技集团公司第十五研究所 | historical data archiving method and historical data archiving device |
CN106156038B (en) * | 2015-03-26 | 2019-11-29 | 腾讯科技(深圳)有限公司 | Date storage method and device |
CN104899491B (en) * | 2015-05-28 | 2017-11-14 | 广东欧珀移动通信有限公司 | A kind of data transfering method and its device |
CN104881477B (en) * | 2015-06-03 | 2018-09-21 | 上海新炬网络信息技术股份有限公司 | A kind of application data space uses evaluation method |
-
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 (5)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101354713A (en) * | 2008-09-08 | 2009-01-28 | 大唐软件技术股份有限公司 | Method and system for storing data |
CN104462461A (en) * | 2014-12-16 | 2015-03-25 | 用友软件股份有限公司 | Form null value check processing method and device |
CN104636483A (en) * | 2015-02-16 | 2015-05-20 | 广东省公安厅 | Data monitoring method |
CN106446271A (en) * | 2016-10-20 | 2017-02-22 | 焦点科技股份有限公司 | Design method of BI data interface |
CN107870981A (en) * | 2017-09-30 | 2018-04-03 | 平安科技(深圳)有限公司 | Electronic installation, the method and storage medium of tables of data filing processing |
Cited By (11)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110888774A (en) * | 2019-11-07 | 2020-03-17 | 中盈优创资讯科技有限公司 | Big data report processing method and device based on HBASE |
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 |
CN112783732A (en) * | 2021-01-29 | 2021-05-11 | 中国农业银行股份有限公司 | Database table capacity monitoring method and device |
CN112783732B (en) * | 2021-01-29 | 2023-10-10 | 中国农业银行股份有限公司 | Database table capacity monitoring method and device |
CN112988664A (en) * | 2021-03-11 | 2021-06-18 | 中国平安财产保险股份有限公司 | Data archiving method, device, equipment and storage medium |
CN112988664B (en) * | 2021-03-11 | 2023-05-30 | 中国平安财产保险股份有限公司 | Data archiving method, device, equipment and storage medium |
CN113821501A (en) * | 2021-08-12 | 2021-12-21 | 马上消费金融股份有限公司 | Data archiving method and device |
CN113821501B (en) * | 2021-08-12 | 2023-05-16 | 马上消费金融股份有限公司 | Data archiving method and device |
CN116756089A (en) * | 2023-08-21 | 2023-09-15 | 湖南云档信息科技有限公司 | File archiving scheme forming method, system and storage medium |
CN116756089B (en) * | 2023-08-21 | 2023-11-03 | 湖南云档信息科技有限公司 | File archiving scheme forming method, system and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN107870981A (en) | 2018-04-03 |
CN107870981B (en) | 2021-10-22 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
WO2019062189A1 (en) | Electronic device, method and system for conducting data table filing processing, and storage medium | |
WO2019085471A1 (en) | Database synchronization method, application server, and computer readable storage medium | |
US9552161B2 (en) | Repetitive data block deleting system and method | |
US9811529B1 (en) | Automatically redistributing data of multiple file systems in a distributed storage system | |
WO2019196304A1 (en) | Electronic apparatus, credit feedback message parsing method, and storage medium | |
WO2019071959A1 (en) | Channel addition method, application server, and computer readable storage medium | |
US20140280610A1 (en) | Identification of users for initiating information spreading in a social network | |
US8977587B2 (en) | Sampling transactions from multi-level log file records | |
WO2019104982A1 (en) | Comprehensive attendance management and control method, application server and computer readable storage medium | |
CN108134696A (en) | A kind of micro services configuration update method and device | |
CN111274256A (en) | Resource control method, device, equipment and storage medium based on time sequence database | |
WO2019169763A1 (en) | Electronic apparatus, service system risk control method, and storage medium | |
WO2019071968A1 (en) | Salary calculation method, application server, and computer readable storage medium | |
WO2019085463A1 (en) | Department demand recommendation method, application server, and computer-readable storage medium | |
WO2019095673A1 (en) | Employee training enrollment method, application server, and computer readable storage medium | |
RU2665272C1 (en) | Method and apparatus for restoring deduplicated data | |
CN111159183B (en) | Report generation method, electronic device and computer readable storage medium | |
CN112328592A (en) | Data storage method, electronic device and computer readable storage medium | |
WO2019071964A1 (en) | Enterprise relationship construction method, and application server | |
WO2019071958A1 (en) | Cloud computing-based salary calculation method, application server, and computer readable storage medium | |
US10210165B2 (en) | File management for eDiscovery | |
US7519610B2 (en) | Method and apparatus for efficiently storing audit event data having diverse characteristics using tiered tables | |
US10635635B2 (en) | Metering data in distributed storage environments | |
CN109446167A (en) | A kind of storage of daily record data, extracting method and device | |
WO2019080424A1 (en) | Customer migration method and system, computer device and storage medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
32PN | Ep: public notification in the ep bulletin as address of the adressee cannot be established |
Free format text: NOTING OF LOSS OF RIGHTS PURSUANT TO RULE 112(1) EPC (EPO FORM 1205A DATED 07/10/2020) |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 18861190 Country of ref document: EP Kind code of ref document: A1 |