data warehouse |
What is data warehouse?
A data warehouse is a relational database that is designed
for query and analysis rather than for transaction processing. It
usually contains historical data derived from transaction data, but it
can include data from other sources. It separates analysis workload from
transaction workload and enables an organization to consolidate data
from several sources.
In addition to a relational database, a data warehouse
environment includes an extraction, transportation, transformation, and
loading (ETL) solution, an online analytical processing (OLAP) engine,
client analysis tools, and other applications that manage the process of
gathering data and delivering it to business users.
0 comments:
Post a Comment