CN108572994A - A processing method and server for data migration - Google Patents
A processing method and server for data migration Download PDFInfo
- Publication number
- CN108572994A CN108572994A CN201710149806.0A CN201710149806A CN108572994A CN 108572994 A CN108572994 A CN 108572994A CN 201710149806 A CN201710149806 A CN 201710149806A CN 108572994 A CN108572994 A CN 108572994A
- Authority
- CN
- China
- Prior art keywords
- data
- node
- migrated
- database
- data type
- 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
- 238000013508 migration Methods 0.000 title claims abstract description 75
- 230000005012 migration Effects 0.000 title claims abstract description 75
- 238000003672 processing method Methods 0.000 title claims abstract description 19
- 238000000034 method Methods 0.000 claims abstract description 26
- 238000012545 processing Methods 0.000 claims description 11
- 238000000605 extraction Methods 0.000 claims description 7
- 238000012360 testing method Methods 0.000 claims description 7
- 239000000284 extract Substances 0.000 claims description 4
- 238000012217 deletion Methods 0.000 claims 1
- 230000037430 deletion Effects 0.000 claims 1
- 238000010586 diagram Methods 0.000 description 7
- 230000008859 change Effects 0.000 description 5
- 238000004590 computer program Methods 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 2
- 230000008014 freezing Effects 0.000 description 2
- 238000007710 freezing Methods 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 239000002360 explosive Substances 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000008676 import Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000005192 partition Methods 0.000 description 1
- 238000004088 simulation Methods 0.000 description 1
- 238000010998 test method Methods 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
本发明实施例提供一种数据迁移的处理方法及服务器,所述方法包括:提取第一数据库中的待迁移数据;根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系;根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。所述服务器执行上述方法。本发明实施例提供的数据迁移的处理方法及服务器,能够减少数据迁移人员的工作量,完成不同数据库之间数据的自动迁移,从而提高数据迁移的效率。
Embodiments of the present invention provide a data migration processing method and server, the method comprising: extracting the data to be migrated from the first database; Two rules corresponding to database data types, wherein the node network is mapped with the corresponding relationship between the data type of the data to be migrated and the rules; according to the matched rules, the data to be migrated is migrated to the in the second database. The server executes the above method. The data migration processing method and server provided by the embodiments of the present invention can reduce the workload of data migration personnel and complete automatic data migration between different databases, thereby improving the efficiency of data migration.
Description
技术领域technical field
本发明实施例涉及数据处理技术领域,具体涉及一种数据迁移的处理方法及服务器。The embodiments of the present invention relate to the technical field of data processing, and in particular to a data migration processing method and server.
背景技术Background technique
随着信息化技术的快速发展,企业的数据量均呈现爆炸式增长,数据库的访问量和数据量快速增长对数据库处理能力和计算强度也相应增大,使得数据在不同的数据库系统之间迁移显得尤为重要。With the rapid development of information technology, the data volume of enterprises has shown explosive growth, and the rapid growth of database access and data volume has correspondingly increased the database processing capacity and computing intensity, making data migration between different database systems appears to be particularly important.
MYSQL数据库作为现有ORACLE数据库的替代方案之一,现有技术通过先使用ORACLE中的SQL Developer把ORACLE的数据表中的数据导出,再由经验丰富的迁移人员将ORACLE数据表中的数据类型匹配成MYSQL相对应的数据类型,再使用MYSQL的Work Bench创建数据表、并导入匹配后的数据,从而完成数据从ORACLE数据库到MYSQL数据库的迁移,但是不同数据库的异构数据之间技术定义不同,使得数据库跨平台、跨结构迁移难度高,工作量大,并且依赖于迁移人员的经验和技术水平。MYSQL database is one of the alternatives to the existing ORACLE database. In the existing technology, the data in the ORACLE data table is exported by using SQL Developer in ORACLE, and then the data types in the ORACLE data table are matched by experienced migration personnel. Create the data type corresponding to MYSQL, and then use the Work Bench of MYSQL to create a data table and import the matched data to complete the data migration from the ORACLE database to the MYSQL database. However, the technical definitions of heterogeneous data in different databases are different. It makes database cross-platform and cross-structure migration difficult and heavy, and depends on the experience and technical level of the migration personnel.
因此,如何减少数据迁移人员的工作量,完成不同数据库之间数据的自动迁移,从而提高数据迁移的效率,成为亟须解决的问题。Therefore, how to reduce the workload of data migration personnel and complete the automatic migration of data between different databases, so as to improve the efficiency of data migration, has become an urgent problem to be solved.
发明内容Contents of the invention
针对现有技术存在的问题,本发明实施例提供一种数据迁移的处理方法及服务器。Aiming at the problems existing in the prior art, embodiments of the present invention provide a data migration processing method and server.
一方面,本发明实施例提供一种数据迁移的处理方法,包括:On the one hand, an embodiment of the present invention provides a data migration processing method, including:
提取第一数据库中的待迁移数据;Extracting the data to be migrated in the first database;
根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系;According to the preset node network and the data type of the data to be migrated, match the rules corresponding to the data type of the second database, wherein the node network is mapped with the data type of the data to be migrated and the rule Correspondence between;
根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。Migrate the data to be migrated to the second database according to the matched rules.
另一方面,本发明实施例提供一种数据迁移的处理服务器,包括:On the other hand, an embodiment of the present invention provides a processing server for data migration, including:
提取模块,用于提取第一数据库中的待迁移数据;An extraction module, configured to extract the data to be migrated in the first database;
匹配模块,用于根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系;A matching module, configured to match a rule corresponding to the data type of the second database according to the preset node network and the data type of the data to be migrated, wherein the node network is mapped with the data type of the data to be migrated Correspondence with said rules;
迁移模块,用于根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。The migration module is configured to migrate the data to be migrated to the second database according to the matched rules.
本发明实施例提供的数据迁移的处理方法及服务器,能够减少数据迁移人员的工作量,完成不同数据库之间数据的自动迁移,从而提高数据迁移的效率。The data migration processing method and server provided by the embodiments of the present invention can reduce the workload of data migration personnel and complete automatic data migration between different databases, thereby improving the efficiency of data migration.
附图说明Description of drawings
为了更清楚地说明本发明实施例或现有技术中的技术方案,下面将对实施例或现有技术描述中所需要使用的附图作一简单地介绍,显而易见地,下面描述中的附图是本发明的一些实施例,对于本领域普通技术人员来讲,在不付出创造性劳动的前提下,还可以根据这些附图获得其他的附图。In order to more clearly illustrate the technical solutions in the embodiments of the present invention or the prior art, the following will briefly introduce the drawings that need to be used in the description of the embodiments or the prior art. Obviously, the accompanying drawings in the following description These are some embodiments of the present invention. Those skilled in the art can also obtain other drawings based on these drawings without creative work.
图1为本发明实施例数据迁移的处理方法的流程示意图;1 is a schematic flow diagram of a processing method for data migration according to an embodiment of the present invention;
图2为本发明实施例节点网络的结构示意图;FIG. 2 is a schematic structural diagram of a node network according to an embodiment of the present invention;
图3为本发明实施例数据迁移的处理服务器的结构示意图;3 is a schematic structural diagram of a processing server for data migration according to an embodiment of the present invention;
图4为本发明实施例提供的服务器实体结构示意图。FIG. 4 is a schematic structural diagram of a server entity provided by an embodiment of the present invention.
具体实施方式Detailed ways
为使本发明实施例的目的、技术方案和优点更加清楚,下面将结合本发明实施例中的附图,对本发明实施例中的技术方案进行清楚、完整地描述,显然,所描述的实施例是本发明一部分实施例,而不是全部的实施例。基于本发明中的实施例,本领域普通技术人员在没有作出创造性劳动前提下所获得的所有其他实施例,都属于本发明保护的范围。In order to make the purpose, technical solutions and advantages of the embodiments of the present invention clearer, the technical solutions in the embodiments of the present invention will be clearly and completely described below in conjunction with the drawings in the embodiments of the present invention. Obviously, the described embodiments It is a part of embodiments of the present invention, but not all embodiments. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without creative efforts fall within the protection scope of the present invention.
图1为本发明实施例数据迁移的处理方法的流程示意图,如图1所示,本发明实施例提供的一种数据迁移的处理方法,包括以下步骤:Fig. 1 is a schematic flowchart of a processing method for data migration according to an embodiment of the present invention. As shown in Fig. 1 , a processing method for data migration provided by an embodiment of the present invention includes the following steps:
S1:提取第一数据库中的待迁移数据。S1: Extract data to be migrated from the first database.
具体的,服务器提取第一数据库中的待迁移数据。需要说明的是:第一数据库可以是ORACLE数据库,可以从ORACLE数据库中的元数据列表中提取待迁移数据,元数据可以包括:用户信息,表名信息,表字段信息,表分区信息,索引信息,注释信息,字段类型信息,字段注释信息等。Specifically, the server extracts the data to be migrated from the first database. It should be noted that: the first database can be an ORACLE database, and the data to be migrated can be extracted from the metadata list in the ORACLE database. The metadata can include: user information, table name information, table field information, table partition information, and index information , comment information, field type information, field comment information, etc.
S2:根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系。S2: Match the rules corresponding to the second database data type according to the preset node network and the data type of the data to be migrated, wherein the node network is mapped with the data type of the data to be migrated and the Correspondence between rules.
具体的,服务器根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系。需要说明的是:待迁移数据的数据类型可以是ORACLE数据库的数据类型,数据类型具体可以包括:VARCHAR,CHAR等字符型、还可以包括数值型等。第二数据库可以是MYSQL数据库,ORACLE数据库与MYSQL数据库的数据类型有不同的对应规则,例如:VARCHAR,CHAR是ORACLE数据库中的字符型数据类型,而TEXT是MYSQL数据库中文本型数据类型,二者实质上是相同的数据类型,实质相同的数据类型对应同一规则。而ORACLE数据库中数值型数据类型则认为是与VARCHAR,CHAR等字符型数据类型实质不同,实质不同的多个数据类型对应多个规则,可以认为:匹配出的规则是ORACLE数据库与MYSQL数据库数据类型之间的对应关系。Specifically, the server matches the rules corresponding to the data type of the second database according to the preset node network and the data type of the data to be migrated, wherein the node network is mapped with the data type of the data to be migrated and Correspondence between the rules. It should be noted that: the data type of the data to be migrated can be the data type of the ORACLE database, and the data type can specifically include: VARCHAR, CHAR and other character types, and can also include numerical values, etc. The second database can be a MYSQL database. The data types of the ORACLE database and the MYSQL database have different corresponding rules, for example: VARCHAR, CHAR is the character data type in the ORACLE database, and TEXT is the text data type in the MYSQL database. They are essentially the same data type, and essentially the same data type corresponds to the same rule. However, the numerical data type in the ORACLE database is considered to be substantially different from the character data types such as VARCHAR and CHAR, and multiple data types with substantially different data types correspond to multiple rules. It can be considered that the matching rules are the data types of the ORACLE database and the MYSQL database. Correspondence between.
S3:根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。S3: Migrate the data to be migrated to the second database according to the matched rule.
具体的,服务器根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。需要说明的是:参照上述实施例VARCHAR,CHAR对应于TEXT的规则能够完成字符型数据类型对应数据的迁移,同理根据其他的规则能够完成数值型数据类型等所有数据类型对应数据的迁移。Specifically, the server migrates the data to be migrated to the second database according to the matched rule. It should be noted that: referring to the VARCHAR embodiment above, the rule that CHAR corresponds to TEXT can complete the migration of data corresponding to character data types, and similarly, according to other rules, the migration of data corresponding to all data types such as numeric data types can be completed.
本发明实施例提供的数据迁移的处理方法,能够减少数据迁移人员的工作量,完成不同数据库之间数据的自动迁移,从而提高数据迁移的效率。The data migration processing method provided by the embodiment of the present invention can reduce the workload of data migration personnel, complete automatic data migration between different databases, and thereby improve the efficiency of data migration.
在上述实施例的基础上,所述节点网络包括类节点、规则节点和中间节点,其中:On the basis of the foregoing embodiments, the node network includes class nodes, rule nodes and intermediate nodes, wherein:
每个类节点对应有所述待迁移数据的每个数据类型,每个规则节点对应有每个与第二数据库数据类型相对应的规则,所述中间节点位于所述类节点和所述规则节点之间,所述中间节点绑定有符合同一规则待迁移数据的数据类型的属性信息。Each class node corresponds to each data type of the data to be migrated, each rule node corresponds to each rule corresponding to the second database data type, and the intermediate node is located between the class node and the rule node Between, the intermediate node is bound with the attribute information of the data type of the data to be migrated according to the same rule.
所述每个规则节点和所述每个中间节点一一相连,多个属性信息相同的类节点分别相连于与所述同一规则节点对应的中间节点。Each of the rule nodes is connected to each of the intermediate nodes one by one, and multiple class nodes with the same attribute information are respectively connected to the intermediate nodes corresponding to the same rule node.
具体的,图2为本发明实施例节点网络的结构示意图,如图2所示,服务器中的节点网络可以包括多个类节点、多个规则节点和多个中间节点,其中:Specifically, FIG. 2 is a schematic structural diagram of a node network according to an embodiment of the present invention. As shown in FIG. 2, the node network in the server may include multiple class nodes, multiple regular nodes, and multiple intermediate nodes, wherein:
每个类节点对应有所述待迁移数据的每个数据类型,每个规则节点对应有每个与第二数据库数据类型相对应的规则,由于第一数据库、第二数据库的不同,类节点的个数可以多于、少于、或等于规则节点的个数,所述中间节点位于所述类节点和所述规则节点之间,规则节点的个数可以等于中间节点的个数,所述中间节点绑定有符合同一规则待迁移数据的数据类型的属性信息,属性信息可以参照上述实施例,理解为字符、或数值等,如图2所示的前三个类节点可以认为是具有相同的数据类型的属性信息,它们分别连接于同一规则上的中间节点,再经由该中间节点连接于同一规则的规则节点。Each class node corresponds to each data type of the data to be migrated, and each rule node corresponds to each rule corresponding to the second database data type. Due to the difference between the first database and the second database, the class node The number can be more than, less than, or equal to the number of regular nodes, the intermediate nodes are located between the class nodes and the regular nodes, the number of regular nodes can be equal to the number of intermediate nodes, and the intermediate nodes The node is bound with the attribute information of the data type that conforms to the same rule to be migrated. The attribute information can be understood as characters or numerical values with reference to the above-mentioned embodiments. The first three types of nodes shown in Figure 2 can be considered to have the same The attribute information of the data type, they are respectively connected to the intermediate node on the same rule, and then connected to the rule node of the same rule through the intermediate node.
所述每个规则节点和所述每个中间节点一一相连,多个属性信息相同的类节点分别相连于与所述同一规则节点对应的中间节点。Each of the rule nodes is connected to each of the intermediate nodes one by one, and multiple class nodes with the same attribute information are respectively connected to the intermediate nodes corresponding to the same rule node.
本发明实施例提供的数据迁移的处理方法,通过设置节点网络中的类节点、规则节点和中间节点,进一步优化了数据的自动迁移所使用的匹配规则,从而提高数据迁移的效率。The data migration processing method provided by the embodiment of the present invention further optimizes the matching rules used for automatic data migration by setting class nodes, rule nodes and intermediate nodes in the node network, thereby improving the efficiency of data migration.
在上述实施例的基础上,所述节点网络还包括:On the basis of the foregoing embodiments, the node network further includes:
不经由所述中间节点,与所述每个规则节点一一相连的每个类节点。Each class node is one-to-one connected to each rule node without passing through the intermediate node.
具体的,服务器中的节点网络还包括:不经由所述中间节点,与所述每个规则节点一一相连的每个类节点。如图2所示,后一个类节点可以认为是不具有与其他类节点相同的数据类型的属性信息,因此可以将其单独、一一与规则节点直接相连。Specifically, the node network in the server further includes: each class node connected to each rule node one by one without going through the intermediate node. As shown in Fig. 2, the latter class node can be regarded as attribute information that does not have the same data type as other class nodes, so it can be directly connected to the rule node individually and one by one.
本发明实施例提供的数据迁移的处理方法,进一步通过在节点网络设置直接连接规则节点的类节点,更加优化了数据的自动迁移所使用的匹配规则,从而提高数据迁移的效率。The data migration processing method provided by the embodiment of the present invention further optimizes the matching rules used for automatic data migration by setting up class nodes directly connected to regular nodes in the node network, thereby improving the efficiency of data migration.
在上述实施例的基础上,所述根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,包括:On the basis of the above embodiments, the matching of the rules corresponding to the second database data type according to the preset node network and the data type of the data to be migrated includes:
若判断获知所述待迁移数据的数据类型含有所述中间节点绑定的属性信息,则由所述中间节点匹配与第二数据库数据类型相对应的规则。If it is determined that the data type of the data to be migrated contains the attribute information bound by the intermediate node, then the intermediate node matches the rule corresponding to the second database data type.
具体的,服务器若判断获知所述待迁移数据的数据类型含有所述中间节点绑定的属性信息,则由所述中间节点匹配与第二数据库数据类型相对应的规则。举例说明如下:假如待迁移数据的数据类型为VARCHAR和CHAR,其属性信息为字符型,服务器匹配到数据类型为VARCHAR和CHAR,且属性信息为字符型对应的一个中间节点,由该一个中间节点匹配到MYSQL数据库中的TEXT数据类型。它们之间映射的对应关系就是ORACLE数据库的数据类型与MYSQL数据库的数据类型相对应的规则。Specifically, if the server determines that the data type of the data to be migrated contains attribute information bound to the intermediate node, the intermediate node matches the rule corresponding to the second database data type. An example is as follows: If the data type of the data to be migrated is VARCHAR and CHAR, and its attribute information is character type, and the server matches an intermediate node whose data type is VARCHAR and CHAR, and whose attribute information is character type, the intermediate node Matches to the TEXT data type in the MYSQL database. The corresponding relationship between them is the rule that the data type of the ORACLE database corresponds to the data type of the MYSQL database.
或,or,
若判断获知所述待迁移数据的数据类型不含有所述中间节点绑定的属性信息,则直接由所述待迁移数据的数据类型对应的类节点匹配与第二数据库数据类型相对应的规则。If it is determined that the data type of the data to be migrated does not contain the attribute information bound to the intermediate node, the class node corresponding to the data type of the data to be migrated is directly matched with the rule corresponding to the second database data type.
具体的,服务器若判断获知所述待迁移数据的数据类型不含有所述中间节点绑定的属性信息,则直接由所述待迁移数据的数据类型对应的类节点匹配与第二数据库数据类型相对应的规则。举例说明如下:假如待迁移数据的数据类型为X,其属性信息为A,节点网络所有的中间节点都没有绑定有A属性信息,MYSQL数据库中与数据类型为X对应的数据类型为Y,则直接由X对应的类节点匹配与MYSQL数据库数据类型Y对应的规则。Specifically, if the server determines that the data type of the data to be migrated does not contain the attribute information bound to the intermediate node, it will directly match the class node corresponding to the data type of the data to be migrated with the data type of the second database. corresponding rules. An example is as follows: If the data type of the data to be migrated is X, and its attribute information is A, all intermediate nodes in the node network are not bound with A attribute information, and the data type corresponding to the data type X in the MYSQL database is Y, Then the class node corresponding to X directly matches the rule corresponding to the MYSQL database data type Y.
本发明实施例提供的数据迁移的处理方法,通过由中间节点间接匹配或由类节点直接匹配第二数据库数据类型相对应的规则,进一步能够减少数据迁移人员的工作量,完成不同数据库之间数据的自动迁移,从而提高数据迁移的效率。The data migration processing method provided by the embodiment of the present invention can further reduce the workload of data migration personnel and complete data migration between different databases by indirect matching of intermediate nodes or direct matching of rules corresponding to the second database data type by class nodes. Automatic migration, thereby improving the efficiency of data migration.
在上述实施例的基础上,所述方法还包括:On the basis of the foregoing embodiments, the method further includes:
根据所述第一数据库中待迁移数据的数据类型的变化,更新所述节点网络。The node network is updated according to the change of the data type of the data to be migrated in the first database.
具体的,服务器根据所述第一数据库中待迁移数据的数据类型的变化,更新所述节点网络。需要说明的是:通常情况下第一数据库中待迁移数据的数据类型的变化是由第一数据库的版本升级而产生的,因此要也将节点网络作相应的同步更新。Specifically, the server updates the node network according to the change of the data type of the data to be migrated in the first database. It should be noted that: usually, the change of the data type of the data to be migrated in the first database is caused by the version upgrade of the first database, so the node network should also be correspondingly updated synchronously.
本发明实施例提供的数据迁移的处理方法,通过不断地更新节点网络,优化了数据的自动迁移所使用的匹配规则,从而提高数据迁移的效率。The data migration processing method provided by the embodiment of the present invention optimizes the matching rules used for automatic data migration by continuously updating the node network, thereby improving the efficiency of data migration.
在上述实施例的基础上,所述根据所述第一数据库中待迁移数据的数据类型的变化,更新所述节点网络,包括:On the basis of the above embodiments, updating the node network according to the change of the data type of the data to be migrated in the first database includes:
遍历所有变化后的所述第一数据库中的待迁移数据,对于新增的数据类型,若所述新增的数据类型的属性信息与所述中间节点绑定的属性信息相关联,则新增针对所述新增的数据类型的类节点,并将新增的类节点与相关联的中间节点一一相连。Traversing all the changed data to be migrated in the first database, for the newly added data type, if the attribute information of the newly added data type is associated with the attribute information bound to the intermediate node, then add For the class node of the newly added data type, connect the newly added class node with the associated intermediate nodes one by one.
具体的,服务器遍历所有变化后的所述第一数据库中的待迁移数据,对于新增的数据类型,若判断获知所述新增的数据类型的属性信息与所述中间节点绑定的属性信息相关联,则新增针对所述新增的数据类型的类节点,并将新增的类节点与相关联的中间节点一一相连。需要说明的是:服务器遍历所有的ORACLE数据库版本升级后的待迁移数据,对于待迁移数据中新增的数据类型,判断新增的数据类型的属性信息是否有中间节点绑定的属性信息相关联,继续参照上述实施例的举例说明:ORACLE数据库版本升级以前的其中一个数据类型为VARCHAR、升级后的变更为VARCHAR3,中间节点中已经绑定的数据信息VARCHAR的属性信息为字符型,而VARCHAR3也是字符型,则可以认为VARCHAR与VARCHAR3相关联,即:属性信息都属于字符型。增加该VARCHAR3对应的类节点,并将该新增的类节点与已经绑定有数据类型为VARCHAR、属性信息为字符型的中间节点相连。Specifically, the server traverses all the changed data to be migrated in the first database. For the newly added data type, if it is determined that the attribute information of the newly added data type is bound to the attribute information of the intermediate node Associating, adding a class node for the added data type, and connecting the added class node with associated intermediate nodes one by one. It should be noted that: the server traverses all the data to be migrated after the Oracle database version upgrade, and for the newly added data type in the data to be migrated, it determines whether the attribute information of the newly added data type is associated with the attribute information bound by the intermediate node , continue to refer to the example of the above embodiment: one of the data types before the ORACLE database version upgrade is VARCHAR, and after the upgrade, it is changed to VARCHAR3, and the attribute information of the bound data information VARCHAR in the intermediate node is character type, and VARCHAR3 is also character type, it can be considered that VARCHAR is associated with VARCHAR3, that is, attribute information is all character type. The class node corresponding to the VARCHAR3 is added, and the newly added class node is connected to an intermediate node already bound with a data type of VARCHAR and attribute information of character type.
测试所述新增的类节点、所述中间节点、以及相应的规则节点是否连接成功。Test whether the newly added class node, the intermediate node, and the corresponding rule node are successfully connected.
具体的,服务器测试所述新增的类节点、所述中间节点、以及相应的规则节点是否连接成功。需要说明的是:测试方法可以是通过在新增的类节点、中间节点、以及相应的规则节点插入模拟用的数据,进而测试出连接是否成功。Specifically, the server tests whether the newly added class node, the intermediate node, and the corresponding rule node are successfully connected. It should be noted that the test method may be to insert simulation data into newly added class nodes, intermediate nodes, and corresponding rule nodes, and then test whether the connection is successful.
若连接成功,则激活所述新增的类节点、所述中间节点、以及相应的规则节点。If the connection is successful, activate the newly added class node, the intermediate node, and the corresponding rule node.
具体的,服务器若判断获知连接成功,则激活所述新增的类节点、所述中间节点、以及相应的规则节点。需要说明的是:激活后的新增的类节点、中间节点、以及相应的规则节点的对应的更新后的节点网络可以用于ORACLE数据库版本升级以后的数据迁移。Specifically, if the server determines that the connection is successful, it activates the newly added class node, the intermediate node, and the corresponding rule node. It should be noted that the activated new class nodes, intermediate nodes, and corresponding updated node networks of the corresponding rule nodes can be used for data migration after the ORACLE database version is upgraded.
或,or,
若所述新增的数据类型的属性信息与所述中间节点绑定的属性信息不相关联,则新增针对所述新增的数据类型的类节点,并重新设置与所述新增的数据类型相匹配的、与第二数据库数据类型相对应的新规则,并将新增的类节点与新规则对应的新增规则节点一一相连。If the attribute information of the newly added data type is not associated with the attribute information bound to the intermediate node, then add a class node for the newly added data type, and reset the A new rule whose type is matched and corresponding to the data type of the second database is connected, and the newly added class node is connected with the newly added rule node corresponding to the new rule one by one.
具体的,服务器若判断获知所述新增的数据类型的属性信息与所述中间节点绑定的属性信息不相关联,则新增针对所述新增的数据类型的类节点,并重新设置与所述新增的数据类型相匹配的、与第二数据库数据类型相对应的新规则,并将新增的类节点与新规则对应的新增规则节点一一相连。需要说明的是:服务器遍历所有的ORACLE数据库版本升级后的待迁移数据,对于待迁移数据中新增的数据类型,判断新增的数据类型的属性信息没有中间节点绑定的属性信息相关联,则可以认为ORACLE数据库版本升级后增加了原节点网络没有的新的数据类型,则不仅需要为该新的数据类型新增相应的类节点,还要重新设置新增的数据类型相匹配的、与第二数据库数据类型相对应的新规则,新规则的重新设置可以由相关人员写入、并存储于节点网络中,并将新增的类节点与新规则对应的新增规则节点一一相连。Specifically, if the server determines that the attribute information of the newly added data type is not associated with the attribute information bound to the intermediate node, it adds a class node for the newly added data type, and resets the The newly added data type matches the new rule corresponding to the second database data type, and connects the added class node to the added rule node corresponding to the new rule one by one. It should be noted that: the server traverses all the data to be migrated after the version upgrade of the ORACLE database. For the newly added data types in the data to be migrated, it is determined that the attribute information of the newly added data type is not associated with the attribute information bound by the intermediate node. Then it can be considered that after the upgrade of the ORACLE database version, a new data type that is not available in the original node network is added, and it is not only necessary to add a corresponding class node for the new data type, but also to reset the newly added data type to match the The new rules corresponding to the data type of the second database, and the reset of the new rules can be written by relevant personnel and stored in the node network, and the newly added class nodes are connected to the newly added rule nodes corresponding to the new rules one by one.
测试所述新增的类节点、以及相应的新增规则节点是否连接成功。Test whether the newly added class node and the corresponding newly added rule node are successfully connected.
具体的,服务器测试所述新增的类节点、以及相应的新增规则节点是否连接成功。可参照上述实施例,不再赘述。Specifically, the server tests whether the newly added class node and the corresponding newly added rule node are connected successfully. Reference may be made to the foregoing embodiments, and details are not repeated here.
若连接成功,则激活所述新增的类节点、以及相应的新增规则节点。If the connection is successful, the newly added class node and the corresponding newly added rule node are activated.
具体的,服务器若判断获知连接成功,则激活所述新增的类节点、以及相应的新增规则节点。可参照上述实施例,不再赘述。Specifically, if the server determines that the connection is successful, it activates the newly added class node and the corresponding newly added rule node. Reference may be made to the foregoing embodiments, and details are not repeated here.
本发明实施例提供的数据迁移的处理方法,具体地针对新增的数据类型优化了数据的自动迁移所使用的匹配规则,从而提高数据迁移的效率。The data migration processing method provided by the embodiment of the present invention specifically optimizes the matching rules used for automatic data migration for newly added data types, thereby improving the efficiency of data migration.
在上述实施例的基础上,所所述根据所述第一数据库中待迁移数据的数据类型的变化,更新所述节点网络,包括:On the basis of the above embodiments, the updating of the node network according to the change of the data type of the data to be migrated in the first database includes:
遍历所有变化后的所述第一数据库中的待迁移数据,对于已被删除的数据类型,若所述已被删除的数据类型的属性信息属于原所述中间节点绑定的属性信息,则冻结所述已被删除的数据类型对应的类节点。Traversing all the changed data to be migrated in the first database, for the deleted data type, if the attribute information of the deleted data type belongs to the original attribute information bound by the intermediate node, freeze The class node corresponding to the deleted data type.
具体的,服务器遍历所有变化后的所述第一数据库中的待迁移数据,对于已被删除的数据类型,若判断获知所述已被删除的数据类型的属性信息属于原所述中间节点绑定的属性信息,则冻结所述已被删除的数据类型对应的类节点。需要说明的是:服务器遍历所有的ORACLE数据库版本升级后的待迁移数据,如果在节点网络中存在没有在找到ORACLE数据库版本升级后的待迁移数据对应的数据类型对应的类节点,对于该类节点对应的数据类型,则可以认为已被删除,如果已被删除的数据类型的属性信息属于原所述中间节点绑定的属性信息,即:已被删除的数据类型原来连接有中间节点,则冻结所述已被删除的数据类型对应的类节点、但保留该中间节点。Specifically, the server traverses all the changed data to be migrated in the first database. For the deleted data type, if it is determined that the attribute information of the deleted data type belongs to the original intermediate node binding attribute information, freeze the class node corresponding to the deleted data type. What needs to be explained is: the server traverses all the data to be migrated after the upgrade of the ORACLE database version. The corresponding data type can be considered to have been deleted. If the attribute information of the deleted data type belongs to the attribute information bound by the original intermediate node, that is: the deleted data type was originally connected to the intermediate node, it will be frozen The class node corresponding to the deleted data type, but keep the intermediate node.
或,or,
若所述已被删除的数据类型的属性信息不属于原所述中间节点绑定的属性信息,则冻结所述已被删除的数据类型对应的类节点与相应的所述规则节点。If the attribute information of the deleted data type does not belong to the original attribute information bound to the intermediate node, freezing the class node corresponding to the deleted data type and the corresponding rule node.
具体的,服务器若判断获知所述已被删除的数据类型的属性信息不属于原所述中间节点绑定的属性信息,则冻结所述已被删除的数据类型对应的类节点与相应的所述规则节点。需要说明的是:如果已被删除的数据类型的属性信息不属于原中间节点绑定的属性信息,即:已被删除的数据类型的原来没有连接有中间节点,而是直接连接有对应的规则节点,因此冻结该类节点和相应的规则节点。Specifically, if the server determines that the attribute information of the deleted data type does not belong to the original attribute information bound to the intermediate node, it freezes the class node corresponding to the deleted data type and the corresponding rule node. What needs to be explained is: if the attribute information of the deleted data type does not belong to the attribute information bound by the original intermediate node, that is: the deleted data type was not originally connected to an intermediate node, but directly connected with corresponding rules node, thus freezing that type of node and the corresponding rule node.
本发明实施例提供的数据迁移的处理方法,具体地针对已被删除的数据类型优化了数据的自动迁移所使用的匹配规则,从而提高数据迁移的效率。The data migration processing method provided by the embodiment of the present invention specifically optimizes the matching rules used for automatic data migration for deleted data types, thereby improving the efficiency of data migration.
在上述实施例的基础上,提取第一数据库中的待迁移数据的步骤以前,所述方法还包括:On the basis of the above embodiments, before the step of extracting the data to be migrated in the first database, the method further includes:
获取第一数据库中元数据模块的地址信息、标识符、以及导出数据所使用的协议。The address information, the identifier, and the protocol used for the exported data of the metadata module in the first database are acquired.
具体的,服务器获取第一数据库中元数据模块的地址信息、标识符、以及导出数据所使用的协议。需要说明的是:地址信息可以包括ORACLE数据库所在装置的IP地址和所占用的端口号,标识符可以是SID(安全标识符Security Identifiers,以下简称“SID”),导出数据所使用的协议可以是:OCI(ORACLE调用接口Oracle Call Interface)或ORACLE thin。Specifically, the server acquires the address information, the identifier, and the protocol used for exporting the metadata module in the first database. It should be noted that the address information can include the IP address of the device where the ORACLE database is located and the port number occupied, the identifier can be SID (Security Identifiers, hereinafter referred to as "SID"), and the protocol used for exporting data can be : OCI (ORACLE call interface Oracle Call Interface) or ORACLE thin.
根据所述地址信息、标识符、以及导出数据所使用的协议,建立所述第一数据库与所述第二数据库之间的链接。A link between the first database and the second database is established based on the address information, the identifier, and the protocol used to derive the data.
具体的,服务器根据所述地址信息、标识符、以及导出数据所使用的协议,建立所述第一数据库与所述第二数据库之间的链接。需要说明的是:通过上述实施例说明,建立了ORACLE数据库与MYSQL数据库之间的链接。Specifically, the server establishes a link between the first database and the second database according to the address information, the identifier, and the protocol used for exporting data. It should be noted that: through the description of the above embodiments, a link between the ORACLE database and the MYSQL database is established.
本发明实施例提供的数据迁移的处理方法,通过最先建立第一数据库与第二数据库之间的链接,保证了数据的自动迁移的正常进行。The data migration processing method provided by the embodiment of the present invention ensures normal progress of automatic data migration by first establishing a link between the first database and the second database.
图3为本发明实施例数据迁移的处理服务器的结构示意图,如图3所示,本发明实施例提供了一种数据迁移的处理服务器,包括提取模块1、匹配模块2和迁移模块3,其中:Fig. 3 is a schematic structural diagram of a processing server for data migration according to an embodiment of the present invention. As shown in Fig. 3 , an embodiment of the present invention provides a processing server for data migration, including an extraction module 1, a matching module 2 and a migration module 3, wherein :
提取模块1用于提取第一数据库中的待迁移数据,匹配模块2用于根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系,迁移模块3用于根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。The extraction module 1 is used to extract the data to be migrated in the first database, and the matching module 2 is used to match the rules corresponding to the data type of the second database according to the preset node network and the data type of the data to be migrated, wherein , the node network is mapped with the corresponding relationship between the data type of the data to be migrated and the rules, and the migration module 3 is used to migrate the data to be migrated to the second database according to the matched rules .
具体的,提取模块1用于提取第一数据库中的待迁移数据,提取模块1将待迁移数据发送给匹配模块2,匹配模块2用于根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系,匹配模块2将匹配后的规则发送给迁移模块3,迁移模块3用于根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。Specifically, the extraction module 1 is used to extract the data to be migrated in the first database, the extraction module 1 sends the data to be migrated to the matching module 2, and the matching module 2 is used to data type, matching a rule corresponding to the second database data type, wherein, the node network is mapped with the corresponding relationship between the data type of the data to be migrated and the rule, and the matching module 2 sends the matched rule For the migration module 3, the migration module 3 is configured to migrate the data to be migrated to the second database according to the matched rules.
本发明实施例提供的数据迁移的处理服务器,能够减少数据迁移人员的工作量,完成不同数据库之间数据的自动迁移,从而提高数据迁移的效率。The data migration processing server provided by the embodiment of the present invention can reduce the workload of data migration personnel and complete automatic data migration between different databases, thereby improving the efficiency of data migration.
在上述实施例的基础上,所述匹配模块2具体用于:On the basis of the foregoing embodiments, the matching module 2 is specifically used for:
若判断获知所述待迁移数据的数据类型含有所述中间节点绑定的属性信息,则由所述中间节点匹配与第二数据库数据类型相对应的规则;或,若判断获知所述待迁移数据的数据类型不含有所述中间节点绑定的属性信息,则直接由所述待迁移数据的数据类型对应的类节点匹配与第二数据库数据类型相对应的规则。If it is determined that the data type of the data to be migrated contains the attribute information bound by the intermediate node, then the intermediate node matches the rule corresponding to the data type of the second database; or, if it is determined that the data to be migrated is known. If the data type does not contain the attribute information bound to the intermediate node, then the class node corresponding to the data type of the data to be migrated directly matches the rule corresponding to the second database data type.
具体的,所述匹配模块2具体用于:若判断获知所述待迁移数据的数据类型含有所述中间节点绑定的属性信息,则由所述中间节点匹配与第二数据库数据类型相对应的规则;或,若判断获知所述待迁移数据的数据类型不含有所述中间节点绑定的属性信息,则直接由所述待迁移数据的数据类型对应的类节点匹配与第二数据库数据类型相对应的规则。Specifically, the matching module 2 is specifically configured to: if it is determined that the data type of the data to be migrated contains the attribute information bound by the intermediate node, then the intermediate node matches the data type corresponding to the second database data type. or, if it is judged that the data type of the data to be migrated does not contain the attribute information bound to the intermediate node, then the class node corresponding to the data type of the data to be migrated is directly matched with the second database data type corresponding rules.
本发明实施例提供的数据迁移的处理服务器,通过由中间节点间接匹配或由类节点直接匹配第二数据库数据类型相对应的规则,进一步能够减少数据迁移人员的工作量,完成不同数据库之间数据的自动迁移,从而提高数据迁移的效率。The data migration processing server provided by the embodiment of the present invention can further reduce the workload of data migration personnel and complete the data transfer between different databases through indirect matching by intermediate nodes or direct matching by class nodes to the rules corresponding to the data types of the second database. Automatic migration, thereby improving the efficiency of data migration.
本发明实施例提供的数据迁移的处理服务器具体可以用于执行上述各方法实施例的处理流程,其功能在此不再赘述,可以参照上述方法实施例的详细描述。The data migration processing server provided by the embodiments of the present invention can be specifically used to execute the processing procedures of the foregoing method embodiments, and its functions will not be described in detail here, and reference can be made to the detailed description of the foregoing method embodiments.
图4为本发明实施例提供的服务器实体结构示意图,如图4所示,所述服务器包括:处理器(processor)401、存储器(memory)402和总线403;FIG. 4 is a schematic structural diagram of a server entity provided by an embodiment of the present invention. As shown in FIG. 4 , the server includes: a processor (processor) 401, a memory (memory) 402, and a bus 403;
其中,所述处理器401、存储器402通过总线403完成相互间的通信;Wherein, the processor 401 and the memory 402 complete mutual communication through the bus 403;
所述处理器401用于调用所述存储器402中的程序指令,以执行上述各方法实施例所提供的方法,例如包括:提取第一数据库中的待迁移数据;根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系;根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。The processor 401 is used to call the program instructions in the memory 402 to execute the methods provided by the above method embodiments, for example, including: extracting the data to be migrated in the first database; according to the preset node network, and The data type of the data to be migrated is matched with a rule corresponding to the data type of the second database, wherein the node network is mapped with a corresponding relationship between the data type of the data to be migrated and the rule; According to the rule, the data to be migrated is migrated to the second database.
本实施例公开一种计算机程序产品,所述计算机程序产品包括存储在非暂态计算机可读存储介质上的计算机程序,所述计算机程序包括程序指令,当所述程序指令被计算机执行时,计算机能够执行上述各方法实施例所提供的方法,例如包括:提取第一数据库中的待迁移数据;根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系;根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。This embodiment discloses a computer program product, the computer program product includes a computer program stored on a non-transitory computer-readable storage medium, the computer program includes program instructions, and when the program instructions are executed by the computer, the computer The methods provided by the above method embodiments can be executed, for example, including: extracting the data to be migrated in the first database; according to the preset node network and the data type of the data to be migrated, matching A corresponding rule, wherein the node network is mapped with a corresponding relationship between the data type of the data to be migrated and the rule; according to the matched rule, the data to be migrated is migrated to the second database .
本实施例提供一种非暂态计算机可读存储介质,所述非暂态计算机可读存储介质存储计算机指令,所述计算机指令使所述计算机执行上述各方法实施例所提供的方法,例如包括:提取第一数据库中的待迁移数据;根据预先设置的节点网络、以及所述待迁移数据的数据类型,匹配与第二数据库数据类型相对应的规则,其中,所述节点网络映射有所述待迁移数据的数据类型与所述规则之间的对应关系;根据匹配后的规则,将所述待迁移数据迁移至所述第二数据库中。This embodiment provides a non-transitory computer-readable storage medium, the non-transitory computer-readable storage medium stores computer instructions, and the computer instructions cause the computer to execute the methods provided in the above method embodiments, for example, including : extract the data to be migrated in the first database; match the rules corresponding to the data type of the second database according to the preset node network and the data type of the data to be migrated, wherein the node network is mapped with the The corresponding relationship between the data type of the data to be migrated and the rule; according to the matched rule, the data to be migrated is migrated to the second database.
本领域普通技术人员可以理解:实现上述方法实施例的全部或部分步骤可以通过程序指令相关的硬件来完成,前述的程序可以存储于一计算机可读取存储介质中,该程序在执行时,执行包括上述方法实施例的步骤;而前述的存储介质包括:ROM、RAM、磁碟或者光盘等各种可以存储程序代码的介质。Those of ordinary skill in the art can understand that all or part of the steps for realizing the above-mentioned method embodiments can be completed by hardware related to program instructions, and the aforementioned program can be stored in a computer-readable storage medium. When the program is executed, the It includes the steps of the above method embodiments; and the aforementioned storage medium includes: ROM, RAM, magnetic disk or optical disk and other various media that can store program codes.
以上所描述的服务器等实施例仅仅是示意性的,其中所述作为分离部件说明的单元可以是或者也可以不是物理上分开的,作为单元显示的部件可以是或者也可以不是物理单元,即可以位于一个地方,或者也可以分布到多个网络单元上。可以根据实际的需要选择其中的部分或者全部模块来实现本实施例方案的目的。本领域普通技术人员在不付出创造性的劳动的情况下,即可以理解并实施。The server and other embodiments described above are only illustrative, and the units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, Located in one place, or can be distributed to multiple network elements. Part or all of the modules can be selected according to actual needs to achieve the purpose of the solution of this embodiment. It can be understood and implemented by those skilled in the art without any creative efforts.
通过以上的实施方式的描述,本领域的技术人员可以清楚地了解到各实施方式可借助软件加必需的通用硬件平台的方式来实现,当然也可以通过硬件。基于这样的理解,上述技术方案本质上或者说对现有技术做出贡献的部分可以以软件产品的形式体现出来,该计算机软件产品可以存储在计算机可读存储介质中,如ROM/RAM、磁碟、光盘等,包括若干指令用以使得一台计算机设备(可以是个人计算机,服务器,或者网络设备等)执行各个实施例或者实施例的某些部分所述的方法。Through the above description of the implementations, those skilled in the art can clearly understand that each implementation can be implemented by means of software plus a necessary general hardware platform, and of course also by hardware. Based on this understanding, the essence of the above technical solution or the part that contributes to the prior art can be embodied in the form of software products, and the computer software products can be stored in computer-readable storage media, such as ROM/RAM, magnetic discs, optical discs, etc., including several instructions to make a computer device (which may be a personal computer, server, or network device, etc.) execute the methods described in various embodiments or some parts of the embodiments.
最后应说明的是:以上各实施例仅用以说明本发明的实施例的技术方案,而非对其限制;尽管参照前述各实施例对本发明的实施例进行了详细的说明,本领域的普通技术人员应当理解:其依然可以对前述各实施例所记载的技术方案进行修改,或者对其中部分或者全部技术特征进行等同替换;而这些修改或者替换,并不使相应技术方案的本质脱离本发明的实施例各实施例技术方案的范围。Finally, it should be noted that: the above embodiments are only used to illustrate the technical solutions of the embodiments of the present invention, not to limit them; although the embodiments of the present invention have been described in detail with reference to the foregoing embodiments, those skilled in the art The skilled person should understand that: it is still possible to modify the technical solutions described in the foregoing embodiments, or perform equivalent replacements for some or all of the technical features; and these modifications or replacements do not make the essence of the corresponding technical solutions deviate from the present invention The scope of the technical solution of each embodiment of the embodiment.
Claims (10)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710149806.0A CN108572994B (en) | 2017-03-14 | 2017-03-14 | A data migration processing method and server |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710149806.0A CN108572994B (en) | 2017-03-14 | 2017-03-14 | A data migration processing method and server |
Publications (2)
Publication Number | Publication Date |
---|---|
CN108572994A true CN108572994A (en) | 2018-09-25 |
CN108572994B CN108572994B (en) | 2021-05-25 |
Family
ID=63577234
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710149806.0A Active CN108572994B (en) | 2017-03-14 | 2017-03-14 | A data migration processing method and server |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN108572994B (en) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111538772A (en) * | 2020-04-14 | 2020-08-14 | 北京宝兰德软件股份有限公司 | Data exchange processing method and device, electronic equipment and storage medium |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102521387A (en) * | 2011-12-21 | 2012-06-27 | 北京人大金仓信息技术股份有限公司 | Plug-in-based data migration method |
US9361326B2 (en) * | 2008-12-17 | 2016-06-07 | Sap Se | Selectable data migration |
CN106202111A (en) * | 2015-05-06 | 2016-12-07 | 阿里巴巴集团控股有限公司 | The method of calibration of database data and device |
-
2017
- 2017-03-14 CN CN201710149806.0A patent/CN108572994B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US9361326B2 (en) * | 2008-12-17 | 2016-06-07 | Sap Se | Selectable data migration |
CN102521387A (en) * | 2011-12-21 | 2012-06-27 | 北京人大金仓信息技术股份有限公司 | Plug-in-based data migration method |
CN106202111A (en) * | 2015-05-06 | 2016-12-07 | 阿里巴巴集团控股有限公司 | The method of calibration of database data and device |
Non-Patent Citations (1)
Title |
---|
梁吉胜: "数据映射技术在ETL过程中的应用", 《计算机系统应用》 * |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN111538772A (en) * | 2020-04-14 | 2020-08-14 | 北京宝兰德软件股份有限公司 | Data exchange processing method and device, electronic equipment and storage medium |
CN111538772B (en) * | 2020-04-14 | 2023-07-04 | 北京宝兰德软件股份有限公司 | Data exchange processing method and device, electronic equipment and storage medium |
Also Published As
Publication number | Publication date |
---|---|
CN108572994B (en) | 2021-05-25 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN110799960B (en) | System and method for database tenant migration | |
CN109977110B (en) | Data cleaning method, device and equipment | |
CN110543586B (en) | Multi-user identity fusion method, device, equipment and storage medium | |
CN106815218B (en) | Database access method, device and database system | |
EP3564808B1 (en) | Data configuration method and data configuration apparatus | |
CN106503087A (en) | A kind of database middleware for Distributed Data Visits | |
CN108322329A (en) | Network collocating method, device and equipment are issued based on SDN network | |
CN113420026A (en) | Database table structure changing method, device, equipment and storage medium | |
CN105426375A (en) | Relationship network calculation method and apparatus | |
JP2022500724A (en) | Replacing the tenant identifier | |
WO2024002327A1 (en) | Cloud monitoring and analysis method and system | |
CN114442952A (en) | Cold data migration method and device, storage medium and electronic device | |
CN104461929B (en) | Distributed data cache method based on blocker | |
US11151110B2 (en) | Identification of records for post-cloning tenant identifier translation | |
CN117370128A (en) | Cloud monitoring and analyzing method and system | |
CN108572994B (en) | A data migration processing method and server | |
CN103778218B (en) | Cloud computation-based standard information consistency early warning system and method | |
CN104023056B (en) | The method and relevant device updated the data | |
WO2017188929A1 (en) | Method and apparatus for replicating data between storage systems | |
CN116226082A (en) | Database model generation method and device, storage medium and electronic equipment | |
CN108073584B (en) | Data processing method and server | |
CN110222105B (en) | Data summarization processing method and device | |
CN106453441B (en) | A communication preprocessing method and management system | |
KR101919816B1 (en) | Consistency checking in database sharding environment | |
US20190324651A1 (en) | Pool partner based replication |
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 |