Set and Access Defaults as Indexes

Enterprise Database Server sets and accesses are mapped by Relational Design Center as follows:

  • Sets and accesses spanning disjoint data sets are modeled as indexes of the SQL table corresponding to the spanned data set.

  • The key or keys of the set or the access are the key or keys of the SQL index.

  • Key data are not modeled.

  • Sets and accesses spanning embedded data sets are not modeled.

  • All physical set organizations are modeled, except for the following set organization types:

    • Unordered list

    • Bit vector

  • SQL indexes can have internationalized keys.