CN112948250A - Structure detection method and system based on data standard - Google Patents
Structure detection method and system based on data standard Download PDFInfo
- Publication number
- CN112948250A CN112948250A CN202110232842.XA CN202110232842A CN112948250A CN 112948250 A CN112948250 A CN 112948250A CN 202110232842 A CN202110232842 A CN 202110232842A CN 112948250 A CN112948250 A CN 112948250A
- Authority
- CN
- China
- Prior art keywords
- detection
- standard
- field
- requirement
- primary key
- 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.)
- Granted
Links
- 238000001514 detection method Methods 0.000 title claims abstract description 176
- 238000000034 method Methods 0.000 claims abstract description 13
- 238000005516 engineering process Methods 0.000 claims description 50
- 238000012545 processing Methods 0.000 claims description 24
- 238000013523 data management Methods 0.000 abstract 1
- 238000010586 diagram Methods 0.000 description 5
- 230000006870 function Effects 0.000 description 5
- 238000004891 communication Methods 0.000 description 2
- 230000010354 integration Effects 0.000 description 2
- 230000009467 reduction Effects 0.000 description 2
- 238000007418 data mining Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000005457 optimization Methods 0.000 description 1
- 210000000056 organ Anatomy 0.000 description 1
- 230000008520 organization Effects 0.000 description 1
- 230000008569 process Effects 0.000 description 1
- 230000006798 recombination Effects 0.000 description 1
- 238000005215 recombination Methods 0.000 description 1
- 238000011160 research Methods 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F11/00—Error detection; Error correction; Monitoring
- G06F11/36—Preventing errors by testing or debugging software
- G06F11/3668—Software testing
- G06F11/3672—Test management
- G06F11/3692—Test management for test results analysis
-
- 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
- G06F16/215—Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Quality & Reliability (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Computer Hardware Design (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a structure detection method and a structure detection system based on data standards, which belong to the technical field of government affair service data management, and solve the technical problems of realizing the exchange and sharing of electronic government affair data and improving the data utilization rate, wherein the adopted technical scheme is as follows: the method comprises the steps of detecting a base table field structure associated with a data element standard according to different structure rule requirements, and generating a detection quality report to realize the exchange and sharing of E-government data; the method comprises the following specific steps: detecting the length of the base table field; detecting the type of the field of the base table; whether the primary key is detected; whether padding is necessary. The system comprises a length detection unit, a type detection unit, a main key detection unit and a necessary item detection unit.
Description
Technical Field
The invention relates to the technical field of government affair service data governance, in particular to a structure detection method and system based on data standards.
Background
The e-Government affairs (e-Government afair) is a revolution of the Government based on the internet technology, applies the modern information and communication technology in the management and service functions of Government organs, realizes the recombination optimization of Government organization structures and engineering flows, overcomes the restrictions of time, space and division of departments, provides high-quality, standard and transparent services for the society in an all-round way, and is a revolution of Government management means.
In the process of electronic government affair application, the unification of data and general business standards should be emphasized, the research and application of government affair informatization overall standards are developed, and cross-region, cross-department and cross-layer data mutual recognition and sharing are promoted; meanwhile, a dynamically updated government affair information resource directory system is established, and the government affair information is guaranteed to be opened, shared and used orderly.
Therefore, how to realize the exchange and sharing of e-government affair data and improve the data utilization rate is a technical problem to be solved urgently at present.
Disclosure of Invention
The technical task of the invention is to provide a structure detection method and a structure detection system based on data standards, so as to solve the problems of how to realize the exchange and sharing of e-government affair data and improve the data utilization rate.
The technical task of the invention is realized in the following way, a structure detection method based on data standard detects the base table field structure associated with the data element standard according to different structure rule requirements, generates a detection quality report and realizes the exchange and sharing of E-government data; the method comprises the following specific steps:
detecting the length of the base table field;
detecting the type of the field of the base table;
whether the primary key is detected;
whether padding is necessary.
Preferably, the detection of the length of the library table field is as follows:
carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
according to the corresponding relation, inquiring the character length requirement of the corresponding data element standard by using a java technology;
inquiring the character length of the corresponding base table field through linkage of mysql and java technology;
comparing the standard character length requirement value with the currently associated library table field length value:
if the standard requirement is not met, the detection is not passed;
if the standard requirement is met, the detection is passed;
and after the detection is finished, generating a base table field length detection report.
Preferably, the detection of the type of the field of the library table is as follows:
carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
according to the corresponding relation, inquiring the field type requirement of the corresponding data element standard by using a java technology; inquiring the field type of the corresponding base table field through linkage of mysql and java technology;
compare the standard field type requirement to the field type of the currently associated library table field:
if the standard requirement is not met, the detection is not passed;
if the standard requirement is met, the detection is passed;
and after the detection is finished, generating a detection report of the field type of the base table.
Preferably, whether the primary key detection is specifically as follows:
carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
according to the corresponding relation, the java technology is utilized to inquire the corresponding primary key requirement of the data element standard;
through linkage of mysql and java technology, whether the corresponding table field is a main key is inquired;
compare the standard primary key requirement to whether the currently associated field is a primary key:
if the standard requirement is not met, the detection is not passed;
if the standard requirement is met, the detection is passed;
and after the detection is finished, generating a primary key detection report.
More preferably, the detection of whether padding is necessary is as follows:
carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
according to the corresponding relation, querying whether the corresponding data element standard is required to be filled by using a java technology; through linkage of mysql and java technology, whether the corresponding table field is a mandatory field is inquired;
compare the standard mandatory fill requirement to whether the currently associated field is a mandatory entry:
if the standard requirement is not met, the detection is not passed;
if the standard requirement is met, the detection is passed;
and after the detection is finished, generating a detection report to be filled.
A structure detection system based on data standards, the system comprising,
the length detection unit is used for detecting the length of the base table field;
the type detection unit is used for detecting the type of the field of the library table;
a primary key detection unit for detecting whether a primary key is detected;
and the mandatory item detection unit is used for detecting whether the mandatory item is required to be filled.
Preferably, the length detecting unit includes,
the field corresponding module I is used for carrying out one-to-one corresponding processing on the data metadata and specific fields of a specific database table;
the character length query module is used for querying the character length requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the character length linkage query module is used for querying the character length of the corresponding base table field through mysql and java technology linkage;
and the character length comparison module is used for comparing the standard character length requirement value with the currently associated base table field length value: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the field length detection report generation module is used for generating a base table field length detection report after the detection is finished.
Preferably, the type detecting unit includes,
the field corresponding module II is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the character type query module is used for querying the field type requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the character type linkage query module is used for querying the field type of the corresponding base table field through mysql and java technology linkage;
and the character type comparison module is used for comparing the standard field type requirement with the field type of the currently associated base table field: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the character type detection report generation module is used for generating a library table field type detection report after the detection is finished.
More preferably, the primary key detecting unit includes,
a third field corresponding module, which is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the primary key requirement query module is used for querying the primary key requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the primary key requirement linkage query module is used for querying whether the corresponding table field is a primary key or not through mysql and java technology linkage;
a primary key comparison module, configured to compare the standard primary key requirement with whether the currently associated field is a primary key: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
the primary key detection report generation module is used for generating a primary key detection report after detection is finished;
the indispensable item detecting unit includes a unit for detecting the indispensable item,
the field corresponding module is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the mandatory requirement query module is used for querying whether the corresponding data element standard is the mandatory requirement or not by utilizing java technology according to the corresponding relation;
the mandatory item linkage query module is used for querying whether the corresponding table field is a mandatory field through mysql and java technology linkage;
a mandatory item comparison module for comparing the standard mandatory requirement with whether the currently associated field is a mandatory item: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the indispensable item detection report generation module is used for generating the indispensable item detection report after the detection is finished.
A computer-readable storage medium having stored thereon computer-executable instructions, which, when executed by a processor, implement the data-criteria-based structure detection method as described above.
The structure detection method and the system based on the data standard have the following advantages that:
the method has the advantages that the data standard structure is detected, the exchange and the sharing of E-government affair data are facilitated, the data utilization rate is improved, the high integration of the data is achieved, the interoperability of an E-government affair system is facilitated to be improved, the effective management of the E-government affair data is facilitated to be realized, and the basis is set for deep data mining and decision support;
the invention detects the database table field structure associated with the data element standard, detects whether the database table data element field accords with the structure standard, generates a detection quality report, promotes the integration and sharing of an information system, and promotes the supporting capability of a unified electronic government network;
the invention detects whether the field length of the field of a certain service system base table related to the data element standard is in the specified range, thereby effectively avoiding the data quality reduction caused by the character length when the system data is recorded;
the method detects whether the field type of a certain business system base table field related to the data element standard accords with the data element standard regulation, thereby effectively avoiding the data quality reduction caused by the data type when the system data is input;
the invention detects whether the field of the base table of a certain business system associated with the data element standard is the primary key, thereby avoiding the error of the table structure caused by the primary key problem;
and (VI) detecting whether the field of a certain business system base table associated with the data element standard is empty, thereby effectively avoiding the problems of incomplete information and the like caused by empty values of data when the system data is recorded.
The invention has the advantages of initiative, timing, high resolution of generated quality report, and the like, and can visually and comprehensively avoid the problem of data structure;
the invention can generate a detection quality report for the detection result, intuitively and comprehensively reflects the structural problem of the standard field, and can be downloaded and checked.
Drawings
The invention is further described below with reference to the accompanying drawings.
FIG. 1 is a schematic diagram of a structure detection method based on data standards;
FIG. 2 is a schematic diagram of field length detection
FIG. 3 is a schematic diagram of field type detection;
FIG. 4 is a schematic diagram of the detection of whether a primary key is detected;
fig. 5 is a schematic diagram of the necessity detection.
Detailed Description
The structure detection method and system based on data standard of the present invention will be described in detail with reference to the drawings and specific embodiments of the specification.
Example 1
As shown in fig. 1, the structure detection method based on data standards of the present invention detects the base table field structure associated with the data element standards according to different structure rule requirements, and generates a detection quality report, thereby realizing the exchange and sharing of e-government data; the method comprises the following specific steps:
s1, detecting the length of the library table field;
s2, detecting the type of the field of the library table;
s3, detecting whether the primary key exists;
and S4, whether the filling is necessary or not.
As shown in fig. 2, the detection of the length of the library table field in step S1 in this embodiment is as follows:
s101, carrying out one-to-one correspondence processing on the data element standard and specific fields of a specific table of a database;
s102, inquiring the character length requirement of the corresponding data element standard by using a java technology according to the corresponding relation;
s103, inquiring the character length of a corresponding base table field through mysql and java technology linkage;
s104, comparing the standard character length requirement value with the currently associated base table field length value:
if the standard requirement is not met, the detection is not passed, and the step S105 is skipped;
if the standard requirement is met, the detection is passed, and the step S105 is skipped;
and S105, after the detection is finished, generating a base table field length detection report.
As shown in fig. 3, the detection of the type of the field of the library table in step S2 in this embodiment is as follows:
s201, carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific table of the database;
s202, inquiring field type requirements of corresponding data element standards by using a java technology according to the corresponding relation;
s203, inquiring the field type of the corresponding base table field through mysql and java technology linkage;
s204, comparing the standard field type requirement with the field type of the currently associated library table field:
if the standard requirement is not met, the detection is not passed, and the step S205 is skipped;
if the standard requirement is met, the detection is passed, and the step S205 is skipped;
and S205, after the detection is finished, generating a detection report of the field type of the base table.
As shown in fig. 4, the detection of whether the primary key is detected in step S3 of the present embodiment is as follows:
s301, carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
s302, inquiring the corresponding primary key requirements of the data element standard by using a java technology according to the corresponding relation;
s303, inquiring whether the corresponding table field is a main key or not through linkage of mysql and java technology;
s304, comparing the standard primary key requirement with whether the currently associated field is a primary key:
if the standard requirement is not met, the detection is not passed, and the step S305 is skipped;
if the standard requirement is met, the detection is passed, and the step S305 is skipped;
and S305, after the detection is finished, generating a primary key detection report.
As shown in fig. 5, the step S4 of the present embodiment specifically includes the following steps:
s401, carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific table of the database;
s402, inquiring whether the corresponding data element standard is a mandatory requirement or not by using a java technology according to the corresponding relation;
s403, inquiring whether the corresponding table field is a mandatory field or not through linkage of mysql and java technology;
s404, comparing the standard required filling requirement with whether the currently associated field is a required filling item:
if the standard requirement is not met, the detection is not passed, and the step S405 is skipped;
if the standard requirement is met, the detection is passed, and the step S405 is skipped;
and S405, generating a necessary filling detection report after the detection is finished.
Example 2:
the structure detection system based on data standard of the invention comprises,
the length detection unit is used for detecting the length of the base table field;
the type detection unit is used for detecting the type of the field of the library table;
a primary key detection unit for detecting whether a primary key is detected;
and the mandatory item detection unit is used for detecting whether the mandatory item is required to be filled.
The length detection unit in the present embodiment includes,
the field corresponding module I is used for carrying out one-to-one corresponding processing on the data metadata and specific fields of a specific database table;
the character length query module is used for querying the character length requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the character length linkage query module is used for querying the character length of the corresponding base table field through mysql and java technology linkage;
and the character length comparison module is used for comparing the standard character length requirement value with the currently associated base table field length value: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the field length detection report generation module is used for generating a base table field length detection report after the detection is finished.
The type detection unit in the present embodiment includes,
the field corresponding module II is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the character type query module is used for querying the field type requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the character type linkage query module is used for querying the field type of the corresponding base table field through mysql and java technology linkage;
and the character type comparison module is used for comparing the standard field type requirement with the field type of the currently associated base table field: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the character type detection report generation module is used for generating a library table field type detection report after the detection is finished.
The primary key detection unit in the present embodiment includes,
a third field corresponding module, which is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the primary key requirement query module is used for querying the primary key requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the primary key requirement linkage query module is used for querying whether the corresponding table field is a primary key or not through mysql and java technology linkage;
a primary key comparison module, configured to compare the standard primary key requirement with whether the currently associated field is a primary key: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
the primary key detection report generation module is used for generating a primary key detection report after detection is finished;
the indispensable item detection unit in the present embodiment includes,
the field corresponding module is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the mandatory requirement query module is used for querying whether the corresponding data element standard is the mandatory requirement or not by utilizing java technology according to the corresponding relation;
the mandatory item linkage query module is used for querying whether the corresponding table field is a mandatory field through mysql and java technology linkage;
a mandatory item comparison module for comparing the standard mandatory requirement with whether the currently associated field is a mandatory item: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the indispensable item detection report generation module is used for generating the indispensable item detection report after the detection is finished.
Example 3
The embodiment of the invention also provides a computer-readable storage medium, wherein a plurality of instructions are stored, and the instructions are loaded by the processor, so that the processor executes the structure detection method based on the data standard in any embodiment of the invention. Specifically, a system or an apparatus equipped with a storage medium on which software program codes that realize the functions of any of the above-described embodiments are stored may be provided, and a computer (or a CPU or MPU) of the system or the apparatus is caused to read out and execute the program codes stored in the storage medium.
In this case, the program code itself read from the storage medium can realize the functions of any of the above-described embodiments, and thus the program code and the storage medium storing the program code constitute a part of the present invention.
Examples of the storage medium for supplying the program code include a floppy disk, a hard disk, a magneto-optical disk, an optical disk (e.g., CD-ROM, CD-R, CD-RW, DVD-ROM, DVD-R structure detecting method and system based on data standard M, DVD-RW, DVD + RW), a magnetic tape, a nonvolatile memory card, and a ROM. Alternatively, the program code may be downloaded from a server computer via a communications network.
Further, it should be clear that the functions of any one of the above-described embodiments may be implemented not only by executing the program code read out by the computer, but also by causing an operating system or the like operating on the computer to perform a part or all of the actual operations based on instructions of the program code.
Further, it is to be understood that the program code read out from the storage medium is written to a memory provided in an expansion board inserted into the computer or to a memory provided in an expansion unit connected to the computer, and then causes a CPU or the like mounted on the expansion board or the expansion unit to perform part or all of the actual operations based on instructions of the program code, thereby realizing the functions of any of the above-described embodiments.
Finally, it should be noted that: the above embodiments are only used to illustrate the technical solution of the present invention, and not to limit the same; while the invention has been described in detail and with reference to the foregoing embodiments, it will be understood by those skilled in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some or all of the technical features may be equivalently replaced; and the modifications or the substitutions do not make the essence of the corresponding technical solutions depart from the scope of the technical solutions of the embodiments of the present invention.
Claims (10)
1. A structure detection method based on data standard is characterized in that the method detects the base table field structure associated with the data element standard according to different structure rule requirements and generates a detection quality report to realize the exchange and sharing of E-government data; the method comprises the following specific steps:
detecting the length of the base table field;
detecting the type of the field of the base table;
whether the primary key is detected;
whether padding is necessary.
2. The method for detecting the structure based on the data standard of claim 1, wherein the detection of the length of the field of the library table is as follows:
carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
according to the corresponding relation, inquiring the character length requirement of the corresponding data element standard by using a java technology;
inquiring the character length of the corresponding base table field through linkage of mysql and java technology;
comparing the standard character length requirement value with the currently associated library table field length value:
if the standard requirement is not met, the detection is not passed;
if the standard requirement is met, the detection is passed;
and after the detection is finished, generating a base table field length detection report.
3. The structure detection method based on the data standard as claimed in claim 1, wherein the detection of the type of the field of the library table is as follows:
carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
according to the corresponding relation, inquiring the field type requirement of the corresponding data element standard by using a java technology;
inquiring the field type of the corresponding base table field through linkage of mysql and java technology;
compare the standard field type requirement to the field type of the currently associated library table field:
if the standard requirement is not met, the detection is not passed;
if the standard requirement is met, the detection is passed;
and after the detection is finished, generating a detection report of the field type of the base table.
4. The method for detecting a structure based on data standard according to claim 1, wherein whether the primary key detection is specifically as follows:
carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
according to the corresponding relation, the java technology is utilized to inquire the corresponding primary key requirement of the data element standard;
through linkage of mysql and java technology, whether the corresponding table field is a main key is inquired;
compare the standard primary key requirement to whether the currently associated field is a primary key:
if the standard requirement is not met, the detection is not passed;
if the standard requirement is met, the detection is passed;
and after the detection is finished, generating a primary key detection report.
5. The method for detecting a structure based on data standards according to any one of claims 1 to 4, wherein the detection of whether padding is necessary is as follows:
carrying out one-to-one correspondence processing on the data element standard and the specific fields of the specific database table;
according to the corresponding relation, querying whether the corresponding data element standard is required to be filled by using a java technology;
through linkage of mysql and java technology, whether the corresponding table field is a mandatory field is inquired;
compare the standard mandatory fill requirement to whether the currently associated field is a mandatory entry:
if the standard requirement is not met, the detection is not passed;
if the standard requirement is met, the detection is passed;
and after the detection is finished, generating a detection report to be filled.
6. A structure detection system based on data standards, characterized in that the system comprises,
the length detection unit is used for detecting the length of the base table field;
the type detection unit is used for detecting the type of the field of the library table;
a primary key detection unit for detecting whether a primary key is detected;
and the mandatory item detection unit is used for detecting whether the mandatory item is required to be filled.
7. The data criteria based structure detection system of claim 6, wherein the length detection unit includes,
the field corresponding module I is used for carrying out one-to-one corresponding processing on the data metadata and specific fields of a specific database table;
the character length query module is used for querying the character length requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the character length linkage query module is used for querying the character length of the corresponding base table field through mysql and java technology linkage;
and the character length comparison module is used for comparing the standard character length requirement value with the currently associated base table field length value: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the field length detection report generation module is used for generating a base table field length detection report after the detection is finished.
8. The data criteria-based structure detection system of claim 6, wherein the type detection unit includes,
the field corresponding module II is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the character type query module is used for querying the field type requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the character type linkage query module is used for querying the field type of the corresponding base table field through mysql and java technology linkage;
and the character type comparison module is used for comparing the standard field type requirement with the field type of the currently associated base table field: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the character type detection report generation module is used for generating a library table field type detection report after the detection is finished.
9. The data standard-based structure detection system of any one of claims 6 to 8, wherein the primary key detection unit includes,
a third field corresponding module, which is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the primary key requirement query module is used for querying the primary key requirement of the corresponding data element standard by using java technology according to the corresponding relation;
the primary key requirement linkage query module is used for querying whether the corresponding table field is a primary key or not through mysql and java technology linkage;
a primary key comparison module, configured to compare the standard primary key requirement with whether the currently associated field is a primary key: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
the primary key detection report generation module is used for generating a primary key detection report after detection is finished;
the indispensable item detecting unit includes a unit for detecting the indispensable item,
the field corresponding module is used for carrying out one-to-one corresponding processing on the data element standard and the specific fields of the specific database table;
the mandatory requirement query module is used for querying whether the corresponding data element standard is the mandatory requirement or not by utilizing java technology according to the corresponding relation;
the mandatory item linkage query module is used for querying whether the corresponding table field is a mandatory field through mysql and java technology linkage;
a mandatory item comparison module for comparing the standard mandatory requirement with whether the currently associated field is a mandatory item: if the standard requirement is not met, the detection is not passed; if the standard requirement is met, the detection is passed;
and the indispensable item detection report generation module is used for generating the indispensable item detection report after the detection is finished.
10. A computer-readable storage medium having computer-executable instructions stored thereon, which when executed by a processor implement the data-criteria-based structure detection method as claimed in claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110232842.XA CN112948250B (en) | 2021-03-03 | 2021-03-03 | Structure detection method and system based on data standard |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202110232842.XA CN112948250B (en) | 2021-03-03 | 2021-03-03 | Structure detection method and system based on data standard |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN112948250A true CN112948250A (en) | 2021-06-11 |
| CN112948250B CN112948250B (en) | 2024-02-02 |
Family
ID=76247329
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202110232842.XA Active CN112948250B (en) | 2021-03-03 | 2021-03-03 | Structure detection method and system based on data standard |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112948250B (en) |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110320433A1 (en) * | 2010-06-25 | 2011-12-29 | Microsoft Corporation | Automated Joining of Disparate Data for Database Queries |
| CN102937965A (en) * | 2012-09-29 | 2013-02-20 | 山东浪潮齐鲁软件产业股份有限公司 | Meta-system design method based on data model |
| WO2016086640A1 (en) * | 2014-12-04 | 2016-06-09 | 中兴通讯股份有限公司 | Tour inspection report generation method and apparatus |
| US20170249361A1 (en) * | 2016-02-29 | 2017-08-31 | International Business Machines Corporation | Detecting logical relationships based on structured query statements |
| US20190220531A1 (en) * | 2018-01-16 | 2019-07-18 | Sap Se | Consistency check for foreign key definition |
| CN111161815A (en) * | 2019-12-27 | 2020-05-15 | 深圳中兴网信科技有限公司 | Medical data detection method, device, terminal and computer-readable storage medium |
| CN111291049A (en) * | 2020-01-19 | 2020-06-16 | 软通动力信息技术有限公司 | Method, device, equipment and storage medium for creating table |
| CN111858567A (en) * | 2020-06-18 | 2020-10-30 | 南京市江宁区信息化管理服务中心 | Method and system for cleaning government affair data through standard data elements |
-
2021
- 2021-03-03 CN CN202110232842.XA patent/CN112948250B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110320433A1 (en) * | 2010-06-25 | 2011-12-29 | Microsoft Corporation | Automated Joining of Disparate Data for Database Queries |
| CN102937965A (en) * | 2012-09-29 | 2013-02-20 | 山东浪潮齐鲁软件产业股份有限公司 | Meta-system design method based on data model |
| WO2016086640A1 (en) * | 2014-12-04 | 2016-06-09 | 中兴通讯股份有限公司 | Tour inspection report generation method and apparatus |
| US20170249361A1 (en) * | 2016-02-29 | 2017-08-31 | International Business Machines Corporation | Detecting logical relationships based on structured query statements |
| US20190220531A1 (en) * | 2018-01-16 | 2019-07-18 | Sap Se | Consistency check for foreign key definition |
| CN111161815A (en) * | 2019-12-27 | 2020-05-15 | 深圳中兴网信科技有限公司 | Medical data detection method, device, terminal and computer-readable storage medium |
| CN111291049A (en) * | 2020-01-19 | 2020-06-16 | 软通动力信息技术有限公司 | Method, device, equipment and storage medium for creating table |
| CN111858567A (en) * | 2020-06-18 | 2020-10-30 | 南京市江宁区信息化管理服务中心 | Method and system for cleaning government affair data through standard data elements |
Non-Patent Citations (2)
| Title |
|---|
| 肖桂荣, 王钦敏, 涂平, 陈崇成: "福建省政务信息资源标准规范改造与集成", 地球信息科学, no. 04 * |
| 郭理桥;: "数据梳理在电子政务中的应用分析", 中国建设信息, no. 23 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN112948250B (en) | 2024-02-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109597853B (en) | Business scene element serial number generation method, device, medium and computer equipment | |
| CN110647316B (en) | Method and device for generating universal business object, computer equipment and storage medium | |
| CN111143446A (en) | Data structure conversion processing method and device of data object and electronic equipment | |
| CN113032105A (en) | Kubernetes cluster access control method, system and related equipment | |
| CN111736913B (en) | Class loading method and device | |
| CN111562929A (en) | Method, device and equipment for generating patch file and storage medium | |
| CN112860412B (en) | Service data processing method and device, electronic equipment and storage medium | |
| CN101000621A (en) | Interdynamic access method and tool of IMS data base | |
| CN114816170A (en) | Rule scheme generation method, device, medium and electronic equipment | |
| CN106484375B (en) | Instruction block loading method, soft switch equipment and system | |
| CN112948250A (en) | Structure detection method and system based on data standard | |
| CN111324645B (en) | Block chain data processing method and device | |
| CN111858586A (en) | Data processing method and device | |
| CN103197950A (en) | Plug-in virtual machine implementing method | |
| CN110597827A (en) | Storage method and system of interface control file data | |
| CN105468304A (en) | Native memory card and management method thereof | |
| CN102799423A (en) | Method and device for implementing dynamic method in JSF (java service face) | |
| US11675683B2 (en) | Method, electronic device, and computer program product for monitoring storage system | |
| CN103902554A (en) | Data access method and device | |
| CN114625372A (en) | Automatic component compiling method and device, computer equipment and storage medium | |
| CN114706526A (en) | Automatic capacity expansion method, system and equipment for cloud native storage data volume | |
| EP3507689B1 (en) | Java card application package used as a library package | |
| CN114077587A (en) | Rule engine based business processing method, rule engine, medium and device | |
| CN104424197A (en) | IP (Internet Protocol) address base retrieval method and system | |
| CN110908996A (en) | Data processing method and device |
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 |