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

Creating and Using User-Defined Casts in Dynamic Server

Dimensional Databases

Building a Dimensional Data Model

Implementing a Dimensional Database (XPS)

In This Chapter

Implementing the sales_demo Dimensional Database

Logging and Nonlogging Tables in Extended Parallel Server

Indexes for Data-Warehousing Environments

Using GK Indexes in a Data-Warehousing Environment

Appendixes

Appendix. Accessibility

Notices

Index