Remote Database Access via Data Event Agent
Find Innovative SolutionsGenerate Solutions
Solution Overview
Problem
Conventional database systems do not effectively provide remote access to future additions or modifications of data records across a firewall, limiting access to users outside the firewall and lacking continuous monitoring and filtering capabilities.
Innovation Solution
A database access system comprising a remote client application, a database, and a data event agent that filters and transmits data records matching query criteria through a firewall, using a data event agent coupled to the database and capable of monitoring for additions or modifications, with features like a database proxy layer and application abstraction layer for standardized data transmission.
Engineering Contradictions & Design Principles
Engineering Contradiction Analysis
1Reliability
If a database is placed behind a firewall for security, then security is improved, but remote access to data records is lost
Solution Approach 1:
The data event agent serves as an intermediary component that bridges the firewall and remote client applications. It accepts queries from remote clients through the firewall, filters data records, and transmits matching records to remote applications, thereby enabling remote access while maintaining firewall security boundaries.
Solution Approach 2:
The system segments the database access functionality into distinct components: the database itself remains protected behind the firewall, while the data event agent operates as a separate service that handles query processing and data transmission. This segmentation allows remote access capabilities to be added without compromising the security of the core database.
2Ease of operation
If continuous monitoring of data records is implemented, then data accessibility is improved, but system complexity increases
Solution Approach 1:
The data event agent implements self-service by automatically and continuously monitoring the database for additions or modifications of data records that match stored query criteria. Once a match is detected, the agent autonomously transmits the relevant data record to the appropriate remote client application without requiring manual intervention or complex orchestration.
3Adaptability or versatility
If remote access to future data record additions is enabled, then data utility is improved, but network security risks increase
Solution Approach 1:
The system performs preliminary action by storing query criteria in advance in the data event agent. When future data records are added to the database, the pre-stored query criteria enable immediate identification and transmission of matching records. This eliminates the need for continuous active polling and reduces network traffic, thereby maintaining data utility while minimizing security exposure.
Data Source
AI summary
In one embodiment, a database access system includes a remote client application, a database having a plurality of data records, and a data event agent. The database has a plurality of data records and is coupled to the data event agent. The data event agent is remotely coupled to the remote client application through a firewall and operable to receive a query from the remote client application. In response to receipt of the query, the data event agent stores the query in memory in order to continually filter additions and modifications to data records against the one or more filter criteria included in the query. In the event that a data record matches the query, the data event agent transmits the data record to the remote client application.