Information Modeling and Relational Databases: From Conceptual Analysis to Logical Design

Glossary

ORM Glossary

This glossary lists key terms and symbols used in Object-Role Modeling a-nd briefly explains their meaning. A concise explanation of other technical terms may be found in the chapter summaries. Further details on technical terms may be accessed by using the index.
Arity
Number of roles in a relationship (unary = 1, binary = 2, ternary = 3, etc.).
Association
Relationship type, usually involving at least two roles.
Base fact type
Fact type that is primitive (not derived from others).
Compositely identified object type
Either a coreferenced object type or a nested entity type.
Compound fact type
Fact type that is equivalent to a conjunction of smaller fact types.
Conceptual schema
Conceptual model of the UoD structure; design that specifies what states and transitions are possible; declaration of elementary fact types, constraints, and derivation rules.
Conceptual schema design procedure (CSDP)
  1. Divide the UoD into manageable subsections

  2. Transform familiar examples into elementary facts, and apply quality checks

  3. Draw the fact types, and apply a population check

  4. Check for entity types that should be combined, and note arithmetic derivations

  5. Add uniqueness constraints, and check arity of fact types

  6. Add mandatory role constraints, and check for logical derivations

  7. Add value, set-comparison (subset, equality, exclusion), and subtype constraints

  8. Add other constraints and perform final checks

  9. Integrate the subschemas into a global conceptual schema

Constraint
Restriction on possible states (static constraint) or transitions (dynamic constraint).
Coreferenced object
Object that is identified by means of two or more reference types in combination. Hence...

UNLIMITED FREE
ACCESS
TO THE WORLD'S BEST IDEAS

SUBMIT
Already a GlobalSpec user? Log in.

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.

Customize Your GlobalSpec Experience

Category: Research and Development Services
Finish!
Privacy Policy

This is embarrasing...

An error occurred while processing the form. Please try again in a few minutes.