Real-time data warehouse simulator

• Main Author: Husain Abbas Bhavnagarwala.
• Other Authors: Vivekanand Gopalkrishnan
• Format: Final Year Project
• Language: English
• Published: 2009
• Subjects: DRNTU::Engineering::Computer science and engineering::Information systems::Database management
• Online Access: http://hdl.handle.net/10356/18990
• Institution: Nanyang Technological University

A data warehouse is a repository of data used by companies for decision support. In today’s fast-paced business world where information is ever changing, real-time decision support is essential to ensure companies make the right decisions regarding its business. This brings the need for the data warehouse to be updated in real-time. As updates are continuously sent to the data warehouse, methods to update it and retrieve data from it have to accommodate either loss in quality of data or delay in the retrieval of data. Developers continue to improve these methods to allow efficient real-time updates and querying. This report describes the process to develop a tool which allows programmers to test their methods against several simulated data warehouse schemas and query sets and benchmark their methods against others. The schemas and query sets will take into consideration the real-time effects of updates. The tool will allow methods for Query Scheduling, Indexing and View Maintenance to be tested. The users, after running the tool will be presented a detailed result of the Quality of Service and Quality of Data provided by their methods. This report explains in detail the software development life cycle model used to develop the tool, the inputs required, the methodology of the tool and the output generated.