Index - Unique Index

Data System Architecture

About

A unique index is an index data structure that:

  • does not allow duplicate
  • allows Null value
  • implements a unique key.

If the key is already present, it will reject the insertion by throwing an error.

Implementation

This kind of structure are generally implemented with a hashmap.





Discover More
Data System Architecture
Logical Data Modeling - Unique Key

A Unique Key identifies: the lowest level of an entity the unique identifier of a single instance remains unique over time butcan change over time. and enforces uniqueness primary key The set...
Data System Architecture
Relational Data Modeling - Unique (Constraint|Key)

Unique key implementation in a relational environment A unique constraint is a constraint that enforces the Entity Integrity e.g. that every value in a column or set of columns (key) be unique—that...



Share this page:
Follow us:
Task Runner