Program Processor Driver for Database Interface Translation
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Client applications face increased complexity when interfacing with database servers that use different programming interfaces, requiring specific instructions for each interface and complicating the development process.
Innovation Solution
A Program Processor Driver (PPD) system generates instructions consistent with the programming interface requirements of the database server, allowing client applications to operate independently of these requirements and sending data about the programming environment to further simplify implementation.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If client applications provide different instructions for each database server programming interface, then compatibility with different database servers is achieved, but programming complexity increases
Solution Approach 1:
The patent introduces a server system as an intermediary between the client application and multiple database servers. The server system receives a single standardized instruction format from the client application and automatically translates it into the appropriate programming interface-specific instructions for each target database server. This mediator approach allows the client application to maintain simplicity while achieving compatibility with diverse database servers through the translation capability of the intermediate server system.
Solution Approach 2:
The server system implements a universal instruction interface that can communicate with multiple different database server types through a single standardized protocol. Rather than requiring the client application to implement multiple specialized interfaces, the universal server system handles the adaptation to various database server programming interfaces, enabling one client application to access multiple different database servers without modification.
2Reliability
If client applications adapt to specific programming interface requirements, then database server functionality is accessed, but development time increases
Solution Approach 1:
The server system performs the complex adaptation and translation work in advance, establishing a pre-configured mapping between the standardized client instruction format and the various database server programming interfaces. This preliminary setup eliminates the need for developers to perform time-consuming adaptation work for each database server integration, as the translation logic is already prepared and configured in the server system before the client application needs to access the databases.
3Adaptability or versatility
If multiple programming interfaces are supported directly in client applications, then database server versatility is achieved, but ease of operation decreases
Solution Approach 1:
The server system acts as an intermediary that shields the client application from the complexity of multiple programming interfaces. The client application interacts with a single, simplified instruction format provided by the server system, which then handles the translation to appropriate interface-specific instructions. This intermediary approach maintains ease of operation for the client application while still achieving versatility in supporting multiple database server types through the server system's translation capability.
Data Source
AI summary
Reducing programming complexity in client applications when interfacing with database servers operating with corresponding programming interfaces. In one embodiment, a client system merely specifies a procedure of interest to be executed on a database server of interest, and a system forms the specific instructions according to the programming interface requirements of the specific database server. Thus, the client applications may be implemented independent of the programming interface requirements of the database servers. The client system may also send data indicating the programming environment (e.g., Java or Visual Basic) in which applications are supported (in the client system). The application sever may form the instructions consistent with the programming environment as well, thereby further reducing the complexity of implementations in the client applications.