VIEWS: 21 PAGES: 8 POSTED ON: 9/13/2011
SENSORS DATABASE DESIGN AND INTEGRATION WITH GEOSERVER. STEP 1-IDENTIFICATION OF APPROPRIATE DATABASE AND DESIGNING THE SCHEMA FOR IT. • In this stage I have used Postgresql till now for implementation of the designed schema. • We can also use Oracle database for implementing the schema. • Reason for Not using Oracle- SDO_Geometry data type is not supported in Oracle express editions. • Status- Completed STEP 2 – GETTING THE DATA FROM THE SENSOR AND CONVERTING IT INTO A FORM USABLE BY THE DATABASE. • This stage can be completed once we get the sensors and get to know in what data format , they give out the data. • The time taken for this step would depend on the data format and the understanding of it. • Status-Pending. • Approximate time Required for this stage- 1 week. STEP 3- WRITING QUERIES TO PERFORM APPROPRIATE TASKS- In this stage we create queries for performing the following tasks- • Taking the average of top readings and storing it in archive. • Deleting the oldest readings for each sensor from the non-archival table. • Using the current data to display average temperature. CONTINUED… • Also the queries need to be scheduled for them to be automatically carried out. • This is usually done with a scheduler within the DBMS. For example Oracle, Microsoft Sql Server and other vendors have schedulers within them to carry out this task. Postgresql comes with a scheduler Pgagent , but it has not been working for us. • Current Status- This step is complete except the scheduling portion. • Time Required- The scheduling part can be done in couple of days at max. once we know how to schedule the task. STEP 4- INTEGRATING DATABASE WITH MAPS AND DEVELOPING A GUI FOR USER- • The user interaction would mostly be through this window . • Status- Pending. • Time Frame-A time period of 7 days for developing an initial prototype and another 7 days for improving on that. ORDER OF STEPS- • Right now I would be jumping to stage-4 as it is one of the most important stages and is independent of sensors in any way. • By the time we complete stage-4, we may have information about sensors and complete stage-2. • Finally we can complete the scheduling part of stage-3. TIME-FRAME FOR VARIOUS STAGES- • Stage 1- Completed. • Stage 2- 1 week -22nd June. • Stage 3- 2 or 3 days.-29th June. • Stage 4- 3 weeks -11th June.
Pages to are hidden for
"Sensor SENSORS DATABASE DESIGN AND INTEGRATION"Please download to view full document