Oracle DBA Guide to Data Warehousing and Star Schemas

Oracle DBA Guide to Data Warehousing and Star Schemas, 9780130325846 (0130325848), Prentice Hall, 2003

Oracle DBAs finally have a definitive guide to every aspect of designing, constructing, tuning, and maintaining star schema data warehouses with Oracle 8i and 9i. Bert Scalzo, one of the world's leading Oracle data warehousing experts, offers practical, hard-won lessons and breakthrough techniques for maximizing performance, flexibility, and manageability in any production environment. Coverage includes:

Data warehousing fundamentals for DBAs--including what a data warehouse isn't
Planning software architecture: business intelligence, user interfaces, Oracle versions, OS platforms, and more
Planning hardware architecture: CPUs, memory, disk space, and configuration
Radically different star schema design for radically improved performance
Tuning ad-hoc queries for lightning speed Industrial-strength data loading techniques
Aggregate tables: maximizing performance benefits, minimizing complexity tradeoffs
Improving manageability: The right ways to partition
Data warehouse administration: Backup/recovery, space and extent management, updates, patches, and more

Comments

Amazing Books

Fundamentals of SVG Programming : Concepts to Source Code (Graphics Series)

Charles River, 2003

Fundamentals of SVG Programming: Concepts to Source Code is a comprehensive guide to the core concepts of SVP programming, including the coordinate systems, color gradients, grid patterns, Bezier curves, transforms, charts, graphs, and more. Written for those new to SVG, this book does an excellent job of “marrying” SVG to...

Killer UX Design

SitePoint Pty Ltd, 2012

When I embarked on my career as a psychologist, I never imagined I’d end up designing technology products and services. Funny where you end up in life, and lucky for me all those years at university weren’t wasted: the business of understanding humans and the way they behave is critical to designing....

Formulas and Functions with Microsoft Excel 2003

Que, 2004

The world of mathematical formulas and jargon in Microsoft Excel is complex and can be intimidating for even advanced computer users. Perhaps like you, a majority of users find it difficult to get the most they can out of this very valuable program. Formulas and Functions with Microsoft Excel 2003 strives to break down the complexities...

Animation with Scripting for Adobe Flash Professional CS5 Studio Techniques

Adobe Press, 2010

The definitive guide to creating animation for the web and mobile devices with top animation designer Chris Georgenes and designer/developer Justin Putney. They reveal how to create and successfully animate characters in Adobe Flash Professional CS5 and how to push the limits of timeline animation with stunning visual effects using...

Microsoft Word 2010: Illustrated Complete (Illustrated Series: Individual Office Applications)

Cengage Learning, 2010

Loved by instructors for its visual and flexible way to build computer skills, the Illustrated Series is ideal for teaching Microsoft Office Word 2010 to both computer rookies and hotshots. Each two-page spread focuses on a single skill, making information easy to follow and absorb. Large, full-color illustrations represent how the...

Handbook of Networks in Power Systems I (Energy Systems)

Springer, 2012

Energy has been an inevitable component of human lives for decades. Recent rapid developments in the area require analyzing energy systems not as independent components but rather as connected interdependent networks. The Handbook of Networks in Power Systems includes the state-of-the-art developments that occurred in the power systems...