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
- access
- database
- mysql
- Prior art date
Links
- 230000015572 biosynthetic process Effects 0.000 claims description 6
- 238000005755 formation reactions Methods 0.000 claims description 6
- 230000000875 corresponding Effects 0.000 claims description 5
- 230000002776 aggregation Effects 0.000 description 4
- 238000004220 aggregation Methods 0.000 description 4
- 280000029482 Network One companies 0.000 description 1
- 281000182076 Sun Microsystems companies 0.000 description 1
- 280000450078 System One companies 0.000 description 1
- 230000002950 deficient Effects 0.000 description 1
Abstract
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.
Embodiment 1
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)
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 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 not_active Application Discontinuation
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 |
|---|---|---|
| CN105138592B (en) | A kind of daily record data storage and search method based on distributed structure/architecture | |
| US9398077B2 (en) | Mobile applications | |
| Le-Phuoc et al. | A middleware framework for scalable management of linked streams | |
| Janowicz et al. | A restful proxy and data model for linked sensor data | |
| CN106096056B (en) | One kind being based on distributed public sentiment data real-time collecting method and system | |
| EP3096250A1 (en) | System and method for distributed database query engines | |
| Yuriyama et al. | Sensor-cloud infrastructure-physical sensor management with virtualized sensors on cloud computing | |
| CN104160394B (en) | Scalable analysis platform for semi-structured data | |
| Tracey et al. | A holistic architecture for the internet of things, sensing services and big data | |
| CN103763182B (en) | A kind of implementation method of customer service request based on wechat public platform | |
| KR101786561B1 (en) | Semantic naming model | |
| US7499983B2 (en) | Web dispatch service | |
| CN103106249B (en) | A kind of parallel data processing system based on Cassandra | |
| US7823123B2 (en) | Semantic system for integrating software components | |
| KR20160074611A (en) | Crawling of m2m devices | |
| AU2005246392B2 (en) | Occasionally-connected application server | |
| Ruta et al. | Enabling the Semantic Web of Things: framework and architecture | |
| CN103491169B (en) | Method and system for uploading and downloading files | |
| CN102054025B (en) | Traffic information resource integration processing method and system | |
| Calderoni et al. | Location-aware mobile services for a smart city: Design, implementation and deployment | |
| CN104125208B (en) | Data transmission method and device | |
| CN105183860B (en) | Method of data synchronization and system | |
| CN103036954B (en) | Mobile message paradigmatic system and method thereof based on GIS | |
| US9116946B2 (en) | System and method for interacting with a plurality of data sources | |
| US20190098113A1 (en) | Web services platform with integration and interface of smart entities with enterprise applications |
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 |