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

In This Chapter

What Is Fragmentation?

Distribution Schemes for Table Fragmentation

Creating a Fragmented Table

Creating a New Fragmented Table

Creating a Fragmented Table from Nonfragmented Tables

Rowids in a Fragmented Table

Fragmenting Smart Large Objects (IDS)

Modifying Fragmentation Strategies

Granting and Revoking Privileges on Fragments (IDS)

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

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