In-Memory Database Comment Binding via Dimension Dependency Tables
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing database systems face challenges in implementing comment functionality across keyfigures with complex relationships, as comments relevant to one data object are not readily available for other related data objects due to flexible relationships between data objects and dimensions.
Innovation Solution
An in-memory database engine binds comments to keyfigures using dimension dependency tables, transforming comments to be associated with related tuples by referencing dimension dependency information, allowing comments to be displayed across different dimensions even if they do not explicitly share dimensions, through aggregation operations like joins.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Loss of information
If comments are bound to specific tuples in a database, then comment relevance to the data object is maintained, but comments cannot be accessed across related dimensions due to flexible relationships between data objects and dimensions
Solution Approach 1:
The patent introduces dimension dependency tables as intermediary structures that mediate between comments bound to specific tuples and the flexible dimensional relationships. These tables store mapping information between dimensions, enabling the system to traverse from a comment's original dimension to related dimensions without changing the comment binding mechanism. This resolves the contradiction by adding a mediating layer that bridges the rigidity of comment binding and the flexibility of dimensional relationships.
Solution Approach 2:
The patent adds a new dimensional aspect to the data model by introducing dimension dependency tables that store relationships between dimensions. This new dimension allows the system to maintain comment binding to original tuples while simultaneously enabling access across related dimensions through the dependency mapping. The solution expands the dimensional structure to accommodate both comment persistence and cross-dimensional accessibility.
2Ease of operation
If the system transforms comments to bound to different tuples based on dimension relationships, then comment accessibility across dimensions is improved, but processing time and computational resources increase
Solution Approach 1:
The patent implements preliminary action by pre-computing and storing dimension dependency relationships in dimension dependency tables before actual comment transformation is needed. When a user requests comments for a particular dimension, the system can quickly query the pre-existing dependency tables rather than computing relationships in real-time. This significantly reduces processing time while maintaining the flexibility of comment transformation across dimensions.
Solution Approach 2:
The patent creates a simplified representation of dimension relationships through dimension dependency tables that copy and store the essential mapping information between dimensions. Instead of performing complex real-time relationship analysis, the system uses these pre-created copies of dimensional relationships to quickly determine which comments should be transformed and bound to which tuples, reducing computational overhead while preserving transformation accuracy.
3Adaptability or versatility
If comments are stored with specific tuples, then data integrity is maintained, but flexibility to display comments with related dimensions is reduced
Solution Approach 1:
The patent introduces dynamics to the comment binding mechanism by enabling comments to be dynamically reassigned to different tuples based on the requested dimension. The dimension dependency tables provide the mapping information needed to transform comment bindings from their original tuples to related tuples in different dimensions. This dynamic binding capability maintains data integrity through systematic transformation while providing the flexibility to display comments appropriately across various dimensional contexts.
Data Source
AI summary
Comments are flexibly bound to keyfigures of an in-memory database, through reference to dimension dependency table(s). An in-memory database engine creates a comment bound to a first tuple via a first comment table. The first tuple comprises a first dimension (e.g., Product). A user then requests a second tuple comprising a second dimension (e.g., Product Group) related to the first dimension. In response, the in-memory database engine references a dimension dependency table to determine dimension dependency information. Based upon that information, the engine transforms the comment to also be bound to the second tuple via a second comment table. The second tuple is then returned to the user together with the comment, even though the second tuple may not explicitly share dimensions with the first tuple. Embodiments may leverage the processing power and data proximity of the in-memory database engine, to efficiently transform comments by executing aggregation (e.g., join) operations.