Difference between revisions of "Understanding Recital Databases"
Yvonnemilne (Talk | contribs) (→What Are Free Tables and What Are Database Tables) |
Yvonnemilne (Talk | contribs) (→What Are Database Tables and What Are Free Tables) |
||
| Line 1: | Line 1: | ||
==Understanding Recital Databases== | ==Understanding Recital Databases== | ||
===What Are Database Tables and What Are Free Tables=== | ===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. | + | 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. | Free tables are not associated with a database; they are accessed via their physical disk location. | ||
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.
