Informix Guide to SQL: Tutorial
Chapter 9: Implementing Your Data Model
Home
Contents
Index
Master Index
New Book
Summary
This chapter covered the following work, which you must do to implement a data model:
Specify the column-specific properties, or constraints, that are used in the model, and complete the model diagram by assigning constraints to each column.
Use interactive SQL to create the database and the tables in it.
If you must create the database again, write the SQL statements to do so into a script of commands for the operating system.
Populate the tables of the model, first using interactive SQL and then by bulk operations.
Possibly write the bulk-load operation into a command script so that you can repeat it easily.
Possibly use the fragmentation SQL statements to create, alter, and modify fragmented tables.
You can now use and test your data model. If it contains very large tables, or if you must protect parts of it from certain users, more work remains to be done. That work is one of the subjects in the
INFORMIX-Universal Server Performance Guide
.
Informix Guide to SQL: Tutorial
, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.