Chapter 6 Using Adaptive Server Anywhere with Jaguar

Building Adaptive Server Anywhere databases

This section gives an overview of the process of building Adaptive Server Anywhere databases.

Designing your database

You can use SQL Modeler, which is included in SQL Anywhere Studio (SQL Anywhere Studio is not included in EAServer), to design your databases. SQL Modeler is a graphical tool that you use to create a database schema, including all tables, views, indexes, references, triggers, and procedures.

Designing a database is not difficult, but it is important. Poor database design can lead to an inefficient and possibly unreliable database system. Because most client applications are built to work on specific parts of a database and rely on the database design, a poor design can be difficult to revise at a later time.

For information about basic database design, see the Adaptive Server Anywhere User's Guide. For more advanced information about database design, see:

Documentation on DataArchitect, which is a component of PowerDesigner and a database design tool available from Sybase
An Introduction to Database Systems, by C. J. Date, which is an excellent textbook on database theory

Configuring and populating the database

You can use SQL Modeler to create your database and tables, and populate them with data.

After designing your database, you initialize it, after which you can connect to it and build the tables and other objects that you need in the database.