CN104809111A - Method, device and system for verifying validation of automatic system database file - Google Patents
Method, device and system for verifying validation of automatic system database file Download PDFInfo
- Publication number
- CN104809111A CN104809111A CN201410031059.7A CN201410031059A CN104809111A CN 104809111 A CN104809111 A CN 104809111A CN 201410031059 A CN201410031059 A CN 201410031059A CN 104809111 A CN104809111 A CN 104809111A
- Authority
- CN
- China
- Prior art keywords
- file
- database
- automated system
- database file
- validation verification
- 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
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method, a device and a system for verifying validation of an automatic system database file. The method for verifying the validation of the automatic system database file includes following steps: building a set file of database objects, corresponding to the database file, and setting structural constraint of each node in the database file; building a judgment file used to guide an input file into the database file and judge validation of the input file by using the set file of the database objects; before starting an automatic system, running a verification file containing the judgment file, and verifying the validation of the automatic system database file. The method, the device and the system for verifying the validation of the automatic system database file evade the risk that a database goes wrong as early as possible, improve the validation of the database file of the FA system, avoid the phenomenon that the FA system interrupts production, caused by error of the database file in running of the automatic system, and improve production efficiency.
Description
Technical field
The present invention relates to semiconductor production field, particularly relate to a kind of method, Apparatus and system of automated system database file validation verification.
Background technology
In current semiconductor production field, factory automation technology adopt by extensive manufacturer.By the realization of some software middlewares, equipment organically can be combined with high-rise parametric controller, thus provide a close friend and efficient operating environment for staff.At present, board adopts FA(FactoryAutomation System, factory system automated software plateform system) as factory's end software and the mutual center section of equipment control software.FA system, based on SEMI standard development, is responsible for resolving factory and holds the message following SEMI standard of software transmission and be issued to equipment end, and the information and sending being SEMI standard by the equipment end message conversion received is held to factory.
At present, the database of FA system adopts XML file form, with the Structure Creating of three grades of nodes.Due to its text attribute, XML document is easily edited by wrong artificially, as deleted letter, repeated to create node etc. by mistake.Database document correctness, can be related to FA system normally run.
Summary of the invention
Based on this, being necessary to propose one, from meeting FA system business rule aspect, improving method, Apparatus and system that FA database file validity ensures the automated system database file validation verification that system is normally run.
For realizing the method for a kind of automated system database file validation verification that goal of the invention provides, comprise the following steps:
Build setting a file of the database object corresponding with described database file, set the structural constraint of each node in described database file;
Build for importing input file, and utilize the judgement file that the validity of described input file is judged of setting a file of described database object;
Before described automated system starts, running package, containing the authenticating documents of described judgement file, is verified the validity of described database file.
As a kind of embodiment, described judgement file carries out recording the error message judged simultaneously one by one.
As a kind of embodiment, described before described automated system starts, running package, containing the authenticating documents of described judgement file, is verified the validity of described database file, further comprising the steps of:
To the mistake of carrying out in the described database file of validation verification, prompting Error Location.
As a kind of embodiment, further comprising the steps of:
When needs perform query manipulation to database, first described automated system is called described judgement file and is carried out validation verification to the data of reading in, and when data are effective, then proceeds data manipulation, otherwise prompting error message.
As a kind of embodiment, described judgement file adopts ValidateXML () method to generate.
Based on the device of a kind of automated system database file validation verification of same inventive concept, comprise the first memory module, the second memory module, and the first authentication module, wherein:
Described first memory module, for storing structural constraint for setting each node in described database file, setting a file of the database object corresponding with described database file;
Described second memory module, for storing for importing input file, and utilizes the judgement file judged the validity of described input file of setting a file of described database object;
Described first authentication module, for before described automated system starts, running package, containing the authenticating documents of described judgement file, is verified the validity of described database file.
As a kind of embodiment, described judgement file carries out recording the error message judged simultaneously one by one.
As a kind of embodiment, described first authentication module also comprises prompting submodule, described prompting submodule, for the mistake of carrying out in the described database file of validation verification, points out Error Location.
As a kind of embodiment, also comprise the second authentication module, for when needs perform query manipulation to database, call described judgement file and validation verification is carried out to the data of reading in, when data are effective, then proceed data manipulation, otherwise prompting error message.
As a kind of embodiment, described judgement file adopts ValidateXML () method to generate.
Based on a kind of automated system of same inventive concept, comprise automated system database, and the device of described automated system database file validation verification.
Beneficial effect of the present invention comprises:
Method, the Apparatus and system of a kind of automated system database file validation verification provided by the invention, before FA starts, running package is containing the authenticating documents of described judgement file in advance, judges that file carries out validation verification to the database file of FA system.The risk that database is made mistakes can be evaded as early as possible, improve the documentary validity of FA system data.The phenomenon avoiding factor data bank document lending in system cloud gray model to cause FA system break to produce, enhances productivity.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of a specific embodiment of the method for a kind of automated system database file of the present invention validation verification;
Fig. 2 is the structural representation of a specific embodiment of the device of a kind of automated system database file of the present invention validation verification.
Embodiment
In order to make object of the present invention, technical scheme and advantage clearly understand, below in conjunction with accompanying drawing, the method for automated system database file validation verification of the embodiment of the present invention, the embodiment of Apparatus and system are described.Should be appreciated that specific embodiment described herein only in order to explain the present invention, be not intended to limit the present invention.
The method of a kind of automated system database file validation verification of the embodiment of the present invention, as shown in Figure 1, comprises the following steps:
S100, builds setting a file of the database object corresponding with described database file, sets the structural constraint of each node in described database file.
The XML data library file of a correct FA system, following two principles should be followed:
The database document grammer of 1, legitimacy: XML is correct, well-formed.And according to XML syntax gauge, three basic constructional requirements below XML document demand fulfillment:
A) root node comprising every other node is had;
B) each beginning label have relative to end mark;
C) all nodes are all correctly nested.
2, validity: XML document must follow structure, the logical and rule of related service defined.For FA system, database file must meet following four standards:
A) two-level node non-NULL.For Host.xml document, do not allow to there is such " Host " node, its inner structure (InnerXml, lower same) is empty, or the value of its all three child nodes (" HostID ", " Name ", " ModeID ") (InnerText, lower same) is sky;
B) fixing two-level node structure.For Host.xml document, its all two-level node name all should be " Host ", and the child node of each Host node is " HostID ", " Name ", " ModeID " these three regularly;
C) the unique and non-NULL of the value of crucial three grades of nodes.So-called key node, refer to that current record is in order to distinguish the indications of other records, its value has uniqueness.For Host.xml document, for each " Host " node, its child node " HostID " is its key node, and its value is unique, and does not allow for sky;
D) type of three grades of nodal values meets business rule.For Host.xml document, for each " Host " node, the Value Types of its child node " HostID " should be string type (must meet Guid format specification), the Value Types of child node " Name " should be string type, and the Value Types of child node " ModeID " should be int type.
Such as, in the FA system document of host information (Host.xml):
According to four standards of above-mentioned FA system library file validity, in advance each database file is write to the set of the XML Schema(database object of a .xsd form) file (.xsd form), define the structural constraint that each node needs to follow.
S200, builds for importing input file, and utilizes the judgement file judged the validity of described input file of setting a file of described database object.
Build one for importing xml file and Schema file, and utilize set a file (the Schema file) of database object to verify that one of xml file availability judges file.
S300, before described automated system starts, running package, containing the authenticating documents of described judgement file, is verified the validity of described database file.
Before FA starts, operating personnel in advance running package, containing the authenticating documents of described judgement file, judge that file carries out validation verification to the database file of FA system.To evade the risk that database is made mistakes as early as possible, improve the documentary validity of FA system data.The phenomenon avoiding factor data bank document lending in system cloud gray model to cause FA system break to produce to a certain extent, enhances productivity.
Wherein in an embodiment, described judgement file carries out recording the error message judged simultaneously one by one.The validity of FA database file is verified, and the error message that itemize is judged.Improve database file corrigendum, maintenance efficiency.
Wherein in an embodiment, described before described automated system starts, running package, containing the authenticating documents of described judgement file, is verified the validity of described database file, further comprising the steps of:
S310, to the mistake of carrying out in the described database file of validation verification, prompting Error Location.Prompting Error Location, shortens error-event, improves the efficiency safeguarded, enhances productivity to a certain extent.
Wherein in an embodiment, further comprising the steps of:
S400, when needs perform query manipulation to database, first described automated system is called described judgement file and is carried out validation verification to the data of reading in, and when data are effective, then proceeds data manipulation, otherwise prompting error message.
In system operation, when needing to perform query manipulation to database, first FA system is called and is judged that file carries out comprehensive validation verification to the data of reading in, if data are effective, then proceeds data manipulation, otherwise prompting error message.To the whether non-NULL of the file two-level node inquired about in the database file of inquiry, whether two-level node is fixing structure, three crucial nodes whether non-NULL, in host information file such as above-mentioned FA system, three grades of nodes " HostID " whether non-NULL, if it is empty, then data file is defective, prompting mistake.And judge whether the type of three grades of nodes meets business rule.Comprehensively judge data during data query in FA system cloud gray model, after preventing some bug patches in database, data import by normal data.Such as suppose that node is revised as following text mistakenly:
Above-mentioned text, compared with FA data bank service rule, lacks one three grades nodes " Name ".But due to this node non-NULL, this node data still can normally read in by FA system, this will cause in follow-up flow chart of data processing, and system may report an error extremely.Such as, after reading in this " Host " node, need the value of " Name " node to be assigned to an inner amount, when performing assignment operation, will there is exception in system, causes to produce to interrupt.Now, the work investigating this type of mistake can consume the regular hour, thus have impact on the efficiency of production.Therefore, the embodiment of the present invention can effectively be enhanced productivity.
Wherein in an embodiment, described judgement file adopts ValidateXML () method to generate.Below for Host.xml file, provide the Schema unbound document of its correspondence:
As implied above, define the xml file of three grades of node structures, its constraint is as follows:
1. root node is " Hosts ";
2. two-level node is " Host ", there is endless number system;
3. in each two-level node, having three grades of nodes three, is " HostID ", " Name " and " ModeID " respectively;
Be customization type three grades of nodes " HostID ", be specially the string type following Guid form, and this nodal value can not be empty.
Determine the constraint condition of FA database file interior joint, so that the concrete structural constraint of follow-up basis carries out validation verification to database file.
Based on same inventive concept, the embodiment of the present invention provides a kind of device of automated system database file validation verification, the principle of dealing with problems due to this device is similar to the method for aforementioned a kind of automated system database file validation verification, therefore, the enforcement of this system can realize according to the concrete steps of preceding method, repeats part and repeats no more.
The device of a kind of automated system database file validation verification of the embodiment of the present invention, as shown in Figure 2, comprises the first memory module 100, second memory module 200, and the first authentication module 300.First memory module 100, for storing structural constraint for setting each node in described database file, setting a file of the database object corresponding with described database file.Second memory module 200, for storing for importing input file, and utilizes the judgement file judged the validity of described input file of setting a file of described database object.First authentication module 300, for before described automated system starts, running package, containing the authenticating documents of described judgement file, is verified the validity of described database file.
The device of the automated system database file validation verification of the embodiment of the present invention, before FA starts, operating personnel by the first authentication module in advance running package containing the authenticating documents of described judgement file, judge that file carries out validation verification to the database file of FA system.To evade the risk that database is made mistakes as early as possible, improve the documentary validity of FA system data.The phenomenon avoiding factor data bank document lending in system cloud gray model to cause FA system break to produce to a certain extent, enhances productivity.
Wherein in an embodiment, described judgement file carries out recording the error message judged simultaneously one by one.The validity of FA database file is verified, and the error message that itemize is judged.Improve database file corrigendum, maintenance efficiency.
Wherein in an embodiment, described first authentication module also comprises prompting submodule 310, for the mistake of carrying out in the described database file of validation verification, points out Error Location.Prompting Error Location, shortens error-event, improves the efficiency safeguarded, enhances productivity to a certain extent.
Wherein in an embodiment, also comprise the second authentication module 400, for when needs perform query manipulation to database, call described judgement file and validation verification is carried out to the data of reading in, when data are effective, then proceed data manipulation, otherwise prompting error message.
Wherein in an embodiment, described judgement file adopts ValidateXML () method to generate.
Also provide a kind of automated system based on same inventive concept, comprise automated system database, also comprise the device of above-mentioned automated system database file validation verification.This automated system can carry out comprehensive validation verification to database file, can avoid in conventional plant system automation software platform system due to phenomenon that data exception makes FA system break produce.
The above embodiment only have expressed several embodiment of the present invention, and it describes comparatively concrete and detailed, but therefore can not be interpreted as the restriction to the scope of the claims of the present invention.It should be pointed out that for the person of ordinary skill of the art, without departing from the inventive concept of the premise, can also make some distortion and improvement, these all belong to protection scope of the present invention.Therefore, the protection domain of patent of the present invention should be as the criterion with claims.
Claims (11)
1. a method for automated system database file validation verification, is characterized in that, comprises the following steps:
Build setting a file of the database object corresponding with described database file, set the structural constraint of each node in described database file;
Build for importing input file, and utilize the judgement file that the validity of described input file is judged of setting a file of described database object;
Before described automated system starts, running package, containing the authenticating documents of described judgement file, is verified the validity of described database file.
2. the method for automated system database file validation verification according to claim 1, is characterized in that, described judgement file carries out recording the error message judged simultaneously one by one.
3. the method for automated system database file validation verification according to claim 1 and 2, it is characterized in that, described before described automated system starts, running package is containing the authenticating documents of described judgement file, the validity of described database file is verified, further comprising the steps of:
To the mistake of carrying out in the described database file of validation verification, prompting Error Location.
4. the method for automated system database file validation verification according to claim 1, is characterized in that, further comprising the steps of:
When needs perform query manipulation to database, first described automated system is called described judgement file and is carried out validation verification to the data of reading in, and when data are effective, then proceeds data manipulation, otherwise prompting error message.
5. the method for automated system database file validation verification according to claim 4, is characterized in that, described judgement file adopts ValidateXML () method to generate.
6. a device for automated system database file validation verification, is characterized in that, comprises the first memory module, the second memory module, and the first authentication module, wherein:
Described first memory module, for storing structural constraint for setting each node in described database file, setting a file of the database object corresponding with described database file;
Described second memory module, for storing for importing input file, and utilizes the judgement file judged the validity of described input file of setting a file of described database object;
Described first authentication module, for before described automated system starts, running package, containing the authenticating documents of described judgement file, is verified the validity of described database file.
7. the device of automated system database file validation verification according to claim 6, is characterized in that, described judgement file carries out recording the error message judged simultaneously one by one.
8. the device of the automated system database file validation verification according to claim 6 or 7, it is characterized in that, described first authentication module also comprises prompting submodule, described prompting submodule, for to the mistake of carrying out in the described database file of validation verification, point out Error Location.
9. the device of automated system database file validation verification according to claim 6, it is characterized in that, also comprise the second authentication module, for when needs perform query manipulation to database, call described judgement file and validation verification is carried out to the data of reading in, when data are effective, then proceed data manipulation, otherwise prompting error message.
10. the device of automated system database file validation verification according to claim 9, is characterized in that, described judgement file adopts ValidateXML () method to generate.
11. 1 kinds of automated systems, comprise automated system database, it is characterized in that, also comprise the device of the automated system database file validation verification described in any one of claim 6 to 10.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410031059.7A CN104809111A (en) | 2014-01-23 | 2014-01-23 | Method, device and system for verifying validation of automatic system database file |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201410031059.7A CN104809111A (en) | 2014-01-23 | 2014-01-23 | Method, device and system for verifying validation of automatic system database file |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN104809111A true CN104809111A (en) | 2015-07-29 |
Family
ID=53693942
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201410031059.7A Pending CN104809111A (en) | 2014-01-23 | 2014-01-23 | Method, device and system for verifying validation of automatic system database file |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104809111A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107273386A (en) * | 2016-04-08 | 2017-10-20 | 北京北方华创微电子装备有限公司 | The XML Schema unbound documents generation methods and device of a kind of database |
| CN109726051A (en) * | 2018-12-29 | 2019-05-07 | 上海上讯信息技术股份有限公司 | A kind of database back-up data validity automatic verification method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1825302A (en) * | 2005-02-22 | 2006-08-30 | 中国电子技术标准化研究所 | Method for processing XML file |
| US20070112891A1 (en) * | 2005-11-14 | 2007-05-17 | Apple Computer, Inc. | Converting file-systems that organize and store data for computing systems |
| CN101000622A (en) * | 2007-01-10 | 2007-07-18 | 华为技术有限公司 | Method and device for checking validity of expandable mark language mode |
-
2014
- 2014-01-23 CN CN201410031059.7A patent/CN104809111A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1825302A (en) * | 2005-02-22 | 2006-08-30 | 中国电子技术标准化研究所 | Method for processing XML file |
| US20070112891A1 (en) * | 2005-11-14 | 2007-05-17 | Apple Computer, Inc. | Converting file-systems that organize and store data for computing systems |
| CN101000622A (en) * | 2007-01-10 | 2007-07-18 | 华为技术有限公司 | Method and device for checking validity of expandable mark language mode |
Non-Patent Citations (1)
| Title |
|---|
| 周从军等: "基于XML Schema的数据有效性验证", 《电脑知识与技术（学术交流）》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107273386A (en) * | 2016-04-08 | 2017-10-20 | 北京北方华创微电子装备有限公司 | The XML Schema unbound documents generation methods and device of a kind of database |
| CN107273386B (en) * | 2016-04-08 | 2020-04-28 | 北京北方华创微电子装备有限公司 | XML Schema constraint file generation method and device for database |
| CN109726051A (en) * | 2018-12-29 | 2019-05-07 | 上海上讯信息技术股份有限公司 | A kind of database back-up data validity automatic verification method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108492195B (en) | Rule engine package parameter generalization method, equipment and storage medium | |
| CN109634600B (en) | Code generation method based on security extension SysML and AADL models | |
| CN102360331B (en) | Test program automatic generation method based on formal description | |
| US20140359362A1 (en) | Information interaction test device and method based on automatic generation of associated test cases | |
| CN103853650A (en) | Test case generating method and device for fuzz testing | |
| CN102713834A (en) | Managing record format information | |
| CN105335412A (en) | Method and device for data conversion and data migration | |
| CN106528744A (en) | Format conversion method and system | |
| CN109740122A (en) | The conversion method and device of mind map use-case file | |
| CN102789654A (en) | Method and system for protocol conformance testing of electronic toll collection core equipment | |
| CN103455589A (en) | Product data migration method, device and system in product factory pattern | |
| CN105225066A (en) | The verification method of workflow legitimacy and demo plant | |
| CN110442371A (en) | A kind of method, apparatus of release code, medium and computer equipment | |
| CN110347709A (en) | A kind of construction method and system of regulation engine | |
| CN111367890A (en) | Data migration method and device, computer equipment and readable storage medium | |
| CN104809111A (en) | Method, device and system for verifying validation of automatic system database file | |
| CN107797805A (en) | A kind of code wrap method, apparatus and computer-readable recording medium | |
| CN112559373B (en) | Software compatibility management method and system | |
| CN101272222B (en) | Restriction calibration method and device | |
| CN107025214A (en) | Data processing method and device | |
| CN111782493A (en) | Modeling assistance system and method for modeling data validation of MES | |
| CN111414440B (en) | Method and system for verifying control system algorithm configuration diagram by utilizing data flow isomorphism | |
| CN103838845A (en) | Universal Excel data importing implementing method | |
| CN103092752B (en) | Error identification method of instrument attributes | |
| CN100446638C (en) | Method and system for creating B side and T side detailed list of veneer |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| CB02 | Change of applicant information | ||
| CB02 | Change of applicant information |
Address after: 100176 Beijing economic and Technological Development Zone, Wenchang Road, No. 8, No. Applicant after: Beijing North China microelectronics equipment Co Ltd Address before: 100176 Beijing economic and Technological Development Zone, Beijing, Wenchang Road, No. 8, No. Applicant before: Beifang Microelectronic Base Equipment Proces Research Center Co., Ltd., Beijing |
|
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20150729 |