CN112434004A - Data migration method and device for heterogeneous system, computer equipment and storage medium - Google Patents
Data migration method and device for heterogeneous system, computer equipment and storage medium Download PDFInfo
- Publication number
- CN112434004A CN112434004A CN202011168319.7A CN202011168319A CN112434004A CN 112434004 A CN112434004 A CN 112434004A CN 202011168319 A CN202011168319 A CN 202011168319A CN 112434004 A CN112434004 A CN 112434004A
- Authority
- CN
- China
- Prior art keywords
- dynamic entity
- grouping
- field
- source system
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000013508 migration Methods 0.000 title claims abstract description 42
- 230000005012 migration Effects 0.000 title claims abstract description 42
- 238000000034 method Methods 0.000 title claims abstract description 41
- 238000003860 storage Methods 0.000 title claims abstract description 17
- 238000013507 mapping Methods 0.000 claims abstract description 78
- 230000001360 synchronised effect Effects 0.000 claims abstract description 38
- 238000004590 computer program Methods 0.000 claims description 12
- 238000010276 construction Methods 0.000 claims description 3
- 230000011218 segmentation Effects 0.000 claims description 2
- 230000005540 biological transmission Effects 0.000 abstract description 2
- 239000000463 material Substances 0.000 description 43
- 238000012545 processing Methods 0.000 description 9
- 238000010586 diagram Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 230000010354 integration Effects 0.000 description 7
- 238000004891 communication Methods 0.000 description 5
- 238000007726 management method Methods 0.000 description 4
- 238000013506 data mapping Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 238000012546 transfer Methods 0.000 description 3
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000011161 development Methods 0.000 description 1
- 230000018109 developmental process Effects 0.000 description 1
- 238000005111 flow chemistry technique Methods 0.000 description 1
- 230000003993 interaction Effects 0.000 description 1
- 239000004973 liquid crystal related substance Substances 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012544 monitoring process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002085 persistent effect Effects 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
- G06F16/214—Database migration support
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Mathematical Physics (AREA)
- Computational Linguistics (AREA)
- Computing Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application relates to a data migration method and device of a heterogeneous system, computer equipment and a storage medium. The method comprises the following steps: acquiring a synchronous instruction of a service form; according to the synchronous instruction, a dynamic entity corresponding to the business form is constructed in a target system; synchronizing the basic data of the service form in the source system to the dynamic entity according to the mapping relation between the dynamic entity and the configuration table of the source system; according to the field mapping relation between the dynamic entity and the source system, synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity; and assigning the grouping internal code into the grouping field information of the dynamic entity according to the mapping relation of the grouping internal code of the field information corresponding to the dynamic entity and the source system. By adopting the method, the quick transmission of the complex field relationship in the heterogeneous system can be realized, so that the efficiency of data migration is effectively improved.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a data migration method and apparatus for a heterogeneous system, a computer device, and a storage medium.
Background
With the development of computer technology and the coming of the 5G era, the appearance of the Internet brings great convenience to modern life, more and more enterprises can process various services on line by using a system service platform, and the service handling efficiency is effectively improved. The business system used in each enterprise may have multiple business systems such as OA office system, business processing system, etc., the business systems used between different enterprises may be very different, and when data synchronization or data migration across the business systems is required, plug-in processing is usually required.
However, in the current data migration method, when data migration is performed for service systems with different structures, a corresponding code needs to be written for each synchronization object, and then the data migration method is processed by a plug-in, and a corresponding code needs to be written each time data synchronization is performed.
Disclosure of Invention
In view of the foregoing, it is desirable to provide a data migration method, apparatus, computer device and storage medium for a heterogeneous system, which can improve data migration efficiency.
A method of data migration for a heterogeneous system, the method comprising:
acquiring a synchronous instruction of a service form;
according to the synchronous instruction, a dynamic entity corresponding to the business form is constructed in a target system;
synchronizing the basic data of the service form in the source system to the dynamic entity according to the mapping relation between the dynamic entity and the configuration table of the source system;
according to the field mapping relation between the dynamic entity and the source system, synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity;
and assigning the grouping internal code into the grouping field information of the dynamic entity according to the mapping relation of the grouping internal code of the field information corresponding to the dynamic entity and the source system.
In one embodiment, the dynamic entity comprises attribute information and field information;
the constructing a dynamic entity corresponding to the business form in the target system according to the synchronization instruction comprises:
according to the synchronous instruction, constructing attribute information of a dynamic entity corresponding to the business form in a target system;
and according to the synchronous instruction, constructing field information of the dynamic entity corresponding to the business form in the target system.
In one embodiment, the synchronization instruction of the service form carries attribute information of the service form; the attribute information of the business form comprises an identifier, a field name and an element type of the business form;
the constructing, according to the synchronization instruction, attribute information of the dynamic entity corresponding to the service form in the target system includes:
and constructing the identifier, the field name and the element type of the corresponding dynamic entity in the target system according to the identifier, the field name and the element type of the service form.
In one embodiment, the constructing, in the target system, field information of the dynamic entity corresponding to the service form according to the synchronization instruction includes:
the field information includes packet field information;
acquiring packet field information corresponding to the service form;
and taking the grouping field information as grouping field information of the dynamic entity corresponding to the service form.
In one embodiment, the synchronizing the grouping information of the service form of the source system to the grouping field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system includes:
according to the source data type contained in the synchronization instruction, acquiring the grouping information corresponding to the business form from a source system in a table, view or structured query SQL statement mode;
and synchronizing the grouping information into the corresponding segmentation field information of the dynamic entity.
In one embodiment, the synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system includes:
acquiring a field mapping relation between a dynamic entity corresponding to a user updating operation and a source system;
and synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relation between the dynamic entity and the source system.
A data migration apparatus of a heterogeneous system, the apparatus comprising:
the acquisition module is used for acquiring a synchronous instruction of the business form;
the construction module is used for constructing a dynamic entity corresponding to the business form in a target system according to the synchronous instruction;
the synchronization module is used for synchronizing the basic data of the service form in the source system into the dynamic entity according to the mapping relation of the configuration table of the dynamic entity and the source system, and synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relation of the dynamic entity and the source system;
and the assignment module is used for assigning the grouping internal code to the grouping field information of the dynamic entity according to the mapping relation of the grouping internal code of the field information corresponding to the dynamic entity and the source system.
A computer device comprising a memory and a processor, the memory storing a computer program, the processor implementing the following steps when executing the computer program:
acquiring a synchronous instruction of a service form;
according to the synchronous instruction, a dynamic entity corresponding to the business form is constructed in a target system;
synchronizing the basic data of the service form in the source system to the dynamic entity according to the mapping relation between the dynamic entity and the configuration table of the source system;
according to the field mapping relation between the dynamic entity and the source system, synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity;
and assigning the grouping internal code into the grouping field information of the dynamic entity according to the mapping relation of the grouping internal code of the field information corresponding to the dynamic entity and the source system.
A computer-readable storage medium, on which a computer program is stored which, when executed by a processor, carries out the steps of:
acquiring a synchronous instruction of a service form;
according to the synchronous instruction, a dynamic entity corresponding to the business form is constructed in a target system;
synchronizing the basic data of the service form in the source system to the dynamic entity according to the mapping relation between the dynamic entity and the configuration table of the source system;
according to the field mapping relation between the dynamic entity and the source system, synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity;
and assigning the grouping internal code into the grouping field information of the dynamic entity according to the mapping relation of the grouping internal code of the field information corresponding to the dynamic entity and the source system.
According to the data migration method, the data migration device, the computer equipment and the storage medium of the heterogeneous system, the dynamic entity corresponding to the business form is constructed in the target system according to the synchronous instruction by acquiring the synchronous instruction of the business form. And according to the mapping relation of the grouping internal codes of the field information corresponding to the dynamic entity and the source system, assigning the grouping internal codes into the grouping field information of the dynamic entity. Therefore, data migration can be automatically carried out during heterogeneous system integration, the complex flow of manual rewriting of plug-in logic code processing is avoided, data migration of complex fields corresponding to a background table during heterogeneous system integration is supported, rapid transfer of complex field relations in the heterogeneous system is achieved, and therefore data migration efficiency is effectively improved.
Drawings
FIG. 1 is a flow diagram illustrating a method for data migration in a heterogeneous system, according to an embodiment;
FIG. 2 is a flowchart illustrating steps of constructing a dynamic entity corresponding to a business form in a target system according to a synchronization instruction in an embodiment;
FIG. 3A is a flowchart illustrating a step of synchronizing grouping information of a service form of a source system to grouping field information corresponding to a dynamic entity according to a field mapping relationship between the dynamic entity and the source system in one embodiment;
FIG. 3B is a diagram illustrating a table mapping relationship interface configured in a business system, according to an embodiment;
FIG. 3C is a diagram illustrating a table field mapping relationship interface configured in a business system, according to an embodiment;
FIG. 3D is a diagram that illustrates an interface presented when synchronizing groupings of items in a business system, in accordance with an embodiment;
FIG. 4 is a block diagram of a data migration apparatus for a heterogeneous system in one embodiment;
FIG. 5 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
In an embodiment, as shown in fig. 1, a data migration method for a heterogeneous system is provided, and this embodiment is illustrated by applying the method to a terminal, it is to be understood that the method may also be applied to a server, and may also be applied to a system including a terminal and a server, and is implemented by interaction between the terminal and the server. In this embodiment, the method includes the steps of:
and 102, acquiring a synchronous instruction of the service form.
Each Enterprise can uniformly manage all resources and information in an Enterprise internal supply chain and an Enterprise external supply chain by adopting a uniform service management information platform, the integration can eliminate various information gaps and information islands caused by division of departments in the Enterprise, for example, effective management of the whole supply chain can be realized by utilizing an Enterprise Resource Planning system, and ERP (Enterprise Resource Planning) is an Enterprise Resource plan, and is an Enterprise information management system which is mainly oriented to the manufacturing industry and performs integrated management of material resources, fund resources and information resources. The business systems used in the enterprises may include a plurality of business systems such as OA office systems, business processing systems, etc., and the business systems used in different enterprises may be very different (heterogeneous systems). A user can log in a service system of a specific scene by inputting a user name and a password in a PC terminal or a mobile phone Application program or a browser webpage, and the user can initiate a synchronization instruction of specific service data through an app (Application) or a web browser. Specifically, the terminal can acquire a synchronous instruction of a business form initiated by different users, wherein the business form refers to a business document corresponding to relevant data processed in a business flow process, and the method is mainly used for meeting the electronic and data processing requirements of a large number of personalized paper forms in an enterprise and public institution in the flow processing and approval process, and monitoring the flow of the whole document form process through the whole workflow. Generally, service circulation needs a service form to express an actual service, so that the service meaning needs to be realized by integrating with the form, and the integration with the form generally includes automatic acquisition, storage and modification of form data, authority control of a form field, maintenance of process related data and binding of a process link form. The business form, i.e. the business data, may include basic data, auxiliary data, business documents, etc., such as materials, departments, purchase orders, etc. The business form data may include basic data, supplementary data, and specific data corresponding to the business form, such as pencil, pen, etc. in the material. The business form groupings may include groupings of base material, ancillary material, business documents, such as groupings of materials.
And 104, constructing a dynamic entity corresponding to the business form in the target system according to the synchronous instruction.
After the terminal obtains the synchronization instruction of the service form, the terminal can construct a dynamic entity corresponding to the service form in the target system according to the synchronization instruction. The synchronization instruction is an instruction for performing data synchronization. The dynamic entity is to construct a corresponding entity class according to different dynamically received instructions, that is, to map the format of a data table or other persistent data into the corresponding entity class. Specifically, the terminal may construct a dynamic entity corresponding to the service form in the target system according to the relevant information of the service form carried in the synchronization instruction. For example, the terminal may load fields such as group fields, multi-language fields, etc. in the service form into a custom entity, and convert the fields into entities for processing in a manner of generating dynamic entities in the target system for complex fields of the corresponding background table such as group fields, multi-language fields, multi-choice basic data fields, etc. in the service form.
And step 106, synchronizing the basic data of the service form in the source system to the dynamic entity according to the mapping relation between the dynamic entity and the configuration table of the source system.
After the terminal constructs a dynamic entity corresponding to the service form in the target system according to the synchronization instruction, the terminal can synchronize the basic data of the service form in the source system to the dynamic entity according to the mapping relation between the dynamic entity and the configuration table of the source system. The configuration table refers to a mapping relationship between data tables configured in advance according to business operations. For example, mapping information such as source system connection information, source data type information, source system material information, source basic material description information, and basic material entity information corresponding to data to be migrated may be configured in the target system in advance, that is, a user may configure a data source corresponding to a dynamic entity of the target system in a customized manner in advance. Specifically, the terminal may synchronize the basic data of the service form in the source system to the dynamic entity according to the table mapping relationship between the dynamic entity and the source system. The basic data may include form attribute information, such as identification information, element type, and field name.
And step 108, synchronizing the grouping information of the service form of the source system to the grouping field information corresponding to the dynamic entity according to the field mapping relation between the dynamic entity and the source system.
After the terminal synchronizes the basic data of the service form in the source system to the dynamic entity according to the mapping relationship of the configuration table of the dynamic entity and the source system, the terminal can synchronize the grouping information of the service form of the source system to the grouping field information corresponding to the dynamic entity according to the field mapping relationship of the dynamic entity and the source system. The grouping information refers to grouping information of the service data, and may include grouping information of the basic data, the auxiliary data, and the service documents, such as material grouping information. The packet field information may include coding, name and description information, etc. The user can configure the table field mapping relationship in advance, that is, configure the data source field corresponding to the self-defined entity field. For example, information such as a field name of the source system table and a field description of the source system table may be added to the table field mapping configuration information. Specifically, the terminal may obtain the grouping information of the service form from the source system and synchronize the grouping information to the grouping field information corresponding to the dynamic entity according to a pre-configured mapping relationship in a plurality of manners, for example, a table, a view, or a structured query SQL statement manner.
And step 110, assigning the packet internal code to the packet field information of the dynamic entity according to the mapping relation of the packet internal code of the field information corresponding to the dynamic entity and the source system.
After the terminal synchronizes the grouping information of the service form of the source system to the grouping field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system, the terminal can assign the grouping internal code to the grouping field information of the dynamic entity according to the mapping relationship of the grouping internal code of the field information corresponding to the dynamic entity and the source system. The intra-packet code refers to a field value corresponding to each packet field. When the terminal synchronizes data, the terminal synchronizes the source system data to the table corresponding to the user-defined entity, and then assigns the internal code to the field of the corresponding entity. Specifically, the terminal synchronizes basic data of service data in the source system to the target system according to a mapping relation of a configuration table of the dynamic entity and the source system, then synchronizes grouping information of the service data of the source system to a service table corresponding to the dynamic entity of the target system according to a field mapping relation of the dynamic entity and the source system configured in advance, establishes a mapping relation of data corresponding to the dynamic entities of the source system and the target system, namely a mapping relation of grouping internal codes, and assigns a complex field of the service data according to the mapping relation of the grouping internal codes of the field information corresponding to the dynamic entity and the source system, namely assigns the grouping internal codes to grouping field information of the service data.
In this embodiment, a dynamic entity corresponding to the service form is constructed in the target system by obtaining the synchronization instruction of the service form and according to the synchronization instruction. And according to the mapping relation of the grouping internal codes of the field information corresponding to the dynamic entity and the source system, assigning the grouping internal codes into the grouping field information of the dynamic entity. Therefore, data migration can be automatically carried out during heterogeneous system integration, the complex flow of manual rewriting of plug-in logic code processing is avoided, data migration of complex fields corresponding to a background table during heterogeneous system integration is supported, rapid transmission of the complex fields and relationships in the heterogeneous system is achieved, and therefore data migration efficiency is effectively improved.
In one embodiment, as shown in fig. 2, the step of constructing a dynamic entity corresponding to the service form in the target system according to the synchronization instruction includes:
And step 204, constructing field information of the dynamic entity corresponding to the business form in the target system according to the synchronization instruction.
After the terminal obtains the synchronization instruction of the service form, the terminal can construct a dynamic entity corresponding to the service form in the target system according to the synchronization instruction. Specifically, the terminal may construct attribute information of the dynamic entity corresponding to the service form in the target system according to the synchronization instruction, and the terminal may construct field information of the dynamic entity corresponding to the service form in the target system according to the synchronization instruction. The dynamic entity may include attribute information and field information, among others. The attribute information of the entity can comprise information such as identification, table name and name; the field information contained by the entity may include field information such as an encoding field, a name field, a creator field, a creation date field, and the like. The range supported by the dynamic entity includes complex fields in the metadata corresponding to the background table, such as: general packet fields, multi-language fields, multiple choice base data fields, etc. Taking materials in the service data as an example, when the terminal acquires the synchronous instruction of the service form as the material grouping data in the synchronous material form, the terminal constructs the attribute information of the dynamic entity corresponding to the material grouping in the material form in the target system according to the synchronous instruction. Further, the terminal constructs field information of the dynamic entity corresponding to the material grouping in the target system according to the synchronization instruction. For example, the terminal may use a field of the general packet as field information of a dynamic entity corresponding to the material packet. The material information has a corresponding grouping field configuration table, namely material grouping, and when the material grouping adopts the metadata of the general grouping, the terminal can take the configuration table in the material grouping field as a field table corresponding to the dynamic entity. Therefore, the definition, the configuration and the application of the complex field relation can be quickly and conveniently realized, plug-ins do not need to be written for the complex field, only simple configuration is needed, the use threshold of a user is reduced, the migration of the complex field corresponding to the background table in the heterogeneous system is supported, the breadth of migration data is improved, the migration of more field types is covered, the relation transfer of the complex field in the heterogeneous system can be quickly realized, and the efficiency of data migration is effectively improved.
In one embodiment, the step of constructing the attribute information of the dynamic entity corresponding to the service form in the target system according to the synchronization instruction includes:
and constructing the identifier, the field name and the element type of the corresponding dynamic entity in the target system according to the identifier, the field name and the element type of the service form.
The terminal can construct the identifier, the field name and the element type of the corresponding dynamic entity in the target system according to the identifier, the field name and the element type of the service form. For example, the terminal may obtain attribute information such as an identifier, a grouping information storage table, and a name of a material grouping field, and the terminal uses the obtained attribute information such as the identifier, the grouping information storage table, and the name of the material grouping field as attribute information such as an identifier, a table name, and a name of a dynamic entity in a target system corresponding to the material grouping. Therefore, the definition, the configuration and the application of the complex field relation can be quickly and conveniently realized, the writing of plug-ins for the complex field is not needed, and the simple configuration is only needed, so that the use threshold of a user is reduced.
In one embodiment, the step of constructing field information of the dynamic entity corresponding to the business form in the target system according to the synchronization instruction includes:
the field information includes packet field information.
And acquiring the grouping field information corresponding to the service form.
And taking the grouping field information as the grouping field information of the dynamic entity corresponding to the service form.
The terminal can obtain the grouping field information corresponding to the service form, and the terminal takes the grouping field information as the grouping field information of the dynamic entity corresponding to the service form. For example, the terminal may use a field of the general packet as field information of a dynamic entity corresponding to the material packet. The material information has a corresponding grouping field configuration table, namely material grouping, and if the material grouping adopts metadata of a general grouping, the terminal can take the configuration table in the material grouping field as a field table corresponding to the dynamic entity. If the material grouping adopts the non-general grouping metadata, the terminal can take the self-defined background table corresponding to the material grouping field as the field table corresponding to the dynamic entity. Therefore, the definition, the configuration and the application of the complex field relation can be quickly and conveniently realized, plug-ins do not need to be written for the complex field, only simple configuration is needed, the use threshold of a user is reduced, the migration of the complex field corresponding to the background table in the heterogeneous system is supported, the breadth of migration data is improved, the migration of more field types is covered, the relation transfer of the complex field in the heterogeneous system can be quickly realized, and the efficiency of data migration is effectively improved.
In an embodiment, as shown in fig. 3A, the step of synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system includes:
And step 304, synchronizing the packet information into the corresponding segment field information of the dynamic entity.
When the terminal constructs an entity corresponding to the service form in the target system, the terminal dynamically loads fields such as grouping fields, multi-language fields and the like into a corresponding dynamic entity, namely, the content of the dynamic entity added in the target system comprises the following steps: the terminal takes the field name in the source system as the name of the dynamic entity, the terminal takes the field identification in the source system as the identification of the dynamic entity, the terminal takes the background corresponding table (such as a grouping corresponding table) of the field in the source system as the table corresponding to the dynamic entity, and the background table field is taken as the field corresponding to the entity. The user can pre-configure the mapping relationship between the target system entity and the source system. For example, as shown in fig. 3B, a graph is displayed for a table mapping relationship interface configured in a certain business system. When the table of the source system is T _ BD _ materal, the source system type is set as the table, and the source system data is configured as T _ BD _ materal. When the table of the source system is t _ ICItem, the type of the source system is set as a view, and the source system data is configured as t _ ICItem. The configured SQL statement may be PushSQL, select from t ici where not in ('8', '13'), and the source system type is set to custom SQL, and the source system data is configured as PushSQL. The terminal can synchronize the basic data of the service form in the source system to the dynamic entity according to the configured table mapping relationship between the dynamic entity and the source system. Further, after the mapping relationship between the dynamic entity of the target system and the configuration table of the source system is determined, the field mapping relationship between the dynamic entity of the target system and the source system can be reconfigured. For example, as shown in fig. 3C, a graph is displayed for a table field mapping relationship interface configured in a certain business system. The terminal may obtain the data of the source system in various ways, for example, in a form of table, view, or structured query SQL statement, according to the source data type included in the synchronization instruction, and synchronize the packet information of the service form of the source system to the packet field information corresponding to the dynamic entity according to the field mapping relationship. The basic data and the grouped data information of the service data are not in sequence, the grouped field records the grouped internal code, the grouped data is not synchronized when the basic data of the material is synchronized, the grouped internal code does not exist at the moment, and the grouped field cannot be synchronized, so the internal code of the grouped field of the material can be updated only after the basic data and the grouped information are synchronized by the terminal, namely the grouped internal code of the field information needs to be updated finally. Therefore, basic information and grouping information are synchronized firstly, and then information with special processing is synchronized, so that the integrity of synchronous data is ensured, meanwhile, confusion and errors can be avoided, especially, the data migration of complex fields corresponding to a background table during heterogeneous system integration is involved, and the accuracy of the data migration can be effectively improved.
In one embodiment, the step of synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system includes:
and acquiring a field mapping relation between the dynamic entity corresponding to the user updating operation and the source system.
And synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relation between the dynamic entity and the source system.
After the terminal synchronizes the basic data of the service form in the source system to the dynamic entity according to the mapping relation of the configuration tables of the target system and the source system, the terminal synchronizes the grouping information of the service form of the source system to the grouping field information corresponding to the dynamic entity according to the field mapping relation of the dynamic entity and the source system. The field mapping relationship between the dynamic entity and the source system may be configured in the target system in advance, or the field mapping relationship between the dynamic entity and the source system corresponding to the user updating operation may be obtained by the terminal in real time, and the terminal synchronizes the grouping information of the service form of the source system to the grouping field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system. Therefore, when a user needs to update the mapping relationship corresponding to the partial synchronous fields, the mapping relationship of the data corresponding to the dynamic entities of the source system and the target system, that is, the mapping relationship of the packet internal code, can be set through an update operation, and the terminal assigns the complex fields of the service data according to the updated mapping relationship of the packet internal code of the field information corresponding to the dynamic entities of the source system, that is, the terminal assigns the packet internal code to the packet field information of the service data. For example, as shown in fig. 3D, a display is shown for an interface when material packets are synchronized in a certain service system. The terminal can synchronize basic information corresponding to the materials into a dynamic entity of a target system, then synchronize grouping information of the materials into grouping field information corresponding to the dynamic entity of the target system, and meanwhile, the terminal groups the materials according to data mapping relations of the basic information of the materials and the grouping of the materials, which are established by a user in real time, namely, the grouping of the materials is carried out according to the data mapping relations of the grouping of the materials, and the grouping fields of the materials corresponding to the materials are updated. Therefore, the dynamic entity and the target field thereof are automatically generated, the dynamic entity data are automatically synchronized based on the configuration of the dynamic entity, and the complex field is assigned with the value according to the data mapping relation of the dynamic entity, so that the code writing is not needed at each time of synchronization, the complex problems are changed into general processing, and the method has good universality.
It should be understood that although the various steps in the flow charts of fig. 1-3 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 1-3 may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed in turn or alternately with other steps or at least some of the other steps.
In one embodiment, as shown in fig. 4, a data migration apparatus for a heterogeneous system is provided, including: an obtaining module 402, a building module 404, a synchronizing module 406, and an assigning module 408, wherein:
an obtaining module 402, configured to obtain a synchronization instruction of the service form.
And the building module 404 is configured to build a dynamic entity corresponding to the service form in the target system according to the synchronization instruction.
The synchronization module 406 is configured to synchronize the basic data of the service form in the source system to the dynamic entity according to the mapping relationship between the dynamic entity and the configuration table of the source system, and synchronize the packet information of the service form in the source system to the packet field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system.
And the assignment module 408 is configured to assign the packet internal code to the packet field information of the dynamic entity according to a mapping relationship between the packet internal code of the field information corresponding to the dynamic entity and the source system.
In one embodiment, the building module is further configured to build attribute information of the dynamic entity corresponding to the service form in the target system according to the synchronization instruction, and build field information of the dynamic entity corresponding to the service form in the target system according to the synchronization instruction.
In one embodiment, the building module is further configured to build the identifier, the field name, and the element type of the corresponding dynamic entity in the target system according to the identifier, the field name, and the element type of the business form.
In an embodiment, the obtaining module is further configured to obtain packet field information corresponding to the service form, and use the packet field information as the packet field information of the dynamic entity corresponding to the service form.
In an embodiment, the obtaining module is further configured to obtain, according to a source data type included in the synchronization instruction, grouping information corresponding to the service form from the source system in a manner of table, view, or structured query SQL statement. The synchronization module is further configured to synchronize the packet information into segment field information corresponding to the dynamic entity.
In one embodiment, the obtaining module is further configured to obtain a field mapping relationship between the dynamic entity corresponding to the user update operation and the source system. The synchronization module is further used for synchronizing the grouping information of the service form of the source system to the grouping field information corresponding to the dynamic entity according to the field mapping relation between the dynamic entity and the source system.
For specific limitations of the data migration apparatus of the heterogeneous system, reference may be made to the above limitations of the data migration method of the heterogeneous system, which are not described herein again. The modules in the data migration apparatus of the heterogeneous system may be implemented in whole or in part by software, hardware, and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a terminal, and its internal structure diagram may be as shown in fig. 5. The computer device includes a processor, a memory, a communication interface, a display screen, and an input device connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system and a computer program. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The communication interface of the computer device is used for carrying out wired or wireless communication with an external terminal, and the wireless communication can be realized through WIFI, an operator network, NFC (near field communication) or other technologies. The computer program is executed by a processor to implement a method of data migration for a heterogeneous system. The display screen of the computer equipment can be a liquid crystal display screen or an electronic ink display screen, and the input device of the computer equipment can be a touch layer covered on the display screen, a key, a track ball or a touch pad arranged on the shell of the computer equipment, an external keyboard, a touch pad or a mouse and the like.
Those skilled in the art will appreciate that the architecture shown in fig. 5 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, a computer device is provided, comprising a memory, a processor and a computer program stored on the memory and executable on the processor, the steps of the above-described method embodiments being implemented when the computer program is executed by the processor.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include at least one of non-volatile and volatile memory. Non-volatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical storage, or the like. Volatile Memory can include Random Access Memory (RAM) or external cache Memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A method of data migration for a heterogeneous system, the method comprising:
acquiring a synchronous instruction of a service form;
according to the synchronous instruction, a dynamic entity corresponding to the business form is constructed in a target system;
synchronizing the basic data of the service form in the source system to the dynamic entity according to the mapping relation between the dynamic entity and the configuration table of the source system;
according to the field mapping relation between the dynamic entity and the source system, synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity;
and assigning the grouping internal code into the grouping field information of the dynamic entity according to the mapping relation of the grouping internal code of the field information corresponding to the dynamic entity and the source system.
2. The method of claim 1, wherein the dynamic entity comprises attribute information and field information;
the constructing a dynamic entity corresponding to the business form in the target system according to the synchronization instruction comprises:
according to the synchronous instruction, constructing attribute information of a dynamic entity corresponding to the business form in a target system;
and according to the synchronous instruction, constructing field information of the dynamic entity corresponding to the business form in the target system.
3. The method according to claim 2, wherein the synchronization instruction of the service form carries attribute information of the service form; the attribute information of the business form comprises an identifier, a field name and an element type of the business form;
the constructing, according to the synchronization instruction, attribute information of the dynamic entity corresponding to the service form in the target system includes:
and constructing the identifier, the field name and the element type of the corresponding dynamic entity in the target system according to the identifier, the field name and the element type of the service form.
4. The method of claim 2, wherein the constructing field information of the dynamic entity corresponding to the service form in the target system according to the synchronization instruction comprises:
the field information includes packet field information;
acquiring packet field information corresponding to the service form;
and taking the grouping field information as grouping field information of the dynamic entity corresponding to the service form.
5. The method of claim 1, wherein the synchronizing the packet information of the service form of the source system to the packet field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system comprises:
according to the source data type contained in the synchronization instruction, acquiring the grouping information corresponding to the business form from a source system in a table, view or structured query SQL statement mode;
and synchronizing the grouping information into the corresponding segmentation field information of the dynamic entity.
6. The method according to claim 1, wherein the synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relationship between the dynamic entity and the source system comprises:
acquiring a field mapping relation between a dynamic entity corresponding to a user updating operation and a source system;
and synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relation between the dynamic entity and the source system.
7. An apparatus for data migration of a heterogeneous system, the apparatus comprising:
the acquisition module is used for acquiring a synchronous instruction of the business form;
the construction module is used for constructing a dynamic entity corresponding to the business form in a target system according to the synchronous instruction;
the synchronization module is used for synchronizing the basic data of the service form in the source system into the dynamic entity according to the mapping relation of the configuration table of the dynamic entity and the source system, and synchronizing the grouping information of the service form of the source system into the grouping field information corresponding to the dynamic entity according to the field mapping relation of the dynamic entity and the source system;
and the assignment module is used for assigning the grouping internal code to the grouping field information of the dynamic entity according to the mapping relation of the grouping internal code of the field information corresponding to the dynamic entity and the source system.
8. The data migration apparatus of a heterogeneous system according to claim 7, wherein said apparatus further comprises:
the construction module is used for constructing the attribute information of the dynamic entity corresponding to the business form in the target system according to the synchronous instruction; and according to the synchronous instruction, constructing field information of the dynamic entity corresponding to the business form in the target system.
9. A computer device comprising a memory and a processor, the memory storing a computer program, wherein the processor implements the steps of the method of any one of claims 1 to 6 when executing the computer program.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011168319.7A CN112434004A (en) | 2020-10-28 | 2020-10-28 | Data migration method and device for heterogeneous system, computer equipment and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011168319.7A CN112434004A (en) | 2020-10-28 | 2020-10-28 | Data migration method and device for heterogeneous system, computer equipment and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112434004A true CN112434004A (en) | 2021-03-02 |
Family
ID=74696234
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011168319.7A Pending CN112434004A (en) | 2020-10-28 | 2020-10-28 | Data migration method and device for heterogeneous system, computer equipment and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112434004A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115292289A (en) * | 2022-08-09 | 2022-11-04 | 华润数字科技有限公司 | Data filtering method, device, equipment and medium based on database migration |
Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100332882A1 (en) * | 2009-06-25 | 2010-12-30 | International Business Machines Corporation | Minimizing storage power consumption |
| US20150007196A1 (en) * | 2013-06-28 | 2015-01-01 | Intel Corporation | Processors having heterogeneous cores with different instructions and/or architecural features that are presented to software as homogeneous virtual cores |
| CN104598531A (en) * | 2014-12-25 | 2015-05-06 | 广东电子工业研究院有限公司 | Incremental data migration method among heterogeneous relational databases based on trigger |
| CN105787057A (en) * | 2016-02-29 | 2016-07-20 | 浪潮通用软件有限公司 | Method for realizing automatic synchronization of service data between heterogeneous systems |
| CN106250382A (en) * | 2016-01-28 | 2016-12-21 | 新博卓畅技术（北京）有限公司 | A kind of metadata management automotive engine system and implementation method |
| CN108133007A (en) * | 2017-12-22 | 2018-06-08 | 北京明朝万达科技股份有限公司 | A kind of method of data synchronization and system |
| CN109885581A (en) * | 2019-03-14 | 2019-06-14 | 苏州达家迎信息技术有限公司 | Synchronous method, device, equipment and the storage medium of database |
| CN110245145A (en) * | 2019-04-25 | 2019-09-17 | 深圳壹账通智能科技有限公司 | Structure synchronization method and apparatus of the relevant database to Hadoop database |
| CN110647579A (en) * | 2019-08-16 | 2020-01-03 | 北京百度网讯科技有限公司 | Data synchronization method and device, computer equipment and readable medium |
| CN110704519A (en) * | 2019-08-29 | 2020-01-17 | 中国平安财产保险股份有限公司 | Business document conversion method and device, storage medium and computer equipment |
| CN111209932A (en) * | 2019-12-24 | 2020-05-29 | 中国电子科技集团公司第三十研究所 | Dynamically configurable user information leading-in model based on multiple data sources |
| CN111506556A (en) * | 2020-04-09 | 2020-08-07 | 北京市测绘设计研究院 | Multi-source heterogeneous structured data synchronization method |
-
2020
- 2020-10-28 CN CN202011168319.7A patent/CN112434004A/en active Pending
Patent Citations (12)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20100332882A1 (en) * | 2009-06-25 | 2010-12-30 | International Business Machines Corporation | Minimizing storage power consumption |
| US20150007196A1 (en) * | 2013-06-28 | 2015-01-01 | Intel Corporation | Processors having heterogeneous cores with different instructions and/or architecural features that are presented to software as homogeneous virtual cores |
| CN104598531A (en) * | 2014-12-25 | 2015-05-06 | 广东电子工业研究院有限公司 | Incremental data migration method among heterogeneous relational databases based on trigger |
| CN106250382A (en) * | 2016-01-28 | 2016-12-21 | 新博卓畅技术（北京）有限公司 | A kind of metadata management automotive engine system and implementation method |
| CN105787057A (en) * | 2016-02-29 | 2016-07-20 | 浪潮通用软件有限公司 | Method for realizing automatic synchronization of service data between heterogeneous systems |
| CN108133007A (en) * | 2017-12-22 | 2018-06-08 | 北京明朝万达科技股份有限公司 | A kind of method of data synchronization and system |
| CN109885581A (en) * | 2019-03-14 | 2019-06-14 | 苏州达家迎信息技术有限公司 | Synchronous method, device, equipment and the storage medium of database |
| CN110245145A (en) * | 2019-04-25 | 2019-09-17 | 深圳壹账通智能科技有限公司 | Structure synchronization method and apparatus of the relevant database to Hadoop database |
| CN110647579A (en) * | 2019-08-16 | 2020-01-03 | 北京百度网讯科技有限公司 | Data synchronization method and device, computer equipment and readable medium |
| CN110704519A (en) * | 2019-08-29 | 2020-01-17 | 中国平安财产保险股份有限公司 | Business document conversion method and device, storage medium and computer equipment |
| CN111209932A (en) * | 2019-12-24 | 2020-05-29 | 中国电子科技集团公司第三十研究所 | Dynamically configurable user information leading-in model based on multiple data sources |
| CN111506556A (en) * | 2020-04-09 | 2020-08-07 | 北京市测绘设计研究院 | Multi-source heterogeneous structured data synchronization method |
Non-Patent Citations (2)
| Title |
|---|
| RENHAI CHEN 等: "Towards Efficient NVDIMM-based Heterogeneous Storage Hierarchy Management for Big Data Workloads", 《PROCEEDINGS OF THE 52ND ANNUAL IEEE/ACM INTERNATIONAL SYMPOSIUM ON MICROARCHITECTURE》, 12 October 2019 (2019-10-12), pages 849 - 860, XP058476931, DOI: 10.1145/3352460.3358266 * |
| 李为;蔡英蔚;徐辉;: "基于多线程的异构数据库集成平台的设计实现", 现代电力, no. 05, 10 October 2008 (2008-10-10), pages 74 - 77 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115292289A (en) * | 2022-08-09 | 2022-11-04 | 华润数字科技有限公司 | Data filtering method, device, equipment and medium based on database migration |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107967159B (en) | Method for configuring file application and server | |
| CN111563368B (en) | Report generation method, report generation device, computer equipment and storage medium | |
| US11782892B2 (en) | Method and system for migrating content between enterprise content management systems | |
| US10291704B2 (en) | Networked solutions integration using a cloud business object broker | |
| US10635408B2 (en) | Method and apparatus for enabling agile development of services in cloud computing and traditional environments | |
| CN106557307B (en) | Service data processing method and system | |
| CN109522751B (en) | Access right control method and device, electronic equipment and computer readable medium | |
| US20130067456A1 (en) | Application configuration framework for enterprise resource planning application installation | |
| CN110738038A (en) | Contract text generation method, device, equipment and computer readable storage medium | |
| CN112433712A (en) | Report display method and device, computer equipment and storage medium | |
| CN113742338A (en) | Structured storage system for project acceptance forms | |
| US9009652B2 (en) | Method and system for handling software design conflicts | |
| CN112434004A (en) | Data migration method and device for heterogeneous system, computer equipment and storage medium | |
| CN112434006A (en) | Form data processing method and device, computer equipment and storage medium | |
| CN112068812A (en) | Micro-service generation method and device, computer equipment and storage medium | |
| CN115543428A (en) | Simulated data generation method and device based on strategy template | |
| CN113656022A (en) | Software development method and device, computer equipment and storage medium | |
| CN112231377A (en) | Data mapping method, system, device, server and storage medium | |
| CN117579480B (en) | Cloud distributed resource data model expansion and labeling method and system | |
| CN111310090A (en) | Content data management system, method, equipment and storage medium of website page | |
| CN109358899B (en) | Method and device for updating resource versions in shared shelf | |
| CN114201464A (en) | Data display method and device, computer equipment and storage medium | |
| CN117978886A (en) | Service processing task dispatching method, device, computer equipment and storage medium | |
| CN114300152A (en) | Method, device, equipment and storage medium for sending page data | |
| CN115080540A (en) | Data migration method and device, computer equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |