Data mapping method, system, device, server and storage medium
The data mapping method addresses inaccuracies in traditional systems by mapping business data to shared models using system-specific parsers, ensuring accurate and efficient data retrieval across heterogeneous business systems.
Patent Information
- Application Number
- CN202011029958.5
- Authority / Receiving Office
- CN · China
- Patent Type
- Patents(China)
- Current Assignee / Owner
- Filing Date
- 2020-09-27
- Publication Date
- 2024-12-20
- Estimated Expiration
- 2040-09-27
AI Technical Summary
Traditional data mapping methods in computer systems fail to accurately map business data due to differing definitions of fields or tables across various business systems, leading to inaccuracies in data retrieval.
A data mapping method that determines a business model and system solution corresponding to the business data, establishes a mapping relationship between the business model and system, and maps business data of the same type to a shared business model, using model parsers to handle different system types, thereby ensuring accurate data mapping across heterogeneous systems.
This approach enables accurate mapping of business data of different types, reducing resource requirements and maintaining a manageable number of business models, while ensuring data integrity and consistency across diverse business systems.
Smart Images

Figure CN112231377B_ABST
Abstract
Description
Technical Field
[0001] The present application relates to the field of computer technology, and in particular to a data mapping method, system, device, server and storage medium. Background Art
[0002] With the development of computer technology, more and more enterprises use business systems to implement their activities, such as marketing planning, sales platform, sales process management, customer service management, customer relationship management, risk prevention, storage of business data and acquisition of business data, etc. Among them, the business system refers to the business links required for the enterprise to achieve its positioning, the roles played by various partners, and the ways and contents of cooperation and transactions among stakeholders.
[0003] When a computer device needs to access a business system, it usually directly operates the database of the business system to be accessed and maps the data in the database. However, traditional data mapping methods cannot accurately map business data. Summary of the invention
[0004] Based on this, it is necessary to provide a data mapping method, system, device, server and storage medium that can accurately map business data in response to the above technical problems.
[0005] A data mapping method, the method comprising:
[0006] In response to the data mapping instruction, determine a business model and a system solution corresponding to the business model; wherein the business data of the same business type to be acquired by the data mapping instruction determine the same business model;
[0007] Determine the business system corresponding to the system solution based on the system solution; each business system corresponds to one system solution;
[0008] Acquire a mapping relationship between the business model and the business system based on the business model and the business system;
[0009] According to the mapping relationship between the business model and the business system, the business data of the business system is mapped into the business model.
[0010] In one embodiment, after determining the business model and the system solution corresponding to the business model, the method further includes:
[0011] Determining the system type of the business system based on the system solution;
[0012] The acquiring a mapping relationship between the business model and the business system based on the business model and the business system includes:
[0013] A mapping relationship between the business model and the business system is acquired based on the business model and the system type of the business system.
[0014] In one embodiment, the acquiring 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:
[0015] Determine a model parser based on the business model and the system type of the business system; the business systems of the same system type determine the same model parser;
[0016] The mapping relationship between the business model and the business system is obtained through the model parser.
[0017] In one embodiment, after mapping the business data of the business system to the business model, the process further includes:
[0018] When receiving a data request sent by a user terminal, determining target data requested by the data request;
[0019] The target data is acquired from the mapped business model, and the target data is sent to the user terminal.
[0020] In one of the embodiments, the data request includes a business model identifier and a user identifier;
[0021] The step of determining target data requested by the data request upon receiving the data request from the user terminal includes:
[0022] When receiving a data request sent by a user terminal, determining a target model from various business models based on a business model identifier included in the data request;
[0023] Based on the user identifier included in the data request, the target data requested by the user identifier is determined through the target model.
[0024] A data mapping system, the system comprising a server and a service terminal;
[0025] The server includes a business model, and the server determines the business model and the system solution corresponding to the business model in response to the data mapping instruction; wherein the business data of the same business type to be acquired by the data mapping instruction determines the same business model; the business system corresponding to the system solution is determined based on the system solution; each business system corresponds to one system solution; based on the business model and the business system, a mapping relationship between the business model and the business system is acquired; according to the mapping relationship between the business model and the business system, the business data of the business system included in the business terminal is mapped to the business model;
[0026] The business terminal includes a business system, and the business terminal obtains the business data and maps the business data to the business model included in the server through a mapping relationship between the business model and the business system.
[0027] In one of the embodiments, the system further includes a user terminal;
[0028] The user terminal obtains a data request, sends the data request to the server, and receives target data returned by the server;
[0029] The server receives the data request sent by the user terminal, determines the target data requested by the data request, obtains the target data from the mapped business model, and sends the target data to the user terminal.
[0030] A data mapping device, comprising:
[0031] A business model and system solution determination module, used to determine a business model and a system solution corresponding to the business model in response to a data mapping instruction; the business data of the same business type to be acquired in the data mapping instruction determine the same business model;
[0032] A business system and system type determination module, used to determine the business system corresponding to the system solution based on the system solution; each business system corresponds to one system solution;
[0033] A mapping relationship acquisition module, used to acquire a mapping relationship between the business model and the business system based on the business model and the system type of the business system;
[0034] A mapping module is used to map the business data of the business system to the business model according to the mapping relationship between the business model and the business system.
[0035] A server includes a memory and a processor, wherein the memory stores a computer program, and the processor implements the steps of the above method when executing the computer program.
[0036] A computer-readable storage medium stores a computer program, which implements the steps of the above method when executed by a processor.
[0037] In the above-mentioned data mapping method, system, device, server and storage medium, the business data of the same business type to be acquired by the data mapping instructions determine the same business model, that is, the business data of the same business type to be acquired by the data mapping instructions share the same business model, and then the mapping relationship between the business model and the business system is obtained based on the business model and the determined business system; according to the mapping relationship between the business model and the business system, the business data of the same business type are mapped to the same business model, the influence caused by different business systems is shielded, and the problem that different types of business data cannot be accurately mapped due to different definitions of fields or tables is avoided, and the business data of different business types can be accurately mapped, so that accurate business data can be obtained from the business model. BRIEF DESCRIPTION OF THE DRAWINGS
[0038] Figure 1 An application environment diagram of a data mapping method in an embodiment;
[0039] Figure 2 is a flow chart of a data mapping method in one embodiment;
[0040] Figure 3 is a flow chart of a data mapping method in another embodiment;
[0041] Figure 4 is a flow chart of a data mapping method in another embodiment;
[0042] Figure 5 A schematic diagram of a flow chart of a data mapping method in which the data mapping system is a single system in an embodiment;
[0043] Figure 6 is a flow chart of a data mapping method in which the data mapping system is a heterogeneous system in another embodiment;
[0044] Figure 7 is a structural block diagram of a data mapping device in one embodiment;
[0045] Figure 8 FIG. 4 is a diagram showing the internal structure of a server in one embodiment. DETAILED DESCRIPTION
[0046] In order to make the purpose, technical solution and advantages of the present application more clearly understood, the present application is further described in detail below in conjunction with the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are only used to explain the present application and are not used to limit the present application.
[0047] The data mapping method provided in this application can be applied to Figure 1 In the application environment shown. Among them, the business terminal 102 communicates with the server 104 through the network, and the user terminal 106 communicates with the server 104 through the network. The server 104 responds to the data mapping instruction to determine the business model and the system solution corresponding to the business model; the data mapping instruction determines the same business model for the business data of the same business type to be acquired; determines the business system corresponding to the system solution based on the system solution; each business system corresponds to a system solution; obtains the mapping relationship between the business model and the business system based on the business model and the business system; maps the business data of the business system included in the business terminal 102 to the business model according to the mapping relationship between the business model and the business system. Further, the user terminal 106 obtains the data request input by the user and can send the data request to the server 104. When the server 104 receives the data request sent by the user terminal 106, it determines the target data requested by the data request; obtains the target data from the mapped business model, and sends the target data to the user terminal 106. Among them, the business terminal 102 can be but is not limited to various personal computers, laptops, smart phones, tablet computers and portable wearable devices, the server 104 can be implemented by an independent server or a server cluster composed of multiple servers, and the user terminal 106 can be but is not limited to various personal computers, laptops, smart phones, tablet computers and portable wearable devices.
[0048] In one embodiment, Figure 2 As shown, a data mapping method is provided, and the data mapping method is applied to Figure 1 Taking the server in as an example, the following steps are included:
[0049] Step 202, in response to obtaining the data mapping instruction, determining the business model and the system solution corresponding to the business model; wherein the business data of the same business type to be obtained by the data mapping instruction determine the same business model.
[0050] The business model is used to define the business data template. The business model includes one or at least two business model bodies and the relationship between business model bodies. The business model body refers to the attribute information of the business data. The business model body may include the fields of specific business data, field types and other information. The business model may also include the identification of the business model, the name of the business model and other information. The business model is stored in the server. The business model may be a sales business model, a procurement business model, etc.
[0051] A field represents a variable associated with an object or class. In a database, a table's "columns" are called "fields", and each field contains information about a specific topic. For example, in the "Address Book" database, "Name" and "Contact Number" are attributes common to all rows in the table, so these columns are called "Name" and "Contact Number". Field type refers to the type of field. Field types include binary data types, character data types, date and time data types, numeric data types, currency data types, special data types, and so on.
[0052] The system solution refers to the solution for connecting the server to the business system. The system solution may include, but is not limited to, the address of the business system, the type of the business system, the name of the system solution, the brand of the business system, the product name of the business system, the product version of the business system, and the database information of the business system (database type, address, port, user name, password, account set, etc.).
[0053] For example, the system solution 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 SQL Server.
[0054] Business systems refer to the business links required for an enterprise to achieve its positioning, the roles played by various partners, and the ways and contents of cooperation and transactions among stakeholders. Business data refers to data from business systems. Business systems include ERP (Enterprise Resource Planning) systems, MES (manufacturing enterprise production execution management system), WMS (Warehouse Management System), etc. The number of business systems can be one or at least two. The architecture of each business system can be the same or different.
[0055] The data to be acquired by the data mapping instruction may be business data in one business system or business data in at least two business systems. The data to be acquired by the data mapping instruction may be business data of the same business type or business data of different business types.
[0056] The business data of the same business type to be acquired in the data mapping instruction determine the same business model, that is, the business data of the same business type are all mapped to the same business model. For example, the business data to be acquired in the data mapping instruction includes business data of business type A and business data of business type B, the business data of business type A to be acquired determine the same business model X, and the business data of business type B to be acquired determine the same business model Y, then the business data of business type A are all mapped to business model X, and the business data of business type B are all mapped to business model Y.
[0057] Specifically, the server pre-sets a preset time length, generates a data mapping instruction at each preset time length interval, and determines a business model and a system solution corresponding to the business model in response to the data mapping instruction. The preset time length, such as 3 minutes, 5 minutes, etc., can be set as needed.
[0058] In another embodiment, when a preset operation is detected, a data mapping instruction is generated; in response to the data mapping instruction, a business model and a system solution corresponding to the business model are determined. The preset operation may be click, double-click, slide, voice input, pressing of a physical button, etc.
[0059] Step 204, determining the business system corresponding to the system solution based on the system solution; each business system corresponds to one system solution.
[0060] Each business system corresponds to a system solution. For example, business system A1 corresponds to system solution B1, business system A2 corresponds to system solution B2, and business system A3 corresponds to system solution B3.
[0061] The system solution refers to the solution for connecting the server to the business system. The system solution may include, but is not limited to, the address of the business system, the type of the business system, the name of the system solution, the brand of the business system, the product name of the business system, the product version of the business system, and the database information of the business system (database type, address, port, user name, password, account set, etc.). The system solution may be stored in the server.
[0062] The system solution includes the identification of the business system. Specifically, the server obtains the identification of the business system from the system solution, and finds the corresponding business system according to the identification of the business system. The identification of the business system is unique, and the business system can be found uniquely. The identification of the business system can be a network address, an icon, a string, etc.
[0063] For example, the business system is identified by the network address http: / / 192.168.x.xxx, and the business system can be found according to the network address, so that the data in the business system can be accessed.
[0064] Step 206: Acquire a mapping relationship between the business model and the business system based on the business model and the business system.
[0065] The mapping relationship between the business model and the business system refers to the relationship between the business data in the business system and the business model.
[0066] It is understandable that the attributes of the business data defined in the business system are different from the attributes of the business data defined in the business model, so it is necessary to obtain the mapping relationship between the business model and the business system, and map the business data in the business system to the template of the business model through the mapping relationship between the business model and the business system.
[0067] Specifically, a model parser is obtained based on the business model and the business system, and a mapping relationship between the business model and the business system is obtained from the model parser.
[0068] The model parser is a parsing program for the mapping relationship between the business model and the business system, and the mapping relationship between the business model and the business system can be obtained from the model parser. For example, the model parser can be an ERP (Enterprise Resource Planning) connector, a CRM (Customer Relationship Management) connector, an OA (Office Automation) connector, etc. For example, if the model parser is K / 3Wise, the mapping relationship between the business model and the K / 3Wise ERP business system can be obtained.
[0069] Step 208 : Map the business data of the business system into the business model according to the mapping relationship between the business model and the business system.
[0070] The server obtains the business data required by the data mapping instruction from the database of the business system according to the mapping relationship between the business model and the business system, and maps the obtained business data to the business model. The business data obtained by the server can be stored on disk.
[0071] In another embodiment, the server may also call an API (Application Programming Interface) of the business system, obtain the business data to be obtained by the data mapping instruction through the API of the business system, and map the obtained business data into the business model.
[0072] For example, the server includes business model M and business model N. Business model M corresponds to system solution 1 and system solution 2. System solution 1 corresponds to business system X1, system solution 2 corresponds to business system X2, business model N corresponds to system solution 3, and system solution 3 corresponds to business system Y1. The server obtains the mapping relationship between business model M and business system X1 as X, the mapping relationship between business model M and business system X2 as X, and the mapping relationship between business model N and business system Y1 as Y. Then the server can map the business data of business system X1 to business model M according to mapping relationship X, map the business data of business system X2 to business model M according to mapping relationship X, and map the business data of business system Y1 to business model N according to mapping relationship Y.
[0073] In the above-mentioned data mapping method, the data mapping instructions determine the same business model for the business data of the same business type to be acquired, that is, the business data of the same business type to be acquired by the data mapping instructions share the same business model, and then obtain the mapping relationship between the business model and the business system based on the business model and the determined business system; according to the mapping relationship between the business model and the business system, the business data of the same business type are mapped to the same business model, which shields the influence of different business systems and avoids the problem that different types of business data cannot be accurately mapped due to different definitions of fields or tables. It can achieve accurate mapping of business data of different business types, so that accurate business data can be obtained from the business model.
[0074] The data mapping instruction determines the same business model for the business data of the same business type to be acquired, and each business type corresponds to a business model. The number and scale of business models are controllable, and only a small number of business models need to be maintained, saving manpower and material resources, and also saving maintenance resources.
[0075] In one embodiment, Figure 3 As shown, after determining the business model and the system solution corresponding to the business model, it also includes:
[0076] Step 302: determine the system type of the business system based on the system solution.
[0077] System type refers to the type of business system. The system type can be one of ERP (Enterprise Resource Planning) system, CRM (Customer Relationship Management) system, OA (Office Automation) system, production management software system, purchase and sales management software system, etc.
[0078] The system type of the business system may be pre-configured in the system solution, and the server may obtain the system type of the business system from the system solution.
[0079] Based on the business model and the business system, the mapping relationship between the business model and the business system is obtained, including:
[0080] Step 304 : Acquire a mapping relationship between the business model and the business system based on the system type of the business model and the business system.
[0081] It is understandable that the tables and fields defined in business systems of different system types are not the same. Therefore, the business systems are further divided according to the system type. Based on the business model and the system type of the business system, a more accurate mapping relationship between the business model and the business system can be obtained, so that the business data of the business system of a specific system type can be mapped to the business model through this mapping relationship.
[0082] Specifically, the mapping relationship between the business model and the business system is obtained based on the system type of the business model and the business system, including: determining a model parser based on the system type of the business model and the business system; business systems of the same system type determine the same model parser; and obtaining the mapping relationship between the business model and the business system through the model parser.
[0083] The model parser is a parsing program for the mapping relationship between the business model and the business system. The mapping relationship between the business model and the business system can be obtained from the model parser. For example, the model parser can be an ERP (Enterprise Resource Planning) connector, a CRM (Customer Relationship Management) connector, an OA (Office Automation) connector, etc. The model parser stores the mapping relationship between the business model body and fields of the business model and the tables and fields of the specified business system.
[0084] It is understandable that the definitions of tables and fields are different for business systems of different system types. Therefore, business systems of the same system type determine the same model parser. The model parser can more accurately obtain the mapping relationship between the business model and the business system of the specific system type, thereby more accurately mapping the business data of the business system of the specific system type to the business model.
[0085] For example, the system type of business system X1 is X, and the system type of business system X2 is also X. Then, the model parser X is determined based on the business model M and business system X1, and the model parser X is determined based on the business model M and business system X2. That is, the same model parser X is determined for the same system type X. Then, the business data of business system X1 is mapped to the business model through model parser X, and the business data of business system X2 is mapped to the business model through model parser X.
[0086] In this embodiment, the model parser is determined based on the business model and the system type of the business system; the business systems of the same system type determine the same model parser; a more accurate mapping relationship between the business model and the business system can be obtained through the model parser, so as to more accurately map the business data of the business system of a specific system type to the business model. Furthermore, the server separates the business model and the model parser corresponding to the specific system type, simplifying the complexity of the data mapping system. The business model and the model parser are involved separately, which is also convenient for large-scale promotion to other business systems. When business systems of different system types are added, new model parsers can be added to achieve data mapping.
[0087] In another embodiment, the server may also jointly determine the model parser based on the business model, the system type of the business system, the brand of the business system, the product name of the business system, the product version of the business system, and the database type of the business system.
[0088] For example, if the business system supports two databases, SQL Server and Oracle, one model parser can be determined based on the business model and SQL Server, and the other model parser can be determined based on the business model and Oracle.
[0089] In one embodiment, Figure 4 As shown, after mapping the business data of the business system to the business model, it also includes:
[0090] Step 402: When a data request sent by a user terminal is received, target data requested by the data request is determined.
[0091] The user terminal is the terminal where the user is located, which can be, but is not limited to, various personal computers, laptops, smart phones, tablet computers, and portable wearable devices. Data request refers to the instruction to request data. The data request may include the device identification of the user terminal, the user identification, the requested service data identification, the service type of the requested service data, the service system where the requested service data is located, etc. The target data refers to the service data requested by the data request.
[0092] The data request includes an identifier of the requested target data. The server may obtain the identifier of the requested target data from the data request, thereby determining the target data requested by the data request.
[0093] The user terminal generates a data request in response to a preset operation and sends the data request to the server. When the server receives the data request sent by the user terminal, it determines the target data requested by the data request. The preset operation may be a click, a double click, a slide, a voice input, a physical button press, etc.
[0094] Step 404: Acquire target data from the mapped business model and send the target data to the user terminal.
[0095] After the server maps the business data of the business system to the business model, the business model includes the business data of the business system. The server obtains the target data from the mapped business model and sends the target data to the user terminal.
[0096] In this embodiment, when a data request is received from a user terminal, the target data requested by the data request is determined; the target data is obtained from the mapped business model, and the target data is sent to the user terminal, so that the user terminal can obtain the business data of the business system.
[0097] In one embodiment, a data request includes a business model identifier and a user identifier; when a data request sent by a user terminal is received, target data requested by the data request is determined, including: when a data request sent by a user terminal is received, based on the business model identifier included in the data request, a target model is determined from various business models; based on the user identifier included in the data request, the target data requested by the user identifier is determined through the target model.
[0098] The business model identifier refers to the identifier of the business model. The user identifier refers to the identifier of the user. The user identifier can be the name of the user, the icon of the user, the identifier of the device where the user is located, the address of the device where the user is located, etc. The target model refers to the business model determined by the data request.
[0099] It is understandable that the server may include one or at least two business models. When the server receives a data request sent by a user terminal, it determines the target model from various business models based on the business model identifier included in the data request.
[0100] In each business model of the server, there is a corresponding storage set. The storage set is used to store business data in the business model. In the storage set, business data corresponding to each user identifier is pre-stored. The server can determine the business data corresponding to the user identifier from the storage set based on the user identifier included in the data request, and the business data is the target data requested by the user identifier.
[0101] In this embodiment, when a data request sent by a user terminal is received, the target model is determined from various business models based on the business model identifier included in the data request, and then based on the user identifier included in the data request, the target data requested by the user identifier can be accurately determined through the target model.
[0102] In one embodiment, a data mapping system is provided, characterized in that the system includes a server and a business terminal; the server includes a business model, and the server determines the business model and the system solution corresponding to the business model in response to a data mapping instruction; the business data of the same business type to be acquired by the data mapping instruction determine the same business model; the business system corresponding to the system solution is determined based on the system solution; each business system corresponds to a system solution; based on the business model and the business system, a mapping relationship between the business model and the business system is acquired; according to the mapping relationship between the business model and the business system, the business data of the business system is mapped to the business model; the business terminal includes the business system, and the business terminal acquires the business data, and maps the business data to the business model through the mapping relationship between the business model and the business system.
[0103] The business terminal refers to the terminal where the business system is located. The server and the business terminal can communicate through the network. The server includes a business model, and can also store the mapping relationship between the system solution, the business model and the business system. The server may include one or at least two business models, and the business type of the data mapped in each business model is the same, that is, the business data of the same business type to be acquired by the data mapping instruction determines the same business model.
[0104] The above-mentioned data mapping system includes a server and a business terminal. The business data of the same business type to be acquired by the data mapping instructions determine the same business model, that is, the business data of the same business type to be acquired by the data mapping instructions share the same business model, and then the mapping relationship between the business model and the business system is obtained based on the business model and the determined business system; according to the mapping relationship between the business model and the business system, the business data of the same business type are mapped to the same business model, which shields the influence of different business systems and avoids the problem that different types of business data cannot be accurately mapped due to different definitions of fields or tables. It can achieve accurate mapping of business data of different business types, so that accurate business data can be obtained from the business model.
[0105] In one embodiment, after determining the business model and the system solution corresponding to the business model, it also includes: determining the system type of the business system based on the system solution; obtaining the mapping relationship between the business model and the business system based on the business model and the business system, including: 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.
[0106] In one embodiment, a mapping relationship between a business model and a business system is obtained based on the system type of the business model and the business system, including: determining a model parser based on the system type of the business model and the business system; business systems of the same system type determine the same model parser; and obtaining a mapping relationship between a business model and a business system through a model parser.
[0107] In one embodiment, the above-mentioned data mapping system also includes a user terminal; the user terminal obtains a data request, sends the data request to a server, and receives target data returned by the server; the server receives the data request sent by the user terminal, determines the target data requested by the data request; obtains the target data from the business model after mapping, and sends the target data to the user terminal.
[0108] The user terminal refers to the terminal where the user identification is located. The data mapping system can 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. A heterogeneous system means that the data mapping system includes at least two business systems with different architectures.
[0109] In another embodiment, the data mapping system is a single system, including an application terminal, a server and a business terminal, wherein the business terminal includes a business system. The user terminal may include an application program, which receives a data request input by a user through the application program and sends the data request to the server. The application program may be a WEB application.
[0110] In one embodiment, Figure 5 As shown, 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 application terminals can be one or at least two, and the number of service terminals can also be one or at least two.
[0111] In response to the data mapping instruction, the server determines the business model M and the system solution 1 corresponding to the business model M, and determines the business system X1 corresponding to the system solution 1 based on the system solution 1. The system solution 1 is also configured with the system type of the business system X1.
[0112] The server determines the model parser X based on the business model M and the system type of the business system X1, and can obtain the mapping relationship between the business model M and the business system X1 from the model parser X. The server obtains business data from the found business system X1 through the model parser X. The server maps the obtained business data to the business model.
[0113] Application A in the user terminal receives the data request input by the user and sends the data request to the server. Based on the data request, the server determines the target data requested by the data request from the data model M and sends the target data to application A in the application terminal.
[0114] In one embodiment, Figure 6 As shown, the data mapping system is a heterogeneous system, including application terminals, servers and service terminals, and the service terminals include three service systems. It should be noted that the number of application terminals can be one or at least two, and the number of service terminals can also be one or at least two.
[0115] In response to the data mapping instruction, the server determines the business model M and the system solutions 1, 2, and 3 corresponding to the business model M. Based on the system solution 1, the business system X1 corresponding to the system solution 1 is determined, and the system solution 1 is also configured with the system type of the business system X1. Based on the system solution 2, the business system X2 corresponding to the system solution 2 is determined, and the system solution 2 is also configured with the system type of the business system X2. Based on the system solution 3, the business system Y corresponding to the system solution 3 is determined, and the system solution 3 is also configured with the system type of the business system Y. The system type of the business system X1 is the same as the system type of the business system X2.
[0116] The server determines the model parser X based on the business model M and the system type of the business system X1, and determines the model parser X based on the business model M and the system type of the business system X2. Business systems of the same system type determine the same model parser.
[0117] The server can obtain the mapping relationship between the business model M and the business system X1, and the mapping relationship between the business model M and the business system X2 from the model parser X. The server obtains the business data from the business system X1 found through the model parser X. The server obtains the business data from the business system X2 found through the model parser X.
[0118] The server determines the model parser Y based on the business model M and the system type of the business system Y. The server can obtain the mapping relationship between the business model M and the business system Y from the model parser Y. The server obtains the business data from the found business system Y through the model parser Y. The server maps the business data to the business model M.
[0119] Application A in the user terminal receives the data request input by the user and sends the data request to the server. Based on the data request, the server determines the target data requested by the data request from the data model M and sends the target data to application A in the application terminal.
[0120] Application B in the user terminal receives the data request input by the user and sends the data request to the server. Based on the data request, the server determines the target data requested by the data request from the data model M and sends the target data to application B in the application terminal.
[0121] It should be understood that although Figure 2-Figure 4 The steps in the flowchart are shown in sequence as indicated by the arrows, but these steps are not necessarily executed in the order indicated by the arrows. Unless otherwise specified in this document, there is no strict order restriction for the execution of these steps, and these steps can be executed in other orders. Moreover, Figure 2-Figure 4 At least part of the steps may include multiple steps or multiple stages. These steps or stages are not necessarily performed at the same time, but can be performed at different times. The execution order of these steps or stages is not necessarily sequential, but can be performed in turn or alternately with other steps or at least part of the steps or stages in other steps.
[0122] In one embodiment, Figure 7 As shown, a data mapping device 700 is provided, comprising: a business model and system solution determination module 702, a business system and system type determination module 704, a mapping relationship acquisition module 706 and a mapping module 708, wherein:
[0123] The business model and system solution determination module 702 is used to determine the business model and the system solution corresponding to the business model in response to the data mapping instruction; the business data of the same business type to be acquired in the data mapping instruction determine the same business model.
[0124] The business system and system type determination module 704 is used to determine the business system corresponding to the system solution based on the system solution; each business system corresponds to one system solution.
[0125] The mapping relationship acquisition module 706 is used to acquire the mapping relationship between the business model and the business system based on the system type of the business model and the business system.
[0126] The mapping module 708 is used to map the business data of the business system into the business model according to the mapping relationship between the business model and the business system.
[0127] In the above-mentioned data mapping device, the business data of the same business type to be acquired by the data mapping instructions determine the same business model, that is, the business data of the same business type to be acquired by the data mapping instructions share the same business model, and then obtain the mapping relationship between the business model and the business system based on the business model and the determined business system; according to the mapping relationship between the business model and the business system, the business data of the same business type are mapped to the same business model, which shields the influence of different business systems and avoids the problem that different types of business data cannot be accurately mapped due to different definitions of fields or tables. It can achieve accurate mapping of business data of different business types, so that accurate business data can be obtained from the business model.
[0128] In one embodiment, the data mapping device further includes a system type determination module for determining the system type of the business system based on the system solution; the mapping relationship acquisition module 706 is further used to acquire the mapping relationship between the business model and the business system based on the system type of the business model and the business system.
[0129] In one embodiment, the mapping relationship acquisition module 706 is also used to determine the model parser based on the business model and the system type of the business system; business systems of the same system type determine the same model parser; and obtain the mapping relationship between the business model and the business system through the model parser.
[0130] In one embodiment, the data mapping device further includes a data request module for determining target data requested by the data request when receiving a data request sent by a user terminal; obtaining the target data from the mapped business model, and sending the target data to the user terminal.
[0131] In one embodiment, the data request includes a business model identifier and a user identifier; the above-mentioned data request module is also used to determine the target model from various business models based on the business model identifier included in the data request when receiving the data request sent by the user terminal; based on the user identifier included in the data request, determine the target data requested by the user identifier through the target model.
[0132] For the specific definition of the data mapping device, please refer to the definition of the data mapping method above, which will not be repeated here. Each module in the above-mentioned data mapping device can be implemented in whole or in part by software, hardware and a combination thereof. Each of the above-mentioned modules can be embedded in or independent of the processor in the server in the form of hardware, or can be stored in the memory in the server in the form of software, so that the processor can call and execute the operations corresponding to each of the above modules.
[0133] In one embodiment, a server is provided, whose internal structure diagram can be as follows: Figure 8 As shown. The server includes a processor, a memory and a network interface connected through a system bus. Among them, the processor of the server is used to provide computing and control capabilities. The memory of the server includes a non-volatile 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 the operating system and the computer program in the non-volatile storage medium. The database of the server is used to store business data, system solutions and other data. The network interface of the server is used to communicate with an external terminal through a network connection. When the computer program is executed by the processor, a data mapping method is implemented.
[0134] Those skilled in the art will understand that Figure 8 The structure shown in the figure is only a block diagram of a partial structure related to the solution of the present application, and does not constitute a limitation on the server to which the solution of the present application is applied. The specific server may include more or fewer components than shown in the figure, or combine certain components, or have a different component arrangement.
[0135] In one embodiment, a server is further provided, including a memory and a processor, wherein a computer program is stored in the memory, and the processor implements the steps in the above-mentioned method embodiments when executing the computer program.
[0136] In one embodiment, a computer-readable storage medium is provided, on which a computer program is stored. When the computer program is executed by a processor, the steps in the above-mentioned method embodiments are implemented.
[0137] Those of ordinary skill in the art can understand that all or part of the processes in the above-mentioned embodiment methods can be completed by instructing the relevant hardware through a computer program, and the computer program can be stored in a non-volatile computer-readable storage medium. When the computer program is executed, it can include the processes of the embodiments of the above-mentioned methods. Among them, any reference to memory, storage, database or other media used in the embodiments provided in this application can include at least one of non-volatile and volatile memory. Non-volatile memory can include read-only memory (ROM), magnetic tape, floppy disk, flash memory or optical memory, etc. Volatile memory can include random access memory (RAM) or external cache memory. As an illustration and not limitation, RAM can be in various forms, such as static random access memory (SRAM) or dynamic random access memory (DRAM).
[0138] The technical features of the above embodiments may be combined arbitrarily. To make the description concise, not all possible combinations of the technical features in the above embodiments are described. However, as long as there is no contradiction in the combination of these technical features, they should be considered to be within the scope of this specification.
[0139] The above-mentioned embodiments only express several implementation methods of the present application, and the descriptions thereof are relatively specific and detailed, but they cannot be understood as limiting the scope of the invention patent. It should be pointed out that, for a person of ordinary skill in the art, several variations and improvements can be made without departing from the concept of the present application, and these all belong to the protection scope of the present application. Therefore, the protection scope of the patent of the present application shall be subject to the attached claims.
Claims
1. A data mapping method, It is characterized in that The method comprises: In response to the data mapping instruction, determine the business model and the system solution corresponding to the business model; wherein the business data of the same business type to be acquired by the data mapping instruction determine the same business model, and the system solution refers to the solution of connecting the server to the business system; Determining the system type of the business system based on the system solution; Determine the business system corresponding to the system solution based on the system solution; each business system corresponds to one system solution; Determine a model parser based on the business model and the system type of the business system; the business systems of the same system type determine the same model parser, and the model parser is a parsing program for the mapping relationship between the business model and the business system; Acquire the mapping relationship between the business model and the business system through the model parser; According to the mapping relationship between the business model and the business system, mapping the business data of the business system to the business model; When receiving a data request sent by a user terminal, determining a target model from various business models based on a business model identifier included in the data request; Based on the user identifier included in the data request, determining the target data requested by the user identifier through the target model; The target data is acquired from the mapped business model, and the target data is sent to the user terminal.
2. The method according to claim 1, It is characterized in that The determining, based on the system solution, a business system corresponding to the system solution includes: The identification of the business system is obtained from the system solution, and the business system corresponding to the system solution is found according to the identification of the business system.
3. The method according to claim 1, It is characterized in that Mapping the business data of the business system to the business model according to the mapping relationship between the business model and the business system includes: According to the mapping relationship between the business model and the business system, the business data to be acquired by the data mapping instruction is acquired from the database of the business system, and the business data is mapped to the business model.
4. The method according to claim 3, It is characterized in that The method further comprises: Store the acquired business data to disk.
5. A data mapping system, It is characterized in that The system includes a server, a service terminal and a user terminal; The server includes a business model, and the server determines the business model and a system solution corresponding to the business model in response to a data mapping instruction; the business data of the same business type to be acquired by the data mapping instruction determine the same business model, and the system solution refers to a solution for connecting the server to the business system; Determining the system type of the business system based on the system solution; Determine the business system corresponding to the system solution based on the system solution; each business system corresponds to one system solution; Determine a model parser based on the business model and the system type of the business system; the business systems of the same system type determine the same model parser, and the model parser is a parsing program for the mapping relationship between the business model and the business system; Acquire a mapping relationship between the business model and the business system through the model parser; map the business data of the business system included in the business terminal to the business model according to the mapping relationship between the business model and the business system; The business terminal includes a business system, the business terminal obtains the business data, and maps the business data to the business model included in the server through a mapping relationship between the business model and the business system; The user terminal obtains a data request, sends the data request to the server, and receives target data returned by the server; The server receives the data request sent by the user terminal, determines the target model from various business models based on the business model identifier included in the data request; determines the target data requested by the user identifier through the target model based on the user identifier included in the data request; obtains the target data from the business model after mapping, and sends the target data to the user terminal.
6. A data mapping device, It is characterized in that The device comprises: A business model and system solution determination module, used to determine a business model and a system solution corresponding to the business model in response to a data mapping instruction; wherein the business data of the same business type to be acquired by the data mapping instruction determine the same business model, and the system solution refers to a solution for connecting a server to a business system; A system type determination module, used to determine the system type of the business system based on the system solution; A business system and system type determination module, used to determine the business system corresponding to the system solution based on the system solution; each business system corresponds to one system solution; A mapping relationship acquisition module, used to determine a model parser based on the business model and the system type of the business system; the business systems of the same system type determine the same model parser, and the model parser is a parsing program for the mapping relationship between the business model and the business system; the mapping relationship between the business model and the business system is acquired through the model parser; A mapping module, used to map the business data of the business system to the business model according to the mapping relationship between the business model and the business system; A data request module is used to, when receiving a data request sent by a user terminal, determine a target model from various business models based on the business model identifier included in the data request; determine the target data requested by the user identifier through the target model based on the user identifier included in the data request; obtain the target data from the mapped business model, and send the target data to the user terminal.
7. The device according to claim 6, It is characterized in that The business system and system type determination module is further used to obtain the identification of the business system from the system solution, and find the business system corresponding to the system solution according to the identification of the business system.
8. The device according to claim 6, It is characterized in that The mapping module is further used to obtain the business data to be obtained by the data mapping instruction from the database of the business system according to the mapping relationship between the business model and the business system, and map the business data to the business model.
9. A server comprising a memory and a processor, wherein the memory stores a computer program. It is characterized in that When the processor executes the computer program, the steps of the method according to any one of claims 1 to 4 are implemented.
10. A computer-readable storage medium having a computer program stored thereon, It is characterized in that When the computer program is executed by a processor, the steps of the method according to any one of claims 1 to 4 are implemented.
