Configuration Engine for Dynamic Database Schema Interfaces
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional non-relational databases do not allow for streamlined composition of reading and/or updating queries of separate but related sources of data, leading to rigid modifications that require deployments and result in inaccuracies and mismatched data.
Innovation Solution
A configuration engine is used to dynamically generate user interfaces for creating and modifying database schemas, allowing users to select presentational options and establish relationships between data, enabling real-time or near real-time updates without disruptions.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Quantity of substance
If conventional non-relational databases are used to store data, then data storage capacity is improved, but the ability to compose reading and updating queries of separate but related sources of data deteriorates
Solution Approach 1:
The patent introduces a configuration engine as an intermediary layer between the non-relational database and the user interface. This engine dynamically generates user interfaces that enable streamlined composition of reading and updating queries across separate data sources, effectively mediating between the flexible storage of non-relational databases and the need for structured data access operations.
2Ease of manufacture
If conventional user interfaces are used for data management, then initial setup is simplified, but adaptability to database schema changes deteriorates
Solution Approach 1:
The patent implements dynamic user interfaces that are generated at runtime based on the current database schema configuration. When the schema changes, the configuration engine automatically regenerates the appropriate user interfaces without requiring deployments or manual updates, making the system adaptable to schema evolution while maintaining ease of operation.
Solution Approach 2:
The system performs preliminary actions by pre-defining schema configurations and data relationships in advance. This allows the configuration engine to automatically generate appropriate user interfaces based on these pre-established schemas, simplifying both initial setup and subsequent adaptations when schemas change.
3Reliability
If data relationships are updated in the database, then data accuracy is improved, but the complexity of maintaining relationships across multiple sources increases
Solution Approach 1:
The configuration engine acts as an intermediary that automatically manages the complexity of maintaining data relationships across multiple sources. It handles the coordination of updates across related data sources based on the configured relationships, ensuring data accuracy without requiring users to manually manage complex inter-source relationships.
Data Source
AI summary
Arrangements for database schema creation and control are provided. In some aspects, a user may request creation or modification of a database schema. In response to receiving the request, one or more interactive user interfaces may be generated. The one or more interactive user interfaces may enable a user to select one or more selectable options for presenting data, establishing relationships between data, data sources, and the like. The schema, including a schema configuration including the presentational aspects and relationships, may be stored. A user may request to view data and the stored database schema may be retrieved. The schema may be transmitted to a configuration engine that may retrieve the requested data from one or more non-relational database sources. One or more user interfaces may be dynamically generated based on the schema configuration and may include the retrieved data.