Multigranular

Multigranular is an adjective used to describe systems or mechanisms that support or operate at multiple levels of granularity—the size or scope of units used to represent, control, or analyze data. Granularity itself refers to the degree of detail or the size of the components.

In database management and concurrent systems, multigranularity locking (MGL) is a technique that allows locks to be placed at different levels of a resource hierarchy, such as database, table, page, or row. The approach uses intention locks to indicate intended lower-level locks, enabling greater concurrency while preserving consistency. This concept has influenced related locking protocols and transaction management.

In information security, multigranularity access control extends traditional models to permit permissions at various levels of granularity, such as object-level, field-level, or attribute-level access. This enables fine-grained control for sensitive data while supporting broader permissions where appropriate, aiding policies like least privilege and separation of duties.

Beyond databases and security, multigranularity appears in analytics and processing where tasks reason about data at several scales—character, word, phrase, or document; coarse and fine representations can be combined for robustness and efficiency.

Etymology and usage: The term derives from granularity, a measure of detail in a system, and is used across computer science, information security, and data analytics to describe multi-level approaches rather than a single standardized technology.