It is of course important to be able to write queries, but it is equally important to know how they are processed. We need a sense of how hard is it to write a disk cache or logging facility.
And what exactly is a database driver, anyway? The first two chapters provide a brief overview of database systems and their use. Chapter 1 discusses the purpose and features of a database system and introduces the Derby and SimpleDB systems.
Chapter 2 explains how to write a database application using Java. In turn, Chapters examine the internals of a typical database engine. Each chapter covers a different database component, starting with the lowest level of abstraction the disk and file manager and ending with the highest the JDBC client interface ; further, the respective chapter explains the main issues concerning the component, and considers possible design decisions.
As a result, the reader can see exactly what services each component provides and how it interacts with the other components in the system. The remaining four chapters then focus on efficient query processing, and focus on the sophisticated techniques and algorithms that can replace the simple design choices described earlier.
Topics include indexing, sorting, intelligent buffer usage, and query optimization. This text is intended for upper-level undergraduate or beginning graduate courses in Computer Science. Conceptual and programming exercises are also included at the end of each chapter. Students can apply their conceptual knowledge by examining the SimpleDB a simple but fully functional database system created by the author and provided online code and modifying it.
Database Systems: A Pragmatic Approach is a classroom textbook for use by students who are learning about relational databases, and the professors who teach them. It discusses the database as an essential component of a software system, as well as a valuable, mission critical corporate resource. The book is based on lecture notes that have been tested and proven over several years, with outstanding results. The ebook includes the main techniques in these areas with broader coverage of query optimization than most other versions, together with advanced topics including distributed transactions, multidimensional and bitmap indexes, and information integration techniques.
No access codes are included. Save my name, email, and website in this browser for the next time I comment. Notify me of new posts by email. If you're interested in creating a cost-saving package for your students, contact your Pearson rep. We're sorry! We don't recognize your username or password. Please try again. The work is protected by local and international copyright laws and is provided solely for the use of instructors in teaching their courses and assessing student learning. You have successfully signed out and will be required to sign back in should you need to download more resources.
Ullman, Stanford University Jennifer Widom. If you're an educator Request a copy Buy this product Alternative formats.
If you're a student Buy this product Alternative formats. Overview Resources Formats Overview. Description For Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments.
0コメント