WO2019062189A1 - Dispositif électronique, procédé et système pour effectuer un traitement de classement sur une table de données, et support de stockage - Google Patents

Dispositif électronique, procédé et système pour effectuer un traitement de classement sur une table de données, et support de stockage Download PDF

Info

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
Application number
PCT/CN2018/089708
Other languages
English (en)
Chinese (zh)
Inventor
王政
邹学森
Original Assignee
平安科技（深圳）有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 平安科技（深圳）有限公司 filed Critical 平安科技（深圳）有限公司
Publication of WO2019062189A1 publication Critical patent/WO2019062189A1/fr

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)
  • Finance (AREA)
  • Databases & Information Systems (AREA)
  • Accounting & Taxation (AREA)
  • Data Mining & Analysis (AREA)
  • Computing Systems (AREA)
  • Quality & Reliability (AREA)
  • Development Economics (AREA)
  • Mathematical Physics (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Strategic Management (AREA)
  • Technology Law (AREA)
  • General Business, Economics & Management (AREA)
  • Software Systems (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)

Abstract

La présente invention concerne un dispositif électronique, un procédé et un système pour effectuer un traitement de classement sur une table de données, et un support de stockage. Le dispositif électronique comprend une mémoire et un processeur connecté à la mémoire; un système de traitement, qui peut être mis en oeuvre sur le processeur, est stocké dans la mémoire; et le système de traitement est exécuté par le processeur pour réaliser les étapes suivantes consistant à : établir une table de surveillance pour surveiller chaque table de données dans une base de données financières FAS, et analyser, sur la base de la table de surveillance, des informations de changement concernant une amplitude de données de chaque table de données; lorsque l'amplitude de données d'une table de données augmente et satisfait une condition prédéfinie, générer un message d'invite qui contient des informations courantes concernant la table de données; et acquérir une règle de traitement qui est définie sur la base des informations courantes concernant la table de données, et sur la base de la règle de traitement, effectuer un traitement de classement sur la table de données. Selon la présente invention, des tables de données ayant des amplitudes de données excessives dans une base de données financière FAS peuvent être traitées de manière opportune et classées, ce qui permet d'améliorer les performances du système et de faciliter la gestion et la maintenance d'un système.
PCT/CN2018/089708 2017-09-30 2018-06-03 Dispositif électronique, procédé et système pour effectuer un traitement de classement sur une table de données, et support de stockage WO2019062189A1 (fr)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN201710916067.3A CN107870981B (zh) 2017-09-30 2017-09-30 电子装置、数据表归档处理的方法及存储介质
CN201710916067.3 2017-09-30

Publications (1)

Publication Number Publication Date
WO2019062189A1 true WO2019062189A1 (fr) 2019-04-04

Family

ID=61752728

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/CN2018/089708 WO2019062189A1 (fr) 2017-09-30 2018-06-03 Dispositif électronique, procédé et système pour effectuer un traitement de classement sur une table de données, et support de stockage

Country Status (2)

Country Link
CN (1) CN107870981B (fr)
WO (1) WO2019062189A1 (fr)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110888774A (zh) * 2019-11-07 2020-03-17 中盈优创资讯科技有限公司 基于hbase的大数据报表处理方法及装置
CN112783732A (zh) * 2021-01-29 2021-05-11 中国农业银行股份有限公司 一种数据库表容量监控方法及装置
CN112988664A (zh) * 2021-03-11 2021-06-18 中国平安财产保险股份有限公司 数据归档方法、装置、设备及存储介质
CN113448939A (zh) * 2020-03-24 2021-09-28 北京有限元科技有限公司 数据归档存储的方法、装置以及存储介质
CN113821501A (zh) * 2021-08-12 2021-12-21 马上消费金融股份有限公司 一种数据归档方法及装置
CN116756089A (zh) * 2023-08-21 2023-09-15 湖南云档信息科技有限公司 一种档案归档方案形成方法、系统及存储介质

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN107870981B (zh) * 2017-09-30 2021-10-22 平安科技（深圳）有限公司 电子装置、数据表归档处理的方法及存储介质
CN109815094B (zh) * 2019-01-04 2023-01-10 平安科技（深圳）有限公司 数据表的监控方法、装置、设备及计算机可读存储介质
CN110362531A (zh) * 2019-06-17 2019-10-22 众安在线财产保险股份有限公司 一种自动归档方法及装置
CN110457255B (zh) * 2019-07-05 2023-11-21 中国平安人寿保险股份有限公司 数据归档的方法、服务器及计算机可读存储介质
CN111190898B (zh) * 2019-11-25 2023-07-14 泰康保险集团股份有限公司 一种数据处理的方法及装置、电子设备、存储介质
CN112817834B (zh) * 2021-01-22 2022-11-01 上海哔哩哔哩科技有限公司 数据表评估方法及装置

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101354713A (zh) * 2008-09-08 2009-01-28 大唐软件技术股份有限公司 数据存储方法和系统
CN104462461A (zh) * 2014-12-16 2015-03-25 用友软件股份有限公司 对表单进行排查空值处理的方法及装置
CN104636483A (zh) * 2015-02-16 2015-05-20 广东省公安厅 一种数据监控方法
CN106446271A (zh) * 2016-10-20 2017-02-22 焦点科技股份有限公司 一种bi数据接口设计方法
CN107870981A (zh) * 2017-09-30 2018-04-03 平安科技（深圳）有限公司 电子装置、数据表归档处理的方法及存储介质

Family Cites Families (11)

* Cited by examiner, † Cited by third party
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 (zh) * 2008-07-30 2011-10-26 中兴通讯股份有限公司 一种基于临时表的多归档文件查询方法
CN101364897A (zh) * 2008-09-17 2009-02-11 中兴通讯股份有限公司 一种历史数据归档的系统与实现方法
US8782369B2 (en) * 2011-11-15 2014-07-15 Lsi Corporation Apparatus to manage efficient data migration between tiers
CN102930062B (zh) * 2012-11-30 2016-04-13 南京富士通南大软件技术有限公司 一种数据库快速水平扩展的方法
CN103106247A (zh) * 2012-12-31 2013-05-15 普天新能源有限责任公司 数据转储方法和系统
US9396131B1 (en) * 2013-02-08 2016-07-19 Workday, Inc. Dynamic three-tier data storage utilization
CN103514295B (zh) * 2013-10-10 2016-09-28 中国电子科技集团公司第十五研究所 历史数据归档方法及历史数据归档装置
CN106156038B (zh) * 2015-03-26 2019-11-29 腾讯科技（深圳）有限公司 数据存储方法和装置
CN104899491B (zh) * 2015-05-28 2017-11-14 广东欧珀移动通信有限公司 一种数据转移方法及其装置
CN104881477B (zh) * 2015-06-03 2018-09-21 上海新炬网络信息技术股份有限公司 一种应用数据空间使用估算方法

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101354713A (zh) * 2008-09-08 2009-01-28 大唐软件技术股份有限公司 数据存储方法和系统
CN104462461A (zh) * 2014-12-16 2015-03-25 用友软件股份有限公司 对表单进行排查空值处理的方法及装置
CN104636483A (zh) * 2015-02-16 2015-05-20 广东省公安厅 一种数据监控方法
CN106446271A (zh) * 2016-10-20 2017-02-22 焦点科技股份有限公司 一种bi数据接口设计方法
CN107870981A (zh) * 2017-09-30 2018-04-03 平安科技（深圳）有限公司 电子装置、数据表归档处理的方法及存储介质

Cited By (11)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110888774A (zh) * 2019-11-07 2020-03-17 中盈优创资讯科技有限公司 基于hbase的大数据报表处理方法及装置
CN110888774B (zh) * 2019-11-07 2023-06-23 中盈优创资讯科技有限公司 基于hbase的大数据报表处理方法及装置
CN113448939A (zh) * 2020-03-24 2021-09-28 北京有限元科技有限公司 数据归档存储的方法、装置以及存储介质
CN112783732A (zh) * 2021-01-29 2021-05-11 中国农业银行股份有限公司 一种数据库表容量监控方法及装置
CN112783732B (zh) * 2021-01-29 2023-10-10 中国农业银行股份有限公司 一种数据库表容量监控方法及装置
CN112988664A (zh) * 2021-03-11 2021-06-18 中国平安财产保险股份有限公司 数据归档方法、装置、设备及存储介质
CN112988664B (zh) * 2021-03-11 2023-05-30 中国平安财产保险股份有限公司 数据归档方法、装置、设备及存储介质
CN113821501A (zh) * 2021-08-12 2021-12-21 马上消费金融股份有限公司 一种数据归档方法及装置
CN113821501B (zh) * 2021-08-12 2023-05-16 马上消费金融股份有限公司 一种数据归档方法及装置
CN116756089A (zh) * 2023-08-21 2023-09-15 湖南云档信息科技有限公司 一种档案归档方案形成方法、系统及存储介质
CN116756089B (zh) * 2023-08-21 2023-11-03 湖南云档信息科技有限公司 一种档案归档方案形成方法、系统及存储介质

Also Published As

Publication number Publication date
CN107870981B (zh) 2021-10-22
CN107870981A (zh) 2018-04-03

Similar Documents

Publication Publication Date Title
WO2019062189A1 (fr) Dispositif électronique, procédé et système pour effectuer un traitement de classement sur une table de données, et support de stockage
WO2019085471A1 (fr) Procédé de synchronisation de bases de données, serveur d'applications, et support de stockage lisible par ordinateur
US9552161B2 (en) Repetitive data block deleting system and method
US9811529B1 (en) Automatically redistributing data of multiple file systems in a distributed storage system
WO2019062191A1 (fr) Dispositif électronique, procédé et système d'extraction de données dans une table de données, et support de stockage
WO2019196304A1 (fr) Appareil électronique, procédé d'analyse de message de rétroaction de crédit, et support d'informations
WO2019104982A1 (fr) Procédé de commande et de gestion de présence complète, serveur d'applications et support d'informations lisible par ordinateur
CN108134696A (zh) 一种微服务配置更新方法及装置
WO2019169763A1 (fr) Appareil électronique, procédé de contrôle de risque de système de service et support de stockage
WO2019071968A1 (fr) Procédé de calcul de salaire, serveur d'application et support de stockage lisible par ordinateur
WO2019095673A1 (fr) Procédé d'inscription d'employés à une formation, serveur d'application et support de stockage lisible par ordinateur
CN111274256A (zh) 基于时序数据库的资源管控方法、装置、设备及存储介质
WO2018149085A1 (fr) Procédé et système d'optimisation de système de base de données, dispositif électronique et support d'informations
CN111159183B (zh) 报表生成方法、电子装置及计算机可读存储介质
CN112328592A (zh) 数据存储方法、电子设备及计算机可读存储介质
WO2019071958A1 (fr) Procédé de calcul de salaire basé sur l'informatique en nuage, serveur d'application, et support d'informations lisible par ordinateur
RU2665272C1 (ru) Способ и устройство для восстановления дедуплицированных данных
US10210165B2 (en) File management for eDiscovery
US7519610B2 (en) Method and apparatus for efficiently storing audit event data having diverse characteristics using tiered tables
US20220083507A1 (en) Trust chain for official data and documents
US10635635B2 (en) Metering data in distributed storage environments
CN109446167A (zh) 一种日志数据存储、提取方法及装置
WO2019080424A1 (fr) Procédé et système de migration de client, dispositif informatique et support d'informations
WO2019071964A1 (fr) Procédé d'élaboration de relation d'entreprise et serveur d'applications
US10635645B1 (en) Systems and methods for maintaining aggregate tables in databases

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