The Linux Database
(Imprint: M & T Books)
(Publisher: IDG Books Worldwide, Inc.)
Author: Fred Butzen
ISBN: 1558284915

Introduction

Acknowledgments

PART I—The Relational Database

Chapter 1—The Relational Model

What Is a Database?

What Are Data?

What Does It Mean to Maintain a Body of Data?

Data Relationality

The Relational Model

What is the Relational Model?

Structure of the Relational Model

Relational Algebra and Relational Calculus

Integrity

How the Relational Model Differs from Other Database Designs

Systems, Not Models

The Hierarchic Database

The Network Database

The Object-Oriented Database

Choosing a Type of Database

Summary

Further Reading

Chapter 2—Designing a Relational Database

From Real World to Relations

What Does It Mean to Design a Database?

The Steps of Designing a Database

The Art of Database Design

Building a Database: A Simple Example

The Baseball Score Problem

Building a Database: A Longer Example

The Library Problem

Building a Database: A Still Longer Example

The Auction Problem

Summary

Further Reading

Chapter 3—Structured Query Language

A History of Structured Query Language (SQL)

SQL Standards

Dialects of SQL

Disadvantages and Advantages of SQL

Implementation of the Language

SQL Structure

SQL Terminology

Structure of the Language

SQL Keywords

Data Types

Example Databases

Setting Up a Database

CREATE: Create a Database and Tables

DROP: Remove a Table or Index

GRANT and REVOKE: Set Permissions

Inserting Data into the Database

INSERT: Insert a Row Into a Table

Selecting Data from the Database

SQL and Relational Calculus

One-Table Selection

The Restrictive WHERE Clause

Multi-Table Selections

Unions

ORDER BY: Sort Output

DISTINCT and ALL: Eliminate or Request Duplicate Rows

Outer Joins

Built-in Functions

Sub-Selects

SELECT: Conclusion

Modifying the Data Within a Database

COMMIT and ROLLBACK: Commit or Abort Database Changes

DELETE: Remove Rows From Tables

Head UPDATE: Modify Rows Within a Table

Views

Stored Procedures and Triggers

Summary

Further Reading

PART II—Programming Database Applications

Introduction

Chapter 4—The Architecture of a Database Application

What Is a Database Application?

Evolution of the Database Application

The Three-Tier Model

How the Tiers Relate to Each Other

Benefits of the Three-Tier Model

Three-Tier Model: An Example

Organization of Tiers into Programs

Clients and Servers

Drivers

Web Access to a Database

Summary

Further Reading

ODBC

JDBC

CGI and Java

Networking and Communication

Chapter 5—Accessing the Database

Embedded SQL

Compiling Embedded SQL

Structure of a Program

Complex (Dynamic) SQL Statements

Open Database Connectivity (ODBC)

Structure of an ODBC Application

Compiling and Running an ODBC Application

Basic Program Structure

Binding a Variable to a Parameter

Reading Data from a SELECT Statement

Handling User Input

Transactions

SQL Interpreter

Java Database Connectivity (JDBC)

Mini-SQL

Structure of a JDBC Program

Elements of the JDBC Standard

A Simple Example

Modifying the Database

NULL Data

Preparing a Statement

General SQL Statements

Meta-Data

Other Features

Summary

Further Reading

Embedded SQL

ODBC

mSQL

JDBC

Chapter 6—Coding Front Ends

Design Principles

Know Your User

Programming Style

Presenting Data

Moving from Screen to Screen

Modifying the Database

Exiting

Common Gateway Interface

Disadvantages and Advantages

Structure of the CGI Interface

Coupling CGI with a Database

CGI and Databases: An Extended Example

Conclusion

Java

From Application to Applet

Baseball Example

An Extended Example

Summary

Further Reading

Common-Gateway Interface

HTTP Servers

Javascript

Chapter 7—Middleware

Encoding Semantic Information

Middleware Tasks

Example: Inserting Data

Batch-Like Approach

Error Detection

Decomposition of the Input

Drag-and-Drop Interface

Protecting Against Deletion Anomalies

Summary