CN111984631A - Production data migration method and device, computer equipment and storage medium - Google Patents
Production data migration method and device, computer equipment and storage medium Download PDFInfo
- Publication number
- CN111984631A CN111984631A CN202010909668.3A CN202010909668A CN111984631A CN 111984631 A CN111984631 A CN 111984631A CN 202010909668 A CN202010909668 A CN 202010909668A CN 111984631 A CN111984631 A CN 111984631A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- migration
- component data
- production
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
- 230000005012 migration Effects 0.000 title claims abstract description 124
- 238000013508 migration Methods 0.000 title claims abstract description 124
- 238000004519 manufacturing process Methods 0.000 title claims abstract description 74
- 238000000034 method Methods 0.000 title claims abstract description 47
- 238000004590 computer program Methods 0.000 claims description 9
- 230000008569 process Effects 0.000 description 10
- 238000010586 diagram Methods 0.000 description 8
- 230000006870 function Effects 0.000 description 6
- 238000004422 calculation algorithm Methods 0.000 description 3
- 230000005540 biological transmission Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000007246 mechanism Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 238000004364 calculation method Methods 0.000 description 1
- 230000008094 contradictory effect Effects 0.000 description 1
- 238000013523 data management Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
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/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/602—Providing cryptographic facilities or services
Abstract
The invention discloses a production data migration method, a production data migration device, a computer device and a storage medium, wherein field association of a database to be migrated and a migration database is established, when an acquisition request of component data in the database to be migrated is received, the component data is encrypted, the encrypted component data is divided into first component data and second component data, the first component data and the second component data are spliced and converted into migration format data through identifiers, only the component data of the production data is migrated to the migration database, database field information is not migrated, and the safety and the accuracy of the production data during migration are improved by encrypting and dividing the component data of the production data during migration.
Description
Technical Field
The present invention relates to the field of data security protection, and in particular, to a method and an apparatus for migrating production data, a computer device, and a storage medium.
Background
The production data relates to a plurality of business secrets, the value is high, and if the production data is leaked, the loss is significant. In the process of database migration related to production data, the generated data is required to be incapable of being acquired by non-specific user query, so that in the data migration process, developers cannot directly acquire the data, but the accuracy of the data migration process must be ensured.
Therefore, a safe and accurate production data migration method is also lacking in the prior art.
Disclosure of Invention
In view of this, the present invention provides a production data migration method, apparatus, computer device and storage medium, which only migrate component data of the production data to the migration database, so as to improve the security and accuracy of the production data during migration.
First, in order to achieve the above object, the present invention provides a production data migration method, where the production data includes a plurality of fields and component data corresponding to the fields, the method including:
establishing field association of a first database and a second database, wherein the first database is a database to be migrated, and the second database is a migration database;
when an acquisition request for component data in the first database is received, encrypting the component data;
dividing the encrypted component data into first component data and second component data;
splicing the first component data and the second component data through identifiers and converting the first component data and the second component data into migration format data;
migrating the migration format data to the second database upon receiving a migration instruction.
Further, the establishing of the field association of the first database and the second database includes:
acquiring table structure fields of the first database and the second database;
generating a plurality of page cards which respectively correspond to the table structure field of the first database and the table structure field of the second database;
displaying the plurality of page cards in a user page;
and receiving the operation of the first user on the plurality of page cards to establish the table structure field association of the first database and the second database.
Further, before receiving the operation of the first user on the plurality of page cards to establish the table structure field association of the first database and the second database, the method further includes:
judging whether the table data structure of the first database and the table data structure of the second database meet preset conditions or not;
correspondingly, the receiving the operation of the first user on the plurality of page cards to establish the table structure field association of the first database and the second database includes:
and when the table data structure of the first database and the table data structure of the second database meet preset conditions, establishing table field association of the first database and the second database according to the operation of the first user.
Further, the receiving the operation of the first user on the plurality of page cards to establish the table structure field association of the first database and the second database further comprises:
when the table data structure of the first database or the table data structure of the second database does not meet a preset condition, respectively executing character recognition or semantic recognition on the first database and the second database;
combining fields of name information or semantic information with similarity meeting a preset value, and converting the fields into a preset format;
and establishing table field association of the first database and the second database according to the operation of the first user.
Further, the dividing the encrypted component data into the first component data and the second component data includes:
dividing the encrypted component data into two parts according to the data length;
receiving a first key and a second key input by the first user;
and encrypting the component data which is divided into two parts by the first key and the second key respectively to obtain the first component data and the second component data.
Further, before migrating the migration format data to the second database when the migration instruction is received, the method further includes:
receiving the migration instruction sent by a second user;
when the migration instruction is received, performing first decryption on the migration format data through the first key and the second key;
and executing second decryption on the migration format data subjected to the first decryption, wherein the second decryption is used for decrypting the component data of the first database.
Further, migrating the migration format data to the second database when the migration instruction is received further includes:
and uploading the migration format data to a block chain.
In order to achieve the above object, the present invention further provides a production data migration apparatus, including:
the field association module is used for establishing field association between a first database and a second database, wherein the first database is a database to be migrated, and the second database is a migration database;
the first encryption module is used for encrypting the component data when an acquisition request for the component data in the first database is received;
a second encryption module for dividing the encrypted component data into first component data and second component data;
the identifier splicing module is used for splicing the first component data and the second component data through identifiers and converting the first component data and the second component data into migration format data;
and the migration execution module is used for migrating the migration format data to the second database when a migration instruction is received.
To achieve the above object, the present invention further provides a computer device, which includes a memory, a processor, and a computer program stored on the memory and executable on the processor, wherein the processor implements the steps of the above method when executing the computer program.
To achieve the above object, the present invention also provides a computer-readable storage medium having stored thereon a computer program which, when being executed by a processor, carries out the steps of the above method.
Compared with the prior art, the production data migration method, the production data migration device, the computer equipment and the storage medium in the embodiments of the present invention, by establishing the field association between the database to be migrated and the database to be migrated, when receiving the request for acquiring the component data in the database to be migrated, encrypting the component data, then dividing the encrypted component data into the first component data and the second component data, splicing the first component data and the second component data through the identifier and converting the first component data and the second component data into the migration format data, migrating only the component data of the production data to the migration database, not migrating the database field information, and encrypting and dividing the component data of the production data during migration, thereby improving the security and accuracy of the production data during migration.
Drawings
FIG. 1 is a schematic diagram of an application environment of an embodiment of the present invention;
FIG. 2 is a flowchart illustrating a production data migration method according to a first embodiment of the present invention;
FIG. 3 is a schematic flow chart illustrating the process of establishing field association between the first database and the second database in FIG. 2;
FIG. 4 is a schematic diagram illustrating the process of FIG. 3 for receiving operations on the plurality of page cards by a first user to establish a table structure field association between a first database and a second database;
fig. 5 is a schematic flow chart of the process of dividing the encrypted component data into the first component data and the second component data in fig. 2;
FIG. 6 is a partial flow diagram of FIG. 2 prior to migrating the migration formatted data to the second database upon receiving a migration instruction;
FIG. 7 is a block diagram of a second embodiment of a production data migration apparatus according to the present invention;
FIG. 8 is a diagram of a hardware configuration of a third embodiment of a computer apparatus according to the present invention.
The implementation, functional features and advantages of the objects of the present invention will be further explained with reference to the accompanying drawings.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the invention and are not intended to limit the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
It should be noted that the description relating to "first", "second", etc. in the present invention is for descriptive purposes only and is not to be construed as indicating or implying relative importance or implicitly indicating the number of technical features indicated. Thus, a feature defined as "first" or "second" may explicitly or implicitly include at least one such feature. In addition, technical solutions between various embodiments may be combined with each other, but must be realized by a person skilled in the art, and when the technical solutions are contradictory or cannot be realized, such a combination should not be considered to exist, and is not within the protection scope of the present invention.
Referring to fig. 1, a schematic diagram of an implementation environment of the embodiment of the invention is shown. The implementation environment includes: a user terminal 10 and a service terminal 12.
The user terminal 10 is an electronic device with network access function, and the device may be a smart phone, a tablet computer, a personal computer, or the like.
The user terminal 10 is installed with a program 11 that can access the server terminal 12, and after the program 11 logs in to access the server terminal 12 through an account and a password, the user can perform specific operations and inputs on the server terminal 12.
In this embodiment, the users include a first user and a second user. The first user is a developer user and the second user is a user performing a database migration.
The server 12 is a server, a server cluster formed by a plurality of servers, or a cloud computing center. The server 12 stores a program 13, the program 13 includes a front-end module and a back-end module, the front-end module and the back-end module can be called by an interface, and a user can perform specific operation and input on the program 13 after the program 11 logs in through an account and a password or accesses the program 13 of the server 12 through the account and the password.
In this embodiment, the server 12 stores a plurality of databases, the production data includes a plurality of fields and component data corresponding to the fields, and at least one database is a production database having production data. Different databases may migrate or synchronize data in the databases to other databases through triggering instructions of the user 10.
In other embodiments, the database may also be stored in different servers in the server 12 cluster, or in different network nodes connected via a network, or locally in the user segment 10.
The user terminal 10 and the service terminal 12 are connected through a network, which may include a plurality of network nodes, and the network may be the internet, a local area network, or a block chain network.
The production data migration method according to the embodiment of the present invention may be applied to the program 11 or the program 13 alone, may be applied to the program 11 and the program 13 in a distributed manner, or may be stored in a plurality of nodes of the network in a blockchain manner.
Example one
According to the production data migration method, only the component data of the production data are migrated to the migration database, the database field information is not migrated, and the component data of the production data in migration are encrypted and divided, so that the safety and the accuracy of the production data during migration are improved.
Referring to fig. 2, a production data migration method of the present embodiment includes the following steps:
step S100, establishing field association of a first database and a second database, wherein the first database is a database to be migrated, and the second database is a migration database;
if the production data is to be migrated from the database to be migrated to the migration database, firstly, the field association between the database to be migrated and the migration database is established.
The database is a collection of massive data stored in a computer, organized, sharable and uniformly managed, a user can add, query, update, delete and the like to the data in a file, and in the database, columns of a table are called fields, each field contains information of a certain special subject and represents attributes common to all rows in the table, so the columns are called fields. Each field corresponds to a plurality of components, for example, the field is a component corresponding to a field, such as a ethnic group, a han-nationality Miao-ethnic group, etc., the field may also be called an attribute, and the component may also be called an attribute value.
For example, in this embodiment, there are two environments corresponding to two databases, one is a production 1 environment, and the other is a production 2 environment, and the two environments correspond to a first database and a second database, where the first database is a database to be migrated, the second database is a migration database, the first database includes fields a1-Am, the second database includes fields B1-Bn, and each field corresponds to multiple components or attribute values.
The fields A1-Am and B1-Bn are fields which are common in the database, the content confidentiality requirement of the parts is not high, and components corresponding to the fields need to be kept confidential.
For example:
product table, product _ package _ config table in production 1 environment
Product _ info table in production 2 Environment
In the two tables, in order to migrate data, the corresponding relation between the tables and the fields between the tables must be known first.
Wherein, the table structure under the production 1 environment is:
the table structure in the production 2 environment is:
create table product _ info (product information table)
id varchar(32),
name varchar (100), product name
market varchar (10), market type
audio _ status varchar (10), approval status
top _ category varchar (20), first classification
sub _ category varchar (20), second classification
package _ info text package information
)
The fields name varchar, mark varchar, etc. are only field names representing product names and market types, which are common table structures in databases and do not need to be kept secret, and the corresponding components or attribute values in the fields are specific production data with very high confidentiality requirements, such as name varchar (100), the components corresponding to the product names represent which specific name products are produced by specific enterprises, such as specific product information of luggage appliances, etc., mark varchar (10), and the corresponding components represent what the specific market types corresponding to the products are, such as foreign trade or internal trade, south market or north market, etc.
Specifically, referring to fig. 3, step S100 is to establish a field association between the first database and the second database, including:
step S110, obtaining table structure fields of the first database and the second database;
step S120, generating a plurality of page cards which respectively correspond to the table structure field of the first database and the table structure field of the second database;
step S130, displaying the page cards in a user page;
step S140, receiving an operation of the first user on the plurality of page cards to establish a table structure field association between the first database and the second database.
Specifically, the following table shows:
| production 1 | |
| Product.id | Product_info.id |
| Product.name | Product_info.name |
| Product.type | Product_info.market |
| Product.status | Product_info.audit_status |
| Product.top_categroy | Product_info.top_categroy |
| Product.sub_categroy | Product_info.sub_categroy |
| product_pagkage_config.price | Product_info.package_info |
| product_pagkage_config.quota | Product_info.package_info |
| product_pagkage_config.package_info | Product_info.package_info |
By the first user, the developer drags the set-up generate 1 environment and produce 1 environment table structure fields to be associated.
Specifically, referring to fig. 4, before receiving the operation of the first user on the multiple page cards in step S140 to establish the table structure field association between the first database and the second database, the method further includes:
step S135, judging whether the table data structure of the first database and the table data structure of the second database meet preset conditions or not;
correspondingly, in step S140, the receiving the operation of the first user on the plurality of page cards to establish the table structure field association of the first database and the second database includes:
step S141, when the table data structure of the first database or the table data structure of the second database does not satisfy a preset condition, respectively performing character recognition or semantic recognition on the first database and the second database.
And step S142, combining the fields of the name information or the semantic information with the similarity meeting the preset value, and converting the fields into a preset format.
Step S143, establishing table field association between the first database and the second database according to the operation of the first user.
When the table data structure of the first database and the table data structure of the second database meet a preset condition, step S143 is directly executed, and table field association of the first database and the second database is established according to the operation of the first user.
Specifically, if the data structures of the two tables are not changed or only the names are changed, for example, status and audio _ status, the data are directly queued and filled in the corresponding positions.
When the table structure changes, for example, the Product _ page _ config table of the production 1 environment does not exist, and all the table structures are merged into the Product _ info.
Step S200, when receiving an acquisition request for component data in the first database, encrypting the component data;
specifically, the component data is encrypted by the key, for example, when data is queried in the production 1 environment, the encryption algorithm in the database can be directly used, and the encryption key is added to the query sql, so that the queried data is already ciphertext when being migrated, and leakage of plaintext data is prevented.
Step S300, dividing the encrypted component data into first component data and second component data;
in this embodiment, data is divided when data migration is performed. The good taste of data division is to prevent that only half of the leaked data can not be received and the other half of the data can not form meaningful component data in case of data leakage.
Specifically, referring to fig. 5, step S300, the dividing the encrypted component data into the first component data and the second component data includes:
step S310, dividing the encrypted component data into two parts according to the data length;
step S320, receiving a first key and a second key input by the first user;
step S330, respectively encrypting the component data divided into two parts by the first key and the second key to obtain the first component data and the second component data.
The ciphertext data of each field is divided into two parts according to the data length, then two parts of data exist equivalently, the first user develops two keys which are respectively input for the two parts of data, and different encryption of the two parts of data of the two divided data is completed.
That is, the data is in two halves, and the data of the two halves is encrypted by different keys, respectively. No matter how the data is circulated or leaked, the plaintext data cannot be obtained, and the data is difficult to restore into the plaintext.
The key is manually input by a second user, such as an operation and maintenance person, when operating the tool, and the first user cannot obtain the key.
Step S400, splicing the first component data and the second component data through identifiers and converting the spliced first component data and the second component data into migration format data;
in step S300, the same data is already divided into two parts, that is, the content of one field is divided into two encrypted files, and then the encrypted first component data and the encrypted second component data are concatenated by the identifier.
In the embodiment, the data is spliced through the symbol, then the data is assembled into a data format to be migrated, for example, fields with different names but the same semantic meaning in two environments are filled into the field of the new environment, or a plurality of fields are filled into the field in the new environment, then a json format is created, and new field data is formed and stored into the field of the new environment.
After the data is composed, the corresponding sql statement can be formed through the key of the data, namely the field name in the corresponding dictionary table.
Step S600, when a migration instruction is received, migrating the migration format data to the second database.
Specifically, in this embodiment, referring to fig. 6, in step S500, before migrating the migration format data to the second database when the migration instruction is received, the method further includes:
step S501, receiving the obtaining request and the migration instruction sent by a second user;
step S502, when the migration instruction is received, performing first decryption on the migration format data through the first key and the second key;
specifically, the data spliced by the identifier ^ is decrypted, the data are divided into two sections according to the identifier ^ and then decrypted by using the corresponding key to obtain a complete sql statement with the database layer encrypted.
Step S503, performing a second decryption on the migration format data subjected to the first decryption, where the second decryption is used for decrypting the component data of the first database.
Finally, the data is loaded into the database and a second decryption, i.e. the decryption of the database itself, needs to be performed, since in the resulting sql statement there will be a placeholder. When the sql statement reaches the database, the query key sql statement is executed first, then the placeholder is automatically filled, when the execution statement is executed, the data is automatically decrypted according to the key, and when the plaintext data of the original text is inserted into the database. Therefore, the production migration of the data is perfectly realized, the key management in the whole process is safer, and the keys are ensured not to be completely revealed through a mechanism of multi-person and data management.
In the present embodiment, it is preferred that,
the database encryption and decryption functions are as follows:
encryption:
EncryptByPassPhrase('EPdRc2',@password)
and (3) decryption:
DecryptByPassPhrase('EPdRc2',@password)
the implementation of key acquisition in the database is:
DecryptByPassPhrase('EPdRc2',select password from pass_manage_info)；
the number of encryption and decryption functions is many, the encryption and decryption in this embodiment are only examples, other embodiments of the present application may be implemented by other encryption and decryption methods, and the identifier in other embodiments may be other symbols.
In this embodiment, in step S500, after the migrating the migration format data to the second database when the migration instruction is received, the method further includes:
and uploading the migration format data to a block chain.
And obtaining corresponding digest information based on the migration format data, specifically, obtaining the digest information by hashing the migration format data, for example, by using a sha256s algorithm. Uploading summary information to the blockchain can ensure the safety and the fair transparency of the user. The user equipment may download the summary information from the blockchain to verify whether the migration format data is tampered. The blockchain referred to in this example is a novel application mode of computer technologies such as distributed data storage, point-to-point transmission, consensus mechanism, encryption algorithm, and the like. A block chain (Blockchain), which is essentially a decentralized database, is a series of data blocks associated by using a cryptographic method, and each data block contains information of a batch of network transactions, so as to verify the validity (anti-counterfeiting) of the information and generate a next block. The blockchain may include a blockchain underlying platform, a platform product service layer, an application service layer, and the like.
According to the production data migration method, the database to be migrated and the field association of the database to be migrated are established, when an acquisition request for the component data in the database to be migrated is received, the component data are encrypted, the encrypted component data are divided into the first component data and the second component data, the first component data and the second component data are spliced and converted into the migration format data through the identifiers, only the component data of the production data are migrated to the migration database, the database field information is not migrated, and the safety and the accuracy of the production data during migration are improved by encrypting and dividing the component data of the production data during migration.
Example two
With continued reference to FIG. 7, a schematic diagram of program modules of the production data migration apparatus is shown. In this embodiment, the production data migration apparatus 20 may include or be divided into one or more program modules, and the one or more program modules are stored in a storage medium and executed by one or more processors to implement the present invention and implement the production data migration method described above. The program modules referred to in the embodiments of the present invention refer to a series of computer program instruction segments capable of performing specific functions, and are more suitable than the program itself for describing the execution process of the production data migration apparatus 20 in the storage medium. The following description will specifically describe the functions of the program modules of the present embodiment:
a field association module 201, configured to establish a field association between a first database and a second database, where the first database is a database to be migrated, and the second database is a migration database;
a first encryption module 202, configured to encrypt component data in the first database when an acquisition request for the component data is received;
a second encryption module 203 for dividing the encrypted component data into first component data and second component data;
an identifier concatenation module 204, configured to concatenate and convert the first component data and the second component data into migration format data through an identifier;
and the migration executing module 205 is configured to migrate the migration format data to the second database when a migration instruction is received.
EXAMPLE III
Fig. 8 is a schematic diagram of a hardware architecture of a computer device according to a third embodiment of the present invention. In the present embodiment, the computer device 2 is a device capable of automatically performing numerical calculation and/or information processing in accordance with a preset or stored instruction. The computer device 2 may be a rack server, a blade server, a tower server or a rack server (including an independent server or a server cluster composed of a plurality of servers), and the like. As shown in fig. 8, the computer device 2 includes, but is not limited to, at least a memory 21, a processor 22, a network interface 23, and a production data migration apparatus 20, which are communicatively connected to each other through a system bus. Wherein:
in this embodiment, the memory 21 includes at least one type of computer-readable storage medium including a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), 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, and the like. In some embodiments, the storage 21 may be an internal storage unit of the computer device 2, such as a hard disk or a memory of the computer device 2. In other embodiments, the memory 21 may also be an external storage device of the computer device 2, such as a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), or the like provided on the computer device 2. Of course, the memory 21 may also comprise both internal and external memory units of the computer device 2. In this embodiment, the memory 21 is generally used for storing an operating system installed in the computer device 2 and various types of application software, such as the program codes of the production data migration apparatus 20 described in the above embodiment. Further, the memory 21 may also be used to temporarily store various types of data that have been output or are to be output.
The network interface 23 may comprise a wireless network interface or a wired network interface, and the network interface 23 is generally used for establishing communication connection between the computer device 2 and other electronic apparatuses. For example, the network interface 23 is used to connect the computer device 2 to an external terminal through a network, establish a data transmission channel and a communication connection between the computer device 2 and the external terminal, and the like. The network may be a wireless or wired network such as an Intranet (Intranet), the Internet (Internet), a Global System of Mobile communication (GSM), Wideband Code Division Multiple Access (WCDMA), a 4G network, a 5G network, Bluetooth (Bluetooth), Wi-Fi, and the like.
It is noted that fig. 8 only shows the computer device 2 with components 20-23, but it is to be understood that not all shown components are required to be implemented, and that more or less components may be implemented instead.
In this embodiment, the production data migration apparatus 20 stored in the memory 21 may be further divided into one or more program modules, and the one or more program modules are stored in the memory 21 and executed by one or more processors (in this embodiment, the processor 22) to complete the present invention.
Example four
The present embodiment also provides a computer-readable storage medium, such as a flash memory, a hard disk, a multimedia card, a card-type memory (e.g., SD or DX memory, etc.), a Random Access Memory (RAM), a Static Random Access Memory (SRAM), 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, a server, an App application mall, etc., on which a computer program is stored, which when executed by a processor implements corresponding functions. The computer-readable storage medium of the present embodiment is used for storing the production data migration apparatus 20, and when being executed by a processor, the computer-readable storage medium implements the production data migration method according to the foregoing embodiment.
The above-mentioned serial numbers of the embodiments of the present invention are merely for description and do not represent the merits of the embodiments.
Through the above description of the embodiments, those skilled in the art will clearly understand that the method of the above embodiments can be implemented by software plus a necessary general hardware platform, and certainly can also be implemented by hardware, but in many cases, the former is a better implementation manner.
The above description is only a preferred embodiment of the present invention, and not intended to limit the scope of the present invention, and all modifications of equivalent structures and equivalent processes, which are made by using the contents of the present specification and the accompanying drawings, or directly or indirectly applied to other related technical fields, are included in the scope of the present invention.
Claims (10)
1. A method of production data migration, wherein the production data includes a plurality of fields and component data corresponding to the plurality of fields, the method comprising:
establishing field association of a first database and a second database, wherein the first database is a database to be migrated, and the second database is a migration database;
when an acquisition request for component data in the first database is received, encrypting the component data;
dividing the encrypted component data into first component data and second component data;
splicing the first component data and the second component data through identifiers and converting the first component data and the second component data into migration format data;
migrating the migration format data to the second database upon receiving a migration instruction.
2. The production data migration method of claim 1, wherein said establishing field associations of the first database and the second database comprises:
acquiring table structure fields of the first database and the second database;
generating a plurality of page cards which respectively correspond to the table structure field of the first database and the table structure field of the second database;
displaying the plurality of page cards in a user page;
and receiving the operation of the first user on the plurality of page cards to establish the table structure field association of the first database and the second database.
3. The production data migration method of claim 2, wherein before receiving the operation of the plurality of page cards by the first user to establish the table structure field association of the first database and the second database, further comprises:
judging whether the table data structure of the first database and the table data structure of the second database meet preset conditions or not;
correspondingly, the receiving the operation of the first user on the plurality of page cards to establish the table structure field association of the first database and the second database includes:
and when the table data structure of the first database and the table data structure of the second database meet preset conditions, establishing table field association of the first database and the second database according to the operation of the first user.
4. The production data migration method of claim 3, wherein said receiving the operation of the plurality of page cards by the first user to establish the table structure field associations of the first database and the second database further comprises:
when the table data structure of the first database or the table data structure of the second database does not meet a preset condition, respectively executing character recognition or semantic recognition on the first database and the second database;
combining fields of name information or semantic information with similarity meeting a preset value, and converting the fields into a preset format;
and establishing table field association of the first database and the second database according to the operation of the first user.
5. The production data migration method according to claim 1 or 4, wherein said dividing the encrypted component data into first component data and second component data comprises:
dividing the encrypted component data into two parts according to the data length;
receiving a first key and a second key input by the first user;
and encrypting the component data which is divided into two parts by the first key and the second key respectively to obtain the first component data and the second component data.
6. The production data migration method of claim 5, wherein said migrating said migration format data to said second database upon receiving a migration instruction further comprises:
receiving the acquisition request and the migration instruction sent by a second user;
when the migration instruction is received, performing first decryption on the migration format data through the first key and the second key;
and executing second decryption on the migration format data subjected to the first decryption, wherein the second decryption is used for decrypting the component data of the first database.
7. The production data migration method of claim 6, wherein said migrating said migration format data to said second database upon receiving a migration instruction further comprises:
and uploading the migration format data to a block chain.
8. A production data migration apparatus, characterized in that the production data migration apparatus comprises:
the field association module is used for establishing field association between a first database and a second database, wherein the first database is a database to be migrated, and the second database is a migration database;
the first encryption module is used for encrypting the component data when an acquisition request for the component data in the first database is received;
a second encryption module for dividing the encrypted component data into first component data and second component data;
the identifier splicing module is used for splicing the first component data and the second component data through identifiers and converting the first component data and the second component data into migration format data;
and the migration execution module is used for migrating the migration format data to the second database when a migration instruction is received.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the steps of the production data migration method according to any one of claims 1 to 7 when executing the computer program.
10. A computer-readable storage medium having stored thereon a computer program, characterized in that: the computer program when executed by a processor performs the steps of the production data migration method of any one of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010909668.3A CN111984631A (en) | 2020-09-02 | 2020-09-02 | Production data migration method and device, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010909668.3A CN111984631A (en) | 2020-09-02 | 2020-09-02 | Production data migration method and device, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN111984631A true CN111984631A (en) | 2020-11-24 |
Family
ID=73447851
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010909668.3A Pending CN111984631A (en) | 2020-09-02 | 2020-09-02 | Production data migration method and device, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111984631A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112540969A (en) * | 2020-11-26 | 2021-03-23 | 南京纯白矩阵科技有限公司 | Data migration method for intelligent contracts among heterogeneous block chains |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109189756A (en) * | 2018-06-29 | 2019-01-11 | 平安科技（深圳）有限公司 | Electronic device, the method for Data Migration and storage medium |
| CN109388637A (en) * | 2018-09-21 | 2019-02-26 | 北京京东金融科技控股有限公司 | Data warehouse information processing method, device, system, medium |
| CN109542882A (en) * | 2018-12-05 | 2019-03-29 | 南京中孚信息技术有限公司 | A kind of database migration method and device |
| CN110297813A (en) * | 2019-05-22 | 2019-10-01 | 平安银行股份有限公司 | Data migration method, device, computer equipment and storage medium |
| US20190340251A1 (en) * | 2018-05-07 | 2019-11-07 | Salesforce.Com, Inc. | Migrating data between databases |
| CN110968885A (en) * | 2019-12-18 | 2020-04-07 | 支付宝(杭州)信息技术有限公司 | Model training data storage method and device, electronic equipment and storage medium |
| CN111061742A (en) * | 2019-12-25 | 2020-04-24 | 北京数起科技有限公司 | Method and device for marking data and service system thereof |
| CN111309711A (en) * | 2020-03-13 | 2020-06-19 | 财付通支付科技有限公司 | Cross-block-chain data migration method, device, equipment and storage medium |
| CN111597569A (en) * | 2020-05-15 | 2020-08-28 | 中国人民解放军空军勤务学院 | Image data output method and system, computer equipment and storage medium |
-
2020
- 2020-09-02 CN CN202010909668.3A patent/CN111984631A/en active Pending
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20190340251A1 (en) * | 2018-05-07 | 2019-11-07 | Salesforce.Com, Inc. | Migrating data between databases |
| CN109189756A (en) * | 2018-06-29 | 2019-01-11 | 平安科技（深圳）有限公司 | Electronic device, the method for Data Migration and storage medium |
| CN109388637A (en) * | 2018-09-21 | 2019-02-26 | 北京京东金融科技控股有限公司 | Data warehouse information processing method, device, system, medium |
| CN109542882A (en) * | 2018-12-05 | 2019-03-29 | 南京中孚信息技术有限公司 | A kind of database migration method and device |
| CN110297813A (en) * | 2019-05-22 | 2019-10-01 | 平安银行股份有限公司 | Data migration method, device, computer equipment and storage medium |
| CN110968885A (en) * | 2019-12-18 | 2020-04-07 | 支付宝(杭州)信息技术有限公司 | Model training data storage method and device, electronic equipment and storage medium |
| CN111061742A (en) * | 2019-12-25 | 2020-04-24 | 北京数起科技有限公司 | Method and device for marking data and service system thereof |
| CN111309711A (en) * | 2020-03-13 | 2020-06-19 | 财付通支付科技有限公司 | Cross-block-chain data migration method, device, equipment and storage medium |
| CN111597569A (en) * | 2020-05-15 | 2020-08-28 | 中国人民解放军空军勤务学院 | Image data output method and system, computer equipment and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112540969A (en) * | 2020-11-26 | 2021-03-23 | 南京纯白矩阵科技有限公司 | Data migration method for intelligent contracts among heterogeneous block chains |
| CN112540969B (en) * | 2020-11-26 | 2023-07-14 | 南京纯白矩阵科技有限公司 | Data migration method of intelligent contracts among heterogeneous block chains |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111756522A (en) | Data processing method and system | |
| CN111915019A (en) | Federal learning method, system, computer device, and storage medium | |
| CN113055380B (en) | Message processing method and device, electronic equipment and medium | |
| CN111611621A (en) | Block chain based distributed data encryption storage method and electronic equipment | |
| WO2020233014A1 (en) | Message sending method and apparatus, and computer device and storage medium | |
| CN112184444A (en) | Method, apparatus, device and medium for processing information based on information characteristics | |
| WO2021139476A1 (en) | Intersection data generation method, and federated model training method based on intersection data | |
| CN111241596B (en) | Block chain asset account recovery method and device | |
| CN112328486A (en) | Interface automation test method and device, computer equipment and storage medium | |
| CN110704875B (en) | Method, device, system, medium and electronic equipment for processing client sensitive information | |
| CN111898135A (en) | Data processing method, data processing apparatus, computer device, and medium | |
| CN111404892A (en) | Data supervision method and device and server | |
| CN111339558A (en) | Data encryption method, data decryption method, computer device and medium | |
| CN111984631A (en) | Production data migration method and device, computer equipment and storage medium | |
| CN111104693A (en) | Android platform software data cracking method, terminal device and storage medium | |
| CN111553655A (en) | Method and system for showing handling history | |
| CN116055067A (en) | Weak password detection method, device, electronic equipment and medium | |
| CN115757535A (en) | Data query method, data storage method and device and electronic equipment | |
| WO2019178981A1 (en) | Password management method and device employing customized rules, terminal apparatus, and storage medium | |
| CN108512657B (en) | Password generation method and device | |
| CN115567212A (en) | File processing method and device, computer equipment and computer readable storage medium | |
| CN115589316A (en) | Data encryption transmission method and device, electronic equipment and storage medium | |
| CN115292731A (en) | Encryption storage method of text reading and amending information and related equipment | |
| CN110995437B (en) | ETC system-based user information input method, device, equipment and storage medium | |
| CN114398678A (en) | Registration verification method and device for preventing electronic file from being tampered, electronic equipment and medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |