Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

Database Names and Filesystem Names

User-based schema names allow different users to create database objects of the same name. For example, the "accounting" user and the "inventory" user can both own an object named "customer". The applied user name as schema keeps these objects related under the user name. FairCom DB stores all persisted objects such as tables and indexes on disk as individual physical files. This creates a challenge with database objects of the same name. To resolve that issue, the schema name of the object owner is prepended along with an underbar character "_" to the object file name. For example, for the "stock" table owned by the "warehouse" user, the physical filename on disk is "warehouse_stock". If user accounting also created a "stock" table, then the resulting table will be physically named "inventory_stock".

See Also