O'Reilly logo

Practical Business Intelligence: with SQL Server 2005 by Roger Toren, John C. Hancock

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 11 Very Large Data Warehouses

Very large databases (VLDBs) magnify inefficiencies that are unnoticeable in smaller databases into show-stopping issues. Common issues associated with very large amounts of data include problems such as speed of importing data, lengthy backup process, excessive unavailability due to long maintenance processes, lengthy processes to retire unneeded historical data, and poor query performance.

Another issue often associated with large databases is a high rate of growth. Large amounts of new data arriving need high-performance extraction, transformation, and loading (ETL) processing.

Even if your database is not multi-terabytes in size, you may be experiencing some of these problems as your database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required