7
May 12

eAggregation/eFederation

Synopsis: Law enforcement client desired a web-based (JAVA/JSF/Lucene/Solr) e-aggregation/e-federation "no-scroll" application to quickly search millions of records and return those matching the selection criteria in less than one second. The returned results of the submitted search would then be "drill-down" searchable from that point, to include cross-linked reports as appropriate.

Language(s)/Platform(s) used:

  • Java SE 7
  • Java Server Faces (JSF) 2.1
  • PrimeFaces 3.2
  • Apache Solr/Lucene 3.5
  • JasperReports 4.5

Database(s) utilized:

  • MySQL 5.1
  • SQL Server 2008
  • Oracle

Geographical Information System (GIS) software used:

  • GeoXML
  • Google Maps (KML)
  • Google Earth (KML)

Extract-Transform-Load (ETL) software used:

  • CloverETL
7
May 12

Flight Dispatch

Synopsis: Client desired a desktop-based (JAVA/Swing/JAXB) flight dispatch application to track 150+ helicopters in near-realtime on a 24x7 basis.

Language(s)/Platform(s) used:

  • Java w/ Swing components
  • JAXB web services

Database(s) utilized:

  • Oracle w/ Oracle Spatial extension
  • MySQL