Database Table Names

When you specify a database for ActiveMatrix BusinessWorks storage, tables are created in your database. The administration domain name and deployment ID (assigned by ActiveMatrix BusinessWorks) are used to name the tables to ensure uniqueness of the tables for each domain and each deployment.

Because some databases limit the number and kinds of characters for table names, the domain name can altered before being used in the table name. The first eight characters and the last eight characters of the domain name are taken and any non-legal characters (such as spaces or dashes) are converted to underscores. This creates a sixteen-character unique ID for each domain, provided that the first and last eight characters of all of your domain names are unique.

For example, the following illustrates conversion of domain names. Notice the second and third domain names convert to the same ID. You should avoid this by creating domain names so that the combination of the first and last eight characters are unique.

Domain Name

Converts To Domain ID

TIBCO_domain_Accounting TIBCO_docounting
TIBCO_domain_Marketing TIBCO_doarketing
TIBCO_domain_Direct_Marketing TIBCO_doarketing

All table names created by ActiveMatrix BusinessWorks begin with T_<domain-id>_<deploymentID>_. You can alter the storage parameters for these tables if you desire, but the table names and column definitions must remain the same.