Slide 1: LIAS Database Architecture Overview

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

• http://lias.cis.rit.edu/larch/

-- PatrickStein - 28 Mar 2006