r1 - 28 Mar 2006 - 10:10:13 - PatrickSteinYou are here: TWiki >  LIAS Web  >  PresentationMaterials > SeminarSeries > LIASDatabaseArchitectureOverview
Tags:
create new tag
, view all tags
Start Presentation

Slide 1: LIAS Database Architecture Overview


Patrick Stein <stein@cis.rit.edu>
2006-03-28

Slide 2: Preview Shot

Slide 3: Block Diagram

Slide 4: Major Pieces

  • Database Server (Java)
  • Database (PostgreSQL soon to be Oracle)
  • Crawlers (Java)
  • GUI Sidebar (Java applet)
  • GUI Google Maps (Javascript)

Slide 5: Database Server

  • Spackle over the Database -- provides an API that is divorced from the actual format of the database
  • Methods like:
    • void FlightImage.setFlightLeg( long _legId );
    • void FlightImage.setAltitude( double _alt );
    • long FlightImageStore.insert( FlightImage _img );
    • java.util.Collection FlightImageStore.findByFlightLeg( long _legId );

Slide 6: Database

  • Currently using PostgreSQL, but will switch to Oracle
  • Using table inheritence so that:
    • WaspImages are FlightImages
    • FlightImages are GeoImages
    • GeoImages are Images
    • etc.
  • Using polygon intersection routines
    • point in polygon?
    • polygon overlaps polygon?

Slide 7: Crawlers

  • Currently, just WASP, but MISI one is mostly done
  • Runs through a tree of data and plops it into the DB
  • Automatically breaks data into legs and clusters
  • Currently, not too sensitive... it doesn't bother checking to see if the flight is already in the DB, so you have to exercise care.

Slide 8: GUI Sidebar

  • Interacts with the Database server
  • Shows/hides stuff on the Google Maps
  • Soon will support downloading data

Slide 9: GUI Google Maps

  • Google Maps API is in Javascript
  • Some custom Javascript used to track which things are visible

Slide 10: Database Schema (Venn Diagram)

Slide 11: Database Schema (UML)

Slide 12: Prototype Demo

-- PatrickStein - 28 Mar 2006

Edit | WYSIWYG | Attach | Printable | Raw View | Backlinks: Web, All Webs | History: r1 | More topic actions
 
Powered by TWiki
This site is powered by the TWiki collaboration platformCopyright © by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki? Send feedback