A Model for Multigranular Data and Its Integrity

Abstract

Data involving spatial and/or temporal attributes are often represented at different levels of granularity in different source schemata. In this work, a model of such multigranular data is developed, which supports not only the usual order structure on granules, but also lattice-like join and disjointness operators for relating such granules in much more complex ways. In addition, a model for multigranular thematic attributes, to which aggregation operators are applied, is provided. Finally, the notion of a thematic multigranular comparison dependency, generalizing ordinary functional and order dependencies but specifically designed to model the kinds of functional and order dependencies which arise in the multigranular context, and in particular incorporating aggregation into the definition of the constraint, is developed.

A linear programming-based framework for handling missing data in multi-granular data warehouses

“…However, these operators do not take into account existing data at the most detailed granularity. (Hegner et al, 2017) introduce integrity constraints into multi-granular database models. The authors define a set of formal constraints for the definition of hierarchy of granularities.…”