Expert Indexing in Oracle Database 11g is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the …

SQL is full of difficulties and traps for the unwary. You can avoid them if you understand relational theory, but only if you know how to put the theory into practice. In this insightful book, author C.J. Date explains relational theory in depth, and demonstrates through numerous examples and exercises …

Database systems and database design technology have seen significant changes in recent years. The relational data model and relational database systems dominate applications; in turn, they are extended by other technologies like data warehousing, OLAP, and data mining. Businesses are expanding and require well-constructed databases to track their new and …

This book is about POSTGRESQL, the most advanced open source database. From its origins in academia, POSTGRESQL has moved to the Internet with explosive growth. It is hard to believe the advances during the past four years under the guidance of a team of worldwide Internet developers. This book is …

Hands-On Database uses a scenario-based approach that shows readers how to build a database by providing them with the context of a running case throughout each step of the process. Who Needs a Database?; Gathering Information; Requirements and Business Rules; Database Design; Normalization and Design Review; Physical Design; SQL; Is …

In addition to Code First, EF 4.1 introduces simpler EF coding patterns with the DbContext, DbSet, ChangeTracker and Validation APIs. This second mini-book will take the reader on a tour of these new features and how to take advantage of them. These new classes and APIs let the user focus …

Stuck with bugs, performance problems, crashes, data corruption, and puzzling output? If you’re a database programmer or DBA, they’re part of your life. The trick is knowing how to quickly recover from them. This unique, example-packed book shows you how to handle an array of vexing problems when working with …

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz’s book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment.  You’ll learn about PeopleSoft’s Internet architecture and …

This cookbook is full of immediately useable recipes showing you how to develop service and message-oriented (integration) applications on the Oracle Service Bus. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, the explanations go into great detail, which makes it good …

What would happen if you optimized a data store for the operations application developers actually use? You’d arrive at MongoDB, the reliable document-oriented database. With this concise guide, you’ll learn how to build elegant database applications with MongoDB and PHP. Written by the Chief Solutions Architect at 10gen—the company that …