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

In This Chapter

Using SQL to Restrict Access to Data

Controlling Access to Databases

Granting Privileges

Using SPL Routines to Control Access to Data

Using Views

Privileges and Views

Privileges When Creating a View

Privileges When Using a View

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