Arbitrary directory data properties in sql-based directory systems

Abstract

The techniques disclosed herein enhance the efficiency and functionality of directory systems. This is accomplished by augmenting a primary table with an extended table for storing properties of an associated entity (e.g., a user, a company). A table serves to organize directory data and comprises rows and columns. Each row of the primary table stores an entity with each column storing an associated property. In contrast, the primary table is configured with an extended table in which each row of the extended table stores a property for an associated entity while each column stores additional information for the property such as timestamps and metadata. Storing specific properties in the extended table eliminates empty spaces in the primary table thereby reducing the volume of stored data. Moreover, by including additional data for properties, the extended table enables property-specific features such as search, synchronization, extensibility, and lifecycle management.