Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Data archiving method and device

A data archiving and data technology, applied in the field of data processing, can solve the problems of reduced access efficiency of archived data, increased maintenance cost, insufficient database storage space, etc.

Pending Publication Date: 2020-08-14
SHOUGANG JINGTANG IRON & STEEL CO LTD
View PDF8 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] Aiming at the problems existing in the prior art, the embodiment of the present invention provides a data archiving method and device, which are used to solve the problem of insufficient storage space of the database during the data archiving process of the ERP system in the prior art, which in turn leads to the loss of archived data. Technical issues of reduced access efficiency and increased maintenance costs

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Data archiving method and device
  • Data archiving method and device
  • Data archiving method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0044] This embodiment provides a data archiving method, which is applied to an ERP system, such as figure 1 As shown, the method includes:

[0045] S110, acquiring historical data from the current database of the enterprise resource planning ERP system;

[0046] The current database of the ERP system is the SAP application server. With the gradual increase of the running time of the ERP system, the data of procurement, quality, equipment, production, sales and finance in the ERP system are also increasing, and the growth rate of the data is constantly accelerating. A large number of outdated and redundant historical data seriously affect the performance of ERP system. Generally, after the ERP system has been in operation for 3 to 5 years, when the direction of data growth has been determined, it is necessary to start archiving historical data. Therefore, in this embodiment, it is first necessary to obtain historical data from the current database of the enterprise resource ...

Embodiment 2

[0080] This embodiment provides a data archiving device, such as figure 2 As shown, the device includes: an acquisition unit 21, a determination unit 22, a generation unit 23, a storage unit 24, and a deletion unit 25; wherein,

[0081] An acquisition unit 21, configured to acquire historical data from the current database of the enterprise resource planning ERP system;

[0082] The determination unit 22 is used to determine the archiving object based on the historical data; for different archiving objects, determine the archiving scope and archiving frequency of each archiving object;

[0083] A generating unit 23, configured to filter each of the archiving objects according to the archiving scope, and generate an archiving file;

[0084] The storage unit 24 is configured to store the archived file in the target database based on the archived frequency, and the deleting unit 25 is configured to delete the online data corresponding to the archived file in the current databas...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention provides a data archiving method and device. The method comprises: obtaining historical data from a current database of an ERP system; determining an archiving range and an archiving frequency of each archiving object; screening the archived objects according to the archived range to generate an archived file; for the archived file corresponding to each archived object, establishingan information index of the archived file in a target database; and storing the archived files and the corresponding information indexes into an information structure index table based on the archiving frequency, and deleting online data corresponding to the archived files in a current database; thus, the historical data is archived into the target database, the storage space of the current database can be greatly released, the stability of the system performance is improved, and the later data operation and maintenance cost is reduced; and when the archived data needs to be accessed, the archived data can be directly inquired from the target database, and the access efficiency of the archived data can be ensured because a large amount of online data is not stored in the target database.

Description

technical field [0001] The invention belongs to the technical field of data processing, and in particular relates to a data archiving method and device. Background technique [0002] The data management strategy of Enterprise Resource Planning (ERP) includes: data avoidance, data aggregation, data deletion and data archiving. Among them, data avoidance and data summary are based on data analysis, cancel and modify invalid data-related configurations, so as to avoid the generation of invalid data; data deletion mainly establishes lifecycle management strategies for some system data tables and custom data tables, and regularly cleans up data ; Data archiving is mainly used in business data and master data archiving and query. [0003] The purpose of data archiving mainly includes three aspects: First, reduce the online data of ERP system database and improve system performance to the greatest extent. By reducing online data, the response speed of the system's functional prog...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F16/11G06F16/13G06F16/16G06F16/172
CPCG06F16/113G06F16/13G06F16/162G06F16/172
Inventor 陈超郭亮郗晓法李嘉戴昭颖范文娟张雪孙彬涛龚鑫
Owner SHOUGANG JINGTANG IRON & STEEL CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products