Sunday, September 27, 2009

ORACLE AND DATAWAREHOUSE

The Oracle (commonly referred to as Oracle RDBMS or simply Oracle) consists of a relational database management system(RDBMS) produced and marketed by Oracle Corporation. As of 2008, Oracle had become a major presence in database computing

Data warehouse is a repository of an organization's electronically stored data. Data warehouses are designed to facilitate reporting and analysis.

This definition of the data warehouse focuses on data storage. However, the means to retrieve and analyze data, to extract, transform and load data, and to manage the data dictionary are also considered essential components of a data warehousing system. Many references to data warehousing use this broader context. Thus, an expanded definition for data warehousing includes business intelligence tools, tools to extract, transform and load data into the repository, and tools to manage and retrieve metadata.

In contrast to data warehouses are operational systems which perform day-to-day Transaction Procesing.

0 comments:

Post a Comment