Data processing method and device, equipment and storage medium

Abstract

The invention relates to the technical field of big data processing, in particular to a data processing method and device, equipment and a storage medium. Extracting object data; according to a first preset dictionary table and the field coding value, determining whether the object data is business data of the current business system; if not, obtaining a target dictionary coding value according to the global dictionary mapping table and the field coding value; generating object conversion data according to the target dictionary coding value and the field data value, and performing first data operation on the object conversion data according to a first preset dictionary table; through the setting of the first preset dictionary table and the global dictionary mapping table, the coding value of the business object by other business systems can be directly converted into the coding value of the business object by the current business system based on the global dictionary mapping table, and then the converted data is continuously processed based on the first preset dictionary table. And different service systems have compatibility, so that the data processing efficiency can be improved.

Description

Technical Field

[0001] The present application relates to the field of big data processing technology, and in particular to a data processing method, device, equipment and storage medium. Background Art

[0002] In the process of business data processing, in order to ensure the consistency of business data, business objects that are not universal, such as business-related proper nouns, abbreviations, business status codes, etc., will be encoded. Through the above method, a unified code is used within the business system to represent a certain business object, providing strong support for the normal operation of the business system.

[0003] At present, different business systems may use different encoding methods to encode the same business object. When the current business system needs to use the business data of at least one other business system for business data processing, a business object has at least two business codes and data parsing cannot be performed. Other business systems are required to first parse the business code into a business object and then send the business data to the current business system for processing to ensure accurate data parsing. The above method is not conducive to improving data processing efficiency. Summary of the invention

[0004] In view of the above problems, the embodiments of the present application provide a data processing method, apparatus, device and storage medium to solve the above technical problems that are not conducive to improving data processing efficiency.

[0005] In a first aspect, an embodiment of the present application provides a data processing method, including:

[0006] Acquire a data processing instruction, the data processing instruction being used to request a first data operation to be performed on at least one object data in a database, the object data comprising a field code value and a field data value;

[0007] extracting the at least one object data from the database according to the data processing instruction;

[0008] Determine whether the object data is business data of the current business system according to a first preset dictionary table and the field code value; the first preset dictionary table includes a first dictionary code value of each business object in the current business system and description information of the business object;

[0009] When the determination result is no, obtaining the target dictionary code value according to the global dictionary mapping table and the field code value; the global dictionary mapping table includes first dictionary code values ​​of multiple business objects in the current business system and at least one second dictionary code value mapped to the first dictionary code value, the second dictionary code value being the dictionary code value of the business object in other business systems;

[0010] Object conversion data is generated according to the target dictionary code value and the field data value, and the first data operation is performed on the object conversion data according to the first preset dictionary table.

[0011] Optionally, after determining whether the object data is business data of the current business system according to the first preset dictionary table and the field code value, the method further includes:

[0012] When the determination result is yes, the first data operation is performed on the object data according to the first preset dictionary table.

[0013] Optionally, the first preset dictionary table further includes a dictionary type code and description information of the dictionary type code, and the dictionary type code is mapped to at least one of the first dictionary code values;

[0014] The performing the first data operation on the object conversion data according to the first preset dictionary table includes:

[0015] Acquire, from the first preset dictionary table, description information of the first dictionary code value that matches the target dictionary code value of the object conversion data and description information of the dictionary type code;

[0016] Determine the first target field of the object conversion data in the first data table according to the obtained description information of the first dictionary encoding value and the description information of the dictionary type encoding, and write the field data value of the object conversion data into the row or column where the first target field is located.

[0017] Optionally, the data processing instruction includes a structured query language SQL statement; and extracting the at least one object data from the database according to the data processing instruction includes:

[0018] generating an execution instruction according to the structured query language SQL statement, and extracting the at least one object data from the database according to the execution instruction;

[0019] Correspondingly, performing the first data operation on the object conversion data according to the first preset dictionary table includes:

[0020] Acquire, from the first preset dictionary table, description information of the first dictionary code value that matches the target dictionary code value of the object conversion data and description information of the dictionary type code;

[0021] Determine a second target field of the object conversion data in the second data table according to the acquired description information of the first dictionary encoding value and the description information of the dictionary type encoding;

[0022] Extracting a first target data value matching the field data value of the object conversion data in the row or column where the second target field is located;

[0023] At least one second target data value associated with the first target data value is obtained from the second data table, the at least one second target data value is used as a query result, and the query result is returned to the sender of the data processing instruction.

[0024] Optionally, determining whether the object data is business data of a current business system according to the first preset dictionary table and the field code value includes:

[0025] Compare the field code value with a plurality of the first dictionary code values ​​in the first preset dictionary table respectively;

[0026] When there is no first dictionary code value matching the field code value, determining that the object data is not business data of the current business system;

[0027] When there is the first dictionary code value matching the field code value, it is determined that the object data is business data of the current business system.

[0028] Optionally, acquiring the target dictionary code value according to the global dictionary mapping table and the field code value includes:

[0029] Compare the field code value with a plurality of the second dictionary code values ​​in the global dictionary mapping table respectively;

[0030] The second dictionary code value matching the field code value is obtained according to the comparison result, and the first dictionary code value mapped to the second dictionary code value is used as the target dictionary code value.

[0031] Optionally, the step of constructing the global dictionary mapping table includes:

[0032] Acquire the first preset dictionary table of the current business system and a second preset dictionary table of at least one other business system, wherein the second preset dictionary table includes a second dictionary code value of each business object in the other business system and description information of the business object;

[0033] Matching the description information of the business object in the first preset dictionary table with the description information of the business object in the second preset dictionary table, and acquiring the target business object existing in the first preset dictionary table and the second preset dictionary table respectively;

[0034] The global dictionary mapping table is constructed according to the first dictionary encoding value, the second dictionary encoding value and the description information of the target business object.

[0035] In a second aspect, an embodiment of the present application provides a data processing device, including:

[0036] An instruction receiving module, used for acquiring a data processing instruction, wherein the data processing instruction is used for requesting a first data operation to be performed on at least one object data in a database, wherein the object data includes a field code value and a field data value;

[0037] a data acquisition module, configured to extract the at least one object data from the database according to the data processing instruction;

[0038] A judgment module, used to determine whether the object data is business data of the current business system according to a first preset dictionary table and the field code value; the first preset dictionary table includes a first dictionary code value of each business object in the current business system and description information of the business object;

[0039] a dictionary mapping module, configured to obtain a target dictionary code value according to a global dictionary mapping table and the field code value when the determination result is no; the global dictionary mapping table includes first dictionary code values ​​of multiple business objects in the current business system and at least one second dictionary code value mapped to the first dictionary code value, the second dictionary code value being a dictionary code value of the business object in other business systems;

[0040] A data operation module is used to generate object conversion data according to the target dictionary code value and the field data value, and perform the first data operation on the object conversion data according to the first preset dictionary table.

[0041] In a third aspect, an embodiment of the present application provides a computer device, the device comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus;

[0042] Memory, used to store computer programs;

[0043] The processor is used to implement the steps of the above-mentioned data processing method when executing the program stored in the memory.

[0044] In a fourth aspect, an embodiment of the present application provides a computer-readable storage medium having a computer program stored thereon, wherein the computer program implements the steps of the above-mentioned data processing method when executed by a processor.

[0045] The data processing method, apparatus, device and storage medium provided by the embodiments of the present application obtain a data processing instruction, wherein the data processing instruction is used to request a first data operation to be performed on at least one object data in a database, wherein the object data includes a field code value and a field data value; according to the data processing instruction, the at least one object data is extracted from the database; according to a first preset dictionary table and the field code value, it is determined whether the object data is business data of the current business system; the first preset dictionary table includes a first dictionary code value of each business object in the current business system and description information of the business object; when the determination result is no, a target dictionary code value is obtained according to a global dictionary mapping table and the field code value; the global dictionary mapping table includes when The first dictionary code value of multiple business objects in the current business system and at least one second dictionary code value mapped to the first dictionary code value, the second dictionary code value is the dictionary code value of the business object in other business systems; object conversion data is generated according to the target dictionary code value and the field data value, and the first data operation is performed on the object conversion data according to the first preset dictionary table; through the setting of the first preset dictionary table and the global dictionary mapping table, the code value of the business object in other business systems can be directly converted into the code value of the business object in the current business system based on the global dictionary mapping table, and then the converted data is further processed based on the first preset dictionary table, so that different business systems are compatible, which is conducive to improving data processing efficiency.

[0046] These and other aspects of the present application will become more clearly understood in the description of the following embodiments. BRIEF DESCRIPTION OF THE DRAWINGS

[0047] Figure 1 A flow chart of a data processing method provided in an embodiment of the present application is shown.

[0048] Figure 2 A schematic diagram of the structure of a data processing device provided in one embodiment of the present application is shown.

[0049] Figure 3 A schematic diagram of the structure of a computer device provided in one embodiment of the present application is shown.

[0050] Figure 4 A schematic diagram of the structure of a computer-readable storage medium provided in one embodiment of the present application is shown. DETAILED DESCRIPTION

[0051] The embodiments of the present application are described in detail below, and examples of the embodiments are shown in the accompanying drawings, wherein the same or similar reference numerals throughout represent the same or similar elements or elements having the same or similar functions. The embodiments described below with reference to the accompanying drawings are exemplary and are only used to explain the present application, and cannot be understood as limiting the present application.

[0052] In order to enable those skilled in the art to better understand the solutions of the present application, the technical solutions in the embodiments of the present application will be clearly and completely described below in conjunction with the drawings in the embodiments of the present application. Obviously, the described embodiments are only part of the embodiments of the present application, rather than all of the embodiments. Based on the embodiments in the present application, all other embodiments obtained by those skilled in the art without making creative work are within the scope of protection of the present application.

[0053] In the embodiments of the present application, it should be noted that, in this article, relational terms such as first and second, etc. are merely used to distinguish one entity or operation from another entity or operation, and do not necessarily require or imply any actual relationship or order between these entities or operations.

[0054] Moreover, the terms "comprises," "comprising," or any other variation thereof are intended to encompass non-exclusive inclusion, such that a process, method, article, or apparatus that includes a list of elements includes not only those elements, but also other elements not explicitly listed, or elements inherent to such process, method, article, or apparatus. In the absence of further limitations, an element defined by the phrase "comprising a ..." does not exclude the presence of additional identical elements in the process, method, article, or apparatus that includes the element.

[0055] In the description of the embodiments of the present application, words such as "example" or "for example" are used to indicate examples, illustrations or descriptions. Any embodiment or design described as "example" or "for example" in the embodiments of the present application is not to be interpreted as being more preferred or having more advantages than another embodiment or design. The use of words such as "example" or "for example" is intended to present relative concepts in a clear manner.

[0056] In addition, the "plurality" in the embodiments of the present application refers to two or more than two. In view of this, in the embodiments of the present application, "plurality" can also be understood as "at least two". "At least one" can be understood as one or more, for example, one, two or more. For example, including at least one means including one, two or more, and there is no limit on which ones are included. For example, including at least one of A, B and C, then A, B, C, A and B, A and C, B and C, or A, B and C can be included.

[0057] An embodiment of the present application provides a data processing method, see Figure 1 As shown, the data processing method includes steps S11 to S15:

[0058] Step S11: obtaining a data processing instruction, where the data processing instruction is used to request a first data operation to be performed on at least one object data in a database, where the object data includes a field code value and a field data value.

[0059] The object data pointed to by the data processing instruction can be the business data of the current business system or the business data of other business systems. The attributes of the object data are encoded by the corresponding business system to obtain field code values, and the value of the object data is the field data value. Exemplarily, the object data is the business data of the life insurance business system, the object data can be (A07-B01-C05-D01, 1 million), 1 million is the field data value, A07-B01-C05-D01 is the code value of the annual number of new users in Qingshan District, Wuhan City, Hubei Province, and the field code value is used to characterize the attributes of the object data; the object data is the business data of the banking business system, the object data can be (01, 135XXXXX), 135XXXXX is the field data value, and 01 is the mobile phone number.

[0060] When the object data is the business data of the current business system, the field coding value is generated using the coding logic of the current business system and can be directly parsed by the current business system; when the object data is the business data of other business systems, the field coding value is generated using the coding logic of other business systems and cannot be directly parsed by the current business system.

[0061] Step S12: extract at least one object data from the database according to the data processing instruction.

[0062] Among them, the database can be the memory of the current business system, the object data can be pre-stored in the memory of the current business system, and the current business system can directly read the object data from the memory; or, the database can also be a shared database connected to the current business system through a communication interface, the object data can also be pre-stored in the shared database, and the current business system calls the object data by accessing the shared database.

[0063] The data processing instruction may include a storage address of at least one object data and an operation instruction for implementing the first data operation. The at least one object data may be extracted according to the storage address of the object data in the data processing instruction.

[0064] Step S13: Determine whether the object data is business data of the current business system according to the first preset dictionary table and the field code value; the first preset dictionary table includes the first dictionary code value of each business object in the current business system and the description information of the business object.

[0065] Among them, the business object can be a proper noun, abbreviation, business status code, business area, business indicator, business indicator attribute, user information type, etc. in the business field. The first dictionary code value of the business object is obtained by encoding the business object according to the encoding rules of the current business system; the description information of the business object is used to describe or express the meaning of the business object, which is easy for people to understand; illustratively, the description information of the business object is usually in human language, for example, the description information of the business object is the contact person's mobile phone number, and the first dictionary code value of the business object is 01; the description information of the business object is the insurance policy number, and the first dictionary code value of the business object is 101; the description information of the business object is the contact person's name, and the first dictionary code value of the business object is 08.

[0066] Among them, the first dictionary code value of the business object is set in one-to-one correspondence with the description information of the business object, and the description information of the corresponding business object can be obtained according to the first dictionary code value according to the mapping relationship. The field code value can be used as a query object to traverse and search in the first preset dictionary table. If the field code value is successfully queried in the first preset dictionary table, the object data corresponding to the dictionary code value is the business data of the current business system; if the field code value cannot be queried in the first preset dictionary table, the object data corresponding to the dictionary code value is not the business data of the current business system.

[0067] As an implementation method, first, the field code value is compared with multiple first dictionary code values ​​in the first preset dictionary table respectively; then, when there is no first dictionary code value matching the field code value, it is determined that the object data is not business data for the current business system; then, when there is a first dictionary code value matching the field code value, it is determined that the object data is business data for the current business system.

[0068] Step S14: When the determination result is no, obtain the target dictionary code value according to the global dictionary mapping table and the field code value; the global dictionary mapping table includes the first dictionary code values ​​of multiple business objects in the current business system and at least one second dictionary code value mapped to the first dictionary code value, and the second dictionary code value is the dictionary code value of the business object in other business systems.

[0069] Among them, the field code value cannot be queried in the first preset dictionary table, and the object data corresponding to the dictionary code value is not the business data of the current business system. The object data needs to be converted into data that can be directly recognized by the current business system. The data conversion process needs to be completed based on the global dictionary mapping table.

[0070] Among them, the global dictionary mapping table is used to record multiple dictionary code values ​​of the same business object, and the multiple dictionary code values ​​are generated by different business systems according to their own coding rules. The multiple dictionary code values ​​include a first dictionary code value corresponding to the current business system and at least one second dictionary code value corresponding to other business systems. The first dictionary code value and the at least one second dictionary code value have a mapping relationship. Exemplarily, for the business object of the contact's mobile phone number, the first dictionary code value generated by the current business system (for example, a life insurance business system) is 01, the second dictionary code value generated by the first other business system (for example, a banking business system) is a, and the second dictionary code value generated by the second other business system (for example, a property insurance business system) is Ha. The first dictionary code value 01 has a mapping relationship with the second dictionary code value a, and the first dictionary code value 01 has a mapping relationship with the second dictionary code value Ha.

[0071] Among them, the field code value can be used as a query object to traverse and search in the global dictionary mapping table. If the field code value is successfully queried in the global dictionary mapping table, the second dictionary code value corresponding to the field code value can be determined, and then based on the mapping relationship between the queried second dictionary code value and the first dictionary code value of the current business system, the corresponding first dictionary code value is obtained as the target dictionary code value.

[0072] As an implementation method, first, the field code value is compared with multiple second dictionary code values ​​in the global dictionary mapping table respectively; then, the second dictionary code value matching the field code value is obtained according to the comparison result, and the first dictionary code value mapped to the second dictionary code value is used as the target dictionary code value.

[0073] As an implementation method, the steps of constructing the global dictionary mapping table include: obtaining a first preset dictionary table of the current business system and a second preset dictionary table of at least one other business system, the second preset dictionary table including a second dictionary code value of each business object in the other business system and description information of the business object; matching the description information of the business object in the first preset dictionary table with the description information of the business object in the second preset dictionary table to obtain the target business object that exists in the first preset dictionary table and the second preset dictionary table respectively; constructing a global dictionary mapping table according to the first dictionary code value, the second dictionary code value and the description information of the target business object.

[0074] Step S15: Generate object conversion data according to the target dictionary code value and the field data value, and perform a first data operation on the object conversion data according to the first preset dictionary table.

[0075] The field code value in the object data is replaced with the target dictionary code value to obtain the object conversion data.

[0076] The target dictionary code value is a code value that can be recognized by the current business system. The way in which the current business system recognizes the target dictionary code value is: the target dictionary code value is used as a query object to traverse and search in the first preset dictionary table. If the target dictionary code value is successfully found in the first preset dictionary table, the description information of the business object of the target dictionary code value is obtained based on the mapping relationship, and the target dictionary code value is identified according to the obtained description information.

[0077] A first data operation is performed according to the description information of the target dictionary encoding value and the field data value.

[0078] In this embodiment, through the setting of the first preset dictionary table and the global dictionary mapping table, the coding values ​​of business objects in other business systems can be directly converted into the coding values ​​of the business objects in the current business system based on the global dictionary mapping table, and then the converted data can be further processed based on the first preset dictionary table. Different business systems are compatible, which is conducive to improving data processing efficiency.

[0079] As an implementation manner, after step S13, the following steps are also included:

[0080] Step S15 ′: when the determination result is yes, a first data operation is performed on the object data according to the first preset dictionary table.

[0081] If the field code value is successfully queried in the first preset dictionary table, the object data corresponding to the dictionary code value is the business data of the current business system, and the field code value can be directly identified. The current business system identifies the field code value in the following way: traverse and search the first preset dictionary table using the field code value as the query object. If the field code value is successfully queried in the first preset dictionary table, the description information of the business object of the field code value is obtained based on the mapping relationship, and the field code value is identified according to the obtained description information.

[0082] A first data operation is performed according to the description information of the field code value and the field data value.

[0083] As an implementation manner, the first preset dictionary table further includes a dictionary type code and description information of the dictionary type code, the dictionary type code is mapped to at least one first dictionary code value, and the dictionary type code has a mapping relationship with the corresponding description information of the dictionary type code.

[0084] The dictionary type encoding represents the business object type, and each business object type corresponds to multiple business objects. For example, if the business object type is contact information, the corresponding multiple business objects are contact phone number, contact email address, and contact address. The description information of the dictionary type encoding is used to describe or express the meaning of the business object type.

[0085] As an implementation manner, the global dictionary mapping table further includes a dictionary type code and description information of the dictionary type code, the dictionary type code is mapped to at least one first dictionary code value, and the dictionary type code has a mapping relationship with the corresponding description information of the dictionary type code.

[0086] In some implementations, the first data operation is a data write operation, and the description information of the first dictionary encoding value and / or the description information of the dictionary type encoding can be used to match the field to be written. Accordingly, step S15 specifically includes the following steps:

[0087] Step S21: acquiring description information of a first dictionary code value matching a target dictionary code value of object conversion data and description information of a dictionary type code from a first preset dictionary table.

[0088] Among them, the target dictionary code value is taken as the query object to traverse and search in the first preset dictionary table. If the first dictionary code value matching the target dictionary code value is successfully found in the first preset dictionary table, the description information of the business object of the first dictionary code value is obtained based on the mapping relationship, and then the description information of the dictionary type code is obtained according to the mapping relationship between the first dictionary code value and the dictionary type code value.

[0089] Step S22: determining the first target field of the object conversion data in the first data table according to the obtained description information of the first dictionary code value and the description information of the dictionary type code, and writing the field data value of the object conversion data into the row or column where the first target field is located.

[0090] Among them, the description information of the first dictionary code value and the description information of the dictionary type code can be used as query information to match the first fields in the first data table respectively, and the first target field matching the query information is obtained, and the field matching one of the description information of the first dictionary code value and the description information of the dictionary type code is the first target field. For example, the description information of the first dictionary code value is the contact phone number, and the description information of the dictionary type code is the contact method. If the first data table contains both the contact phone number field and the contact method field, the contact phone number field matches the description information of the first dictionary code value, and the contact method field matches the description information of the dictionary type code, and the first target fields are the contact phone number field and the contact method field respectively; if the first data table only contains the contact phone number field, the contact phone number field matches the description information of the first dictionary code value, and no field in the first data table matches the description information of the dictionary type code, and the first target field is the contact phone number field; if the first data table only contains the contact method field, the contact method field matches the description information of the dictionary type code, and no field in the first data table matches the description information of the first dictionary code value, and the first target fields are the contact method field.

[0091] Correspondingly, the step of performing a first data operation on the object data according to the first preset dictionary table may include: obtaining description information of a first dictionary code value that matches the field code value of the object data and description information of the dictionary type code from the first preset dictionary table; determining a first target field of the object data in the first data table according to the obtained description information of the first dictionary code value and description information of the dictionary type code, and writing the field data value of the object data into the row or column where the first target field is located.

[0092] As an implementation method, the data processing instruction includes a structured query language SQL statement.

[0093] Accordingly, step S11 specifically includes the following steps:

[0094] Step S31: Generate an execution instruction according to a structured query language SQL statement, and extract the at least one object data from the database according to the execution instruction.

[0095] The first data operation is a data query operation, and step S15 specifically includes the following steps:

[0096] Step S41: acquiring description information of a first dictionary code value matching a target dictionary code value of object conversion data and description information of a dictionary type code from a first preset dictionary table.

[0097] For details of step S41, please refer to the description of step S21, which will not be described in detail here.

[0098] Step S42: determining a second target field of the object conversion data in the second data table according to the acquired description information of the first dictionary encoding value and the description information of the dictionary type encoding.

[0099] The manner of determining the second target field is similar to the manner of determining the first target field in step S22, and please refer to the description of S22 for details.

[0100] Step S43: extracting a first target data value matching the field data value of the object conversion data in the row or column where the second target field is located.

[0101] The field data value is matched among all key values ​​in the row or column where the second target field is located, and the key value identical to the field data value is the first target data value.

[0102] Step S44: acquiring at least one second target data value associated with the first target data value from the second data table, taking the at least one second target data value as a query result, and returning the query result to the sender of the data processing instruction.

[0103] Among them, the second target data value is determined according to the location of the first target data value. Specifically, when the second target field is a row field, the other key values ​​of the column where the first target data value is located are the second target data values; when the second target field is a column field, the other key values ​​of the row where the first target data value is located are the second target data values. For example, the second target field is the contact's mobile phone number, and the first target data value is consistent with the mobile phone number corresponding to the field data value. Through the mobile phone number corresponding to the first target data value, multiple data values ​​associated with the first target data value, such as the contact name, contact insurance policy number, contact ID number, contact address, etc., can be obtained; then the contact name, contact insurance policy number, contact ID number, contact address, etc. are the second target data values. The sender of the data processing instruction can be other business systems.

[0104] Accordingly, the step of performing a first data operation on the object data according to the first preset dictionary table may include: obtaining description information of a first dictionary code value that matches the field code value of the object data and description information of a dictionary type code from the first preset dictionary table; determining a second target field of the object data in a second data table according to the obtained description information of the first dictionary code value and description information of the dictionary type code; extracting a first target data value that matches the field data value of the object data in the row or column where the second target field is located; obtaining at least one second target data value associated with the first target data value from the second data table, taking the at least one second target data value as a query result, and returning the query result to the sender of the data processing instruction.

[0105] An embodiment of the present application provides a data processing device, see Figure 2 As shown, the data processing device 40 includes: an instruction receiving module 41, a data acquisition module 42, a judgment module 43, a dictionary mapping module 44 and a data operation module 45. The instruction receiving module 41 is used to obtain a data processing instruction, wherein the data processing instruction is used to request a first data operation to be performed on at least one object data in a database, wherein the object data includes a field code value and a field data value. The data acquisition module 42 is used to extract the at least one object data from the database according to the data processing instruction. The judgment module 43 is used to determine whether the object data is business data of the current business system according to a first preset dictionary table and the field code value; the first preset dictionary table includes a first dictionary code value of each business object in the current business system and description information of the business object. The dictionary mapping module 44 is used to obtain a target dictionary code value according to a global dictionary mapping table and the field code value when the determination result is no; the global dictionary mapping table includes first dictionary code values ​​of multiple business objects in the current business system and at least one second dictionary code value mapped to the first dictionary code value, wherein the second dictionary code value is a dictionary code value of the business object in other business systems. The data operation module 45 is configured to generate object conversion data according to the target dictionary code value and the field data value, and perform the first data operation on the object conversion data according to the first preset dictionary table.

[0106] As an implementation manner, the data operation module 45 is configured to perform the first data operation on the object data according to the first preset dictionary table when the determination result is yes.

[0107] As an implementation manner, the first preset dictionary table also includes a dictionary type code and description information of the dictionary type code, and the dictionary type code is mapped to at least one of the first dictionary code values. The data operation module 45 is used to obtain the description information of the first dictionary code value and the description information of the dictionary type code that match the target dictionary code value of the object conversion data from the first preset dictionary table; determine the first target field of the object conversion data in the first data table according to the obtained description information of the first dictionary code value and the description information of the dictionary type code, and write the field data value of the object conversion data into the row or column where the first target field is located.

[0108] As an implementation manner, the data processing instruction includes a structured query language SQL statement.

[0109] The data acquisition module 42 is used to generate an execution instruction according to the structured query language SQL statement, and extract the at least one object data from the database according to the execution instruction.

[0110] Correspondingly, the data operation module 45 is used to obtain the description information of the first dictionary code value matching the target dictionary code value of the object conversion data and the description information of the dictionary type code from the first preset dictionary table; determine the second target field of the object conversion data in the second data table according to the obtained description information of the first dictionary code value and the description information of the dictionary type code; extract the first target data value matching the field data value of the object conversion data in the row or column where the second target field is located; obtain at least one second target data value associated with the first target data value from the second data table, take at least one second target data value as a query result, and return the query result to the sender of the data processing instruction.

[0111] As an implementation mode, the judgment module 43 is used to compare the field code value with multiple first dictionary code values ​​in the first preset dictionary table respectively; when there is no first dictionary code value matching the field code value, it is determined that the object data is not business data of the current business system; when there is a first dictionary code value matching the field code value, it is determined that the object data is business data of the current business system.

[0112] As an embodiment, the dictionary mapping module 44 is used to compare the field code value with multiple second dictionary code values ​​in the global dictionary mapping table respectively; obtain the second dictionary code value that matches the field code value according to the comparison result, and use the first dictionary code value mapped to the second dictionary code value as the target dictionary code value.

[0113] As an embodiment, the dictionary mapping module 44 is used to obtain the first preset dictionary table of the current business system and the second preset dictionary table of at least one other business system, the second preset dictionary table including the second dictionary code value of each business object in the other business system and the description information of the business object; match the description information of the business object in the first preset dictionary table with the description information of the business object in the second preset dictionary table to obtain the target business object that exists in the first preset dictionary table and the second preset dictionary table respectively; construct the global dictionary mapping table according to the first dictionary code value, the second dictionary code value and the description information of the target business object.

[0114] An embodiment of the present application provides a computer device, see Figure 3As shown, the computer device 50 includes a processor 51, a communication interface 52, a memory 53 and a communication bus 54, wherein the processor 51, the communication interface 52 and the memory 53 communicate with each other via the communication bus 54; the memory 53 is used to store computer programs; the processor 51 is used to implement the steps of the above-mentioned data processing method when executing the program stored in the memory 53.

[0115] The processor 51 may also be a CPU (Central Processing Unit). The processor 51 may also be an integrated circuit chip having signal processing capabilities. The processor 51 may also be a general-purpose processor, a digital signal processor (DSP), an application-specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gate or transistor logic devices, discrete hardware components. The general-purpose processor may be a microprocessor or the processor may also be any conventional processor, etc.

[0116] The memory 53 may be, for example, a read-only memory (ROM), and the processor 51 and the memory 53 are connected to each other via a communication bus 54. The communication interface 52 is also connected to the communication bus 54.

[0117] See also Figure 4 , Figure 4 The schematic diagram of the structure of the computer-readable storage medium of an embodiment of the present application. The computer-readable storage medium 60 of the embodiment of the present application stores a computer program 61 capable of implementing all the above methods, and the computer program 61 is a computer executable instruction or a computer program, wherein the computer program 61 can be stored in the above computer-readable storage medium in the form of a software product, and can include several instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) or a processor (processor) to perform all or part of the steps of the method described in each embodiment of the present application. The computer-readable storage medium 60 can be a non-volatile storage medium or a volatile storage medium, and the aforementioned computer-readable storage medium 60 can include: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk and other media that can store program codes, or terminal devices such as computers, servers, mobile phones, and tablets.

[0118] In the several embodiments provided in the present application, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic. For example, the division of units is only a logical function division. There may be other division methods in actual implementation. For example, multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. Another point is that the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, which can be electrical, mechanical or other forms.

[0119] In addition, each functional unit in each embodiment of the present application can be integrated into one processing unit, or each unit can exist physically separately, or two or more units can be integrated into one unit. The above integrated unit can be implemented in the form of hardware or in the form of software functional units. The above is only an implementation method of the present application, and does not limit the patent scope of the present application. Any equivalent structure or equivalent process transformation made by using the content of the specification and drawings of this application, or directly or indirectly used in other related technical fields, is also included in the patent protection scope of the present application.

[0120] The above is only an implementation method of the present application. It should be pointed out that a person skilled in the art can make improvements without departing from the inventive concept of the present application, but these improvements are within the scope of protection of the present application.

Claims

1. A data processing method, characterized in that: include: Acquire a data processing instruction, the data processing instruction being used to request a first data operation to be performed on at least one object data in a database, the object data comprising a field code value and a field data value; extracting the at least one object data from the database according to the data processing instruction; Determining whether the object data is business data of the current business system according to the first preset dictionary table and the field code value; The first preset dictionary table includes a first dictionary code value of each business object in the current business system and description information of the business object; When the determination result is no, obtaining the target dictionary code value according to the global dictionary mapping table and the field code value; The global dictionary mapping table includes first dictionary code values ​​of multiple business objects in the current business system and at least one second dictionary code value mapped to the first dictionary code value, where the second dictionary code value is a dictionary code value of the business object in other business systems; Object conversion data is generated according to the target dictionary code value and the field data value, and the first data operation is performed on the object conversion data according to the first preset dictionary table.

2. The data processing method according to claim 1, characterized in that: After determining whether the object data is business data of the current business system according to the first preset dictionary table and the field code value, the method further includes: When the determination result is yes, the first data operation is performed on the object data according to the first preset dictionary table.

3. The data processing method according to claim 1, characterized in that: The first preset dictionary table further includes a dictionary type code and description information of the dictionary type code, and the dictionary type code is mapped to at least one of the first dictionary code values; The performing the first data operation on the object conversion data according to the first preset dictionary table includes: Acquire, from the first preset dictionary table, description information of the first dictionary code value that matches the target dictionary code value of the object conversion data and description information of the dictionary type code; Determine the first target field of the object conversion data in the first data table according to the obtained description information of the first dictionary encoding value and the description information of the dictionary type encoding, and write the field data value of the object conversion data into the row or column where the first target field is located.

4. The data processing method according to claim 1, characterized in that: The data processing instruction includes a structured query language SQL statement; and extracting the at least one object data from the database according to the data processing instruction includes: generating an execution instruction according to the structured query language SQL statement, and extracting the at least one object data from the database according to the execution instruction; Correspondingly, performing the first data operation on the object conversion data according to the first preset dictionary table includes: Acquire, from the first preset dictionary table, description information of the first dictionary code value that matches the target dictionary code value of the object conversion data and description information of the dictionary type code; Determine a second target field of the object conversion data in the second data table according to the acquired description information of the first dictionary code value and the description information of the dictionary type code; Extracting a first target data value matching the field data value of the object conversion data in the row or column where the second target field is located; At least one second target data value associated with the first target data value is obtained from the second data table, the at least one second target data value is used as a query result, and the query result is returned to the sender of the data processing instruction.

5. The data processing method according to claim 1, characterized in that: The determining, according to the first preset dictionary table and the field code value, whether the object data is business data of the current business system includes: Compare the field code value with a plurality of the first dictionary code values ​​in the first preset dictionary table respectively; When there is no first dictionary code value matching the field code value, determining that the object data is not business data of the current business system; When there is the first dictionary code value matching the field code value, it is determined that the object data is business data of the current business system.

6. The data processing method according to claim 1, characterized in that: The step of obtaining the target dictionary code value according to the global dictionary mapping table and the field code value includes: Compare the field code value with a plurality of the second dictionary code values ​​in the global dictionary mapping table respectively; The second dictionary code value matching the field code value is obtained according to the comparison result, and the first dictionary code value mapped to the second dictionary code value is used as the target dictionary code value.

7. The data processing method according to claim 1, characterized in that: The steps of constructing the global dictionary mapping table include: Acquire the first preset dictionary table of the current business system and a second preset dictionary table of at least one other business system, wherein the second preset dictionary table includes a second dictionary code value of each business object in the other business system and description information of the business object; Matching the description information of the business object in the first preset dictionary table with the description information of the business object in the second preset dictionary table, and acquiring the target business object existing in the first preset dictionary table and the second preset dictionary table respectively; The global dictionary mapping table is constructed according to the first dictionary encoding value, the second dictionary encoding value and the description information of the target business object.

8. A data processing device, characterized in that: include: An instruction receiving module, used for acquiring a data processing instruction, wherein the data processing instruction is used for requesting a first data operation to be performed on at least one object data in a database, wherein the object data includes a field code value and a field data value; a data acquisition module, configured to extract the at least one object data from the database according to the data processing instruction; A judgment module, used for determining whether the object data is business data of the current business system according to the first preset dictionary table and the field code value; The first preset dictionary table includes a first dictionary code value of each business object in the current business system and description information of the business object; A dictionary mapping module, used for obtaining a target dictionary code value according to a global dictionary mapping table and the field code value when the determination result is no; The global dictionary mapping table includes first dictionary code values ​​of multiple business objects in the current business system and at least one second dictionary code value mapped to the first dictionary code value, where the second dictionary code value is a dictionary code value of the business object in other business systems; A data operation module is used to generate object conversion data according to the target dictionary code value and the field data value, and perform the first data operation on the object conversion data according to the first preset dictionary table.

9. A computer device, characterized in that: The device includes a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus; Memory, used to store computer programs; A processor, for implementing the steps of the data processing method according to any one of claims 1 to 7 when executing a program stored in a memory.

10. A computer-readable storage medium having a computer program stored thereon, characterized in that: When the computer program is executed by a processor, the steps of the data processing method according to any one of claims 1 to 7 are implemented.

Images