Data Warehouse
In computing, a data warehouse (DW or DWH), also known as an
enterprise data warehouse (EDW), is a system used for reporting and data
analysis. DWs are central repositories of integrated data from one or more
disparate sources. They store current and historical data and are used for
creating analytical reports for knowledge workers throughout the enterprise.
Examples of reports could range from annual and quarterly comparisons and
trends to detailed daily sales analyses.
Data Mart
A data mart is a simple form of a data warehouse that is
focused on a single subject (or functional area), such as sales, finance or
marketing. Data marts are often built and
controlled by a single department within an organization. Given their
single-subject focus, data marts usually draw data from only a few sources. The
sources could be internal operational systems, a central data warehouse, or
external data. De-normalization is the norm for data modeling techniques in this
system.
No comments:
Post a Comment