Team Members: William Busby, Lindsey Gray, & David Meffe

1. Team Members: William Busby, Lindsey Gray, & David Meffe • Sponsor: Lockheed Martin Reconnaissance Systems • Bill Rawlings and Marvin Kliene

2. Project Description • Retrieval and display of XML formatted SAR metadata in intranet environment • SAR metadata and imagery stored in a relational database • XML tags for metadata • Style sheets to display metadata • Web-based retrieval and display Lindsey Gray

3. Problem Statement Requirements Architecture Design Implementation Testing Design Method • Incremental approach • Process loops back to the requirements in the architectural, design, implement and testing stages • Ensures the requirements are a part of each step in the procedure Lindsey Gray

4. Physical View Architecture is similar to basic Client/Server David Meffe

5. Data Flow View Architecture shows the Parsing/ Insertion of Flat Files Data into Database and Generation and Display of Data to Client David Meffe

6. Logical View Architecture shows access by an outside source that can view data other than a Web Browser David Meffe

7. Functional View Architecture is similar to Logical view and displays all external entities David Meffe

8. ER Diagram William Busby

9. Acquiring the SAR Metadata • Data stored in 4 binary files - CNF - IMU - ANT - IFMU • Parse files based on predefined structures • 3 files contain multiple records - ANT - IMU - IFMU • Insert data into database William Busby

10. Extraction/Insertion Classes William Busby

11. Database Connectivity: Connection Pool • Handles the Connection pool to the Database. Limits the Max amount of connections • Exception Handler handles exceptions thrown by the connection pool William Busby

12. Database Connectivity: SQL Request • Handles the creation and return of the Result set generated by the SQL statement • SQL Exception handler handles the exceptions thrown by an invalid result set William Busby

13. XML Schema • Used to define XML document • What must the document contain • What type the data should be • Relationships (i.e. nesting) • Used to validate the XML document created Lindsey Gray

14. <element name=”Image” type=”JavaXML:SARImageType” />  <complexType name = “SARImageType”> <element name = “IMAGE_ID” type = “string” /> <element name = “pass_no” type = “integer” /> <element name = “file_id” type = “integer” /> <element name = “rec_len” type = “integer” /> <element name = “tape_date” type = “string” /> <element name = “tape_time” type = “string” /> <element name = “rec_cnt” type = “integer” /> <element name = “cnf” type= “JavaXML:cnfType” /> <element name = “ifmu” type = “JavaXML:ifmuType” /> <element name = “ant” type = “JavaXML:antType” /> <element name = “imu” type = “JavaXML:imuType” /> </complexType> <complexType name = “antType”> <element name = “time_tag” type = “integer” /> <element name = “roll_cmd” type = “float” /> <element name = “yaw_cmd” type = “float” /> <element name = “new_range_gate” type = “integer” /> </complexType> Lindsey Gray

15. CreateXMLDoc outputFile printSARImageType(String) printCNFType(String) printIFMUType(String) printANTType(String) printIMUType(String) validate(Schema) XML Document Generation • Create XML document from database • Validate against schema Lindsey Gray

16. XSL • Will be used to transform XML to HTML • Still learning • http://www.w3schools.com/xsl/ Lindsey Gray

17. Test Plan • Test each module separately • Slowly integrate with other modules • Test again with other pieces in place • User testing • Revisions integrated • More testing Lindsey Gray

18. Schedule • Main Tasks • Gantt Chart • Critical Path • Current Status William Busby

19. Main Tasks • XML element specification • Extract data • Oracle 8i database • DB connection pool & SQL management • XML document generation • XSL style sheets • HTML pages – entry & online help • Servlet filtering/handling William Busby

21. Critical Path William Busby

22. Current Status • Overall on schedule • Slightly behind on some • Slightly ahead on others • Schedule needs adjustments • Too compacted • Only 3 people, but more than 3 concurrent tasks • Room to work with • Current schedule has project finishing 3/30 William Busby

23. QUESTIONS ?