Please use this identifier to cite or link to this item:
Title: Real-time data warehouse simulator
Authors: Husain Abbas Bhavnagarwala.
Keywords: DRNTU::Engineering::Computer science and engineering::Information systems::Database management
Issue Date: 2009
Abstract: 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.
Rights: Nanyang Technological University
Fulltext Permission: restricted
Fulltext Availability: With Fulltext
Appears in Collections:SCSE Student Reports (FYP/IA/PA/PI)

Files in This Item:
File Description SizeFormat 
Husain Abbas Bhavnagarwala.pdf
  Restricted Access
789.07 kBAdobe PDFView/Open

Page view(s) 50

Updated on Nov 25, 2020

Download(s) 50

Updated on Nov 25, 2020

Google ScholarTM


Items in DR-NTU are protected by copyright, with all rights reserved, unless otherwise indicated.