System for inter-database communication

• US 20060235852A1
• Filed: 04/14/2005
• Published: 10/19/2006
• Est. Priority Date: 04/14/2005
• Status: Abandoned Application

• Current Assignee: Lockheed Martin Corporation (Martin Marietta Corporation)
• Original Assignee: Lockheed Martin Corporation (Martin Marietta Corporation)
• Inventors: Gaug, Mark
• Application Number:
  US11/105,693
• Publication Number:
  US 20060235852A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/2471 Distributed queries

Abstract

A system aggregates communication data. The system includes a client and a data access gateway. The data access gateway receives a single request from the client. The data access gateway composes a first query and a second query. The first query and the second query together satisfy the single request from the client. The data access gateway simultaneously routes the first query and the second query to a first database and a second database, respectively. The first database receives the first query from the data access gateway. The first database formulates a first response corresponding to the first query from the data access gateway. The first database provides the first response to the data access gateway. The second database receives the second query from the data access gateway. The second database formulates a second response corresponding to the second query from the data access gateway. The second database provides the second response to the data access gateway. The data access gateway aggregates the first response and the second response to produce a single aggregated response for the client. The aggregated response comprises data from both the first and second responses. The data satisfies the single request from the client.

Claims

1. A system for aggregating communication data, said system comprising:

a client; and

a data access gateway for receiving a single request from said client, said data access gateway composing a first query and a second query, said first query and said second query together satisfying the single request from said client, said data access gateway simultaneously routing said first query and said second query to a first database and a second database, respectively,

said first database receiving said first query from said data access gateway, said first database formulating a first response corresponding to said first query from said data access gateway, said first database providing said first response to said data access gateway,

said second database receiving said second query from said data access gateway, said second database formulating a second response corresponding to said second query from said data access gateway, said second database providing said second response to said data access gateway,

said data access gateway aggregating said first response and said second response to produce a single aggregated response for said client, said aggregated response comprising data from both said first and second responses, said data satisfying said single request from said client.

2. The system as set forth in claim 1 wherein said data access gateway includes a business logic tier for validating the plurality of requests.

3. The system as set forth in claim 1 wherein said data access gateway includes a business logic tier for creating the first query and the second query.

4. The system as set forth in claim 1 wherein said data access gateway includes a business logic tier for validating the first response from the first database and the second response from the second database.

5. The system as set forth in claim 1 wherein said data access gateway includes a business logic tier for aggregating the first response and the second response.

6. The system as set forth in claim 1 wherein said data access gateway includes a data tier for asynchronously communicating with the first database and the second database.

7. The system as set forth in claim 1 wherein said data access gateway includes a data tier for translating the first response and the second response into a common format.

8. The system as set forth in claim 1 wherein said first database and said second database independent and part of a common database, said first and second databases residing on multiple systems.

9. The system as set forth in claim 1 wherein said data access gateway communicates with said first database asynchronously.

10. The system as set forth in claim 9 wherein said data access gateway communicates with said second database asynchronously, said data access gateway simultaneously contacting and retrieving data from multiple data stores.

11. A data access gateway for aggregating communication data, said data access gateway comprising:

a first data tier;

a second data tier; and

a business logic tier for receiving a single request from a client, said business logic tier composing a plurality of requests, said plurality of requests satisfying the single request from the client,

said plurality of requests comprising a first request and a second request, said business logic tier simultaneously routing said first request to said first data tier and said second request to said second data tier,

said first data tier receiving said first request from said business logic tier, said first data tier formulating a first query corresponding to said first request from said business logic tier, said first data tier routing said first query to a first database, said first data tier receiving a first response from the first database and asynchronously routing the first response to said business logic tier,

said second data tier receiving said second request from said business logic tier, said second data tier formulating a second query corresponding to said second request from said business logic tier, said second data tier routing said second query to a second database, said second data tier receiving a second response from the second database and asynchronously routing the second response to said business logic tier,

said data access gateway aggregating the first response and the second response to produce a single aggregated response for the client, said aggregated response comprising data from both the first and second databases, said aggregated response satisfying the single request from the client.

12. The data access gateway as set forth in claim 11 wherein said business logic tier includes an output service agent for communicating with said data tier.

13. The data access gateway as set forth in claim 11 wherein said business logic tier includes a service facade for communicating with the client and an aggregator service agent for communicating with said service facade.

14. The data access gateway as set forth in claim 12 wherein said business logic tier includes an aggregator for translating responses from said data tier into a common format.

15. The data access gateway as set forth in claim 11 wherein said business logic tier includes a configuration file.

16. A computer program product for aggregating communication data, said computer program product comprising:

a first instruction for receiving requests by a business logic tier from a client;

a second instruction for transforming the requests into a plurality of requests;

a third instruction for transferring each request from the business logic tier to an appropriate data tier;

a fourth instruction for receiving a request from the business logic tier by the appropriate data tier;

a fifth instruction for routing requests from a data tier to an appropriate database and receiving responses from an appropriate database by the data tier;

a sixth instruction for asynchronously routing a data response from the appropriate database to the business logic tier;

a seventh instruction for receiving results by the business logic tier;

an eighth instruction for aggregating the results from appropriate data tiers into a single aggregated response; and

a ninth instruction for routing the single aggregated response to the client.

17. The computer program product as set forth in claim 16 further including a tenth instruction for updating a plurality of interfaces without recompiling said plurality of interfaces.

18. The computer program product as set forth in claim 16 further including a tenth instruction for anticipating a format of the first request.

19. The computer program product as set forth in claim 16 further including a tenth instruction for validating data from the data tier.

20. The computer program product as set forth in claim 16 further including a tenth instruction for determining a common format of the single aggregate response.