Database Glossary - G

Granularity

1) The level of detail contained in a unit of data. The higher the level of detail - the lower the granularity level; conversely the reduced detail results in higher granularity.
2) The size of the smallest unit that can be independently locked. (A database may apply locks at the database, table, record, or single field value level.)

Ground Query

See: Query, Ground.

Grouping Level

The specified level at which a collection of related records, either grouped by index or query is organized. Grouping puts related data together to limit the scope of a sort or calculation by defining the [usually hierarchical] level(s) from which values are taken.