Information Systems Re-engineering, Integration and Normalization - Heterogeneous Database Connectivity



Forum


Link 1
Link 2

Figure 9.8 Whole picture of Transformed flattened XML Schema
Download



Prototype

Download Schema of Prototype

Detail of below 4 video , please refer to Kenneth's thesis Ch5. Case Study with prototype.
Video 1[0:00]:
create the RDB schema/database in MySQL and insert data. 
Video 1[1:03]:
[Refer to Thesis P.76, Step 1: Transform from relational database into flattened XML document ]
Use the UDB software tranform the RDB database into flatten XML. 
Video 1[3:28]:
[Refer to Thesis P.79, Step 2: Transform from flattened XML document into legacy databases]
Use the UDB software again, transform the flatten XML output to 4 kinds of data file, RDB, XML, OODB, NDB.  

UDB file: testcase_k4_udb.xml
Output RDB file: testcase_k4_udb.sql
Output XML file: testcase_k4_out.xml
Output OODB file: testcase_k4_out.oodb
Output NDB file: testcase_k4_out.ndb with 6 csv file generated





Video 2: [Refer to Thesis P.89, Example 5. Transform from flattened XML documents to relational database ] Verify Output RDB file (testcase_k4_udb.sql) in MySQL.

Video 3[0:00-1:28]: [Refer to Thesis P.79, Data transformation from flattened XML document into XML document ] Verify Output XML file (testcase_k4_out.xml) by Qizx/open. Video 3[1:28]: [Refer to Thesis P.86, Example 4. Transform from flattened XML OUDG into Network database ] Verify Output NDB file (testcase_k4_out.ndb) and 6 csv file by Raima.

Video 4: [Refer to Thesis P.83, Example 3. Transform from flattened XML documents into Object-Oriented databases ] Verify Output OODB file (testcase_k4_out.oodb) by UniSQL.