Day: June 18, 2023
-
Shifting Towards Simplicity: Using Single Unique Identifiers in Our Data Model
Views: 9 Shifting Towards Simplicity: Using Single Unique Identifiers in Our Data Model Nobuyuki SAMBUICHI ISO/TC295 Audit data services/SG1 Semantic model Convener In our current table and field definitions, we have several tables that define their primary key as a combination of multiple fields. I recommend that we use a single primary key to define our object classes from our table definition. Primary keys and referenced identifiers (foreign keys) should be defined more simply and clearly in UML associations. User Provide some pros and cons of defining a primary key on multiple fields. Provide the advantage of designing the semantic model of object classes using a single unique identifier (primary […]