Understanding Recital Databases

From Recital Documentation Wiki
Revision as of 12:01, 21 December 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Understanding Recital Databases

What Are Database Tables and What Are Free Tables

Databases provide the means of organizing the tables and associated files for a particular application or system. They are implemented as directories with a catalog file which contains information, including full path details, about all the files that belong to that particular database. Opening a database gives an application access to all that database's files - operating system and data dictionary protection and security permitting - in whichever directory on the system they reside and database commands can target the files as a single unit. Databases are searched for in the sub-directories of the directory defined in the DB_DATADIR environment variable set in the recital.conf configuration file.

Free tables are not associated with a database; they are accessed via their physical disk location.

What is a Cursor

Summary