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 PDF

Info

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
Application number
CN2011103006326A
Other languages
Chinese (zh)
Inventor
袁东风
王磊
单小明
Original Assignee
山东大学
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by 山东大学 filed Critical 山东大学
Priority to CN2011103006326A priority Critical patent/CN102355498A/en
Publication of CN102355498A publication Critical patent/CN102355498A/en

Links

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

A kind of information access system and access method that is used for a plurality of wireless sensor networks

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)

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.
CN2011103006326A 2011-09-30 2011-09-30 Information access system for a plurality of wireless sensor networks and access method CN102355498A (en)

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)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
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

Patent Citations (5)

* Cited by examiner, † Cited by third party
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)

* Cited by examiner, † Cited by third party
Title
袁东风,徐伟涛: "基于ZigBee与RFID技术的智能仓储管理系统的设计", 《中国电子学会第十七届信息论学术年会论文集》, 31 October 2010 (2010-10-31) *

Cited By (4)

* Cited by examiner, † Cited by third party
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