ALLBASE/SQL Reference Manual (36216-90216)

46 Chapter1
Introduction
ALLBASE/SQL Databases
Figure 1-2. How Tables, DBEFiles, and DBEFileSets Are Related
A DBEFileSet specifies the files that contain data for one or more tables associated with
the DBEFileSet. These tables do not have to be in the same database. Figure 1-3.
illustrates that, while a DBEFileSet can contain data for all the tables in a database, a
DBEFileSet can also contain data for some of the tables in a database, or for tables in more
than one database. Thus DBEFileSets offer a way to allocate data storage independently of
how users think about the data.
Figure 1-3. Databases and DBEFileSets