Physical Database Design: The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More

Description

The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book. The first complete treatment on physical database design, written by the authors of the seminal, Database Modeling and Design: Logical Design, Fourth Edition Includes an introduction to the major concepts of physical database design as well as detailed examples, using methodologies and tools most popular for relational databases today: Oracle, DB2 (IBM), and SQL Server (Microsoft) Focuses on physical database design for exploiting B+tree indexing, clustered indexes, multidimensional clustering (MDC), range partitioning, shared nothing partitioning, shared disk data placement, materialized views, bitmap indexes, automated design tools, and more!

Get the book

Amazon.com

Search the book

eBay.com

Search the book

Similar books

• 

  Physical Database Design Using Oracle

  By Donald K. Burleson

  The evolution of Oracle has led to a revolution in design practices.

• 

  Usage-Driven Database Design: From Logical Data Modeling through Physical Schema Definition

  By George Tillmann

  The design framework in this book can be used to create operational databases for transaction processing systems, or for data warehouses in support of decision support systems.

• 

  A Practical Guide to Database Design

  By Rex Hogan

  Fully updated and expanded from the previous edition, A Practical Guide to Database Design, Second Edition is intended for those involved in the design or development of a database system or application.

• 

  Physical Database Design for SYBASE SQL Server

  By Jean Tabaka, Rob Gillette, Dean Muench

  This is the first in a series of practical guidebooks known as the Sybase Method Set for database developers who are involved in designing and implementing client/server applications in the...

• 

  Automated Physical Database Design and Tuning

  By Nicolas Bruno

  What-if optimization calls can be avoided in some scenarios by inferring costs from previous optimizations of atomic configurations. • INUM and CPQO are techniques that can reoptimize queries ... Automatic physical database tuning: A ...

• 

  Database Modeling and Design

  By Toby J. Teorey

  This work has been revised and updated to provide a comprehensive treatment of database design for commercial database products and their applications.

• 

  Handbook of Data Management: 1999 Edition

  By Sanjiv Purba

  Handbook of Data Management, 1999 Edition is the most comprehensive, single-volume guide of its kind. The book provides the latest, most innovative solutions for planning, developing, and running a powerful data management function.

• 

  Database Life Cycle

  By Open University. Relational Databases: Theory and Practice Course Team

  It presents a simple framework for database development and maintenance.This is a very practical block and will require you to write and execute SQL statements for which you will need access to a computer installed with the course software ...

• 

  Logical Database Design Principles

  By Terry Clark, Jeff Walker, John Garmany

  Logical Database Design Principles reflects these recent changes. The book begins by covering traditional lo

• 

  Conceptual Data Modeling and Database Design: A Fully Algorithmic Approach, Volume 1: The Shortest Advisable Path

  By Christian Mancas

  This new book aims to provide both beginners and experts with a completely algorithmic approach to data analysis and conceptual modeling, database design, implementation, and tuning, starting from vague and incomplete customer requests and ...