Normal view MARC view ISBD view

Database systems : the complete book / Hector Garcia-Molina, Jeffrey D. Ullman, Jennifer Widom

Main Author Garcia-Molina, Hector Coauthor Ullman, Jeffrey D.
Widom, Jennifer
Country Estados Unidos. Publication Upper Saddle River : Prentice Hall, cop. 2002 Description XXVII, 1119 p. ; 24 cm ISBN 0-13-031995-3
0-13-098043-9
CDU 681.3
Tags from this library: No tags from this library for this title. Log in to add tags.
    average rating: 0.0 (0 votes)
Holdings
Item type Current location Call number Status Date due Barcode Item holds Course reserves
Monografia Biblioteca Geral da Universidade do Minho
BGUM 681.3 - G Checked out 2022-01-27 306395
Monografia Biblioteca Geral da Universidade do Minho
BGUM 681.3 - G Available 331893

Mestrado Integrado em Engenharia Informática Bases de Dados 1º semestre

Total holds: 0

Enhanced descriptions from Syndetics:

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: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.

Table of contents provided by Syndetics

  • NOTE:Each chapter concludes with Summary and References sections
  • 1 The Worlds of Database Systems
  • The Evolution of Database Systems
  • Overview of a Database Management System
  • Outline of Database-System Studies
  • 2 The Entity-Relationship Data Model
  • Elements of the E/R Model
  • Design Principles
  • The Modeling of Constraints
  • Weak Entity Sets
  • 3 The Relational Data Model
  • Basics of the Relational Model
  • From E R Diagrams to Relational Designs
  • Converting Subclass Structures to Relations
  • Functional Dependencies
  • Rules About Functional Dependencies
  • Design of Relational Database Schemas
  • Multivalued Dependencies
  • 4 Other Data Models
  • Review of Object-Oriented Concepts
  • Introduction to ODL
  • Additional ODL Concepts
  • From ODL Designs to Relational Designs
  • The Object-Relational Model
  • Semistructured Data
  • XML and Its Data Model
  • 5 Relational Algebra
  • An Example Database Schema
  • An Algebra of Relational Operations
  • Relational Operations on Bags
  • Extended Operators of Relational Algebra
  • Constraints on Relations
  • 6 The Database Language SQL
  • Simple Queries in SQL
  • Queries Involving More Than One Relation
  • Subqueries
  • Full-Relation Operations
  • Database Modifications
  • Defining a Relation Schema in SQL
  • View Definitions
  • 7 Constraints and Triggers
  • Keys and Foreign Keys
  • Constraints on Attributes and Tuples
  • Modification of Constraints
  • Schema-Level Constraints and Triggers
  • 8 System Aspects of SQL
  • SQL in a Programming Environment
  • Procedures Stored in the Schema
  • The SQL Environment
  • Using a Call-Level Interface
  • Java Database Connectivity
  • Transactions in SQL
  • Security and User Authorization in SQL
  • 9 Object-Orientation in Query Languages
  • Introduction to OQL
  • Additional Forms of OQL Expressions
  • Object Assignment and Creation in OQL
  • User-Defined Types in SQL
  • Operations on Object-Relational Data
  • 10 Logical Query Languages
  • A Logic for Relations
  • From Relational Algebra to Datalog
  • Recursive Programming in Datalog
  • Recursion in SQL
  • 11 Data Storage
  • The ldquo;Megatron 2002rdquo; Database System
  • The Memory Hierarchy
  • Disks
  • Using Secondary Storage Effectively
  • Accelerating Access to Secondary Storage
  • Disk Failures
  • Recovery from Disk Crashes
  • 12 Representing Data Elements
  • Data Elements and Fields
  • Records
  • Representing Block and Record Addresses
  • Variable-Length Data and Records
  • Record Modifications
  • 13 Index Structures
  • Indexes on Sequential Files
  • Secondary Indexes
  • B-Trees
  • Hash Tables
  • 14 Multidimensional Indexes
  • Applications Needing Multiple Dimensions
  • Hash-Like Structures for Multidimensional Data
  • Tree-Like Structures for Multidimensional Data
  • Bitmap Indexes
  • 15 Query Execution
  • Introduction to Physical-Query-Plan Operators
  • One-Pass Algorithms for Database Operations
  • Nested-Loop Joins
  • Two-Pass Algorithms Based on Sorting
  • Two-Pass Algorithms Based on Hashing
  • Index-Based Algorithms
  • Buffer Management
  • Algorithms Using More Than Two Passes
  • Parallel Algorithms for Relational Operations
  • 16 The Query Co

Author notes provided by Syndetics

JEFFREY D. ULLMAN is the Stanford W. Ascherman Professor of Computer Science 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. Karlstrom Outstanding Educator Award, the SIGMOD Contributions Award, and the Knuth Prize.

JENNIFER WIDOM is Associate Professor of Computer Science and Electrical Engineering at Stanford University. 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.

HECTOR GARCIA-MOLINA is the L. Bosack and S. Lerner Professor of Computer Science and Electrical Engineering, and Chair of the Department of Computer Science at Stanford University. His research interests include digital libraries, information integration, and database application on the Internet. He was a recipient of the SIGMOD Innovations Award and is a member of PITAC (President's Information-Technology Advisory Council).

There are no comments for this item.

Log in to your account to post a comment.