Logical Object Search Framework for Relational Database Query Translation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Existing data management systems face challenges in efficiently bridging relational and object-oriented environments, requiring complex translations and multiple database schemas for query execution, which increases training and implementation costs and reduces user flexibility.
Innovation Solution
A logical object search framework and API that provides a pre-defined logical schema to translate object-oriented queries into relational query language, allowing users to execute queries across multiple relational database entities without needing to know the underlying physical database structure, simplifying query execution and integration across different database types.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If multiple database schemas are used to bridge relational and object-oriented environments, then query execution capability is improved, but device complexity and training costs increase
Solution Approach 1:
The patent introduces a query translator as an intermediary component that mediates between object-oriented queries and relational database schemas. The translator receives object-oriented queries, translates them into relational query language, and executes them against the database, eliminating the need for users to directly interact with multiple database schemas.
Solution Approach 2:
The patent creates a universal query interface that accepts queries in object-oriented language and automatically adapts them to work with underlying relational database schemas. This single interface handles multiple database types and schemas, providing multi-functionality without requiring users to learn multiple query languages.
2Adaptability or versatility
If multiple database schemas are maintained for different database types, then data storage flexibility is improved, but ease of operation deteriorates
Solution Approach 1:
The query translator serves as an intermediary that hides the complexity of multiple database schemas from users. Users interact with a single unified interface using object-oriented queries, while the translator handles the translation and adaptation to different underlying relational schemas, maintaining both flexibility and simplicity.
3Measurement precision
If complex translations between object-oriented and relational query languages are performed, then query execution accuracy is improved, but processing time increases
Solution Approach 1:
The system performs preliminary translation of object-oriented queries into relational query language before execution. By pre-translating and validating queries, the system ensures accurate mapping of object-oriented concepts to relational structures, improving execution accuracy while preparing the query in advance for efficient processing.
Data Source
AI summary
A method, computer program product, and system for executing and administering queries in a data management system, and particularly a relational data management system. Logical objects can be queried by providing a translation from a logical query in a pre-defined logical schema to a physical query against the physical data management system, such as by translating a database query constructed using an Object Query Language (OQL) into a query in Structured Query Language (SQL) without the user needing to know the details of the physical data management system such as the structure of the underlying relational databases.