Research Work

Home

Research

This section has information about my research work in an Automated Data Warehouse, which deals with automatic management of data warehouse used for decision support systems. In this I have developed a tool and a framework to help a non technical user to help create, populate and manage a data warehouse. The tools supports creation of data warehouse with minimal information required to be input by the user. The tool provides visual means of mapping the source and target databases in the creation of a data warehouse. 

The framework has been designed in a way that the there can be multiple copies of the warehouse database, where each copy is an image of the warehouse database. When one copy needs to be updated, it is taken offline. Applications that need to access the warehouse database can now access any of the other image warehouses.

Database Switching application is a setup I have built that manages database switching in such a way that even if one of the databases go down, applications will be able to access data from one of the other image databases. The setup updates each of the mirror images at regular intervals. The framework is designed to keep the data warehouse updated in a transparent manner to the data mining applications accessing it.

I have also been involved in Web-based Benchmark data engine being developed at the Computer Science Department, University of New Orleans. The highlight of the website generator is its ability to dynamically generate new websites, based on a number of parameters given by the creator of the website. In effect, even users with a non-technical background can create their own websites in minimum amount of time. To start with, this engine was used for the maritime industry, where several shipping companies can create their own websites. They can also upload their data, for example, data pertaining to performance of ships, life & failure of individual parts, mean time before failure of equipment. 

Automated Data Warehouse
SagaMap - A tool for Semi Automatic Schema Generation And Mapping

Database Switcher
Working diagram of the Database Switcher