CN114328599A - Method and system for analyzing mapping relation between data standard and constraint object - Google Patents
Method and system for analyzing mapping relation between data standard and constraint object Download PDFInfo
- Publication number
- CN114328599A CN114328599A CN202111572561.5A CN202111572561A CN114328599A CN 114328599 A CN114328599 A CN 114328599A CN 202111572561 A CN202111572561 A CN 202111572561A CN 114328599 A CN114328599 A CN 114328599A
- Authority
- CN
- China
- Prior art keywords
- data
- constraint object
- data standard
- constraint
- standard
- 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
- 238000013507 mapping Methods 0.000 title claims abstract description 37
- 238000000034 method Methods 0.000 title claims abstract description 27
- 238000012216 screening Methods 0.000 claims description 14
- 230000000694 effects Effects 0.000 claims description 13
- 238000004458 analytical method Methods 0.000 abstract description 9
- 238000004141 dimensional analysis Methods 0.000 abstract description 6
- 238000005516 engineering process Methods 0.000 abstract description 5
- 238000010586 diagram Methods 0.000 description 10
- 238000004590 computer program Methods 0.000 description 7
- 230000008569 process Effects 0.000 description 7
- 238000007726 management method Methods 0.000 description 6
- 238000012986 modification Methods 0.000 description 5
- 230000004048 modification Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 4
- 238000004364 calculation method Methods 0.000 description 2
- 238000013499 data model Methods 0.000 description 2
- 230000004075 alteration Effects 0.000 description 1
- 238000012098 association analyses Methods 0.000 description 1
- 230000006399 behavior Effects 0.000 description 1
- 238000007796 conventional method Methods 0.000 description 1
- 238000007405 data analysis Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a system for analyzing a mapping relation between a data standard and a constraint object. Wherein, the method comprises the following steps: storing the incidence relation between the data standard and the constraint object in a data table; retrieving by taking the data standard as an element, and inquiring a constraint object associated with the data standard; and searching by taking the constraint object as an element, and inquiring the data standard associated with the constraint object. Therefore, the constraint object dimension is added for analyzing and displaying the data standard mapping relation, the limitation of analyzing the mapping relation by independently using the data standard dimension is made up, the problem that the running performance is influenced by data redundancy possibly brought by technical realization is considered, the index technology is adopted for realizing quick single-table query, and the running performance of analysis is ensured while the data standard and the constraint object two-dimensional analysis mapping relation is realized.
Description
Technical Field
The present invention relates to the field of data analysis technologies, and in particular, to a method and a system for analyzing a mapping relationship between a data standard and a constraint object.
Background
Data becomes an asset and is already a consensus in the industry. Data Governance (Data godernance) is a whole set of management behaviors in an organization related to Data use, and is a series of policies and procedures on how to make and implement application and technical management of Data. The use of data governance systems or proximity tools for data governance has received a high degree of attention in countries, governments, industries, associations and the like, and has performed a number of tasks.
The data standard refers to normative constraints for guaranteeing the consistency and accuracy of internal and external use and exchange of data, and can be generally divided into a basic data standard and an index data standard. The base class data standards generally include reference data and main data standards, logical data model standards, physical data model standards, metadata standards, common code and encoding standards, and the like. The index-type data standard is generally classified into a basic index standard and a calculation index (also called a combined index) standard. The basic indexes generally do not contain dimension information and have specific business and economic meanings, and the calculation indexes are usually calculated by more than two basic indexes.
In a data governance scene, data standards are numerous, and constraint objects associated with the standards are also distributed in metadata of different data sources and different dimensions. The data standard and the constraint object are analyzed difficultly, and the data standard dimension is used for displaying the mapping relation of the data standard in the general data standard management process, namely, a user can only check a certain data standard association constraint object when analyzing the mapping relation, and the requirements of diversified, multi-dimensional and comprehensive analysis of the data standard cannot be met. In the general data standard management process, the number of fields of a back-end information storage base table is large, if a plurality of tables are created to meet the multi-dimensional analysis incidence relation, certain performance loss can be generated in the data processing and analyzing process, and the redundancy rate of system data is high. Therefore, a method is needed to satisfy the user's understanding and viewing of the mapping relationships of various data standards and various constraint objects.
In order to clearly show the mapping relation between the data standard and the constraint object from different dimensions and different objects after the data standard is effectively mapped and associated to the constraint object, the data standard management can be effectively carried out, and the data quality is improved.
Disclosure of Invention
According to the invention, a method and a system for analyzing the mapping relation between the data standard and the constraint object are provided, so as to solve the technical problems that the mapping relation between the data standard and the constraint object is difficult to analyze and the mapping relation between the data standard and the constraint object is displayed by using the data standard dimension in the common data standard management process in the prior art.
According to a first aspect of the present invention, there is provided a method for analyzing a mapping relationship between a data standard and a constraint object, comprising:
storing the incidence relation between the data standard and the constraint object in a data table;
retrieving by taking the data standard as an element, and inquiring a constraint object associated with the data standard;
and searching by taking the constraint object as an element, and inquiring the data standard associated with the constraint object.
Optionally, the association relationship includes data standard, constraint object attribute, constraint rule, and whether to take effect.
Optionally, storing the association relationship between the data standard and the constraint object in a data table includes:
recording the data standard and the constraint object in a data table after one-to-one correspondence;
determining that each record corresponds to a main key, creating two index files of a data standard and a constraint object, calling the two index files of the data standard and the constraint object to carry out screening retrieval during retrieval, and inquiring a corresponding index to carry out inquiry screening and output during dimension switching.
Optionally, the searching with the data standard as an element and querying the constraint object associated with the data standard includes:
and searching by taking the data standard as an element, inquiring a constraint object associated with the data standard, and displaying a certain field constrained by the standard rule by outputting a plurality of layers of a data source and a database table where the constraint object is located.
Optionally, the searching by taking the constraint object as an element, and querying the data standard associated with the constraint object, includes:
and searching by taking the constraint object as a factor, and inquiring a data standard having a constraint effect with the constraint object.
According to another aspect of the present invention, there is also provided a system for analyzing a mapping relationship between a data standard and a constraint object, including:
the storage incidence relation module is used for storing the incidence relation between the data standard and the constraint object in a data table;
the query constraint object module is used for retrieving by taking the data standard as an element and querying a constraint object associated with the data standard;
and the query data standard module is used for searching by taking the constraint object as an element and querying the data standard associated with the constraint object.
Optionally, the association relationship includes data standard, constraint object attribute, constraint rule, and whether to take effect.
Optionally, the storage association relation module includes:
the recording submodule is used for recording the data standard and the constraint object in a data table after one-to-one correspondence;
and the query output sub-module is used for determining that each record corresponds to one main key, creating two index files of a data standard and a constraint object, calling the two index files of the data standard and the constraint object for screening and searching during searching, and querying the corresponding index for query screening and output during dimension switching.
Optionally, the query constraint object module comprises:
and the query constraint object submodule is used for searching by taking the data standard as an element, querying a constraint object associated with the data standard, and displaying a certain field constrained by the standard rule through outputting a plurality of layers of a data source and a database table where the constraint object is positioned.
Optionally, the query data standard module includes:
and the query data standard submodule is used for searching by taking the constraint object as an element and querying the data standard with the constraint effect on the constraint object.
Therefore, the constraint object dimension is added for analyzing and displaying the data standard mapping relation, the limitation of analyzing the mapping relation by independently using the data standard dimension is made up, the problem that the running performance is influenced by data redundancy possibly brought by technical realization is considered, the index technology is adopted for realizing quick single-table query, and the running performance of analysis is ensured while the data standard and the constraint object two-dimensional analysis mapping relation is realized.
Drawings
A more complete understanding of exemplary embodiments of the present invention may be had by reference to the following drawings in which:
FIG. 1 is a flowchart illustrating a method for analyzing a mapping relationship between a data standard and a constraint object according to the present embodiment;
FIG. 2 is a diagram illustrating a data standard mapping relationship according to the present embodiment;
fig. 3 is a schematic diagram of a system for analyzing a mapping relationship between a data standard and a constraint object according to the present embodiment.
Detailed Description
The exemplary embodiments of the present invention will now be described with reference to the accompanying drawings, however, the present invention may be embodied in many different forms and is not limited to the embodiments described herein, which are provided for complete and complete disclosure of the present invention and to fully convey the scope of the present invention to those skilled in the art. The terminology used in the exemplary embodiments illustrated in the accompanying drawings is not intended to be limiting of the invention. In the drawings, the same units/elements are denoted by the same reference numerals.
Unless otherwise defined, terms (including technical and scientific terms) used herein have the same meaning as commonly understood by one of ordinary skill in the art to which this invention belongs. Further, it will be understood that terms, such as those defined in commonly used dictionaries, should be interpreted as having a meaning that is consistent with their meaning in the context of the relevant art and will not be interpreted in an idealized or overly formal sense.
According to a first aspect of the present invention, there is provided a method 100 for analyzing a mapping relationship between a data standard and a constraint object, referring to fig. 1, the method 100 comprising:
s101, storing the incidence relation between the data standard and the constraint object in a data table;
s102, retrieving by taking the data standard as an element, and inquiring a constraint object associated with the data standard;
and S103, searching by taking the constraint object as an element, and inquiring the data standard associated with the constraint object.
Specifically, aiming at the problems in the existing data standard mapping association analysis application scene, the dimension of the constraint object is added through the multi-dimensional mapping relation display of the data standard and the constraint object, and the comprehensive display of the multi-dimensional data standard and the constraint object association relation is realized through the data standard displaying the mapping association relation of the data standard and the constraint object.
Referring to fig. 2, when the association relationship is analyzed according to the data standard dimension, the relationship between the data standard and the constraint object is stored in the data table, and the information is often composed of a plurality of parts, such as the data standard, the constraint object attribute (where the data standard exists, the database table), the constraint rule, whether the constraint rule is valid, and the like. In the process of analyzing the association relation by using the data standard dimension, the data standard is used as an element for searching, a constraint object associated with a certain data standard is inquired, and a certain field constrained by a standard rule is displayed finally by outputting multiple layers of a data source and a database table where the constraint object is located.
On the basis, the dimensionality of the analysis association relationship of the constraint object is increased, the multi-dimensional analysis data standard and data are met, the analysis association relationship is analyzed by taking the constraint object as the dimensionality, the retrieval is carried out by taking the constraint object as an element, the data standard with constraint effect of a certain object is inquired, and the standard of the data with effective constraint enables a user to more comprehensively grasp the standard falling situation and the quality state of the constraint object.
Meanwhile, whether the analysis is carried out by data standard or constraint object dimension, in the process of storing the corresponding information, a corresponding relation is taken as a record, each record corresponds to a main key, two index files of the data standard and the constraint object are created, the two index files of the data standard and the constraint object are called for screening and searching during searching, and the corresponding index is quickly inquired for inquiry screening and output during dimension switching. The analysis of the multi-dimensional data standard and the constraint object incidence relation is realized; the data redundancy in the conventional method is reduced, and the retrieval query speed is optimized.
Therefore, the constraint object dimension is added for analyzing and displaying the data standard mapping relation, the limitation of analyzing the mapping relation by independently using the data standard dimension is made up, the problem that the running performance is influenced by data redundancy possibly brought by technical realization is considered, the index technology is adopted for realizing quick single-table query, and the running performance of analysis is ensured while the data standard and the constraint object two-dimensional analysis mapping relation is realized.
Optionally, the association relationship includes data standard, constraint object attribute, constraint rule, and whether to take effect.
Optionally, storing the association relationship between the data standard and the constraint object in a data table includes:
recording the data standard and the constraint object in a data table after one-to-one correspondence;
determining that each record corresponds to a main key, creating two index files of a data standard and a constraint object, calling the two index files of the data standard and the constraint object to carry out screening retrieval during retrieval, and inquiring a corresponding index to carry out inquiry screening and output during dimension switching.
Optionally, the searching with the data standard as an element and querying the constraint object associated with the data standard includes:
and searching by taking the data standard as an element, inquiring a constraint object associated with the data standard, and displaying a certain field constrained by the standard rule by outputting a plurality of layers of a data source and a database table where the constraint object is located.
Optionally, the searching by taking the constraint object as an element, and querying the data standard associated with the constraint object, includes:
and searching by taking the constraint object as a factor, and inquiring a data standard having a constraint effect with the constraint object.
According to another aspect of the present invention, there is further provided a system 300 for analyzing a mapping relationship between data criteria and constraint objects, as shown in fig. 3, the system 300 includes:
a storage association relation module 310, configured to store an association relation between the data standard and the constraint object in a data table;
a query constraint object module 320, configured to search by using the data standard as an element, and query a constraint object associated with the data standard;
and the query data standard module 330 is used for searching by taking the constraint object as an element and querying the data standard associated with the constraint object.
Optionally, the association relationship includes data standard, constraint object attribute, constraint rule, and whether to take effect.
Optionally, the storage association relation module 310 includes:
the recording submodule is used for recording the data standard and the constraint object in a data table after one-to-one correspondence;
and the query output sub-module is used for determining that each record corresponds to one main key, creating two index files of a data standard and a constraint object, calling the two index files of the data standard and the constraint object for screening and searching during searching, and querying the corresponding index for query screening and output during dimension switching.
Optionally, query constraint object module 320, comprising:
and the query constraint object submodule is used for searching by taking the data standard as an element, querying a constraint object associated with the data standard, and displaying a certain field constrained by the standard rule through outputting a plurality of layers of a data source and a database table where the constraint object is positioned.
Optionally, the query data criteria module 330 includes:
and the query data standard submodule is used for searching by taking the constraint object as an element and querying the data standard with the constraint effect on the constraint object.
Therefore, the constraint object dimension is added for analyzing and displaying the data standard mapping relation, the limitation of analyzing the mapping relation by independently using the data standard dimension is made up, the problem that the running performance is influenced by data redundancy possibly brought by technical realization is considered, the index technology is adopted for realizing quick single-table query, and the running performance of analysis is ensured while the data standard and the constraint object two-dimensional analysis mapping relation is realized.
The system 300 for analyzing the mapping relationship between the data standard and the constraint object according to the embodiment of the present invention corresponds to the method 100 for analyzing the mapping relationship between the data standard and the constraint object according to another embodiment of the present invention, and is not described herein again.
As will be appreciated by one skilled in the art, embodiments of the present application may be provided as a method, system, or computer program product. Accordingly, the present application may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present application 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 scheme in the embodiment of the application can be implemented by adopting various computer languages, such as object-oriented programming language Java and transliterated scripting language JavaScript.
The present application is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems), and computer program products according to embodiments of the application. 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.
While the preferred embodiments of the present application have been described, additional variations and modifications in those embodiments may occur to those skilled in the art once they learn of the basic inventive concepts. Therefore, it is intended that the appended claims be interpreted as including preferred embodiments and all alterations and modifications as fall within the scope of the application.
It will be apparent to those skilled in the art that various changes and modifications may be made in the present application without departing from the spirit and scope of the application. Thus, if such modifications and variations of the present application fall within the scope of the claims of the present application and their equivalents, the present application is intended to include such modifications and variations as well.
Claims (10)
1. A method for analyzing a mapping relationship between a data standard and a constraint object, comprising:
storing the incidence relation between the data standard and the constraint object in a data table;
retrieving by taking the data standard as an element, and inquiring a constraint object associated with the data standard;
and searching by taking the constraint object as an element, and inquiring the data standard associated with the constraint object.
2. The method of claim 1,
the incidence relation comprises data standard, constraint object attribute, constraint rule and whether to take effect or not.
3. The method of claim 1, wherein storing the association of the data criteria to the constraint object in a data table comprises:
recording the data standard and the constraint object in a data table after one-to-one correspondence;
determining that each record corresponds to a main key, creating two index files of a data standard and a constraint object, calling the two index files of the data standard and the constraint object to carry out screening retrieval during retrieval, and inquiring a corresponding index to carry out inquiry screening and output during dimension switching.
4. The method of claim 1, wherein searching for a constraint object associated with a data criterion based on the data criterion comprises:
and searching by taking the data standard as an element, inquiring a constraint object associated with the data standard, and displaying a certain field constrained by the standard rule by outputting a plurality of layers of a data source and a database table where the constraint object is located.
5. The method of claim 1, wherein searching for data criteria associated with the constraint object using the constraint object as an element comprises:
and searching by taking the constraint object as a factor, and inquiring a data standard having a constraint effect with the constraint object.
6. A system for analyzing a mapping relationship between data criteria and constraint objects, comprising:
the storage incidence relation module is used for storing the incidence relation between the data standard and the constraint object in a data table;
the query constraint object module is used for retrieving by taking the data standard as an element and querying a constraint object associated with the data standard;
and the query data standard module is used for searching by taking the constraint object as an element and querying the data standard associated with the constraint object.
7. The system of claim 6,
the incidence relation comprises data standard, constraint object attribute, constraint rule and whether to take effect or not.
8. The system of claim 6, wherein the store association module comprises:
the recording submodule is used for recording the data standard and the constraint object in a data table after one-to-one correspondence;
and the query output sub-module is used for determining that each record corresponds to one main key, creating two index files of a data standard and a constraint object, calling the two index files of the data standard and the constraint object for screening and searching during searching, and querying the corresponding index for query screening and output during dimension switching.
9. The system of claim 6, wherein the query constraint object module comprises:
and the query constraint object submodule is used for searching by taking the data standard as an element, querying a constraint object associated with the data standard, and displaying a certain field constrained by the standard rule through outputting a plurality of layers of a data source and a database table where the constraint object is positioned.
10. The system of claim 6, wherein the query data criteria module comprises:
and the query data standard submodule is used for searching by taking the constraint object as an element and querying the data standard with the constraint effect on the constraint object.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111572561.5A CN114328599A (en) | 2021-12-21 | 2021-12-21 | Method and system for analyzing mapping relation between data standard and constraint object |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111572561.5A CN114328599A (en) | 2021-12-21 | 2021-12-21 | Method and system for analyzing mapping relation between data standard and constraint object |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN114328599A true CN114328599A (en) | 2022-04-12 |
Family
ID=81054632
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111572561.5A Pending CN114328599A (en) | 2021-12-21 | 2021-12-21 | Method and system for analyzing mapping relation between data standard and constraint object |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN114328599A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101510209A (en) * | 2009-03-30 | 2009-08-19 | 北京金山软件有限公司 | Method, system and server for implementing real time search |
| CN109063215A (en) * | 2018-10-16 | 2018-12-21 | 成都四方伟业软件股份有限公司 | Data retrieval method and device |
| CN113626550A (en) * | 2021-08-05 | 2021-11-09 | 生态环境部卫星环境应用中心 | Image tile map service method based on triple bidirectional index and optimized cache |
-
2021
- 2021-12-21 CN CN202111572561.5A patent/CN114328599A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101510209A (en) * | 2009-03-30 | 2009-08-19 | 北京金山软件有限公司 | Method, system and server for implementing real time search |
| CN109063215A (en) * | 2018-10-16 | 2018-12-21 | 成都四方伟业软件股份有限公司 | Data retrieval method and device |
| CN113626550A (en) * | 2021-08-05 | 2021-11-09 | 生态环境部卫星环境应用中心 | Image tile map service method based on triple bidirectional index and optimized cache |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110633292B (en) | Query method, device, medium, equipment and system for heterogeneous database | |
| CN109254966B (en) | Data table query method, device, computer equipment and storage medium | |
| US20220342875A1 (en) | Data preparation context navigation | |
| US8924373B2 (en) | Query plans with parameter markers in place of object identifiers | |
| US9600507B2 (en) | Index structure for a relational database table | |
| US7464084B2 (en) | Method for performing an inexact query transformation in a heterogeneous environment | |
| CN105760418B (en) | Method and system for performing cross-column search on relational database table | |
| CN107408114B (en) | Identifying join relationships based on transactional access patterns | |
| Ikeda et al. | Panda: A system for provenance and data | |
| US8600942B2 (en) | Systems and methods for tables of contents | |
| US10296497B2 (en) | Storing a key value to a deleted row based on key range density | |
| US11853279B2 (en) | Data storage using vectors of vectors | |
| US11068459B2 (en) | Computer implemented and computer controlled method, computer program product and platform for arranging data for processing and storage at a data storage engine | |
| CN106095964A (en) | A kind of method that data are carried out visualization filing and search | |
| US20130024459A1 (en) | Combining Full-Text Search and Queryable Fields in the Same Data Structure | |
| US8396858B2 (en) | Adding entries to an index based on use of the index | |
| US11392632B1 (en) | Systems and methods for locating media using a tag-based query | |
| US20190340272A1 (en) | Systems and related methods for updating attributes of nodes and links in a hierarchical data structure | |
| US20180349443A1 (en) | Edge store compression in graph databases | |
| US9262472B2 (en) | Concatenation for relations | |
| CN114328599A (en) | Method and system for analyzing mapping relation between data standard and constraint object | |
| CN113625967B (en) | Data storage method, data query method and server | |
| CN111984657B (en) | Data collection method, device, storage medium and computer equipment | |
| US11803356B1 (en) | Software requirements creating and tracking system and method | |
| US20090319541A1 (en) | Efficient Identification of Entire Row Uniqueness in Relational Databases |
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 |