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: Elke A. Rundensteiner PH. D Student: Xin Zhang 04 -19 -2001 1

XML and Relational Database: What and Why? n Benefits n Applications 04 -19 -2001 2

XML and Relational Database n Problem n Current Solution n Rainbow Solution 04 -19 -2001 3

Goals of our MPQ n Learn about the database technology 04 -19 -2001 4

Rainbow System Overview 04 -19 -2001 5

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

Complete Class Diagram 04 -19 -2001 7

Rainbow Implementation n Development Tools u Java: Visual Café, Javadocs, JDBC u Oracle, 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 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 DW handling concurrency u Feasibility improvements to Rainbow concept u Automated test bed u Performance evaluations Knowledge gained u OO, Java, JDBC u SQL, DBMS, Distributed Query Processing u Software reuse & re-engineering u Teamwork & S/W Engineering Project Future work – Ry. Co (Distributed Dy. Da system) 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