|Home » Products » DBISAM for Visual Studio Database Developers
|Database System Utility
|This utility allows the developer or end user to create, browse, update, restructure, search, query, and print DBISAM tables from a convenient and easy-to-use interface.
|Server Administration Utility
|This utility allows the developer or end user to administer a DBISAM database server from a convenient and easy-to-use interface. This utility can modify server configuration data, users, databases, and user rights as well as retrieve server log information. All functions are subject to having administrator rights on the database server being administered and access can be controlled on a per-user basis.
|The most common data types (including BCD, BLOB, GUID, and auto-increment) are supported in DBISAM tables, and complete and accurate NULL support is provided for all data types.
|Tables can be encrypted using strong encryption.
|Tables can be assigned a locale in order to control how sorting occurs in indexes as well as any searching or filtering done on the table via filters or SQL. However, currently this support is only available for Windows.
|Configurable index page and BLOB block sizes
|Both index pages and BLOB block sizes can be configured to optimize access and storage requirements.
|Tables can be assigned major and minor version numbers, which allows for easy structure version checking and updating.
|Long field names and field and table descriptions
|Field names can be quite long, and descriptions can be specified for tables and fields for reference purposes.
|Min, max, and required constraints, default values, and character-case specifiers for fields
|Simple expression constraints can be assigned to fields, and default values can be assigned automatically for NULL fields when records are added. Also, you can specify that a field be forced to upper or lower case whenever that field is modified.
|BLOB fields can be compressed to save space, and the compression is transparent once it is enabled.
|Primary and secondary indexes
|Tables can contain primary and secondary indexes that have case-insensitive, descending, and unique attributes, including mixed ascending/descending key fields.
|Configurable index key compression
|Index key compression can be enabled to greatly reduce the size of indexes and optimize access.
|Full text indexing
|Full text indexing is can be specified for any string or memo fields in a table along with stop words, space characters, and include characters to control how the indexing occurs.