CN104598598A - Method for evaluating relational data standard - Google Patents
Method for evaluating relational data standard Download PDFInfo
- Publication number
- CN104598598A CN104598598A CN201510035345.5A CN201510035345A CN104598598A CN 104598598 A CN104598598 A CN 104598598A CN 201510035345 A CN201510035345 A CN 201510035345A CN 104598598 A CN104598598 A CN 104598598A
- Authority
- CN
- China
- Prior art keywords
- data
- field
- standard
- assessed
- item
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The invention relates to the field of information evaluation, in particular to a method for evaluating relational data standard. The method comprises the following steps: 1, transmitting a data standard evaluation request to an evaluation system terminal by a user terminal; 2, enabling the evaluation system to respond to the request; 3, configuring a relational database data source; 4, evaluating the standard data; 5, storing an evaluation value and recording immediate evaluation time; 6, outputting the evaluation value. According to the method, standard evaluation of the relational data can be achieved; data can be relatively and accurately analyzed, so as to facilitate further utilization of the data.
Description
Technical field
The present invention relates to information evaluation field, particularly relate to a kind of appraisal procedure of relational data standard.
Background technology
The informatization of the current industry-by-industry of China is like a raging fire has carried out a lot of year, these data are multifarious, storage organization is also ever-changing, various industry to have put into effect respective industry standard data definition all in succession, meanwhile, and different government bodies and large enterprise, also respective internal data standard definition is had, in order in standardize information system Construction process, data definition disunity, nonstandard problem.But in the implementation of standard, often occur that standard does not obtain the problem well performed, but suffer from and do not have good technological means to detect.Such as sex, there is special standard in country, must span within certain numeral, but the situation of reality be but most data completely and national standard code be not inconsistent, cause data nonstandard, disunity, cannot well be used.
Summary of the invention
In order to overcome the defect existed in above-mentioned background technology, the technical problem to be solved in the present invention is to provide a kind of appraisal procedure of relational data standard.
For solving the problems of the technologies described above, the appraisal procedure of relational data standard of the present invention, comprises the steps:
Step 1, user terminal sends data standard assessment request to evaluating system terminal;
Step 2, the request of evaluating system terminal response;
Step 3, configuration relation type database data source, comprises the steps:
3.1, input the information of evaluated database, described information comprises the IP address of database, database user name, password or port, and by described information storage to evaluating system;
3.2, set up linking of evaluating system and evaluated database;
3.3, obtain the structure of table corresponding to described evaluated database and field, any one field that described evaluating system can select any one to show is configured;
Step 4, data standard is assessed, and comprises the steps:
4.1, initialization standard criterion;
4.2, select the data to be assessed in evaluated database, described data to be assessed comprise several tables to be assessed, comprise one or more field to be assessed under described list structure;
4.3, standard criterion is input to evaluating system, and described evaluating regulation comprises data name item, data type item and data length item;
4.4, choose field to be assessed and mate with the data name item in standard criterion, filter out the field matched mutually;
4.5, the data type item in field step 4.4 filtered out and standard criterion carries out school inspection, filters out the field that matches and calculates the weight of respective field in total field;
4.6, the data length item in field step 4.5 filtered out and standard criterion carries out school inspection, filters out the field that matches and calculate respective field to filter out weight in field in total field or step 4.4;
Step 5, stores assessed value and records the immediate assessment time;
Step 6, exports the weighted value in described step 4.5 or 4.6.
Further, between described step 4 and step 5, be also provided with standard criterion go through all over item, described standard criterion goes through the standard criterion whether going through time evaluating system typing all over item for detecting field to be assessed.
Further, described standard criterion is mated by circulation matching way one by one with field to be assessed.
The standard criterion of data inside database according to typing in advance can be assessed by the appraisal procedure of data standard of the present invention, can analyze data more accurately, so that data further utilize.Concrete, the standard criterion used is specification general in country or this area, the content of its specification comprises data name item, data type item and data length item, school of field data and above-mentioned standard criterion being compared is examined, comparison is a kind of evaluation measures of simple and effective, form matching result, result comprises the data and the weighted value of such data in corresponding data thereof that meet specification, according to the standard of weighted value assessment data, also can be further analyzed screening the data meeting specification.
Accompanying drawing explanation
In order to be illustrated more clearly in inventive embodiments or technical scheme of the prior art, briefly introduce to the accompanying drawing used required in the embodiment of the present invention or description of the prior art below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those skilled in the art, under the prerequisite not paying creative work, also can obtain other accompanying drawing according to these accompanying drawings;
Fig. 1 is the process flow diagram of the appraisal procedure embodiment of a kind of relational data standard of the present invention;
Fig. 2 is the process flow diagram in configuration relation type database data source in the appraisal procedure embodiment of a kind of relational data standard of the present invention;
Fig. 3 is the process flow diagram of a kind of appraisal procedure in the appraisal procedure embodiment of a kind of relational data of the present invention standard.
Embodiment
Figure 1 shows that the process flow diagram of the appraisal procedure embodiment of a kind of relational data standard of the present invention, comprise the steps: step 1, user terminal sends data standard assessment request to evaluating system terminal; Step 2, the request of evaluating system terminal response; Step 3, configuration relation type database data source; Step 4, evaluation criteria data; Step 5, stores assessed value and records the immediate assessment time; Step 6, exports assessed value.Said method can the assessment of standard of implementation relation type data, the result of assessment comprises the data and the weighted value of such data in corresponding data thereof that meet specification, according to the standard of weighted value assessment data, also can be further analyzed screening the data meeting specification.
Figure 2 shows that the process flow diagram in configuration relation type database data source in the appraisal procedure embodiment of a kind of relational data standard of the present invention, comprise the steps: step 3.1, input the information of evaluated database, information comprises the IP address of database, database user name, password or port, and by information storage to evaluating system; Step 3.2, foundation links with evaluated database; Step 3.3, obtain the structure of table corresponding to evaluated database and field, any one field that evaluating system can select any one to show is configured.
A kind of process flow diagram of appraisal procedure in the appraisal procedure embodiment of a kind of relational data of Fig. 3 the present invention standard, comprising: user terminal sends data standard assessment request to evaluating system terminal; The request of evaluating system terminal response; Configuration relation type database data source; Evaluation criteria data; Export assessed value.Wherein evaluation criteria data comprise initialization standard criterion, typing standard criterion to evaluating system, for the JT/T697 standard of Ministry of Communications, namely specification is done to the definition of data item of transportation industry, particularly, data as relevant to harbour part have been done as given a definition, specifically see form 1:
Form 1
In form, data name item, data type item and data length Xiang Jun have the standard criterion of its correspondence, with this standard criterion for normative reference, treat assessment data and compare.Fig. 2 is the physical presence situation of data to be assessed.
Form 2
Evaluating system is that " name of port " evaluation process is as follows to data item, the first step, first mate to the data name item of assessment data, namely the data name item of comparison data to be assessed is removed by standard criterion, the data not meeting name item specification are rejected, namely its name item and " name of port " are runed counter to, and the data name item in form 2 meets standard, continue the assessment implementing next stage.Second step, the standard criterion of the data data type item first step screened is compared coupling, the data item not meeting " variable length character type or VARCHAR2 " is rejected, and the data name item in form 2 meets standard, continues the assessment implementing next stage.3rd step, the standard criterion of the data data length item screened by second step is compared coupling, and the data item not meeting " 100 " is rejected, and the data length in form 2 meets standard criterion.
In like manner, above-mentioned standard assessment also can be done to other project in form two, for " harbour maximum water depth ", it meets the specification of name item, but it does not meet the specification of data type item, because it does not meet the specification of data type item, just do not continue necessity of assessment data length item yet.Because data standard evaluation object often has larger radix, before assessment, add up its quantity be designated as
a, because standard criterion and field to be assessed are mated one by one by circulation matching way, after the first step terminates, filter out the data meeting data name item, quantity is designated as b; Continue the assessment comparison above-mentioned data being carried out to data type item, after second step terminates, filter out the data meeting data type item, quantity is designated as c; Continue the assessment comparison above-mentioned data being carried out to data length item, after the 3rd EOS, filter out the data meeting data length item, quantity is designated as d.A in Fig. 3 can be according to the actual requirements
c/
aor c/b, B can be d/a, d/b according to the actual requirements.In addition, in estimation flow, also have standard criterion to go through all over item, can data to be assessed be examined whether go through all over analysis rule in school further, avoid because other factors cause the omission of data assessment, the integrality of guarantee Data Detection.Before result exports, also can store assessed value according to demand and record the immediate assessment time, the inquiry of data assessment can be carried out at any time.
More than show and describe ultimate principle of the present invention, principal character and advantage of the present invention.The technician of the industry should understand; the present invention is not restricted to the described embodiments; what describe in above-described embodiment and instructions just illustrates principle of the present invention; the present invention also has various changes and modifications without departing from the spirit and scope of the present invention, and these changes and improvements all fall in the claimed scope of the invention.Application claims protection domain is defined by appending claims and equivalent thereof.
Claims (3)
1. an appraisal procedure for relational data standard, comprises the steps:
Step 1, user terminal sends data standard assessment request to evaluating system terminal;
Step 2, the request of evaluating system terminal response;
Step 3, configuration relation type database data source, comprises the steps:
3.1, input the information of evaluated database, described information comprises the IP address of database, database user name, password or port, and by described information storage to evaluating system;
3.2, set up linking of evaluating system and evaluated database;
3.3, obtain the structure of table corresponding to described evaluated database and field, any one field that described evaluating system can select any one to show is configured;
Step 4, data standard is assessed, and comprises the steps:
4.1, initialization standard criterion;
4.2, select the data to be assessed in evaluated database, described data to be assessed comprise several tables to be assessed, comprise one or more field to be assessed under described list structure;
4.3, standard criterion is input to evaluating system, and described evaluating regulation comprises data name item, data type item and data length item;
4.4, choose field to be assessed and mate with the data name item in standard criterion, filter out the field matched mutually;
4.5, the data type item in field step 4.4 filtered out and standard criterion carries out school inspection, filters out the field that matches and calculates the weight of respective field in total field;
4.6, the data length item in field step 4.5 filtered out and standard criterion carries out school inspection, filters out the field that matches and calculate respective field to filter out weight in field in total field or step 4.4;
Step 5, stores assessed value and records the immediate assessment time;
Step 6, exports the weighted value in described step 4.5 or 4.6.
2. the appraisal procedure of relational data standard according to claim 1, it is characterized in that: between described step 4 and step 5, be also provided with standard criterion go through all over item, described standard criterion goes through the standard criterion whether going through time evaluating system typing all over item for detecting field to be assessed.
3. the appraisal procedure of relational data standard according to claim 1 and 2, is characterized in that: described standard criterion is mated by circulation matching way one by one with field to be assessed.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510035345.5A CN104598598A (en) | 2015-01-23 | 2015-01-23 | Method for evaluating relational data standard |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510035345.5A CN104598598A (en) | 2015-01-23 | 2015-01-23 | Method for evaluating relational data standard |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104598598A true CN104598598A (en) | 2015-05-06 |
Family
ID=53124383
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510035345.5A Pending CN104598598A (en) | 2015-01-23 | 2015-01-23 | Method for evaluating relational data standard |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104598598A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107544979A (en) * | 2016-06-24 | 2018-01-05 | 上海壹账通金融科技有限公司 | The credibility Analysis method and system of user data |
| CN108256074A (en) * | 2018-01-17 | 2018-07-06 | 链家网（北京）科技有限公司 | Method, apparatus, electronic equipment and the storage medium of checking treatment |
| CN110309124A (en) * | 2019-05-23 | 2019-10-08 | 深圳宏崎达技术有限公司 | Data managing method and system |
| CN110389941A (en) * | 2019-06-19 | 2019-10-29 | 平安国际智慧城市科技股份有限公司 | Database method of calibration, device, equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101021890A (en) * | 2007-03-20 | 2007-08-22 | 华为技术有限公司 | Method, system and server for checking page data |
| US20120066260A1 (en) * | 2006-02-01 | 2012-03-15 | Oracle International Corporation | System And Method For Building Decision Trees In A Database |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
-
2015
- 2015-01-23 CN CN201510035345.5A patent/CN104598598A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120066260A1 (en) * | 2006-02-01 | 2012-03-15 | Oracle International Corporation | System And Method For Building Decision Trees In A Database |
| CN101021890A (en) * | 2007-03-20 | 2007-08-22 | 华为技术有限公司 | Method, system and server for checking page data |
| CN104317974A (en) * | 2014-11-21 | 2015-01-28 | 武汉理工大学 | Reconfigurable multi-source data importing method in ERP system |
Non-Patent Citations (3)
| Title |
|---|
| 刘晓华: ""企业数据字典标准化管理平台解决方案探讨"", 《武汉工程大学学报》 * |
| 常思思 等: ""矿产资源潜力评价中定性数据标准化检查"", 《物探化探计算技术》 * |
| 武伟: ""交通运输数据标准符合性检测研究及系统开发"", 《中国优秀硕士学位论文全文数据库 工程科技II辑》 * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107544979A (en) * | 2016-06-24 | 2018-01-05 | 上海壹账通金融科技有限公司 | The credibility Analysis method and system of user data |
| CN108256074A (en) * | 2018-01-17 | 2018-07-06 | 链家网（北京）科技有限公司 | Method, apparatus, electronic equipment and the storage medium of checking treatment |
| CN108256074B (en) * | 2018-01-17 | 2020-06-23 | 贝壳找房(北京)科技有限公司 | Verification processing method and device, electronic equipment and storage medium |
| CN110309124A (en) * | 2019-05-23 | 2019-10-08 | 深圳宏崎达技术有限公司 | Data managing method and system |
| CN110309124B (en) * | 2019-05-23 | 2021-12-03 | 深圳宏崎达技术有限公司 | Data management method and system |
| CN110389941A (en) * | 2019-06-19 | 2019-10-29 | 平安国际智慧城市科技股份有限公司 | Database method of calibration, device, equipment and storage medium |
| CN110389941B (en) * | 2019-06-19 | 2021-01-05 | 平安国际智慧城市科技股份有限公司 | Database checking method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11757945B2 (en) | Collaborative database and reputation management in adversarial information environments | |
| Ward et al. | Truncation error estimates in process life cycle assessment using input‐output analysis | |
| US9531751B2 (en) | System and method for identifying phishing website | |
| US8615516B2 (en) | Grouping similar values for a specific attribute type of an entity to determine relevance and best values | |
| WO2017101301A1 (en) | Data information processing method and device | |
| CN104598598A (en) | Method for evaluating relational data standard | |
| US20170053031A1 (en) | Information forecast and acquisition method based on webpage link parameter analysis | |
| CN102724187A (en) | Method and device for safety detection of universal resource locators | |
| US11968239B2 (en) | System and method for detection and mitigation of data source compromises in adversarial information environments | |
| CN104298923B (en) | Leak type identification method and device | |
| CN103077250B (en) | A kind of capturing webpage contents method and device | |
| CN105812417B (en) | Remote server, router and bad webpage information filtering method | |
| CN104484448A (en) | Assessment method for relational data quality | |
| MX2022005322A (en) | Page simulation system. | |
| CN104317909A (en) | Method and device for verifying data of points of interest | |
| CN110223035A (en) | Fire control acceptance intelligent quantization method and fire control acceptance intelligent quantization system | |
| CN111291331A (en) | Mixed source file license conflict detection method | |
| CN104268289A (en) | Link URL (Uniform Resource Locator) failure detection method and device | |
| CN103605744A (en) | Method and device for analyzing website searching engine traffic data | |
| CN111192015A (en) | Integrated data management system based on core object | |
| Reynolds Jr | The Bernoulli CUSUM chart for detecting decreases in a proportion | |
| CN114154166A (en) | Abnormal data identification method, device, equipment and storage medium | |
| CN113360895A (en) | Station group detection method and device and electronic equipment | |
| Gosper et al. | Continental‐scale syntheses of Australian pyromes–misclassification of south‐western eucalypt woodlands misinforms management | |
| CN106844495A (en) | A kind of acquisition methods and device of website operation daily record |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150506 |
|
| RJ01 | Rejection of invention patent application after publication |