Physical Database Design: the database professional's gui... and thousands of other textbooks are available for instant download on your Kindle Fire tablet or on the free Kindle apps for iPad, Android tablets, PC or Mac.
Qty:1
  • List Price: $65.95
  • Save: $9.19 (14%)
In Stock.
Ships from and sold by Amazon.com.
Gift-wrap available.
Add to Cart
FREE Shipping on orders over $35.
Used: Good | Details
Sold by RentU
Condition: Used: Good
Comment: Fast shipping from Amazon! Qualifies for Prime Shipping and FREE standard shipping for orders over $35. Overnight, 2 day and International shipping available! Excellent Customer Service.. May not include supplements such as CD, access code or DVD.
Access codes and supplements are not guaranteed with used items.
Add to Cart
Trade in your item
Get a $10.49
Gift Card.
Have one to sell? Sell on Amazon
Flip to back Flip to front
Listen Playing... Paused   You're listening to a sample of the Audible audio edition.
Learn more
See this image

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

ISBN-13: 978-0123693891 ISBN-10: 0123693896 Edition: 4th

Buy New
Price: $56.76
22 New from $26.90 22 Used from $23.55
Rent from Amazon Price New from Used from
eTextbook
"Please retry"
$18.63

Free%20Two-Day%20Shipping%20for%20College%20Students%20with%20Amazon%20Student



Frequently Bought Together

Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more (The Morgan Kaufmann Series in Data Management Systems) + Database Modeling and Design, Fifth Edition: Logical Design (The Morgan Kaufmann Series in Data Management Systems) + SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)
Price for all three: $126.58

Buy the selected items together

NO_CONTENT_IN_FEATURE
Shop the new tech.book(store)
New! Introducing the tech.book(store), a hub for Software Developers and Architects, Networking Administrators, TPMs, and other technology professionals to find highly-rated and highly-relevant career resources. Shop books on programming and big data, or read this week's blog posts by authors and thought-leaders in the tech industry. > Shop now

Product Details

  • Series: The Morgan Kaufmann Series in Data Management Systems
  • Paperback: 448 pages
  • Publisher: Morgan Kaufmann; 4th edition (April 4, 2007)
  • Language: English
  • ISBN-10: 0123693896
  • ISBN-13: 978-0123693891
  • Product Dimensions: 1.1 x 7.4 x 9.1 inches
  • Shipping Weight: 2 pounds (View shipping rates and policies)
  • Average Customer Review: 3.2 out of 5 stars  See all reviews (5 customer reviews)
  • Amazon Best Sellers Rank: #886,272 in Books (See Top 100 in Books)

Editorial Reviews

Review

I highly recommend Physical Database Design by Lightstone, Teorey, and Nadeau. The book covers fine aspects of physical design -- issues such as the effects of different approaches to indexes, tradeoffs in materializing views, and details of physical data layout. Unlike other books, it does not focus on a particular product, but instead covers the deep principles that cut across products. The book addresses both transaction intensive applications (OLTP) as well as data warehouses (OLAP). Their new book is a welcome addition to the literature.
--Michael Blaha, OMT Associates, Inc.

This is an excellent book on physical database design, giving pragmatic models and advice. It has a wealth of information for both the student and for the practitioner -- presenting analytic models and practical tips that are demonstrated with examples using Oracle, DB2, and Microsoft SQL Server.
--Jim Gray, Microsoft Research

From the Back Cover

I highly recommend Physical Database Design by Lightstone, Teorey, and Nadeau. The book covers fine aspects of physical design -- issues such as the effects of different approaches to indexes, tradeoffs in materializing views, and details of physical data layout. Unlike other books, it does not focus on a particular product, but instead covers the deep principles that cut across products. The book addresses both transaction intensive applications (OLTP) as well as data warehouses (OLAP). Their new book is a welcome addition to the literature.
--Michael Blaha, OMT Associates, Inc.

This is an excellent book on physical database design, giving pragmatic models and advice. It has a wealth of information for both the student and for the practitioner -- presenting analytic models and practical tips that are demonstrated with examples using Oracle, DB2, and Microsoft SQL Server.
--Jim Gray, Microsoft Research

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.

Features
" 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!

More About the Authors

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

3.2 out of 5 stars
5 star
0
4 star
3
3 star
0
2 star
2
1 star
0
See all 5 customer reviews
Share your thoughts with other customers

Most Helpful Customer Reviews

23 of 23 people found the following review helpful By Data Guy on August 6, 2007
Format: Paperback
This book fills a gap in the marketplace that has needed to be filled for some time now. Oh, there are a lot of good books on each individual DBMS and there are some very good books on logical database design and data modeling. But until now, there has not been a good book that provides a comprehensive treatment of the physical side of database design from a DBMS agnostic perspective.

Actually, the last book that I can recall to tackle the subject well was Handbook of Relational Database Design by Fleming and von Halle (Addison-Wesley, ISBN 0-201-11434-8); but that book was published way back in 1989 and it is a bit long in the tooth.

Physical Database Design is co-authored by three database design experts: Sam Lightstone, Toby Teorey, and Tom Nadeau. Lightstone is a Senior Technical Staff Member and Development Manager with IBM's DB2 product development team. Teorey is a professor emeritus in the Electrical Engineering and Computer Science Department and Director of Academic Programs in the College of Engineering at the University of Michigan, Ann Arbor. And Nadeau is the founder of Aladdin Software and works in the area of data and text mining. So it is no surprise that the book has a solid technical foundation.

The book offers comprehensive coverage of how to design the physical structures and environment for the most popular database management systems. After reading Physical Database Design you will come away with a better understanding of how the choices you make during physical design affect the performance of your systems. The specific examples, guidelines, and best and worst practices included by the authors are instructive and enlightening, as well as being helpful across the spectrum of popular DBMSs.
Read more ›
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
3 of 4 people found the following review helpful By Jason Short on April 27, 2008
Format: Paperback Verified Purchase
This is NOT a book for people looking to learn SQL, or some other dialect of a database. It is a data centric design book on the low level parts of those database engines you currently use.

Did you ever wonder WHY heap files and B-Tree files are used in databases? This is the book to give you the why behind a lot of the lower level design decisions in databases today.

I enjoyed the why discussion of almost all of the topics, but it left me feeling a little light on the implementation. There is not much in the way of practical discussion in the book. While a discussion about index types is very well thought out it never completes the thought from an implementation standpoint. I was actually left with a lot more questions to low level implementation than I started. When to use one of these algorithms is totally left as an excercise to the reader. And in many cases the actual algorithm itself is also left to you to research. I guess they are outside the scope of the book, but I would have enjoyed it so much more with some simple pseudocode or a sample project concept to put them to use.

The book is a great reference to get you thinking about the lowest level of database implementation and make you really think about the way in which SQL Server, DB2, etc all work. But you are not left with a lot of substance on why one implementation would be better than the other for your specific application or problem domain.
2 Comments Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
Format: Paperback Verified Purchase
This book starts with an overview of where in the overall database life cycle physical database design stands.

Basic indexing methods such as the all too common B+tree, hash table and bitmap are addressed, differences and benefits explained. Index selection methods and trade-offs are assessed in a sensible way. A useful set of rules of thumb on indexing is provided as well.

Next come partitioning and clustering techniques such as shared-nothing and hash range partitioning and MDC (Multi Dimensional Clustering). Pros and cons are provided and explained. Sound examples that illustrate the usage combinations of indexing, partitioning and clustering techniques are given.

Query optimization, plan selection and execution aspects are addressed with focus on where the indexing, partitioning and clustering techniques previously discussed fit in and on how physical design can be improved by selecting the right plan.

There is a chapter on automated database physical design that, although it does not focus much on a particular product, gives an overview of the way IBM DB2 Design Advisor, MS SQL Server Database Tuning Advisor and Oracle SQL Access Advisor handle tunings and optimizations.

Server topology, hardware aspects like CPU, memory, storage systems, performance aspects and their impacts are addressed as well.
The last two chapters are, respectively, about performance improvements through denormalization and specifics of distributed database allocation.

Here we have a useful book that covers the main aspects of physical database design and thoroughly discusses them. The book content is accessible to someone having - at least - basic database knowledge, although I found not all parts of it are easy to grasp.
Read more ›
1 Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again
1 of 4 people found the following review helpful By Alexey Timanovsky on December 29, 2009
Format: Paperback Verified Purchase
As other reviewer I bought the book because of recommendation. I must admit though, I haven't read it through, just spotted few chapters. While Table of Contents looks impressive actual filling is not of highest quality. For example introduction paragraph on Indexes is so vague and misleading that were I still a student knowing nothing about RDBMS I would understand nothing. It introduces UNIQUE indexes and then basically declares it is the same as ORDERED index. Description of non-unique indexes is cryptic. Statement on performance of multi-column indexes is not correct at best. I'm not saying that main chapters on indexes are bad, but this introduction is just a disaster.

RAID. Useless chapter, how you can pretend you are explaining RAID, and giving advice on what to use for RDBMS without providing comparison of protection level, overhead, R/W performance of different configurations?! The book is called "Physical database design" let me remind you.

I'm sure there should be something valuable in this book, I just haven't got to it yet.
Comment Was this review helpful to you? Yes No Sending feedback...
Thank you for your feedback. If this review is inappropriate, please let us know.
Sorry, we failed to record your vote. Please try again

Customer Images

Search

What Other Items Do Customers Buy After Viewing This Item?