CN107193245A - The method that coal production industry net information is merged with office internet information - Google Patents
The method that coal production industry net information is merged with office internet information Download PDFInfo
- Publication number
- CN107193245A CN107193245A CN201710252207.1A CN201710252207A CN107193245A CN 107193245 A CN107193245 A CN 107193245A CN 201710252207 A CN201710252207 A CN 201710252207A CN 107193245 A CN107193245 A CN 107193245A
- Authority
- CN
- China
- Prior art keywords
- data
- management
- module
- function
- information
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
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
- G05B19/00—Programme-control systems
- G05B19/02—Programme-control systems electric
- G05B19/04—Programme control other than numerical control, i.e. in sequence controllers or logic controllers
- G05B19/048—Monitoring; Safety
Landscapes
- Physics & Mathematics (AREA)
- General Physics & Mathematics (AREA)
- Engineering & Computer Science (AREA)
- Automation & Control Theory (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses the method that a kind of industrial net information of coal production is merged with office internet information, it initially sets up a data interchange platform, the interaction for the business administration database of each office internet information system；A data service calling module is resettled, the industrial control data of the Integrated Automation System of Coal-mine for extracting industry net end finally sets up a data integration platform containing various functions module.The present invention is applied to the line coal production unit with certain basis for IT application level, data integration can be carried out in terms of the production automation and enterprise information management, the data that daily conference on production needs all are extracted by data warehouse, the various information high unities of underground, relatively before data report collect layer by layer, make data more accurate, quickly, the overall lower management level of coal industry is greatly improved, potential safety hazard is substantially reduced, so as to improve the performance of enterprises.
Description
Technical field
The present invention relates to industrial management computer database technology.
Background technology
At present, some coal coal enterprise with certain basis for IT application level, generally establish colliery comprehensive automation
Change system, realizes the production automation, and establishes in terms of business administration office internet information system (i.e. management information
Change system and business administration database), realize IT application in management.Because Integrated Automation System of Coal-mine is in industrial looped network
Build, both can not interconnect, management information is unable to high unity with downhole production data on well, and daily conference on production is needed
The data wanted, which need to report layer by layer, to collect, and accuracy rate is low, and speed is slow, so there is potential safety hazard, makes coal industry overall modern
Changing managerial skills can not play well, influence the performance of enterprises.
Therefore, it is sought after setting up the passage of industrial looped network information and ' Office LAN information interconnection and intercommunication, such as by anti-
Wall with flues maps or other modes carry out interconnection mapping, realizes the logical of industrial automation services device and IT application in management server
News.Coal enterprise can be related to by production, safety, the informationization managed by coal enterprise's exclusive data REPOSITORY TECHNOLOGY
Data, by unified interface standard, different interfacings realizes Data Integration storage, solves the production of traditional data warehouse
Separated with operation, the problem of internet is separated with EPA.Because most of Integrated Automation System of Coal-mine supports OPC to connect
Mouth agreement, configuration software, such as：WINCC, IFIX, KingView, Forcecontrol etc., all support OPC interface agreement.Therefore,
It can realize that industrial control data is inserted into relevant database in real time, such as by kepserver software merit rating OPC passages：
Oracle database, sqlserver databases.
The content of the invention
The invention aims to solve the problems, such as merging for the industrial looped network information of coal enterprise and ' Office LAN information,
Set up it is a set of integrate information gathering, monitoring, storage system, the data channel of industrial net and Office Network is got through, according to industry
Business standard carries out data fusion, the method for forming data warehouse.
To achieve the above object, the present invention is adopted the technical scheme that：
The method that a kind of industrial net information of coal production is merged with office internet information, it is characterised in that it includes：
First, set up a data interchange platform, the business administration database for each office internet information system
Interaction；Data interchange platform includes：
A, switching bus：Switching bus is messaging bus, mainly undertake offer message,
The management of queue and scheduling feature；Major function has：Queue management device, message are accessed, message is forwarded, bursting tube
Reason, dial-up connection, log management, management and monitoring；
B, switching centre/switching node：The various services that switching centre/node is provided by switching bus, completion message
Transmission；
The data exchange of data interchange platform, is to pass through connecting node, adapter service component and number by switching bus
According to transition components, the data traffic flows of end-to-end (P2P) are formed；
Second, a data service calling module is set up, for extracting the industrial Integrated Automation System of Coal-mine for netting end
Industrial control data, such as safety detection information data, draining information data；Service calling module is by industry control variable, cycle, ODBC numbers
Database table configuration is carried out according to source, relevant database information, after the completion of configuration, operation kepserver services, by relevant data
Extract in real time into relational database, then data exchange is carried out by professional tool and data warehouse, realize data integration；It is above-mentioned
Relevant database is for example：Oracle database, sqlserver databases；
3rd, set up a data integration platform containing various functions module；Data integration platform passes through
Webseviecs modes or MQ modes, push the number of the business administration database for the IT application in management system for receiving internet end
According to, and it is integrated；Data integration platform is by data, services calling module, and the colliery that industry net end is extracted in real time is integrated automated
The industrial control data of system, such as industrial automation data, safety monitoring data, drainage system data etc. are simultaneously integrated；Data integration is put down
Platform is stored integrated industrial control data according to unified standard, and service is provided for follow-up data processing displaying；Described number
Include according to the functional module of integrated platform：
A, object class definition module：Mainly realize to business object Classification Management function,
Including：Newly-increased, editor, deletion, query function；
B, business object definition module：The main defined function realized to business object, including：Increase newly, edit, deleting,
Query function；
C, data source management module：The main configuration management function realized to various different data sources, including：Newly-increased, volume
Volume, delete, query function；
D, service registry management module：The main registration management function of realizing to business object service, including：Newly-increased, volume
Volume, delete, query function；
E, task registration management module：The main unified configuration management function realized to background task, including：Newly-increased, volume
Volume, delete, query function；
F, Portable Batch System module：Uniform registration, the configuration management function to background task are mainly realized, including：Appoint
The newly-increased of business configuration, editor, delete, inquiry, the function such as start, stop；
G, data management function module：Realize and state is handled to the business datum in data collecting system and data receiver
Browse, query function；Browsable data content includes：Unit data, division data, demographic data, goods and materials business datum；
H, access monitoring log pattern：Realize external system, login user access system journal browse and daily record is whole
Manage function；
L, data monitoring log pattern：The exchange situation of statistical analysis miscellaneous service data exchange, including：Business datum is handed over
The statistics such as quantity, exchange successful mortality for changing；
J, background task monitoring module：Realize the monitoring to background task running status situation.
The positive effect of the present invention：
1st, the data interchange platform set up of the present invention, due to can flexible Connection Service component input/output terminal, thus
The exchange logic for meeting different demands can flexibly be constituted.(need to carry out data friendship in each data exchange node by configuring
Each node changed) Exchange Service, each data exchange node is only needed to the interface with data interchange platform by standard
Interact, and data conversion is carried out by XML, can just be got without being connected directly to one another to access between application system
Required data.
2nd, kepserver softwares are run, the industry control variable extracted, decimation periods, odbc data source, relational data is configured
Storehouse information, configuration of database table etc..After configuration is completed, taking out in real time for industrial control data is realized in operation kepserver services
Take.After industrial automation data is extracted into relational database, data exchange can be carried out by professional tool and data warehouse,
Realize data integration.
3rd, the present invention directly combines the information data of production line and business administration together, is excavated by depth, derivative
Go out the new productive function of coal enterprise, the information-based base provided to fine-grained management is managed from extensive style for coal industry
Plinth is ensured.In the data storage end, model customization during Database is carried out, that is, meets the OLTP features of transaction application again
The OLAP features of data warehouse are merged.
4th, the present invention is applied to the line coal production unit with certain basis for IT application level, in the production automation and
Data integration can be carried out in terms of enterprise information management, the data that daily conference on production needs all are carried by data warehouse
Take, the various information high unities of underground, relatively before data report collect layer by layer, make data more accurate, quickly, greatly
It is big to improve the overall lower management level of coal industry, potential safety hazard is substantially reduced, so as to improve the performance of enterprises.
Brief description of the drawings
Fig. 1 is the structural representation of the embodiment of the present invention.
Embodiment
Those skilled in the art are sufficient for implementing according to content of the invention combination Fig. 1 structure chart.Below again embodiment
In several functional modules of data integration platform described in the 3rd step be described in detail：
A, object class definition module：Mainly realize to business object Classification Management function,
Including：Newly-increased, editor, deletion, query function；Main business object and attribute is as follows：
Attribute definition：Sequence number, numbering, title, class indication, sort field, remarks.
Service logic：Numbering, title, class indication can not be sky；Numbering, title, class indication can not be repeated.
Sample data：
001 basic coding data BASIC 1,
002 human resource data HR 2,
003 automation drainage system data M 3.
B, business object definition module：The main defined function realized to business object, including：Increase newly, edit, deleting,
Query function；Main business object and attribute is as follows：
Business object is defined：Sequence number, object classifying and numbering, business object numbering, business object title, business object mark
Knowledge, sort field, remarks；
Object physical table is defined：Sequence number, business object sequence number, table name, table description, sort field, remarks；
Object physics literary name section is defined：Sequence number, table sequence number, field name, field description, field type, whether be empty, be
No repetition, sort field, remarks.
C, data source management module：The main configuration management function realized to various different data sources, including：Newly-increased, volume
Volume, delete, query function；Main business object and attribute definition are as follows：
Data source object is defined：Sequence number, data source numbering, DSN, data source types, user name, password, end
Mouth, IP address, instance name etc..
D, service registry management module：The main registration management function of realizing to business object service, including：Newly-increased, volume
Volume, delete, query function；Main business object and attribute definition is as follows：
Operational Visit service definition：Sequence number, business object sequence number, address of service, method of servicing, method parameter, service are retouched
State.
E, task registration management module：The main unified configuration management function realized to background task, including：Newly-increased, volume
Volume, delete, query function；Function point includes：Newly-increased, editor, deletion, query function.Main business object and attribute definition
It is as follows：
Service attribute includes：Sequence number, mission number, task names, classification of task, task description, execution frequency, task class
Type, execution task class, execution multitask method etc..
F, Portable Batch System module：Uniform registration, the configuration management function to background task are mainly realized, including：Appoint
The newly-increased of business configuration, editor, delete, inquiry, the function such as start, stop；Main business object and attribute definition are as follows：
Service attribute includes：Sequence number, mission number, task names, classification of task, task description, execution frequency, task class
Type, execution task class, execution multitask method etc..
G, data management function module：Realize and state is handled to the business datum in data collecting system and data receiver
Browse, query function；Browsable data content includes：Unit data, division data, demographic data, goods and materials business datum；
Browsable data content includes：Unit data, division data, demographic data, goods and materials business datum etc..
H, access monitoring log pattern：Realize external system, login user access system journal browse and daily record is whole
Manage function.
L, data monitoring log pattern：The exchange situation of statistical analysis miscellaneous service data exchange, including：Business datum is handed over
The statistics such as quantity, exchange successful mortality for changing.
J, background task monitoring module：Realize the monitoring to background task running status situation.
Claims (2)
1. the method that a kind of industrial net information of coal production is merged with office internet information, it is characterised in that it includes：
First, a data interchange platform is set up, the interaction for the business administration database of each office internet information system；
Data interchange platform includes：
A, switching bus：Switching bus is messaging bus, mainly undertakes offer message, the management of queue queue and scheduling feature；
Major function has：Queue management device, message access, message forwarding, safety management, dial-up connection, log management, management and prison
Control；
B, switching centre/switching node：The various services that switching centre/node is provided by switching bus, the biography of completion message
It is defeated；
The data exchange of data interchange platform, is to be turned by switching bus by connecting node, adapter service component and data
Component is changed, the data traffic flows of end-to-end (P2P) are formed；
Second, a data service calling module is set up, the industry control of the Integrated Automation System of Coal-mine for extracting industry net end
Industry control variable, cycle, odbc data source, relevant database information are carried out database table configuration by data, service calling module,
After the completion of configuration, operation kepserver services are extracted relevant data into relational database, then pass through professional tool in real time
Data exchange is carried out with data warehouse, data integration is realized；
3rd, set up a data integration platform containing various functions module；Data integration platform passes through webseviecs side
Formula or MQ modes, push the data of the business administration database for the IT application in management system for receiving internet end, and integrated；Number
According to integrated platform by data, services calling module, the industry control number of the Integrated Automation System of Coal-mine at industry net end is extracted in real time
According to；Data integration platform is stored integrated industrial control data according to unified standard, is provided for follow-up data processing displaying
Service；The functional module of described data integration platform includes：
A, object class definition module：Mainly realize to business object Classification Management function, including：Increase newly, edit, delete, look into
Ask function；
B, business object definition module：The main defined function realized to business object, including：Newly-increased, editor, deletion, inquiry
Function；
C, data source management module：The main configuration management function realized to various different data sources, including：Increase newly, edit, delete
Remove, query function；
D, service registry management module：The main registration management function of realizing to business object service, including：Increase newly, edit, delete
Remove, query function；
E, task registration management module：The main unified configuration management function realized to background task, including：Increase newly, edit, delete
Remove, query function；
F, Portable Batch System module：Uniform registration, the configuration management function to background task are mainly realized, including：Task is matched somebody with somebody
The newly-increased, editor that puts, delete, inquiry, start, stop function；
G, data management function module：Realize and the clear of state is handled to the business datum in data collecting system and data receiver
Look at, query function；Browsable data content includes：Unit data, division data, demographic data, goods and materials business datum；
H, access monitoring log pattern：Realize that external system, login user access browsing and daily record arrangement work(for system journal
Energy；
L, data monitoring log pattern：The exchange situation of statistical analysis miscellaneous service data exchange, including：What business datum was exchanged
Quantity, exchange successful mortality statistics；
J, background task monitoring module：Realize the monitoring to background task running status situation.
2. the method that the industrial net information of coal production as claimed in claim 1 is merged with office internet information, its feature exists
In described relevant database includes oracle database and sqlserver databases.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710252207.1A CN107193245A (en) | 2017-04-18 | 2017-04-18 | The method that coal production industry net information is merged with office internet information |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710252207.1A CN107193245A (en) | 2017-04-18 | 2017-04-18 | The method that coal production industry net information is merged with office internet information |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107193245A true CN107193245A (en) | 2017-09-22 |
Family
ID=59872039
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710252207.1A Pending CN107193245A (en) | 2017-04-18 | 2017-04-18 | The method that coal production industry net information is merged with office internet information |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107193245A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109922124A (en) * | 2018-12-29 | 2019-06-21 | 淄博矿业集团有限责任公司 | A kind of coal mine data management system based on Hadoop |
| CN111106952A (en) * | 2019-12-14 | 2020-05-05 | 河南思凯蓝通信科技有限公司 | Big data exchange platform network architecture |
| CN112769903A (en) * | 2020-12-24 | 2021-05-07 | 青岛奥利普自动化控制系统有限公司 | Real-time pushing method and device for equipment data acquisition information and storage medium |
| CN114745226A (en) * | 2022-03-31 | 2022-07-12 | 和中通信科技有限公司 | Switching center-based cross-domain secure switching method between enterprises |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101126927A (en) * | 2007-08-29 | 2008-02-20 | 上海交大慧谷自动化科技有限公司 | Coal mine production scheduling system |
| CN100581174C (en) * | 2007-11-28 | 2010-01-13 | 浪潮集团山东通用软件有限公司 | Method for constructing multi-type database secure data exchange platform |
| CN102981465A (en) * | 2012-11-08 | 2013-03-20 | 合肥工大高科信息科技股份有限公司 | Integration processing system and processing method of mine monitoring system data based on internet of things structure |
| CN105626149A (en) * | 2014-11-07 | 2016-06-01 | 沈阳市东陵区真宬商务信息咨询事务所 | Coal mine safety monitoring system based on Internet of Things |
| CN105843880A (en) * | 2016-03-21 | 2016-08-10 | 中国矿业大学 | Coal mine multi-dimensional data warehousing system based on multiple data marts |
-
2017
- 2017-04-18 CN CN201710252207.1A patent/CN107193245A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101126927A (en) * | 2007-08-29 | 2008-02-20 | 上海交大慧谷自动化科技有限公司 | Coal mine production scheduling system |
| CN100581174C (en) * | 2007-11-28 | 2010-01-13 | 浪潮集团山东通用软件有限公司 | Method for constructing multi-type database secure data exchange platform |
| CN102981465A (en) * | 2012-11-08 | 2013-03-20 | 合肥工大高科信息科技股份有限公司 | Integration processing system and processing method of mine monitoring system data based on internet of things structure |
| CN105626149A (en) * | 2014-11-07 | 2016-06-01 | 沈阳市东陵区真宬商务信息咨询事务所 | Coal mine safety monitoring system based on Internet of Things |
| CN105843880A (en) * | 2016-03-21 | 2016-08-10 | 中国矿业大学 | Coal mine multi-dimensional data warehousing system based on multiple data marts |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109922124A (en) * | 2018-12-29 | 2019-06-21 | 淄博矿业集团有限责任公司 | A kind of coal mine data management system based on Hadoop |
| CN111106952A (en) * | 2019-12-14 | 2020-05-05 | 河南思凯蓝通信科技有限公司 | Big data exchange platform network architecture |
| CN112769903A (en) * | 2020-12-24 | 2021-05-07 | 青岛奥利普自动化控制系统有限公司 | Real-time pushing method and device for equipment data acquisition information and storage medium |
| CN114745226A (en) * | 2022-03-31 | 2022-07-12 | 和中通信科技有限公司 | Switching center-based cross-domain secure switching method between enterprises |
| CN114745226B (en) * | 2022-03-31 | 2023-09-05 | 和中通信科技有限公司 | Inter-enterprise cross-domain security switching method based on switching center |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11308163B1 (en) | Monitoring system control interface for asset tree determination | |
| CN106096056B (en) | One kind being based on distributed public sentiment data real-time collecting method and system | |
| CN111435344B (en) | Big data-based drilling acceleration influence factor analysis model | |
| CN107315776B (en) | Data management system based on cloud computing | |
| CN107193245A (en) | The method that coal production industry net information is merged with office internet information | |
| CN112688865B (en) | Design method of OPC UA gateway for graphical online modeling | |
| CN1984170B (en) | Method for processing network alerting information | |
| CN108595449A (en) | The structure and application process of dispatch automated system knowledge mapping | |
| CN111241078A (en) | Data analysis system, data analysis method and device | |
| CN112347071B (en) | Power distribution network cloud platform data fusion method and power distribution network cloud platform | |
| CN101146152A (en) | Information collection and search system for telecommunication information station | |
| CN102902813A (en) | Log collection system | |
| CN112182077B (en) | Intelligent operation and maintenance system based on data middling platform technology | |
| CN112416923A (en) | Metadata management method and device, equipment and storage medium | |
| CN110968629A (en) | Cross-hierarchy heterogeneous data aggregation-based unified information resource management method and system | |
| CN108052358B (en) | Distributed deployment system and method | |
| CN107169069A (en) | Distributed hierarchical extracts many application processes and data pick-up applicator | |
| CN105183916A (en) | Device and method for managing unstructured data | |
| CN110706125A (en) | Water conservancy big data analysis information service system and platform service system | |
| CN111858722A (en) | Big data application system and method based on Internet of things | |
| CN102722368A (en) | Plug-in software designing method based on document tree and message pump | |
| CN112328667B (en) | Shale gas field ground engineering digital handover method based on data blood margin | |
| CN101968747B (en) | Cluster application management system and application management method thereof | |
| CN110209578A (en) | A kind of information on-line testing platform | |
| CN108075922A (en) | A kind of telecommunication network management system |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20170922 |
|
| WD01 | Invention patent application deemed withdrawn after publication |