top of page

Primary Keys

Primary Key 3d-2.jpg

The architecture utilizes a globally unique eight-byte key for primary keys, comprising a system ID and a record ID.  The System ID is assigned to systems much like TCP/IP addresses are assigned.  The Record ID leverages the built in capabilities of SQL to assign an incremented integer value which guarantees the same value will not be used twice. This design is applied universally across all data types, including master, transaction, and system data.

​

Benefits

 

  • Universality and Uniqueness: Each record is assigned a primary key that is not only unique within its system but across all systems, greatly simplifying data identification, exchange and aggregation.

​​

  • Compactness and Efficiency: The size of the primary key is half the size of a GUID which enhances the efficiency of index operations.

​​

  • Simplicity for Utilities: Having a consistent primary/foreign key format across all tables has made it possible to create the 3D platform.

​​

  • Ease of Reference: The straightforward format (e.g., 1-123) makes these keys easy to use and reference, unlike the cumbersome strings of a GUID.

​​

  • Optimized Data Storage: The sequential nature of the record IDs allows for efficient, orderly data storage, improving database performance for storage and retrieval and reduces bloating.
    ​

For more information refer to the following video https://youtu.be/AezBmbEWawY​

bottom of page