Modifying the Database

10/25/99


Click here to start


Table of Contents

Modifying the Database

More Interesting Insertions

Deletions

Updates

Data Definition in SQL

Data Types in SQL

Creating Tables

Deleting or Modifying a Table

Default Values

Indexes

Creating Indexes

Defining Views (!!)

A Different View

Updating Views

Non-Updatable Views

Reusing a Materialized View

Query Rewriting Using Views

Another Example

The General Problem

Querying the WWW

Datalog

Predicates and Atoms

Datalog Rules and Queries

The Meaning of Datalog Rules

Rule Safety

Composing Datalog Rules

From Relational Algebra to Datalog

Author: Alon Levy

Email: alon@cs.washington.edu

Home Page: http://www.cs.washington.edu/homes/alon

Download presentation source