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

Expression-Based Distribution Scheme

Round-Robin Distribution Scheme

Range Distribution Scheme (XPS)

System-Defined Hash Distribution Scheme (XPS)

Hybrid Distribution Scheme (XPS)

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