Logical Data Modeling - Global Identifier (Fully Qualified Name, Canonical Form)

Data System Architecture


A global identifier identify uniquely a primary element (entity or relationship) in the global scope

It's also generally known as:

  • the fully qualified id
  • the fully qualified name
  • the canonical form (global unique id)

The Gold Modeling Rule

Every entity should have a non-null identifier.

Why ? Just because if any error happens when processing its properties, you should be able to report it unambiguously.

If you don't have one, generate one.



A fully qualified identifier is composed of:

<MATH> \Large GlobalIdentity = NameSpace + PrimaryKey </MATH>


The identifier describes the identity of an entity.

If there is no namespace functionality in the system, you will get this formula <MATH> \Large id+entity = identity </MATH>

Discover More
Card Puncher Data Processing

A list of books B00125MJYMThe Non-Designer's Design Book (3rd Edition) (Non Designer's Design Book) B009ZUZ9FWthe K&R White Book B00J9IJ5R8The Art of Computer...
Data System Architecture
Character Set - Code page

Code page is a number identifier for a character set. The term code page originated from IBM's EBCDIC-based mainframe systems, but many vendors use this term including Microsoft, SAP, and Oracle Corporation....
Card Puncher Data Processing
Code design - (Connection|Session)

During the use of a product, a session or connection is a execution context that holds identification data (if any) and group actions (such as interaction or transaction) that take place within...
Consistent Hashing
Cryptography - Hash

A hash function is an encryption crypto algorithm that takes as data as input (possibly large and of variable-sized) and produces a short fixed-length integer value (generally printed as an hexadecimal...
Data System Architecture
Data - Cache

In computer science, a data cache is a component that aims to: improve performance reduce load on the server. The cache will: store transparently a request response and use it to for later...
Thomas Bayes
Data Mining - Data (Preparation | Wrangling | Munging)

Data Preparation is a data step that prepares your data for further analyis. It's a key factor in any data project: mining, ai analytics Preparing has several steps that are explained below. ...
Data System Architecture
Data Modeling - Canonical Form

A canonical form is a unique representation such that every object can be uniquely identified in the global scope object (entity)normal form In computer science, the equality of two objects can easily...
Gmail Original Message Id
Email - Message Id

A Message-ID is an email identifier. It is generated by the client sending the mail and added in the Message-ID header An message id is generally the concatenation of: a timestamp the local hostname...
Etag - An unique identifier for a HTTP resource

The ETag HTTP response header is an identifier for a specific version of a resource. A etag comparison determines whether two representations of a resource are the same and is therefore similar to a hash...
Git Commit Tree Data Model
Git - Commit

A commit in git is an object that stores the information : who saved the file system snapshots, when they were saved, why they were saved. the commiter the author the parent commit It's...

Share this page:
Follow us:
Task Runner