Temporal Extent Descriptor for Dimensional Data Reporting
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
The phenomenon of slowly changing dimensions in dimensional data modeling creates ambiguity when generating reports, as grain relationships change over time, making it unclear which values at one grain should be considered related to values at another grain within a specified temporal extent.
Innovation Solution
A report query specifies a temporal mode, which is processed to determine a time extent descriptor, allowing for appropriate indications of dimension coordinates based on time information, thereby clarifying which values should be included in the report.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If grain relationships in dimensional data are allowed to change over time to reflect slowly changing dimensions, then the data model becomes more flexible and realistic, but ambiguity arises in reporting about which grain values should be considered related within a specified temporal extent
Solution Approach 1:
The patent introduces a temporal dimension to the dimensional data model by adding time extent parameters to coordinate constraints. This allows grain relationships to vary across different time periods while maintaining unambiguous reporting semantics. The time extent parameters (such as effective time ranges) create an additional dimension along which grain relationships can change, resolving the contradiction by making time-explicit what was previously ambiguous.
2Measurement precision
If temporal modes are processed to determine time extent descriptors for clarifying grain relationships, then reporting accuracy improves, but query processing complexity increases
Solution Approach 1:
The patent applies preliminary action by pre-defining temporal modes and their associated time extent descriptors in the query specification itself. Rather than performing complex temporal reasoning during query execution, the temporal mode (such as 'as of', 'during', 'cumulative') is processed beforehand to determine the appropriate time extent descriptor, which is then used to constrain the coordinate values. This shifts complexity from execution time to query preparation time, improving reporting accuracy while managing processing complexity.
Data Source
AI summary
A method/system considers the phenomenon of slowly changing dimensions in the process of reporting on facts of a collection of facts organized as, or otherwise accessible according to, a dimensionally-modeled fact collection. A report query specifies a temporal mode, and the specified temporal mode is processed to determine a time extent descriptor (e.g., in view of at least one of a context, in which the report query is made, and at least one dimension coordinate constraint). A processed result of querying the dimensionally-modeled fact collection includes appropriate indications of dimension coordinates in view of the time information from the time extent descriptor.