Database Design And Implementation

This book takes software developers through database systems while covering the traditional database system concepts from a systems perspective. The chapters are organized according to the components of a database, starting from low–level disk access and ending at the query planner.

A software developer’s hands–on guide to database systems

Combining an eminently readable style with a practical approach, Edward Sciore’s Database Design and Implementation introduces you to database systems from a software developer’s perspective. In its pages, you will learn how to use a database and how to develop one of your own.

Organized according to the components of a database, Database Design and Implementation takes you through database systems concepts from low–level disk access all the way to the query planner. Presenting only the essential algorithms and techniques that most clearly illustrate the issues discussed, the book covers such topics as data design and manipulation; integrity and security; memory and record management; metadata; query processing and optimization; integrity and security; indexing, and more.

As you proceed through the chapters and numerous exercises, you’ll learn:

• How to build database applications in Java
• JDBC, JPA, XML, and Servlet development
• The internals of a database server
• Sophisticated techniques for indexing, sorting, intelligent buffer usage, and query optimization

Best of all, this book includes a simple but fully functional database system, SimpleDB, that enables you to apply your conceptual knowledge by examining and modifying the code. With numerous hands–on exercises and such tools as SimpleDB, Database Design and Implementation will give the self–studier as well as the traditional student an ideal introduction to the world of database systems.

∗ Covering the traditional database system concepts from a systems perspective, this book addresses the functionality that database systems provide as well as what algorithms and design decisions will best implement their functionality
∗ Describes what Java tools and techniques will best help developers build an application that uses a database system
∗ Contains a fully functional database system that allows readers to examine and modify the code