What is more’s law
As time passes process speed increases but value decreases
Why dataware house required
Data sets are increasing
What is complex question
Join multiple tables but do not use primary keys in complex questions/queries
What are intelligent enterprises
The companies who uses complex questions
What is dataware house
A body that contains complete repository of historical corporate data extracted from transaction systems that is available for ad-hock access by knowledge workers.
What is ad-hock queries
Queries created at run time
What are knowledge workers
Decision makers
In which situations, data removed in dataware house
- Data old or hard to store