Sensor SENSORS DATABASE DESIGN AND INTEGRATION by dandanhuanghuang

VIEWS: 21 PAGES: 8

									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.

								
To top