Sybase 12.4.2 manual Building Your Adaptive Server IQ Databases, Designing your database

C H A P T E R 3 Working with Database Objects

About this chapter	This chapter describes the mechanics of creating, altering, and deleting
	database objects such as tables, views, and indexes. The SQL statements
	for carrying out these tasks are called the Data Definition Language
	(DDL).
	The definitions of the database objects form the database schema. You can
	think of the schema as an empty database.
	Procedures are also database objects, but are discussed in Chapter 6,
	“Using Procedures and Batches”
	Note Remember that Adaptive Server IQ consists of both a Catalog Store
	and an IQ Store. This chapter explains how you create both stores, and the
	objects in your IQ Store. Tables created in the Catalog Store have the
	characteristics of Adaptive Server Anywhere tables. If you want to create
	tables in the Catalog Store, you need to refer to the Adaptive Server
	Anywhere documentation.

Building Your Adaptive Server IQ Databases

This section introduces you to the steps involved in creating a database, and the tools you use. It also explains decisions you need to make about where to store the data, how much space it will require, and who will be able to define or modify database objects.

Designing your database

It's important to design your database before you actually create it. The right database design can make a major difference in the usefulness of your data, and the speed with which you can retrieve it.

99