Gateway Translating Internet Requests to Legacy Database Commands
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Current data base management systems face challenges in providing secure and powerful access to proprietary databases via the Internet due to security issues and the stateless nature of Internet protocols, which limits the ability to link multiple transactions and maintain data state, hindering the execution of stored procedures.
Innovation Solution
A gateway system translates HTML transactions into database management system commands, implements a sophisticated security system for multiple access levels, and introduces state management through a repository to associate related service requests, enabling the execution of stored procedures and handling of variables without requiring extensive programming knowledge.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Adaptability or versatility
If Internet access is provided to proprietary database management systems, then universality and accessibility are improved, but security control deteriorates
Solution Approach 1:
The patent introduces a gateway as an intermediary component that sits between the Internet and the proprietary database management system. This gateway translates Internet-based service requests into the proprietary system's command language and manages security authentication, thereby enabling universal Internet access while maintaining the security control mechanisms of the proprietary system.
Solution Approach 2:
The patent transforms the stateless Internet protocol model into a stateful interaction model by implementing a repository that maintains transaction state information. This parameter change allows the system to track and control access across multiple transactions, improving security control while preserving Internet accessibility.
2Ease of operation
If stateless Internet protocols are used for database access, then simplicity and universality are improved, but the ability to link multiple transactions and maintain data state deteriorates
Solution Approach 1:
The gateway acts as an intermediary that handles the complexity of state management. It maintains a repository that stores state information for multiple transactions, allowing the Internet protocol to remain simple and stateless while the gateway internally manages the stateful requirements needed for executing stored procedures and linking transactions.
Solution Approach 2:
The patent creates a virtual representation of the proprietary database system's state management capabilities within the Internet environment. The gateway copies and adapts the state management mechanisms of the proprietary system into the Internet context, allowing complex state tracking without requiring changes to the underlying Internet protocol simplicity.
3Adaptability or versatility
If stored procedures are executed via Internet gateway, then database functionality is improved, but translation complexity between protocols increases
Solution Approach 1:
The gateway serves as a translation intermediary that converts service requests from Internet protocols into the proprietary database management system's command language. This enables full database functionality including stored procedures to be accessed via Internet while the gateway absorbs the translation complexity, keeping the client-side interface simple.
Solution Approach 2:
The system performs preliminary actions by pre-compiling and storing translation rules and command mappings in the gateway. This allows the complex protocol translation to be prepared in advance, reducing the complexity of real-time translation when executing stored procedures and other database functions.
Data Source
AI summary
An apparatus for and method of utilizing an Internet terminal coupled to the world wide web to access a legacy data base management system having a dialog-based request format to prepare, modify, and execute stored procedures. The user request is passed to the legacy data base management system via the Internet. The command type is determined whereby list, parameter, column, and execute commands are defined. In response to the user request, the scripted procedure is accessed, prepared, modified, or executed, as appropriate. Invalid and/or undefined requests result in an error response. Valid and defined requests result in performance of the requested command and transfer of an appropriate response to the user terminal.