Choosing Microsoft SQL SERVER 2005 For Data Warehousing
The warehousing of corporate data into an architecture from which it can all be accessed is no longer an option for midmarket and large companies that want to be successful. Consolidating the information so that it is readily accessible, and to give the team visibility for reporting, analytics, spot queries, and predictive capabilities is now necessary. Fortunately, pioneers established this long ago and this requirement is met in the field of data warehousing (DW) and business intelligence (BI). There is a lot more to achieving information access than simply copying data from one system to another. Data warehouses are now the major use of database management systems.