Automatic standardization method and device based on data structure

Through meta-model technology, the data structure tables of business entities and data entities are generated and associated, and the automatic synchronization of information standards is realized, which solves the time consumption and consistency problems caused by manual maintenance, and improves the accuracy and efficiency of standards.

CN112800063BActive Publication Date: 2025-02-14INDUSTRIAL AND COMMERCIAL BANK OF CHINA
View PDF 1 Cites 0 Cited by

Patent Information

Application Number
CN202110129895.9
Authority / Receiving Office
CN · China
Patent Type
Patents(China)
Current Assignee / Owner
Filing Date
2021-01-29
Publication Date
2025-02-14
Estimated Expiration
2041-01-29

AI Technical Summary

Technical Problem

In the prior art, manual maintenance of information standards for data entity data structure tables and business entity data structure tables has problems such as high time consumption, easy to cause errors, and inability to ensure consistency and integrity.

Method used

The business entity data structure table and data entity data structure table are generated through meta-model technology, and by establishing a one-to-one correspondence relationship between the business entity and the data entity, the business entity information standards are automatically synchronized to the data entity data structure table.

Benefits of technology

Automatic standards are realized, labor costs are reduced, the accuracy and efficiency of standards are improved, and the standardization, completeness and consistency of data structure tables are enhanced.

✦ Generated by Eureka AI based on patent content.

Smart Images

  • Figure CN112800063B_ABST
    Figure CN112800063B_ABST
Patent Text Reader

Abstract

A method and device for automatic standardization based on data structure can be used in the financial field or other fields. The method includes: using metamodel technology to configure preset field elements to generate a business entity data structure table and a data entity data structure table; inputting the acquired business entity information standard into the business entity information standard field in the corresponding business entity data structure table; setting the business entity association relationship field and the data entity association relationship field according to the corresponding relationship between the business entity and the data entity; synchronizing the business entity information standard to the data entity information standard field according to the business entity association relationship field and the data entity association relationship field. The present invention constructs a business entity data structure table and a data entity data structure table through metamodel technology, and realizes automatic standardization by establishing an association relationship, thereby enhancing the standardization, integrity and consistency of standardization, reducing human resources and time, and improving the efficiency and correctness of standardization.
Need to check novelty before this filing date? Find Prior Art

Description

Technical Field

[0001] The present invention relates to the technical field of data structures, and in particular to an automatic labeling method and device based on data structures. Background Art

[0002] With the continuous development of the Internet and information technology, data is growing exponentially, and the corresponding data structure requirements are becoming more and more standardized. There is a lack of standardized management in the maintenance of data structure-related information standards, and an automatic standardization method is needed to deal with this situation.

[0003] Standardization application is the standard application of strengthening information from building conceptual models to physical models. It has the function of optimizing statistical information related to standards, improving the evaluation mechanism of standard work, and improving the integrity and consistency of various information items. Among them, the business entity of the business entity data structure table design guides the data entity under the data entity data structure table, realizes the guiding relationship from business entity attributes to data entity attributes, and guides database developers to complete table structure development.

[0004] For the sake of convenience, the model designed for database operations from the business level in the application development process is called the business entity data structure table, and the model designed for database operations from the physical level is called the data entity data structure table. The process of maintaining consistency and integrity from the information standards associated with the business entity data structure table to the information standards associated with the data entity data structure table is called standard implementation. Changes to the data entity data structure table mainly include addition, modification, and deletion operations, which require manual association of information standards. In bank-related systems, due to strict information specification requirements, developers need to look up the information standards associated with the business entity data structure table when manually maintaining the information standards associated with the data entity data structure table, and cannot fully guarantee the integrity and consistency from the business entity data structure table to the data entity data structure table.

[0005] Currently, this manual method of associating information has the following shortcomings:

[0006] 1. When the amount of data changes in the data structure tables of multiple applications is huge, manually maintaining the information standards of the business entity data structure table and the data entity data structure table will consume a lot of time and energy. In addition, due to the different levels of developers and the fields they are familiar with, it is very easy to cause errors in the associated information standards, and it is necessary to repeatedly modify and submit the data structure table associated information standards.

[0007] 2. When developers modify the data structure table in the development environment or test environment but omit to mention the information standard associated with the data structure table, it will lead to inconsistency between the information standard associated with the data structure table of the conceptual model and the physical model, which may cause data errors and even cause serious problems.

[0008] 3. The information standards associated with the application's data structure tables have failed to form online assets, which increases the difficulty of subsequent data governance and maintenance. Summary of the invention

[0009] In view of the problems existing in the prior art, the main purpose of the embodiments of the present invention is to provide a method and device for automatic standardization based on data structure, so as to realize automatic standardization, reduce labor costs, and improve the accuracy and efficiency of standardization.

[0010] In order to achieve the above object, an embodiment of the present invention provides an automatic standardization method based on data structure, the method comprising:

[0011] Using metamodel technology to configure preset field elements, generate a business entity data structure table and a data entity data structure table; wherein the business entity data structure table includes a business entity information standard field and a business entity association relationship field, and the data entity data structure table includes a data entity information standard field and a data entity association relationship field;

[0012] Acquire business entity information standards, and input the business entity information standards into the business entity information standard fields in the corresponding business entity data structure table;

[0013] According to the correspondence between the business entity and the data entity, the business entity association relationship field and the data entity association relationship field are set; wherein the business entity and the data entity are in one-to-one correspondence;

[0014] According to the business entity association relationship field and the data entity association relationship field, the business entity information standard in the business entity information standard field is automatically synchronized to the data entity information standard field in the data entity data structure table.

[0015] Optionally, in an embodiment of the present invention, the business entity data structure table further includes a business entity basic information field and a business entity attribute information field; the data entity data structure table further includes a data entity basic information field and a data entity attribute information field.

[0016] Optionally, in one embodiment of the present invention, setting the business entity association relationship field and the data entity association relationship field according to the correspondence between the business entity and the data entity includes: determining the data entity name corresponding one-to-one to the business entity name according to the correspondence between the business entity and the data entity and the business entity name in the business entity basic information field, and inputting the data entity name into the business entity association relationship field; determining the business entity name corresponding one-to-one to the data entity name according to the correspondence between the business entity and the data entity and the data entity name in the data entity basic information field, and inputting the business entity name into the data entity association relationship field.

[0017] Optionally, in one embodiment of the present invention, the automatically synchronizing the business entity information standard in the business entity information standard field to the data entity information standard field in the data entity data structure table according to the business entity association relationship field and the data entity association relationship field includes: determining the business entity data structure table associated with the data entity data structure table to be standardized according to the business entity name corresponding to the data entity association relationship field in the data entity data structure table to be standardized; if it is known that the data entity name corresponding to the business entity association relationship field in the business entity data structure table associated with the data entity data structure table to be standardized is consistent with the data entity name in the data entity data structure table to be standardized, then the business entity information standard corresponding to the business entity information standard field in the business entity data structure table associated with the data entity data structure table to be standardized is automatically synchronized to the data entity information standard field in the data entity data structure table to be standardized.

[0018] The embodiment of the present invention further provides an automatic labeling device based on a data structure, the device comprising:

[0019] A data structure table module, used to configure preset field elements using metamodel technology to generate a business entity data structure table and a data entity data structure table; wherein the business entity data structure table includes a business entity information standard field and a business entity association relationship field, and the data entity data structure table includes a data entity information standard field and a data entity association relationship field;

[0020] An information standard module, used for acquiring business entity information standards and inputting the business entity information standards into a business entity information standard field in a corresponding business entity data structure table;

[0021] An association module, used to set the business entity association field and the data entity association field according to the corresponding relationship between the business entity and the data entity; wherein the business entity and the data entity are in one-to-one correspondence;

[0022] The automatic standardization module is used to automatically synchronize the business entity information standard in the business entity information standard field to the data entity information standard field in the data entity data structure table according to the business entity association relationship field and the data entity association relationship field.

[0023] Optionally, in an embodiment of the present invention, the business entity data structure table further includes a business entity basic information field and a business entity attribute information field; the data entity data structure table further includes a data entity basic information field and a data entity attribute information field.

[0024] Optionally, in one embodiment of the present invention, the association relationship module includes: a business entity association relationship unit, used to determine the data entity name corresponding to the business entity name one-to-one according to the correspondence between the business entity and the data entity and the business entity name in the business entity basic information field, and input the data entity name into the business entity association relationship field; a data entity association relationship unit, used to determine the business entity name corresponding to the data entity name one-to-one according to the correspondence between the business entity and the data entity and the data entity name in the data entity basic information field, and input the business entity name into the data entity association relationship field.

[0025] Optionally, in one embodiment of the present invention, the automatic standardization module includes: an associated data structure table unit, used to determine the business entity data structure table associated with the data entity data structure table to be standardized according to the business entity name corresponding to the data entity association relationship field in the data entity data structure table to be standardized; an automatic standardization unit, used to automatically synchronize the business entity information standard corresponding to the business entity information standard field in the business entity data structure table associated with the data entity data structure table to be standardized to the data entity information standard field in the data entity data structure table to be standardized if the data entity name corresponding to the business entity association relationship field in the business entity data structure table associated with the data entity data structure table to be standardized is consistent with the data entity name in the data entity data structure table to be standardized.

[0026] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above method when executing the program.

[0027] The present invention also provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program for executing the above method.

[0028] The present invention constructs a business entity data structure table and a data entity data structure table through metamodel technology, and realizes automatic implementation of standards by establishing association relationships, thereby enhancing the standardization, integrity and consistency of standard implementation, reducing human resources and time, improving the efficiency of standard implementation, and ensuring the correctness of standard implementation. BRIEF DESCRIPTION OF THE DRAWINGS

[0029] In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings required for use in the description of the embodiments will be briefly introduced below. Obviously, the drawings described below are only some embodiments of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0030] Figure 1 This is a flow chart of an automatic standardization method based on data structure according to an embodiment of the present invention;

[0031] Figure 2 A flowchart of the association relationship setting in an embodiment of the present invention;

[0032] Figure 3 This is a flow chart of automatic implementation of the standard in an embodiment of the present invention;

[0033] Figure 4 It is a schematic diagram of the association between the business entity data structure table and the data entity data structure table in an embodiment of the present invention;

[0034] Figure 5 This is a schematic diagram of the structure of an automatic labeling device based on a data structure according to an embodiment of the present invention;

[0035] Figure 6 This is a schematic diagram of the structure of the association relationship module in an embodiment of the present invention;

[0036] Figure 7 This is a schematic diagram of the structure of the automatic labeling module in an embodiment of the present invention;

[0037] Figure 8 A schematic diagram of the structure of an electronic device provided by an embodiment of the present invention. DETAILED DESCRIPTION

[0038] The embodiments of the present invention provide a method and device for automatic labeling based on a data structure, which can be used in the financial field or other fields. It should be noted that the method and device for automatic labeling based on a data structure of the present invention can be used in the financial field, and can also be used in any field other than the financial field. The application field of the method and device for automatic labeling based on a data structure of the present invention is not limited.

[0039] The following will be combined with the drawings in the embodiments of the present invention to clearly and completely describe the technical solutions in the embodiments of the present invention. Obviously, the described embodiments are only part of the embodiments of the present invention, not all of the embodiments. Based on the embodiments of the present invention, all other embodiments obtained by ordinary technicians in this field without creative work are within the scope of protection of the present invention.

[0040] In the application development process, the model for database operation design from the business level is called the business entity data structure table, and the model for database operation design from the physical level is called the data entity data structure table. The process of maintaining consistency and integrity from the information standards associated with the business entity data structure table to the information standards associated with the data entity data structure table is called standard implementation. Changes to the data entity data structure table mainly include addition, modification, and deletion operations. After the data entity data structure table is associated with the business entity data structure table, the information standards need to be manually associated. When developers manually maintain the information standards associated with the data entity data structure table, they need to look up the information standards associated with the business entity data structure table, and cannot fully guarantee the integrity and consistency from the business entity data structure table to the data entity data structure table.

[0041] like Figure 1 The flowchart of an automatic standardization method based on data structure according to an embodiment of the present invention is shown. The execution subject of the automatic standardization method based on data structure provided by the embodiment of the present invention includes but is not limited to a computer. The method shown in the figure includes:

[0042] Step S1, using metamodel technology to configure preset field elements to generate a business entity data structure table and a data entity data structure table; wherein the business entity data structure table includes business entity information standard fields and business entity association relationship fields, and the data entity data structure table includes data entity information standard fields and data entity association relationship fields.

[0043] Among them, the metamodel refers to the technical metamodel, and the modeling technology of the metamodel can be used to define the field elements and rules of the data structure table. By presetting the field elements needed to build the data structure table, such as data name, value and other fields, the business entity data structure table and the data entity data structure table are generated using the modeling technology of the metamodel. Specifically, the data structure table is generated in the form of key-value form through the metamodel, and the metamodel is shown in Table 1.

[0044] Table 1

[0045] key value illustrate name DataStandard Asset name, globally unique type EReference Type: Relationship upperBound -1 Verification rules: No upper limit

[0046] Furthermore, the business entity data structure table refers to a data structure table designed for database operations from a business level, and the data entity data structure table refers to a data structure table designed for database operations from a physical level. The business entity data structure table and the data entity data structure table include the basic information fields of the business entity and the basic information fields of the data entity, respectively. The basic information fields of the business entity include information such as the name, purpose, definition and scope of the business entity, and the basic information fields of the data entity include information such as the name, purpose, definition and scope of the data entity. In addition, the business entity data structure table also includes a business entity association relationship field and a business entity information standard field, and the data entity data structure table also includes a business entity association relationship field and a business entity information standard field.

[0047] Specifically, after the business entity data structure table is constructed, the business entity association relationship field and the business entity information standard field are set according to the acquired business entity association relationship and business entity information standard, and the same is true for the data entity data structure table. Among them, the business entity association relationship field records the name of the data entity associated with the business entity, and the data entity association relationship field records the name of the business entity associated with the data entity. The business entity data structure table is shown in Table 2, and the data entity data structure table is shown in Table 3. The business entity information standard field in Table 2 is included in the business entity attribute information field, and the data entity information standard field in Table 3 is included in the data entity attribute information field.

[0048] Table 2

[0049]

[0050]

[0051] Table 3

[0052]

[0053] Step S2, obtaining business entity information standards, and inputting the business entity information standards into the business entity information standard fields in the corresponding business entity data structure table.

[0054] The business entity information standard can be obtained by manual input or from a storage area such as a database. Specifically, according to the name of the business entity, the information standard corresponding to the name of the business entity is obtained. For example, if the name of the business entity is an account, the information standard corresponding to the account is obtained, such as the information standard of the numerical type of the account. In addition, the information standard is shown in Table 4, and the information standard can also include multiple data dictionaries, as shown in Table 5, to further improve the information standard.

[0055] Table 4

[0056]

[0057] Table 5

[0058] Dictionary Values Dictionary meaning 100001 Insurance Agreement 100001 Other investment and financial management agreements

[0059] Further, after obtaining the business entity information standard, the business entity information standard is input into the business entity information standard field of the business entity data structure table. Alternatively, a unique identifier (ID) may be given to the business entity information standard, and the unique identifier may be input into the business entity information standard field of the corresponding business entity data structure table.

[0060] Step S3, according to the corresponding relationship between the business entity and the data entity, setting the business entity association relationship field and the data entity association relationship field; wherein the business entity and the data entity are in one-to-one correspondence.

[0061] Among them, the business entity and the data entity are in one-to-one correspondence, and the correspondence of the relationship can be realized specifically through the business entity name and the data entity name. For example, if the business entity name is account and the data entity name is also account, then the names are consistent, and the business entity and the data entity are in a one-to-one correspondence. Furthermore, by setting the business entity association field in the business entity data structure table and the data entity association field in the data entity data structure table, the setting of the association relationship is realized. Specifically, the data entity name corresponding to the business entity is input into the business entity association field, so that the business entity data structure table points to the associated data entity data structure table; the business entity name corresponding to the data entity is input into the data entity association field, so that the data entity data structure table points to the associated business entity data structure table, thereby realizing the mutual association between the two associated data structure tables.

[0062] Step S4, according to the business entity association relationship field and the data entity association relationship field, the business entity information standard in the business entity information standard field is automatically synchronized to the data entity information standard field in the data entity data structure table.

[0063] The business entity association field records the data entity name associated with the business entity, and the data entity association field records the business entity name associated with the data entity. When the two names point to each other, indicating that the two data structure tables are associated with each other, the business entity information standard in the business entity information standard field is automatically synchronized to the data entity information standard field in the data entity data structure table, thereby achieving automatic standardization.

[0064] As an embodiment of the present invention, the business entity data structure table further includes a business entity basic information field and a business entity attribute information field; the data entity data structure table further includes a data entity basic information field and a data entity attribute information field.

[0065] Among them, the business entity data structure table and the data entity data structure table respectively include the basic information field of the business entity and the basic information field of the data entity, the basic information field of the business entity includes the name, purpose, definition and scope of the business entity, and the basic information field of the data entity includes the name, purpose, definition and scope of the data entity. In addition, the business entity data structure table and the data entity data structure table also include the business entity attribute information field and the data entity attribute information field respectively. Specifically, the business entity attribute information field includes the business entity attribute name, purpose, definition and scope, and may also include the business entity information standard field. Similarly, the data entity attribute information field includes the data entity attribute name, purpose, definition and scope, and may also include the data entity information standard field.

[0066] In this embodiment, if Figure 2 As shown, according to the correspondence between the business entity and the data entity, setting the business entity association relationship field and the data entity association relationship field includes:

[0067] Step S21, according to the correspondence between the business entity and the data entity and the business entity name in the business entity basic information field, determine the data entity name corresponding to the business entity name one by one, and input the data entity name into the business entity association relationship field.

[0068] Step S22, according to the correspondence between the business entity and the data entity, and the data entity name in the data entity basic information field, determine the business entity name corresponding to the data entity name one by one, and input the business entity name into the data entity association relationship field.

[0069] Among them, the business entity and the data entity are in one-to-one correspondence, and the correspondence of the relationship can be realized specifically through the business entity name and the data entity name. For example, if the business entity name is account and the data entity name is also account, then the names are consistent, and the business entity and the data entity are in a one-to-one correspondence. Furthermore, by setting the business entity association field in the business entity data structure table and the data entity association field in the data entity data structure table, the setting of the association relationship is realized. Specifically, the data entity name corresponding to the business entity is input into the business entity association field, so that the business entity data structure table points to the associated data entity data structure table; the business entity name corresponding to the data entity is input into the data entity association field, so that the data entity data structure table points to the associated business entity data structure table, thereby realizing the mutual association between the two associated data structure tables.

[0070] In this embodiment, if Figure 3 As shown, according to the business entity association relationship field and the data entity association relationship field, automatically synchronizing the business entity information standard in the business entity information standard field to the data entity information standard field in the data entity data structure table includes:

[0071] Step S31, according to the business entity name corresponding to the data entity association relationship field in the data entity data structure table to be standardized, determine the business entity data structure table associated with the data entity data structure table to be standardized.

[0072] Among them, the name of the business entity corresponding to the data entity can be determined from the data entity association relationship field in the data entity data structure table to be standardized, and then the business entity data structure table associated with the data entity data structure table to be standardized is determined by the name of the business entity.

[0073] Step S32, if the data entity name corresponding to the business entity association relationship field in the business entity data structure table associated with the data entity data structure table to be standardized is known to be consistent with the data entity name in the data entity data structure table to be standardized, then the business entity information standard corresponding to the business entity information standard field in the business entity data structure table associated with the data entity data structure table to be standardized will be automatically synchronized to the data entity information standard field in the data entity data structure table to be standardized.

[0074] If the business entity name of the business entity basic information in the business entity data structure table is consistent with the business entity name corresponding to the data entity, then the business entity data structure table is the business entity data structure table associated with the data entity data structure table to be standardized. The business entity information standard in the business entity information standard field of the associated business entity data structure table is automatically synchronized to the data entity information standard field in the data entity data structure table to be standardized, thereby achieving automatic standardization.

[0075] In a specific embodiment of the present invention, Figure 4 As shown, business personnel establish business entities under the business entity data structure table, and establish business entity attributes under the business entity to implement table structure design at the business level. Developers establish data entities under the data entity data structure table based on the business entities in the business entity data structure table and establish relationships with the business entities in the business entity data structure table to achieve the role of business guidance development. New data entity attributes under the data entity require the association of information standards and the data dictionary under the information standards. The business entities associated with the data entity are established through the data entity attributes and the business entity attributes are established. The backend automatically obtains the corresponding business entity attribute information standards and the data dictionary under the information standards according to the definition of the technical metamodel after the data entity attributes and the business entity attributes establish a one-to-one relationship, completing the automatic standardization from the business entity data structure table to the data entity data structure table.

[0076] The business entity data structure table and the data entity data structure table are constructed using the modeling technology of the metamodel, and the metamodel can define field elements and rules. Specifically, the metamodel defines the field elements and rule process as shown in Table 6.

[0077] Table 6

[0078]

[0079] Among them, the information standard corresponding to the data entity information standard field in the data entity data structure table constrains the data entity attributes. If the data entity is established under the guidance of the business entity, the data entity attributes must be constrained by the information standard and the data dictionary. A data entity attribute can only be associated with one information standard, and the information standard can exist in multiple data dictionaries.

[0080] Furthermore, the generation of the business entity data structure table and the data entity data structure table in the present application can utilize the relevant page information configured by the technical metamodel. Set the technical metamodel information of the field elements that need to be displayed on the page, including the business entity data structure table page, the standard field information of the information associated with the business entity data structure table, the data entity data structure table page, and the standard field information of the information associated with the data entity data structure table. Draw the page according to the fields configured by the technical metamodel and the UI control type bound to the fields. Then configure the field elements in the technical metamodel, including the page control type of the field, whether it is required, the length, the data type, and other information. Load the technical metamodel, and automatically generate the page according to the rules set by the technical metamodel information to ensure the correctness of the page display.

[0081] In addition, the technical metamodel is configured with information standard verification rules. Through the dictionary characteristics of the technical metamodel, the rules for associating information standards of business entity data structure tables, the rules for associating information standards of data entity data structure tables, the rules for associating business entity data structure tables with data entity data structure tables, etc. are configured. According to these rules, the compliance rules from business entity data structure tables to data entity data structure tables are restricted to ensure the correctness of the association from business entity data structure tables to data entity data structure tables.

[0082] The business entity data structure table is automatically implemented after being associated with the data entity data structure table. Specifically, the business entity data structure table, the information standard information associated with the business entity data structure table, and the data entity data structure table are registered. When the data entity data structure table is associated with the business entity data structure table, the information standard associated with the business entity data structure table is automatically associated with the data entity data structure table. When multiple applications are involved and the amount of data in the table structure change is huge, after maintaining the relationship between the business entity data structure table and the data entity data structure table, the information standard from the business entity data structure table to the data entity data structure table will automatically establish a relationship, that is, the data entity data structure table automatically associates the information standard, reducing the manual maintenance of information standards and achieving completeness and consistency in the implementation of the standard. Furthermore, the table information is formed into an asset to ensure the accuracy of the table resources and the timeliness of the data presentation, which is convenient for subsequent maintenance and governance.

[0083] The present invention constructs a business entity data structure table and a data entity data structure table through metamodel technology, and realizes automatic implementation of standards by establishing association relationships, thereby enhancing the standardization, integrity and consistency of standard implementation, reducing human resources and time, improving the efficiency of standard implementation, and ensuring the correctness of standard implementation.

[0084] like Figure 5 The figure shows a schematic diagram of the structure of an automatic labeling device based on a data structure according to an embodiment of the present invention. The device shown in the figure includes:

[0085] The data structure table module 10 is used to configure preset field elements using metamodel technology to generate a business entity data structure table and a data entity data structure table; wherein the business entity data structure table includes business entity information standard fields and business entity association relationship fields, and the data entity data structure table includes data entity information standard fields and data entity association relationship fields.

[0086] Among them, the metamodel refers to the technical metamodel, and the modeling technology of the metamodel can be used to define the field elements and rules of the data structure table. By presetting the field elements needed to build the data structure table, such as data name, value and other fields, the business entity data structure table and the data entity data structure table are generated using the modeling technology of the metamodel.

[0087] Furthermore, the business entity data structure table refers to a data structure table designed for database operations from a business level, and the data entity data structure table refers to a data structure table designed for database operations from a physical level. The business entity data structure table and the data entity data structure table include the basic information fields of the business entity and the basic information fields of the data entity, respectively. The basic information fields of the business entity include information such as the name, purpose, definition and scope of the business entity, and the basic information fields of the data entity include information such as the name, purpose, definition and scope of the data entity. In addition, the business entity data structure table also includes a business entity association relationship field and a business entity information standard field, and the data entity data structure table also includes a business entity association relationship field and a business entity information standard field.

[0088] Specifically, after the business entity data structure table is constructed, the business entity association relationship field and the business entity information standard field are set according to the obtained business entity association relationship and business entity information standard, and the same is true for the data entity data structure table. Among them, the business entity association relationship field records the name of the data entity associated with the business entity, and the data entity association relationship field records the name of the business entity associated with the data entity.

[0089] The information standard module 20 is used to obtain the business entity information standard and input the business entity information standard into the business entity information standard field in the corresponding business entity data structure table.

[0090] The business entity information standard may be obtained by manual input or from a storage area such as a database. Specifically, according to the name of the business entity, the information standard corresponding to the name of the business entity is obtained. For example, if the name of the business entity is an account, the information standard corresponding to the account is obtained, such as the information standard of the account's numerical type.

[0091] Further, after obtaining the business entity information standard, the business entity information standard is input into the business entity information standard field of the business entity data structure table. Alternatively, a unique identifier (ID) may be given to the business entity information standard, and the unique identifier may be input into the business entity information standard field of the corresponding business entity data structure table.

[0092] The association module 30 is used to set the business entity association field and the data entity association field according to the corresponding relationship between the business entity and the data entity; wherein the business entity and the data entity are in one-to-one correspondence.

[0093] Among them, the business entity and the data entity are in one-to-one correspondence, and the correspondence of the relationship can be realized specifically through the business entity name and the data entity name. For example, if the business entity name is account and the data entity name is also account, then the names are consistent, and the business entity and the data entity are in a one-to-one correspondence. Furthermore, by setting the business entity association field in the business entity data structure table and the data entity association field in the data entity data structure table, the setting of the association relationship is realized. Specifically, the data entity name corresponding to the business entity is input into the business entity association field, so that the business entity data structure table points to the associated data entity data structure table; the business entity name corresponding to the data entity is input into the data entity association field, so that the data entity data structure table points to the associated business entity data structure table, thereby realizing the mutual association between the two associated data structure tables.

[0094] The automatic standardization module 40 is used to automatically synchronize the business entity information standard in the business entity information standard field to the data entity information standard field in the data entity data structure table according to the business entity association relationship field and the data entity association relationship field.

[0095] The business entity association field records the data entity name associated with the business entity, and the data entity association field records the business entity name associated with the data entity. When the two names point to each other, indicating that the two data structure tables are associated with each other, the business entity information standard in the business entity information standard field is automatically synchronized to the data entity information standard field in the data entity data structure table, thereby achieving automatic standardization.

[0096] As an embodiment of the present invention, the business entity data structure table further includes a business entity basic information field and a business entity attribute information field; the data entity data structure table further includes a data entity basic information field and a data entity attribute information field.

[0097] In this embodiment, if Figure 6 As shown, the association relationship module 30 includes:

[0098] A business entity association unit 31 is used to determine the data entity name corresponding to the business entity name one by one according to the corresponding relationship between the business entity and the data entity and the business entity name in the business entity basic information field, and input the data entity name into the business entity association field;

[0099] The data entity association unit 32 is used to determine the business entity name corresponding to the data entity name one by one according to the correspondence between the business entity and the data entity and the data entity name in the data entity basic information field, and input the business entity name into the data entity association field.

[0100] In this embodiment, if Figure 7 As shown, the automatic labeling module 40 includes:

[0101] The associated data structure table unit 41 is used to determine the business entity data structure table associated with the data entity data structure table to be standardized according to the business entity name corresponding to the data entity association relationship field in the data entity data structure table to be standardized;

[0102] The automatic labeling unit 42 is used to automatically synchronize the business entity information standard corresponding to the business entity information standard field in the business entity data structure table associated with the data entity data structure table to be labeled to the data entity information standard field in the data entity data structure table to be labeled if the data entity name corresponding to the business entity association relationship field in the business entity data structure table associated with the data entity data structure table to be labeled is consistent with the data entity name in the data entity data structure table to be labeled.

[0103] Based on the same application concept as the above-mentioned automatic labeling method based on data structure, the present invention also provides the above-mentioned automatic labeling device based on data structure. Since the principle of solving the problem by the automatic labeling device based on data structure is similar to that of the automatic labeling method based on data structure, the implementation of the automatic labeling device based on data structure can refer to the implementation of the automatic labeling method based on data structure, and the repeated parts will not be repeated.

[0104] The present invention constructs a business entity data structure table and a data entity data structure table through metamodel technology, and realizes automatic implementation of standards by establishing association relationships, thereby enhancing the standardization, integrity and consistency of standard implementation, reducing human resources and time, improving the efficiency of standard implementation, and ensuring the correctness of standard implementation.

[0105] The present invention also provides an electronic device, comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, wherein the processor implements the above method when executing the program.

[0106] The present invention also provides a computer-readable storage medium, wherein the computer-readable storage medium stores a computer program for executing the above method.

[0107] like Figure 8 As shown, the electronic device 600 may further include: a communication module 110, an input unit 120, an audio processing unit 130, a display 160, and a power supply 170. It is worth noting that the electronic device 600 does not necessarily have to include Figure 8 In addition, the electronic device 600 may also include Figure 8 For components not shown, reference may be made to the prior art.

[0108] like Figure 8 As shown, the central processor 100 is sometimes also referred to as a controller or an operation control, and may include a microprocessor or other processor devices and / or logic devices. The central processor 100 receives inputs and controls the operations of various components of the electronic device 600.

[0109] The memory 140 may be, for example, one or more of a cache, a flash memory, a hard drive, a removable medium, a volatile memory, a non-volatile memory or other suitable devices. The above-mentioned information related to the failure may be stored, and a program for executing the relevant information may also be stored. The CPU 100 may execute the program stored in the memory 140 to implement information storage or processing.

[0110] The input unit 120 provides input to the CPU 100. The input unit 120 is, for example, a key or a touch input device. The power supply 170 is used to provide power to the electronic device 600. The display 160 is used to display display objects such as images and text. The display may be, for example, an LCD display, but is not limited thereto.

[0111] The memory 140 may be a solid-state memory, such as a read-only memory (ROM), a random access memory (RAM), a SIM card, etc. It may also be a memory that saves information even when the power is off, can be selectively erased, and is provided with more data, examples of which are sometimes referred to as EPROMs, etc. The memory 140 may also be some other type of device. The memory 140 includes a buffer memory 141 (sometimes referred to as a buffer). The memory 140 may include an application / function storage unit 142, which is used to store application programs and function programs or processes for executing the operation of the electronic device 600 through the central processor 100.

[0112] The memory 140 may also include a data storage unit 143 for storing data, such as contacts, digital data, pictures, sounds, and / or any other data used by the electronic device. The driver storage unit 144 of the memory 140 may include various drivers for communication functions of the electronic device and / or for executing other functions of the electronic device (such as messaging applications, address book applications, etc.).

[0113] The communication module 110 is a transmitter / receiver 110 that transmits and receives signals via an antenna 111. The communication module (transmitter / receiver) 110 is coupled to the central processor 100 to provide input signals and receive output signals, which may be the same as the case of a conventional mobile communication terminal.

[0114] Based on different communication technologies, multiple communication modules 110 may be provided in the same electronic device, such as a cellular network module, a Bluetooth module and / or a wireless LAN module. The communication module (transmitter / receiver) 110 is also coupled to a speaker 131 and a microphone 132 via an audio processor 130 to provide an audio output via the speaker 131 and receive an audio input from the microphone 132, thereby realizing a common telecommunication function. The audio processor 130 may include any suitable buffer, decoder, amplifier, etc. In addition, the audio processor 130 is also coupled to the central processor 100, so that the sound can be recorded on the local machine through the microphone 132, and the sound stored on the local machine can be played through the speaker 131.

[0115] Those skilled in the art will appreciate that embodiments of the present invention may be provided as methods, systems, or computer program products. Therefore, the present invention may take the form of a complete hardware embodiment, a complete software embodiment, or an embodiment combining software and hardware. Moreover, the present invention may take the form of a computer program product implemented on one or more computer-usable storage media (including but not limited to disk storage, CD-ROM, optical storage, etc.) containing computer-usable program code.

[0116] The present invention is described with reference to flowcharts and / or block diagrams of methods, devices (systems), and computer program products according to embodiments of the present invention. It should be understood that each process and / or block in the flowchart and / or block diagram, as well as the combination of processes and / or blocks in the flowchart and / or block diagram, can be implemented by computer program instructions. These computer program instructions can be provided to a processor of a general-purpose computer, a special-purpose computer, an embedded processor, or other programmable data processing device to produce a machine, so that the instructions executed by the processor of the computer or other programmable data processing device generate instructions for implementing the processes in the flowchart and / or block diagram. Figure 1A process or multiple processes and / or boxes Figure 1 A device that provides the functions specified in a block or multiple blocks.

[0117] These computer program instructions may also be stored in a computer-readable memory capable of directing a computer or other programmable data processing device to operate in a specific manner, so that the instructions stored in the computer-readable memory produce an article of manufacture comprising an instruction device, which implements the process Figure 1 A process or multiple processes and / or boxes Figure 1 A function specified in one or more boxes.

[0118] These computer program instructions can also be loaded onto a computer or other programmable data processing device so that a series of operating steps are executed on the computer or other programmable device to produce a computer-implemented process, thereby providing instructions for implementing the process in the computer or other programmable device. Figure 1 A process or multiple processes and / or boxes Figure 1 The steps for the functions specified in one or more boxes.

[0119] The present invention uses specific embodiments to illustrate the principles and implementation methods of the present invention. The description of the above embodiments is only used to help understand the method of the present invention and its core idea. At the same time, for those skilled in the art, according to the idea of ​​the present invention, there will be changes in the specific implementation methods and application scope. In summary, the content of this specification should not be understood as a limitation on the present invention.

Claims

1. An automatic standardization method based on data structure, characterized in that: The method comprises: Using metamodel technology to configure preset field elements, generate a business entity data structure table and a data entity data structure table; wherein the business entity data structure table includes a business entity information standard field and a business entity association relationship field, and the data entity data structure table includes a data entity information standard field and a data entity association relationship field; Acquire business entity information standards, and input the business entity information standards into the business entity information standard fields in the corresponding business entity data structure table; According to the correspondence between the business entity and the data entity, the business entity association relationship field and the data entity association relationship field are set; wherein the business entity and the data entity are in one-to-one correspondence; According to the business entity association relationship field and the data entity association relationship field, the business entity information standard in the business entity information standard field is automatically synchronized to the data entity information standard field in the data entity data structure table; Wherein, setting the business entity association relationship field and the data entity association relationship field according to the correspondence between the business entity and the data entity includes: According to the correspondence between the business entity and the data entity, and the business entity name in the business entity basic information field, determine the data entity name corresponding to the business entity name one by one, and input the data entity name into the business entity association relationship field; According to the correspondence between the business entity and the data entity, and the data entity name in the data entity basic information field, determine the business entity name corresponding to the data entity name one by one, and input the business entity name into the data entity association relationship field.

2. The method according to claim 1, characterized in that: The business entity data structure table also includes a business entity basic information field and a business entity attribute information field; the data entity data structure table also includes a data entity basic information field and a data entity attribute information field.

3. The method according to claim 1, characterized in that The step of automatically synchronizing the business entity information standard in the business entity information standard field to the data entity information standard field in the data entity data structure table according to the business entity association relationship field and the data entity association relationship field comprises: According to the business entity name corresponding to the data entity association relationship field in the data entity data structure table to be standardized, determine the business entity data structure table associated with the data entity data structure table to be standardized; If the data entity name corresponding to the business entity association relationship field in the business entity data structure table associated with the data entity data structure table to be standardized is known to be consistent with the data entity name in the data entity data structure table to be standardized, the business entity information standard corresponding to the business entity information standard field in the business entity data structure table associated with the data entity data structure table to be standardized will be automatically synchronized to the data entity information standard field in the data entity data structure table to be standardized.

4. An automatic labeling device based on data structure, characterized in that: The device comprises: A data structure table module, used to configure preset field elements using metamodel technology to generate a business entity data structure table and a data entity data structure table; wherein the business entity data structure table includes a business entity information standard field and a business entity association relationship field, and the data entity data structure table includes a data entity information standard field and a data entity association relationship field; An information standard module, used for acquiring business entity information standards and inputting the business entity information standards into a business entity information standard field in a corresponding business entity data structure table; An association module, used to set the business entity association field and the data entity association field according to the corresponding relationship between the business entity and the data entity; wherein the business entity and the data entity are in one-to-one correspondence; An automatic standardization module, used to automatically synchronize the business entity information standard in the business entity information standard field to the data entity information standard field in the data entity data structure table according to the business entity association relationship field and the data entity association relationship field; The association relationship module includes: A business entity association unit, configured to determine a data entity name corresponding to the business entity name one-to-one according to the corresponding relationship between the business entity and the data entity and the business entity name in the business entity basic information field, and input the data entity name into the business entity association field; The data entity association relationship unit is used to determine the business entity name corresponding to the data entity name one by one according to the corresponding relationship between the business entity and the data entity and the data entity name in the data entity basic information field, and input the business entity name into the data entity association relationship field.

5. The device according to claim 4, characterized in that The business entity data structure table also includes a business entity basic information field and a business entity attribute information field; the data entity data structure table also includes a data entity basic information field and a data entity attribute information field.

6. The device according to claim 4, characterized in that The automatic standardization module includes: An associated data structure table unit is used to determine a business entity data structure table associated with the data entity data structure table to be standardized according to the business entity name corresponding to the data entity association relationship field in the data entity data structure table to be standardized; The automatic standardization unit is used to automatically synchronize the business entity information standard corresponding to the business entity information standard field in the business entity data structure table associated with the data entity data structure table to be standardized to the data entity information standard field in the data entity data structure table to be standardized if the data entity name corresponding to the business entity association relationship field in the business entity data structure table associated with the data entity data structure table to be standardized is consistent with the data entity name in the data entity data structure table to be standardized.

7. An electronic device comprising a memory, a processor, and a computer program stored in the memory and executable on the processor, characterized in that: When the processor executes the program, the method according to any one of claims 1 to 3 is implemented.

8. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program for executing the method according to any one of claims 1 to 3.

Citation Information

Patent Citations

  • Database table generation method and system, computer system and readable storage medium

    CN111858615A