CN107291060A - Large-scale industry management information system and its control method based on oracle database - Google Patents
Large-scale industry management information system and its control method based on oracle database Download PDFInfo
- Publication number
- CN107291060A CN107291060A CN201610195280.5A CN201610195280A CN107291060A CN 107291060 A CN107291060 A CN 107291060A CN 201610195280 A CN201610195280 A CN 201610195280A CN 107291060 A CN107291060 A CN 107291060A
- Authority
- CN
- China
- Prior art keywords
- data
- industrial
- opc
- oracle
- control
- 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
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B23/00—Testing or monitoring of control systems or parts thereof
- G05B23/02—Electric testing or monitoring
- G05B23/0205—Electric testing or monitoring by means of a monitoring system capable of detecting and responding to faults
- G05B23/0218—Electric testing or monitoring by means of a monitoring system capable of detecting and responding to faults characterised by the fault detection method dealing with either existing or incipient faults
- G05B23/0224—Process history based detection method, e.g. whereby history implies the availability of large amounts of data
-
- G—PHYSICS
- G05—CONTROLLING; REGULATING
- G05B—CONTROL OR REGULATING SYSTEMS IN GENERAL; FUNCTIONAL ELEMENTS OF SUCH SYSTEMS; MONITORING OR TESTING ARRANGEMENTS FOR SUCH SYSTEMS OR ELEMENTS
- G05B2219/00—Program-control systems
- G05B2219/20—Pc systems
- G05B2219/24—Pc safety
- G05B2219/24048—Remote test, monitoring, diagnostic
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Automation & Control Theory (AREA)
- General Factory Administration (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of large-scale industry management information system and its control method based on oracle database, multi-platform data acquisition unit is used for the primary monitoring data for gathering the system of each in Industry Control, OPC Standard Interfaces are used to receive primary monitoring data, and it is converted into the industrial field data that database can be recognized, Oracle industrial specifications database is used to store data in the form of contingency table, and data are handled by industrial data Processing Algorithm.The present invention, which is provided, all concentrates industrial field data and status information of equipment, reduce the degree of scatter of data, eliminate information transfer barrier, offer information operating platform is made for industrial intelligence, the data storage amount of oracle database is big, concurrent operations are relatively more, real-time is good, the same integration of powerful data storage handling capability and data to analyse in depth industrial system and prediction becomes practical, improve process device efficiency, reduce maintenance cost, and meet the requirement of more high safety.
Description
Technical field
The present invention relates to a kind of large-scale industry management information system and its control method based on oracle database.
Background technology
The substantial amounts of industrial control information and industrial process information that traditional control system is produced for industrial process are all of short duration storage, analysis and the further subsystem for being all each special field is concentrated mainly in local control unit that excavates for historical information are realized.With the development of network technology and database technology, there are numerous application systems in a specific Industry Control, these application systems are usually scattered, independent, user is in order to obtain some statistics, generally require to enter different systems, both inconvenient, efficiency is also low.With the continuous progress of informationization technology, it is desirable to the system combination of independent, inequality originally is got up, realize the data sharing on logic level, the demand of deeper is more manufacturing industry factories transparence, the data acquisition for realizing data efficient, transmission, display, storage and applied, promote the digitlization and intellectuality of factory, enterprise production efficiency, reduces production cost, accelerates time to market (TTM).
The content of the invention
The present invention provides a kind of large-scale industry management information system and its control method based on oracle database, industrial field data and status information of equipment are all concentrated, reduce the degree of scatter of data, eliminate information transfer barrier, offer information operating platform is made for industrial intelligence, the data storage amount of oracle database is big, concurrent operations are relatively more, real-time is good, the same integration of powerful data storage handling capability and data to analyse in depth industrial system and prediction becomes practical, improve process device efficiency, reduce maintenance cost, and meet the requirement of more high safety.
In order to achieve the above object, the present invention provides a kind of large-scale industry management information system based on oracle database, comprising：Multi-platform data acquisition unit, and pass through the Oracle industrial specification databases of the multi-platform data acquisition unit of OPC Standard Interfaces connection；
Described multi-platform data acquisition unit is used for the primary monitoring data for gathering the system of each in Industry Control；
Described OPC Standard Interfaces are used to receive primary monitoring data, and are converted into the industrial field data that database can be recognized；
Described Oracle industrial specifications database is used to store data in the form of contingency table, and data are handled by industrial data Processing Algorithm.
Described multi-platform data acquisition unit is included：
One or more industrial configuration software OPC interfaces, it is electrically connected with control platforms different in industrial control system, for the data of different configuration software to be concentrated on into oracle database by OPC data Standard Interface, realize in the data set of different control platforms and export；
One or more intelligence instrument OPC interfaces, it is electrically connected with the intelligence instrument with OPC functions, for realizing the data exchange between intelligence instrument and oracle database with OPC functions；
One or more OPC normative translations units, it is electrically connected with the intelligence instrument without OPC functions, for the intelligence instrument without OPC functions to be converted into the intelligence instrument with OPC functions, the data exchange between intelligence instrument and oracle database without OPC functions is realized.
Described Oracle industrial specification databases are included：
Industrial configuration software ODBC interfaces, it is electrically connected with different control platforms, in real time the automatic industrial control information for collecting configuration software；
Historical diagnostic data storehouse, its classification for completing to industrial control system historical field data and history control information is stored, and is that System Performance Analysis and model prediction provide data, while providing the user data query function；
Real-time control data storehouse, it is carried out data transmission by ODBC agreements and historical diagnostic data storehouse, and data resource is provided for historical diagnostic data storehouse；
System Performance Analysis model prediction data storehouse, it is based on historical diagnostic data storehouse and real-time control data storehouse and obtains user's request information, configuration individual information, allocation models and set up intelligent maintenance decision optimization model, and by the unified allocation of resources to safeguarding resource, provide the intelligent maintenance plan of equipment；
Oracle database management system, it passes through ODBC consultative management real-time control datas storehouse, historical diagnostic data storehouse and System Performance Analysis model prediction data storehouse, the control information of various configuration softwares is transferred in database by ODBC agreements simultaneously, the real-time integration of industrial stokehold information is realized.
Equipment state is mounted with described historical diagnostic data storehouse to extract and fault type algorithm, is mounted with described real-time control data storehouse in real time control algorithms, described System Performance Analysis model prediction data storehouse and is mounted with diagnosis control model algorithm.
The present invention also provides a kind of large-scale industry information control method based on oracle database, comprises the steps of：
The primary monitoring data of each system in step S1, multi-platform data acquisition unit automatic data collection Industry Control；
Step S2, OPC Standard Interface receives primary monitoring data, and is converted into the industrial field data that oracle database can be recognized；
Step S3, Oracle industrial specification database stores data in the form of contingency table；
Step S4, Oracle industrial specification data base manipulation industrial data Processing Algorithm carries out intelligent state estimation and Fault Identification to data；
Step S5, application program access and called the data and result preserved in Oracle industrial specification databases.
In step S1, described multi-platform data acquisition unit has three kinds of data acquisition modes：Clocked flip data acquisition modes, event trigger data acquisition mode, and command triggers data acquisition modes.
Described step S1 is specifically included：
The data of industrial configuration software OPC interface automatic data collection different configuration software；
Intelligence instrument OPC interface automatic data collection has the data of the intelligence instrument of OPC functions；
OPC normative translations unit is converted to the industrial Fieldbus protocols of the intelligence instrument without OPC functions the OPC specification protocols for meeting Oracle offers, realizes the automatic data acquisition to the intelligence instrument without OPC functions.
The step of described OPC normative translations unit is converted to the industrial Fieldbus protocols of the intelligence instrument without OPC functions the OPC specification protocols for meeting Oracle offers specifically includes：Fundamental characteristics in data content and OPC specification protocols that industrial Fieldbus protocols are transmitted forms mapping relations one by one, realizes that industrial Fieldbus protocols are changed to OPC specification protocols；Described mapping relations are included：Meter address is corresponding with opc server, and control word is corresponding with OPC groups, and live real time data is corresponding with OPC.
In described step S3, the data in contingency table use the column data in unified industrial data cannonical format, contingency table to comprise at least：Data address, data acquisition time, data function, data value.
In step S4, the step of Oracle industrial specifications data base manipulation industrial data Processing Algorithm carries out intelligent state estimation and Fault Identification to data specifically comprises the steps of：
Step S4.1, oracle database management system extraction equipment state and the feature of fault type from the historical data base of marked equipment state or fault type；
Step S4.2, oracle database management system are returned and classification based training using support vector machine method to the feature of extraction, obtain diagnosis control model, diagnosis control model are stored in into System Performance Analysis model prediction data storehouse, for application call；
Step S4.3, oracle database management system carry out inputting diagnosis control model after feature extraction from real-time data base, data in real-time data base are compared with the data that diagnosis control model prediction is exported so that diagnosis control model output equipment state estimation or fault category.
The present invention all concentrates industrial field data and status information of equipment, reduce the degree of scatter of data, the confluence analysis of industrial information is set more to facilitate, both the data acquisition of equipment bottom can be realized, the horizontal information integration of equipment interoperability etc., it can also realize that the vertical information in equipment and high in the clouds is integrated, information transfer barrier can be eliminated, so as to form the data platform of a real full industrial control system, offer information operating platform is made for industrial intelligence, the data storage amount of oracle database is big, concurrent operations are relatively more, real-time is good, the same integration of powerful data storage handling capability and data to analyse in depth industrial system and prediction becomes practical, improve process device efficiency, reduce maintenance cost, and meet the requirement of more high safety.
Brief description of the drawings
Fig. 1 is a kind of block diagram for large-scale industry management information system based on oracle database that the present invention is provided.
Fig. 2 is a kind of flow chart for large-scale industry information control method based on oracle database that the present invention is provided.
Fig. 3 is the operation principle schematic diagram of OPC normative translation units.
Fig. 4 is the schematic diagram that Oracle industrial specifications database carries out data processing.
Embodiment
Below according to Fig. 1~Fig. 4, presently preferred embodiments of the present invention is illustrated.
As shown in figure 1, the present invention provides a kind of large-scale industry management information system based on oracle database, comprising：Multi-platform data acquisition unit 1, and pass through the Oracle industrial specifications database 3 of the multi-platform data acquisition unit 1 of OPC Standard Interfaces connection.Wherein, OPC refers to the OLE for process control（OLE for Process Control）, OLE refers to the link and insertion of object（Object Linking and Embedded）.
Described multi-platform data acquisition unit 1 is used for the primary monitoring data for gathering the system of each in Industry Control；Described OPC Standard Interfaces 2 are used to receive primary monitoring data, and are converted into the industrial field data that database can be recognized, are to realize the data channel communicated between multi-platform data acquisition unit 1 and Oracle industrial specifications database 3；Described Oracle industrial specifications database 3 is used to store data in the form of contingency table, and data are handled by industrial data Processing Algorithm, database is fed back to, and then reaches that the effect for being detected and being controlled to industrial system and the overall performance to industrial system make the analysis of depth.
Described multi-platform data acquisition unit 1 is included：
One or more industrial configuration software OPC interfaces 101, it is electrically connected with control platforms different in industrial control system, for the data of different configuration software to be concentrated on into oracle database by OPC data Standard Interface, realize in the data set of different control platforms and export；In the present embodiment, the OPC interface that the industrial configuration software OPC interface 101 is provided using each configuration software manufacturer；
One or more intelligence instrument OPC interfaces 102, it is electrically connected with the intelligence instrument with OPC functions, for realizing the data exchange between intelligence instrument and oracle database with OPC functions；
One or more OPC normative translations units 103, it is electrically connected with the intelligence instrument without OPC functions, for the intelligence instrument without OPC functions to be converted into the intelligence instrument with OPC functions, the data exchange between intelligence instrument and oracle database without OPC functions is realized；Described OPC normative translations unit 103 is by the industrial Fieldbus protocols of intelligence instrument, the industrial protocols such as such as modbus, profibus, heart are converted to the OPC specification protocols for meeting Oracle offers, the data content that the industrial Fieldbus protocols of general intelligence instrument are transmitted is made up of meter address, control word and live real time data three-decker, by respectively by meter address and opc server, control word and OPC groups, site physical data and OPC this three groups map one by one, so as to realize the function that industrial Fieldbus protocols are changed to OPC specification protocols.
In the present embodiment, the OPC interface that described OPC Standard Interfaces 2 are carried using Oracle industrial specifications database 3.
Described Oracle industrial specifications database 3 is included：
Industrial configuration software ODBC interfaces 305, it is electrically connected with different control platforms, as configuration software data transmission interface from control information to oracle database, third-party technical support is not needed, just some data at scene can be transferred to oracle database, realize automatic real-time collecting of the database to industrial control information；
Historical diagnostic data storehouse 303, equipment state is wherein mounted with to extract and fault type algorithm, it is that System Performance Analysis and model prediction provide data, while providing the user data query function to complete the storage of the classification to industrial control system historical field data and history control information；
Real-time control data storehouse 302, wherein it is mounted with real time control algorithms, to carry out data transmission by ODBC agreements and historical diagnostic data storehouse, largely abundant data resource is provided for historical diagnostic data storehouse, so as to be prepared for the depth excavation of further industrial information；
System Performance Analysis model prediction data storehouse 304, wherein it is mounted with diagnosis control model algorithm, corresponding intelligent maintenance decision optimization model is set up to obtain user's request information, configuration individual information, allocation models based on historical diagnostic data storehouse and real-time control data storehouse, and by the unified allocation of resources to safeguarding resource, provide the intelligent maintenance plan of equipment；
Oracle database management system 301, it passes through ODBC（Open Database Connectivity, i.e. Open Database Connection）Consultative management real-time control data storehouse, historical diagnostic data storehouse and System Performance Analysis model prediction data storehouse, while the control information of various configuration softwares is transferred in database by ODBC agreements, realize the real-time integration of industrial stokehold information.
Three databases in Oracle industrial specification databases, be in order to mitigate the data storage of single database and calculate pressure, data manipulation requirement of the data from history, different to data with prediction three phases in real time, the characteristics of more conforming to industrial control system are realized using three parallel database examples.
As shown in Fig. 2 the present invention also provides a kind of large-scale industry information control method based on oracle database, comprise the steps of：
The primary monitoring data of each system in step S1, multi-platform data acquisition unit automatic data collection Industry Control；
Step S2, OPC Standard Interface receives primary monitoring data, and is converted into the industrial field data that oracle database can be recognized；
Step S3, Oracle industrial specification database stores data in the form of contingency table；
Step S4, Oracle industrial specification data base manipulation industrial data Processing Algorithm carries out intelligent state estimation and Fault Identification to data；
Step S5, application program access and called the data and result preserved in Oracle industrial specification databases, wherein, described application program is located in industry spot terminal, or in same server of Oracle industrial specification databases.
In step S1, described multi-platform data acquisition unit has three kinds of data acquisition modes：Clocked flip data acquisition modes, event trigger data acquisition mode, and command triggers data acquisition modes.
Described step S1 is specifically included：
The data of industrial configuration software OPC interface automatic data collection different configuration software；
Intelligence instrument OPC interface automatic data collection has the data of the intelligence instrument of OPC functions；
OPC normative translations unit is converted to the industrial Fieldbus protocols of the intelligence instrument without OPC functions the OPC specification protocols for meeting Oracle offers, realizes the automatic data acquisition to the intelligence instrument without OPC functions.
As shown in figure 3, described OPC normative translations unit is specifically included the step of the industrial Fieldbus protocols of the intelligence instrument without OPC functions to be converted to the OPC specification protocols for meeting Oracle offers：The data content that industrial Fieldbus protocols are transmitted（Meter address, control word and live real time data）With the fundamental characteristics in OPC specification protocols（Opc server, OPC groups and OPC）Mapping relations one by one are formed, realize that industrial Fieldbus protocols are changed to OPC specification protocols；Described mapping relations are included：Meter address is corresponding with opc server, and control word is corresponding with OPC groups, and live real time data is corresponding with OPC.
In described step S3, the data in contingency table use the column data in unified industrial data cannonical format, contingency table to comprise at least：Data address, data acquisition time, data function, data value etc.；Described industrial data cannonical format should comply with Industry Control industry characteristic, and with universal adaptability；All industrial field data collection in same industrial control system are all described with same industry data standard form, each row data one industrial field data information of correspondence in contingency table；When application program is accessed and calls data, it is only necessary to data are handled according to the form of list data, it is not necessary to enter the conversion of row format to industrial data again.
In step S4, the step of Oracle industrial specifications data base manipulation industrial data Processing Algorithm carries out intelligent state estimation and Fault Identification to data specifically comprises the steps of：
Step S4.1, oracle database management system extraction equipment state and the feature of fault type from the historical data base of marked equipment state or fault type；
Step S4.2, oracle database management system are returned using support vector machine method to the feature of extraction（Corresponding device state estimation）And classification（Correspondence Fault Identification）Training, obtains diagnosis control model, diagnosis control model is stored in into System Performance Analysis model prediction data storehouse, for application call；
Step S4.3, oracle database management system carry out inputting diagnosis control model after feature extraction from real-time data base, data in real-time data base are compared with the data that diagnosis control model prediction is exported so that diagnosis control model output equipment state estimation or fault category.
As shown in figure 4, described intelligent state estimation and fault recognition method are that feature extraction is carried out from the historical data base of marked equipment state or fault type by training process, returned after feature extraction using support vector machine method（Corresponding device state estimation）And classification（Correspondence Fault Identification）Training, obtain diagnosis control model, by the diagnosis control model deposit System Performance Analysis model prediction data storehouse of acquisition, for application call, prediction process carries out inputting diagnosis control model after feature extraction from real-time data base, data in real-time data base are compared with the data that diagnosis control model prediction is exported so that diagnosis control model output equipment state estimation or fault category.
Used diagnosis control model parameter in described real-time data base, historical data base and System Performance Analysis model prediction data storehouse, it is that dynamic adjustment in real time is carried out by the actual motion state of above three data, the real-time update of diagnosis control model can be accomplished.
In described step S5, when application program accesses Oracle industrial specification databases, pass through
PL/SQL（Procedural Language program languages/Structured Query Language SQLs）Query statement or storing process accessing database data, so as to realize transparent access of the application service to data storage in Oracle.
The present invention has advantages below：
1st, all concentrated by industrial field data and status information of equipment, information transfer barrier can be eliminated, be that industrial intelligence makes offer information operating platform so as to form the data platform of a real full industrial control system；
2nd, the cross-platform large-scale industry information integration control system based on oracle database monitors for industrial control system and intelligent maintenance provides information platform, the Data Integration provided by information platform is analyzed, process device efficiency, reduction maintenance cost can be improved, and meets the requirement of more high safety.
Although present disclosure is discussed in detail by above preferred embodiment, but it should be appreciated that the description above is not considered as limitation of the present invention.After those skilled in the art have read the above, a variety of modifications and substitutions for the present invention all will be apparent.Therefore, protection scope of the present invention should be limited to the appended claims.
Claims (10)
1. a kind of large-scale industry management information system based on oracle database, it is characterised in that include：Multi-platform data acquisition unit, and pass through the Oracle industrial specification databases of the multi-platform data acquisition unit of OPC Standard Interfaces connection；
Described multi-platform data acquisition unit is used for the primary monitoring data for gathering the system of each in Industry Control；
Described OPC Standard Interfaces are used to receive primary monitoring data, and are converted into the industrial field data that database can be recognized；
Described Oracle industrial specifications database is used to store data in the form of contingency table, and data are handled by industrial data Processing Algorithm.
2. the large-scale industry management information system as claimed in claim 1 based on oracle database, it is characterised in that described multi-platform data acquisition unit is included：
One or more industrial configuration software OPC interfaces, it is electrically connected with control platforms different in industrial control system, for the data of different configuration software to be concentrated on into oracle database by OPC data Standard Interface, realize in the data set of different control platforms and export；
One or more intelligence instrument OPC interfaces, it is electrically connected with the intelligence instrument with OPC functions, for realizing the data exchange between intelligence instrument and oracle database with OPC functions；
One or more OPC normative translations units, it is electrically connected with the intelligence instrument without OPC functions, for the intelligence instrument without OPC functions to be converted into the intelligence instrument with OPC functions, the data exchange between intelligence instrument and oracle database without OPC functions is realized.
3. the large-scale industry management information system as claimed in claim 1 based on oracle database, it is characterised in that described Oracle industrial specification databases are included：
Industrial configuration software ODBC interfaces, it is electrically connected with different control platforms, in real time the automatic industrial control information for collecting configuration software；
Historical diagnostic data storehouse, its classification for completing to industrial control system historical field data and history control information is stored, and is that System Performance Analysis and model prediction provide data, while providing the user data query function；
Real-time control data storehouse, it is carried out data transmission by ODBC agreements and historical diagnostic data storehouse, and data resource is provided for historical diagnostic data storehouse；
System Performance Analysis model prediction data storehouse, it is based on historical diagnostic data storehouse and real-time control data storehouse and obtains user's request information, configuration individual information, allocation models and set up intelligent maintenance decision optimization model, and by the unified allocation of resources to safeguarding resource, provide the intelligent maintenance plan of equipment；
Oracle database management system, it passes through ODBC consultative management real-time control datas storehouse, historical diagnostic data storehouse and System Performance Analysis model prediction data storehouse, the control information of various configuration softwares is transferred in database by ODBC agreements simultaneously, the real-time integration of industrial stokehold information is realized.
4. the large-scale industry management information system as claimed in claim 3 based on oracle database, it is characterized in that, equipment state is mounted with described historical diagnostic data storehouse to extract and fault type algorithm, it is mounted with described real-time control data storehouse in real time control algorithms, described System Performance Analysis model prediction data storehouse and is mounted with diagnosis control model algorithm.
5. the control method of the large-scale industry management information system based on oracle database in a kind of 1-4 such as claim as described in any one, it is characterised in that comprise the steps of：
The primary monitoring data of each system in step S1, multi-platform data acquisition unit automatic data collection Industry Control；
Step S2, OPC Standard Interface receives primary monitoring data, and is converted into the industrial field data that oracle database can be recognized；
Step S3, Oracle industrial specification database stores data in the form of contingency table；
Step S4, Oracle industrial specification data base manipulation industrial data Processing Algorithm carries out intelligent state estimation and Fault Identification to data；
Step S5, application program access and called the data and result preserved in Oracle industrial specification databases.
6. a kind of large-scale industry information control method based on oracle database as claimed in claim 5, it is characterised in that in step S1, described multi-platform data acquisition unit has three kinds of data acquisition modes：Clocked flip data acquisition modes, event trigger data acquisition mode, and command triggers data acquisition modes.
7. a kind of large-scale industry information control method based on oracle database as claimed in claim 6, it is characterised in that described step S1 is specifically included：
The data of industrial configuration software OPC interface automatic data collection different configuration software；
Intelligence instrument OPC interface automatic data collection has the data of the intelligence instrument of OPC functions；
OPC normative translations unit is converted to the industrial Fieldbus protocols of the intelligence instrument without OPC functions the OPC specification protocols for meeting Oracle offers, realizes the automatic data acquisition to the intelligence instrument without OPC functions.
8. a kind of large-scale industry information control method based on oracle database as claimed in claim 7, characterized in that, described OPC normative translations unit is specifically included the step of the industrial Fieldbus protocols of the intelligence instrument without OPC functions to be converted to the OPC specification protocols for meeting Oracle offers：Fundamental characteristics in data content and OPC specification protocols that industrial Fieldbus protocols are transmitted forms mapping relations one by one, realizes that industrial Fieldbus protocols are changed to OPC specification protocols；Described mapping relations are included：Meter address is corresponding with opc server, and control word is corresponding with OPC groups, and live real time data is corresponding with OPC.
9. a kind of large-scale industry information control method based on oracle database as claimed in claim 5, it is characterised in that in described step S3, the data in contingency table use the column data in unified industrial data cannonical format, contingency table to comprise at least：Data address, data acquisition time, data function, data value.
10. a kind of large-scale industry information control method based on oracle database as claimed in claim 5, it is characterized in that, in step S4, the step of Oracle industrial specifications data base manipulation industrial data Processing Algorithm carries out intelligent state estimation and Fault Identification to data specifically comprises the steps of：
Step S4.1, oracle database management system extraction equipment state and the feature of fault type from the historical data base of marked equipment state or fault type；
Step S4.2, oracle database management system are returned and classification based training using support vector machine method to the feature of extraction, obtain diagnosis control model, diagnosis control model are stored in into System Performance Analysis model prediction data storehouse, for application call；
Step S4.3, oracle database management system carry out inputting diagnosis control model after feature extraction from real-time data base, data in real-time data base are compared with the data that diagnosis control model prediction is exported so that diagnosis control model output equipment state estimation or fault category.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610195280.5A CN107291060B (en) | 2016-03-31 | 2016-03-31 | Large-scale industry management information system and its control method based on oracle database |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610195280.5A CN107291060B (en) | 2016-03-31 | 2016-03-31 | Large-scale industry management information system and its control method based on oracle database |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107291060A true CN107291060A (en) | 2017-10-24 |
| CN107291060B CN107291060B (en) | 2019-08-02 |
Family
ID=60086912
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610195280.5A Expired - Fee Related CN107291060B (en) | 2016-03-31 | 2016-03-31 | Large-scale industry management information system and its control method based on oracle database |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107291060B (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107909300A (en) * | 2017-12-12 | 2018-04-13 | 北京可视化智能科技股份有限公司 | Intelligent plant management platform and method |
| CN108600181A (en) * | 2018-03-28 | 2018-09-28 | 南京智格电力科技有限公司 | A kind of parsing configuration method for supporting polymorphic type communication protocol |
| CN109709811A (en) * | 2018-12-20 | 2019-05-03 | 中国科学院沈阳自动化研究所 | A kind of edge calculations controller and its working method towards intelligence manufacture |
| CN109799798A (en) * | 2019-01-23 | 2019-05-24 | 上海智共荟智能科技有限公司 | One kind being applied to industrial processing equipment large data sets into acquisition system and method |
| CN110266677A (en) * | 2019-06-13 | 2019-09-20 | 广州中国科学院沈阳自动化研究所分所 | A kind of edge calculations intelligent gateway and implementation method towards industry manufacture |
| CN110853351A (en) * | 2019-11-12 | 2020-02-28 | 华侨大学 | Monitoring system in intelligent road environment |
| WO2020177441A1 (en) * | 2019-03-04 | 2020-09-10 | 北京工业大学 | Unidirectional isolated data acquisition and offline algorithm verification system |
| CN111665761A (en) * | 2020-06-23 | 2020-09-15 | 上海一旻成锋电子科技有限公司 | Industrial control system and control method |
| CN113806190A (en) * | 2020-06-17 | 2021-12-17 | 华为技术有限公司 | Method, device and system for predicting performance of database management system |
| CN114614946A (en) * | 2022-01-26 | 2022-06-10 | 桂林电子科技大学 | Electronic intelligent industry building operation and maintenance cloud platform system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1801131A (en) * | 2005-11-11 | 2006-07-12 | 南京科远控制工程有限公司 | Setup method for real-time database system of thermal power plant |
| CN104504094A (en) * | 2014-12-26 | 2015-04-08 | 中国石油集团工程设计有限责任公司北京分公司 | Various data source integrated management method for oil and gas field |
| CN105278373A (en) * | 2015-10-16 | 2016-01-27 | 中国南方电网有限责任公司电网技术研究中心 | Substation integrated information processing system realizing method |
| CN105320085A (en) * | 2014-06-25 | 2016-02-10 | 中兴通讯股份有限公司 | Method, apparatus and system for acquiring industrial automation data |
| CN105389131A (en) * | 2015-11-23 | 2016-03-09 | 江苏瑞中数据股份有限公司 | Data acquisition method for process industry production system |
-
2016
- 2016-03-31 CN CN201610195280.5A patent/CN107291060B/en not_active Expired - Fee Related
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1801131A (en) * | 2005-11-11 | 2006-07-12 | 南京科远控制工程有限公司 | Setup method for real-time database system of thermal power plant |
| CN105320085A (en) * | 2014-06-25 | 2016-02-10 | 中兴通讯股份有限公司 | Method, apparatus and system for acquiring industrial automation data |
| CN104504094A (en) * | 2014-12-26 | 2015-04-08 | 中国石油集团工程设计有限责任公司北京分公司 | Various data source integrated management method for oil and gas field |
| CN105278373A (en) * | 2015-10-16 | 2016-01-27 | 中国南方电网有限责任公司电网技术研究中心 | Substation integrated information processing system realizing method |
| CN105389131A (en) * | 2015-11-23 | 2016-03-09 | 江苏瑞中数据股份有限公司 | Data acquisition method for process industry production system |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107909300A (en) * | 2017-12-12 | 2018-04-13 | 北京可视化智能科技股份有限公司 | Intelligent plant management platform and method |
| CN108600181A (en) * | 2018-03-28 | 2018-09-28 | 南京智格电力科技有限公司 | A kind of parsing configuration method for supporting polymorphic type communication protocol |
| CN109709811A (en) * | 2018-12-20 | 2019-05-03 | 中国科学院沈阳自动化研究所 | A kind of edge calculations controller and its working method towards intelligence manufacture |
| CN109799798A (en) * | 2019-01-23 | 2019-05-24 | 上海智共荟智能科技有限公司 | One kind being applied to industrial processing equipment large data sets into acquisition system and method |
| WO2020177441A1 (en) * | 2019-03-04 | 2020-09-10 | 北京工业大学 | Unidirectional isolated data acquisition and offline algorithm verification system |
| CN110266677A (en) * | 2019-06-13 | 2019-09-20 | 广州中国科学院沈阳自动化研究所分所 | A kind of edge calculations intelligent gateway and implementation method towards industry manufacture |
| CN110853351A (en) * | 2019-11-12 | 2020-02-28 | 华侨大学 | Monitoring system in intelligent road environment |
| CN113806190A (en) * | 2020-06-17 | 2021-12-17 | 华为技术有限公司 | Method, device and system for predicting performance of database management system |
| CN111665761A (en) * | 2020-06-23 | 2020-09-15 | 上海一旻成锋电子科技有限公司 | Industrial control system and control method |
| CN114614946A (en) * | 2022-01-26 | 2022-06-10 | 桂林电子科技大学 | Electronic intelligent industry building operation and maintenance cloud platform system |
| CN114614946B (en) * | 2022-01-26 | 2023-09-01 | 桂林电子科技大学 | Electronic intelligent manufacturing operation and maintenance cloud platform system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107291060B (en) | 2019-08-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107291060A (en) | Large-scale industry management information system and its control method based on oracle database | |
| CN109709811B (en) | Intelligent manufacturing-oriented edge calculation controller and working method thereof | |
| US8365195B2 (en) | Systems and methods for generating sets of model objects having data messaging pipes | |
| CN110266677A (en) | A kind of edge calculations intelligent gateway and implementation method towards industry manufacture | |
| CN112131636A (en) | Device and method for accurately mapping building information model and Internet of things monitoring item | |
| CN100347930C (en) | System and equipment for collecting and monitoring data of electric power | |
| CN108718345A (en) | A kind of digitlization workshop industrial data Network Transmitting system | |
| CN107730394A (en) | The polynary isomeric data fusion method of panorama power network based on big data | |
| CN206249316U (en) | A kind of Data Centre in Hospital plateform system based on high in the clouds | |
| CN110866320A (en) | Intelligent platform area graph automatic generation method and system | |
| CN103439629A (en) | Power distribution network fault diagnosis system based on data grid | |
| CN112182077B (en) | Intelligent operation and maintenance system based on data middling platform technology | |
| CN105681285B (en) | A kind of isomery industry signal source information acquisition methods | |
| CN110308966B (en) | Static security analysis method based on container technology | |
| CN110191138A (en) | A kind of edge calculations intelligent adapter and implementation method towards industry manufacture | |
| CN109150854A (en) | Dynamic and configurable communication protocol converting system based on XML file | |
| CN105335900A (en) | Integrated data processing method based on power equipment state monitoring system | |
| CN102739788B (en) | A kind of field device communicating method based on EIB agreement | |
| CN111711677A (en) | Virtual and real loop visualization method, system and medium for process layer switch of intelligent substation | |
| CN1684430A (en) | Configurating data collecting system and its method in network management | |
| CN111159152A (en) | Secondary operation and maintenance data fusion method based on big data processing technology | |
| CN106713019A (en) | Design method of service operation support system applied to Internet of Things self-management platform | |
| CN111077851A (en) | Chemical process fault diagnosis system based on gas chromatography fog calculation framework | |
| CN112866364A (en) | Industrial internet cloud platform | |
| CN108880870B (en) | Cloud flattened access and control method of plug-and-play internet of things equipment |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| 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: 20190802 |