Physical Database Design

Physical Database Design
Author :
Publisher : Morgan Kaufmann
Total Pages : 449
Release :
ISBN-10 : 9780080552316
ISBN-13 : 0080552315
Rating : 4/5 (16 Downloads)

Book Synopsis Physical Database Design by : Sam S. Lightstone

Download or read book Physical Database Design written by Sam S. Lightstone and published by Morgan Kaufmann. This book was released on 2010-07-26 with total page 449 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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!


Physical Database Design Related Books

Physical Database Design
Language: en
Pages: 449
Authors: Sam S. Lightstone
Categories: Computers
Type: BOOK - Published: 2010-07-26 - Publisher: Morgan Kaufmann

DOWNLOAD EBOOK

The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under gr
Physical Database Design Using Oracle
Language: en
Pages: 264
Authors: Donald K. Burleson
Categories: Computers
Type: BOOK - Published: 2004-07-27 - Publisher: CRC Press

DOWNLOAD EBOOK

The evolution of Oracle has led to a revolution in design practices. For Oracle 10g, database physical structures have become more complex than ever before and
Oracle Design: The Definitive Guide
Language: en
Pages: 558
Authors: Dave Ensor
Categories: Computers
Type: BOOK - Published: 1997 - Publisher: "O'Reilly Media, Inc."

DOWNLOAD EBOOK

This book focuses exclusively on Oracle database design. It covers the most up-to-date Oracle issues and technologies, including massively parallel processors,
Oracle SQL Developer Data Modeler for Database Design Mastery
Language: en
Pages: 338
Authors: Heli Helskyaho
Categories: Computers
Type: BOOK - Published: 2015-05-22 - Publisher: McGraw Hill Professional

DOWNLOAD EBOOK

Design Databases with Oracle SQL Developer Data Modeler In this practical guide, Oracle ACE Director Heli Helskyaho explains the process of database design usin
Database Design and Implementation
Language: en
Pages: 458
Authors: Edward Sciore
Categories: Computers
Type: BOOK - Published: 2020-02-27 - Publisher: Springer Nature

DOWNLOAD EBOOK

This textbook examines database systems from the viewpoint of a software developer. This perspective makes it possible to investigate why database systems are t