Dynamic UI Models for Runtime Analytical Data Pivoting
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Modern enterprise software applications face challenges in making practical use of data due to different data formats and varying user knowledge and access privileges, leading to statically defined and cumbersome data views that limit user interaction and data access.
Innovation Solution
The solution provides a data access component and a framework for designing 'booklets' that allow users to easily create, modify, and visualize data through a low code/no code approach, using analytical data protocols to facilitate dynamic data retrieval and visualization, enabling users to interact with data through customizable graphical user interfaces.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Stability of the object's composition
If data views are statically defined with hard coded definitions, then data access structure is stable and consistent, but user flexibility and ease of creating custom views deteriorates
Solution Approach 1:
The patent transforms static, hard-coded data views into dynamic views that can be modified at runtime. Users can interact with data models and views through a graphical interface, adding, removing, and modifying data elements without requiring application code changes. The system maintains stability through a structured data model framework while enabling dynamic customization through user interactions and runtime modifications.
Solution Approach 2:
The patent introduces a data model object as an intermediary layer between the underlying data sources and the user interface. This data model serves as a flexible mediator that can be dynamically configured and modified, allowing users to create custom views without directly accessing or modifying the underlying data structures. The data model object abstracts the complexity while providing adaptability.
2Adaptability or versatility
If data views are dynamically customizable, then user flexibility and interaction capability improves, but system complexity and difficulty of implementation worsens
Solution Approach 1:
The patent enables users to create and modify their own data views through a graphical interface without requiring programming expertise. The system provides self-service capabilities where users can interactively build custom views by selecting data elements, configuring display parameters, and modifying views through point-and-click operations. This eliminates the need for complex implementation while providing high user flexibility.
Solution Approach 2:
The patent replaces traditional mechanical approaches to view creation (hard-coded definitions requiring developer intervention) with an automated system that uses data model objects and graphical interfaces. The system automatically handles the complexity of view management, data binding, and interface generation, substituting manual configuration with automated processes that reduce overall system complexity.
3Power
If technical users configure data models and database systems, then data storage and processing capability improves, but ease of data access and understanding for non-technical users deteriorates
Solution Approach 1:
The patent introduces a data model object as an intermediary that bridges the gap between technical data infrastructure and non-technical users. This intermediary layer presents data in a simplified, intuitive format through graphical interfaces while maintaining connection to the powerful underlying data processing capabilities. Users interact with the data model rather than raw database structures, making data access easier without sacrificing processing power.
Solution Approach 2:
The patent replaces complex technical configurations with automated data model objects that handle the complexity of data processing internally. Non-technical users can access and manipulate data through simplified graphical interfaces without needing to understand underlying database structures or processing mechanisms. The system automatically manages the complex interactions between users, data models, and database systems.
4Reliability
If predefined data access methods are used, then system reliability and data consistency improves, but user interaction capability and analytical flexibility worsens
Solution Approach 1:
The patent creates dynamic data views that maintain consistency with predefined data models while allowing runtime modifications. Users can customize views by adding or removing data elements, changing display parameters, and configuring filters without compromising the underlying data consistency. The system dynamically adjusts views while maintaining integrity constraints defined in the data model, enabling both reliability and flexibility.
Solution Approach 2:
The patent makes data model objects universal entities that serve multiple functions: they ensure data consistency through predefined structures, enable flexible user interactions through graphical interfaces, and support various analytical operations. The same data model object can be used across different views and contexts, providing consistent data access while adapting to diverse user needs and analytical requirements.
Data Source
AI summary
Techniques and solutions are provided for providing software application functionality allowing users to perform analytical data operations. Software applications typically limit users to interacting with predefined data. Disclosed techniques allow users retrieve new data, or process data in different ways, by accessing lower-level objects, such as analytic queries defined in a virtual data model. An object of a data model defined for a collection of graphical user interfaces can be used to identify an analytical data object providing access to data defined by the data model. A query is executed to retrieve data corresponding to at least a portion of attributes defined in the data model. At least a portion of retrieved data is displayed. User input is received that requests a pivot operation, an operation to add a filter, or to add a multidimensional data element of the analytical data object to the graphical user interface display.