DATA WAREHOUSE SCHEMA
One of the key questions
to be answered by the database designer is: How can we design a database that
allows unknown queries to be performant? This question encapsulates the
differences between designing for a data warehouse and designing for an operational
system. In a data warehouse one designs to support the business process
rather than specific query requirements. In order to achieve this, the designer
must understand the way in which the information within the data warehouse will
be used.
In general, the queries
directed at a data warehouse tend to ask questions about
some essential fact,
analyzed in different ways. For example reporting on:
-The
average number of light bulbs sold per store over the past month
-The
top ten most viewed cable-TV programs during the past week
-Top
spending customers over the past quarter
-Customers
with average credit card balances more than Rs.10,000 during the past year.
Each of these queries has
one thing in common: they are all based on factual data. The content and
presentation of the results may differ between examples, but the factual and
transactional nature of the underlying data is the same.
sbobet asia indonesia Read More About News, Trends and Ideas that matter most to Entrepreneurs Visit SnapMunk
