Data warehousing for the busy DBA
Part 2: What a data warehouse isn’t
Many data requirements can be fulfilled without going to the trouble of a data warehouse. In some cases the requirements are in conflict with the main requirements of a data warehouse system.
Data warehouses are not real-time systems
Real-time data warehousing is almost never a genuine requirement. Real-time analytic and aggregate reporting requirements are actually quite rare with very few exceptions. There are two very good reasons not to implement a real-time system unless you really need it: more »