Difference between revisions of "Understanding Recital Databases"
Barrymavin (Talk | contribs) |
Yvonnemilne (Talk | contribs) (→What Are Free Tables and What Are Database Tables) |
||
Line 1: | Line 1: | ||
==Understanding Recital Databases== | ==Understanding Recital Databases== | ||
− | ===What Are | + | ===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=== | ===What is a Cursor=== | ||
===Summary=== | ===Summary=== |
Revision as of 12:01, 21 December 2009
Contents
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.