Al technical title is built by PatSnap Al team. It summarizes the technical point description of the patent document.
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
This helps you quickly interpret patents by identifying the three key elements:
Problems solved by technology
Method used
Benefits of technology
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
Click on the blue label to locate the original text in one second.
Reading with bidirectional positioning of images and text.
Smart Image
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
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
Application Date:The date an application was filed.
Publication Date:The date a patent or application was officially published.
First Publication Date:The earliest publication date of a patent with the same application number.
Issue Date:Publication date of the patent grant document.
PCT Entry Date:The Entry date of PCT National Phase.
Estimated Expiry Date:The statutory expiry date of a patent right according to the Patent Law, and it is the longest term of protection that the patent right can achieve without the termination of the patent right due to other reasons(Term extension factor has been taken into account ).
Invalid Date:Actual expiry date is based on effective date or publication date of legal transaction data of invalid patent.
Login to view more 
Login to view more