R & D Summary

    OpenDWS - Open Data Warehousing Suite

OpenDWS started as InterBase DataWarehouse Builder (IB-DWB), a prototype of a data warehouse builder for Borland InterBase 6 Open Edition that I've worked on for my Advanced Diploma in Computing project.

Currently, this project is back onto the drawing board for re-designing with the following aims in mind:

• The source databases can be heterogeneous (not tied to a specific database management system)

• Distributed deployment (a single installation of OpenDWS can span multiple hardware systems)

• Ad hoc distributed processing (ability to use multiple ad hoc hardware for computation tasks)

• Plug-in system for analysis and processing features

Annotated Publications from this project

Ling, MHT and So, CW. 2003. Architecture of an Open-Sourced, Extensible Data Warehouse Builder: InterBase 6 Data Warehouse Builder (IB-DWB). In Rubinstein, B. I. P., Chan, N. & Kshetrapalapuram, K. K. (Eds.), Proceedings of the First Australian Undergraduate Students' Computing Conference. (pp. 40-45). [Abstract] [PDF]

This manuscript describes the prototyping of IB-DWB.

Ling, MHT. 2007. Firebird Database Backup by Serialized Database Table Dump. The Python Papers 2 (1): 12-16. [Abstract] [PDF]

This manuscript demonstrated the use of kinterbasdb, a DB-API 2.0 compliant library, to extract and insert data table-by-table which is useful to recover corrupt database file or backing up only specific data tables.