CN113486024B - Data dictionary information transmission method and device, storage medium and electronic equipment - Google Patents
Data dictionary information transmission method and device, storage medium and electronic equipment Download PDFInfo
- Publication number
- CN113486024B CN113486024B CN202110851655.XA CN202110851655A CN113486024B CN 113486024 B CN113486024 B CN 113486024B CN 202110851655 A CN202110851655 A CN 202110851655A CN 113486024 B CN113486024 B CN 113486024B
- Authority
- CN
- China
- Prior art keywords
- data dictionary
- target system
- dictionary information
- information corresponding
- determining
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 88
- 230000005540 biological transmission Effects 0.000 title claims abstract description 19
- 230000008859 change Effects 0.000 claims abstract description 9
- 238000004458 analytical method Methods 0.000 abstract description 5
- 230000008569 process Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 8
- 238000007726 management method Methods 0.000 description 7
- 238000012545 processing Methods 0.000 description 5
- 230000002411 adverse Effects 0.000 description 3
- 230000006399 behavior Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000008520 organization Effects 0.000 description 2
- 230000001360 synchronised effect Effects 0.000 description 2
- 230000001960 triggered effect Effects 0.000 description 2
- 238000007405 data analysis Methods 0.000 description 1
- 238000013500 data storage Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 239000004744 fabric Substances 0.000 description 1
- 230000002349 favourable effect Effects 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
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/24—Querying
- G06F16/245—Query processing
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/31—Indexing; Data structures therefor; Storage structures
- G06F16/316—Indexing structures
- G06F16/322—Trees
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/30—Information retrieval; Database structures therefor; File system structures therefor of unstructured textual data
- G06F16/36—Creation of semantic tools, e.g. ontology or thesauri
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02D—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN INFORMATION AND COMMUNICATION TECHNOLOGIES [ICT], I.E. INFORMATION AND COMMUNICATION TECHNOLOGIES AIMING AT THE REDUCTION OF THEIR OWN ENERGY USE
- Y02D10/00—Energy efficient computing, e.g. low power processors, power management or thermal management
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)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a data dictionary information transmission method and device, a storage medium and electronic equipment, wherein the method comprises the following steps: when the first data dictionary information is received, determining a first system corresponding to the second data dictionary information and the first data dictionary information; determining each target system corresponding to the first system, and acquiring data dictionary information corresponding to each target system stored in a blockchain network; determining at least one system to be transmitted in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system; and transmitting the first data dictionary information to each system to be transmitted. By applying the method provided by the invention, each system involved in the change can be determined based on the data dictionary information after the database table is changed and each pre-stored data dictionary information, and the changed data dictionary information is sent to each system involved, so that the analysis by staff is not needed, the workload can be reduced, and the careless mistakes are avoided.
Description
Technical Field
The present invention relates to the field of information technologies, and in particular, to a method and apparatus for transmitting data dictionary information, a storage medium, and an electronic device.
Background
In an enterprise organization such as a bank, a large number of application systems are usually provided to handle various business tasks. Between application systems, there is often a database table reference relationship between the systems, that is, the database tables of some application systems need to reference the data in the database tables of other application systems.
In daily system update maintenance work, it is often necessary to modify the relevant information of the database tables of the application system. And when the related information of the database table of the application system is changed, each application system referencing the database table also needs to be changed synchronously. At present, after the related information of the database table of the application system is changed, a worker typically manually analyzes which application system data references are affected by the changed database table, and synchronizes the changed related information to each affected application system.
In an actual application scene, the reference relation of the database tables among all application systems is complicated, and the whole data link is long, for example, various data analysis systems can be connected with data of a plurality of application systems. Therefore, when changes are made to the database tables of the application system, a large number of application systems are often affected. Therefore, the affected application system is determined based on manual analysis at present, so that the information synchronization mode is realized, the workload is extremely high, and careless mistakes are easy to occur, and the operation of each service system is adversely affected.
Disclosure of Invention
In view of the above, the embodiment of the invention provides a data dictionary information transmission method, so as to solve the problems of large workload and easy occurrence of careless mistakes based on a system involved in manual analysis of database table change.
The embodiment of the invention also provides a device for transmitting the data dictionary information, which is used for ensuring the practical realization and application of the method.
In order to achieve the above object, the embodiment of the present invention provides the following technical solutions:
a method of transmitting data dictionary information, comprising:
when first data dictionary information sent by a user is received, determining second data dictionary information and a first system corresponding to the first data dictionary information, wherein the second data dictionary information corresponds to the first system;
determining each target system corresponding to the first system in each system corresponding to a preset blockchain network, and acquiring data dictionary information corresponding to each target system stored in the blockchain network;
determining at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system;
And sending the first data dictionary information to each system to be sent.
The above method, optionally, the determining the second data dictionary information includes:
determining a system identifier corresponding to the first data dictionary information;
and acquiring data dictionary information corresponding to the system identifier from the blockchain network, and determining the data dictionary information corresponding to the system identifier as the second data dictionary information.
In the above method, optionally, the determining at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system includes:
determining source information corresponding to the first system, wherein the source information corresponding to the first system comprises a system identifier and a data table name in the second data dictionary information;
determining source information corresponding to each target system, wherein the source information corresponding to each target system comprises a system identifier and a data table name in data dictionary information corresponding to the target system;
determining the reference information corresponding to each target system, wherein the reference information corresponding to each target system comprises a field source identifier in the data dictionary information corresponding to the target system;
Judging whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system, and determining each target system having the data reference relationship with the first system as the system to be sent.
In the above method, optionally, the determining whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system includes:
determining a reference relation between each target system and the first system according to the reference information corresponding to each target system and the source information corresponding to the first system;
determining a reference relation between each target system based on source information and reference information corresponding to each target system;
constructing a tree structure according to the reference relation between each target system and the first system and the reference relation between each target system, wherein the tree structure comprises a first node and nodes corresponding to each target system, and the first node is a node corresponding to the first system;
And judging whether the node corresponding to each target system is a subtree node corresponding to the first node or not, and if the node corresponding to the target system is the subtree node corresponding to the first node, determining that the target system and the first system have a data reference relationship.
In the above method, optionally, the determining, according to the reference information corresponding to each target system and the source information corresponding to the first system, a reference relationship between each target system and the first system includes:
and judging whether the reference information corresponding to the target system is matched with the source information corresponding to the first system or not for each target system, and if the reference information corresponding to the target system is matched with the source information corresponding to the first system, determining that the target system and the first system have a reference relationship.
The method, optionally, further comprises:
and sending the first data dictionary information to the blockchain network, so that the blockchain network stores the first data dictionary information.
A transmission apparatus of data dictionary information, comprising:
a first determining unit, configured to determine, when first data dictionary information sent by a user is received, second data dictionary information and a first system corresponding to the first data dictionary information, where the second data dictionary information corresponds to the first system;
The second determining unit is used for determining each target system corresponding to the first system in each system corresponding to a preset blockchain network and acquiring data dictionary information corresponding to each target system stored in the blockchain network;
a third determining unit, configured to determine at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system;
and the first sending unit is used for sending the first data dictionary information to each system to be sent.
The above device, optionally, further comprises:
and the second sending unit is used for sending the first data dictionary information to the blockchain network so that the blockchain network stores the first data dictionary information.
The above apparatus, optionally, the first determining unit includes:
a first determining subunit, configured to determine a system identifier corresponding to the first data dictionary information;
and the second determining subunit is used for acquiring the data dictionary information corresponding to the system identifier from the blockchain network and determining the data dictionary information corresponding to the system identifier as the second data dictionary information.
The above apparatus, optionally, the third determining unit includes:
a third determining subunit, configured to determine source information corresponding to the first system, where the source information corresponding to the first system includes a system identifier and a data table name in the second data dictionary information;
a fourth determining subunit, configured to determine source information corresponding to each target system, where the source information corresponding to each target system includes a system identifier and a data table name in the data dictionary information corresponding to the target system;
a fifth determining subunit, configured to determine reference information corresponding to each target system, where the reference information corresponding to each target system includes a field source identifier in the data dictionary information corresponding to the target system;
the first judging subunit is configured to judge whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system, and determine each target system having a data reference relationship with the first system as the system to be sent.
The above apparatus, optionally, the first judging subunit includes:
A sixth determining subunit, configured to determine, according to the reference information corresponding to each target system and the source information corresponding to the first system, a reference relationship between each target system and the first system;
a seventh determining subunit, configured to determine a reference relationship between each target system based on source information and reference information corresponding to each target system;
the building subunit is used for building a tree structure according to the reference relation between each target system and the first system and the reference relation between each target system, wherein the tree structure comprises a first node and a node corresponding to each target system, and the first node is a node corresponding to the first system;
and the second judging subunit is used for judging whether the node corresponding to the target system is a subtree node corresponding to the first node for each target system, and if the node corresponding to the target system is the subtree node corresponding to the first node, determining that the target system and the first system have a data reference relationship.
The above apparatus, optionally, the sixth determining subunit includes:
And the third judging subunit is used for judging whether the reference information corresponding to the target system is matched with the source information corresponding to the first system or not for each target system, and if the reference information corresponding to the target system is matched with the source information corresponding to the first system, determining that the target system and the first system have a reference relationship.
A storage medium comprising stored instructions, wherein the instructions, when executed, control a device in which the storage medium resides to perform a method of transferring data dictionary information as described above.
An electronic device comprising a memory, and one or more instructions, wherein the one or more instructions are stored in the memory and configured to be executed by one or more processors as a method of transmitting data dictionary information as described above.
Based on the data dictionary information transmission method provided by the embodiment of the invention, when first data dictionary information sent by a user is received, determining second data dictionary information and a first system corresponding to the first data dictionary information, wherein the second data dictionary information corresponds to the first system; determining each target system corresponding to the first system in each system corresponding to a preset blockchain network, and acquiring data dictionary information corresponding to each target system stored in the blockchain network; determining at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system; and sending the first data dictionary information to each system to be sent. By using the method provided by the embodiment of the invention, the related information of the database table is recorded by the data dictionary information, the user can send the corresponding data dictionary information after the database table is changed to the server, trigger the server to determine each affected system and send the corresponding data dictionary information to each affected system, the analysis work of staff is not needed, the workload can be saved, the working efficiency can be improved, the manual careless omission can be avoided, and the normal work of the system can be ensured.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings that are required to be used in the embodiments or the description of the prior art will be briefly described below, and it is obvious that the drawings in the following description are only embodiments of the present invention, and that other drawings can be obtained according to the provided drawings without inventive effort for a person skilled in the art.
Fig. 1 is a method flowchart of a method for transmitting data dictionary information according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of a block data structure in a blockchain network according to an embodiment of the present invention;
FIG. 3 is a flowchart of another method for transmitting data dictionary information according to an embodiment of the present invention;
fig. 4 is a schematic structural diagram of a data dictionary information transmission device according to an embodiment of the present invention;
fig. 5 is a schematic structural diagram of a data dictionary information transmission device according to an embodiment of the present invention;
fig. 6 is a schematic structural diagram of an electronic device according to an embodiment of the present invention.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
In this application, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article, or apparatus that comprises the element.
The embodiment of the invention provides a method for transmitting data dictionary information, which can be applied to a management system of a data dictionary, wherein an execution subject of the method can be a server of the system, and a flow chart of the method is shown in fig. 1 and comprises the following steps:
s101: when first data dictionary information sent by a user is received, determining second data dictionary information and a first system corresponding to the first data dictionary information, wherein the second data dictionary information corresponds to the first system;
in the method provided by the embodiment of the invention, the data dictionary refers to the definition and description of the contents such as data items, data structures, data storage or processing logic of data, namely, the information set for describing the data, which can be regarded as a catalog of related information of a database table of a recording system.
In the case that a database table of a certain system is modified, data dictionary information corresponding to the modified database table, that is, information recording relevant definitions and descriptions of the modified database table, may be generated. The first data dictionary information is generated after the database table of the corresponding system is changed. The user may submit the first data dictionary information in the management system of the data dictionary.
When the server of the management system receives the first data dictionary information, the second data dictionary information and the first system corresponding to the first data dictionary information can be determined. The second data dictionary information refers to the data dictionary information corresponding to the first system currently stored in the management system, that is, in the management system, the data dictionary information recording the related information of the database table of the first system is the second data dictionary information, which is the data dictionary information corresponding to the database table of the system before the current change occurs.
S102: determining each target system corresponding to the first system in each system corresponding to a preset blockchain network, and acquiring data dictionary information corresponding to each target system stored in the blockchain network;
In the method provided by the embodiment of the invention, a blockchain network is pre-constructed and used for storing the data dictionary information corresponding to each system. The blockchain network may be a federated chain built based on a fabric framework that interfaces with the various systems set by the organization, and each system may be accessed as a blockchain node.
Each of the systems other than the first system may be determined as a target system. And acquiring the data dictionary information corresponding to each target system in the blockchain network according to the system identification of each target system.
S103: determining at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system;
in the method provided by the embodiment of the invention, at least one system to be sent, namely each system affected by the database table of the first system, can be determined based on the data dictionary information and the second data dictionary information corresponding to each target system. Specifically, based on the data source of the database table of each target system included in the data dictionary information corresponding to each target system, whether the database table of the target system references the data in the database table of the first system or not can be judged, so as to determine whether the target system is the affected system after the database table of the first system changes, and the affected system is used as the system to be sent.
S104: and sending the first data dictionary information to each system to be sent.
In the method provided by the embodiment of the invention, the first data dictionary information can be sent to each system to be sent according to the preset transmission mode, so that the related information in the database table in the system can be updated synchronously according to the first data dictionary information. The specific transmission mode can be based on the IP address of the system for information transmission, or based on the intelligent contract of the blockchain for transmission, the first data dictionary information is pushed to the blockchain node corresponding to each system to be transmitted, and each system to be transmitted is triggered to acquire information from the corresponding blockchain node.
It should be noted that, a specific information transmission mode may be selected according to actual requirements, so that the implementation function of the method provided by the embodiment of the present invention is not affected.
Based on the method provided by the embodiment of the invention, after the database table of the system is changed, a user can send the data dictionary information corresponding to the changed database table to the server so as to trigger the server to determine each system to be sent affected by the data dictionary information according to the data dictionary information corresponding to the original database table of the system, and send the changed data dictionary information to each system to be sent. By applying the method provided by the embodiment of the invention, after the database table of a certain system is changed, the corresponding data dictionary information can be automatically synchronized to each system referencing the data of the database table, and the change behavior is not required to be analyzed by staff, so that the workload of the staff can be reduced, the working efficiency is improved, and the adverse effect caused by manual careless omission on the system work can be avoided, thereby being beneficial to ensuring the normal work of the system.
Furthermore, the method provided by the embodiment of the invention can be realized based on the intelligent contract of the blockchain network, namely, the corresponding intelligent contract can be set according to the method principle shown in fig. 1, and the transmission flow is automatically triggered in the form of the intelligent contract.
Further, on the basis of the method shown in fig. 1, the process for determining the second data dictionary information mentioned in step S101 according to the further data dictionary information transmission method provided by the embodiment of the present invention includes:
determining a system identifier corresponding to the first data dictionary information;
and acquiring data dictionary information corresponding to the system identifier from the blockchain network, and determining the data dictionary information corresponding to the system identifier as the second data dictionary information.
In the method provided by the embodiment of the invention, each piece of data dictionary information stored in the blockchain network contains the system identifier of the corresponding system. And acquiring the system identification of the system corresponding to the data dictionary information from the first data dictionary information, and selecting the data dictionary information corresponding to the system identification from the data dictionary information stored in the blockchain network as second data dictionary information. The second data dictionary information, that is, the data dictionary information corresponding to the database table of the first system before the database table is changed.
Based on the method provided by the embodiment of the invention, the second data dictionary information can be determined according to the system identification, the processing process is simple and quick, and the processing efficiency can be further improved.
In order to better illustrate the method provided by the embodiments of the present invention, a brief description of the data dictionary information stored in the blockchain network follows. The respective data dictionary information may be stored in a blockchain network in a blockwise manner. The data structure diagram of the block may be as shown in fig. 2, and the data dictionary information of each system may include data source information and data table information. The data source information may include database type, belonging application system, IP address, port number, database name, user name and password, etc. The data source information may include a table english name, a field type, a field source (system/table/field), whether null is allowed, and the like.
It should be noted that, the specific data attribute of the data dictionary information mentioned in the embodiment of the present invention is only provided for better explaining an embodiment provided by the method of the present invention, and is not limited to the data attribute in the actual application process, and in the specific implementation process, different attribute description data may be adopted, so that the implementation function of the method provided by the embodiment of the present invention is not affected.
Further, on the basis of the method shown in fig. 1, another method for transmitting data dictionary information is provided in the embodiment of the present invention, the process of determining at least one system to be transmitted in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system mentioned in step S103 includes:
determining source information corresponding to the first system, wherein the source information corresponding to the first system comprises a system identifier and a data table name in the second data dictionary information;
in the method provided by the embodiment of the invention, the system identifier, the data table name and other information of the corresponding system can be obtained from the second data dictionary information and used as the source information corresponding to the first system, and the source information corresponding to the first system is also used for describing some definitions of the original data table.
Determining source information corresponding to each target system, wherein the source information corresponding to each target system comprises a system identifier and a data table name in data dictionary information corresponding to the target system;
in the method provided by the embodiment of the invention, the data with the preset attribute can be obtained from the data dictionary information corresponding to each target system, the obtained data is used as the source information corresponding to each target system, and the obtained data can be the system identifier and the data table name of the corresponding system, namely, some definitions for describing the database table of the system identifier and the data table name.
Determining the reference information corresponding to each target system, wherein the reference information corresponding to each target system comprises a field source identifier in the data dictionary information corresponding to the target system;
in the method provided by the embodiment of the invention, the field source identifier of the field value data source representing the field of the target system can be obtained from the data dictionary information corresponding to each target system and used as the reference information corresponding to each target system. In a specific implementation, the data dictionary information may include a plurality of field source identifiers.
Judging whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system, and determining each target system having the data reference relationship with the first system as the system to be sent.
In the method provided by the embodiment of the invention, whether each target system has a data reference relationship with the first system can be judged according to the source information of the first system, the source information and the reference information of each target system, and specifically, whether the data of each target system is directly or indirectly sourced from the database table of the first system can be judged based on the reference information of each target system. If the reference information of the target system is matched with the source information of the first system, the database table representing the target system has a data reference relation directly referencing the database table of the first system, and if the reference information of the target system can be traced back to the first system by being matched with the source information of other target systems, the database table representing the target system has a data reference relation indirectly referencing the database table of the first system. When the database tables of the target system and the first system have direct or indirect data reference relationship, the target system and the first system are considered to have data reference relationship. And taking each target system with a reference relation with the first system as a system to be sent.
Based on the method provided by the embodiment, comprehensive data reference analysis can be performed based on the source information of the first system and the source information and reference information of each target system, all target systems directly or indirectly referring to the first system can be screened out to serve as each system to be sent, the processing efficiency is high, the determination of the affected systems is comprehensive, and the accuracy of information synchronization is guaranteed.
In order to better explain the method provided by the embodiment of the present invention, on the basis of the foregoing embodiment, the embodiment of the present invention provides a method for transmitting data dictionary information, where the process for determining whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system mentioned in the foregoing embodiment includes:
determining a reference relation between each target system and the first system according to the reference information corresponding to each target system and the source information corresponding to the first system;
in the method provided by the embodiment of the invention, the data sources in the database table of each target system can be judged to be the database table of the first system according to the matching of the reference information corresponding to each target system and the source information of the first system, so as to determine whether a direct reference relationship exists between each target system and the first system.
Determining a reference relation between each target system based on source information and reference information corresponding to each target system;
in the method provided by the embodiment of the invention, the matching can be performed among the target systems according to the source information and the reference information of each target system, namely, for each target system, the corresponding reference information is matched with the source information of each other target system, so as to judge whether the data source in the database table of each target system is the database table of a certain other target system or not, and whether a direct reference relation exists between each target system and each other target system or not is determined.
Constructing a tree structure according to the reference relation between each target system and the first system and the reference relation between each target system, wherein the tree structure comprises a first node and nodes corresponding to each target system, and the first node is a node corresponding to the first system;
in the method provided by the embodiment of the invention, the first system and each target system can be respectively used as a node to construct a tree structure. The connection relation of each node in the tree structure is determined based on the reference relation between the first system, each target system and other systems, the node corresponding to each system is connected with the node of the system with the direct reference relation, the node of the referenced system is a father node, and the system node of the referenced system is a child node.
And judging whether the node corresponding to each target system is a subtree node corresponding to the first node or not, and if the node corresponding to the target system is the subtree node corresponding to the first node, determining that the target system and the first system have a data reference relationship.
In the method provided by the embodiment of the invention, the subtree corresponding to the first node can be determined according to the constructed tree structure, namely, the subtree taking the node corresponding to the first system as the root node, each node except the root node in the subtree is directly or indirectly connected with the root node, namely, the system corresponding to each node except the root node in the subtree is described, and the database table of the first system is indirectly or directly referenced. And if the node corresponding to the target system is a subtree node in the subtree, determining that the target system and the first system have a data reference relationship. That is, the target system corresponding to each node except the root node in the subtree is determined as the target system having the data reference relation with the first system.
Based on the method provided by the embodiment of the invention, a tree structure can be constructed according to the data dictionary information of each system, each target system with the data source of the database table of the first system is analyzed by the tree structure, and the system range influenced by the database table change of the first system is obtained. Based on the tree structure, the explicit reference relation of all the systems can be obtained, which is favorable for identifying all the direct or indirect reference relations, and can further improve the identification accuracy of the reference relation.
Further, on the basis of the method provided in the foregoing embodiment, the embodiment of the present invention provides a method for transmitting data dictionary information, where the determining, according to the reference information corresponding to each target system and the source information corresponding to the first system, the reference relationship between each target system and the first system includes:
and judging whether the reference information corresponding to the target system is matched with the source information corresponding to the first system or not for each target system, and if the reference information corresponding to the target system is matched with the source information corresponding to the first system, determining that the target system and the first system have a reference relationship.
In the method provided by the embodiment of the invention, the reference information of each target system can be matched with the source information of the first system so as to judge whether the data source of the database table of each target system is the database table of the first system. Specifically, if the field source identifier in the reference information of the target system is the same as the system identifier or the data table name in the source information of the first system, it is determined that the reference information of the target system is matched with the source information of the first system, so that the database table of the target system has a reference to the database table of the first system, that is, a reference relationship exists between the target system and the first system.
Based on the method provided by the embodiment of the invention, the field source identifier can be set in the data dictionary information, whether the reference relationship exists between the target system and the first system can be rapidly determined according to the matching of the field source identifier, and the data processing speed can be further improved.
Further, as mentioned in the method provided in the foregoing embodiment, the principle of determining the reference relationship between each target system may be referred to in the foregoing description of determining the reference relationship between each target system and the first system, that is, the principle of determining the reference relationship between each target system and any other target system is the same as the principle of determining the reference relationship between each target system and the first system, which is not repeated herein.
In order to better illustrate the method provided by the embodiment of the present invention, on the basis of the method shown in fig. 1, the embodiment of the present invention provides another method for transmitting data dictionary information, where a flowchart of the method is shown in fig. 3, and the method provided by the embodiment of the present invention further includes:
s105: and sending the first data dictionary information to the blockchain network, so that the blockchain network stores the first data dictionary information.
In the method provided by the embodiment of the invention, the management system of the data dictionary information can be used for storing all the data dictionary information and responding to the change of the data dictionary information. In the case of receiving the first data dictionary transmitted by the user, that is, the data dictionary information corresponding to the first system is changed. The first data dictionary information may be sent to the blockchain network to trigger the blockchain network to generate a corresponding block based on a preset intelligent contract, so as to store the first data dictionary information, that is, update the data dictionary information corresponding to the first system in the blockchain network to the first data dictionary information.
According to the method provided by the embodiment of the invention, the first data dictionary information, namely the data dictionary information corresponding to the current database table after the first system is changed, can be further sent to the blockchain network for storage, and the data dictionary information of the first system stored in the blockchain network can be updated so as to facilitate the subsequent management of the data dictionary information of the first system.
Corresponding to the transmission method of the data dictionary information shown in fig. 1, the embodiment of the invention further provides a transmission device of the data dictionary information, which is used for implementing the method shown in fig. 1, and the structure schematic diagram is shown in fig. 4, and includes:
A first determining unit 201, configured to determine, when first data dictionary information sent by a user is received, second data dictionary information and a first system corresponding to the first data dictionary information, where the second data dictionary information corresponds to the first system;
a second determining unit 202, configured to determine, in each system corresponding to a preset blockchain network, each target system corresponding to the first system, and obtain data dictionary information corresponding to each target system stored in the blockchain network;
a third determining unit 203, configured to determine at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system;
a first sending unit 204, configured to send the first data dictionary information to each of the systems to be sent.
Based on the device provided by the embodiment of the invention, after the database table of the system is changed, a user can send the data dictionary information corresponding to the changed database table to the server so as to trigger the server to determine each system to be sent affected by the data dictionary information according to the data dictionary information corresponding to the original database table of the system, and send the changed data dictionary information to each system to be sent. By applying the device provided by the embodiment of the invention, after the database table of a certain system is changed, the corresponding data dictionary information can be automatically synchronized to each system referencing the data of the system, and the change behavior is not required to be analyzed by staff, so that the workload of the staff can be reduced, the working efficiency is improved, and the adverse effect caused by manual careless omission on the system work can be avoided, thereby being beneficial to ensuring the normal work of the system.
On the basis of the device shown in fig. 4, the embodiment of the invention provides a further device for transmitting data dictionary information, the structure schematic diagram of which is shown in fig. 5, and the device provided in the embodiment of the invention further comprises:
and a second sending unit 205, configured to send the first data dictionary information to the blockchain network, so that the blockchain network stores the first data dictionary information.
On the basis of the apparatus provided by the foregoing embodiment, in the apparatus provided by the embodiment of the present invention, the first determining unit 201 includes:
a first determining subunit, configured to determine a system identifier corresponding to the first data dictionary information;
and the second determining subunit is used for acquiring the data dictionary information corresponding to the system identifier from the blockchain network and determining the data dictionary information corresponding to the system identifier as the second data dictionary information.
On the basis of the apparatus provided by the foregoing embodiment, in the apparatus provided by the embodiment of the present invention, the third determining unit 203 includes:
a third determining subunit, configured to determine source information corresponding to the first system, where the source information corresponding to the first system includes a system identifier and a data table name in the second data dictionary information;
A fourth determining subunit, configured to determine source information corresponding to each target system, where the source information corresponding to each target system includes a system identifier and a data table name in the data dictionary information corresponding to the target system;
a fifth determining subunit, configured to determine reference information corresponding to each target system, where the reference information corresponding to each target system includes a field source identifier in the data dictionary information corresponding to the target system;
the first judging subunit is configured to judge whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system, and determine each target system having a data reference relationship with the first system as the system to be sent.
On the basis of the device provided by the foregoing embodiment, in the device provided by the embodiment of the present invention, the first judging subunit includes:
a sixth determining subunit, configured to determine, according to the reference information corresponding to each target system and the source information corresponding to the first system, a reference relationship between each target system and the first system;
A seventh determining subunit, configured to determine a reference relationship between each target system based on source information and reference information corresponding to each target system;
the building subunit is used for building a tree structure according to the reference relation between each target system and the first system and the reference relation between each target system, wherein the tree structure comprises a first node and a node corresponding to each target system, and the first node is a node corresponding to the first system;
and the second judging subunit is used for judging whether the node corresponding to the target system is a subtree node corresponding to the first node for each target system, and if the node corresponding to the target system is the subtree node corresponding to the first node, determining that the target system and the first system have a data reference relationship.
On the basis of the apparatus provided by the foregoing embodiment, in the apparatus provided by the embodiment of the present invention, the sixth determining subunit includes:
and the third judging subunit is used for judging whether the reference information corresponding to the target system is matched with the source information corresponding to the first system or not for each target system, and if the reference information corresponding to the target system is matched with the source information corresponding to the first system, determining that the target system and the first system have a reference relationship.
The embodiment of the invention also provides a storage medium, which comprises stored instructions, wherein the equipment where the storage medium is located is controlled to execute the data dictionary information transmission method when the instructions run.
The embodiment of the present invention further provides an electronic device, whose structural schematic diagram is shown in fig. 6, specifically including a memory 301, and one or more instructions 302, where the one or more instructions 302 are stored in the memory 301, and configured to be executed by the one or more processors 303, where the one or more instructions 302 perform the following operations:
when first data dictionary information sent by a user is received, determining second data dictionary information and a first system corresponding to the first data dictionary information, wherein the second data dictionary information corresponds to the first system;
determining each target system corresponding to the first system in each system corresponding to a preset blockchain network, and acquiring data dictionary information corresponding to each target system stored in the blockchain network;
determining at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system;
And sending the first data dictionary information to each system to be sent.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for a system or system embodiment, since it is substantially similar to a method embodiment, the description is relatively simple, with reference to the description of the method embodiment being made in part. The systems and system embodiments described above are merely illustrative, wherein the elements illustrated as separate elements may or may not be physically separate, and the elements shown as elements may or may not be physical elements, may be located in one place, or may be distributed over a plurality of network elements. Some or all of the modules may be selected according to actual needs to achieve the purpose of the solution of this embodiment. Those of ordinary skill in the art will understand and implement the present invention without undue burden.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative elements and steps are described above generally in terms of functionality in order to clearly illustrate the interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the solution. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present invention.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present invention. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the invention. Thus, the present invention is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.
Claims (7)
1. A method for transmitting data dictionary information, comprising:
when first data dictionary information sent by a user is received, determining second data dictionary information and a first system corresponding to the first data dictionary information, wherein the second data dictionary information corresponds to the first system; the first data dictionary information is generated after the database table corresponding to the first system is changed; the second data dictionary information is the data dictionary information corresponding to the database table of the first system before the current change occurs;
determining each target system corresponding to the first system in each system corresponding to a preset blockchain network, and acquiring data dictionary information corresponding to each target system stored in the blockchain network;
Determining at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system;
transmitting the first data dictionary information to each system to be transmitted;
wherein determining at least one system to be transmitted in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system includes:
determining source information corresponding to the first system, wherein the source information corresponding to the first system comprises a system identifier and a data table name in the second data dictionary information;
determining source information corresponding to each target system, wherein the source information corresponding to each target system comprises a system identifier and a data table name in data dictionary information corresponding to the target system;
determining the reference information corresponding to each target system, wherein the reference information corresponding to each target system comprises a field source identifier in the data dictionary information corresponding to the target system;
judging whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system, and determining each target system having the data reference relationship with the first system as the system to be sent;
The determining whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system includes:
judging whether the reference information corresponding to the target system is matched with the source information corresponding to the first system or not for each target system, and if the reference information corresponding to the target system is matched with the source information corresponding to the first system, determining that a reference relationship exists between the target system and the first system;
determining a reference relation between each target system based on source information and reference information corresponding to each target system;
constructing a tree structure according to the reference relation between each target system and the first system and the reference relation between each target system, wherein the tree structure comprises a first node and nodes corresponding to each target system, and the first node is a node corresponding to the first system;
and judging whether the node corresponding to each target system is a subtree node corresponding to the first node or not, and if the node corresponding to the target system is the subtree node corresponding to the first node, determining that the target system and the first system have a data reference relationship.
2. The method of claim 1, wherein the determining the second data dictionary information comprises:
determining a system identifier corresponding to the first data dictionary information;
and acquiring data dictionary information corresponding to the system identifier from the blockchain network, and determining the data dictionary information corresponding to the system identifier as the second data dictionary information.
3. The method as recited in claim 1, further comprising:
and sending the first data dictionary information to the blockchain network, so that the blockchain network stores the first data dictionary information.
4. A transmission apparatus for data dictionary information, comprising:
a first determining unit, configured to determine, when first data dictionary information sent by a user is received, second data dictionary information and a first system corresponding to the first data dictionary information, where the second data dictionary information corresponds to the first system; the first data dictionary information is generated after the database table corresponding to the first system is changed; the second data dictionary information is the data dictionary information corresponding to the database table of the first system before the current change occurs;
The second determining unit is used for determining each target system corresponding to the first system in each system corresponding to a preset blockchain network and acquiring data dictionary information corresponding to each target system stored in the blockchain network;
a third determining unit, configured to determine at least one system to be sent in each target system according to the data dictionary information and the second data dictionary information corresponding to each target system;
a first sending unit, configured to send the first data dictionary information to each system to be sent;
wherein the third determining unit includes:
a third determining subunit, configured to determine source information corresponding to the first system, where the source information corresponding to the first system includes a system identifier and a data table name in the second data dictionary information;
a fourth determining subunit, configured to determine source information corresponding to each target system, where the source information corresponding to each target system includes a system identifier and a data table name in the data dictionary information corresponding to the target system;
a fifth determining subunit, configured to determine reference information corresponding to each target system, where the reference information corresponding to each target system includes a field source identifier in the data dictionary information corresponding to the target system;
The first judging subunit is used for judging whether each target system has a data reference relationship with the first system according to the source information corresponding to the first system and the source information and the reference information corresponding to each target system, and determining each target system having the data reference relationship with the first system as the system to be sent;
wherein the first judging subunit includes:
a sixth determining subunit, configured to determine, for each target system, whether reference information corresponding to the target system matches source information corresponding to the first system, and if the reference information corresponding to the target system matches the source information corresponding to the first system, determine that a reference relationship exists between the target system and the first system;
a seventh determining subunit, configured to determine a reference relationship between each target system based on source information and reference information corresponding to each target system;
the building subunit is used for building a tree structure according to the reference relation between each target system and the first system and the reference relation between each target system, wherein the tree structure comprises a first node and a node corresponding to each target system, and the first node is a node corresponding to the first system;
And the second judging subunit is used for judging whether the node corresponding to the target system is a subtree node corresponding to the first node for each target system, and if the node corresponding to the target system is the subtree node corresponding to the first node, determining that the target system and the first system have a data reference relationship.
5. The apparatus as recited in claim 4, further comprising:
and the second sending unit is used for sending the first data dictionary information to the blockchain network so that the blockchain network stores the first data dictionary information.
6. A storage medium comprising stored instructions, wherein the instructions, when executed, control a device in which the storage medium is located to perform a method for transferring data dictionary information according to any one of claims 1-3.
7. An electronic device comprising a memory and one or more instructions, wherein the one or more instructions are stored in the memory and configured to be executed by the one or more processors to perform a method of transferring data dictionary information according to any one of claims 1-3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110851655.XA CN113486024B (en) | 2021-07-27 | 2021-07-27 | Data dictionary information transmission method and device, storage medium and electronic equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110851655.XA CN113486024B (en) | 2021-07-27 | 2021-07-27 | Data dictionary information transmission method and device, storage medium and electronic equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113486024A CN113486024A (en) | 2021-10-08 |
| CN113486024B true CN113486024B (en) | 2024-04-09 |
Family
ID=77944163
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110851655.XA Active CN113486024B (en) | 2021-07-27 | 2021-07-27 | Data dictionary information transmission method and device, storage medium and electronic equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113486024B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101133416A (en) * | 2005-03-04 | 2008-02-27 | 株式会社东芝 | Database management apparatus and method of managing database |
| CN107844588A (en) * | 2017-11-17 | 2018-03-27 | 中国银行股份有限公司 | A kind of processing method of data dictionary, device, storage medium and processor |
| CN108132957A (en) * | 2016-12-01 | 2018-06-08 | 中国移动通信有限公司研究院 | A kind of data base processing method and device |
| CN109710703A (en) * | 2019-01-03 | 2019-05-03 | 北京顺丰同城科技有限公司 | A kind of generation method and device of genetic connection network |
| CN112000671A (en) * | 2020-08-24 | 2020-11-27 | 中国银行股份有限公司 | Block chain-based database table processing method, device and system |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7174341B2 (en) * | 2001-05-31 | 2007-02-06 | Synopsys, Inc. | Dynamic database management system and method |
-
2021
- 2021-07-27 CN CN202110851655.XA patent/CN113486024B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101133416A (en) * | 2005-03-04 | 2008-02-27 | 株式会社东芝 | Database management apparatus and method of managing database |
| CN108132957A (en) * | 2016-12-01 | 2018-06-08 | 中国移动通信有限公司研究院 | A kind of data base processing method and device |
| CN107844588A (en) * | 2017-11-17 | 2018-03-27 | 中国银行股份有限公司 | A kind of processing method of data dictionary, device, storage medium and processor |
| CN109710703A (en) * | 2019-01-03 | 2019-05-03 | 北京顺丰同城科技有限公司 | A kind of generation method and device of genetic connection network |
| CN112000671A (en) * | 2020-08-24 | 2020-11-27 | 中国银行股份有限公司 | Block chain-based database table processing method, device and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113486024A (en) | 2021-10-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10191736B2 (en) | Systems and methods for tracking configuration file changes | |
| US8938421B2 (en) | Method and a system for synchronizing data | |
| US10715388B2 (en) | Using a container orchestration service for dynamic routing | |
| US20170115977A1 (en) | Apparatus and method for automating the installation and configuration of infrastructure | |
| US11159390B2 (en) | Systems and methods for service-aware mapping of a system infrastructure | |
| US10038753B2 (en) | Network-independent programming model for online processing in distributed systems | |
| WO2009042204A1 (en) | Autopropagation of business intelligence metadata | |
| US10545951B1 (en) | Workflow dependency management system | |
| US11411830B2 (en) | Systems and methods for determining entry points for mapping a network | |
| US20150286505A1 (en) | Computing system resource provisioning | |
| US11226978B2 (en) | Systems and methods for dynamic creation of schemas | |
| CN116701330A (en) | Logistics information sharing method, device, equipment and storage medium | |
| CN114416868A (en) | Data synchronization method, device, equipment and storage medium | |
| CN113486024B (en) | Data dictionary information transmission method and device, storage medium and electronic equipment | |
| US20150317330A1 (en) | Storing data to multiple storage location types in a distributed historization system | |
| US10417228B2 (en) | Apparatus and method for analytical optimization through computational pushdown | |
| US8869122B2 (en) | Extensible executable modeling | |
| US20230069124A1 (en) | Schema based type-coercion for structured documents | |
| CN109634976A (en) | O&M method, apparatus, system and the readable storage medium storing program for executing of non-relational database | |
| CN114020368A (en) | Information processing method and device based on state machine and storage medium | |
| CN111625866A (en) | Authority management method, system, equipment and storage medium | |
| US20200302349A1 (en) | Action determination for case management | |
| JP6549537B2 (en) | Service providing system and service providing method | |
| JP6200377B2 (en) | Virtual DB system and information processing method for virtual DB system | |
| CN113504955A (en) | BPMN-based aerospace workflow management 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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |