Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (The Morgan Kaufmann Series in Data Management ... Kaufmann Series in Data Management Systems)

eBook Information

Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (The Morgan Kaufmann Series in Data Management ... Kaufmann Series in Data Management Systems) ISBN  0123693896 Release Date  21 March 2007 Category  Databases Tags  database,   0123693896,   storage,   physical,   exploit,   index,   "physical database design",   exploiting,   morgan kaufman,   design pattern,   kaufmann,   "data management systems",   This book @Amazon  View Tools Google Search Web flazx.com

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, 4th 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! Other books on Databases Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL (The Morgan Kaufmann Series in Data Management Systems) Handbook of Database Security: Applications and Trends Database Programming Languages: 11th International Symposium, DBPL 2007, Vienna, Austria, September 23-24, 2007, Revised Selected Papers (Lecture Notes in Computer Science) The Berkeley DB Book (Books for Professionals by Professionals) Architecture of a Database System Data Modeling Fundamentals: A Practical Guide for IT Professionals Database System Concepts Applied Mathematics for Database Professionals (Expert's Voice) Contemporary Issues in Database Design and Information Systems Development (Advances in Database Research Series) (Advances in Database Research Series) Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (The Morgan Kaufmann Series in Data Management ... Kaufmann Series in Data Management Systems) Databases and Information Systems IV: Selected Papers from the Seventh International Conference DB&IS'2006 - Volume 155 Frontiers in Artificial Intelligence and Applications Data Lifecycles: Managing Data for Strategic Advantage IBM DB2 9 New Features Beginning Database Design: From Novice to Professional Stream Data Management (Advances in Database Systems)