Introduction

Basics of Database Design and Implementation

Planning a Database

Building a Relational Data Model

Choosing Data Types

Implementing a Relational Data Model

Managing Databases

Table Fragmentation Strategies

Granting and Limiting Access to Your Database

Using Distributed Queries

Object-Relational Databases

Creating and Using Extended Data Types in Dynamic Server

Understanding Type and Table Inheritance in Dynamic Server

In This Chapter

What Is Inheritance?

Type Inheritance

Table Inheritance

The Relationship Between Type and Table Hierarchies

Defining a Table Hierarchy

Inheritance of Table Behavior in a Table Hierarchy

Modifying Table Behavior in a Table Hierarchy

SERIAL Types in a Table Hierarchy

Adding a New Table to a Table Hierarchy

Dropping a Table in a Table Hierarchy

Altering the Structure of a Table in a Table Hierarchy

Querying Tables in a Table Hierarchy

Creating a View on a Table in a Table Hierarchy

Creating and Using User-Defined Casts in Dynamic Server

Dimensional Databases

Building a Dimensional Data Model

Implementing a Dimensional Database (XPS)

Appendixes

Appendix. Accessibility

Notices

Index