Mapping Service Translates Database Artifacts
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Client applications face complexity and reduced flexibility due to the need to account for database schema details when accessing databases using Structured Query Language (SQL), which increases development difficulties and reduces performance.
Innovation Solution
Implementing a mapping service at the application server or database management system that translates database artifacts into a format consumable by client applications, reducing the need for clients to know database schema specifics and leveraging in-memory database performance.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Ease of operation
If client applications access database directly using SQL, then data access capability is achieved, but client application complexity increases
Solution Approach 1:
The patent introduces a mapping service as an intermediary layer between client applications and the database. This mapping service translates database artifacts into a simplified format that client applications can consume without needing to understand underlying database schema complexities. The mapping service acts as a mediator that handles the complexity of database interactions while presenting a simplified interface to clients.
Solution Approach 2:
The patent creates translation artifacts that are simplified copies or representations of actual database artifacts. Instead of requiring client applications to directly interact with complex database schemas, the system generates and exposes simplified translation artifacts that mirror the essential functionality and structure of the database objects, making them easier for clients to consume and work with.
2Adaptability or versatility
If client applications access database using SQL, then data access is enabled, but development flexibility is reduced
Solution Approach 1:
The mapping service serves as a flexible intermediary that can adapt to different client application needs while maintaining a consistent interface. It allows client applications to access database functionality in a standardized way through translation artifacts, providing versatility in how applications can interact with the database without being constrained by specific SQL implementations or schema details.
Solution Approach 2:
The mapping service provides a universal interface for accessing database artifacts through translation artifacts. This universal approach allows different types of client applications to interact with the database in a consistent manner, regardless of the underlying database schema complexity, thereby enhancing adaptability and versatility across different application scenarios.
3Measurement precision
If database schema details are exposed to client applications, then data access precision is maintained, but processing performance decreases
Solution Approach 1:
The system creates simplified translation artifacts that are copies or representations of actual database artifacts. These translation artifacts maintain the essential data access capabilities and precision needed for client applications while being optimized for performance. By working with these simplified representations rather than directly accessing complex database schemas, the system achieves both data access precision and improved processing performance.
Solution Approach 2:
The mapping service acts as a performance-optimized intermediary that handles data access operations. It maintains precision in data access by accurately translating between client requests and database operations, while simultaneously optimizing performance by managing the complexity of schema interactions on the server side rather than in client applications.
Data Source
AI summary
Various examples are directed to exposing database artifacts. For example, a rules engine may receive schema data describing a database schema of an in-memory database. The schema data may describe a table, a view, and a procedure. The rules engine may generate a data model comprising a plurality of translation artifacts including a table translation artifact describing a table of the database schema, a view translation artifact describing a view of the database schema, and a procedure translation artifact describing a procedure of the database schema. A mapping service may receive from a client application a first client request comprising first metadata describing the view translation artifact. The mapping service may initiate execution of the view at an in-memory database to determine a view result; and send the view result to the client application.