Database Systems: The Complete Book In book: Hector Garcia-Molina and Jeffrey D. Ullman and Jennifer Widom, Publisher: Prentice Hall. Database Systems: The Complete Book. Hector Garcia-Molina. Jeffrey D. Ullman. Jennifer Widom. Department of Computer Science. Stanford University. Database systems: the complete book / Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom Garcia-Molina, Hector. View online; Borrow · Buy.
|Published (Last):||13 May 2013|
|PDF File Size:||8.45 Mb|
|ePub File Size:||9.43 Mb|
|Price:||Free* [*Free Regsitration Required]|
This item has been replaced by Database Systems: The Complete Book, 2nd Edition. For Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments. Written by well-known computer scientists, this introduction to database systems offers a comprehensive approach, focusing on database design, database use, and implementation of database applications and database management systems.
The first half of the book provides in-depth coverage of databases from the point of view of the database designer, user, and application programmer. It covers the latest database standards SQL: The second half of the book provides in-depth coverage of databases from the point of view of the DBMS implementor.
It focuses on storage structures, query processing, and transaction management. The book covers the main techniques in these areas with broader coverage of query optimization than most other texts, along with advanced topics including multidimensional and bitmap indexes, distributed transactions, and information integration techniques.
This product is part of the following series. Click on a series title to see the full list of products in the series. Provides students with the opportunity to practice and apply the concepts they’ve learned in each chapter. Each chapter concludes with Summary and References sections. The Worlds of Database Systems. The Evolution of Database Systems.
Overview of a Database Management System. Outline of Database-System Studies. The Modeling dagabase Constraints. Basics of the Relational Model. Converting Subclass Structures to Relations.
Rules About Functional Dependencies.
IS 257: Database Management
Design of Relational Database Schemas. Review of Object-Oriented Concepts. An Example Database Schema. An Algebra of Relational Operations. Relational Operations on Bags.
Database Systems: The Complete Book
Extended Operators of Relational Algebra. Simple Queries in SQL.
Keys and Foreign Keys. Constraints on Attributes and Tuples. Schema-Level Constraints and Triggers. SQL in a Programming Environment.
Procedures Stored in the Schema. Using a Call-Level Interface. Databasw on Object-Relational Data. A Logic for Relations. From Relational Algebra to Datalog. Recursive Programming in Datalog. Using Secondary Storage Effectively. Accelerating Access to Secondary Storage. Recovery from Disk Crashes. Data Elements and Fields. Representing Block and Record Addresses.
Variable-Length Data and Records. Indexes on Sequential Files. Applications Needing Multiple Dimensions.
Database Systems: The Complete Book
Hash-Like Structures for Multidimensional Data. Tree-Like Structures for Multidimensional Data.
Introduction to Physical-Query-Plan Operators. One-Pass Algorithms for Database Operations. Two-Pass Algorithms Based on Sorting. Two-Pass Algorithms Based on Hashing. Parallel Algorithms for Relational Operations. Algebraic Laws for Improving Query Plans. Estimating the Cost of Operations. Introduction to Cost-Based Plan Selection. Choosing an Order for Joins. Issues and Models for Resilient Operation. Protecting Against Media Failures. Serial and Serializable Schedules.
Enforcing Serializability by Locks. An Architecture for a Locking Scheduler. Managing Hierarchies of Database Elements.
IS Database Management
Concurrency Control by Timestamps. Concurrency Control by Validation. Modes of Information Integration. Wrappers in Mediator-Based Systems.
Capability-Based Optimization in Mediators. Pearson offers special pricing when you package your text with other student resources. If you’re interested in creating a cost-saving package for your students, contact your Pearson rep. His research interests include data mining, information integration, and electronic education. Her research interests include query processing on data streams, data caching and replication, semistructured data and XML, and data warehousing.
She is a former Guggenheim Fellow and has served on numerous program committees, advisory boards, and editorial boards. His research interests include digital libraries, information integration, and database application on the Internet.
We don’t recognize your username or password. 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.
Hector Garcia-Molina Jeffrey D. Ullman, Stanford University Jennifer D. Description For Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments.
Series This product is part of the following series. With its innovative underlying technology, Gradiance turns basic homework assignments and programming labs into true learning experiences for students. Offers a readable and engaging presentation. Teaches about this important first step of the planning process.
Provides a more extensive treatment of query processing than other books on the market. Gives students practical advice on integrating state-of-the-art technologies with databases. Coverage of advanced issues important to database designers and users. Includes discussions of views, integrity constraints, assertions, triggers, transactions, authorization, and recursion in SQL: Discussions of how to successfully plan a database application before building it.
Reflects how these plans are developed in the real world. Coverage of topics such as designing storage structures and implementing a variety of indexing schemes. Shows students how to build efficient database management systems. Extensive coverage of query processing and optimization. Shows students how to fine tune database systems to improve performance.
Comprehensive coverage of transaction processing mechanisms for concurrency control and recovery, including distributed and long-duration transactions. Shows how to design complex database systems that can handle real-world business applications. Coverage of information integration, including data warehousing, mediation, OLAP, data-cube systems, and data mining. Exposes readers to cutting edge technology used in business applications. Extensive exercises —In almost every section.