![]() |
Using Cloudview
|
|
Tables in a Relational DatabaseA relational database stores information in two-dimensional tables consisting of rows and columns, as illustrated in Figure 3-1. Tables contain rows of data consisting of columns of simple data types such as strings of characters, numeric data types, dates, times, and a few others. Figure 3-1 A two-dimensional table. A relational database usually consists of more than one table. Tables are related to each other through keys, columns that define uniqueness and references between tables. Access to data that spans more than one table is called a join. In the last lesson, you created a database in a small Java program. The command to create a database, as you recall, was a call to the java.sql.DriverManager. However, you did not store any data in the database. In order to store data, you need to define tables for storing data. Cloudscape provides a graphical application that makes it easy to create tables and other dictionary objects. This application, called Cloudview, does the work of sending the SQL-J commands that create the tables to Cloudscape. SQL-J is the name of Cloudscape's dialect of SQL. In this lesson, you will start Cloudview and use it to create and examine tables. |
|
![]() Cloudscape Version 3.6 For information about Cloudscape technical support, go to: www.cloudscape.com/support/.Copyright © 1998, 1999, 2000 Informix Software, Inc. All rights reserved. |