Aggregated Database Views with Automatic Property Harmonization
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing approaches for aggregating data across multiple databases are difficult to maintain and can break when underlying databases are modified or deleted, requiring technical skill and being prone to disruptions.
Innovation Solution
A system that aggregates data across multiple databases using a block model with unique identifiers, automatic harmonization, and machine learning to map properties, ensuring robustness against database changes and providing dynamic, user-friendly database structures.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If traditional aggregated database views are used, then data can be viewed across multiple databases, but the views break when underlying databases are modified or deleted
Solution Approach 1:
The patent introduces an intermediary layer between the aggregated view and underlying databases. This intermediary automatically detects database changes and updates the aggregated view accordingly, preventing view breakage. The intermediary acts as a mediator that handles the complexity of database change management, allowing the aggregated view to remain stable while databases evolve.
Solution Approach 2:
The system implements self-service through automatic detection and adaptation mechanisms. When databases are modified or deleted, the system automatically detects these changes and updates the aggregated view without requiring manual intervention. This self-service capability eliminates the need for technical skill to maintain aggregated views and prevents disruptions.
2Ease of operation
If manual aggregation approaches are used, then data can be combined from multiple sources, but technical skill is required and maintenance is difficult
Solution Approach 1:
The system performs self-service by automatically detecting database changes and adapting aggregated views without human intervention. The automatic detection mechanism monitors underlying databases for modifications or deletions and updates the view structure accordingly, eliminating the need for technical skill to maintain aggregations.
Solution Approach 2:
The system dynamically changes parameters of the aggregated view based on detected database modifications. When databases change, the system adjusts view parameters such as data sources, query structures, and display configurations automatically, making the system easy to operate while managing complexity internally.
3Adaptability or versatility
If static aggregated views are created, then data can be displayed, but the views cannot adapt to database changes
Solution Approach 1:
The system maintains continuous operation of aggregated views through real-time or near-real-time detection and adaptation mechanisms. The automatic detection continuously monitors database changes and updates views without interruption, ensuring continuous useful action while adapting to changes. This eliminates downtime and maintains view availability.
Solution Approach 2:
The system performs preliminary actions by proactively detecting database changes before they cause view breakage. The automatic detection mechanism monitors for modifications and prepares update sequences in advance, allowing smooth transitions without disrupting view access. This preliminary action prevents disruptions while maintaining adaptability.
Data Source
AI summary
A system may identify a plurality of databases in a scope, to be included in an aggregated view, each database of the plurality of databases comprising data used to populate one or more blocks of an integrated workspace, each block comprising one or more properties, the one or more properties comprising at least one common property, wherein the scope is a grouping of hierarchically organized blocks of a render tree. A system may retrieve one or more blocks associated with each database. A system may harmonize a first database and a second database of the plurality of databases by determining a mapping of one or more of the first database to one or more properties of the second database. A system may generate the aggregated view of the one or more blocks, wherein the aggregated view includes a display of at least the at least one common property.