Rainbow XML and Relational Database Design Implementation Test

Rainbow: XML and Relational Database Design, Implementation, Test, and Evaluation Project Members: Tien Vu, Mirek Cymer, John Lee Advisor: Prof. Elke A. Rundensteiner PH. D Student: Xin Zhang Sponsor: GE Laboratories 04 -19 -2001 1

XML and Relational Database: What and Why? n Benefits: u u u n Efficient query and analysis tools. Matured Data Warehousing support. Easy Integration with existing business database. Applications: u u E-commerce Web-based industries 04 -19 -2001 2

XML and Relational Database n Problem u Many Application usually change its data very frequently. t n Current Solution u n e. g. , flight reservation, online billing, inventory. Reloading the complete XML document when changed which is very expensive. Rainbow Solution u Incrementally propagate XML Document Updates to Stored XML Data. t t t 04 -19 -2001 Goal: XML Repository Implemented using RDBMS Approach: Flexible Mapping Features: • DTD Metadata Management in RDB • Automatic Schema Creation • Incremental Update Propagation • XML Query Optimization 3

Goals of our MPQ n n n Learn about the database technology Translate abstract research ideas into actual software system design Implement large-scale Rainbow software system Practice good software engineering: UML, reengineering and reuse Design an experimental test plan and test bed Conduct extensive performance study and analysis 04 -19 -2001 4

Rainbow System Architecture Overview XML Query Workload User XML Model XML Query Engine Internal Process Restructuring DBA Legend DTDM Manager Sub system DTDM Repository Loader Clock Relational Model Dumper DTD 04 -19 -2001 Schema Creator XML 5

Java Object-Oriented Design n Reuse and Re-engineering u u Difficulties and advantages of using existing code Time span of design vs. implementation n Design Tools used in Re-engineering u u Unified Modeling Language (UML) Object Domain – Class Diagrams, Activity Diagrams, Sequence Diagrams 04 -19 -2001 6

Complete Class Diagram 04 -19 -2001 7

Rainbow Implementation n Development Tools u Java: Visual Café 2, Javadocs u Oracle 8 i, XML 4 J, JDBC 1. 2, SQL Queries Code Facts u 22, 991 lines of system code u 7, 253 lines of Rainbow code u 15, 738 lines of code reused u 100 total system classes u 17 Rainbow system classes u 83 classes reused Re-engineering success 04 -19 -2001 8

Rainbow Evaluation & Test n Experiment Setup u Oracle 8 i u Win NT u Randomly generated data 04 -19 -2001 9

Rainbow Analysis 04 -19 -2001 10

Rainbow Analysis Cont. . 04 -19 -2001 11

Rainbow Conclusions n n n Accomplishments u Built complex Object Oriented design u Fully functional u Feasibility improvements to Rainbow concept u Automated test bed u Performance evaluations Knowledge gained u OO, Java, JDBC u SQL, DBMS u Software reuse & re-engineering u Teamwork & S/W Engineering Project Future works: 04 -19 -2001 12

Rainbow: XML and Relational Database Design, Implementation, Test, and Evaluation Project Members: Tien Vu, Mirek Cymer, John Lee Advisor: Elke A. Rundensteiner PH. D Student: Xin Zhang Visit Rainbow at http: //davis. wpi. edu/dsrg/TJM/ 04 -19 -2001 13