Creating subtables from an array of structures

Service Manager enables a dbdict administrator to manage data more effectively by creating subtables of unique and non-unique attributes within an array of structures. You can use this feature to achieve the following benefits:

  • Improve mapping to external SQL database tables.
  • Implement a more cost-effective solution for managing attribute information.
  • Simplify queries.

The dbdict administrator can identify two subtable names for each array of structures in the dbdict. One table contains the names of unique attributes. The second table names non-unique attributes. A pop-up utility dialog box enables you to identify which attributes are unique.

The subtable feature helps you create queries that can return detailed information. This type of available detail can improve business and management decisions. You can create subtables for an array of structures in any dbdict. Service Manager provided out-of-box subtables already created for all arrays of structures in the inventory dbdicts.

Related topics

Device table
Devtype table
Attribute tables
Join tables