O'Reilly logo

Apache Derby—Off to the Races: Includes Details of IBM® Cloudscape™ by Dan Scott, George Baklarz, Paul C. Zikopoulos

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Database Objects

An Apache Derby database is an organized collection of objects. Each database has its own system catalog, log files, security, and tuning parameters. SQL is used throughout the database industry as a common method of issuing database queries. Before we examine the SQL language, we need to understand some Apache Derby terminology. We will be referring to the basic components or objects that are defined for each Apache Derby database. These objects include:

Tables

Data Types

Schemas

Views

Indexes

Triggers

Procedures

The following sections give a brief overview of each object and describe how it is used.

Tables

A table is an unordered set of rows. Rows consist of columns. Each column is based on a data type. Tables, once created and populated ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required