Migration method and device, equipment and storage medium
AI-driven data migration methods automate and optimize data transfer by generating migration maps and adjusting parameters, enhancing efficiency and adaptability.
Patent Information
- Application Number
- CN202411237554.3
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-09-04
- Publication Date
- 2024-12-06
AI Technical Summary
Current data migration technologies require manual configuration and cannot be dynamically optimized, leading to inefficiencies and low efficiency in adapting to the rapid changes in data migration needs.
A method and device utilizing AI intelligence to automate data migration by obtaining connection information, determining metadata, generating migration maps, and adjusting parameters based on load and network status to optimize data transfer.
Enhances data migration efficiency by automating and dynamically optimizing the process, improving adaptability and reducing manual intervention.
Smart Images

Figure CN119088788A_ABST
Abstract
Description
Background Art
[0002] As the application of social informatization continues to deepen, data has become an increasingly important asset for enterprises. In addition, data information in all walks of life has grown explosively, accumulating a huge amount of historical data. Due to technological development and changes in business needs, it is sometimes necessary to migrate this data from one database to another. However, when migrating data, related technologies require a lot of manual configuration or manual scripting, and cannot be dynamically optimized and adjusted according to the situation of the migrated data, making the current data migration efficiency low. Summary of the invention
[0003] The present disclosure provides a migration method, apparatus, device and storage medium, which improve the efficiency of data migration at least to a certain extent.
[0004] Other features and advantages of the present disclosure will become apparent from the following detailed description, or may be learned in part by the practice of the present disclosure.
[0005] According to one aspect of the present disclosure, a migration method is provided, which is applied to a first AI intelligence, including:
[0006] Obtaining connection information of the first database and the second database;
[0007] Connecting the first database and the second database according to the connection information, and determining metadata information of the first database and the second database;
[0008] Generate a migration map according to metadata information and a preset map generation algorithm;
[0009] The migration map is sent to the second AI intelligence, so that the second AI intelligence completes the data migration between the first database and the second database.
[0010] In one embodiment of the present disclosure, the method further includes:
[0011] When the data migration is completed, the migration result information sent by the second AI intelligence is received.
[0012] According to another aspect of the present disclosure, a migration method is provided, which is applied to a second AI intelligence, including:
[0013] Receiving a migration map sent by the first AI intelligence;
[0014] Determine the migration strategy based on at least one of the following information: the amount of data to be migrated, threads, and migration cycles;
[0015] Data migration is completed between the first database and the second database based on the migration strategy.
[0016] In one embodiment of the present disclosure, the method further includes:
[0017] After the data migration is completed, the migration result information is sent to the first AI intelligence.
[0018] In one embodiment of the present disclosure, the method further includes:
[0019] Receive parameter adjustment information sent by the third AI intelligence, where the parameter adjustment information is generated by the third AI intelligence based on at least one of the load information of the first database, the load information of the second database, the network status information, the data read and write information, the migration data priority information, the memory information of the first database, and the memory information of the second database.
[0020] In one embodiment of the present disclosure, the method further includes:
[0021] The data migration action is adjusted according to the parameter adjustment information, where the data migration action includes at least one of suspending migration, increasing the amount of data during batch migration, reducing the amount of data during batch migration, and suspending migration and second AI smart wake-up.
[0022] According to another aspect of the present disclosure, a migration method is provided, which is applied to a third AI intelligence, including:
[0023] Generate parameter adjustment information based on at least one of the load information of the first database, the load information of the second database, network status information, data read and write information, migration data priority information, memory information of the first database, and memory information of the second database;
[0024] Send parameter adjustment information to the second AI intelligence.
[0025] According to another aspect of the present disclosure, a migration device is provided, which is applied to a first AI intelligence, including:
[0026] A first acquisition module, used to acquire the connection information of the first database and the second database;
[0027] A first determination module, used to connect the first database and the second database according to the connection information, and determine the metadata information of the first database and the second database;
[0028] A first generation module, used to generate a migration map according to metadata information and a preset mapping generation algorithm;
[0029] The first sending module is used to send the migration mapping to the second AI intelligence, so that the second AI intelligence completes the data migration between the first database and the second database.
[0030] In one embodiment of the present disclosure, the device further includes:
[0031] The third receiving module is used to receive the migration result information sent by the second AI intelligence when the data migration is completed.
[0032] According to another aspect of the present disclosure, a migration device is provided, which is applied to a second AI intelligence, including:
[0033] A first receiving module, configured to receive a migration mapping sent by a first AI intelligence;
[0034] A second determination module is used to determine the migration strategy according to the migration map to determine at least one of the following information: the amount of data to be migrated, the thread, and the migration period;
[0035] The migration module is used to complete data migration between the first database and the second database based on the migration strategy.
[0036] In one embodiment of the present disclosure, the device further includes:
[0037] The third sending module is used to send migration result information to the first AI intelligence after the data migration is completed.
[0038] In one embodiment of the present disclosure, the device further includes:
[0039] The third receiving module is used to receive parameter adjustment information sent by the third AI intelligence, where the parameter adjustment information is generated by the third AI intelligence based on at least one of the load information of the first database, the load information of the second database, the network status information, the data read and write information, the migration data priority information, the memory information of the first database, and the memory information of the second database.
[0040] In one embodiment of the present disclosure, the device further includes:
[0041] The adjustment module is used to adjust the data migration action according to the parameter adjustment information, where the data migration action includes at least one of suspending migration, increasing the amount of data during batch migration, reducing the amount of data during batch migration, and suspending migration of the second AI smart wake-up.
[0042] According to another aspect of the present disclosure, a migration device is provided, which is applied to a third AI intelligence, including:
[0043] A second generating module, configured to generate parameter adjustment information based on at least one of the load information of the first database, the load information of the second database, network status information, data read and write information, migration data priority information, memory information of the first database, and memory information of the second database;
[0044] The second sending module is used to send parameter adjustment information to the second AI intelligence.
[0045] According to another aspect of the present disclosure, an electronic device is provided, including: a processor; and a memory for storing executable instructions of the processor; wherein the processor is configured to perform the above-mentioned migration method by executing the executable instructions.
[0046] According to another aspect of the present disclosure, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the above-mentioned migration method is implemented.
[0047] The migration method, apparatus, device and storage medium provided by the embodiments of the present disclosure obtain connection information of the first database and the second database, connect the first database and the second database according to the connection information, determine metadata information of the first database and the second database, generate a migration map according to the metadata information and a preset mapping generation algorithm, and send the migration map to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database, thereby improving the efficiency of data migration.
[0048] It is to be understood that the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the present disclosure. BRIEF DESCRIPTION OF THE DRAWINGS
[0049] The accompanying drawings herein are incorporated into the specification and constitute a part of the specification, illustrate embodiments consistent with the present disclosure, and together with the specification are used to explain the principles of the present disclosure. Obviously, the accompanying drawings described below are only some embodiments of the present disclosure, and for ordinary technicians in this field, other accompanying drawings can be obtained based on these accompanying drawings without creative work.
[0050] Figure 1 A schematic diagram of the structure of a migration system in an embodiment of the present disclosure is shown;
[0051] Figure 2 A flow chart of a migration method in an embodiment of the present disclosure is shown;
[0052] Figure 3 Another migration method flow chart in the embodiment of the present disclosure is shown;
[0053] Figure 4 A flow chart of another migration method in an embodiment of the present disclosure is shown;
[0054] Figure 5 A flow chart of another migration method in an embodiment of the present disclosure is shown;
[0055] Figure 6 A flow chart of another migration method in an embodiment of the present disclosure is shown;
[0056] Figure 7A flow chart of another migration method in an embodiment of the present disclosure is shown;
[0057] Figure 8 A schematic diagram of a migration device in an embodiment of the present disclosure is shown;
[0058] Fig. 9 A schematic diagram of another migration device in an embodiment of the present disclosure is shown;
[0059] Fig.10 A schematic diagram of another migration device in an embodiment of the present disclosure is shown;
[0060] Fig.11 A structural block diagram of an electronic device in an embodiment of the present disclosure is shown. DETAILED DESCRIPTION
[0061] Example embodiments will now be described more fully with reference to the accompanying drawings. However, example embodiments can be implemented in a variety of forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that the disclosure will be more comprehensive and complete and to fully convey the concepts of the example embodiments to those skilled in the art. The described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments.
[0062] In addition, the accompanying drawings are only schematic illustrations of the present disclosure and are not necessarily drawn to scale. The same reference numerals in the figures represent the same or similar parts, and their repeated description will be omitted. Some of the block diagrams shown in the accompanying drawings are functional entities and do not necessarily correspond to physically or logically independent entities. These functional entities can be implemented in software form, or implemented in one or more hardware modules or integrated circuits, or implemented in different networks and / or processor devices and / or microcontroller devices.
[0063] It should be understood that the various steps described in the method embodiments of the present disclosure may be performed in different orders and / or in parallel. In addition, the method embodiments may include additional steps and / or omit the steps shown. The scope of the present disclosure is not limited in this respect.
[0064] It should be noted that the concepts such as "first" and "second" mentioned in the present disclosure are only used to distinguish different devices, modules or units, and are not used to limit the order or interdependence of the functions performed by these devices, modules or units.
[0065] It should be noted that the modifications of "one" and "plurality" mentioned in the present disclosure are illustrative rather than restrictive, and those skilled in the art should understand that unless otherwise clearly indicated in the context, it should be understood as "one or more".
[0066] With the acceleration of digital transformation, the amount of data generated by enterprises and organizations is growing exponentially. At the same time, enterprises often need to migrate data between different systems, databases, and cloud platforms to adapt to business development, technology upgrades, or cost optimization needs. All of these make it difficult for traditional manual or semi-automatic data migration methods to cope with the rapid transfer needs of large-scale and complex data sets.
[0067] In order to solve the above technical problems, the present disclosure provides a migration method, device, equipment and storage medium. In order to explain the present disclosure in detail, the present disclosure first explains the migration method.
[0068] It should be pointed out that, in the absence of conflict, the embodiments of the present disclosure and the technical features therein may be combined with each other.
[0069] The specific implementation method of the embodiment of the present disclosure is described in detail below with reference to the accompanying drawings.
[0070] Figure 1 A schematic diagram of the structure of a migration system in an embodiment of the present disclosure is shown, and the system can apply the migration method or migration device in each embodiment of the present disclosure.
[0071] like Figure 1 As shown, the migration system 10 may include an agent layer 101 , a perception setting layer 102 , a basic layer 103 , and a user system 104 .
[0072] The agent layer 101 includes a first AI agent, a second AI agent, and a third AI agent. The first AI agent may be a migration planning agent, the second AI agent may be a migration execution agent, and the third AI agent may be a migration supervision and optimization agent.
[0073] The perception setting layer 102 includes an agent role setting module, an agent memory information module, an agent action control module, an agent environment module, and an agent goal and constraint module.
[0074] The basic layer 103 may include a database connection driver module, a database operation API module, a large pre-trained language model module, a built-in commission vocabulary module, and a reinforcement learning model module.
[0075] The user system 104 may include a user registration module, a login authentication module, a permission management module, a file management module, and a multi-user support module.
[0076] The agent layer 101, the perception setting layer 102, the basic layer 103, and the user system 104 may be located on multiple different devices. For example, the agent layer 101 may be a module on a device such as a camera for recording video, and the perception setting layer 102 may be a module on an electronic device with processing capabilities such as a computer. The agent layer 101, the perception setting layer 102, the basic layer 103, and the user system 104 may be located on the same device.
[0077] The intelligent body layer 101, the perception setting layer 102, the basic layer 103, and the user system 104 are connected to each other through a network, which can be a wired network or a wireless network.
[0078] Optionally, the wireless network or wired network described above uses standard communication technology and / or protocol. The network is usually the Internet, but it can also be any network, including but not limited to a local area network (LAN), a metropolitan area network (MAN), a wide area network (WAN), a mobile, wired or wireless network, a dedicated network or any combination of a virtual private network). In some embodiments, technologies and / or formats including Hyper Text Mark-up Language (HTML), Extensible Markup Language (XML), etc. are used to represent data exchanged through the network. In addition, conventional encryption technologies such as Secure Socket Layer (SSL), Transport Layer Security (TLS), Virtual Private Network (VPN), Internet Protocol Security (IPsec) can also be used to encrypt all or some links. In other embodiments, customized and / or dedicated data communication technologies can also be used to replace or supplement the above data communication technologies.
[0079] The following describes the situation where the agent layer 101, the perception setting layer 102, the basic layer 103, and the user system 104 can be located on different devices.
[0080] The intelligent body layer 101, the perception setting layer 102, the basic layer 103, and the user system 104 can all be located on a terminal device, which can be a variety of electronic devices, including but not limited to smart phones, tablet computers, laptop computers, desktop computers, wearable devices, augmented reality devices, virtual reality devices, etc.
[0081] Optionally, the client of the application installed in different terminal devices is the same, or the client of the same type of application based on different operating systems. Based on the different terminal platforms, the specific form of the client of the application can also be different, for example, the application client can be a mobile client, a PC client, etc.
[0082] The agent layer 101, the perception setting layer 102, the basic layer 103, and the user system 104 can all be located on a server, which can be a server that provides various services, such as a background management server that provides support for devices operated by users using terminal devices. The background management server can analyze and process the received request and other data, and feed back the processing results to the terminal device.
[0083] Optionally, the server can be an independent physical server, a server cluster or distributed system composed of multiple physical servers, or a cloud server that provides basic cloud computing services such as cloud services, cloud databases, cloud computing, cloud functions, cloud storage, network services, cloud communications, middleware services, domain name services, security services, CDN (Content Delivery Network), as well as big data and artificial intelligence platforms.
[0084] Those skilled in the art will know that Figure 1 The number of the agent layer 101, the perception setting layer 102, the basic layer 103, and the user system 104 is only for illustration, and any number of data acquisition modules and data processing modules may be provided according to actual needs. The embodiments of the present disclosure are not limited to this.
[0085] Figure 2 A flow chart of a migration method in an embodiment of the present disclosure is shown. It should be noted that the migration method in the present disclosure is applied to the first AI intelligence.
[0086] like Figure 2 As shown, migration methods may include:
[0087] S210: Acquire connection information of the first database and the second database.
[0088] In some embodiments, the first database may be a database in which data is previously stored, and the second database may be a database into which the data needs to be migrated.
[0089] Exemplarily, the first database may be a source database, and the second database may be a target database.
[0090] In some embodiments, the connection information of the first database and the second database may be input into the first AI intelligence by a user.
[0091] In some embodiments, the connection information may include at least one of a user name, address, port, and password of a database.
[0092] In some embodiments, AI intelligence may include intelligent models, large language models, and other models capable of data processing capabilities.
[0093] S220: Connect the first database and the second database according to the connection information, and determine metadata information of the first database and the second database.
[0094] In some embodiments, after the second AI intelligence receives the connection information, it can connect to the first database and the second database based on the connection information, and then after connecting to the first database and the second database, it can obtain metadata information in the first database and the second database.
[0095] In some embodiments, the second AI intelligence may send metadata information to the first AI intelligence, and the first AI intelligence may generate a migration map based on the metadata information and a preset mapping generation algorithm.
[0096] In some embodiments, the first AI intelligence can connect to the first database and the second database based on the connection information, and then obtain metadata information from the first database and the second database.
[0097] S230: Generate a migration map according to the metadata information and a preset mapping generation algorithm.
[0098] In some embodiments, the mapping generation algorithm may be an intelligent model.
[0099] Exemplarily, the metadata information is sent to the intelligent model to obtain a migration map.
[0100] S240: Send the migration mapping to the second AI intelligence, so that the second AI intelligence completes the data migration between the first database and the second database.
[0101] In some embodiments, after the second AI intelligently determines the migration mapping, data migration can be completed based on the determined first database and second database.
[0102] The migration method provided by the embodiments of the present disclosure obtains connection information of the first database and the second database, connects the first database and the second database according to the connection information, determines metadata information of the first database and the second database, generates a migration map according to the metadata information and a preset mapping generation algorithm, and sends the migration map to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database, thereby improving the efficiency of data migration.
[0103] Figure 3 A flow chart of another migration method in an embodiment of the present disclosure is shown.
[0104] like Figure 3 As shown, the identification method may include:
[0105] S310, obtaining connection information of the first database and the second database;
[0106] S320, connecting the first database and the second database according to the connection information, and determining metadata information of the first database and the second database;
[0107] S330, generating a migration map according to the metadata information and a preset mapping generation algorithm;
[0108] S340: Send the migration mapping to the second AI intelligence, so that the second AI intelligence completes the data migration between the first database and the second database.
[0109] S350: When the data migration is completed, receive the migration result information sent by the second AI intelligence.
[0110] In some embodiments, the migration result information may be used to indicate that the data migration has been completed.
[0111] In some embodiments, after the migration map is generated, the generated migration map may be sent to the user, and after confirmation by the user, the migration map is sent to the second database.
[0112] The migration method provided by the embodiments of the present disclosure obtains connection information of the first database and the second database, connects the first database and the second database according to the connection information, determines metadata information of the first database and the second database, generates a migration map according to the metadata information and a preset mapping generation algorithm, and sends the migration map to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database, thereby improving the efficiency of data migration.
[0113] Figure 4 A flow chart of another migration method in an embodiment of the present disclosure is shown. It should be noted that the migration method in the present disclosure is applied to the second AI intelligence.
[0114] like Figure 4 As shown, migration methods may include:
[0115] S410, receiving a migration mapping sent by a first AI intelligence;
[0116] S420: Determine a migration strategy based on at least one of the following information: the amount of data to be migrated, threads, and a migration period according to the migration mapping.
[0117] S430: Complete data migration between the first database and the second database based on the migration strategy.
[0118] In some embodiments, when the second AI intelligence completes data migration between the first database and the second database, the data migration result can be sent to the first AI intelligence, and then the first AI intelligence confirms the migration result and feeds back to the user.
[0119] The migration method provided by the embodiments of the present disclosure obtains connection information of the first database and the second database, connects the first database and the second database according to the connection information, determines metadata information of the first database and the second database, generates a migration map according to the metadata information and a preset mapping generation algorithm, and sends the migration map to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database, thereby improving the efficiency of data migration.
[0120] Figure 5 A flow chart of another migration method in an embodiment of the present disclosure is shown. It should be noted that the migration method in the present disclosure is applied to the second AI intelligence.
[0121] like Figure 5 As shown, migration methods may include:
[0122] S510, receiving a migration mapping sent by a first AI intelligence;
[0123] S520, determining a migration strategy based on at least one of the following information: the amount of data to be migrated, threads, and migration cycles;
[0124] S530: Complete data migration between the first database and the second database based on the migration strategy.
[0125] S540: After the data migration is completed, the migration result information is sent to the first AI intelligence.
[0126] The migration method provided by the embodiments of the present disclosure obtains connection information of the first database and the second database, connects the first database and the second database according to the connection information, determines metadata information of the first database and the second database, generates a migration map according to the metadata information and a preset mapping generation algorithm, and sends the migration map to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database, thereby improving the efficiency of data migration.
[0127] Figure 6 A flow chart of another migration method in an embodiment of the present disclosure is shown. It should be noted that the migration method in the present disclosure is applied to the second AI intelligence.
[0128] like Figure 6 As shown, migration methods may include:
[0129] S610, receiving a migration mapping sent by a first AI intelligence;
[0130] S620, determining a migration strategy based on at least one of the following information: the amount of data to be migrated, threads, and migration cycles;
[0131] S630: Complete data migration between the first database and the second database based on the migration strategy.
[0132] S640, receiving parameter adjustment information sent by the third AI intelligence, where the parameter adjustment information is generated by the third AI intelligence based on at least one of the load information of the first database, the load information of the second database, the network status information, the data read and write information, the migration data priority information, the memory information of the first database, and the memory information of the second database.
[0133] In some embodiments, after the second AI intelligence receives the above parameter adjustment information, it can adjust the parameters based on the parameter adjustment information.
[0134] In some embodiments, after the parameter adjustment is completed, the second AI intelligence can continue to complete the data migration.
[0135] In some embodiments, after the second AI intelligently receives the parameter adjustment information, the method may further include:
[0136] The data migration action is adjusted according to the parameter adjustment information, where the data migration action includes at least one of suspending migration, increasing the amount of data during batch migration, reducing the amount of data during batch migration, and suspending migration and second AI smart wake-up.
[0137] The migration method provided by the embodiments of the present disclosure obtains connection information of the first database and the second database, connects the first database and the second database according to the connection information, determines metadata information of the first database and the second database, generates a migration map according to the metadata information and a preset mapping generation algorithm, and sends the migration map to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database, thereby improving the efficiency of data migration.
[0138] Based on the same inventive concept, the present disclosure also provides a migration method, such as the following embodiment. Since the principle of solving the problem in this method embodiment is similar to that in the above method embodiment, the implementation of this method embodiment can refer to the implementation of the above method embodiment, and the repeated parts will not be repeated.
[0139] Figure 7A flow chart of another migration method in an embodiment of the present disclosure is shown. It should be noted that the migration method in the present disclosure is applied to the third AI intelligence.
[0140] S710, generating parameter adjustment information based on at least one of load information of the first database, load information of the second database, network status information, data read and write information, migration data priority information, memory information of the first database, and memory information of the second database;
[0141] S720, sending parameter adjustment information to the second AI intelligence.
[0142] The migration method provided by the embodiments of the present disclosure obtains connection information of the first database and the second database, connects the first database and the second database according to the connection information, determines metadata information of the first database and the second database, generates a migration map according to the metadata information and a preset mapping generation algorithm, and sends the migration map to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database, thereby improving the efficiency of data migration.
[0143] Based on the same inventive concept, the present disclosure also provides a migration device, such as the following embodiment. Since the principle of solving the problem in the device embodiment is similar to that in the above method embodiment, the implementation of the device embodiment can refer to the implementation of the above method embodiment, and the repeated parts will not be repeated.
[0144] Figure 8 A schematic diagram of a migration device in an embodiment of the present disclosure is shown. It should be noted that the migration device in the present disclosure is applied to the first AI intelligence.
[0145] like Figure 8 As shown, the migration device 800 may include:
[0146] A first acquisition module 810 is used to acquire the connection information of the first database and the second database;
[0147] A first determination module 820, configured to connect the first database and the second database according to the connection information, and determine metadata information of the first database and the second database;
[0148] A first generating module 830, configured to generate a migration map according to metadata information and a preset mapping generation algorithm;
[0149] The first sending module 840 is used to send the migration mapping to the second AI intelligence, so that the second AI intelligence completes the data migration between the first database and the second database.
[0150] In some embodiments, the apparatus further comprises:
[0151] The third receiving module is used to receive the migration result information sent by the second AI intelligence when the data migration is completed.
[0152] Based on the same inventive concept, the present disclosure also provides a migration device, such as the following embodiment. Since the principle of solving the problem in the device embodiment is similar to that in the above method embodiment, the implementation of the device embodiment can refer to the implementation of the above method embodiment, and the repeated parts will not be repeated.
[0153] Fig. 9 A schematic diagram of another migration device in an embodiment of the present disclosure is shown. It should be noted that the migration device in the present disclosure is applied to the second AI intelligence.
[0154] like Fig. 9 As shown, the migration device 900 may include:
[0155] A first receiving module 910 is configured to receive a migration mapping sent by a first AI intelligence;
[0156] A second determination module 920 is used to determine a migration strategy based on at least one of the following information: the amount of data to be migrated, threads, and migration cycles;
[0157] The migration module 930 is used to complete data migration between the first database and the second database based on the migration strategy.
[0158] In some embodiments, the apparatus further comprises:
[0159] The third sending module is used to send migration result information to the first AI intelligence after the data migration is completed.
[0160] In some embodiments, the apparatus further comprises:
[0161] The third receiving module is used to receive parameter adjustment information sent by the third AI intelligence, where the parameter adjustment information is generated by the third AI intelligence based on at least one of the load information of the first database, the load information of the second database, the network status information, the data read and write information, the migration data priority information, the memory information of the first database, and the memory information of the second database.
[0162] Fig.10 A schematic diagram of another migration device in an embodiment of the present disclosure is shown. It should be noted that the migration device in the present disclosure is applied to the second AI intelligence.
[0163] like Fig.10 As shown, the migration device 1000 may include:
[0164] The second generating module 1010 is used to generate parameter adjustment information based on at least one of the load information of the first database, the load information of the second database, the network status information, the data read and write information, the migration data priority information, the memory information of the first database, and the memory information of the second database;
[0165] The second sending module 1020 is used to send parameter adjustment information to the second AI intelligence.
[0166] The migration device provided by the embodiment of the present disclosure obtains connection information of the first database and the second database, connects the first database and the second database according to the connection information, determines metadata information of the first database and the second database, generates a migration map according to the metadata information and a preset mapping generation algorithm, and sends the migration map to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database, thereby improving the efficiency of data migration.
[0167] The migration device provided in the embodiment of the present disclosure can be used to execute the identification methods provided in the above-mentioned method embodiments. The implementation principles and technical effects thereof are similar and will not be described in detail here for the sake of brevity.
[0168] Those skilled in the art will appreciate that various aspects of the present disclosure may be implemented as systems, methods or program products. Therefore, various aspects of the present disclosure may be specifically implemented in the following forms, namely: complete hardware implementation, complete software implementation (including firmware, microcode, etc.), or a combination of hardware and software, which may be collectively referred to herein as "circuits", "modules" or "systems".
[0169] Refer to the following Fig.11 1100 according to this embodiment of the present disclosure is described. Fig.11 The electronic device 1100 shown is merely an example and should not bring any limitation to the functions and scope of use of the embodiments of the present disclosure.
[0170] like Fig.11 As shown, the electronic device 1100 is in the form of a general computing device. The components of the electronic device 1100 may include but are not limited to: at least one processing unit 1110, at least one storage unit 1120, and a bus 1130 connecting different system components (including the storage unit 1120 and the processing unit 1110).
[0171] The storage unit stores program codes, which can be executed by the processing unit 1110, so that the processing unit 1110 performs the steps of various exemplary embodiments of the present disclosure described in the above “Exemplary Method” section of this specification. For example, the processing unit 1110 can perform the following steps of the above method embodiment:
[0172] Obtaining connection information of the first database and the second database;
[0173] Connecting the first database and the second database according to the connection information, and determining metadata information of the first database and the second database;
[0174] Generate a migration map according to metadata information and a preset map generation algorithm;
[0175] The migration map is sent to the second AI intelligence, so that the second AI intelligence completes the data migration between the first database and the second database.
[0176] Alternatively, receiving a migration mapping intelligently sent by the first AI;
[0177] Determine the migration strategy based on at least one of the following information: the amount of data to be migrated, threads, and migration cycles;
[0178] Data migration is completed between the first database and the second database based on the migration strategy.
[0179] Alternatively, the parameter adjustment information is generated based on at least one of the load information of the first database, the load information of the second database, the network status information, the data read and write information, the migration data priority information, the memory information of the first database, and the memory information of the second database;
[0180] Send parameter adjustment information to the second AI intelligence.
[0181] The storage unit 1120 may include a readable medium in the form of a volatile storage unit, such as a random access storage unit (RAM) 11201 and / or a cache storage unit 11202 , and may further include a read-only storage unit (ROM) 11203 .
[0182] The storage unit 1120 may also include a program / utility 11204 having a set (at least one) of program modules 11205, such program modules 11205 including but not limited to: an operating system, one or more application programs, other program modules, and program data, each of which or some combination may include an implementation of a network environment.
[0183] Bus 1130 may represent one or more of several types of bus structures, including a memory unit bus or memory unit controller, a peripheral bus, an accelerated graphics port, a processing unit, or a local bus using any of a variety of bus architectures.
[0184] The electronic device 1100 may also process images with one or more external devices 1140 (e.g., keyboards, pointing devices, Bluetooth devices, etc.), may also process images with one or more devices that enable a user to interact with the electronic device 1100, and / or may process images with any device that enables the electronic device 1100 to process images with one or more other computing devices (e.g., routers, modems, etc.). Such image processing may be performed through an input / output (I / O) interface 1150. Furthermore, the electronic device 1100 may also process images with one or more networks (e.g., local area networks (LANs), wide area networks (WANs), and / or public networks, such as the Internet) through a network adapter 1160. As shown, the network adapter 1160 processes images with other modules of the electronic device 1100 through a bus 1130. It should be understood that, although not shown in the figure, other hardware and / or software modules may be used in conjunction with the electronic device 1100, including but not limited to: microcode, device drivers, redundant processing units, external disk drive arrays, RAID systems, tape drives, and data backup storage systems.
[0185] Through the description of the above implementation, it is easy for those skilled in the art to understand that the example implementation described here can be implemented by software, or by software combined with necessary hardware. Therefore, the technical solution according to the implementation of the present disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.) or on a network, including several instructions to enable a computing device (which can be a personal computer, a server, a terminal device, or a network device, etc.) to execute the method according to the implementation of the present disclosure.
[0186] In an exemplary embodiment of the present disclosure, a computer-readable storage medium is also provided, which may be a readable signal medium or a readable storage medium. A program product capable of implementing the above method of the present disclosure is stored thereon. In some possible implementations, various aspects of the present disclosure may also be implemented in the form of a program product, which includes a program code, and when the program product is run on a terminal device, the program code is used to enable the terminal device to execute the steps according to various exemplary implementations of the present disclosure described in the above “Exemplary Method” section of this specification.
[0187] More specific examples of computer-readable storage media in the present disclosure may include, but are not limited to, an electrical connection having one or more conductors, a portable computer disk, a hard disk, a random access memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), optical fiber, a portable compact disk read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing.
[0188] In the present disclosure, a computer readable storage medium may include a data signal propagated in baseband or as part of a carrier wave, wherein a readable program code is carried. Such propagated data signals may take a variety of forms, including but not limited to electromagnetic signals, optical signals, or any suitable combination of the above. A readable signal medium may also be any readable medium other than a readable storage medium, which may send, propagate, or transmit a program for use by or in conjunction with an instruction execution system, apparatus, or device.
[0189] Alternatively, the program code contained on the computer-readable storage medium may be transmitted using any appropriate medium, including but not limited to wireless, wired, optical cable, RF, etc., or any suitable combination of the foregoing.
[0190] In a specific implementation, the program code for performing the operations of the present disclosure may be written in any combination of one or more programming languages, including object-oriented programming languages such as Java, C++, etc., and conventional procedural programming languages such as "C" or similar programming languages. The program code may be executed entirely on the user computing device, partially on the user device, as a separate software package, partially on the user computing device and partially on a remote computing device, or entirely on a remote computing device or server. In the case of a remote computing device, the remote computing device may be connected to the user computing device through any type of network, including a local area network (LAN) or a wide area network (WAN), or may be connected to an external computing device (e.g., using an Internet service provider to connect through the Internet).
[0191] It should be noted that, although several modules or units of the device for action execution are mentioned in the above detailed description, this division is not mandatory. In fact, according to the embodiments of the present disclosure, the features and functions of two or more modules or units described above can be embodied in one module or unit. On the contrary, the features and functions of one module or unit described above can be further divided into multiple modules or units to be embodied.
[0192] In addition, although the steps of the method in the present disclosure are described in a specific order in the drawings, this does not require or imply that the steps must be performed in this specific order, or that all the steps shown must be performed to achieve the desired results. Additionally or alternatively, some steps may be omitted, multiple steps may be combined into one step, and / or one step may be decomposed into multiple steps, etc.
[0193] Through the description of the above implementation, it is easy for those skilled in the art to understand that the example implementation described here can be implemented by software, or by software combined with necessary hardware. Therefore, the technical solution according to the implementation of the present disclosure can be embodied in the form of a software product, which can be stored in a non-volatile storage medium (which can be a CD-ROM, a USB flash drive, a mobile hard disk, etc.) or on a network, including several instructions to enable a computing device (which can be a personal computer, a server, a mobile terminal, or a network device, etc.) to execute the method according to the implementation of the present disclosure.
[0194] Those skilled in the art will readily appreciate other embodiments of the present disclosure after considering the specification and practicing the invention disclosed herein. The present disclosure is intended to cover any variations, uses or adaptations of the present disclosure, which follow the general principles of the present disclosure and include common knowledge or customary techniques in the art that are not disclosed in the present disclosure. The description and examples are intended to be exemplary only, and the true scope and spirit of the present disclosure are indicated by the appended claims.
Claims
1. A migration method, It is characterized in that Applied to the first AI intelligence, including: Obtaining connection information of the first database and the second database; connecting the first database and the second database according to the connection information, and determining metadata information of the first database and the second database; Generate a migration map according to the metadata information and a preset mapping generation algorithm; The migration map is sent to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database.
2. The method according to claim 1, It is characterized in that The method further comprises: When the data migration is completed, migration result information sent by the second AI intelligence is received.
3. A migration method, It is characterized in that Applied to the second AI intelligence, including: Receiving a migration mapping sent by the first AI intelligence; Determine a migration strategy based on at least one of the following information: the amount of data to be migrated, threads, and migration cycles; Data migration is completed between the first database and the second database based on the migration strategy.
4. The migration method according to claim 3, It is characterized in that The method further comprises: After the data migration is completed, the migration result information is sent to the first AI intelligence.
5. The migration method according to claim 3, It is characterized in that The method further comprises: Receive parameter adjustment information sent by the third AI intelligence, where the parameter adjustment information is generated by the third AI intelligence based on at least one of the load information of the first database, the load information of the second database, network status information, data read and write information, migration data priority information, memory information of the first database, and memory information of the second database.
6. The migration method according to claim 5, It is characterized in that The method further comprises: The data migration action is adjusted according to the parameter adjustment information, where the data migration action includes at least one of suspending migration, increasing the amount of data during batch migration, reducing the amount of data during batch migration, and suspending migration and second AI smart wake-up.
7. A migration method, It is characterized in that Applied to the third AI intelligence, including: Generate parameter adjustment information based on at least one of the load information of the first database, the load information of the second database, network status information, data read and write information, migration data priority information, memory information of the first database, and memory information of the second database; The parameter adjustment information is sent to the second AI intelligence.
8. A migration device, It is characterized in that Applied to the first AI intelligence, including: A first acquisition module, used to acquire the connection information of the first database and the second database; A first determining module, configured to connect the first database and the second database according to the connection information, and determine metadata information of the first database and the second database; A first generating module, configured to generate a migration map according to the metadata information and a preset mapping generation algorithm; The first sending module is used to send the migration mapping to the second AI intelligence, so that the second AI intelligence completes data migration between the first database and the second database.
9. A migration device, It is characterized in that Applied to the second AI intelligence, including: A first receiving module, configured to receive a migration mapping sent by a first AI intelligence; A second determination module is used to determine a migration strategy based on at least one of the following information: the amount of data to be migrated, threads, and migration cycles; A migration module is used to complete data migration between the first database and the second database based on the migration strategy.
10. A migration device, It is characterized in that Applied to the third AI intelligence, including: a second generating module, configured to generate parameter adjustment information based on at least one of the load information of the first database, the load information of the second database, network status information, data read and write information, migration data priority information, memory information of the first database, and memory information of the second database; The second sending module is used to send the parameter adjustment information to the second AI intelligence.
11. An electronic device, It is characterized in that include: processor; as well as A memory, configured to store executable instructions of the processor; The processor is configured to execute the migration method according to any one of claims 1 to 7 by executing the executable instructions.
12. A computer-readable storage medium having a computer program stored thereon, It is characterized in that When the computer program is executed by a processor, the migration method according to any one of claims 1 to 7 is implemented.
