CN102355498A - Information access system for a plurality of wireless sensor networks and access method - Google Patents
Information access system for a plurality of wireless sensor networks and access method Download PDFInfo
- Publication number
- CN102355498A CN102355498A CN2011103006326A CN201110300632A CN102355498A CN 102355498 A CN102355498 A CN 102355498A CN 2011103006326 A CN2011103006326 A CN 2011103006326A CN 201110300632 A CN201110300632 A CN 201110300632A CN 102355498 A CN102355498 A CN 102355498A
- Authority
- CN
- China
- Prior art keywords
- information
- wireless sensor
- database
- mysql
- server
- 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
Images
Abstract
The invention relates to an information access system for a plurality of wireless sensor networks and an access method, which belong to the technical field of electronic information. The system comprises two parts, i.e. a plurality of local wireless sensor network systems, and a general server and a database for a user to have access to. Each local wireless sensor network system comprises a plurality of sensor information acquisition nodes, a router node, a gateway node and an upper computer, i.e. a personal computer (PC) which is connected with the gateway node. The invention also provides the information access method for a plurality of wireless sensor networks. A plurality of local wireless sensor networks directly save the sensor information to the general database via the Internet, and the server is connected with the database, so that the user can have access to the information of the wireless sensor networks through the general server, and the access flexibility and the convenience of the user are improved.
Description
Technical field
The present invention relates to a kind of information access system and access method that is used for a plurality of wireless sensor networks, belong to electronic information technical field.
Background technology
Wireless sensor network (Wireless Sensor Network is called for short WSN) is formed by being distributed in the sensor in different positions node.Wireless sensor network is made up of three types node: information gathering node, router node and aggregation node.The information gathering node is responsible for gathering environmental information, and information is sent to router node or directly sends aggregation node to.Router node is responsible for the information that the information gathering node transmits is carried out route, passes to aggregation node through the multi-hop mode.Aggregation node is the external interface of wireless sensor network, and it is responsible for the information of whole wireless sensor network is gathered arrangement, provides interface to supply user inquiring to call, and user command can also be sent to specified node and make it carry out corresponding actions.
WAMP (Windows+Apache+MySQL+PHP) or LAMP (Linux+Apache+MySQL+PHP) framework are website frameworks commonly used.Windows and Linux are the operating system that use the website.Apache is that the world uses the web server software that ranks the first, and it may operate on nearly all widely used computer platform, be widely used with fail safe owing to it is cross-platform, and be one of most popular Web server end software.MySQL is a small-sized Relational DBMS, and the developer is a Sweden MySQLAB company, is purchased by Sun Microsystems on January 16th, 2008.MySQL is widely used in the middle-size and small-size website on the Internet.Because its volume is little, speed is fast, the total cost of ownership is low, these characteristics of open source code especially, many middle-size and small-size websites have selected MySQL as site databases in order to reduce the website total cost of ownership.PHP is the embedded language of a kind of HTML, is a kind of script of the embedding html document of carrying out at server end.Interfaces such as the API of MySQL support standard C, JDBC, ODBC, NET, PHP, Python, Perl, Ruby, VB, the user can call the MySQL interface and carry out the MySQL database manipulation in these programming languages.The MySQL database is made up of table, and each table is made up of many records again.Each table all has different fields to describe the attribute of record, and a record is exactly the data line that different field combines.
Adopt WAMP or LAMP framework can build the WEB website, comprise server and database section, supply the user capture relevant information.But do not find a kind of information access system and access method that is used for a plurality of wireless sensor networks at present as yet.Traditional information access system is to create a WEB website separately for each local system, comprises independently a server and an independent database.When traditional information access system is used for a plurality of local wireless sensor network system; Just need a plurality of WEB websites of configuration; Each WEB website all has independently server and database; So not only increased hardware and software cost; And the user need import different domain name addresses when carrying out message reference; Be not easy to memory, caused a lot of inconvenience.And information access system that is used for a plurality of wireless sensor networks and access method that the present invention proposes can address this problem.The information access system that is used for a plurality of wireless sensor networks that the present invention proposes only need be created a WEB website; Comprise a server and a database, only need import a domain name addresses when user carries out message reference and select corresponding local wireless sensor network system to get final product then.
Summary of the invention
To the defective of prior art, the present invention provides a kind of information access system and access method that is used for a plurality of wireless sensor networks.
A kind of information access system that is used for a plurality of wireless sensor networks, system comprises two parts: a plurality of local wireless sensor network systems and the far-end WEB website that supplies user capture; The local wireless sensor network system comprises a plurality of sensor information acquisition nodes, routing node, gateway node and the host computer PC that links to each other with gateway node through the RS232 interface; Far-end WEB website comprises server and database section, adopts WAMP or LAMP framework.
A kind of access method that is used for the information access system of a plurality of wireless sensor networks comprises formation gathering method and information access method.Formation gathering method is following:
Sensor nodes to collect information gathering environmental information to form a data stream routed through the router nodes or passed directly to the gateway node, the gateway node send via RS232 interface connected to the host computer PC, running on the PC PC software for wireless sensor network data flow information in accordance with the local system to parse the data format, and then call a remote MySQL database WEB site provides a C language API, via an Internet connection MySQL database using the MySQL database MySQL insert statement to write sensor to the environment information; remote MySQL database compared with each of the local wireless sensor network system to create a database, create a sensor_inf each database table to store the sensor data collected environmental information;
Information access method is following:
(1) subscription client sends information inquiring request through browser;
(2) server is received this request, and the PHP language API that calling MySQL provides connects the MySQL database;
(3) server asks to select the corresponding MySQL database of local system of user inquiring according to the user, operation MySQL query statement in the sensor_inf tables of data, and Query Result is kept among the PHP;
(4) server returns to client with Query Result, and client shows.
Advantage of the present invention:
(1) with build website for each local wireless sensor network system to compare; The user only need visit the sensor information that a website that is positioned on the director server just can obtain all local wireless sensor network systems, needn't land the server site that links to each other with local system one by one and obtain sensor information.
(2) the local PC in the local wireless sensor network system only need install upper computer software, needn't configuration server and database, so just do not require that local PC has high-performance, even local PC can be replaced with the embedded platform with similar functions.
(3) each wireless sensor network possibly have the different data flow form; The present invention can the shadow data stream format difference; Host computer PC in the local system all converts data flow to MySQL database that uniform data format writes far-end WEB website, needn't consider the difference of data stream format during the user capture sensor information.
The present invention can visit the information of a plurality of wireless sensor network collections and need not visit each network one by one to unify mode, has evaded the concrete data stream format of each sensor network simultaneously, has efficient, convenient, the unified advantage of message reference.
Description of drawings
Fig. 1 is the information access system structured flowchart that is used for a plurality of wireless sensor networks of the present invention.
Fig. 2 is the information access method structured flowchart that is used for a plurality of wireless sensor networks of the present invention.
Wherein, 1, the Remote WEB website, 2, director server; 3, MySQL database, 4, Internet connects, 5, the local wireless sensor network system; 6, local PC, 7, wireless sensor network, 8, the RS232 interface; 9, the Internet, 10, the user, 11, connect specified database; Carry out database query operations; 12, return Query Result to server, 13, information inquiring request, 14, server is replied and return the content of solicited message.
Embodiment
Below in conjunction with accompanying drawing and embodiment the present invention is further specified.
A kind of information access system that is used for a plurality of wireless sensor networks, as shown in Figure 1, system comprises two parts: a plurality of local wireless sensor network systems and the far-end WEB website that supplies user capture; The local wireless sensor network system comprises a plurality of sensor information acquisition nodes, routing node, gateway node and the host computer PC that links to each other with gateway node through the RS232 interface; Far-end WEB website comprises server and database section, adopts the WAMP framework.
A kind of access method that is used for the information access system of a plurality of wireless sensor networks as shown in Figure 2, comprises formation gathering method and information access method.Formation gathering method is following:
Sensor nodes to collect information gathering environmental information to form a data stream routed through the router nodes or passed directly to the gateway node, the gateway node send via RS232 interface connected to the host computer PC, running on the PC PC software for wireless sensor network data flow information in accordance with the local system to parse the data format, and then call a remote MySQL database WEB site provides a C language API, via an Internet connection MySQL database using the MySQL database MySQL insert statement to write sensor to the environment information; remote MySQL database compared with each of the local wireless sensor network system to create a database, create a sensor_inf each database table to store the sensor data collected environmental information;
Information access method is following:
(1) subscription client sends information inquiring request through browser;
(2) server is received this request, and the PHP language API that calling MySQL provides connects the MySQL database;
(3) server asks to select the corresponding MySQL database of local system of user inquiring according to the user, operation MySQL query statement in the sensor_inf tables of data, and Query Result is kept among the PHP;
(4) server returns to client with Query Result, and client shows.
Embodiment 2:
A kind of information access system and access method that is used for a plurality of wireless sensor networks, identical with embodiment 1, difference is: server and database section adopt the LAMP framework.
Claims (2)
1. an information access system that is used for a plurality of wireless sensor networks is characterized in that system comprises two parts: a plurality of local wireless sensor network systems and the far-end WEB website that supplies user capture; The local wireless sensor network system comprises a plurality of sensor information acquisition nodes, routing node, gateway node and the host computer PC that links to each other with gateway node through the RS232 interface; Far-end WEB website comprises server and database section, adopts WAMP or LAMP framework.
2. an access method that is used for the information access system of a plurality of wireless sensor networks comprises formation gathering method and information access method, it is characterized in that,
Formation gathering method is following:
Sensor nodes to collect information gathering environmental information to form a data stream routed through the router nodes or passed directly to the gateway node, the gateway node send via RS232 interface connected to the host computer PC, running on the PC PC software for wireless sensor network data flow information in accordance with the local system to parse the data format, and then call a remote MySQL database WEB site provides a C language API, via an Internet connection MySQL database using the MySQL database MySQL insert statement to write sensor to the environment information; remote MySQL database compared with each of the local wireless sensor network system to create a database, create a sensor_inf each database table to store the sensor data collected environmental information;
Information access method is following:
(1) subscription client sends information inquiring request through browser;
(2) server is received this request, and the PHP language API that calling MySQL provides connects the MySQL database;
(3) server asks to select the corresponding MySQL database of local system of user inquiring according to the user, operation MySQL query statement in the sensor_inf tables of data, and Query Result is kept among the PHP;
(4) server returns to client with Query Result, and client shows.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103006326A CN102355498A (en) | 2011-09-30 | 2011-09-30 | Information access system for a plurality of wireless sensor networks and access method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011103006326A CN102355498A (en) | 2011-09-30 | 2011-09-30 | Information access system for a plurality of wireless sensor networks and access method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102355498A true CN102355498A (en) | 2012-02-15 |
Family
ID=45578992
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011103006326A Pending CN102355498A (en) | 2011-09-30 | 2011-09-30 | Information access system for a plurality of wireless sensor networks and access method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102355498A (en) |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102594922A (en) * | 2012-03-26 | 2012-07-18 | 哈尔滨工业大学 | Wireless network system used for monitoring physical sign signals |
| CN102882896A (en) * | 2012-11-01 | 2013-01-16 | 山东大学 | Data information access system and method based on internet of things |
| CN104468214A (en) * | 2014-12-05 | 2015-03-25 | 浪潮集团有限公司 | Method for systematically managing PowerPC cloud storage platform through LAMP |
| CN107528864A (en) * | 2016-06-20 | 2017-12-29 | 中国科学院微电子研究所 | Heterogeneous network data processing method and system |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101442556A (en) * | 2008-12-25 | 2009-05-27 | 北京交通大学 | Wireless sensor network server system based on IPv6 |
| CN201532211U (en) * | 2009-10-27 | 2010-07-21 | 西安迅腾科技有限责任公司 | Lawn environment parameter data acquisition system based on lawn lamps |
| CN201601867U (en) * | 2010-05-05 | 2010-10-06 | 山东天元物联电子科技有限公司 | Street lamp energy conservation and management system based on Internet of things |
| CN201690477U (en) * | 2010-02-04 | 2010-12-29 | 烟台毅康电子科技有限公司 | Distributed controller based on Zigbee technology |
| CN201796269U (en) * | 2010-05-19 | 2011-04-13 | 山东建筑大学 | Building electric equipment networking system |
-
2011
- 2011-09-30 CN CN2011103006326A patent/CN102355498A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101442556A (en) * | 2008-12-25 | 2009-05-27 | 北京交通大学 | Wireless sensor network server system based on IPv6 |
| CN201532211U (en) * | 2009-10-27 | 2010-07-21 | 西安迅腾科技有限责任公司 | Lawn environment parameter data acquisition system based on lawn lamps |
| CN201690477U (en) * | 2010-02-04 | 2010-12-29 | 烟台毅康电子科技有限公司 | Distributed controller based on Zigbee technology |
| CN201601867U (en) * | 2010-05-05 | 2010-10-06 | 山东天元物联电子科技有限公司 | Street lamp energy conservation and management system based on Internet of things |
| CN201796269U (en) * | 2010-05-19 | 2011-04-13 | 山东建筑大学 | Building electric equipment networking system |
Non-Patent Citations (1)
| Title |
|---|
| 袁东风，徐伟涛: "基于ZigBee与RFID技术的智能仓储管理系统的设计", 《中国电子学会第十七届信息论学术年会论文集》, 31 October 2010 (2010-10-31) * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102594922A (en) * | 2012-03-26 | 2012-07-18 | 哈尔滨工业大学 | Wireless network system used for monitoring physical sign signals |
| CN102882896A (en) * | 2012-11-01 | 2013-01-16 | 山东大学 | Data information access system and method based on internet of things |
| CN104468214A (en) * | 2014-12-05 | 2015-03-25 | 浪潮集团有限公司 | Method for systematically managing PowerPC cloud storage platform through LAMP |
| CN107528864A (en) * | 2016-06-20 | 2017-12-29 | 中国科学院微电子研究所 | Heterogeneous network data processing method and system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6961728B2 (en) | System and methods for highly distributed wide-area data management of a network of data sources through a database interface | |
| CN107402995A (en) | A kind of distributed newSQL Database Systems and method | |
| CN104333512A (en) | Distributed memory database access system and method | |
| CN103425726A (en) | Processing queries in a computer network using business intelligence tools | |
| CN102882896A (en) | Data information access system and method based on internet of things | |
| CN103645951A (en) | Cross-platform mobile data management system and method | |
| CN102073683A (en) | Distributed real-time news information acquisition system | |
| CN106790503A (en) | It is a kind of to realize the IPv4 websites without skylight using the device upgraded to IPv6 based on HTTP reverse proxys | |
| US20190324987A1 (en) | Storing and identifying metadata through extended properties in a historization system | |
| Yuriyama et al. | Integrated cloud computing environment with IT resources and sensor devices | |
| CN107480252A (en) | A kind of data query method, client, service end and system | |
| US20140358492A1 (en) | Systems and methods for synchronizing geographic information system (gis) network models | |
| CN102355498A (en) | Information access system for a plurality of wireless sensor networks and access method | |
| CN101493825A (en) | GIS middleware collocation and management method | |
| CN102946648A (en) | Intelligent terminal system of wireless gateway and automatic control method of intelligent terminal system | |
| CN103577568A (en) | Cross-platform mobile safety comprehensive information aggregation system and method adopting same | |
| CN103729479A (en) | Web page content statistical method and system based on distributed file storage | |
| CN105681285A (en) | Method for obtaining information of heterogeneous industrial signal source | |
| Chaturvedi et al. | InterSensor service: establishing interoperability over heterogeneous sensor observations and platforms for smart cities | |
| CN104503985A (en) | Method for automatically creating Solr index file by Hbase data | |
| CN109241384A (en) | A kind of method for visualizing and device of scientific research information | |
| CN103377269A (en) | Sensor data positioning method and device | |
| CN104778285A (en) | XML-based WEB service system and working method thereof | |
| CN103838781A (en) | Database access method and system | |
| CN103034650A (en) | System and method for processing data |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20120215 |