CN108197133A - A kind of data governing system based on data standard - Google Patents
A kind of data governing system based on data standard Download PDFInfo
- Publication number
- CN108197133A CN108197133A CN201710962458.9A CN201710962458A CN108197133A CN 108197133 A CN108197133 A CN 108197133A CN 201710962458 A CN201710962458 A CN 201710962458A CN 108197133 A CN108197133 A CN 108197133A
- Authority
- CN
- China
- Prior art keywords
- word
- data
- standard
- term
- dictionary
- 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
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/21—Design, administration or maintenance of 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Machine Translation (AREA)
Abstract
A kind of data governing system based on data standard, the process which administers data include：User is first depending on enterprises system structure and master data type works out a meta data category standard, and user can acquire the other information of each metadata category by two kinds of approach：It imports from metadata and is imported from Excel tables.
Description
Technical field
The invention belongs to data Treatment process field, more particularly to a kind of data governing system based on data standard.
Background technology
The patent document of Publication No. CN102012935A discloses " a kind of that data among systems are administered by Excel
Method ... ... data among systems are administered by Excel method, an automation is provided in a manner of Excel plug-in units
Transfer process, to solve the problems, such as that the translation exception of user's data between the systems is difficult, specific method is related to accessing Excel
Table, source system and source data wherein to be administered, goal systems and the target data for meeting its requirement.It includes five streams
Journey：It exports data, be loaded into template, data conversion, data check, formatting ".
However administer field in data, due between each system data format, coding it is all inconsistent, cause between system
The problem of conversion of data is difficult is still easier what is solved, and since the confusion of term administers problem using caused data
It is only more scabrous problem.
Invention content
The purpose of the application is to provide a kind of data governing system based on data standard, to solve data in the prior art
Predicament in improvement.
A kind of data governing system based on data standard, the process which administers data include：
User is first depending on enterprises system structure and master data type works out a meta data category standard,
User can acquire the other information of each metadata category by two kinds of approach：It is imported from metadata and from Excel
Table imports,
For from the mode imported from metadata, including performing step：
A1 selects the hitch point of metadata storage, is imported accordingly so as to correspond in the metadatabase corresponding to hitch point
Metadata becomes candidate term；
A2 imports the information of acquisition by metadata, tentatively screen, supplements, modification, by data application for word or
Person's term, wherein
Apply for that the data for word jump to the word application page, the part that will differ from system format is improved and mended
It fills, and then submits the application as standard word,
System carries out verification audit, if there are the word in standard word dictionary, authentication failed needs to reject, if not depositing
Representing that verification is out of question, then by audit, auditing result is added to for the data of standard word in standard word dictionary；
Apply for that the data for term jump to the term application page, by tentatively screening, it is perfect, supplement, term is carried out
Morpheme segmentation is combed the form for term+word A+ word B+ words C+ ..., and then submits the Shen as standard term
Please,
System carries out verification audit, if there are the list is not present in the term or standard word dictionary in standard dictionary
Word A or word B or word C, authentication failed then need to reject, on the contrary then be proved to be successful, then audit passes through, and auditing result is standard
The data of term are added in standard dictionary；
For the mode imported from Excel tables, including performing step：
B1 is arranged by business personnel, and metadata in table is directly translated into the form of system requirements, as term+mono-
The form of word A+ word B+ words C+ ...；
B2 imports the information of acquisition by Excel tables, tentatively screen, supplements, modification, is standard by data application
Term,
System carries out verification audit, if there are the list is not present in the term or standard word dictionary in standard dictionary
Word A or word B or word C, authentication failed then need to reject, on the contrary then be proved to be successful, then audit passes through, and auditing result is standard
The data of term are added in standard dictionary.
Acquisition information screen perfect by the present invention in data governance process, applies carrying out for normal data and to it
The system of management.The system includes：UI front-end interfaces, middle-end program and background data base.Data normalization system is to dispersion
Data in each system provide the definition base of a set of unified numerical nomenclature, data definition, data type, assignment rule etc.
Standard, and the science flow of this sets of data standard achievement of O＆M is provided.By the standardization to data, standard list should be finally obtained
Word dictionary and standard two big achievement of dictionary.The range that user can be directed to word/term is searched, according to selected retrieval
Range, system inquire the data for whether having in specified dictionary and meeting search condition automatically.
The present invention can prevent the chaotic of term from using by query criteria data dictionary, maintain the one of enterprise data model
Cause property, it is ensured that the correctness and quality of data, and can improve data productive value improves the consistency and effectively of data management
Property, the data Governance Ability of effective enterprise.
Description of the drawings
Detailed description below, above-mentioned and other mesh of exemplary embodiment of the invention are read by reference to attached drawing
, feature and advantage will become prone to understand.In the accompanying drawings, if showing the present invention's by way of example rather than limitation
Dry embodiment, wherein：
Fig. 1 is the flow chart of data processing figure of data governing system in the embodiment of the present invention.
Fig. 2 is the standard word dictionary exemplary plot of data governing system in the embodiment of the present invention.
Fig. 3 is the standard dictionary exemplary plot of data governing system in the embodiment of the present invention.
Specific embodiment
As shown in Figure 1.Present system is needed in addition to necessary system login process and management module, user according to enterprise
Built-in system structure and master data type work out a meta data category standard, for example metadata is divided into financial class, manpower money
Source class etc..User can acquire the other information of each metadata category by two kinds of approach, be imported from metadata and from Excel tables
It imports.The hitch point that metadata is selected to store is needed from metadata importing, so as to correspond to the metadatabase corresponding to hitch point
Middle importing respective meta-data, becomes candidate term.Business personnel is needed to arrange from the importing of Excel tables, metadata in table is straight
Switch through the form of the form of formation system requirement, as term+word A+ word B+ words C+ ....
By metadata import acquisition information, user can carry out tentatively screen, supplement, modification, next can will
Data application is word or term.Apply for that the data for word jump to the word application page, will differ from system format
Part is improved and is supplemented, and then submits the application as standard word, verification audit is carried out later, if standard word before
There are the word in dictionary, then authentication failed needs to reject, if out of question there is no verification is represented, automatically by or audit
Assistant director can audit manually item by item to be passed through.Auditing result is exported for standard word by the form of Excel tables, is added to standard
In word lexicon.
Apply for that the data for term jump to the term application page, user is by preliminary screening, perfect, supplement, by term
Carry out morpheme segmentation to be combed the form for being term+word A+ word B+ words C+ ..., and then submission becomes standard term
Application, carry out verification audit later, if before in standard dictionary there are the term or before in standard word dictionary not
There are word A or word B or word C, authentication failed then needs to reject, on the contrary then be proved to be successful, then automatically by or examine
Core assistant director can audit manually item by item to be passed through.Auditing result is exported for standard term by the form of Excel tables, is added to mark
In mutatis mutandis dictionary.
By Excel tables import acquisition information, user can carry out tentatively screen, supplement, modification, next can will
Data application is standard term, carries out verification audit later, if there are the term or before standard in standard dictionary before
On the contrary there is no word A or word B or word C in word lexicon, authentication failed then to need to reject, then be proved to be successful, then oneself
It moves to pass through or audit assistant director and can audit manually item by item and pass through.Auditing result is form of the standard term by Excel tables
Export, is added in standard dictionary.
What deserves to be explained is although foregoing teachings describe the essence of the invention by reference to several specific embodiments
God and principle, it should be appreciated that, the present invention is not limited to disclosed specific embodiment, the division also unawareness to various aspects
The feature that taste in these aspects cannot combine, this to divide merely to the convenience of statement.The present invention is directed to cover appended power
Included various modifications and equivalent arrangements in the spirit and scope of profit requirement.
Claims (1)
1. a kind of data governing system based on data standard, which is characterized in that the data governing system administered data
Process includes：User is first depending on enterprises system structure and master data type works out a meta data category standard,
User can acquire the other information of each metadata category by two kinds of approach：It imports from metadata and is led from Excel tables
Enter,
For from the mode imported from metadata, including performing step：
A1 selects the hitch point of metadata storage, and corresponding first number is imported so as to correspond in the metadatabase corresponding to hitch point
According to becoming candidate term；
A2 imports the information of acquisition by metadata, tentatively screen, supplements, modification, is word or use by data application
Language, wherein
Apply for that the data for word jump to word application module, the part that will differ from system format is improved and is supplemented,
And then the application for becoming standard word is submitted,
System carries out verification audit, if there are the word in standard word dictionary, authentication failed needs to reject, if being not present,
It is out of question to represent verification, then by audit, auditing result is added to for the data of standard word in standard word dictionary；
Apply for that the data for term jump to term application module, by tentatively screening, it is perfect, supplement, term is subjected to morpheme
Segmentation is combed the form for term+word A+ word B+ words C+ ..., and then submits the application as standard term,
System carries out verification audit, if there are word A is not present in the term or standard word dictionary in standard dictionary
Or word B or word C, authentication failed then need to reject, on the contrary then be proved to be successful, then audit passes through, and auditing result is standard use
The data of language are added in standard dictionary；
For the mode imported from Excel tables, including performing step：
B1 is arranged by business personnel, and metadata in table is directly translated into the form of system requirements, as term+word A+
The form of word B+ words C+ ...；
B2 imports the information of acquisition by Excel tables, tentatively screen, supplements, modification, is standard term by data application,
System carries out verification audit, if there are word A is not present in the term or standard word dictionary in standard dictionary
Or word B or word C, authentication failed then need to reject, on the contrary then be proved to be successful, then audit passes through, and auditing result is standard use
The data of language are added in standard dictionary.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710962458.9A CN108197133A (en) | 2017-10-17 | 2017-10-17 | A kind of data governing system based on data standard |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710962458.9A CN108197133A (en) | 2017-10-17 | 2017-10-17 | A kind of data governing system based on data standard |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN108197133A true CN108197133A (en) | 2018-06-22 |
Family
ID=62572869
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710962458.9A Pending CN108197133A (en) | 2017-10-17 | 2017-10-17 | A kind of data governing system based on data standard |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN108197133A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109408502A (en) * | 2018-11-14 | 2019-03-01 | 成都四方伟业软件股份有限公司 | A kind of data standard processing method, device and its storage medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050165816A1 (en) * | 2002-03-26 | 2005-07-28 | Harald Schiller | Method and apparatus for using metadata from different sources |
| CN102012935A (en) * | 2010-12-06 | 2011-04-13 | 江西省电力公司信息通信中心 | Method for processing data among systems by using Excel |
| CN105701176A (en) * | 2016-01-04 | 2016-06-22 | 浪潮软件股份有限公司 | Data integration method and apparatus |
| CN106227898A (en) * | 2016-08-31 | 2016-12-14 | 江苏艾倍科科技股份有限公司 | A kind of Big Dipper moves wearable device data and administers platform and data administering method thereof |
| CN107169073A (en) * | 2017-05-09 | 2017-09-15 | 北京智行创远信息科技有限公司 | A kind of data managing method and management platform |
| CN107247788A (en) * | 2017-06-15 | 2017-10-13 | 山东浪潮云服务信息科技有限公司 | A kind of method of the comprehensive regulation service based on government data |
-
2017
- 2017-10-17 CN CN201710962458.9A patent/CN108197133A/en active Pending
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20050165816A1 (en) * | 2002-03-26 | 2005-07-28 | Harald Schiller | Method and apparatus for using metadata from different sources |
| CN102012935A (en) * | 2010-12-06 | 2011-04-13 | 江西省电力公司信息通信中心 | Method for processing data among systems by using Excel |
| CN105701176A (en) * | 2016-01-04 | 2016-06-22 | 浪潮软件股份有限公司 | Data integration method and apparatus |
| CN106227898A (en) * | 2016-08-31 | 2016-12-14 | 江苏艾倍科科技股份有限公司 | A kind of Big Dipper moves wearable device data and administers platform and data administering method thereof |
| CN107169073A (en) * | 2017-05-09 | 2017-09-15 | 北京智行创远信息科技有限公司 | A kind of data managing method and management platform |
| CN107247788A (en) * | 2017-06-15 | 2017-10-13 | 山东浪潮云服务信息科技有限公司 | A kind of method of the comprehensive regulation service based on government data |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109408502A (en) * | 2018-11-14 | 2019-03-01 | 成都四方伟业软件股份有限公司 | A kind of data standard processing method, device and its storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| WO2020233330A1 (en) | Batch testing method, apparatus, and computer-readable storage medium | |
| US20190272329A1 (en) | Statistical process control and analytics for translation supply chain operational management | |
| EP2565802B1 (en) | Data masking setup | |
| CN104572895B (en) | MPP databases and Hadoop company-datas interoperability methods, instrument and implementation method | |
| CN103793422B (en) | Methods for generating cube metadata and query statements on basis of enhanced star schema | |
| EP2608074A2 (en) | Systems and methods for merging source records in accordance with survivorship rules | |
| US10599635B1 (en) | Control systems with independent data processing | |
| EP1990740A1 (en) | Schema matching for data migration | |
| US11170022B1 (en) | Method and device for processing multi-source heterogeneous data | |
| CN107357933A (en) | A kind of label for multi-source heterogeneous science and technology information resource describes method and apparatus | |
| US20220261395A1 (en) | Multi-table data validation tool | |
| CN110457676A (en) | Extracting method and device, storage medium, the computer equipment of evaluation information | |
| AU2015331030A1 (en) | System generator module for electronic document and electronic file | |
| CN107016094A (en) | A kind of project shared file multi-person synergy development approach, apparatus and system | |
| US11842286B2 (en) | Machine learning platform for structuring data in organizations | |
| CN112651218A (en) | Automatic generation method and management method of bidding document, medium and computer | |
| CN106815366A (en) | A kind of method and system of Mass production data | |
| CN106933859A (en) | The moving method and device of a kind of medical data | |
| CN110765101A (en) | Label generation method and device, computer readable storage medium and server | |
| CN107748775A (en) | A kind of data governing system based on the quality of data | |
| CN115221143A (en) | Cross-type migration operator-based multi-source big data processing method | |
| CN111177181A (en) | SQL text auditing method, system, storage medium and device | |
| CN108197133A (en) | A kind of data governing system based on data standard | |
| CN109542869A (en) | A kind of structural data checking method | |
| CN112328621A (en) | SQL conversion method and device, computer equipment and computer readable storage medium |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20180622 |
|
| RJ01 | Rejection of invention patent application after publication |