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

In This Chapter

Overview of Data Warehousing

Why Build a Dimensional Database?

What Is Dimensional Data?

Concepts of Dimensional Data Modeling

Building a Dimensional Data Model

Handling Common Dimensional Data-Modeling Problems

Implementing a Dimensional Database (XPS)

Appendixes

Appendix. Accessibility

Notices

Index