Rainbow: XML and Relational Database Design, Implementation, Test, and Evaluation

1
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

2
XML and Relational Database What and Why?

• Benefits
• Applications

3
XML and Relational Database

• Problem
• Current Solution
• Rainbow Solution

4
Goals of our MPQ

• Learn about the database technology

5
Rainbow System Overview
6
Java Object-Oriented Design

• Reuse and Re-engineering
• Difficulties and advantages of using existing
  code
• Time span of design vs. implementation
• Design Tools used in Re-engineering
• Unified Modeling Language (UML)
• Object Domain Class Diagrams, Activity
  Diagrams, Sequence Diagrams

7
Complete Class Diagram
8
Rainbow Implementation

• Development Tools
• Java Visual Café, Javadocs, JDBC
• Oracle, SQL Queries
• Code Facts
• 22,991 lines of system code
• 7,253 lines of Rainbow code
• 15,738 lines of code reused
• 100 total system classes
• 17 Rainbow system classes
• 83 classes reused
• Re-engineering success

9
Rainbow Evaluation Test
10
Rainbow Analysis
11
Rainbow Analysis Cont..
12
Rainbow Conclusions

• Accomplishments
• Built complex Object Oriented design
• Fully functional DW handling concurrency
• Feasibility improvements to Rainbow concept
• Automated test bed
• Performance evaluations
• Knowledge gained
• OO, Java, JDBC
• SQL, DBMS, Distributed Query Processing
• Software reuse re-engineering
• Teamwork S/W Engineering Project
• Future work RyCo (Distributed DyDa system)

13
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/