CN113515306A - System transplanting method and device - Google Patents
System transplanting method and device Download PDFInfo
- Publication number
- CN113515306A CN113515306A CN202110454524.8A CN202110454524A CN113515306A CN 113515306 A CN113515306 A CN 113515306A CN 202110454524 A CN202110454524 A CN 202110454524A CN 113515306 A CN113515306 A CN 113515306A
- Authority
- CN
- China
- Prior art keywords
- database
- data
- difference
- determining
- source database
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/70—Software maintenance or management
- G06F8/76—Adapting program code to run in a different environment; Porting
Abstract
The invention discloses a system transplanting method and device, and relates to the technical field of big data. One embodiment of the method comprises: acquiring running data of a source database in a first system; determining the difference between the source database and a target database in a second system according to the operating data; determining a conversion relation corresponding to the source database and the target database according to the difference; and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted to the second system. The implementation mode can ensure that the data and the application are adaptive to the second system before and after the transplantation, thereby improving the efficiency of the system transplantation and facilitating the normal operation of the system after the transplantation.
Description
Technical Field
The invention relates to the technical field of big data, in particular to a system transplanting method and device.
Background
In a financial system or other business system, system migration may be involved in a facility upgrade or modification process. Software and hardware before and after the migration of related systems may be different, and the amount of data and applications related to these systems is also large, so how to ensure the adaptation of data format and applications before and after the migration of data is a problem to be solved urgently.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method and an apparatus for system migration, which can determine a difference between a source database in a first system before migration and a target database in a second system after migration according to operation data of the source database in the first system before migration, determine a conversion relationship between the source database and the target database according to the difference, and further migrate an application and data in the first system to the second system according to the determined conversion relationship, thereby ensuring that the data and the application before and after migration are adapted to the second system, thereby improving efficiency of system migration and facilitating normal operation of the system after migration.
To achieve the above object, according to an aspect of an embodiment of the present invention, there is provided a system migration method, including:
acquiring running data of a source database in a first system; the first system includes: an X86 server, a Redhat Linux operating system, Weblogic middleware and an Oracle database;
determining the difference between the source database and a target database in a second system according to the operating data; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a Dameng database;
determining a conversion relation corresponding to the source database and the target database according to the difference;
and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted to the second system.
Optionally, the method comprises:
converting the data to be transplanted and the application to be transplanted in the source database according to the conversion relation;
and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
Optionally, the method further comprises:
the operational data includes any one or more of: the configuration information of the source database, the table data of the source database, the sql statement corresponding to the source database, the function corresponding to the source database, the trigger, the space usage data of the source database, and the server pressure data.
Optionally, when the run data includes the sql statement, the method includes:
determining a database schema definition language according to the sql statement;
analyzing the database mode definition language and determining the grammatical difference of the source database and the target database;
and determining the conversion relation according to the grammar difference.
Optionally, the method further comprises:
determining a data manipulation language according to the sql statement;
and analyzing the difference of the source database and the target database about the data manipulation language, and determining the conversion relation according to the difference.
Optionally, the method further comprises:
determining a data type corresponding to the source database according to the table data of the source database;
and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the conversion relation of the field types of the database according to the difference.
Optionally, the method further comprises:
and determining the difference of the functions included in the source database and the target database, and determining the conversion relation corresponding to the functions according to the difference.
Optionally, the method further comprises:
and acquiring an automatic load information report of the source database, and determining the space usage data and the server pressure data according to the automatic load information report.
Optionally, the method comprises:
unloading the converted data to be transplanted from the source database, and importing the converted data to be transplanted into the target database;
optionally, the method comprises:
and transplanting the converted data to be transplanted to the target database by using a data migration tool of the target database.
Optionally, the method comprises:
and converting the codes corresponding to the application to be transplanted according to the database field type conversion relation and the calling relation between the application to be transplanted and the data to be transplanted.
Optionally, the method comprises:
and determining a partition strategy of a target database according to the space usage data and/or the server pressure data of the source database, and configuring the second system according to the partition strategy.
Optionally, the method comprises:
and reconstructing the target database according to the service type corresponding to the application to be transplanted, wherein the service type comprises online service and/or batch processing service.
Optionally, the method comprises:
and modifying the configuration file, the domain configuration and the used code corresponding to the application to be converted according to the difference between the Bayland middleware and the Weblogic middleware, and configuring the second system according to the modified application to be converted.
To achieve the above object, according to still another aspect of an embodiment of the present invention, there is provided a system migration apparatus.
The system transplanting device of the embodiment of the invention comprises: the device comprises an acquisition module, a difference determination module and a transplantation module; wherein the content of the first and second substances,
the acquisition module is used for acquiring the operating data of the source database in the first system; the first system includes: an X86 server, a Redhat Linux operating system, Weblogic middleware and an Oracle database;
the difference determining module is used for determining the difference between the source database and a target database in the second system according to the operating data; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a Dameng database;
the migration module is used for determining a conversion relation corresponding to the source database and the target database according to the difference; and according to the conversion relation, migrating the data and the application in the first system to the second system.
Optionally, the migration module is configured to convert, according to the conversion relationship, the data to be migrated and the application to be migrated in the source database;
and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
Optionally, the migration module is configured to determine a database schema definition language according to the sql statement;
analyzing the database mode definition language and determining the grammatical difference of the source database and the target database;
and determining the conversion relation according to the grammar difference.
Optionally, the migration module is configured to determine a data manipulation language according to the sql statement;
and analyzing the difference of the source database and the target database about the data manipulation language, and determining the conversion relation according to the difference.
Optionally, the migration module is configured to determine a data type corresponding to the source database according to the table data of the source database;
and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the conversion relation of the field types of the database according to the difference.
Optionally, the migration module is configured to determine a difference between functions included in the source database and the target database, and determine a conversion relationship corresponding to the function according to the difference.
To achieve the above object, according to still another aspect of the embodiments of the present invention, there is provided an electronic device for system migration.
An electronic device for system migration according to an embodiment of the present invention includes: one or more processors; a storage device, configured to store one or more programs, which when executed by the one or more processors, cause the one or more processors to implement a method of system migration according to an embodiment of the present invention.
To achieve the above object, according to still another aspect of embodiments of the present invention, there is provided a computer-readable storage medium.
A computer-readable storage medium of an embodiment of the present invention stores thereon a computer program that, when executed by a processor, implements a method of system migration of an embodiment of the present invention.
One embodiment of the above invention has the following advantages or benefits: the method and the system have the advantages that the difference between the source database in the first system before the migration and the target database in the second system after the migration can be determined according to the operation data of the source database in the first system before the migration, the conversion relation between the source database and the target database is determined according to the difference, and then the application and the data in the first system are transplanted to the second system according to the determined conversion relation, so that the adaptation between the data before and after the migration and the application in the second system is guaranteed, the efficiency of the system migration is improved, and the normal operation of the system after the migration is facilitated. When the first system is a foreign system and the second system is a domestic system, the conversion relation from the foreign operating system to the domestic operating system can be obtained by analyzing the difference between the current foreign operating system and the domestic operating system, so that the transplantation of the foreign operating system to the domestic operating system becomes possible, the monopoly of foreign enterprises on the information system architecture is broken, and the information security of China is facilitated.
Further effects of the above-mentioned non-conventional alternatives will be described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a schematic diagram of the main steps of a method of system migration according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of the major modules of a system-ported apparatus according to an embodiment of the invention;
FIG. 3 is an exemplary system architecture diagram in which embodiments of the present invention may be employed;
fig. 4 is a schematic block diagram of a computer system suitable for use in implementing a terminal device or server of an embodiment of the invention.
Detailed Description
Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, in which various details of embodiments of the invention are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
It should be noted that the embodiments of the present invention and the technical features of the embodiments may be combined with each other without conflict.
Fig. 1 is a schematic diagram of the main steps of a method of system migration according to an embodiment of the present invention.
As shown in fig. 1, the system migration method of the embodiment of the present invention mainly includes the following steps:
step S101: acquiring running data of a source database in a first system;
in one embodiment of the invention, the operational data comprises any one or more of: the configuration information of the source database, the table data of the source database, the sql statement corresponding to the source database, the function corresponding to the source database, the trigger, the space usage data of the source database, and the server pressure data. And acquiring an automatic load information report of the source database, and determining the space usage data and the server pressure data according to the automatic load information report.
Specifically, the Automatic Load information report (also called AWR report) includes database details, host configuration information, AWR report start/stop Time and duration (SnapShot information), System Load condition (Load Profile), Top ten Foreground Wait Events (Top 10 formed Events by Total Wait Time), database resource proportion occupied by each process (Time Model Statistics), performance index at Operating System level (Operating System Statistics), SQL statement information of occupied resources (SQL Statistics), and the like.
Step S102: determining the difference between the source database and a target database in a second system according to the operating data;
in one embodiment of the invention, the first system comprises: an X86 server, a Redhat Linux operating system, Weblogic middleware and an Oracle database; the second system includes: the system comprises a Feiteng CPU server, an Tianjin kylin operating system, a Baoland middleware and a Dameng database. And modifying the configuration file, the domain configuration and the used code corresponding to the application to be converted according to the difference between the Bayland middleware and the Weblogic middleware, and configuring the second system according to the modified application to be converted.
Specifically, we need to analyze and modify the war file, that is, modify the configuration file related to weblogic in the war package, such as weblogic.xml; analyzing and modifying domain configuration, organizing application programs in weblogic in a domain, and correspondingly configuring the previously collected information of a source application server (weblogic) on a target application server; analyzing and modifying the jar package, analyzing the jar package which is strongly coupled with the weblogic, and modifying codes used in the application.
Step S103: determining a conversion relation corresponding to the source database and the target database according to the difference;
in one embodiment of the invention, when the running data comprises the sql statement, determining a database schema definition language according to the sql statement; analyzing the database mode definition language and determining the grammatical difference of the source database and the target database; and determining the conversion relation according to the grammar difference.
Specifically, the DDL Language (database Definition Language) involved in the database is combed, so as to perform the difference analysis on the source database (Oracle) and the target database (dreams database). The DDL Language is a Language for describing real-world entities to be stored in a database, and is a component of SQL (Structured Query Language).
In one embodiment of the invention, a data manipulation language is determined from the sql statement; and analyzing the difference of the source database and the target database about the data manipulation language, and determining the conversion relation according to the difference.
Specifically, differences between the source database (Oracle) and the target database (dreams) at the DML (Data management Language) operating level are summarized, summarizing database operations that may be used therein. And determining the conversion relation of the Oracle to the dream database according to the difference between the source database and the target database in the operation level and the operation of the corresponding databases.
In an embodiment of the present invention, a data type corresponding to the source database is determined according to table data of the source database; and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the conversion relation of the field types of the database according to the difference.
Specifically, the field types contained in the source database (Oracle) and the field types involved in the system are statistically analyzed, the field types in the target database (dreams database) are analogized, the difference between the field types in the source database and the field types in the target database is found, and an alternative scheme of the field types of the database is defined, namely, the conversion relation of the field types of the database is determined.
In an embodiment of the present invention, a code corresponding to the application to be migrated is converted according to the database field type conversion relationship and the call relationship between the application to be migrated and the data to be migrated.
Specifically, when the Database is migrated from the Oracle Database to the dream Database, operations such as replacing a JDBC driver package (Java Database Connectivity), configuring a data source link, and driving a class name need to be acquired. JDBC is an application program interface in the Java language that specifies how a client program accesses a database. After the system is correctly connected to the dream database, the corresponding code needs to be adjusted according to the type of data modified in the database migration process.
In an embodiment of the present invention, a difference between functions included in the source database and the target database is determined, and a conversion relationship corresponding to the function is determined according to the difference.
Specifically, the function of the source database (Oracle) and the special syntax used in the storage process are analyzed, and the difference between the special syntax of the source database (Oracle) and the special syntax of the target database (Dameng database) in the function use and storage processes is determined according to the analysis result, so that the conversion relation of the Oracle database to the Dameng database is determined.
In an embodiment of the present invention, a partitioning policy of a target database is determined according to the space usage data of the source database and/or the server pressure data, and the second system is configured according to the partitioning policy.
Specifically, the initialization script of the first system is analyzed, including the data type, the data length of the Darmon database and analyzing the DDL statement for reforming the table. If some applications have special partitioning requirements, the initialization scripts need to be analyzed one by one, so that a partitioning strategy of the dream database is formulated to configure the second system.
In an embodiment of the present invention, the target database is modified according to a service type corresponding to the application to be migrated, where the service type includes an online service and/or a batch service.
In particular, there is a need for modification of the online services of the first system, including real-time transactions and near real-time transactions. In addition, the batch processing service of the first system needs to be modified. And deploying the modified first system to an original application server (weblogic) for verification, so as to confirm the correctness and validity of the database migration part and the change part of the system application.
Step S104: and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted to the second system.
In an embodiment of the present invention, the data to be migrated and the application to be migrated in the source database are transformed according to the transformation relationship; and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
In an embodiment of the present invention, the converted data to be migrated is unloaded from the source database, and the converted data to be migrated is imported into the target database; and transplanting the converted data to be transplanted to the target database by using a data migration tool of the target database.
Specifically, the file can be unloaded from the Oracle database and then imported into the dream arrival database, and a DM data migration tool (DTS) provided by the dream arrival database can be used for stock data migration, and the tool provides a function of migrating tables, views, indexes and the like of a mainstream large database (Oracle, MySQL, DB2 and the like) into the dream arrival database.
According to the embodiment of the invention, the difference between the operation data of the source database in the first system before the migration and the target database in the second system after the migration can be determined, the conversion relation between the source database and the target database can be determined according to the difference, and the application and the data in the first system can be migrated to the second system according to the determined conversion relation, so that the adaptation between the data and the application before and after the migration and the second system can be ensured, the efficiency of the system migration can be improved, and the normal operation of the system after the migration can be facilitated. When the first system is a foreign system and the second system is a domestic system, the conversion relation from the foreign operating system to the domestic operating system can be obtained by analyzing the difference between the current foreign operating system and the domestic operating system, so that the transplantation of the foreign operating system to the domestic operating system becomes possible, the monopoly of foreign enterprises on the information system architecture is broken, and the information security of China is facilitated.
Fig. 2 is a schematic diagram of the main modules of the system-ported apparatus according to an embodiment of the present invention.
As shown in fig. 1, the system transplanting device 200 according to the embodiment of the present invention includes: an acquisition module 201, a difference determination module 202 and a migration module 203.
Wherein the content of the first and second substances,
the obtaining module 201 is configured to obtain operating data of a source database in a first system;
the difference determining module 202 is configured to determine, according to the operating data, a difference between the source database and a target database in the second system;
the migration module 203 is configured to determine a conversion relationship corresponding to the source database and the target database according to the difference; and according to the conversion relation, migrating the data and the application in the first system to the second system.
In an embodiment of the present invention, the obtaining module 201 is configured to obtain an automatic load information report of the source database, and determine the space usage data and the server pressure data according to the automatic load information report.
In an embodiment of the present invention, the migration module 203 is configured to convert the data to be migrated and the application to be migrated in the source database according to the conversion relationship; and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
In an embodiment of the present invention, the migration module 203 is configured to determine a database schema definition language according to the sql statement; analyzing the database mode definition language and determining the grammatical difference of the source database and the target database; and determining the conversion relation according to the grammar difference.
In one embodiment of the invention, the operational data comprises any one or more of: the configuration information of the source database, the table data of the source database, the sql statement corresponding to the source database, the function corresponding to the source database, the trigger, the space usage data of the source database, and the server pressure data.
In an embodiment of the present invention, the migration module 203 determines a database schema definition language according to the sql statement; analyzing the database mode definition language and determining the grammatical difference of the source database and the target database; and determining the conversion relation according to the grammar difference.
In an embodiment of the present invention, the migration module 203 determines a data manipulation language according to the sql statement; and analyzing the difference of the source database and the target database about the data manipulation language, and determining the conversion relation according to the difference.
In an embodiment of the present invention, the migration module 203 determines a data type corresponding to the source database according to the table data of the source database; and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the conversion relation of the field types of the database according to the difference.
In an embodiment of the present invention, the difference determining module 202 determines a difference between functions included in the source database and the target database, and determines a conversion relationship corresponding to the function according to the difference.
In an embodiment of the present invention, the migration module 203 unloads the converted data to be migrated from the source database, and imports the converted data to be migrated into the target database;
in an embodiment of the present invention, the migration module 203 utilizes a data migration tool of the target database to migrate the converted data to be migrated to the target database.
In an embodiment of the present invention, the difference determining module 202 converts the code corresponding to the application to be migrated according to the database field type conversion relationship and the call relationship between the application to be migrated and the data to be migrated.
In an embodiment of the present invention, the migration module 203 determines a partition policy of a target database according to the space usage data of the source database and/or the server pressure data, and configures the second system according to the partition policy.
In an embodiment of the present invention, the migration module 203 reconstructs the target database according to a service type corresponding to the application to be migrated, where the service type includes an online service and/or a batch processing service.
In one embodiment of the invention, the first system comprises: an X86 server, a Redhat Linux operating system, Weblogic middleware and an Oracle database;
the second system includes: the system comprises a Feiteng CPU server, an Tianjin kylin operating system, a Baoland middleware and a Dameng database.
In an embodiment of the present invention, the migration module 203 modifies a configuration file, a domain configuration, and a used code corresponding to the application to be converted according to a difference between the bawland middleware and the Weblogic middleware, and configures the second system according to the modified application to be converted.
An embodiment of the present invention further provides a server, including: one or more processors; a storage device for storing one or more programs which, when executed by the one or more processors, cause the one or more processors to implement the identification method as provided in any of the embodiments above.
Embodiments of the present invention further provide a computer-readable medium, on which a computer program is stored, where the computer program, when executed by a processor, implements the identification method provided in any of the above embodiments.
Fig. 3 illustrates an exemplary system architecture 300 to which the method of system migration or apparatus of system migration of embodiments of the present invention may be applied.
As shown in fig. 3, the system architecture 300 may include terminal devices 301, 302, 303, a network 304, and a server 305. The network 304 serves as a medium for providing communication links between the terminal devices 301, 302, 303 and the server 305. Network 304 may include various connection types, such as wired, wireless communication links, or fiber optic cables, to name a few.
The user may use the terminal device 301, 302, 303 to interact with the server 305 via the network 304 to receive or send messages or the like. The terminal devices 301, 302, 303 may have various communication client applications installed thereon, such as shopping applications, web browser applications, search applications, instant messaging tools, mailbox clients, social platform software, and the like.
The terminal devices 301, 302, 303 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.
The server 305 may be a server providing various services, such as a background management server providing support for shopping websites browsed by the user using the terminal devices 301, 302, 303. The background management server may analyze and perform other processing on the received data such as the product information query request, and feed back a processing result (e.g., target push information and product information) to the terminal device.
It should be noted that the method for system migration provided by the embodiment of the present invention is generally executed by the server 305, and accordingly, the apparatus for system migration is generally disposed in the server 305.
It should be understood that the number of terminal devices, networks, and servers in fig. 3 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 4, a block diagram of a computer system 400 suitable for use with a terminal device implementing an embodiment of the invention is shown. The terminal device shown in fig. 4 is only an example, and should not bring any limitation to the functions and the scope of use of the embodiments of the present invention.
As shown in fig. 4, the computer system 400 includes a Central Processing Unit (CPU)401 that can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)402 or a program loaded from a storage section 408 into a Random Access Memory (RAM) 403. In the RAM 403, various programs and data necessary for the operation of the system 400 are also stored. The CPU 401, ROM 402, and RAM 403 are connected to each other via a bus 404. An input/output (I/O) interface 405 is also connected to bus 404.
The following components are connected to the I/O interface 405: an input section 406 including a keyboard, a mouse, and the like; an output section 407 including a display device such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage section 408 including a hard disk and the like; and a communication section 409 including a network interface card such as a LAN card, a modem, or the like. The communication section 409 performs communication processing via a network such as the internet. A driver 410 is also connected to the I/O interface 405 as needed. A removable medium 411 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 410 as necessary, so that a computer program read out therefrom is mounted into the storage section 408 as necessary.
In particular, according to the embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 409, and/or installed from the removable medium 411. The computer program performs the above-described functions defined in the system of the present invention when executed by a Central Processing Unit (CPU) 401.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a module, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The modules described in the embodiments of the present invention may be implemented by software or hardware. The described modules may also be provided in a processor, which may be described as: a processor includes an acquisition module, a discrepancy determining module, and a migration module. The names of these modules do not form a limitation to the module itself in some cases, for example, the obtaining module may also be described as a "module for obtaining the running data of the source database in the first system".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be separate and not incorporated into the device. The computer readable medium carries one or more programs which, when executed by a device, cause the device to comprise: acquiring running data of a source database in a first system; determining the difference between the source database and a target database in a second system according to the operating data; determining a conversion relation corresponding to the source database and the target database according to the difference; and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted to the second system.
According to the technical scheme of the embodiment of the invention, the difference between the operation data of the source database in the first system before the migration and the operation data of the target database in the second system after the migration can be determined, the conversion relation between the source database and the target database can be determined according to the difference, and the application and the data in the first system can be migrated to the second system according to the determined conversion relation, so that the adaptation between the application and the second system before and after the migration is ensured, the efficiency of the system migration is improved, and the normal operation of the system after the migration is facilitated. When the first system is a foreign system and the second system is a domestic system, the conversion relation from the foreign operating system to the domestic operating system can be obtained by analyzing the difference between the current foreign operating system and the domestic operating system, so that the transplantation of the foreign operating system to the domestic operating system becomes possible, the monopoly of foreign enterprises on the information system architecture is broken, and the information security of China is facilitated.
The above-described embodiments should not be construed as limiting the scope of the invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions can occur, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (17)
1. A method of system migration, comprising:
acquiring running data of a source database in a first system; the first system includes: an X86 server, a Redhat Linux operating system, Weblogic middleware and an Oracle database;
determining the difference between the source database and a target database in a second system according to the operating data; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a Dameng database;
determining a conversion relation corresponding to the source database and the target database according to the difference;
and according to the conversion relation, the data to be transplanted and the application to be transplanted in the first system are transplanted to the second system.
2. The method of claim 1,
converting the data to be transplanted and the application to be transplanted in the source database according to the conversion relation;
and configuring the second system according to the converted data to be transplanted and the application to be transplanted.
3. The method of claim 1,
the operational data includes any one or more of: the configuration information of the source database, the table data of the source database, the sql statement corresponding to the source database, the function corresponding to the source database, the trigger, the space usage data of the source database, and the server pressure data.
4. The method of claim 3, wherein when the run data comprises the sql statement,
determining a database schema definition language according to the sql statement;
analyzing the database mode definition language and determining the grammatical difference of the source database and the target database;
and determining the conversion relation according to the grammar difference.
5. The method of claim 3,
determining a data manipulation language according to the sql statement;
and analyzing the difference of the source database and the target database about the data manipulation language, and determining the conversion relation according to the difference.
6. The method of claim 3,
determining a data type corresponding to the source database according to the table data of the source database;
and determining the difference between the data type corresponding to the source data and the data type of the target database, and determining the conversion relation of the field types of the database according to the difference.
7. The method of claim 3,
and determining the difference of the functions included in the source database and the target database, and determining the conversion relation corresponding to the functions according to the difference.
8. The method of claim 3,
and acquiring an automatic load information report of the source database, and determining the space usage data and the server pressure data according to the automatic load information report.
9. The method of claim 2,
unloading the converted data to be transplanted from the source database, and importing the converted data to be transplanted into the target database.
10. The method of claim 2,
and transplanting the converted data to be transplanted to the target database by using a data migration tool of the target database.
11. The method of claim 6,
and converting the codes corresponding to the application to be transplanted according to the database field type conversion relation and the calling relation between the application to be transplanted and the data to be transplanted.
12. The method of claim 3,
and determining a partition strategy of a target database according to the space usage data and/or the server pressure data of the source database, and configuring the second system according to the partition strategy.
13. The method of claim 2, further comprising:
and reconstructing the target database according to the service type corresponding to the application to be transplanted, wherein the service type comprises online service and/or batch processing service.
14. The method of claim 1,
and modifying the configuration file, the domain configuration and the used code corresponding to the application to be converted according to the difference between the Bayland middleware and the Weblogic middleware, and configuring the second system according to the modified application to be converted.
15. An apparatus for system migration, comprising: the device comprises an acquisition module, a difference determination module and a transplantation module; wherein the content of the first and second substances,
the acquisition module is used for acquiring the operating data of the source database in the first system; the first system includes: an X86 server, a Redhat Linux operating system, Weblogic middleware and an Oracle database;
the difference determining module is used for determining the difference between the source database and a target database in the second system according to the operating data; the second system includes: the system comprises a Feiteng CPU server, a Tianjin kylin operating system, a Baoland middleware and a Dameng database;
the migration module is used for determining a conversion relation corresponding to the source database and the target database according to the difference; and according to the conversion relation, migrating the data and the application in the first system to the second system.
16. An electronic device for system migration, comprising:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-14.
17. A computer-readable medium, on which a computer program is stored, which, when being executed by a processor, carries out the method according to any one of claims 1-14.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110454524.8A CN113515306B (en) | 2021-04-26 | 2021-04-26 | System transplanting method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110454524.8A CN113515306B (en) | 2021-04-26 | 2021-04-26 | System transplanting method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113515306A true CN113515306A (en) | 2021-10-19 |
| CN113515306B CN113515306B (en) | 2023-04-25 |
Family
ID=78063848
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110454524.8A Active CN113515306B (en) | 2021-04-26 | 2021-04-26 | System transplanting method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113515306B (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117851434A (en) * | 2024-03-07 | 2024-04-09 | 深圳市雁联计算系统有限公司 | Method, system and storage medium for concurrent migration of database |
| CN117851434B (en) * | 2024-03-07 | 2024-05-14 | 深圳市雁联计算系统有限公司 | Method, system and storage medium for concurrent migration of database |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050138606A1 (en) * | 2003-12-17 | 2005-06-23 | Sujit Basu | System and method for code migration |
| WO2013002937A2 (en) * | 2011-06-29 | 2013-01-03 | Microsoft Corporation | Virtual machine migration tool |
| US20170192758A1 (en) * | 2016-01-04 | 2017-07-06 | Syntel, Inc. | Method and apparatus for migration of application source code |
| US20170206245A1 (en) * | 2016-01-20 | 2017-07-20 | Oracle International Corporation | System and method for dynamic conversion of database accessing scripts during runtime in a mainframe rehosting platform |
| KR101762283B1 (en) * | 2016-05-19 | 2017-07-31 | 주식회사 티맥스 소프트 | Method and computer program stored in computer-readable medium for converting sort script to reuse jcl in different encoding environment |
| US20170286412A1 (en) * | 2016-03-29 | 2017-10-05 | Wipro Limited | System and method for database migration with target platform scalability |
| CN110968566A (en) * | 2019-11-01 | 2020-04-07 | 广东省信息工程有限公司 | Migration tool-based domestic application system migration method |
| US20200334244A1 (en) * | 2019-04-19 | 2020-10-22 | Oracle International Corporation | Bidirectional mapping of hierarchical data to database object types |
| CN112685081A (en) * | 2020-12-15 | 2021-04-20 | 建信金融科技有限责任公司 | System migration method and device, electronic equipment and storage medium |
-
2021
- 2021-04-26 CN CN202110454524.8A patent/CN113515306B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050138606A1 (en) * | 2003-12-17 | 2005-06-23 | Sujit Basu | System and method for code migration |
| WO2013002937A2 (en) * | 2011-06-29 | 2013-01-03 | Microsoft Corporation | Virtual machine migration tool |
| US20170192758A1 (en) * | 2016-01-04 | 2017-07-06 | Syntel, Inc. | Method and apparatus for migration of application source code |
| US20170206245A1 (en) * | 2016-01-20 | 2017-07-20 | Oracle International Corporation | System and method for dynamic conversion of database accessing scripts during runtime in a mainframe rehosting platform |
| US20170286412A1 (en) * | 2016-03-29 | 2017-10-05 | Wipro Limited | System and method for database migration with target platform scalability |
| KR101762283B1 (en) * | 2016-05-19 | 2017-07-31 | 주식회사 티맥스 소프트 | Method and computer program stored in computer-readable medium for converting sort script to reuse jcl in different encoding environment |
| US20200334244A1 (en) * | 2019-04-19 | 2020-10-22 | Oracle International Corporation | Bidirectional mapping of hierarchical data to database object types |
| CN110968566A (en) * | 2019-11-01 | 2020-04-07 | 广东省信息工程有限公司 | Migration tool-based domestic application system migration method |
| CN112685081A (en) * | 2020-12-15 | 2021-04-20 | 建信金融科技有限责任公司 | System migration method and device, electronic equipment and storage medium |
Non-Patent Citations (1)
| Title |
|---|
| 段永见;: "ORACLE到DB2应用移植方法探讨", no. 11 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN117851434A (en) * | 2024-03-07 | 2024-04-09 | 深圳市雁联计算系统有限公司 | Method, system and storage medium for concurrent migration of database |
| CN117851434B (en) * | 2024-03-07 | 2024-05-14 | 深圳市雁联计算系统有限公司 | Method, system and storage medium for concurrent migration of database |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113515306B (en) | 2023-04-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10970277B2 (en) | System and method for dynamic conversion of database accessing scripts during runtime in a mainframe rehosting platform | |
| US9563650B2 (en) | Migrating federated data to multi-source universe database environment | |
| CN111400061A (en) | Data processing method and system | |
| CN111125064B (en) | Method and device for generating database schema definition statement | |
| EP3937022B1 (en) | Method and apparatus of monitoring interface performance of distributed application, device and storage medium | |
| CN111666293A (en) | Database access method and device | |
| CN110689268A (en) | Method and device for extracting indexes | |
| CN113760948A (en) | Data query method and device | |
| CN112000734A (en) | Big data processing method and device | |
| CN110795135A (en) | Method and device for realizing injection-resolution configuration | |
| CN110764769B (en) | Method and device for processing user request | |
| CN111414154A (en) | Method and device for front-end development, electronic equipment and storage medium | |
| CN116204428A (en) | Test case generation method and device | |
| CN113515306B (en) | System transplanting method and device | |
| CN113779122B (en) | Method and device for exporting data | |
| CN111752916B (en) | Data acquisition method and device, computer readable storage medium and electronic equipment | |
| CN112988583A (en) | Method and device for testing syntax compatibility of database | |
| CN112416865A (en) | File processing method and device based on big data | |
| CN112182080A (en) | Data integration system and data processing method based on data integration system | |
| CN113779018A (en) | Data processing method and device | |
| CN112214500A (en) | Data comparison method and device, electronic equipment and storage medium | |
| CN112925772A (en) | Data dynamic splitting method and device | |
| CN112988857A (en) | Service data processing method and device | |
| CN115563183B (en) | Query method, query device and program product | |
| CN113268417B (en) | Task execution method and device |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |