Database Systems

Database Systems: The Complete Book is ideal for Database Systems and Database Design and Application courses offered at the junior, senior and graduate levels in Computer Science departments. A basic understanding of algebraic expressions and laws, logic, basic data structure, OOP concepts, and programming environments is implied.

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:1999, SQL/PSM, SQL/CLI, JDBC, ODL, and XML, with broader coverage of SQL than most other texts. 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.

(Pearson)

Bli först med att recensera och betygsätt boken Database Systems - du kan vinna 200 kr varje månad i tävlingen "Månadens recension".

Hector Garcia-Molina is the L. Bosack and S. Lerner Professor of Computer Science and Electrical Engineering at Stanford University. His research interests include digital libraries, information integration, and database applications on the Internet. He was a recipient of the SIGMOD Innovations Award and a member of PITAC (President's Information-Technology Advisory Council). He currently serves on the Board of Directors of Oracle Corp. Jeffrey D. Ullman is the Stanford W. Ascherman Professor of Computer Science (emeritus) at Stanford University. He is the author or co-author of 16 books, including Elements of ML Programming (Prentice Hall 1998). His research interests include data mining, information integration, and electronic education. He is a member of the National Academy of Engineering, and recipient of a Guggenheim Fellowship, the Karl V. Karlstom Outstanding Educator Award, the SIGMOD Contributions and Edgar F. Codd Innovations Awards, and the Knuth Prize. Jennifer Widom is Professor of Computer Science and Electrical Engineering at Stanford University. Her research interests span many aspects of nontraditional data management. She is an ACM Fellow and a member of the National Academy of Engineering, she received the ACM SIGMOD Edgar F. Codd Innovations award in 2007 and was a Guggenheim Fellow in 2000, and she has served on a variety of program committees, advisory boards, and editorial boards.

(Pearson)

                 TABLE OF CONTENTS

 

1 The Worlds of Database Systems

      1.1 The Evolution of Database Systems

            1.1.1 Early Database Management Systems

            1.1.2 Relational Database Systems

            1.1.3 Smaller and Smaller Systems

            1.1.4 Bigger and Bigger Systems

            1.1.5 Information Integration

      1.2 Overview of a Database Management System

            1.2.1 Data-Definition Language Commands

            1.2.2 Overview of Query Processing

            1.2.3 Storage and Buffer Management

            1.2.4 Transaction Processing

            1.2.5 The Query Processor

      1.3 Outline of Database-System Studies

      1.4 References for Chapter 1

 

PART I: Relational Database Modeling

 

2 The Relational Model of Data

      2.1 An Overview of Data Models

            2.1.1 What is a Data Model?

            2.1.2 Important Data Models

            2.1.3 The Relational Model in Brief

            2.1.4 The Semistructured Model in Brief

            2.1.5 Other Data Models

            2.1.6 Comparison of Modeling Approaches

      2.2 Basics of the Relational Model

            2.2.1 Attributes

            2.2.2 Schemas

            2.2.3 Tuples

            2.2.4 Domains

            2.2.5 Equivalent Representations of a Relation

            2.2.6 Relation Instances

  &nbs...

(Pearson)