CN112231377A - Data mapping method, system, device, server and storage medium - Google Patents
Data mapping method, system, device, server and storage medium Download PDFInfo
- Publication number
- CN112231377A CN112231377A CN202011029958.5A CN202011029958A CN112231377A CN 112231377 A CN112231377 A CN 112231377A CN 202011029958 A CN202011029958 A CN 202011029958A CN 112231377 A CN112231377 A CN 112231377A
- Authority
- CN
- China
- Prior art keywords
- service
- model
- data
- business
- mapping
- 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
- 238000013506 data mapping Methods 0.000 title claims abstract description 90
- 238000000034 method Methods 0.000 title claims abstract description 46
- 238000003860 storage Methods 0.000 title claims abstract description 19
- 238000013507 mapping Methods 0.000 claims abstract description 106
- 238000004590 computer program Methods 0.000 claims description 13
- 238000007726 management method Methods 0.000 description 11
- 238000010586 diagram Methods 0.000 description 6
- 238000013499 data model Methods 0.000 description 3
- 238000004519 manufacturing process Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 2
- 238000003825 pressing Methods 0.000 description 2
- 230000004044 response Effects 0.000 description 2
- 238000013500 data storage Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000002265 prevention 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/25—Integrating or interfacing systems involving database management systems
- G06F16/252—Integrating or interfacing systems involving database management systems between a Database Management System and a front-end application
Abstract
The application relates to a data mapping method, a system, a device, a server and a storage medium. The method comprises the following steps: responding to a data mapping instruction, and determining a service model and a system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired; determining a service system corresponding to the system scheme based on the system scheme; each business system corresponds to one system scheme; acquiring a mapping relation between the business model and the business system based on the business model and the business system; and mapping the service data of the service system into the service model according to the mapping relation between the service model and the service system. The method can accurately map the service data of different service types.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a data mapping method, system, apparatus, server, and storage medium.
Background
With the development of computer technology, more and more enterprises adopt business systems to realize activities of the enterprises, such as marketing planning, sales platforms, sales process management, customer service management, customer relationship management, risk prevention, business data storage and business data acquisition, and the like. The business system refers to business links required by enterprises for positioning, roles played by all partners, and modes and contents of cooperation and transaction of stakeholders.
When a computer device needs to access a business system, it usually directly operates a database of the business system to be accessed, and maps data in the database. However, the conventional data mapping method cannot accurately map the service data.
Disclosure of Invention
In view of the above, it is necessary to provide a data mapping method, system, device, server and storage medium capable of accurately mapping service data in view of the above technical problems.
A method of data mapping, the method comprising:
responding to a data mapping instruction, and determining a service model and a system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired;
determining a service system corresponding to the system scheme based on the system scheme; each business system corresponds to one system scheme;
acquiring a mapping relation between the business model and the business system based on the business model and the business system;
and mapping the service data of the service system into the service model according to the mapping relation between the service model and the service system.
In one embodiment, after determining the service model and the system scenario corresponding to the service model, the method further includes:
determining a system type of the business system based on the system scheme;
the obtaining of the mapping relationship between the service model and the service system based on the service model and the service system includes:
and acquiring the mapping relation between the service model and the service system based on the service model and the system type of the service system.
In one embodiment, the obtaining a mapping relationship between the business model and the business system based on the business model and the system type of the business system includes:
determining a model parser based on the business model and a system type of the business system; the business systems of the same system type determine the same model resolver;
and acquiring the mapping relation between the service model and the service system through the model resolver.
In one embodiment, after mapping the business data of the business system into the business model, the method further includes:
when a data request sent by a user terminal is received, determining target data requested by the data request;
and acquiring the target data from the mapped service model, and sending the target data to the user terminal.
In one embodiment, the data request includes a business model identification and a user identification;
when receiving a data request sent by a user terminal, determining target data requested by the data request, including:
when a data request sent by a user terminal is received, determining a target model from each service model based on a service model identifier included in the data request;
and determining target data requested by the user identification through the target model based on the user identification included in the data request.
A data mapping system comprises a server and a service terminal;
the server comprises a service model, and the server responds to a data mapping instruction and determines the service model and a system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired; determining a service system corresponding to the system scheme based on the system scheme; each business system corresponds to one system scheme; acquiring a mapping relation between the business model and the business system based on the business model and the business system; mapping the service data of the service system included by the service terminal into the service model according to the mapping relation between the service model and the service system;
the service terminal comprises a service system, and the service terminal acquires the service data and maps the service data to the service model included in the server through the mapping relation between the service model and the service system.
In one embodiment, the system further comprises a user terminal;
the user terminal acquires a data request, sends the data request to the server and receives target data returned by the server;
the server receives a data request sent by the user terminal and determines target data requested by the data request; and acquiring the target data from the mapped service model, and sending the target data to the user terminal.
An apparatus for data mapping, the apparatus comprising:
the system comprises a service model and system scheme determining module, a service model and a system scheme corresponding to the service model, wherein the service model and system scheme determining module is used for responding to a data mapping instruction and determining the service model and the system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired;
the service system and system type determining module is used for determining a service system corresponding to the system scheme based on the system scheme; each business system corresponds to one system scheme;
the mapping relation obtaining module is used for obtaining the mapping relation between the business model and the business system based on the business model and the system type of the business system;
and the mapping module is used for mapping the service data of the service system into the service model according to the mapping relation between the service model and the service system.
A server comprising a memory storing a computer program and a processor implementing the steps of the method described above when the processor executes the computer program.
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 above-mentioned method.
According to the data mapping method, the data mapping system, the data mapping device, the server and the storage medium, the same service model is determined by the service data of the same service type to be acquired by the data mapping instruction, namely the service data of the same service type to be acquired by the data mapping instruction share the same service model, and then the mapping relation between the service model and the service system is acquired based on the service model and the determined service system; according to the mapping relation between the service model and the service system, the service data of the same service type is mapped to the same service model, so that the influence caused by different service systems is shielded, the problem that different types of service data cannot be accurately mapped due to different definitions of fields or tables is solved, the service data of different service types can be accurately mapped, and the accurate service data can be acquired from the service model.
Drawings
FIG. 1 is a diagram of an application environment of a data mapping method in one embodiment;
FIG. 2 is a flow diagram illustrating a data mapping method in one embodiment;
FIG. 3 is a flow chart illustrating a data mapping method according to another embodiment;
FIG. 4 is a flow chart illustrating a data mapping method according to another embodiment;
FIG. 5 is a schematic flow chart diagram illustrating a data mapping method in which the data mapping system is a single system in one embodiment;
FIG. 6 is a flowchart illustrating a data mapping method in which the data mapping system is a heterogeneous system according to another embodiment;
FIG. 7 is a block diagram of a data mapping apparatus in one embodiment;
fig. 8 is an internal configuration diagram of a server in one 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.
The data mapping method provided by the application can be applied to the application environment shown in fig. 1. The service terminal 102 communicates with the server 104 through a network, and the user terminal 106 communicates with the server 104 through the network. The server 104 responds to the data mapping instruction and determines a service model and a system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired; determining a service system corresponding to the system scheme based on the system scheme; each service system corresponds to one system scheme; acquiring a mapping relation between a business model and a business system based on the business model and the business system; and mapping the service data of the service system included in the service terminal 102 into the service model according to the mapping relation between the service model and the service system. Further, the user terminal 106 may obtain a data request input by the user, and may send the data request to the server 104. When the server 104 receives a data request sent by the user terminal 106, determining target data requested by the data request; and acquiring target data from the mapped service model and sending the target data to the user terminal 106. The service terminal 102 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices, the server 104 may be implemented by an independent server or a server cluster composed of a plurality of servers, and the user terminal 106 may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices.
In one embodiment, as shown in fig. 2, a data mapping method is provided, which is applied to the server in fig. 1 as an example, and includes the following steps:
The business model is used to define business data templates. The business model comprises one or at least two business model bodies and the relation between the business model bodies. The service model body refers to attribute information of service data. The service model body may include information of a field, a field type, etc. of specific service data. The business model may also include information such as an identification of the business model, a name of the business model, and the like. The business model is stored in the server. The business model may be a sales business model, a purchase business model, etc.
A field (field) represents a variable associated with an object or class. In a database, the "columns" of a table are called "fields," each of which contains information for a topic. For example, in the directory database, the names and the contact numbers are common attributes for all rows in the table, so these columns are referred to as the name field and the contact number field. The field type refers to the type of the field. Field types such as binary data type, character data type, date and time data type, numeric data type, currency data type, special data type, and the like.
The system scheme refers to a scheme in which a server connects to a service system. The system scenario may include, but is not limited to, an address of the business system, a type of the business system, a system scenario name, a business system brand, a product name of the business system, a product version of the business system, and database information (database type, address, port, username, password, account cover, etc.) of the business system.
For example, the system scheme may include that the system brand is brand a, the product of the business system is K/3Wise, the product version of the business system is 15.1, and the database type of the business system is SQLServer.
The business system refers to business links required by enterprises for positioning, roles played by all partners, and modes and contents of cooperation and transaction of interest relatives. Service data refers to data in the slave service system. Business systems such as ERP (Enterprise Resource Planning) System, MES (manufacturing Enterprise production process execution Management System), WMS (Warehouse Management System), and the like. The number of service systems may be one or at least two. The architecture of each business system may be the same or different.
The data to be acquired by the data mapping instruction may be service data in one service system, or may be service data in at least two service systems. The data to be acquired by the data mapping instruction may be service data of the same service type or service data of different service types.
The data mapping instruction determines the same service model for the service data of the same service type to be acquired, namely the service data of the same service type are mapped to the same service model. For example, the service data to be acquired by the data mapping instruction includes service data of a service type a and service data of a service type B, the service data of the service type a to be acquired determines the same service model X, the service data of the service type B to be acquired determines the same service model Y, the service data of the service type a are both mapped to the service model X, and the service data of the service type B are both mapped to the service model Y.
Specifically, the server presets preset time duration, and generates a data mapping instruction every preset time duration; and responding to the data mapping instruction, and determining a business model and a system scheme corresponding to the business model. The preset time period, such as 3 minutes, 5 minutes, etc., can be set as required.
In another embodiment, when a preset operation is detected, a data mapping instruction is generated; and responding to the data mapping instruction, and determining a business model and a system scheme corresponding to the business model. The preset operation may be clicking, double-clicking, sliding, voice inputting, pressing of a physical key, and the like.
Each business system corresponds to a system plan. For example, the service system a1 corresponds to the system scheme B1, the service system a2 corresponds to the system scheme B2, and the service system A3 corresponds to the system scheme B3.
The system scheme refers to a scheme in which a server connects to a service system. The system scenario may include, but is not limited to, an address of the business system, a type of the business system, a system scenario name, a business system brand, a product name of the business system, a product version of the business system, and database information (database type, address, port, username, password, account cover, etc.) of the business system. The system solution may be stored in a server.
The system scenario includes identification of the business system. Specifically, the server obtains the identifier of the service system from the system scheme, and finds the corresponding service system according to the identifier of the service system. The identification of the service system has uniqueness, and the service system can be uniquely found. The identification of the business system may be a network address, an icon, a string, etc.
For example, if the identifier of the service system is http://192.168.x.xxx, the service system can be found according to the network address, so that the data in the service system can be accessed.
And step 206, acquiring the mapping relation between the business model and the business system based on the business model and the business system.
The mapping relation between the business model and the business system refers to the relation of mapping business data in the business system to the business model.
It can be understood that, if the attribute of the service data defined in the service system is different from the attribute of the service data defined in the service model, the mapping relationship between the service model and the service system needs to be obtained, and the service data in the service system is mapped to the template of the service model through the mapping relationship between the service model and the service system.
Specifically, a model resolver is obtained based on the business model and the business system, and a mapping relation between the business model and the business system is obtained from the model resolver.
The model resolver is a resolving program of the mapping relation between the business model and the business system, and can acquire the mapping relation between the business model and the business system from the model resolver. For example, the model parser may be an ERP (Enterprise Resource Planning) connector, a CRM (Customer Relationship Management) connector, an OA (Office Automation Management) connector, or the like. For example, the model parser is K/3Wise, and the mapping relation between the service model and the K/3Wise ERP service system can be obtained.
And step 208, mapping the service data of the service system into the service model according to the mapping relation between the service model and the service system.
And the server acquires the service data to be acquired by the data mapping instruction from the database of the service system according to the mapping relation between the service model and the service system, and maps the acquired service data into the service model. The service data acquired by the server can be stored in a disk.
In another embodiment, the server may also call an Application Programming Interface (API) of the service system, obtain the service data to be obtained by the data mapping instruction through the API of the service system, and map the obtained service data into the service model.
For example, the server includes a service model M and a service model N, and a system scheme 1 and a system scheme 2 corresponding to the service model M, a service system corresponding to the system scheme 1 is X1, a service system corresponding to the system scheme 2 is X2, a system scheme 3 corresponding to the service model N, and a service system corresponding to the system scheme 3 is Y1. The server obtains that the mapping relation between the service model M and the service system X1 is X, the mapping relation between the service model M and the service system X2 is also X, and the mapping relation between the service model N and the service system Y1 is also Y. The server may map the service data of the service system X1 into the service model M according to the mapping relationship X, map the service data of the service system X2 into the service model M according to the mapping relationship X, and map the service data of the service system Y1 into the service model N according to the mapping relationship Y.
In the data mapping method, the same service model is determined for the service data of the same service type to be acquired by the data mapping instruction, namely the service data of the same service type to be acquired by the data mapping instruction share the same service model, and then the mapping relation between the service model and the service system is acquired based on the service model and the determined service system; according to the mapping relation between the service model and the service system, the service data of the same service type is mapped to the same service model, so that the influence caused by different service systems is shielded, the problem that different types of service data cannot be accurately mapped due to different definitions of fields or tables is solved, the service data of different service types can be accurately mapped, and the accurate service data can be acquired from the service model.
The data mapping instruction determines the same service model according to the service data of the same service type to be acquired, each service type corresponds to one service model, the number and scale of the service models are controllable, only a small number of service models are required to be maintained, manpower and material resources are saved, and maintenance resources are also saved.
In an embodiment, as shown in fig. 3, after determining the service model and the system scenario corresponding to the service model, the method further includes:
The system type refers to the type of business system. The system type may be one of an ERP (Enterprise Resource Planning) system, a CRM (Customer Relationship Management) system, an OA (Office Automation Management) system, a production Management software system, a purchase-sale-stock Management software system, and the like.
The system type of the service system may be preconfigured in the system solution, and the server may obtain the system type of the service system from the system solution.
Acquiring a mapping relation between a service model and a service system based on the service model and the service system, wherein the mapping relation comprises the following steps:
and 304, acquiring a mapping relation between the service model and the service system based on the service model and the system type of the service system.
It can be understood that the tables and fields defined in the service systems of different system types are different, so that the service systems are further divided according to the system types, and a more accurate mapping relationship between the service model and the service system can be obtained based on the service model and the system type of the service system, so that the service data of the service system of a specific system type can be mapped into the service model through the mapping relationship.
Specifically, obtaining the mapping relationship between the service model and the service system based on the service model and the system type of the service system includes: determining a model resolver based on a service model and a system type of a service system; the business systems of the same system type determine the same model resolver; and acquiring a mapping relation between the service model and the service system through the model analyzer.
The model resolver is a resolving program of the mapping relation between the business model and the business system, and can acquire the mapping relation between the business model and the business system from the model resolver. For example, the model parser may be an ERP (Enterprise Resource Planning) connector, a CRM (Customer Relationship Management) connector, an OA (Office Automation Management) connector, or the like. The model analyzer stores the mapping relation between the business model body and the field of the business model and the table and the field of the appointed business system.
It can be understood that, the service systems of different system types, the tables and the fields are different in definition, so that the service systems of the same system type determine the same model resolver, and the mapping relationship between the service model and the service system of the specific system type can be more accurately obtained through the model resolver, thereby more accurately mapping the service data of the service system of the specific system type into the service model.
For example, if the system type of the service system X1 is X, and the system type of the service system X2 is also X, then a model parser X is determined based on the service model M and the service system X1, and a model parser X is determined based on the service model M and the service system X2, that is, the same model parser X is determined for the same system type X, then the service data of the service system X1 is mapped into the service model through the model parser X, and the service data of the service system X2 is mapped into the service model through the model parser X.
In the embodiment, a model resolver is determined based on a service model and a system type of a service system; the business systems of the same system type determine the same model resolver; the model parser can obtain a more accurate mapping relation between the business model and the business system, so that the business data of the business system with a specific system type can be more accurately mapped into the business model. Furthermore, the server separates the business model from the model resolver corresponding to the specific system type, thereby simplifying the complexity of the data mapping system. The business model and the model resolver are involved separately, and the large-scale popularization to other business systems is facilitated. When service systems of different system types are added, a new model resolver can be added, and mapping of data can be realized.
In another embodiment, the server may further determine the model resolver based on a business model, a system type of the business system, a brand of the business system, a product name of the business system, a product version of the business system, and a database type of the business system.
For example, the business system supports 2 databases, SQLServer and Oracle, respectively, and then one model parser can be determined based on the business model and SQLServer, and the other model parser can be determined based on the business model and Oracle.
In one embodiment, as shown in fig. 4, after mapping the business data of the business system into the business model, the method further includes:
The user terminal is a terminal where a user is located, and may be, but is not limited to, various personal computers, notebook computers, smart phones, tablet computers, and portable wearable devices. A data request refers to an instruction that requests data. The data request may include a device identification of the user terminal, a user identification, an identification of the requested service data, a service type of the requested service data, a service system in which the requested service data is located, and the like. The target data refers to the service data requested by the data request.
The data request includes an identification of the requested target data, and the server may obtain the identification of the requested target data from the data request, thereby determining the target data requested by the data request.
And the user terminal responds to the preset operation, generates a data request and sends the data request to the server. When the server receives a data request sent by the user terminal, the target data requested by the data request is determined. The preset operation may be clicking, double-clicking, sliding, voice inputting, pressing of a physical key, and the like.
And step 404, acquiring target data from the mapped service model, and sending the target data to the user terminal.
And after the server maps the service data of the service system to the service model, the service model comprises the service data of the service system. And the server acquires target data from the mapped service model and sends the target data to the user terminal.
In the embodiment, when a data request sent by a user terminal is received, target data requested by the data request is determined; and acquiring target data from the mapped service model, and sending the target data to the user terminal, so that the user terminal can acquire the service data of the service system.
In one embodiment, the data request includes a business model identification and a user identification; when a data request sent by a user terminal is received, determining target data requested by the data request, wherein the method comprises the following steps: when a data request sent by a user terminal is received, determining a target model from each service model based on a service model identifier included in the data request; and determining target data requested by the user identification through the target model based on the user identification included in the data request.
The business model identification refers to an identification of the business model. The user identification refers to an identification of the user. The user identification may be a name of the user, an icon of the user, an identification of a device where the user is located, an address of the device where the user is located, and so on. The target model refers to the business model determined by the data request.
It is understood that one or at least two service models may be included in the server, and when the server receives a data request sent by the user terminal, a target model is determined from each service model based on a service model identifier included in the data request.
In each business model of the server, there is a corresponding storage set. The storage set is used for storing business data in the business model. And the service data corresponding to each user identifier is stored in the storage set in advance. The server can determine service data corresponding to the user identifier from the storage set based on the user identifier included in the data request, wherein the service data is target data requested by the user identifier.
In this embodiment, when a data request sent by a user terminal is received, a target model is determined from each service model based on a service model identifier included in the data request, and then target data requested by a user identifier can be accurately determined through the target model based on the user identifier included in the data request.
In one embodiment, the data mapping system is characterized by comprising a server and a service terminal; the server comprises a service model, and the server responds to the data mapping instruction and determines the service model and a system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired; determining a service system corresponding to the system scheme based on the system scheme; each service system corresponds to one system scheme; acquiring a mapping relation between a business model and a business system based on the business model and the business system; mapping the service data of the service system into the service model according to the mapping relation between the service model and the service system; the service terminal comprises a service system, acquires service data and maps the service data into the service model through the mapping relation between the service model and the service system.
The service terminal refers to a terminal where a service system is located. The server and the service terminal may communicate via a network. The server includes a service model, and may further store a system scheme, a mapping relationship between the service model and the service system, and the like. The server may include one or at least two service models, and the service types of the data mapped in each service model are the same, that is, the same service model is determined by the service data of the same service type to be acquired by the data mapping instruction.
The data mapping system comprises a server and a service terminal, wherein the data mapping instruction determines the same service model for the service data of the same service type to be acquired, namely the service data of the same service type to be acquired by the data mapping instruction shares the same service model, and then the mapping relation between the service model and the service system is acquired based on the service model and the determined service system; according to the mapping relation between the service model and the service system, the service data of the same service type is mapped to the same service model, so that the influence caused by different service systems is shielded, the problem that different types of service data cannot be accurately mapped due to different definitions of fields or tables is solved, the service data of different service types can be accurately mapped, and the accurate service data can be acquired from the service model.
In one embodiment, after determining the service model and the system solution corresponding to the service model, the method further includes: determining a system type of a service system based on a system scheme; acquiring a mapping relation between a service model and a service system based on the service model and the service system, wherein the mapping relation comprises the following steps: and acquiring the mapping relation between the service model and the service system based on the service model and the system type of the service system.
In one embodiment, obtaining the mapping relationship between the business model and the business system based on the system type of the business model and the business system includes: determining a model resolver based on a service model and a system type of a service system; the business systems of the same system type determine the same model resolver; and acquiring a mapping relation between the service model and the service system through the model analyzer.
In one embodiment, the data mapping system further includes a user terminal; the user terminal acquires a data request, sends the data request to the server and receives target data returned by the server; the server receives a data request sent by a user terminal and determines target data requested by the data request; and acquiring target data from the mapped service model, and sending the target data to the user terminal.
The user terminal refers to a terminal where the user identifier is located. The data mapping system may be a single system or a heterogeneous system. A single system means that the number of business systems included in the data mapping system is one. The heterogeneous system refers to a data mapping system comprising at least two business systems with different architectures.
In another embodiment, the data mapping system is a single system, and includes an application terminal, a server and a service terminal, and the service terminal includes a service system. The user terminal may include an application program, receive a data request input by a user through the application program, and send the data request to the server. Wherein, the application program can be a WEB application.
In one embodiment, as shown in fig. 5, the data mapping system is a single system, and the data mapping system includes an application terminal, a server, and a service terminal. It should be noted that the number of the application terminals may be one or at least two, and the number of the service terminals may also be one or at least two.
The server responds to the data mapping instruction, determines a service model M and a system scheme 1 corresponding to the service model M, determines a service system X1 corresponding to the system scheme 1 based on the system scheme 1, and configures the system type of the service system X1 in the system scheme 1.
The server determines a model resolver X based on the business model M and the system type of the business system X1, and may obtain a mapping relationship between the business model M and the business system X1 from the model resolver X. The server obtains the service data from the found service system X1 through the model resolver X. And the server maps the acquired service data into the service model.
An application A in the user terminal receives a data request input by a user and sends the data request to a server. The server determines target data requested by the data request from the data model M based on the data request, and sends the target data to the application A of the application terminal.
In one embodiment, as shown in fig. 6, the data mapping system is a heterogeneous system, and includes an application terminal, a server, and a service terminal, where the service terminal includes three service systems. It should be noted that the number of the application terminals may be one or at least two, and the number of the service terminals may also be one or at least two.
And the server responds to the data mapping instruction and determines a business model M and a system scheme 1, a system scheme 2 and a system scheme 3 corresponding to the business model M. Based on the system scheme 1, the service system X1 corresponding to the system scheme 1 is determined, and the system type of the service system X1 is also configured in the system scheme 1. Based on the system scheme 2, the service system X2 corresponding to the system scheme 2 is determined, and the system type of the service system X2 is also configured in the system scheme 2. And determining a service system Y corresponding to the system scheme 3 based on the system scheme 3, wherein the system type of the service system Y is also configured in the system scheme 3. The system type of the service system X1 is the same as that of the service system X2.
The server determines a model resolver X based on the business model M and the system type of the business system X1; the model parser X is determined based on the business model M and the system type of the business system X2. And the business systems of the same system type determine the same model resolver.
The server may obtain the mapping relationship between business model M and business system X1, and the mapping relationship between business model M and business system X2 from model parser X. The server obtains the service data from the found service system X1 through the model resolver X. The server obtains the service data from the found service system X2 through the model resolver X.
The server determines a model parser Y based on the business model M and the system type of the business system Y. The server can obtain the mapping relation between the business model M and the business system Y from the model resolver Y. And the server acquires the service data from the searched service system Y through the model resolver Y. The server maps the business data into a business model M.
An application A in the user terminal receives a data request input by a user and sends the data request to a server. The server determines target data requested by the data request from the data model M based on the data request, and sends the target data to the application A of the application terminal.
And the application B in the user terminal receives the data request input by the user and sends the data request to the server. And the server determines target data requested by the data request from the data model M based on the data request and sends the target data to an application B of the application terminal.
It should be understood that although the various steps in the flowcharts of fig. 2-4 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. 2-4 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 or stages.
In one embodiment, as shown in fig. 7, there is provided a data mapping apparatus 700, including: a service model and system scheme determining module 702, a service system and system type determining module 704, a mapping relation obtaining module 706 and a mapping module 708, wherein:
a service model and system scheme determining module 702, configured to determine, in response to the data mapping instruction, a service model and a system scheme corresponding to the service model; and the data mapping instruction determines the same service model according to the service data of the same service type to be acquired.
A service system and system type determining module 704, configured to determine a service system corresponding to the system scheme based on the system scheme; each business system corresponds to a system plan.
A mapping relation obtaining module 706, configured to obtain a mapping relation between the service model and the service system based on the service model and the system type of the service system.
The mapping module 708 is configured to map the service data of the service system into the service model according to a mapping relationship between the service model and the service system.
In the data mapping device, the data mapping instruction determines the same service model for the service data of the same service type to be acquired, that is, the data mapping instruction shares the same service model for the service data of the same service type to be acquired, and then the mapping relation between the service model and the service system is acquired based on the service model and the determined service system; according to the mapping relation between the service model and the service system, the service data of the same service type is mapped to the same service model, so that the influence caused by different service systems is shielded, the problem that different types of service data cannot be accurately mapped due to different definitions of fields or tables is solved, the service data of different service types can be accurately mapped, and the accurate service data can be acquired from the service model.
In an embodiment, the data mapping apparatus further includes a system type determining module, configured to determine a system type of the service system based on the system scheme; the mapping relationship obtaining module 706 is further configured to obtain a mapping relationship between the service model and the service system based on the service model and the system type of the service system.
In an embodiment, the mapping relationship obtaining module 706 is further configured to determine a model parser based on the service model and the system type of the service system; the business systems of the same system type determine the same model resolver; and acquiring a mapping relation between the service model and the service system through the model analyzer.
In an embodiment, the data mapping apparatus further includes a data request module, configured to determine, when a data request sent by a user terminal is received, target data requested by the data request; and acquiring target data from the mapped service model, and sending the target data to the user terminal.
In one embodiment, the data request includes a business model identification and a user identification; the data request module is further used for determining a target model from each business model based on a business model identifier included in the data request when receiving the data request sent by the user terminal; and determining target data requested by the user identification through the target model based on the user identification included in the data request.
For the specific definition of the data mapping device, reference may be made to the above definition of the data mapping method, which is not described herein again. The modules in the data mapping apparatus 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 of a processor in the server, and can also be stored in a memory in the server in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a server is provided, the internal structure of which may be as shown in fig. 8. The server includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the server is configured to provide computing and control capabilities. The memory of the server comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the server is used for storing data such as service data, system schemes and the like. The network interface of the server is used for communicating with an external terminal through network connection. The computer program is executed by a processor to implement a data mapping method.
Those skilled in the art will appreciate that the architecture shown in fig. 8 is a block diagram of only a portion of the architecture associated with the subject application, and does not constitute a limitation on the servers to which the subject application applies, as a particular server may include more or less components than those shown, or may combine certain components, or have a different arrangement of components.
In one embodiment, there is also provided a server including a memory and a processor, the memory storing a computer program, the processor implementing the steps of the above method embodiments when executing the computer program.
In an embodiment, a computer-readable storage medium is provided, on which a computer program is stored which, when being executed by a processor, carries out the steps of the above-mentioned method embodiments.
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 mapping, the method comprising:
responding to a data mapping instruction, and determining a service model and a system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired;
determining a service system corresponding to the system scheme based on the system scheme; each business system corresponds to one system scheme;
acquiring a mapping relation between the business model and the business system based on the business model and the business system;
and mapping the service data of the service system into the service model according to the mapping relation between the service model and the service system.
2. The method of claim 1, wherein after determining the service model and the system scenario corresponding to the service model, the method further comprises:
determining a system type of the business system based on the system scheme;
the obtaining of the mapping relationship between the service model and the service system based on the service model and the service system includes:
and acquiring the mapping relation between the service model and the service system based on the service model and the system type of the service system.
3. The method of claim 2, wherein obtaining the mapping relationship between the business model and the business system based on the business model and the system type of the business system comprises:
determining a model parser based on the business model and a system type of the business system; the business systems of the same system type determine the same model resolver;
and acquiring the mapping relation between the service model and the service system through the model resolver.
4. The method of claim 1, wherein after mapping the business data of the business system into the business model, further comprising:
when a data request sent by a user terminal is received, determining target data requested by the data request;
and acquiring the target data from the mapped service model, and sending the target data to the user terminal.
5. The method of claim 4, wherein the data request comprises a business model identification and a user identification;
when receiving a data request sent by a user terminal, determining target data requested by the data request, including:
when a data request sent by a user terminal is received, determining a target model from each service model based on a service model identifier included in the data request;
and determining target data requested by the user identification through the target model based on the user identification included in the data request.
6. A data mapping system is characterized in that the system comprises a server and a service terminal;
the server comprises a service model, and the server responds to a data mapping instruction and determines the service model and a system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired; determining a service system corresponding to the system scheme based on the system scheme; each business system corresponds to one system scheme; acquiring a mapping relation between the business model and the business system based on the business model and the business system; mapping the service data of the service system included by the service terminal into the service model according to the mapping relation between the service model and the service system;
the service terminal comprises a service system, and the service terminal acquires the service data and maps the service data to the service model included in the server through the mapping relation between the service model and the service system.
7. The system of claim 6, wherein the system further comprises a user terminal;
the user terminal acquires a data request, sends the data request to the server and receives target data returned by the server;
the server receives a data request sent by the user terminal and determines target data requested by the data request; and acquiring the target data from the mapped service model, and sending the target data to the user terminal.
8. An apparatus for data mapping, the apparatus comprising:
the system comprises a service model and system scheme determining module, a service model and a system scheme corresponding to the service model, wherein the service model and system scheme determining module is used for responding to a data mapping instruction and determining the service model and the system scheme corresponding to the service model; the data mapping instruction determines the same service model according to the service data of the same service type to be acquired;
the service system and system type determining module is used for determining a service system corresponding to the system scheme based on the system scheme; each business system corresponds to one system scheme;
the mapping relation obtaining module is used for obtaining the mapping relation between the business model and the business system based on the business model and the system type of the business system;
and the mapping module is used for mapping the service data of the service system into the service model according to the mapping relation between the service model and the service system.
9. A server comprising a memory and a processor, the memory storing a computer program, characterized in that the processor realizes the steps of the method of any of claims 1 to 5 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 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011029958.5A CN112231377A (en) | 2020-09-27 | 2020-09-27 | Data mapping method, system, device, server and storage medium |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011029958.5A CN112231377A (en) | 2020-09-27 | 2020-09-27 | Data mapping method, system, device, server and storage medium |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112231377A true CN112231377A (en) | 2021-01-15 |
Family
ID=74108249
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011029958.5A Pending CN112231377A (en) | 2020-09-27 | 2020-09-27 | Data mapping method, system, device, server and storage medium |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112231377A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113793612A (en) * | 2021-09-15 | 2021-12-14 | 京东科技信息技术有限公司 | Model service updating method and device and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20000040284A (en) * | 1998-12-17 | 2000-07-05 | 이계철 | Method for controlling unitary traffic using instruction classification and mapping to standardized management data in electronic switching system |
| CN110278236A (en) * | 2018-03-16 | 2019-09-24 | 华为技术有限公司 | A kind of business event converged communication method and device |
| CN110351342A (en) * | 2019-06-20 | 2019-10-18 | 平安科技（深圳）有限公司 | Service order processing method, device, computer equipment and storage medium |
-
2020
- 2020-09-27 CN CN202011029958.5A patent/CN112231377A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR20000040284A (en) * | 1998-12-17 | 2000-07-05 | 이계철 | Method for controlling unitary traffic using instruction classification and mapping to standardized management data in electronic switching system |
| CN110278236A (en) * | 2018-03-16 | 2019-09-24 | 华为技术有限公司 | A kind of business event converged communication method and device |
| CN110351342A (en) * | 2019-06-20 | 2019-10-18 | 平安科技（深圳）有限公司 | Service order processing method, device, computer equipment and storage medium |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113793612A (en) * | 2021-09-15 | 2021-12-14 | 京东科技信息技术有限公司 | Model service updating method and device and storage medium |
| CN113793612B (en) * | 2021-09-15 | 2024-04-09 | 京东科技信息技术有限公司 | Updating method and device of model service and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10291704B2 (en) | Networked solutions integration using a cloud business object broker | |
| US7200806B2 (en) | System and method for generating pre-populated forms | |
| US10394805B2 (en) | Database management for mobile devices | |
| CN107169094A (en) | information aggregation method and device | |
| CN111814197A (en) | Data sharing method and device, server and storage medium | |
| CN110162464A (en) | Mcok test method and system, electronic equipment and readable storage medium storing program for executing | |
| US10182104B1 (en) | Automatic propagation of resource attributes in a provider network according to propagation criteria | |
| CN109684093A (en) | Data processing method and system | |
| CN112288400A (en) | Multi-system data interaction method and device, computer equipment and storage medium | |
| CN111414369A (en) | Data processing method, device and equipment | |
| WO2023134134A1 (en) | Method and apparatus for generating association viewing model, and computer device and storage medium | |
| CN112433712A (en) | Report display method and device, computer equipment and storage medium | |
| CN105843899A (en) | Automatic big-data analysis method and system capable of simplifying programming | |
| JP2024505236A (en) | Data set multiplexer for data processing systems | |
| CN112231377A (en) | Data mapping method, system, device, server and storage medium | |
| CN109582476B (en) | Data processing method, device and system | |
| CN111488386A (en) | Data query method and device | |
| CN112491943A (en) | Data request method, device, storage medium and electronic equipment | |
| CN115857929A (en) | Resource data processing method and device, computer equipment and storage medium | |
| CN112583890B (en) | Message pushing method and device based on enterprise office system and computer equipment | |
| CN112199426B (en) | Interface call management method, device, server and medium under micro-service architecture | |
| CN114254278A (en) | User account merging method and device, computer equipment and storage medium | |
| CN110471708B (en) | Method and device for acquiring configuration items based on reusable components | |
| CN112073554A (en) | Global unique identifier generation method, device and computer readable storage medium | |
| US11803789B2 (en) | Provision of remote application action feed cards |
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 |