Data Abstraction Model Logical Field Mapping
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current database systems, particularly relational databases, are inefficient for users without a programming or IT background to access and manipulate data due to their complexity, requiring specialized training and limiting access to only those with technical expertise.
Innovation Solution
Integrating physical query statements into a data abstraction model by parsing and mapping output fields to logical fields, allowing users to compose abstract queries through intuitive interfaces, and generating new logical fields as needed to expose underlying physical database data.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If a programming language command based method (SQL) is used to access the database, then the database can be accessed with precise control and flexibility, but only people with programming or information technology background can access the database
Solution Approach 1:
The patent introduces an intermediary layer (abstract query system with logical fields) between the user and the physical database. This intermediary translates high-level user intentions into SQL commands, allowing non-technical users to access the database without learning SQL syntax while maintaining precise control over data access through the abstraction layer's mapping to physical tables and columns
2Ease of operation
If database abstraction techniques are used to provide an abstraction layer between physical database and users, then users can access database more easily without specialized training, but existing SQL-based queries cannot be integrated with the abstract database system
Solution Approach 1:
The patent makes the abstraction layer universal by enabling it to handle both abstract queries from non-technical users and existing SQL-based queries simultaneously. The system maps SQL query results to logical fields, allowing the abstraction layer to serve multiple functions: providing intuitive interfaces for new users while maintaining compatibility with existing SQL query libraries, thus achieving multi-functionality
3Productivity
If SQL queries are executed to generate tables from existing data, then the queries can retrieve and manipulate data effectively, but the generated tables are not part of the underlying relational database schema and cannot be used by abstract query based system
Solution Approach 1:
The patent creates a virtual copy of SQL query results within the abstraction layer by mapping query output columns to logical fields. Instead of physically integrating external tables into the database schema, the system creates virtual representations that behave as if they were native schema elements, allowing abstract queries to reference and manipulate SQL query results without actual schema modification
Data Source
AI summary
A method and system for integrating a physical query statement in a data abstraction model comprising a plurality of logical fields are provided. The method involves receiving the physical query statement and parsing the physical query statement to provide physical fields. The next step is determining whether the physical fields can be directly mapped to logical fields in the data abstraction model to yield a first determination result. Following this step, if at least one first physical field cannot be directly mapped to logical fields in the data abstraction model, then the next step is determining whether the first physical field can be determined from fields in the data abstraction model to yield a second determination result. Finally, the method involves providing a representation of the first determination result and a representation of the second determination result.