Define persistent attribute hash table
To increase search speed in the database, it is possible to define persistent hash tables. A hash table is a persistent data structure in the database that speeds up the search for instances of one entity in one schema via the value of one attribute. The hash table is created when a data model of the specified schema is created and it is maintained during the entire lifetime of the model or until it is deleted. If there exist a data model based on the specified schema when the hash table is defined, this model do not get a hash table. In this case the model must be exported to a STEP file, deleted and recreated from the STEP file. Likewise is an attribute hash table of data model removed if attribute hash table definition is removed from underlying schema of the data model.
This command defines attribute hash tables.
Â
Arguments:
Schema: |
Specify the name of schema(ta) in the EDMdatabase that defines the actual attribute(s). Schema names are case insensitive. |
Entity: |
Specify the name of entity(ies) in the schema(ta) specified by the <Schema> argument that defines the attribute(s) of interrest. Entity names are case insensitive. |
Attribute: |
Specify the name of attribute(s) in the entity(ies) specified by the <Schema> and <Entity> arguments, of interrest. Attribute names are case insensitive. |
Attribute hash table width: |
Number of hash table entries. The use of this argument is not implemented yet. System default is always used. |
Attribute (fixed) string length: |
If the option [fixed string length] is selected, this argument specifies the fixed attribute string length. |
Options:
accumulating command output: |
A global option that appends the command output to the EDMsupervisor output window. Otherwise the output window is refreshed and only the last command output is displayed. |
match selected input: |
A global option that specifies that only items that partly or exactly matches the string in the related argument input field when activating a Select button, will be in the selection list. An empty (blank) string will match all items. |
delete attribute hash table: |
If this option is selected, the existing hash table of the specified attribute is deleted. No new hash table is defined. |
redefine attribute hash table: |
If this option is selected, the existing hash table of the specified attribute is deleted and a new hash table is defined. |
subtypes: |
If this option is selected, all subtypes of the specified entity |
fixed string length: |
If this option is selected, the argument <Attribute (fixed) string length> is taken as the fixed string length of the attribute. |
unique attribute values: |
If this option is selected it is checked that the attribute is unique when a new instance is stored or an attribute is modified. |