CN107528836A - A kind of method that BACnet agreements directly enter DataBase Gateway - Google Patents
A kind of method that BACnet agreements directly enter DataBase Gateway Download PDFInfo
- Publication number
- CN107528836A CN107528836A CN201710681972.5A CN201710681972A CN107528836A CN 107528836 A CN107528836 A CN 107528836A CN 201710681972 A CN201710681972 A CN 201710681972A CN 107528836 A CN107528836 A CN 107528836A
- Authority
- CN
- China
- Prior art keywords
- bacnetip
- database
- gateway
- services
- network service
- 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
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/06—Notations for structuring of protocol data, e.g. abstract syntax notation one [ASN.1]
-
- 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
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L69/00—Network arrangements, protocols or services independent of the application payload and not provided for in the other groups of this subclass
- H04L69/08—Protocols for interworking; Protocol conversion
Landscapes
- Engineering & Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Computing Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Data Exchanges In Wide-Area Networks (AREA)
Abstract
The invention discloses a kind of method that BACnet agreements directly enter DataBase Gateway, comprise the steps of：A, it is JOSN packets by BACnetIP protocol conversions, and in the form of the RESTFul network services of standard, BACnetIP Transformation Services are disclosed using BACnetIP encoding and decoding softwares；B, using database web services, BACnetIP network service interface is read in timing, to obtain the last look of each item data of the required record of local BACnetIP equipment, and the data obtained are converted into database table format, it is written in target database, what the present invention can be inexpensive is uploaded to local several sensing datas in remote data base.Can low cost set up wide area network remote distributed sensor data acquisition network.
Description
Technical field
The present invention relates to a kind of method that coding techniques, specifically a kind of BACnet agreements directly enter DataBase Gateway.
Background technology
At present, when some systems（Such as energy management system）Collection for a long time is needed to be distributed in the multiple of multiple places
During the data history records of sensor, it is often necessary to gateway, self-control software etc. are installed in sensor location, then again by automatic control
Software is uploaded in database after sensing data is changed.
At present using robot control system(RCS) access sensor, and it is the problem of upload the data to the pattern of database, at present
Most of self-control software in addition to the function of record data, also extra many logic controls, day process control etc. automatically control
Function needed for system processed, and price is higher, and for such as energy management system, it is only necessary to by required sensor number
Enter according to record in database, it is not necessary to control function.So design is a kind of only to realize access BACnetIP agreement sensors,
And it is necessary that the data collected are uploaded into the inexpensive gateway device of specified database.
The content of the invention
The technical problem to be solved in the present invention is to provide a kind of method that BACnet agreements directly enter DataBase Gateway, with
Solve the problems, such as to mention in background technology.
To achieve the above object, the present invention provides following technical scheme：
A kind of method that BACnet agreements directly enter DataBase Gateway, is comprised the steps of：
A, it is JOSN packets by BACnetIP protocol conversions using BACnetIP encoding and decoding softwares, and with the RESTFul of standard
Network service form, BACnetIP Transformation Services are disclosed；
B, using database web services, BACnetIP network service interface is read in timing, to obtain local BACnetIP
The last look of each item data of the required record of equipment, and the data obtained are converted into database table format, it is written to mesh
Mark in database；
C, using network service is set, allow user BACnetIP equipment can be called to find service by webpage, can set
The point information that need to be recorded, can all sets target databases every Connecting quantity；
D, it is the monitoring process program on the (SuSE) Linux OS of specific gateway hardware by above-mentioned 3 service compilations, and writes net
Close in hardware, complete whole gateway.
Compared with prior art, the beneficial effects of the invention are as follows：The present invention can low cost by local several sensings
Device data are uploaded in remote data base.Can low cost set up wide area network remote distributed sensor data acquisition network
Network.
Brief description of the drawings
Fig. 1 is the block diagram of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is carried out clear, complete
Site preparation describes, it is clear that described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.It is based on
Embodiment in the present invention, those of ordinary skill in the art are obtained every other under the premise of creative work is not made
Embodiment, belong to the scope of protection of the invention.
Referring to Fig. 1, a kind of BACnet agreements directly enter the method for DataBase Gateway, comprise the steps of：
A, it is JOSN packets by BACnetIP protocol conversions using BACnetIP encoding and decoding softwares, and with the RESTFul of standard
Network service form, BACnetIP Transformation Services are disclosed；
B, using database web services, BACnetIP network service interface is read in timing, to obtain local BACnetIP
The last look of each item data of the required record of equipment, and the data obtained are converted into database table format, it is written to mesh
Mark in database；
C, using network service is set, allow user BACnetIP equipment can be called to find service by webpage, can set
The point information that need to be recorded, can all sets target databases every Connecting quantity；
D, it is the monitoring process program on the (SuSE) Linux OS of specific gateway hardware by above-mentioned 3 service compilations, and writes net
Close in hardware, complete whole gateway.
The present invention operation principle be：1 as shown in figure 1,
2 BACnetIP encoding and decoding services set generation BACnetIP communications to wrap and are responsible for setting with BACnetIP according to configuration file
Standby information contact, and the information read is converted into network service and disclosed.
2.1 set up coding bag, and order is converted to BACnetIP bags by sole duty.
2.2 set up decoding bag, and BACnetIP bags are converted to JOSN bags by sole duty.
2.3 set up transmitting-receiving manager, manage BACnetIP transmitting-receiving activity, according to the memory object example for the point that need to be inquired about
Information calls coding bag generation BACnetIP packets, and sends the BACnetIP packets according to priority.By what is received
BACnetIP bags give BACnetIP bags and are converted to JOSN bags, and result is changed to and write the memory object example put accordingly
In.
2.4 set up BACnetIP encoding and decoding network services, generate the network interface of BACnetIP services, including：
2.4.1 equipment finds service, equipment query order whois is sent into BACnet networks, and establish according to returning result
Corresponding BACnetIP device memories object instance in BACnetIP list of devices and internal memory.
2.4.2 polling object subscription service, it may specify which BACnetIP equipment point needs to monitor, BACnetIP encoding and decoding
Network service is by the information of the point specified by long-term automatic regular polling.
2.4.3 facility information list, with the tabular form in JOSN files, all BACnetIP points subscribed to are shown
Last time Query Value is how many and corresponding last time query time.
3 data base read-write services set connection database according to configuration file, and are responsible for timing reading BACnetIP and compile solution
Code network service, the information write into Databasce that will be read.
4 configuration services are responsible for reading and writing BACnetIP encoding and decoding services, the configuration file of data base read-write service, and by its turn
Turn to html web page service for user and man-machine interface configuration service is provided.
4.1 equipment for reading BACnetIP encoding and decoding network services find service, and by the list of devices in returning result
The form of webpage returns to user.
4.2 by equipment can the object of poll user is presented to tabular form, user determines which is subscribed in the form of choosing
A little BACnetIP equipment points.
Database Connection Parameters are presented to user by 4.3 in the form of web page listings, write into Databasce after user fills
Configuration file.
4.4 by the point information write into Databasce configuration file of subscription.
Claims (1)
1. a kind of method that BACnet agreements directly enter DataBase Gateway, it is characterised in that comprise the steps of：
A, it is JOSN packets by BACnetIP protocol conversions using BACnetIP encoding and decoding softwares, and with the RESTFul of standard
Network service form, BACnetIP Transformation Services are disclosed；
B, using database web services, BACnetIP network service interface is read in timing, to obtain local BACnetIP
The last look of each item data of the required record of equipment, and the data obtained are converted into database table format, it is written to mesh
Mark in database；
C, using network service is set, allow user BACnetIP equipment can be called to find service by webpage, can set
The point information that need to be recorded, can all sets target databases every Connecting quantity；
D, it is the monitoring process program on the (SuSE) Linux OS of specific gateway hardware by above-mentioned 3 service compilations, and writes net
Close in hardware, complete whole gateway.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710681972.5A CN107528836A (en) | 2017-08-10 | 2017-08-10 | A kind of method that BACnet agreements directly enter DataBase Gateway |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710681972.5A CN107528836A (en) | 2017-08-10 | 2017-08-10 | A kind of method that BACnet agreements directly enter DataBase Gateway |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107528836A true CN107528836A (en) | 2017-12-29 |
Family
ID=60681048
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710681972.5A Pending CN107528836A (en) | 2017-08-10 | 2017-08-10 | A kind of method that BACnet agreements directly enter DataBase Gateway |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107528836A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115766684A (en) * | 2021-09-02 | 2023-03-07 | 台州市海特自动控制技术有限公司 | Protocol conversion gateway |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103727639A (en) * | 2014-01-09 | 2014-04-16 | 山东建筑大学 | Central air conditioner energy saving system and method based on body |
| CN104320332A (en) * | 2014-11-13 | 2015-01-28 | 济南华汉电气科技有限公司 | Multi-protocol industrial communication safety gateway and communication method with gateway applied |
| CN106685815A (en) * | 2017-01-04 | 2017-05-17 | 上海建坤信息技术有限责任公司 | Multi - protocol hardware acquisition gateway system |
| CN108133275A (en) * | 2018-01-31 | 2018-06-08 | 域通全球成都科技有限责任公司 | Charging vehicle manages system in a kind of field based on data analysis |
-
2017
- 2017-08-10 CN CN201710681972.5A patent/CN107528836A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103727639A (en) * | 2014-01-09 | 2014-04-16 | 山东建筑大学 | Central air conditioner energy saving system and method based on body |
| CN104320332A (en) * | 2014-11-13 | 2015-01-28 | 济南华汉电气科技有限公司 | Multi-protocol industrial communication safety gateway and communication method with gateway applied |
| CN106685815A (en) * | 2017-01-04 | 2017-05-17 | 上海建坤信息技术有限责任公司 | Multi - protocol hardware acquisition gateway system |
| CN108133275A (en) * | 2018-01-31 | 2018-06-08 | 域通全球成都科技有限责任公司 | Charging vehicle manages system in a kind of field based on data analysis |
Non-Patent Citations (3)
| Title |
|---|
| SHSUNWELL112012: "BACnet网关使用说明", 《工控论坛》 * |
| 支广潮: "基于BACnet/ IP 的设备与实时数据库通信实现", 《计算机应用》 * |
| 迅饶: "迅饶SQL2BACnet协议转换网关软件", 《迅饶》 * |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN115766684A (en) * | 2021-09-02 | 2023-03-07 | 台州市海特自动控制技术有限公司 | Protocol conversion gateway |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104660682B (en) | A kind of OPC data collection and monitoring intelligent terminal based on TD-LTE | |
| CN106951694B (en) | Adaptive modeling method for online monitoring system of secondary equipment of power system | |
| CN102802139A (en) | Gateway data adapting system and method of Internet of Things | |
| CN103733148A (en) | Energy management gateways and processes | |
| CN104104674A (en) | Multiprotocol distributed data acquisition control system of equipment sensor and method thereof | |
| CN103297306B (en) | A kind of agriculture Internet of things system | |
| CN102946648A (en) | Intelligent terminal system of wireless gateway and automatic control method of intelligent terminal system | |
| CN102929224B (en) | Condition acquisition controller (CAC) for power transformer equipment and system control method | |
| CN104362757A (en) | Transformer substation on-line monitoring system based on IEC61850 | |
| CN106953923A (en) | A kind of industrial Internet of Things intelligence system | |
| CN104811501A (en) | Server positioning method and server positioning device | |
| CN104104699A (en) | Handset remote configuration system and configuration method for the same | |
| CN102164175A (en) | Cloud-storage-based electricity utilization information acquisition method and system | |
| CN106068028A (en) | Terminal processes method and the terminal of wireless network name mess code | |
| CN103970530A (en) | Data acquisition and implementation method based on Intouch configuration technology of OPC interface | |
| CN103744587A (en) | Method of adjusting function menus and dynamic menu system | |
| CN111010296A (en) | Configurable Internet of things data acquisition system and configuration method | |
| CN103561083A (en) | Internet of things data processing method | |
| CN107528836A (en) | A kind of method that BACnet agreements directly enter DataBase Gateway | |
| CN102034163A (en) | Method and system for managing asset information of telecommunication equipment | |
| CN106101218A (en) | The report method of terminal data and device | |
| CN100393093C (en) | Intelligent applicate communication controlling system and method based on radio application protocol | |
| CN101764761B (en) | Method for limiting transmission flow capacity of service provider interfaces and multi-media service gateway | |
| CN111711695B (en) | Distributed equipment management system based on cloud platform | |
| CN114466039A (en) | OPCUA communication system and method based on 5G private network |
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 | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20171229 |
|
| RJ01 | Rejection of invention patent application after publication |