Building the Data Warehouse

Скачать в pdf «Building the Data Warehouse»


Large amounts of data need to be managed in many ways—through flexibility of addressability of data stored inside the processor and stored inside disk


First technological requirement— the ability to manage volumes of data




О


index


Second technological requirement— to be able to manage multiple media


Third technological requirement— to be able to index and montor data freely and easily


report



Fourth technological requirement— to interface—both receiving data from and passing data to a wide variety of technologies


Figure 5.1 Some basic requirements for technology supporting a data warehouse.


storage, through indexing, through extensions of data, through the efficient management of overflow, and so forth. No matter how the data is managed, however, two fundamental requirements are evident—the ability to manage large amounts at all and the ability to manage it well. Some approaches can be used to manage large amounts of data but do so in a clumsy manner. Other approaches can manage large amounts and do so in an efficient, elegant man-


ner. To be effective, the technology used must satisfy the requirements for both volume and efficiency.


In the ideal case, the data warehouse developer builds a data warehouse under the assumption that the technology that houses the data warehouse can handle the volumes required. When the designer has to go to extraordinary lengths in design and implementation to map the technology to the data warehouse, then there is a problem with the underlying technology. When technology is an issue, it is normal to engage more than one technology. The ability to participate in moving dormant data to overflow storage is perhaps the most strategic capability that a technology can have.

Скачать в pdf «Building the Data Warehouse»