CN100573376C - The factory information system and the method for new data more thereof - Google Patents
The factory information system and the method for new data more thereof Download PDFInfo
- Publication number
- CN100573376C CN100573376C CN 200610116035 CN200610116035A CN100573376C CN 100573376 C CN100573376 C CN 100573376C CN 200610116035 CN200610116035 CN 200610116035 CN 200610116035 A CN200610116035 A CN 200610116035A CN 100573376 C CN100573376 C CN 100573376C
- Authority
- CN
- China
- Prior art keywords
- test
- database
- test data
- data
- dynamically
- 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.)
- Expired - Fee Related
Links
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a kind of factory information system, comprise: a plurality of tester tables, wherein each tester table comprises a test procedure, a SGML and dynamically links database (Dynamic Link Library, DLL), test procedure is organized into the test data of a markup language with test result, and is sent to DLL; One servomechanism comprises a database, in order to store test data, and deposits in corresponding field according to the difference of test data; And an internal network, in order to link a plurality of tester tables and servomechanism and to transmit test data.Wherein, DLL exports test data in the servomechanism database, and database is done a conversion according to the saving format of test data with test data and saved as the corresponding field value of test data.The present invention also discloses a kind of method of upgrading the factory information system data.
Description
Technical field
The present invention is relevant for the method for a kind of factory information system and renewal factory information system data thereof, but be meant the data between a kind of integration test system and the plant area's supervisory system and the factory information system of flow process especially, and upgrade the method for factory information system data.
Background technology
Manufacturing industry develops into customer orientation and competition guiding from producing guiding during the decade apace at this, thereby also makes the situation of production scene play very big change, and the conventional management pattern has been unable to cope with this new situation.At the problem that factory management faced, just develop and that a cover can be grasped the state of plant area's activity and information is given the supvr, make the supvr assign effective order management and control plant area, this cover system just is called plant area's supervisory system (Shop Floor ControlSystem, SFCS), also often be called factory information system (Factory Information System, FIS) or the production information automatic system (Computer Integrated Manufacturing, CIM) etc.
Because every profession and trade plant produced scale all significantly enlarges,, because need a large amount of tests in the production of electronic product, and the personnel that write of test procedure, generally do not understand data store organisation in database and the flow process control of FIS with the information package trade; And the test of difference in functionality, corresponding testing apparatus manufacturer and test special project are all different, so the data layout of test result and content are also all different.
Under the demand of instant messages, practical problems that production line faces and bottleneck are got rid of, can see through and import FIS, use the lifting management efficiency; Yet, be not that every company even each tester table and program are all used identical infosystem, therefore, even used identical database, every company and each test procedure gained result's data structure is also necessarily far from each other, and the tangible suitable difficulty of so huge exchanges data.
See also Fig. 1, be the synoptic diagram of known technology one factory information system.Current factory information system 1 way is with the unified collection of product to be tested, after finishing via different tester table 10 test, by manually test result being indicated on the product, regather the renewal of doing the other flow process in station by a main control system (Station Control Client) 12, test contents and result are stored in the database 140 of servomechanism 14 with archive files.
This factory information system will have such problem and exist: independent separately between the test procedure of tester table 10, main control system 12 and the servomechanism 14, therefore, can not the immediate updating data, cause production efficiency low, the detailed results of test is not stored in database, be not easy to data analysis, add that again artificial judgment makes mistakes easily, and the time have the incomplete situation of data recording take place easily in input, for example not having each, detailed the test bad item all is collected into or the situation that test data may be lost takes place.
Therefore the present invention is directed to above-mentioned problem, design a factory information system, design by program, utilize SGML, dynamically link the integration of database and internal network, make the result of each test procedure can be immediately via network update content and be stored in database in servomechanism, to improve the problems referred to above.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of factory information system, by SGML, dynamically link the integration of database and internal network, but makes result's immediate updating of each test procedure and is stored in database.
Another object of the present invention is to provide a kind of method of upgrading the factory information system data, but robotization upgrade, remove the inconvenience of manual entry, but efficient and intactly record make result's immediate updating of each test procedure and be stored in database.
Based on above-mentioned purpose, the present invention discloses a kind of factory information system, in order to logging test results, comprise: a plurality of tester tables, wherein each tester table comprise a test procedure, a SGML and one dynamically link database (Dynamic Link Library, DLL), wherein, test procedure is organized into a test data of markup language by SGML with test result, and transfers among the DLL, and this DLL receives and resolve the legitimacy of this test data; One servomechanism comprises a database at least, in order to store test data, and deposits in corresponding field according to the difference of test data; And an internal network, in order to link a plurality of tester tables and servomechanism and to transmit test data; Wherein, DLL exports test data to database, and database is according to the saving format of test data, test data is done a conversion and save as the corresponding field value of test data.
Based on above-mentioned purpose, the present invention also discloses the more method of new data of a kind of factory information system in addition, comprises the following step: test procedure is carried out test and is obtained a test result; Test procedure is organized into a test data of markup language by SGML with test result, and test data is sent to DLL; DLL uploads to database with the test data archives; Database is converted to the corresponding field value of database with the test data archives and stores, and wherein, these test data archives also comprise a step after being sent to this DLL step: this DLL receives and resolve the legitimacy of these test data archives.
The present invention has following advantage compared to the prior art:
The present invention can robotization upgrades efficient and intactly record test data and result, avoids artificial judgment to make mistakes and the incomplete situation generation of data recording is arranged when import.
The present invention utilize SGML technique guarantee upload the versatility of interface for various different structure data, can remove the difference of factor from, and huge exchanges data need be arranged according to structure.
Description of drawings
By following detailed description in conjunction with the accompanying drawings, can understand the plurality of advantages of foregoing and the present invention easily, wherein:
Fig. 1 is the synoptic diagram of known technology one factory information system;
Fig. 2 is the factory information system synoptic diagram of one embodiment of the invention; And
Fig. 3 uploads the process flow diagram of interface storage data for the factory information system utilization of one embodiment of the invention.
Embodiment
The invention provides a factory information system, design by program, utilize SGML, dynamically link the integration of database and internal network, write the general interface of uploading that a data operation middle layer dynamically links database, realize that test macro combines with the flow process and the data of factory information system, with detail record test data and test result, utilize existing database to finish data mining and data analysis to test data, and guarantee to upload the versatility of interface for various different structure data, can finish this purpose with the existing outfit that detects board.In order to make narration of the present invention more detailed and complete, please refer to following description and cooperate following accompanying drawing.
See also Fig. 2, be the factory information system synoptic diagram of one embodiment of the invention.Factory information system 2 is linked to servomechanism 24 by a plurality of tester tables 20 via internal network 22.Wherein, a test procedure 200, one dynamic database (Dynamic Link Library, DLL) 202 and one SGML 204 of linking that comprises required use separately in each tester table 20 at least.Internal network 22 is in order to link a plurality of tester tables 20 and servomechanism 204 and Data transmission.Dynamically link the upload interface of database 202, in order to data are exported to servomechanism 24 as tester table 20.And comprise a database (Database) 240 in the servomechanism 24 at least, in order to store each tester table 20 the test data in the servomechanism that transfers to 24, also can be simultaneously as the database of factory information system.
Institute of the present invention written program utilizes DLL 202 to set up the data manipulation middle layer of a safety, and DLL202 can be called out for test procedure as a shared module, and realizes being connected of database (FIS database) data in test data and the servomechanism; When uploading data again, utilize mark-up language technique,, guarantee safe, the complete and high-level efficiency of data upload in conjunction with data structure to be uploaded.Wherein, SGML can use extendible SGML (eXtensible Markup Language, XML), because the mark of XML, therefore need not consider in the upload procedure of DLL 202 middle layer test datas that different content measurements are made different data structures resolves, and finishes and will give database back end.Like this in test process, both guaranteed test data safety, complete and upload efficiently, can guarantee applicability and the stability of data manipulation middle layer DLL 202 again.
Please refer to Fig. 3, upload the process flow diagram of interface storage data for the factory information system utilization of one embodiment of the invention.Present embodiment is linked to servomechanism with tester table by internal network, reaches by institute's written program test data is uploaded the method that interface is uploaded to database by the DLL middle layer, comprises the following step:
Step S300, the initial step of test procedure for this reason.Step S302 imports a sequence number by the monitoring personnel to tester table, and this sequence number is the sequence number that the supplier provided according to each test procedure.Step S3040, test procedure will call out and dynamically link database (DLL), and DLL will judge the legitimacy of this sequence number; It is by step S3042, and the specification in the program that is prestored into by factory information system (FIS) database is judged.If sequence number is illegal, then send an alert notification; If sequence number is legal, automatically by the installation of testing software, enter step S306, the beginning test process.Step S308, test is finished and is produced a test result, according to the data structure of predefined test data and test result is organized into test data archives (hereinafter to be referred as the XML archives).Step S310 is sent to the DLL middle layer with test result XML archives.
Step S312, the DLL acceptance test is the legitimacy of XML archives and analyzing XML archives as a result.If test result XML archives are illegal, the notice that then says the word test procedure is reorganized into the XML archives with test data and test result, is uploaded to DLL again; If test result XML archives are legal, then enter step S314, DLL uploads to test data XML archives in the database.
Step S316, database acceptance test data archival in the servomechanism according to the mechanism that provides in the XML data structure of predefined and the database, is converted to the corresponding field value of database with the data in the XML archives.Step S318 deposits the corresponding field value of being changed in the database in, and sends one and return and notify to DLL.
Step S320, DLL receive and to return notice, i.e. return results, and send one again and finish message to test procedure.Step S322, test procedure receive and finish message, finish this testing procedure.
In the present invention, dynamically linking database need be placed under the path identical with testing software, can finish renewal by immediate updating (LiveUpdate) program of factory information system, and rely on the XML technique guarantee and upload the versatility of interface for various different structure data.
The present invention combines by DLL technology and XML technology, adds the support of database to its XML technology, by writing the general interface of uploading of a data operation middle layer DLL, realizes that test macro combines with the flow process and the data of factory information system.At length record test data and result are so that utilize the existing database instrument to finish data mining and data analysis to test data.
The present invention has following advantage compared to the prior art: can robotization upgrade efficient and complete record test data and result, avoid artificial judgment to make mistakes and the incomplete situation generation of data recording is arranged when import; Utilize again SGML technique guarantee upload the versatility of interface for various different structure data, can remove the difference of factor from, and huge exchanges data need be arranged according to structure.
Though the present invention illustrates as above with preferred embodiment, so it is not only to terminate in the foregoing description in order to limit spirit of the present invention and entity of the present invention.So, having in any affiliated technical field and know the knowledgeable usually, the modification of being done in without departing from the spirit or scope of the invention all should be included in the following claim.
Claims (12)
1. a factory information system, in order to logging test results, this system comprises:
A plurality of tester tables, wherein each this tester table comprises a test procedure, a SGML and dynamically links database, wherein, this test procedure is organized into this test result by this SGML one test data of this markup language, and transfer to this dynamic binding in the database, this dynamically links the legitimacy that database received and resolved this test data;
One servomechanism comprises a database at least, in order to storing this test data, and deposits in corresponding field according to the difference of this test data; And
One internal network is in order to link these a plurality of tester tables and this servomechanism and to transmit this test data;
Wherein, this dynamically links database and exports this test data the database of this servomechanism to, and the database of this servomechanism is according to the saving format of this test data, and this test data is done a conversion and save as the corresponding field value of this test data,
Wherein, this test procedure is carried out test and is also obtained before this test result step, also comprise input one sequence number to this test procedure and by this dynamically link database judge whether legal; If this sequence number is illegal, then send an alert notification; If this sequence number is legal, then pass through the authentication of this test procedure automatically,
Wherein, after storing described corresponding field value, send one and return notice to should dynamically linking database, described dynamic binding database describedly sends one again after returning notice and finishes message to test procedure receiving, and described test procedure finishes test after receiving described end message.
2. the system as claimed in claim 1 is characterized in that, the test procedure in each this tester table can be different test events.
3. the system as claimed in claim 1 is characterized in that, this SGML is an extend markup language.
4. the system as claimed in claim 1, it is characterized in that this system also comprises the storage test parameter, wherein, when this test procedure is organized into this test data of this markup language by this SGML with this test result, simultaneously this test parameter is organized into this test data.
5. the method for a logging test results comprises the following step:
One test procedure is carried out test and is obtained a test result;
This test procedure is organized into a test data of this markup language by a SGML with this test result, this test data is sent to one of tester table dynamically links database;
Should dynamically link the database that database uploads to test data archives servomechanism; And
The database of this servomechanism is according to the saving format of this test data, with this test data conversion, and saves as the corresponding field value of this test data,
Wherein, after these test data archives were sent to this dynamic binding database steps, also comprise a step: this dynamically linked the legitimacy that database received and resolved these test data archives,
Wherein, this test procedure is carried out test and is also obtained before this test result step, also comprise input one sequence number to this test procedure and by this dynamically link database judge whether legal; If this sequence number is illegal, then send an alert notification; If this sequence number is legal, then pass through the authentication of this test procedure automatically,
Wherein, after storing described corresponding field value, send one and return notice to should dynamically linking database, described dynamic binding database describedly sends one again after returning notice and finishes message to test procedure receiving, and described test procedure finishes test after receiving described end message.
6. method as claimed in claim 5 is characterized in that, this dynamically links legitimacy that database judges this sequence number and judges by the rule that the database of this servomechanism is pre-stored in this test procedure.
7. method as claimed in claim 5 is characterized in that, this SGML is an extendible SGML.
8. method as claimed in claim 5, it is characterized in that, after should dynamically linking database and resolving the step of legitimacy of these test data archives, also comprise a step: when these test data archives illegal, then should dynamically link this test procedure of database notification this test result was reorganized test data archives, and be uploaded to this again and dynamically link database.
9. method as claimed in claim 5, it is characterized in that, after should dynamically linking database and resolving the step of legitimacy of these test data archives, also comprise a step: if these test data archives are legal, subsequent steps: this dynamically links the database that database uploads to these test data archives this servomechanism.
10. method as claimed in claim 5 is characterized in that, the mechanism that the database of this servomechanism provides the conversion of this test data archives according to the database of this servomechanism and this markup-language data structure of predefined.
11. method as claimed in claim 5 is characterized in that, this dynamically links database and this test procedure can be by this factory information system new data more.
12. method as claimed in claim 5 is characterized in that, when this test procedure is organized into this test data by this SGML with this test result, also comprises a test parameter is organized into this test data simultaneously.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610116035 CN100573376C (en) | 2006-09-14 | 2006-09-14 | The factory information system and the method for new data more thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 200610116035 CN100573376C (en) | 2006-09-14 | 2006-09-14 | The factory information system and the method for new data more thereof |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101145043A CN101145043A (en) | 2008-03-19 |
| CN100573376C true CN100573376C (en) | 2009-12-23 |
Family
ID=39207601
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 200610116035 Expired - Fee Related CN100573376C (en) | 2006-09-14 | 2006-09-14 | The factory information system and the method for new data more thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN100573376C (en) |
Families Citing this family (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102385350A (en) * | 2010-08-30 | 2012-03-21 | 北汽福田汽车股份有限公司 | Process card output method and device, and computer device |
| CN104700217A (en) * | 2015-03-17 | 2015-06-10 | 歌尔声学股份有限公司 | Method and system for collecting test data |
| US10325792B2 (en) * | 2015-12-17 | 2019-06-18 | Applied Materials, Inc. | Methods and apparatus for interactively and dynamically updating a schematic overlay |
| CN109947057B (en) * | 2019-02-14 | 2021-08-17 | 珠海格力智能装备有限公司 | Test result control method, device and system |
-
2006
- 2006-09-14 CN CN 200610116035 patent/CN100573376C/en not_active Expired - Fee Related
Non-Patent Citations (4)
| Title |
|---|
| XML数据库技术. 万常选,99-102,清华大学出版社. 2005 |
| XML数据库技术. 万常选，99-102，清华大学出版社. 2005 * |
| 利用计算机指纹实现软件加密原理与方法. 鞠斌山，邱晓凤，张文东.青岛大学学报(自然科学版)，第18卷第3期. 2005 |
| 利用计算机指纹实现软件加密原理与方法. 鞠斌山，邱晓凤，张文东.青岛大学学报(自然科学版)，第18卷第3期. 2005 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101145043A (en) | 2008-03-19 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101393442B (en) | CEMS monitoring method based on OPC communication technology | |
| CN102750301B (en) | Blueprint generating method for integrated avionic system model aiming at architecture analysis and design language (AADL) description | |
| CN102043719B (en) | Method for testing IEC61850 configuration description file | |
| CN100593794C (en) | Long-distance controlling apparatus used for crops production expert diagnosing system and method thereof | |
| CN104598376A (en) | Data driving layered automation test system and method | |
| CN101621405A (en) | Distributed type management monitoring system, monitoring method and establishing method thereof | |
| CN106707848A (en) | Control program organization structure of control system and download method | |
| CN107656749A (en) | A kind of device version management-control method and device | |
| CN105577475A (en) | Automatic performance test system and method | |
| CN100573376C (en) | The factory information system and the method for new data more thereof | |
| CN108427383B (en) | Engineering device, engineering method, and storage medium | |
| CN102004954A (en) | Product information system and information integration method of product design system | |
| CN106327100A (en) | Change list generation method and device | |
| CN114123482A (en) | Main plant station information joint debugging decoupling method | |
| KR100982527B1 (en) | Total Dimensional Accuracy Control System and Method for Block Assembly | |
| CN101771725A (en) | Method and system for constructing service testing environment | |
| CN113676366A (en) | Consistency testing tool for power communication protocol | |
| CN105868410A (en) | Model-driven intelligent SCD (substation configuration description) file and CIM/E (common information model/efficiency) file conversion tool and method | |
| CN108287720A (en) | software compilation method, device, equipment and storage medium | |
| CN109117431A (en) | System and method for the source data applied from source to be incorporated into the target data of target application | |
| CN111813439B (en) | Distribution material quality control method, device, equipment and computer storage medium | |
| CN109687984B (en) | Configuration system and configuration method of wind power SCADA system | |
| US11307564B2 (en) | Methods, systems and computer program products for plant resource management | |
| CN112347321A (en) | Test management system for factory test of box-type transformer substation | |
| CN102310950B (en) | Experiment intelligent interpretation system and method |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20091223 Termination date: 20210914 |