The location of the database table associated with the Object Class. Logical databases are defined in Genus Configuration.
The name of the database table associated with the Object Class.
RDMS naming method
- Prefix Table Name with Name of Data Set. The table name is prefixed with the name of the data set in database queries.
- Suffix Table Name with Name of Data Set. The table name is suffixed with the name of the data set in database queries.
Rarely in use. However, some applications partions data by using this naming method. For example, if your directory contains two or more data sets, each representing a company, sales data for each company may be stored in different sales tables in the same database or schema:
Property used to check if a cached object is outdated, e.g. a property which stores the last date an object was modified. If an object is outdated, the cache is updated with values stored in the database.
It is highly recommended to specify an aging property in order to reduce concurrency errors. If an object is outdated, the cache is always synchronized with values stored in the database before an edit operation is allowed to start.
Read all on first accesss
Select this option to read all objects from the Object Class into memory in a single operation the first time data are requested. At a later point, if a reference to the object class is found and the referenced object is not in memory, an attempt is made to read the referenced object.
Select this option to keep frequently accessed data in memory. All objects from the Object Class are read into memory in a single operation the first time data are requested. This options is best used on Object Classes with a small amount of data which not is frequently updated, for example an Object Class containing the chart of accounts in an accounting system.
Estimated number of rows
The approximate number of rows stored in a table. The estimate is used for two purposes:
- To find the most efficient data aggregate to minimize the time to answer aggregate queries.
- To determine if objects can be selected from a drop-down list box in Forms. For example, an employee works in a department. To change which department an employee works in, the user can select a department from a drop-down list box, or search for an department. If Estimated Number of Rows for the Department Object Class is less than or equal to the maxium number of objects allowed in drop-down list (100 objects), a department can be selected from a drop-down list box. Otherwise, the user has to search for a department.
Enable live update
Live update is a mechanism which allows you to deploy changes in data to clients connected to your application server. This feature is under construction and will be available in the release following version 2018.2.