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

In This Chapter

Overview of Distributed Queries

Configuring the Database Server to Use Distributed Queries

The Syntax of a Distributed Query

Accessing a Remote Server and Database

Valid Statements for Accessing Remote Objects

Accessing Remote Tables

Other Remote Operations

Monitoring Distributed Queries

Server Environment and Distributed Queries

Database Access Restrictions

Transaction Processing

Cross Server Compatibility Issues (XPS)

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