The purpose of this 3 page paper is to discuss , views regarding data
warehousing and data mining or knowledge discovery in databases. Discuss
the role of the database administration and the issues of cost/benefit for these
types of endeavors in organizations.
A data warehouse is a repository storing integrated information for efficient
querying and analysis. Information is extracted from heterogeneous sources
as it is generated or updated
A Data Warehouse on the other end, is a database that is designed for
facilitating querying and analysis. Often designed as OLAP (On-Line
Analytical Processing) systems, these databases contain read-only data that
can be queried and analysed far more efficiently as compared to your regular
OLTP application databases. In this sense an OLAP system is designed to be
read-optimized.
This solution describes features and advantages of data warehousing and data mining in terms of cost/benefit and also examines the role of database administration.