In this tutorial chapter, you created a default DBEnvironment structure
consisting of a DBECon file, a log, and a DBEFILE0 associated with DBEFileSet SYSTEM to contain system catalog data. You created the ALBUMFS DBEFileSet, and two DBEFiles associated with it-- AlbumData, for the Albums and Titles table data, and AlbumIndex, for the Albums and Titles indexes. You also created and loaded the tables themselves, created groups and granted authorities, and defined a unique and a non-unique index. You have also done several queries and examined the system catalog.
As a further exercise, create the Composers and Log tables from the descriptions in chapter 2. Consider whether to create indexes on them. Add some rows to them, using values consistent with the entries in the Albums and Titles tables. Then perform some queries. What sort of security structure would be appropriate?
There's plenty more! But you're off to a good start. As you continue with your own DBEnvironments, use the examples in the ALLBASE/ISQL Reference Manual and the ALLBASE/SQL Reference Manual as models. You can also refer to the chapter in this guide
entitled "Practice with ALLBASE/SQL Using PartsDBE" for information about a
comprehensive sample DBEnvironment that is supplied as a part of ALLBASE/SQL.
