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?

Why Use Fragmentation?

Whose Responsibility Is Fragmentation?

Enhanced Fragmentation (XPS)

Fragmentation and Logging

Distribution Schemes for Table Fragmentation

Creating a Fragmented Table

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