CN104679758A - Production backtracking management system adopting double database bridge and method thereof - Google Patents
Production backtracking management system adopting double database bridge and method thereof Download PDFInfo
- Publication number
- CN104679758A CN104679758A CN201310616830.2A CN201310616830A CN104679758A CN 104679758 A CN104679758 A CN 104679758A CN 201310616830 A CN201310616830 A CN 201310616830A CN 104679758 A CN104679758 A CN 104679758A
- Authority
- CN
- China
- Prior art keywords
- database
- production
- wincc
- data storehouse
- user archive
- 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
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
-
- 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/27—Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q10/00—Administration; Management
- G06Q10/06—Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- Business, Economics & Management (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- General Engineering & Computer Science (AREA)
- Strategic Management (AREA)
- Data Mining & Analysis (AREA)
- Human Resources & Organizations (AREA)
- Educational Administration (AREA)
- Game Theory and Decision Science (AREA)
- Computing Systems (AREA)
- Development Economics (AREA)
- Marketing (AREA)
- Operations Research (AREA)
- Quality & Reliability (AREA)
- Tourism & Hospitality (AREA)
- General Business, Economics & Management (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a production backtracking management system adopting a double database bridge and a method thereof. The production backtracking management system comprises double database bodies and all production backtracking information of specific process links required by the double database bodies, wherein the double database bodies include a WinCC filing database located in a system monitoring layer and a relational database located in a system management layer, and the WinCC filing database and the relational database are established based on Microsoft SQL Server. The WinCC filing database and the relational database form a production backtracking database, the mode that the information of the two databases is simply merged is abandoned, a database bridge is established between the two databases to enable the information to flow as required, and a core function of production backtracking management is successively achieved.
Description
[technical field]
A kind of production backtracking management system and method thereof adopting Double Data storehouse bridge of the present invention.
[background technology]
Utilize configuration software to realize production process monitoring technology to be used widely.For large and medium-sized enterprise, when carrying out necessary production process monitoring, optimization and the management of production process are also key problems.Produce backtracking management refer to by production technology links to all in real time and non-real-time data carry out information classification.This mode indirectly obtaining production data by production technology link is called as " backtracking ".Produce backtracking management and effectively can find a certain concrete technology link Problems existing, thus improvement is made to production process and optimizes.Obviously, the subsystem that backtracking management system is production management system is produced.
The core of carrying out producing backtracking sets up production retrieve data storehouse, as shown in Figure 1, all production informations of backtracking that needs is recorded in database.The unspecial database application method for producing backtracking at present, most manufacturing monitoring system and production management system are independently.But the information recording method based on WinCC configuration environment has a lot, main employing WinCC VBS script operation WinCC filing data storehouse or relational database.
Set up production retrieve data storehouse, generally integrated in the real-time filing data storehouse in manufacturing monitoring system and the relational database in production management system, real-time filing data by filing data storehouse writes in the relational database in production management system online, produces backtracking to facilitate.But find that the information transmission of this big data quantity very easily causes seriously taking of host computer resource in experiment, and the real-time of information and accuracy can not ensure, the design of simul relation database is also more complicated.
[summary of the invention]
The object of the invention is to the defect for prior art and deficiency, there is provided a kind of structure simple, a kind of production backtracking management system and method thereof adopting Double Data storehouse bridge reasonable in design, easy to use, it has abandoned the mode that two database informations simply merge, database bridge is built between two databases, information is flowed as required, successfully achieves the Core Feature of producing backtracking management.
A kind of production backtracking management system and method thereof adopting Double Data storehouse bridge of the present invention, it comprises all production traceback informations of concrete technology link needed for Double Data storehouse body and Double Data storehouse body, described Double Data storehouse body comprises the WinCC filing data storehouse being in system monitoring layer and the relational database being in system management layer, and WinCC filing data storehouse and relational database all build based on Microsoft SQL Server; This WinCC filing data storehouse and relational database composition production retrieve data storehouse.
Described WinCC filing data storehouse is divided into again variable database of record and user archive database, can realize the operation to variable database of record and user archive database by the .Net control of the SQL statement of specific syntax structure, WinCC VBS shell script and secondary development.
Described user archive database can also utilize the cooperation of user archive parameter ID and JOB to realize interpolation and the deletion of data.
Building database bridge between described WinCC filing data storehouse and relational database; It is as follows that its database bridge realizes date interworkmg method:
I, described production traceback information to be classified:
Data source a: the numeric type real-time production data needing the cycle to file;
Data source b: product introduction and the character type production data recorded when leaving production line;
Data source c: obtain from production management system, the order belonging to this product and batch information;
II, as follows for the data source disposal route of above-mentioned three productions traceback information:
Data a, data b in described production traceback information, data c charge to WinCC variable database of record, user archive database and relational database respectively; Its interaction flow is as follows:
A. set up order, batch and WinCC built-in variable:
B. WinCC user archive database sequence information table and station information table is set up;
C. WinCC variable is connected to the corresponding field in WinCC user archive database sequence information table and station information table;
During d..Net control response task by the batch of orders information updating of producing in SQL relational database to user archive sequence information table;
E., in the overall VBS script of responsible real time record station information change, ID with JOB parameter is utilized by the batch of orders information assignment in user archive sequence information table to be connected WinCC variable;
F., in the overall VBS script of responsible real time record station information change, ID with JOB parameter is utilized to file in the station information table of user archive database together with all production informations;
By the batch of orders information deletion produced current in user archive sequence information table when g..Net control is finished the work, and then deliver to steps d.
After adopting said structure, beneficial effect of the present invention is: a kind of production backtracking management system and method thereof adopting Double Data storehouse bridge of the present invention, it has abandoned the mode that two database informations simply merge, database bridge is built between two databases, information is flowed as required, successfully achieves the Core Feature of producing backtracking management.
[accompanying drawing explanation]
Accompanying drawing described herein is used to provide a further understanding of the present invention, forms a application's part, but does not form inappropriate limitation of the present invention, in the accompanying drawings:
Fig. 1 is the production retrieve data base relation figure that traditional approach of the present invention adopts;
Fig. 2 is database bridge information interactive process process flow diagram in the present invention;
Double Data library structure schematic diagram in Fig. 3 the present invention.
[embodiment]
Describe the present invention in detail below in conjunction with accompanying drawing and specific embodiment, illustrative examples wherein and explanation are only used for explaining the present invention, but not as a limitation of the invention.
As shown in Figure 2 and Figure 3, a kind of production backtracking management system and method thereof adopting Double Data storehouse bridge described in this embodiment, it comprises all production traceback informations of concrete technology link needed for Double Data storehouse body and Double Data storehouse body, described Double Data storehouse body comprises the WinCC filing data storehouse being in system monitoring layer and the relational database being in system management layer, and WinCC filing data storehouse and relational database all build based on Microsoft SQL Server; This WinCC filing data storehouse and relational database composition production retrieve data storehouse.
Described WinCC filing data storehouse is divided into again variable database of record and user archive database, can realize the operation to variable database of record and user archive database by the .Net control of the SQL statement of specific syntax structure, WinCC VBS shell script and secondary development.
Described user archive database can also utilize the cooperation of user archive parameter ID and JOB to realize interpolation and the deletion of data.
Building database bridge between described WinCC filing data storehouse and relational database; It is as follows that its database bridge realizes date interworkmg method:
I, described production traceback information to be classified:
Data source a: the numeric type real-time production data needing the cycle to file; Such as, in the car body welding producing line welding current of welding machine, weldingvoltage etc.;
Data source b: product introduction and the character type production data recorded when leaving production line; The operation user of such as production line, the bar code of product, the time etc. of turnover production line;
Data source c: obtain from production management system, the order belonging to this product and batch information;
Order belonging to this product and batch information.This category information generally leaves in the relational database of administration and supervision authorities;
II, as follows for the data source disposal route of above-mentioned three productions traceback information:
Data a, data b in described production traceback information, data c charge to WinCC variable database of record, user archive database and relational database respectively; Its interaction flow is as follows:
A. set up order, batch and WinCC built-in variable;
B. WinCC user archive database sequence information table and station information table is set up;
C. WinCC variable is connected to the corresponding field in WinCC user archive database sequence information table and station information table;
During d..Net control response task by the batch of orders information updating of producing in SQL relational database to user archive sequence information table;
E., in the overall VBS script of responsible real time record station information change, ID with JOB parameter is utilized by the batch of orders information assignment in user archive sequence information table to be connected WinCC variable;
F., in the overall VBS script of responsible real time record station information change, ID with JOB parameter is utilized to file in the station information table of user archive database together with all production informations;
By the batch of orders information deletion produced current in user archive sequence information table when g..Net control is finished the work, and then deliver to steps d.
In the present invention, for produce data source a, the data source b of traceback information, data source c tri-category information processing mode as follows:
(1) (data source a), is placed in WinCC variable database of record, in WinCC variable record, carries out configuration type I information, and carries out application management with the variable record control that WinCC carries to variable database of record in picture.Information due to variable database of record is continuous print, therefore can not distinguish the information of different product on production line.The present invention's record product in user archive Basic Information Table enters and leaves the time of production line, then the time period of WinCC variable record control is used to intercept function, allow control show the filing value intercepted in the time period, thus obtain cycle archive information corresponding to this product;
(2) Equations of The Second Kind information (data source b), be placed in WinCC user archive database, the present invention carries out configuration and sets up Basic Information Table in WinCC user archive, and in WinCC overall situation VBS script, write the record of codes implement essential information, the .Net control adding secondary development in picture carries out application management to user archive database.The structure of Basic Information Table also needs to reserve the fields such as the sequence information integrated into from relational database when designing except the production information field of adding in user archive database herein;
(3) the 3rd category informations (data source c), by .Net control by the order number produced current in relational database and batch number information reproduction in the sequence information table of user archive database.Can call WinCCODK function the information in relational database is write in WinCC variable, but the method processing procedure is more loaded down with trivial details.Comparatively speaking, employing .Net control operates user archive database simultaneously and relational database realizes more convenient, because the field in user archive database table can be connected to WinCC variable, if have record in table, then by controling parameters ID with JOB, the field value of selected record can be assigned to be connected WinCC variable, recycling WinCC VBS script system controls user archive parameter ID and JOB and production informations all in user archive database is integrated together.
The present invention adopts the VBS overall situation script edit of WinCC, realizes adding variable record to WinCC user archive database; Application claims host computer monitoring software must adopt the WinCC7.OSP2 of Siemens Company and above version, and the database software of administration and supervision authorities requires to support sql like language.Exploitation .Net control carries out production information backtracking to user archive database.
The present invention and existing Technical comparing, advantage of the present invention is:
(1), realize production data and the unified management of administration and supervision authorities data of supervisory layers, data are mutual as required, greatly save server resource;
(2), all production of arbitrary automation equipment and nonproductive data message in a certain production link can be recalled, provide extensive guide for optimizing and improving production link;
(3), be not only applicable to produce backtracking management system, and to other MES management system, all there is using value and use meaning.
(4), without restraint of trade.
A kind of production backtracking management system and method thereof adopting Double Data storehouse bridge of the present invention, it has abandoned the mode that two database informations simply merge, between two databases, build database bridge, information is flowed as required, successfully achieve the Core Feature of producing backtracking management.
The above is only better embodiment of the present invention, therefore all equivalences done according to structure, feature and the principle described in patent claim of the present invention change or modify, and are included in patent claim of the present invention.
Claims (4)
1. one kind adopts production backtracking management system and the method thereof of Double Data storehouse bridge, it is characterized in that: it comprises all production traceback informations of concrete technology link needed for Double Data storehouse body and Double Data storehouse body, described Double Data storehouse body comprises the WinCC filing data storehouse being in system monitoring layer and the relational database being in system management layer, and WinCC filing data storehouse and relational database all build based on Microsoft SQL Server; This WinCC filing data storehouse and relational database composition production retrieve data storehouse.
2. a kind of production backtracking management system and method thereof adopting Double Data storehouse bridge according to claim 1, it is characterized in that: described WinCC filing data storehouse is divided into again variable database of record and user archive database, the operation to variable database of record and user archive database can be realized by the .Net control of the SQL statement of specific syntax structure, WinCC VBS shell script and secondary development.
3. a kind of production backtracking management system and method thereof adopting Double Data storehouse bridge according to claim 1, is characterized in that: described user archive database can also utilize the cooperation of user archive parameter ID and JOB to realize interpolation and the deletion of data.
4. a kind of production backtracking management system and method thereof adopting Double Data storehouse bridge according to claim 1, is characterized in that: building database bridge between described WinCC filing data storehouse and relational database; It is as follows that its database bridge realizes date interworkmg method:
I, described production traceback information to be classified:
Data source a: the numeric type real-time production data needing the cycle to file;
Data source b: product introduction and the character type production data recorded when leaving production line;
Data source c: obtain from production management system, the order belonging to this product and batch information;
II, as follows for the data source disposal route of above-mentioned three productions traceback information:
Data a, data b in described production traceback information, data c charge to WinCC variable database of record, user archive database and relational database respectively; Its interaction flow is as follows:
A. set up order, batch and WinCC built-in variable;
B. WinCC user archive database sequence information table and station information table is set up;
C. WinCC variable is connected to the corresponding field in WinCC user archive database sequence information table and station information table;
During d..Net control response task by the batch of orders information updating of producing in SQL relational database to user archive sequence information table;
E., in the overall VBS script of responsible real time record station information change, ID with JOB parameter is utilized by the batch of orders information assignment in user archive sequence information table to be connected WinCC variable;
F., in the overall VBS script of responsible real time record station information change, ID with JOB parameter is utilized to file in the station information table of user archive database together with all production informations;
By the batch of orders information deletion produced current in user archive sequence information table when g..Net control is finished the work, and then deliver to steps d.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310616830.2A CN104679758B (en) | 2013-11-29 | 2013-11-29 | Management system is recalled in a kind of production using double data library bridge |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310616830.2A CN104679758B (en) | 2013-11-29 | 2013-11-29 | Management system is recalled in a kind of production using double data library bridge |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104679758A true CN104679758A (en) | 2015-06-03 |
| CN104679758B CN104679758B (en) | 2018-06-22 |
Family
ID=53314820
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310616830.2A Active CN104679758B (en) | 2013-11-29 | 2013-11-29 | Management system is recalled in a kind of production using double data library bridge |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104679758B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101923606A (en) * | 2010-08-20 | 2010-12-22 | 无锡北邮感知技术产业研究院有限公司 | System and method for drug placement, distribution and source tracing based on digital tags |
| CN102339030A (en) * | 2011-10-20 | 2012-02-01 | 河海大学常州校区 | Online real-time diagnosis service system and method for hydraulic cold-drawing machine |
| CN102360466A (en) * | 2011-10-12 | 2012-02-22 | 天津振兴水泥有限公司 | Method and system for tracing material quality in whole course of cement production |
-
2013
- 2013-11-29 CN CN201310616830.2A patent/CN104679758B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101923606A (en) * | 2010-08-20 | 2010-12-22 | 无锡北邮感知技术产业研究院有限公司 | System and method for drug placement, distribution and source tracing based on digital tags |
| CN102360466A (en) * | 2011-10-12 | 2012-02-22 | 天津振兴水泥有限公司 | Method and system for tracing material quality in whole course of cement production |
| CN102339030A (en) * | 2011-10-20 | 2012-02-01 | 河海大学常州校区 | Online real-time diagnosis service system and method for hydraulic cold-drawing machine |
Non-Patent Citations (1)
| Title |
|---|
| 武福生 等: "WinCC数据归档在输煤过程中的应用", 《工矿自动化》 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104679758B (en) | 2018-06-22 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101718977B (en) | CAM system for automobile longeron punching processing and control method and construction method thereof | |
| CN108971807B (en) | Intelligent management control method and management system for field welding construction process | |
| CN104572895B (en) | MPP databases and Hadoop company-datas interoperability methods, instrument and implementation method | |
| CN104407576A (en) | Realization method for general type production and manufacturing unit and control system thereof | |
| CN104778540A (en) | BOM (bill of material) management method and management system for building material equipment manufacturing | |
| CN102707669B (en) | Method for constructing CAM (computer-aided manufacturing) system for punching for automobile girders | |
| CN101763064A (en) | Numerical control machining process design system and method of aircraft complex components facing process object | |
| CN102044016A (en) | Method and device for realizing automatic product configuration by utilizing spreadsheet definition rule | |
| CN106776962A (en) | A kind of general Excel data import multiple database physical table methods | |
| CN103616855A (en) | Three-dimensional simulation assembly-based cutting tool management system and management method thereof | |
| CN102004954A (en) | Product information system and information integration method of product design system | |
| CN110543303A (en) | Visual business platform | |
| CN106446019A (en) | Software function processing method and device | |
| CN104216845A (en) | Process-oriented complex product final assembly data information transmitting method | |
| CN105975489A (en) | Metadata-based online SQL code completion method | |
| CN105279269A (en) | SQL generating method and system for supporting table free association | |
| CN108829651A (en) | A kind of method, apparatus of document treatment, terminal device and storage medium | |
| CN111290813B (en) | Software interface field data standardization method, device, equipment and medium | |
| CN110795835A (en) | Three-dimensional process model reverse generation method based on automatic synchronous modeling | |
| CN103927402A (en) | Control logic diagram modular design management system implementation method | |
| CN111651968A (en) | Automatic EXCEL report generation method and system and information data processing terminal | |
| CN110032154B (en) | Production control method and system for small-batch products | |
| CN106408178A (en) | Multi-dimensional data snapshot-based product BOM management method and device | |
| WO2021228118A1 (en) | Central air conditioner intelligent design method, system and device | |
| CN113722564A (en) | Visualization method and device for energy and material supply chain based on space map convolution |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |