E. Foster – Database Systems (2016)

Автор: E. Foster
Название книги: Database Systems
Формат: PDF
Жанр: Компьютеры
Страницы: 619
Качество: Изначально компьютерное, E-book

This is a classroom textbook providing a comprehensive yet concise introduction to the theory and practice of database systems as they are used in corporate software development.
Contents
Preface
Preliminary Topics
Introduction to Database Systems
The Database System Environment
The Relational Database Model
The Relational Model
Integrity Rules and Normalization
Database Modeling and Design
Database User Interface Design
Relational Algebra
Relational Calculus
Refl ective Look at the Relational Database Model
The Structured Query Language
Overview of SQL
SQL Data Defi nition Statements
SQL Data Manipulation Statements
Logical Views and System Security
The System Catalog
Some Limitations of SQL
Advanced Topics
Database Administration
Distributed Database Systems
Object Databases
Data Warehousing
Web-Accessible Databases
Using Database Systems to Anchor Management
Support Systems
Overview of Selected DBMS Suites
Overview of Oracle
Overview of DB2
Overview of MySQL
Overview of Microsoft SQL Server
Appendices
Appendix A1: Review of Trees
Appendix A2: Review of Hashing
Appendix A3: Review of Information-Gathering Techniques
Appendix A4: BNF Syntax for Selected SQL Statements
Appendix A5: Sample Exercises and Examination Questions