System and Method for Providing Remote Access to Events From A Database Access System

• US 20080016146A1
• Filed: 02/07/2007
• Published: 01/17/2008
• Est. Priority Date: 07/14/2006
• Status: Active Grant

• Current Assignee: Raytheon Company (Rtx Corporation)
• Original Assignee: Raytheon Company (Rtx Corporation)
• Inventors: Cress, Derek C., Gan, Zhen-Qi, Northrup, Max W.
• Granted Patent: US 7,865,487 B2
• Time in Patent Office: Days
• US Class Current: 709/203
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation

Abstract

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.

Claims

1. A database access system comprising:

a web browser;

a distributed database comprising;

a plurality of federated databases for storage of a plurality of data records; and

a metadata database for storage of a plurality of metadata records each representing a corresponding one of the plurality data records;

a data event agent that is coupled to the distributed database using a database proxy layer, the data event agent also being coupled to the web browser through a firewall, the data event agent being operable to;

receive a query comprising contextual, temporal, or geo-spatial filter criteria from the web browser;

store the query in a memory;

filter at least one of the plurality of metadata records against the query in response to an addition or modification of the at least one metadata record; and

in the event that the at least one metadata record matches the query, transmit the corresponding one of the plurality of data records to the web browser.

2. The database access system of claim 1, wherein the plurality of federated databases are coupled to the data event agent using a database proxy layer.

3. The database access system of claim 2, wherein the database proxy layer is operable to convert each of the plurality of data records into a standardized format using an extensible markup language schema.

4. The database access system of claim 1, wherein the distributed database further comprises a data discovery agent that is operable to periodically search each of the federated databases and in the event that a new data record is found, create the corresponding metadata record.

5. A database access system comprising:

a remote client application;

a database for storage of a plurality of data records;

a data event agent that is coupled to the database through a database proxy layer, the data event agent also coupled to the remote client application through a firewall, the data event agent being operable to;

receive a query from the remote client application;

store the query in a memory;

filter one of the plurality of data records against the query in response to an addition or modification of the one data record in the database; and

in the event that the one data record matches the query, transmit the one data record to the remote client application.

6. The database access system of claim 5, wherein the data record is stored in a distributed database comprising a plurality of federated databases and a metadata database.

7. The database access system of claim 6, wherein the data record comprises a data record portion and a metadata record portion, the data record portion being stored in the federated database and the metadata record portion being stored in the metadata database.

8. The database access system of claim 7, wherein the database proxy layer is operable to encapsulate each of the data record portions into a standardized data record and expose the standardized data record for use by the remote client application.

9. The database access system of claim 8, wherein the database proxy layer is implemented according to an extensible markup language schema.

10. The database access system of claim 5, wherein the data record is exposed to the data event agent using an application abstraction layer.

11. The database access system of claim 10, wherein the application abstraction layer is implemented using a Java messaging service.

12. The database access system of claim 11, wherein application abstraction layer is configured to format the data record according to a simple object access protocol schema.

13. The database access system of claim 5, wherein the query is operable to filter data records according to a filter criteria that is selected from the group consisting of geo-spatial, contextual, or temporal filter criteria.

14. The database access system of claim 5, wherein the data event agent is coupled to the remote client application through the Internet.

15. The database access system of claim 5, wherein the remote client application is a web browser.

16. A method comprising:

generating a query by a remote client application, the query including at least one type of filter criteria;

transmitting the query to a database access system through a firewall;

storing the query in a memory;

filtering additions or modifications to a plurality of data records in the database access system against the at least one type of filter criteria; and

in the event that a particular one of the plurality of data records matches the at least one type of filter criteria, transmitting the data record to the remote client application through the firewall.

17. The method of claim 16, wherein generating a query by a remote client application comprises generating a query by a web browser, and transmitting the data record to the remote client application comprises transmitting the data record to the web browser.

18. The method of claim 16, wherein generating a query by a remote client application that includes at least one type of filter criteria comprises generating a query by a remote client application that includes at least one type of filter criteria that is selected from the group consisting of contextual, temporal, or geo-spatial filter criteria.

19. The method of claim 16, wherein transmitting the query to a database access system through a firewall comprises transmitting the query to a database access system having a distributed database through a firewall.

20. The method of claim 16, wherein prior to the act of transmitting the data record to the remote client application through the firewall, encapsulating the data record in a format according to a simple object access protocol schema.