CN101145043A - Factory information system and its method for updating data - Google Patents
Factory information system and its method for updating data Download PDFInfo
- Publication number
- CN101145043A CN101145043A CN 200610116035 CN200610116035A CN101145043A CN 101145043 A CN101145043 A CN 101145043A CN 200610116035 CN200610116035 CN 200610116035 CN 200610116035 A CN200610116035 A CN 200610116035A CN 101145043 A CN101145043 A CN 101145043A
- Authority
- CN
- China
- Prior art keywords
- test
- test data
- data
- dll
- database
- 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
Images
Abstract
The present invention discloses a factory information system, and the factory information system comprises a plurality of testing machines, a server as well as a internal network, wherein, each testing machine comprises a testing program, a label language and a Dynamic Link Library (DLL), the testing results can be organized by the testing program into a test data in the format of the label language test data, and is sent to the DLL; the server includes a database to store test data, stores the test data in the corresponding columns according to different test data; the internal network can be used to connect with a plurality of testing machines and the server and to transmit testing data; the DLL outputs the testing data to the database in the server; the data base can convert the testing data according to the storing format of the testing data and then stores the testing data in the values of the corresponding columns of the testing data. The present invention also discloses a method to update the data of information systems of plants.
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 markup language, 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 markup language, 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 markup language and one dynamically link database (Dynamic Link Library, DLL), wherein, test procedure is organized into a test data of markup language form by markup language with test result, and transfers among the DLL; 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 form 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.
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 markup language 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 markup language, 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 markup language 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 DLL 202 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 the markup language technology,, guarantee safe, the complete and high-level efficiency of data upload in conjunction with data structure to be uploaded.Wherein, markup language can be used 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 markup language 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 (16)
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 markup language and dynamically links database, wherein, this test procedure is organized into a test data of this markup language form by this markup language with this test result, and transfers among this DLL;
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 DLL exports this test data to this database, and this database is according to the saving format of this test data, this test data is done a conversion and save as the corresponding field value of this test data.
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 markup language 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 form by this markup language 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 form by this SGML with this test result, and this test data is sent to this DLL;
This DLL uploads to this database with these test data archives; And
This database 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.
6. method as claimed in claim 5 is characterized in that, this test procedure is carried out test and also obtained also to comprise a step before this test result step: import a sequence number to this test procedure, and judge whether by this DLL legal.
7. method as claimed in claim 6 is characterized in that, if this sequence number is illegal, then sends an alert notification.
8. method as claimed in claim 6 is characterized in that, if this sequence number is legal, then passes through the authentication of this test procedure automatically.
9. method as claimed in claim 6 is characterized in that, the legitimacy that this DLL judges this sequence number is judged by the rule that this database is pre-stored in this test procedure.
10. method as claimed in claim 5 is characterized in that, this SGML is an extendible SGML.
11. method as claimed in claim 5 is characterized in that, these test data archives also comprise a step after being sent to this DLL step: this DLL receives and resolves the legitimacy of these test data archives.
12. method as claimed in claim 11, it is characterized in that, after this DLL resolves the step of legitimacy of these test data archives, also comprise a step: when these test data archives illegal, then this DLL notifies this test procedure that this test result is reorganized test data archives, is uploaded to this DLL again.
13. method as claimed in claim 11 is characterized in that, this DLL also comprises a step after resolving the step of legitimacy of these test data archives: if these test data archives are legal, subsequent steps: this DLL uploads to this database with these test data archives.
14. method as claimed in claim 5 is characterized in that, the mechanism that this database provides the conversion of this test data archives according to this database and this markup language data structure of predefined.
15. 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.
16. 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 true CN101145043A (en) | 2008-03-19 |
| CN100573376C 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) |
Cited By (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 |
| CN108369415A (en) * | 2015-12-17 | 2018-08-03 | 应用材料公司 | For alternatively and dynamically update schematic diagram superposition method and apparatus |
| CN109947057A (en) * | 2019-02-14 | 2019-06-28 | 珠海格力智能装备有限公司 | Control method, the device and system of test result |
-
2006
- 2006-09-14 CN CN 200610116035 patent/CN100573376C/en not_active Expired - Fee Related
Cited By (5)
| 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 |
| CN108369415A (en) * | 2015-12-17 | 2018-08-03 | 应用材料公司 | For alternatively and dynamically update schematic diagram superposition method and apparatus |
| CN109947057A (en) * | 2019-02-14 | 2019-06-28 | 珠海格力智能装备有限公司 | Control method, the device and system of test result |
| CN109947057B (en) * | 2019-02-14 | 2021-08-17 | 珠海格力智能装备有限公司 | Test result control method, device and system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN100573376C (en) | 2009-12-23 |
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 | |
| CN104598376A (en) | Data driving layered automation test system and method | |
| EP4176602A1 (en) | Method and apparatus for updating gateway resource, and iot control platform | |
| CN107656749A (en) | A kind of device version management-control method and device | |
| CN1937559A (en) | Proxy server for integration of industrial automation data over multiple networks | |
| CN105915381B (en) | A kind of realization monitoring system service logic online modification system | |
| CN102298365A (en) | Method for automatically identifying and managing spaceflight measurement and control earth station device change | |
| CN102043719A (en) | Method for testing IEC61850 configuration description file | |
| CN108427383B (en) | Engineering device, engineering method, and storage medium | |
| CN104102489A (en) | Third-party database APP (Application) construction system and construction method | |
| CN101174237B (en) | Automatic test method, system and test device | |
| CN106327100A (en) | Change list generation method and device | |
| CN106934507A (en) | A kind of new cruising inspection system and method for oil field petrochemical field | |
| CN100573376C (en) | The factory information system and the method for new data more thereof | |
| CN102087657A (en) | IO (Input/output) to point method and IO (Input/output) to point for nuclear power plant simulation platform | |
| KR100982527B1 (en) | Total Dimensional Accuracy Control System and Method for Block Assembly | |
| CN113778903B (en) | Method and system for generating test case of power distribution terminal and storage medium | |
| CN113285841B (en) | Configuration method of industrial gateway data transmission protocol | |
| CN113676366A (en) | Consistency testing tool for power communication protocol | |
| CN111401028B (en) | Automatic comparison method and device for RPS software versions of nuclear power station | |
| CN108984398A (en) | Method, apparatus, electronic device and the storage medium of software test | |
| CN105868410A (en) | Model-driven intelligent SCD (substation configuration description) file and CIM/E (common information model/efficiency) file conversion tool and method | |
| CN109117431A (en) | System and method for the source data applied from source to be incorporated into the target data of target application | |
| CN114123482A (en) | Main plant station information joint debugging decoupling 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 |