This text provides an introduction to data warehousing, including a description of what it is, the business rationales that will secure essential management buy-in, and how to build an effective data warehousing management team. It gives step-by-step guidance on setting up a data warehouse with Oracle, and provides tips, tricks and techniques on how to make it an effective business tool. Included are discussion of tecnical decisions needed to be made such as choosing RAID technology; running the cost-based optimizer; using read-only tablespaces; warehouse refresh mechanisms; and backup and recovery considerations. It also shows how to convert a legacy system into an Oracle data warehouse and get information on version 7.3's new data warehousing features.
Sprache
Verlagsort
Verlagsgruppe
McGraw-Hill Education - Europe
Zielgruppe
Illustrationen
Maße
Höhe: 232 mm
Breite: 189 mm
Gewicht
ISBN-13
978-0-07-882242-1 (9780078822421)
Copyright in bibliographic data is held by Nielsen Book Services Limited or its licensors: all rights reserved.
Schweitzer Klassifikation
What is a data warehouse?; the business case for building data warehouse; building the team roles and responsibilities; how do I manage a project?; the right design approach; the transformation process - moving it and grooming it; how to sell it to your customers - end users; building the data marts; now that I have a data mart, how do I get at it?; rolling it out; picking an appropriate hardware platform; RAID - do I need it? What is it?; backup/recovery - keeping your data warehouse safe; optimizing your data warehouse access.
