A Comparative Study Between the Performance of Relational & Object Oriented Database in Data Warehousing

摘要

A data warehouse is a repository of subjectively selected and adapted operational data which can successfully answer any ad hoc, statistical, complex or analytical queries. Data warehousing technology is becoming essential for effective business intelligence, business strategy formulation and implementation in a globally competitive environment where in larger and larger amounts of data are required to be processed faster and faster for comprehension of its real meaning and impact. A warehouse is a subjectoriented, integrated, time-variant and non-volatile collection of data in support of management's decision making process”. Data that gives information about a particular subject instead of about a company's ongoing operations. It is integrated as data that is gathered into the data warehouse from a variety of sources and merged into a coherent whole. Data warehouse system is time variant as all data in the data warehouse is identified with a particular time period This paper discusses in detail two existing database models used for data warehousing, the relational database and object oriented database and does an analysis of the benefits of Object Oriented databases over the conventional relational database in Data warehousing.