A first course in database systems

著者

• Ullman, Jeffrey D.
• Widom, Jennifer

書誌事項

A first course in database systems

Jeffrey D. Ullman and Jennifer Widom

（An Alan R. Apt book）

Prentice Hall, c1997

注記

Includes bibliographical references and index

内容説明・目次

内容説明

Giving comprehensive coverage of all aspects of SQL programming, this student-friendly text adopts a user-oriented approach. It covers the design of databases using both the E/R model and the OO standard ODL, and explains object-oriented and object-relational database programming. It also covers the OO standard OQL and object-oriented features of SQL3, and advanced database programming, including integrity constraints, assertions, triggers and recursion in SQL3.

目次

• The worlds of database systems: the evolution of database systems
• the architecture of a DBMS
• the future of database systems
• outline of the book. Database modelling: introduction of ODL
• entity-relationship diagrams
• design principles
• subclasses
• the modelling of constraints
• weak entity sets
• models of historical interest. The relationship data model: basic of the relational model from ODL
• designs to relational designs
• from E/R diagrams to relational designs
• converting subclass structures to relations
• functional dependencies
• rules about functional dependencies
• design of rational database schemas
• multivalued dependencies
• an example database schema. Operations in the relational model: an algebra of relational operations
• a logic for relations
• from relational algebra to datalog
• recursive computations
• constraints on relations
• relational operations on bags
• other extensions of the relational model. The database language SQL: simple queries in SQL
• queries involving more than on e relation
• subqueries
• supplicates
• aggregation database modifications
• defining a relation schema in SQL
• view definitions
• Null values and outerjoints
• recursion in SQL3. Active elements in SQL: declaring keys in SQL
• referential integrity and foreign keys
• value constraints
• global constraints
• modification of constraints
• event-condition-action rules in SQL3. System aspects of SQL: SQL in a programming environment
• transactions in SQL
• the SQL environment
• security and user authorization in SQL2. Object oriented query languages: query-related features of ODL
• introduction to OQL
• additional forms of OQL
• expressions
• object assignment and creation in OQL
• tuple objects in SQL3
• value-ADT's
• comparison of ODL/PQL and SQL3
• approaches.

「Nielsen BookData」 より

詳細情報

• NII書誌ID(NCID): BA31599326
• ISBN:
  • 0138613370
• LCCN: 97007762
• 出版国コード: us
• タイトル言語コード: eng
• 本文言語コード: eng
• 出版地: Upper Saddle River, N.J.
• ページ数/冊数: xiii, 470 p.
• 大きさ: 25 cm
• 分類:
  • LCC : QA76.9.D3
  • DC21 : 005.74
• 件名:
  • LCSH : Database management
• 親書誌ID:
  • BA2422684X