Method and device for transferring data

Abstract

The invention discloses a method and device for transferring data, and relates to the technical field of computers. A specific embodiment of the method comprises the steps of obtaining a log file of asource database, analyzing the log file, and determining a data slave table associated with a to-be-transferred data master table and an association relationship between the data master table and thedata slave table; configuring data transfer information according to the association relationship; querying to-be-transferred data according to the data transfer information and storing the to-be-transferred data in a storage device; and writing the to-be-transferred data in the storage device into the target database. According to the embodiment, the associated data tables are determined by analyzing the log file of the source database, the association relationship between the data tables can be further determined, and the data transfer information is configured based on the association relationship to perform data transfer, so that omission of the data slave table associated with the data master table can be avoided, the integrity of the data relationship between the transferred sourcedatabase and the transferred target database is ensured, data maintenance is facilitated, and the labor cost is further reduced.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for carrying forward data. Background technique [0002] With the continuous development of computer application systems, the amount of data in the database is also increasing. When the amount of data in the database reaches a certain order of magnitude, it will inevitably affect the speed of data operations. Most of the data is already a long time ago, and has long been inactive. Therefore, it needs to be transferred to other databases, such as historical databases, so as to reduce the volume of the current database and reduce the impact of a large amount of invalid data on data operations. Among them, data carry-forward mainly refers to the transfer of part or all of the data in one database to another database. [0003] At present, commonly used data carry-forward methods include: manual carry-forward and carry-forward tools. However, in the process of ...

AI Technical Summary

Problems solved by technology

However, in the process of realizing the present invention, the inventor found that at least the following problems existed in the prior art: manual carry-over needs to be completed jointly by R&D personnel and a database administrator (Database Administrator, referred to as DBA), and the database administrator does not understand the actual business, High communication costs and high labor costs

Moreover, for database administrators who are not familiar with business data, it is easy to miss interrelated data tables or confuse the relationship between data tables when carrying forward data, resulting in incomplete data relationships and even disrupting and losing data.

Most carry-over tools are single-table carry-forward. It is necessary to create a carry-forward task for each table and execute them one by one. It must be the same, so it is carried forward according to a certain point in time, which may lead to incomplete carry-over data relationship, querying the historical database or the current database will cause some data to be unrelated

Images