A method and system for constructing a homonymic heterographic data search

Abstract

The application discloses a kind of isomorphic heterocode data retrieval configuration method and system, method includes: setting service system basic system information, build isomorphic heterocode field information resource library;Basic system information includes corresponding unique system code and system field;Identify the system field in isomorphic heterocode field information resource library, according to system field definition corresponding standard information, generate definition standard library;Standard information includes unique standard code;Identify the same system field in isomorphic heterocode field information resource library and definition standard library, and the association of basic system information and standard information is carried out, and its unique system code and unique standard code are associated definition;According to the association information of basic system information and standard information, build isomorphic heterocode relationship table;Integrate isomorphic heterocode relationship table, and the information of isomorphic heterocode field information resource library and definition standard library is combined, and data chain table is generated.Establish isomorphic heterocode data mapping table, and quick search can be carried out.

Description

TECHNICAL FIELD

[0001] The present application relates to the technical field of data retrieval, in particular to a same-type different-code data retrieval construction method and system. BACKGROUND

[0002] In the process of enterprise digital transformation, departments have not yet fully formed based on unique data field definition and unique business data expression. Most enterprises have started data governance work and have established master data systems, which can effectively avoid the problem of different field definitions for newly developed systems. However, a large number of existing systems in enterprises have existed for a long time, and in addition to the non-unique system field definition, the data generated by the system itself is different in expression, and each system is self-reliant, such as the existence of 6 coding forms for functional positions, and similar master data such as real-time data and various measurement data. The same device, the same functional position, but different ways in the system. This has caused great difficulty in data connection, correlation and fast search. How to realize data field correspondence and content correspondence with minimal investment while ensuring business continuity of existing systems has always been a pain point. SUMMARY

[0003] The technical problem to be solved by the present application is that, in view of at least one defect of the related art mentioned in the above background, how to construct a data retrieval scheme for the same functional position in different systems, a same-type different-code data retrieval construction method and system are provided.

[0004] The technical scheme adopted by the present application to solve the technical problem is: a same-type different-code data retrieval construction method is provided, the method comprising:

[0005] S10: setting business system basic system information and constructing a same-type different-code field information resource library; the basic system information comprises corresponding unique system codes and system fields;

[0006] S20: identifying the system fields in the same-type different-code field information resource library, defining corresponding standard information according to the system fields, and generating a definition standard library; the standard information comprises unique standard codes;

[0007] S30: identifying the same system fields in the same-type different-code field information resource library and the definition standard library, associating the basic system information and the standard information, and defining according to the unique system codes and the unique standard codes;

[0008] S40: constructing a same-type different-code relationship table according to the association information of the basic system information and the standard information;

[0009] S50: integrating the homograph heteronym relation table, combining the homograph heteronym field information resource library and the information of the definition standard library, and generating a data chain table.

[0010] Preferably, in the homograph heteronym data retrieval construction method, in step S10, the unique system code is respectively matched with the basic system information;

[0011] Preferably, in the homograph heteronym data retrieval construction method, the basic system information further includes system name, system abbreviation, system introduction, database configuration information, database connection information, field definition and business data.

[0012] Preferably, in the homograph heteronym data retrieval construction method, the standard information further includes field standard and business data standard.

[0013] In step S20, the unique standard code is respectively matched with the standard information.

[0014] In step S30, the field standard is associated with the field definition, and the business data standard is associated with the business data.

[0015] Preferably, in the homograph heteronym data retrieval construction method, step S20 includes:

[0016] S21: If the system field in the homograph heteronym field information resource library is identified, the field definition and the business data corresponding to the same system field are the same, and the same field definition and the business data are defined as the field standard and the business data standard in the standard information, respectively.

[0017] Preferably, in the homograph heteronym data retrieval construction method, after step S50, the method further includes:

[0018] S60: inputting the business data or the business data standard, and matching the data information containing the same system field in the data chain table.

[0019] The application also constructs a homograph heteronym data retrieval construction system, which includes:

[0020] The construction module is used for setting business system basic system information and constructing a homograph heteronym field information resource library; the basic system information includes corresponding unique system code and system field.

[0021] The generation module is used for identifying the system field in the homograph heteronym field information resource library, defining corresponding standard information according to the system field, and generating a definition standard library; the standard information includes unique standard code.

[0022] an association module, configured to identify the same system field in the same-type different-code field information resource library and the definition standard library, associate the basic system information and the standard information, and define the association according to the unique system code and the unique standard code;

[0023] a first table building module, configured to build a same-type different-code relationship table according to the associated information of the basic system information and the standard information;

[0024] a second table building module, configured to integrate the same-type different-code relationship table, combine the information of the same-type different-code field information resource library and the definition standard library, and generate a data chain table.

[0025] Preferably, in the same-type different-code data retrieval system, in the building module, the unique system code is respectively matched with the basic system information.

[0026] Preferably, in the same-type different-code data retrieval system, the basic system information further includes system name, system abbreviation, system introduction, database configuration information, database connection information, field definition and business data.

[0027] Preferably, in the same-type different-code data retrieval system, the standard information further includes field standard and business data standard.

[0028] In the generating module, the unique standard code is respectively matched with the standard information.

[0029] In the association module, the field standard is associated with the field definition, and the business data standard is associated with the business data.

[0030] Preferably, in the same-type different-code data retrieval system, the generating module includes:

[0031] an identifying unit, configured to, if the system field in the same-type different-code field information resource library is identified, identify that the field definition and the business data corresponding to the same system field are the same, and respectively define the same field definition and the business data as the field standard and the business data standard in the standard information.

[0032] Preferably, in the same-type different-code data retrieval system, the system further includes:

[0033] a matching module, configured to input the business data or the business data standard, and match the data information containing the same system field in the data chain table.

[0034] By implementing the present application, the following beneficial effects are achieved:

[0035] The application discloses a homotype heterogeneous code data retrieval construction method and system. The method integrates homotype heterogeneous code fields in an information resource library and records related basic system information. According to system fields in the basic system information, corresponding standard information is defined, a definition standard library is generated, the basic system information and the standard information are associated by identifying the same system fields in the information resource library and the definition standard library, and the association is defined by the unique system code of the basic system information and the unique standard code of the standard information, so as to construct a homotype heterogeneous code relation table. According to the homotype heterogeneous code relation table, the basic system information and the standard information are combined to generate a data chain table. Each business data is sorted, so that each homotype heterogeneous code data corresponds to the definition standard data, the homotype heterogeneous code data associated by one key can be retrieved, the retrieval efficiency is improved, and the continuity and stability of the system are maintained. BRIEF DESCRIPTION OF DRAWINGS

[0036] The application will be further described below in combination with the drawings and embodiments. In the drawings:

[0037] Figure 1 is a flowchart of the homotype heterogeneous code data retrieval construction method of the application;

[0038] Figure 2 is a flowchart of the overall scheme of the application;

[0039] Figure 3 is a module block diagram of the homotype heterogeneous code data retrieval construction system of the application. DETAILED DESCRIPTION

[0040] In order to have a clearer understanding of the technical features, objects and effects of the application, the specific embodiments of the application will be described in detail below with reference to the drawings.

[0041] It should be noted that the flowchart shown in the drawings is only illustrative, and does not necessarily include all the contents and operations / steps, nor does it necessarily execute in the order described. For example, some operations / steps can be further divided, and some operations / steps can be combined or partially combined, so that the actual execution order can be changed according to the actual situation.

[0042] The block diagram shown in the drawings is only a functional entity, which does not necessarily correspond to a physically independent entity. That is, the functional entity can be realized in the form of software, or in one or more hardware modules or integrated circuits, or in different networks and / or processor devices and / or microcontroller devices.

[0043] In the embodiment, as shown in Figure 1 the application provides a homotype heterogeneous code data retrieval construction method, which includes the following steps:

[0044] S10: setting service system basic system information, constructing same type different code field information resource library; the basic system information includes corresponding unique system code and system field;

[0045] S20: identifying the system field in the same type different code field information resource library, defining corresponding standard information according to the system field, and generating definition standard library; the standard information includes unique standard code;

[0046] S30: identifying the same system field in the same type different code field information resource library and the definition standard library, associating the basic system information and the standard information, and defining according to the unique system code and the unique standard code;

[0047] S40: constructing the same type different code relationship table according to the association information of the basic system information and the standard information;

[0048] S50: integrating the same type different code relationship table, combining the information of the same type different code field information resource library and the definition standard library, and generating the data chain table.

[0049] As shown in Figure 2 , the same type different code data formed correspond to respective systems, the same type different code relationship table is formed by combining the attribute information of the data, the same type different code relationship table is integrated, and the information of the same type different code field information resource library and the definition standard library is combined to generate the data chain table.

[0050] Specifically:

[0051] In this embodiment, in step S10, the unique system code is respectively corresponding to the basic system information;

[0052] The basic system information further includes: system name, system abbreviation, system introduction, database configuration information, database connection information, field definition and business data.

[0053] As shown in Table 1, the service system basic system information is established, the same type different code field information in each system is integrated, and the data information is recorded, and the system field is judged according to the system information. The unique system code is composed of the coding rule system abbreviation+date+three serial numbers. The name and introduction of the system are recorded in detail in the information resource library, which is used for subsequent data searching.

[0054] Table 1 service system basic system information table

[0055]

[0056]

[0057] The standard information further includes: field standard and business data standard;

[0058] In step S20, the unique standard code is corresponded to the standard information respectively.

[0059] In step S30, the field standard is associated with the field definition and the service data standard is associated with the service data.

[0060] As shown in Table 2, the standard field definition and the standard service definition of the partial database system field are made, and the corresponding remarks can be inputted, wherein the unique standard code is composed of STD+date+three-digit serial code.

[0061] Table 2 Definition standard table

[0062]

[0063] As shown in Table 3, the information of the same-type different-code field information resource library is associated with the information of the definition standard library by identifying the same system field. The corresponding unique system code, unique standard code, system name, field definition and service data are recorded in Table 3.

[0064] Table 3 Information association table

[0065]

[0066] As shown in Table 4, based on the associated information of the same-type different-code field information resource library and the definition standard library, the information of the same system field in the associated data information is classified, and the same-type different-code relationship table is obtained.

[0067] Table 4 Same-type different-code relationship table

[0068]

[0069] Further, step S20 comprises:

[0070] S21: If the system field in the same-type different-code field information resource library is identified, the corresponding field definition and service data are the same, the same field definition and service data are defined as the field standard and service data standard in the standard information respectively.

[0071] Further, after step S50, it further comprises:

[0072] S60: The service data or service data standard is inputted, and the data information containing the same system field in the data chain table is matched out.

[0073] The same-type different-code data configuration is made for the existing data, and the newly generated data is coded by using the standard information of the definition standard library.

[0074] In this embodiment, as shown in Figure 3 The application also configures a same-type different-code data retrieval configuration system, which comprises:

[0075] A configuration module is configured to set the basic system information of the business system and build a same-type different-code field information resource library. The basic system information comprises corresponding unique system codes and system fields.

[0076] A generation module is configured to identify the system fields in the same-type different-code field information resource library, define corresponding standard information according to the system fields, and generate a definition standard library. The standard information comprises unique standard codes.

[0077] An association module is configured to identify the same system fields in the same-type different-code field information resource library and the definition standard library, associate the basic system information and the standard information, and define the association according to the unique system codes and the unique standard codes.

[0078] A first table building module is configured to build a same-type different-code relationship table according to the association information of the basic system information and the standard information.

[0079] A second table building module is configured to integrate the same-type different-code relationship table, combine the information of the same-type different-code field information resource library and the definition standard library, and generate a data chain table.

[0080] As shown in Figure 2 The configured same-type different-code data corresponds to respective systems, and a same-type different-code relationship table is configured by combining the attribute information of the data. The respective same-type different-code relationship tables are integrated, and the information of the same-type different-code field information resource library and the definition standard library is combined to generate a data chain table.

[0081] Specifically,

[0082] In this embodiment, in the configuration module, the unique system codes are respectively corresponding to the basic system information.

[0083] The basic system information further comprises a system name, a system abbreviation, a system introduction, database configuration information, database connection information, field definition, and business data.

[0084] As shown in Table 1, the basic system information of the business system is established, the same-type different-code field information in each system is integrated, and the data information is recorded. The system fields are determined according to the system information. The unique system codes are composed of the coding rule system abbreviation + date + three serial numbers. The name and introduction of the system are recorded in detail in the information resource library, which is used for subsequent data searching.

[0085] The standard information further comprises field standards and business data standards.

[0086] In the generating module, the unique standard code is corresponded to the standard information respectively through the unique standard code;

[0087] In the associating module, the field standard is associated with the field definition and the business data standard is associated with the business data.

[0088] As shown in Table 2, the standard field definition and the standard business definition of the partial database system field are carried out, and the corresponding remarks can be input, wherein the unique standard code is composed of STD+date+three serial numbers.

[0089] As shown in Table 3, the information of the same type different code field information resource library is associated with the information of the definition standard library by identifying the same system field. The corresponding unique system code, unique standard code, system name, field definition and business data are recorded in Table 3.

[0090] As shown in Table 4, based on the associated information of the same type different code field information resource library and the information of the definition standard library, the information of the same system field in the associated data information is classified, and the same type different code relationship table is obtained.

[0091] Further, the generating module comprises:

[0092] The identifying unit is used for identifying the system field in the same type different code field information resource library, identifying that the field definition and the business data corresponding to the same system field are the same, and defining the same field definition and the business data as the field standard and the business data standard in the standard information respectively.

[0093] Further, the system further comprises:

[0094] The matching module is used for inputting the business data or the business data standard, and matching the data information containing the same system field in the data chain table.

[0095] The same type different code data configuration is carried out on the existing data, and the newly generated data is coded by using the standard information of the definition standard library.

[0096] By implementing the present application, the following beneficial effects are obtained:

[0097] The application discloses a kind of homotype heterocode data retrieval composition method and system, by integrating homotype heterocode field in information resource library and record relevant basic system information, according to the system field in basic system information, define corresponding standard information, generate definition standard library, by identifying the same system field in information resource library and definition standard library, basic system information and standard information are associated, and by its basic system information unique system code and standard information unique standard code are associated definition, build homotype heterocode relationship table, according to homotype heterocode relationship table again in combination basic system information and standard information, generate data chain table. Each business data is arranged, so that each homotype heterocode data and definition standard data are corresponding, and homotype heterocode data associated can be searched by one key, improve the retrieval efficiency, maintain the continuity and stability of system.

[0098] It can be understood that the above embodiments only express the preferred embodiments of the present application, which are described in detail and specifically, but cannot be understood as the limitation of the patent scope of the present application; it should be pointed out that for ordinary skilled in the art, the above technical features can be freely combined without departing from the concept of the present application, and several modifications and improvements can be made, which belong to the protection scope of the present application; therefore, any equivalent transformation and modification within the scope of the claims of the present application should belong to the scope of the claims of the present application.

Claims

1. A method of constructing a homonym heterogeneous code data search, characterized by, The method comprises the following steps: S10: setting business system basic system information; based on the business system basic system information, a same-type different-code field information resource library is constructed; the basic system information comprises corresponding unique system codes and system fields; S20: identifying the system fields in the same-type different-code field information resource library, defining corresponding standard information according to the system fields, and generating a definition standard library; the standard information comprises unique standard codes; S30: identifying the same system fields in the same-type different-code field information resource library and the definition standard library, associating the basic system information and the standard information, and defining the association according to the unique system codes and the unique standard codes; S40: constructing a same-type different-code relationship table according to the association information of the basic system information and the standard information; S50: integrating the same-type different-code relationship table, combining the information of the same-type different-code field information resource library and the definition standard library, and generating a data chain table.

2. The heterogeneous code data search configuration method according to claim 1, characterized by, In step S10, the unique system codes are respectively matched with the basic system information; The basic system information further comprises: system names, system abbreviations, system introductions, database configuration information, database connection information, field definitions, and business data.

3. The method according to claim 2, wherein The standard information further comprises: field standards and business data standards; In step S20, the unique standard codes are respectively matched with the standard information; In step S30, the field standards are associated with the field definitions, and the business data standards are associated with the business data.

4. The method according to claim 3, wherein Step S20 comprises: S21: if the system fields in the same-type different-code field information resource library are identified, and the same system fields correspond to the same field definitions and business data, the same field definitions and business data are defined as the field standards and the business data standards in the standard information, respectively.

5. The method of claim 3, wherein the same data is stored in the same location in the same file. After step S50, the method further comprises: S60: inputting the business data or the business data standards, and matching data information containing the same system fields in the data chain table.

6. A system for constructing a homonym heterogeneous code data search, characterized by, The method comprises: A construction module is configured to set business system basic system information; A same-type different-code field information resource library is constructed based on the business system basic system information; The basic system information comprises corresponding unique system codes and system fields; A generation module is configured to identify the system fields in the same-type different-code field information resource library, define corresponding standard information according to the system fields, and generate a definition standard library; the standard information comprises unique standard codes; An association module is configured to identify the same system fields in the same-type different-code field information resource library and the definition standard library, associate the basic system information and the standard information, and define the association according to the unique system codes and the unique standard codes; A first table construction module is configured to construct a same-type different-code relationship table according to the association information of the basic system information and the standard information; A second table building module is configured to integrate the same-type different-code relation table, combine information of the same-type different-code field information resource and the definition standard library, and generate a data chain table.

7. The heterogeneous code data search configuration system according to claim 6, wherein In the building module, the unique system code is respectively matched with the basic system information; The basic system information further includes system name, system abbreviation, system introduction, database configuration information, database connection information, field definition, and business data.

8. The heterogeneous code data search configuration system according to claim 7, wherein The standard information further includes field standard and business data standard. In the generating module, the unique standard code is respectively matched with the standard information; In the associating module, the field standard is associated with the field definition, and the business data standard is associated with the business data.

9. The heterogeneous code data search configuration system according to claim 8, wherein, The generating module includes: An identifying unit is configured to identify system fields in the same-type different-code field information resource, identify that the same system field corresponds to the same field definition and business data, and respectively define the same field definition and business data as the field standard and the business data standard in the standard information.

10. The heterogeneous code data search configuration system according to claim 8, wherein, The system further includes: A matching module is configured to input the business data or the business data standard, and match data information containing the same system field in the data chain table.

Images