Intermediary Database Structure for Multi-Model Querying
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems lack standardization, making it difficult to manage databases with different models using a single system, and existing solutions require replacing entire database systems, which is impractical for organizations like healthcare providers.
Innovation Solution
A database system with a hierarchical tree-like structure that uses multi-character expressions to provide access to data from various database models, allowing for fast querying and context switching by assigning unique expressions to entities, attributes, and entity occurrences, and storing them in an intermediary data structure.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If an intermediary data structure with hierarchical tree-like structure is introduced to access data from multiple database models, then adaptability and ease of operation are improved, but device complexity increases
Solution Approach 1:
The patent introduces an intermediary data structure with a hierarchical tree-like structure that acts as a mediator between users and multiple database models. This intermediary layer translates queries from different database models into a unified interface, enabling adaptability across various database systems without requiring users to learn multiple complex query languages. The intermediary structure resolves the contradiction by absorbing the complexity of multiple database models while presenting a simplified, standardized interface.
2Speed
If multi-character expressions are assigned to entities, attributes, and entity occurrences to enable fast querying, then speed and productivity are improved, but device complexity increases
Solution Approach 1:
The patent applies preliminary action by pre-assigning multi-character expressions to all entities, attributes, and entity occurrences in the database structure before queries are executed. These expressions are stored in advance in the hierarchical tree-like structure, enabling rapid query processing through pattern matching against the pre-established expression framework. This preliminary structuring eliminates the need for complex real-time processing during queries, thereby improving speed while the system architecture manages the complexity through automated expression generation and matching mechanisms.
3Ease of operation
If a unified interface database is created to access data from multiple database models, then ease of operation is improved, but loss of information may occur due to data transformation requirements
Solution Approach 1:
The patent segments the data access system into distinct layers: the underlying database models remain intact with their original structures and data, while a separate hierarchical tree-like interface layer handles the unified access operations. This segmentation allows the interface to translate and transform data queries without modifying the original databases, thereby maintaining data integrity and preventing information loss. The hierarchical structure enables selective access to different levels of data granularity, ensuring that information is retrieved accurately while presenting it through a simplified, standardized interface.
Data Source
AI summary
A method of querying a database system, the database system comprising at least one database populated with a plurality of unique, multi-character expressions associated with the data entities of the at least one database, the method comprising: providing a graphical user interface for receiving at least one input selection from a user defining a database query expression; scanning the at least one database with the database query expression to obtain a first set of results; parsing the first set of results with a user profile expression associated with the user to obtain a second set of results, the user profile expression comprising a unique, multi-character expression; and displaying the second set of results in the graphical user interface.


