CN112800063A - Automatic label passing method and device based on data structure - Google Patents
Automatic label passing method and device based on data structure Download PDFInfo
- Publication number
- CN112800063A CN112800063A CN202110129895.9A CN202110129895A CN112800063A CN 112800063 A CN112800063 A CN 112800063A CN 202110129895 A CN202110129895 A CN 202110129895A CN 112800063 A CN112800063 A CN 112800063A
- Authority
- CN
- China
- Prior art keywords
- entity
- data
- field
- data structure
- structure table
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 37
- 238000005516 engineering process Methods 0.000 claims abstract description 17
- 238000004590 computer program Methods 0.000 claims description 13
- 238000003860 storage Methods 0.000 claims description 13
- 238000010606 normalization Methods 0.000 abstract description 4
- 238000010586 diagram Methods 0.000 description 14
- 230000006870 function Effects 0.000 description 12
- 238000012545 processing Methods 0.000 description 8
- 238000004891 communication Methods 0.000 description 7
- 238000011161 development Methods 0.000 description 5
- 239000000872 buffer Substances 0.000 description 4
- 230000002708 enhancing effect Effects 0.000 description 3
- 238000012423 maintenance Methods 0.000 description 3
- 230000035515 penetration Effects 0.000 description 3
- 238000004132 cross linking Methods 0.000 description 2
- 230000000149 penetrating effect Effects 0.000 description 2
- 230000001413 cellular effect Effects 0.000 description 1
- 230000007547 defect Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000010295 mobile communication Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 238000011378 penetrating method Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000005728 strengthening Methods 0.000 description 1
- 238000012360 testing method Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/21—Design, administration or maintenance of databases
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
An automatic label passing method and device based on a data structure can be used in the financial field or other fields. The method comprises the following steps: configuring preset field elements by using a meta-model technology to generate a business entity data structure table and a data entity data structure table; inputting the acquired service entity information standard into a service entity information standard field in a corresponding service entity data structure table; setting a business entity incidence relation field and a data entity incidence relation field according to the corresponding relation between the business entity and the data entity; and synchronizing the service entity information standard to the data entity information standard field according to the service entity incidence relation field and the data entity incidence relation field. The invention constructs the business entity data structure table and the data entity data structure table through the meta-model technology, realizes automatic through-marking by establishing the incidence relation, enhances the normalization, the integrity and the consistency of the through-marking, reduces the human resources and the time, and improves the efficiency and the accuracy of the through-marking.
Description
Technical Field
The present invention relates to the technical field of data structures, and in particular, to an automatic label-crossing method and apparatus based on a data structure.
Background
With the continuous development of the internet and the information technology, data grows exponentially, corresponding data structures are required to be more and more standardized, and the maintenance level of the data structure associated information standard lacks of standardized management, so that an automatic standard passing method is required to correspond to the situation.
The through-standard application is standard application from constructing a conceptual model to strengthening information of a physical model, has a statistical information function related to the optimization of the standard of information, perfects an evaluation mechanism of standard work, and improves the integrity and consistency of various information items. The business entity designed by the business entity data structure table guides the data entity under the data entity data structure table, so that the guidance relationship from the business entity attribute to the data entity attribute is realized, and a database developer is guided to complete the table structure development.
For convenience of introduction, in the application development process, a model designed from a business layer to a database operation is referred to as a business entity data structure table, a model designed from a physical layer to the database operation is referred to as a data entity data structure table, and a process of maintaining consistency and integrity from an information standard associated with the business entity data structure table to an information standard associated with the data entity data structure table is referred to as a through standard. The change of the data entity data structure table mainly comprises the operations of adding, modifying and deleting, and the information standard is manually associated. In a bank related system, due to strict requirements on information specifications, developers need to search information standards related to a business entity data structure table when manually maintaining the data entity data structure table related information standards, and the integrity and consistency from the business entity data structure table to the data entity data structure table cannot be completely guaranteed.
At present, the standard way of the manual associated information has the following defects:
1. when the data structure table related to a plurality of applications has a huge changed data amount, the work of manually maintaining the information standards of the business entity data structure table and the data entity data structure table consumes a great deal of time and energy, and the associated information standards are easy to be wrong due to different levels of developers and familiar fields, and the data structure table associated information standards need to be repeatedly modified and submitted.
2. When a developer modifies the data structure table in a development environment or a test environment, but fails to extract the information standard associated with the data structure table, the information standard associated with the data structure table of the conceptual model and the physical model may be inconsistent, which may cause data errors or even serious problems.
3. The information standard associated with the applied data structure table cannot form assets on the line, and the difficulty is increased for subsequent data governance and maintenance.
Disclosure of Invention
Aiming at the problems in the prior art, the embodiments of the present invention mainly aim to provide an automatic target penetrating method and apparatus based on a data structure, which realize automatic target penetrating, reduce labor cost, and improve target penetrating accuracy and efficiency.
In order to achieve the above object, an embodiment of the present invention provides an automatic target matching method based on a data structure, where the method includes:
configuring preset field elements by using a meta-model technology to generate a business entity data structure table and a data entity data structure table; the data structure table of the service entity comprises a standard field of information of the service entity and an incidence relation field of the service entity, and the data structure table of the data entity comprises a standard field of information of the data entity and an incidence relation field of the data entity;
acquiring a service entity information standard, and inputting the service entity information standard into a service entity information standard field in a corresponding service entity data structure table;
setting the business entity incidence relation field and the data entity incidence relation field according to the corresponding relation between the business entity and the data entity; wherein, the service entities and the data entities are in one-to-one correspondence;
and automatically synchronizing the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table according to the service entity incidence relation field and the data entity incidence relation field.
Optionally, in an embodiment of the present invention, the service entity data structure table further includes a service entity basic information field and a service entity attribute information field; the data entity data structure table also comprises a data entity basic information field and a data entity attribute information field.
Optionally, in an embodiment of the present invention, the 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 includes: determining data entity names corresponding to the business entity names one by one according to the corresponding relation between the business entities and the data entities and the business entity names in the basic information fields of the business entities, and inputting the data entity names into the associated relation fields of the business entities; determining business entity names corresponding to the data entity names one by one according to the corresponding relation between the business entities and the data entity names in the basic information fields of the data entities, and inputting the business entity names into the data entity association relation fields.
Optionally, in an embodiment of the present invention, the automatically synchronizing the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table according to the service entity association relation field and the data entity association relation field includes: determining a business entity data structure table associated with the data entity data structure table to be subjected to the through mark according to the business entity name corresponding to the data entity association relation field in the data entity data structure table to be subjected to the through mark; and if the data entity name corresponding to the business entity incidence relation field in the business entity data structure table associated with the data entity data structure table to be subjected to the consistency with the data entity name in the data entity data structure table to be subjected to the consistency, automatically synchronizing 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 subjected to the consistency to the data entity information standard field in the data entity data structure table to be subjected to the consistency.
The embodiment of the invention also provides an automatic label passing device based on the data structure, which comprises:
the data structure table module is used for configuring preset field elements by utilizing a meta-model technology to generate a business entity data structure table and a data entity data structure table; the data structure table of the service entity comprises a standard field of information of the service entity and an incidence relation field of the service entity, and the data structure table of the data entity comprises a standard field of information of the data entity and an incidence relation field of the data entity;
the information standard module is used for acquiring a service entity information standard and inputting the service entity information standard into a service entity information standard field in a corresponding service entity data structure table;
the incidence relation module is used for setting the incidence relation field of the business entity and the incidence relation field of the data entity according to the corresponding relation between the business entity and the data entity; wherein, the service entities and the data entities are in one-to-one correspondence;
and the automatic mark passing module is used for automatically synchronizing the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table according to the service entity incidence relation field and the data entity incidence relation field.
Optionally, in an embodiment of the present invention, the service entity data structure table further includes a service entity basic information field and a service entity attribute information field; the data entity data structure table also comprises a data entity basic information field and a data entity attribute information field.
Optionally, in an embodiment of the present invention, the association relationship module includes: a business entity incidence relation unit, configured to determine, according to a correspondence between a business entity and a data entity and a business entity name in the business entity basic information field, a data entity name corresponding to the business entity name one to one, and input the data entity name to the business entity incidence relation field; and the data entity incidence relation unit is used for determining business entity names corresponding to the data entity names one by one according to the corresponding relation between the business entities and the data entity names in the basic information fields of the data entities, and inputting the business entity names into the data entity incidence relation fields.
Optionally, in an embodiment of the present invention, the automatic target matching module includes: the associated data structure table unit is used for determining a business entity data structure table associated with the data entity data structure table to be subjected to the through mark according to the business entity name corresponding to the data entity association relation field in the data entity data structure table to be subjected to the through mark; and the automatic cross-mark unit is used for automatically synchronizing the service entity information standard corresponding to the service entity information standard field in the service entity data structure table associated with the data entity data structure table to be cross-marked to the data entity information standard field in the data entity data structure table to be cross-marked if the data entity name corresponding to the service entity association relation field in the service entity data structure table associated with the data entity data structure table to be cross-marked is consistent with the data entity name in the data entity data structure table to be cross-marked.
The invention also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method when executing the program.
The present invention also provides a computer-readable storage medium storing a computer program for executing the above method.
The invention constructs the business entity data structure table and the data entity data structure table through the meta-model technology, and realizes automatic through-mark through establishing the incidence relation, thereby enhancing the normalization, the integrity and the consistency of the through-mark, reducing the human resources and the time, improving the through-mark efficiency and ensuring the correctness of the through-mark.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained based on these drawings without creative efforts.
FIG. 1 is a flow chart of an automatic label-intersecting method based on a data structure according to an embodiment of the present invention;
FIG. 2 is a flow chart of association setting in an embodiment of the present invention;
FIG. 3 is a flow chart of an automatic target crossing in an embodiment of the present invention;
FIG. 4 is a diagram illustrating an association between a business entity data structure table and a data entity data structure table according to an embodiment of the present invention;
FIG. 5 is a schematic structural diagram of an automatic target tracking apparatus based on a data structure according to an embodiment of the present invention;
FIG. 6 is a schematic structural diagram of an association module according to an embodiment of the present invention;
FIG. 7 is a schematic structural diagram of an automatic label passing module according to an embodiment of the present invention;
fig. 8 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides an automatic target crossing method and device based on a data structure, which can be used in the financial field or other fields.
The technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
In the application development process, a model designed from a business layer to the database operation is called a business entity data structure table, a model designed from a physical layer to the database operation is called a data entity data structure table, and a process of keeping consistency and integrity from an information standard associated with the business entity data structure table to an information standard associated with the data entity data structure table is called a through standard. The change of the data entity data structure table mainly comprises the operations of adding, modifying and deleting, and after the data entity data structure table is associated with the service entity data structure table, the information standard needs to be manually associated. When the developer manually maintains the data entity data structure table association information standard, the developer needs to search the information standard associated with the business entity data structure table, and the integrity and consistency from the business entity data structure table to the data entity data structure table cannot be completely ensured.
Fig. 1 is a flowchart illustrating an automatic benchmarking method based on a data structure according to an embodiment of the present invention, where an execution subject of the automatic benchmarking method based on a data structure provided by the embodiment of the present invention includes, but is not limited to, a computer. The method shown in the figure comprises the following steps:
step S1, configuring the preset field element by using meta-model technology, and generating a business entity data structure table and a data entity data structure table; the data structure table of the service entity comprises a standard field of information of the service entity and an incidence relation field of the service entity, and the data structure table of the data entity comprises a standard field of information of the data entity and an incidence relation field of the data entity.
The meta-model is a technical meta-model, and field elements and rules of the data structure table can be defined by using a modeling technology of the meta-model. And generating a business entity data structure table and a data entity data structure table by presetting field elements, such as data names, values and other fields, which are required to be used for constructing the data structure table, and utilizing a modeling technology of a meta model. Specifically, the data structure table is generated in the form of a key-value form by a meta model, which is shown in table 1.
TABLE 1
| key | value | Description of the invention |
| name | DataStandard | Asset name, globally unique |
| type | EReference | The types are as follows: relationships between |
| upperBound | -1 | And (3) checking rules: without upper limit |
Further, the service entity data structure table refers to a data structure table designed for database operation from the service layer, and the data entity data structure table refers to a data structure table designed for database operation from the physical layer. The business entity data structure table and the data entity data structure table respectively comprise basic information fields of business entities and basic information fields of data entities, the basic information fields of the business entities comprise information such as names, purposes, definitions and ranges of the business entities, and the basic information fields of the data entities comprise information such as names, purposes, definitions and ranges of the data entities. In addition, the business entity data structure table also comprises a business entity incidence relation field and a business entity information standard field, and the data entity data structure table also comprises a business entity incidence relation field and a business entity information standard field.
Specifically, after the business entity association relationship field and the business entity information standard field are constructed in the business entity data structure table, 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. The business entity association relation field records information such as a data entity name associated with the business entity, and the data entity association relation field records information such as a business entity name associated with the data entity. The service entity data structure table is shown in table 2, the data entity data structure table is shown in table 3, the service entity information standard field of table 2 is contained in the service entity attribute information field, and the data entity information standard field in table 3 is contained in the data entity attribute information field.
TABLE 2
TABLE 3
Step S2, obtaining the service entity information standard, and inputting the service entity information standard into the service entity information standard field in the corresponding service entity data structure table.
The obtaining mode of the service entity information standard can be manual input or obtained from a storage area such as a database. Specifically, according to the name of the business entity, an information standard corresponding to the name of the business entity is obtained. For example, if the name of the business entity is an account, information criteria corresponding to the account, such as information criteria of the account value type, etc., are obtained. In addition, the information standard is shown in table 4, and a plurality of data dictionaries can be further included in the information standard, as shown in table 5, so as to further improve the information standard.
TABLE 4
TABLE 5
| Dictionary value | Dictionary meaning |
| 100001 | Insurance agreement |
| 100001 | Other investment financing protocols |
Further, after the service entity information standard is obtained, the service entity information standard is input into the service entity information standard field of the service entity data structure table. Alternatively, a service entity information standard unique Identifier (ID) may be assigned and entered into a service entity information standard field of the corresponding service entity data structure table.
Step S3, setting the correlation relationship field of the business entity and the correlation relationship field of the data entity according to the corresponding relationship between the business entity and the data entity; wherein the service entities are in one-to-one correspondence with the data entities.
The business entities and the data entities are in one-to-one correspondence, and the correspondence of the relation can be realized through business entity names and data entity names. For example, if the name of the service entity is an account and the name of the data entity is also an account, the names are consistent, and the service entity and the data entity are in a one-to-one correspondence relationship. Further, the setting of the association relationship is realized 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. Specifically, the name of the data entity corresponding to the service entity is input to the associated field of the service entity, so that the data structure table of the service entity points to the associated data structure table of the data entity; and inputting the name of the business entity corresponding to the data entity into the data entity association field to realize 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.
Step S4, according to the business entity association relation field and the data entity association relation 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.
The business entity association relation field records the name of the data entity associated with the business entity, and the data entity association relation field records the name of the business entity associated with the data entity. And when the two names point to each other to indicate that the two data structure tables are associated with each other, automatically synchronizing the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table, thereby realizing automatic mark crossing.
As an embodiment of the present invention, the service entity data structure table further includes a service entity basic information field and a service entity attribute information field; the data entity data structure table also comprises a data entity basic information field and a data entity attribute information field.
The business entity data structure table and the data entity data structure table respectively comprise basic information fields of business entities and basic information fields of data entities, the basic information fields of the business entities comprise information such as names, purposes, definitions and ranges of the business entities, and the basic information fields of the data entities comprise information such as names, purposes, definitions and ranges of the data entities. In addition, the service entity data structure table and the data entity data structure table respectively include a service entity attribute information field and a data entity attribute information field. Specifically, the service entity attribute information field includes a service entity attribute name, a purpose, a definition, and a range, and may further include a service entity information standard field. Similarly, the data entity attribute information field includes data entity attribute name, purpose, definition and range, and may also include data entity information standard field.
In this embodiment, as shown in fig. 2, the 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 includes:
step S21, determining data entity names corresponding to the business entity names one to one according to the corresponding relationship between the business entity and the data entity and the business entity names in the basic information field of the business entity, and inputting the data entity names into the business entity association relationship field.
Step S22, determining business entity names corresponding to the data entity names one to one according to the corresponding relationship between the business entities and the data entity names in the basic information fields of the data entities, and inputting the business entity names into the data entity association relationship fields.
The business entities and the data entities are in one-to-one correspondence, and the correspondence of the relation can be realized through business entity names and data entity names. For example, if the name of the service entity is an account and the name of the data entity is also an account, the names are consistent, and the service entity and the data entity are in a one-to-one correspondence relationship. Further, the setting of the association relationship is realized 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. Specifically, the name of the data entity corresponding to the service entity is input to the associated field of the service entity, so that the data structure table of the service entity points to the associated data structure table of the data entity; and inputting the name of the business entity corresponding to the data entity into the data entity association field to realize 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.
In this embodiment, as shown in fig. 3, automatically synchronizing the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table according to the service entity association relation field and the data entity association relation field includes:
step S31, according to the business entity name corresponding to the data entity association relation field in the data entity data structure table to be subjected to the consistency check, determining the business entity data structure table associated with the data entity data structure table to be subjected to the consistency check.
The name of the business entity corresponding to the data entity can be determined from the data entity association relation field in the data entity data structure table to be subjected to the cross-linking, and then the business entity data structure table associated with the data entity data structure table to be subjected to the cross-linking is determined according to the name of the business entity.
Step S32, 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 subjected to the consistency with the data entity name in the data entity data structure table to be subjected to the consistency, 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 subjected to the consistency to the data entity information standard field in the data entity data structure table to be subjected to the consistency.
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, the business entity data structure table is the business entity data structure table associated with the data entity data structure table to be subjected to the standard penetration. And automatically synchronizing the service entity information standard in the service entity information standard field of the associated service entity data structure table to the data entity information standard field in the data entity data structure table to be subjected to the standard crossing, thereby realizing the automatic standard crossing.
In a specific embodiment of the present invention, as shown in fig. 4, a service person establishes a service entity under a service entity data structure table, and establishes a service entity attribute under the service entity to implement a table structure design of a service layer. The developer establishes the data entity under the data entity data structure table according to the service entity of the service entity data structure table and establishes a relationship with the service entity of the service entity data structure table, thereby realizing the function of guiding and developing the service. The method comprises the steps of adding a data entity attribute under a data entity, needing to be associated with an information standard and a data dictionary under the information standard, establishing a relationship between a service entity associated with the data entity and the service entity attribute through the data entity attribute, automatically acquiring the information standard of the corresponding service entity attribute and the data dictionary under the information standard after the data entity attribute and the service entity attribute establish a one-to-one relationship according to the definition of a technical meta-model at the rear end, and completing automatic mark passing from a service entity data structure table to a data entity data structure table.
The business entity data structure table and the data entity data structure table are constructed by utilizing a modeling technology of a meta-model, and the meta-model can define field elements and rules. In particular, the meta-model definition field elements and the rule process are shown in table 6.
TABLE 6
The data entity attribute is constrained by the information standard corresponding to the data entity information standard field in the data entity data structure table, if the data entity is established by the guidance of the service entity, the data entity attribute must be constrained by the information standard and the data dictionary, one data entity attribute can only be associated with one information standard, and a plurality of data dictionaries can exist in the information standard.
Further, the generation of the business entity data structure table and the data entity data structure table in the application can configure the related page information by using the technical meta model. Setting field element technical meta-model information to be displayed on a page, wherein the field element technical meta-model information comprises a service entity data structure table page, information standard field information related to the service entity data structure table, the data entity data structure table page and information standard field information related to the data entity data structure table, and drawing the page according to fields configured by a technical meta-model and UI control types bound by the fields. And then configuring field elements including information such as the page control type, the necessity of inputting, the length, the data type and the like of the field in the technical meta-model, loading the technical meta-model, and automatically generating a page according to rules set by the technical meta-model information to ensure the display correctness of the page.
In addition, the technical meta-model is provided with an information standard check rule, and a rule of a business entity data structure table correlation information standard, a rule of a data entity data structure table correlation information standard, a rule of a business entity data structure table correlation data structure table and the like are configured through the dictionary characteristics of the technical meta-model, and the rule from the business entity data structure table to the data entity data structure table is limited according to the rules, so that the correctness of the correlation from the business entity data structure table to the data entity data structure table is ensured.
And automatically marking the business entity data structure table after the business entity data structure table is associated with the data entity data structure table. Specifically, a business entity data structure table, information standard information associated with the business entity data structure table, and a data entity data structure table are registered, and 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 a plurality of applications are involved and the data quantity of the table structure change is huge, after the relationship between the business entity data structure table and the data entity data structure table is maintained, the relationship is automatically established from the business entity data structure table to the information standard of the data entity data structure table, namely the information standard is automatically associated with the data entity data structure table, the work of manually maintaining the information standard is reduced, and the integrity and the consistency of the standard are achieved. Furthermore, the table information is formed into assets, so that the accuracy of the table resources and the timeliness of data display are guaranteed, and subsequent maintenance and treatment are facilitated.
The invention constructs the business entity data structure table and the data entity data structure table through the meta-model technology, and realizes automatic through-mark through establishing the incidence relation, thereby enhancing the normalization, the integrity and the consistency of the through-mark, reducing the human resources and the time, improving the through-mark efficiency and ensuring the correctness of the through-mark.
Fig. 5 is a schematic structural diagram of an automatic label passing apparatus based on a data structure according to an embodiment of the present invention, where the apparatus includes:
a data structure table module 10, configured to configure preset field elements by using a meta-model technique, and generate a service entity data structure table and a data entity data structure table; the data structure table of the service entity comprises a standard field of information of the service entity and an incidence relation field of the service entity, and the data structure table of the data entity comprises a standard field of information of the data entity and an incidence relation field of the data entity.
The meta-model is a technical meta-model, and field elements and rules of the data structure table can be defined by using a modeling technology of the meta-model. And generating a business entity data structure table and a data entity data structure table by presetting field elements, such as data names, values and other fields, which are required to be used for constructing the data structure table, and utilizing a modeling technology of a meta model.
Further, the service entity data structure table refers to a data structure table designed for database operation from the service layer, and the data entity data structure table refers to a data structure table designed for database operation from the physical layer. The business entity data structure table and the data entity data structure table respectively comprise basic information fields of business entities and basic information fields of data entities, the basic information fields of the business entities comprise information such as names, purposes, definitions and ranges of the business entities, and the basic information fields of the data entities comprise information such as names, purposes, definitions and ranges of the data entities. In addition, the business entity data structure table also comprises a business entity incidence relation field and a business entity information standard field, and the data entity data structure table also comprises a business entity incidence relation field and a business entity information standard field.
Specifically, after the business entity association relationship field and the business entity information standard field are constructed in the business entity data structure table, 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. The business entity association relation field records information such as a data entity name associated with the business entity, and the data entity association relation field records information such as a business entity name associated with the data entity.
And an information standard module 20, configured to obtain a service entity information standard, and input the service entity information standard into a service entity information standard field in a corresponding service entity data structure table.
The obtaining mode of the service entity information standard can be manual input or obtained from a storage area such as a database. Specifically, according to the name of the business entity, an information standard corresponding to the name of the business entity is obtained. For example, if the name of the business entity is an account, information criteria corresponding to the account, such as information criteria of the account value type, etc., are obtained.
Further, after the service entity information standard is obtained, the service entity information standard is input into the service entity information standard field of the service entity data structure table. Alternatively, a service entity information standard unique Identifier (ID) may be assigned and entered into a service entity information standard field of the corresponding service entity data structure table.
The association relation module 30 is configured to set the business entity association relation field and the data entity association relation field according to a correspondence between a business entity and a data entity; wherein the service entities are in one-to-one correspondence with the data entities.
The business entities and the data entities are in one-to-one correspondence, and the correspondence of the relation can be realized through business entity names and data entity names. For example, if the name of the service entity is an account and the name of the data entity is also an account, the names are consistent, and the service entity and the data entity are in a one-to-one correspondence relationship. Further, the setting of the association relationship is realized 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. Specifically, the name of the data entity corresponding to the service entity is input to the associated field of the service entity, so that the data structure table of the service entity points to the associated data structure table of the data entity; and inputting the name of the business entity corresponding to the data entity into the data entity association field to realize 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.
And the automatic mark crossing module 40 is configured to automatically synchronize the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table according to the service entity association relationship field and the data entity association relationship field.
The business entity association relation field records the name of the data entity associated with the business entity, and the data entity association relation field records the name of the business entity associated with the data entity. And when the two names point to each other to indicate that the two data structure tables are associated with each other, automatically synchronizing the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table, thereby realizing automatic mark crossing.
As an embodiment of the present invention, the service entity data structure table further includes a service entity basic information field and a service entity attribute information field; the data entity data structure table also comprises a data entity basic information field and a data entity attribute information field.
In this embodiment, as shown in fig. 6, the association relation module 30 includes:
a service entity association relation unit 31, configured to determine, according to a correspondence between a service entity and a data entity and a service entity name in the basic information field of the service entity, a data entity name corresponding to the service entity name one to one, and input the data entity name to the service entity association relation field;
and a data entity association relation unit 32, configured to determine, according to a correspondence between a service entity and a data entity name in the data entity basic information field, a service entity name corresponding to the data entity name one to one, and input the service entity name to the data entity association relation field.
In this embodiment, as shown in fig. 7, the automatic label passing module 40 includes:
an associated data structure table unit 41, configured to determine, according to the business entity name corresponding to the data entity association relationship field in the data entity data structure table to be subjected to the target penetration, a business entity data structure table associated with the data entity data structure table to be subjected to the target penetration;
and an automatic target unit 42, configured to, if it is known that the data entity name corresponding to the service entity association relationship field in the service entity data structure table associated with the data entity data structure table to be target-penetrated is consistent with the data entity name in the data entity data structure table to be target-penetrated, automatically synchronize the service entity information standard corresponding to the service entity information standard field in the service entity data structure table associated with the data entity data structure table to the data entity information standard field in the data entity data structure table to be target-penetrated.
Based on the same application concept as the automatic label passing method based on the data structure, the invention also provides the automatic label passing device based on the data structure. Because the principle of solving the problems of the automatic target crossing device based on the data structure is similar to that of the automatic target crossing method based on the data structure, the implementation of the automatic target crossing device based on the data structure can refer to the implementation of the automatic target crossing method based on the data structure, and repeated parts are not repeated.
The invention constructs the business entity data structure table and the data entity data structure table through the meta-model technology, and realizes automatic through-mark through establishing the incidence relation, thereby enhancing the normalization, the integrity and the consistency of the through-mark, reducing the human resources and the time, improving the through-mark efficiency and ensuring the correctness of the through-mark.
The invention also provides an electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method when executing the program.
The present invention also provides a computer-readable storage medium storing a computer program for executing the above method.
As shown in fig. 8, the electronic device 600 may further include: communication module 110, input unit 120, audio processing unit 130, display 160, power supply 170. It is noted that the electronic device 600 does not necessarily include all of the components shown in FIG. 8; furthermore, the electronic device 600 may also comprise components not shown in fig. 8, which may be referred to in the prior art.
As shown in fig. 8, the central processor 100, sometimes referred to as a controller or operational control, may include a microprocessor or other processor device and/or logic device, the central processor 100 receiving input and controlling the operation of the various components of the electronic device 600.
The memory 140 may be, for example, one or more of a buffer, a flash memory, a hard drive, a removable media, a volatile memory, a non-volatile memory, or other suitable device. The information relating to the failure may be stored, and a program for executing the information may be stored. And the central processing unit 100 may execute the program stored in the memory 140 to realize information storage or processing, etc.
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 an object to be displayed, such as an image or a character. The display may be, for example, an LCD display, but is not limited thereto.
The memory 140 may be a solid state memory such as Read Only Memory (ROM), Random Access Memory (RAM), a SIM card, or the like. There may also be a memory that holds information even when power is off, can be selectively erased, and is provided with more data, an example of which is sometimes called an EPROM or the like. The memory 140 may also be some other type of device. Memory 140 includes buffer memory 141 (sometimes referred to as a buffer). The memory 140 may include an application/function storage section 142, and the application/function storage section 142 is used to store application programs and function programs or a flow for executing the operation of the electronic device 600 by the central processing unit 100.
The memory 140 may also include a data store 143, the data store 143 for storing data, such as contacts, digital data, pictures, sounds, and/or any other data used by the electronic device. The driver storage portion 144 of the memory 140 may include various drivers of the electronic device for communication functions and/or for performing other functions of the electronic device (e.g., messaging application, address book application, etc.).
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 an input signal and receive an output signal, which may be the same as in the case of a conventional mobile communication terminal.
Based on different communication technologies, a plurality of communication modules 110, such as a cellular network module, a bluetooth module, and/or a wireless local area network module, may be provided in the same electronic device. The communication module (transmitter/receiver) 110 is also coupled to a speaker 131 and a microphone 132 via an audio processor 130 to provide audio output via the speaker 131 and receive audio input from the microphone 132 to implement general telecommunications functions. Audio processor 130 may include any suitable buffers, decoders, amplifiers and so forth. In addition, an audio processor 130 is also coupled to the central processor 100, so that recording on the local can be enabled through a microphone 132, and so that sound stored on the local can be played through a speaker 131.
As will be appreciated by one skilled in the art, embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
The principle and the implementation mode of the invention are explained by applying specific embodiments in the invention, and the description of the embodiments is only used for helping to understand the method and the core idea of the invention; meanwhile, for a person skilled in the art, according to the idea of the present invention, there may be variations in the specific embodiments and the application scope, and in summary, the content of the present specification should not be construed as a limitation to the present invention.
Claims (10)
1. An automatic target crossing method based on a data structure is characterized by comprising the following steps:
configuring preset field elements by using a meta-model technology to generate a business entity data structure table and a data entity data structure table; the data structure table of the service entity comprises a standard field of information of the service entity and an incidence relation field of the service entity, and the data structure table of the data entity comprises a standard field of information of the data entity and an incidence relation field of the data entity;
acquiring a service entity information standard, and inputting the service entity information standard into a service entity information standard field in a corresponding service entity data structure table;
setting the business entity incidence relation field and the data entity incidence relation field according to the corresponding relation between the business entity and the data entity; wherein, the service entities and the data entities are in one-to-one correspondence;
and automatically synchronizing the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table according to the service entity incidence relation field and the data entity incidence relation field.
2. The method of claim 1, wherein the service entity data structure table further comprises a service entity basic information field and a service entity attribute information field; the data entity data structure table also comprises a data entity basic information field and a data entity attribute information field.
3. The method according to claim 2, wherein the 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 comprises:
determining data entity names corresponding to the business entity names one by one according to the corresponding relation between the business entities and the data entities and the business entity names in the basic information fields of the business entities, and inputting the data entity names into the associated relation fields of the business entities;
determining business entity names corresponding to the data entity names one by one according to the corresponding relation between the business entities and the data entity names in the basic information fields of the data entities, and inputting the business entity names into the data entity association relation fields.
4. The method of claim 3, wherein automatically synchronizing the business entity information criteria in the business entity information criteria field to the data entity information criteria field in the data entity data structure table according to the business entity association relationship field and the data entity association relationship field comprises:
determining a business entity data structure table associated with the data entity data structure table to be subjected to the through mark according to the business entity name corresponding to the data entity association relation field in the data entity data structure table to be subjected to the through mark;
and if the data entity name corresponding to the business entity incidence relation field in the business entity data structure table associated with the data entity data structure table to be subjected to the consistency with the data entity name in the data entity data structure table to be subjected to the consistency, automatically synchronizing 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 subjected to the consistency to the data entity information standard field in the data entity data structure table to be subjected to the consistency.
5. An automatic target passing device based on a data structure, which is characterized by comprising:
the data structure table module is used for configuring preset field elements by utilizing a meta-model technology to generate a business entity data structure table and a data entity data structure table; the data structure table of the service entity comprises a standard field of information of the service entity and an incidence relation field of the service entity, and the data structure table of the data entity comprises a standard field of information of the data entity and an incidence relation field of the data entity;
the information standard module is used for acquiring a service entity information standard and inputting the service entity information standard into a service entity information standard field in a corresponding service entity data structure table;
the incidence relation module is used for setting the incidence relation field of the business entity and the incidence relation field of the data entity according to the corresponding relation between the business entity and the data entity; wherein, the service entities and the data entities are in one-to-one correspondence;
and the automatic mark passing module is used for automatically synchronizing the service entity information standard in the service entity information standard field to the data entity information standard field in the data entity data structure table according to the service entity incidence relation field and the data entity incidence relation field.
6. The apparatus of claim 5, wherein the service entity data structure table further comprises a service entity basic information field and a service entity attribute information field; the data entity data structure table also comprises a data entity basic information field and a data entity attribute information field.
7. The apparatus of claim 6, wherein the association module comprises:
a business entity incidence relation unit, configured to determine, according to a correspondence between a business entity and a data entity and a business entity name in the business entity basic information field, a data entity name corresponding to the business entity name one to one, and input the data entity name to the business entity incidence relation field;
and the data entity incidence relation unit is used for determining business entity names corresponding to the data entity names one by one according to the corresponding relation between the business entities and the data entity names in the basic information fields of the data entities, and inputting the business entity names into the data entity incidence relation fields.
8. The apparatus of claim 7, wherein the automatic target module comprises:
the associated data structure table unit is used for determining a business entity data structure table associated with the data entity data structure table to be subjected to the through mark according to the business entity name corresponding to the data entity association relation field in the data entity data structure table to be subjected to the through mark;
and the automatic cross-mark unit is used for automatically synchronizing the service entity information standard corresponding to the service entity information standard field in the service entity data structure table associated with the data entity data structure table to be cross-marked to the data entity information standard field in the data entity data structure table to be cross-marked if the data entity name corresponding to the service entity association relation field in the service entity data structure table associated with the data entity data structure table to be cross-marked is consistent with the data entity name in the data entity data structure table to be cross-marked.
9. An electronic device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, wherein the processor implements the method of any one of claims 1 to 4 when executing the program.
10. A computer-readable storage medium, characterized in that the computer-readable storage medium stores a computer program for executing the method of any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110129895.9A CN112800063A (en) | 2021-01-29 | 2021-01-29 | Automatic label passing method and device based on data structure |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110129895.9A CN112800063A (en) | 2021-01-29 | 2021-01-29 | Automatic label passing method and device based on data structure |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112800063A true CN112800063A (en) | 2021-05-14 |
Family
ID=75813028
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110129895.9A Pending CN112800063A (en) | 2021-01-29 | 2021-01-29 | Automatic label passing method and device based on data structure |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112800063A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113342686A (en) * | 2021-06-30 | 2021-09-03 | 建信金融科技有限责任公司 | Test data generation method and device |
| CN115794827A (en) * | 2022-11-29 | 2023-03-14 | 广发银行股份有限公司 | Data table structure management system and method |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140068404A1 (en) * | 2012-09-04 | 2014-03-06 | Spm Software, Inc. | Method of representing business units in sales performance management using entity tables and system comprising same |
| CN109656912A (en) * | 2018-12-13 | 2019-04-19 | 成都四方伟业软件股份有限公司 | Data model management-control method, device and server |
| CN110750599A (en) * | 2019-09-20 | 2020-02-04 | 中国电子科技集团公司第二十八研究所 | Associated information extraction and display method based on entity modeling |
| CN111858615A (en) * | 2020-08-04 | 2020-10-30 | 中国工商银行股份有限公司 | Database table generation method, system, computer system and readable storage medium |
-
2021
- 2021-01-29 CN CN202110129895.9A patent/CN112800063A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20140068404A1 (en) * | 2012-09-04 | 2014-03-06 | Spm Software, Inc. | Method of representing business units in sales performance management using entity tables and system comprising same |
| CN109656912A (en) * | 2018-12-13 | 2019-04-19 | 成都四方伟业软件股份有限公司 | Data model management-control method, device and server |
| CN110750599A (en) * | 2019-09-20 | 2020-02-04 | 中国电子科技集团公司第二十八研究所 | Associated information extraction and display method based on entity modeling |
| CN111858615A (en) * | 2020-08-04 | 2020-10-30 | 中国工商银行股份有限公司 | Database table generation method, system, computer system and readable storage medium |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113342686A (en) * | 2021-06-30 | 2021-09-03 | 建信金融科技有限责任公司 | Test data generation method and device |
| CN113342686B (en) * | 2021-06-30 | 2023-01-10 | 中国建设银行股份有限公司 | Test data generation method and device |
| CN115794827A (en) * | 2022-11-29 | 2023-03-14 | 广发银行股份有限公司 | Data table structure management system and method |
| CN115794827B (en) * | 2022-11-29 | 2023-07-21 | 广发银行股份有限公司 | Data table structure management system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN112783793B (en) | Automatic interface test system and method | |
| WO2020259035A1 (en) | Service code generating and executing methods and devices | |
| CN112800063A (en) | Automatic label passing method and device based on data structure | |
| CN110795140A (en) | Configuration file generation method and device | |
| CN112988601A (en) | Test script development method and device | |
| CN112784112A (en) | Message checking method and device | |
| CN112711640A (en) | Method and device for configuring business handling process | |
| CN112860585B (en) | Test script assertion generation method and device | |
| CN106990974B (en) | APP updating method and device and electronic equipment | |
| CN111626022A (en) | Online education topic generation method and device, electronic equipment and storage medium | |
| CN113010443B (en) | Database test data generation method and device based on financial core transaction scene | |
| CN113095782A (en) | Automatic approval decision-making method and device | |
| CN111209283A (en) | Data processing method and device | |
| CN113553530A (en) | Information reporting dynamic page configuration method and device | |
| CN113076262B (en) | Webpage automatic testing method and device | |
| CN114840576A (en) | Data standard matching method and device | |
| US20140025439A1 (en) | Regression free business process management | |
| CN114968917A (en) | Method and device for rapidly importing file data | |
| CN114647591A (en) | Delay assertion processing method and device in automatic test | |
| CN113791984A (en) | Automatic interface testing method and device | |
| CN112860314B (en) | Code modeling method and device | |
| CN113190463B (en) | Code testing method, node and system | |
| CN113129134B (en) | Credit product data processing method and device | |
| CN113419957B (en) | Rule-based big data offline batch processing performance capacity scanning method and device | |
| CN113297225A (en) | Credit data acquisition method, device and system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination |