Introduction

Basics of Database Design and Implementation

Planning a Database

Building a Relational Data Model

Choosing Data Types

Implementing a Relational Data Model

In This Chapter

Creating the Database

Using CREATE DATABASE

Using CREATE TABLE

Using CREATE INDEX

Using Synonyms for Table Names

Using Synonym Chains

Using Command Scripts

Populating the Database

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)

Appendixes

Appendix. Accessibility

Notices

Index