Graphical In-Memory Database Exploration for Real-Time Data Cube Creation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Business users face limitations in analyzing business data as existing systems require technical expertise to define new data cubes, and predefined data cubes may not capture all relevant dimensions or views, restricting real-time exploration and analysis.
Innovation Solution
The system allows graphical exploration of an in-memory database by identifying selected data objects, searching for associated data elements, determining relationships, and generating displayable graphs, enabling users to create new data cubes based on user selections and interactions, without needing technical expertise.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If predefined data cubes are used to present business data, then data presentation is standardized and efficient, but the system cannot capture all relevant dimensions or views and requires technical expertise to define new data cubes
Solution Approach 1:
The system enables business users to independently explore and define new data views by searching for data elements and visually constructing data cubes through drag-and-drop interfaces, eliminating the need for technical expertise in cube definition
Solution Approach 2:
A graphical user interface acts as an intermediary between users and the underlying database structure, providing search functionality and visual tools that simplify complex data cube operations into intuitive drag-and-drop interactions
2Adaptability or versatility
If predefined data cubes are used, then data analysis is efficient, but real-time exploration and creation of new data views is restricted
Solution Approach 1:
The system transitions from static predefined data cubes to dynamic user-defined data views that can be created and modified in real-time through graphical exploration and drag-and-drop operations
Solution Approach 2:
The system performs preliminary actions by automatically searching for and retrieving data elements from the database when users drag items between areas, eliminating manual data definition time
Data Source
AI summary
Techniques implemented in methods, computer-readable media apparatus, and systems for graphically exploring an in-memory database include: identifying a selected data object; searching an in-memory database for a data element associated with a search term; and determining a relationship between the data element and the selected data object; and generating a displayable graph of the relationship as a path between the data element and the selected data object, the path comprising at least two nodes, where a first node represents the selected data object and a second node represents a node associated with the data element.