Network-based database communication system

• US 8,060,541 B2
• Filed: 06/11/2009
• Issued: 11/15/2011
• Est. Priority Date: 03/17/2003
• Status: Active Grant

• Current Assignee: Centric Isolutions, Inc.
• Original Assignee: Be-Centric LLC
• Inventors: Dant, Robert
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US12/482,764
• Publication Number:
  US 20090287716A1
• Time in Patent Office: 887 Days
• Field of Search: 707/809
• US Class Current: 707/809
• CPC Class Codes: G06F 16/252 between a Database Management System and a front-end application
• CPC Class Codes: G06F 16/256 in federated or virtual databases
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

The present invention is a communication system. Further, the present invention relates to a database communication system that allows for communication between disparate databases.

Claims

1. A database system comprising:

a database;

a sync application configured to receive first outgoing information from the database; and

a communication component associated with the sync application, the communication component configured to identify a target database system to receive the first outgoing information, wherein the sync application is configured to transmit the first outgoing information to the target database system.

2. The database system of claim 1 further comprising a translation component associated with the sync application, the translation component configured to translate the first outgoing information into a format compatible with the target database system.

3. The database system of claim 2 wherein the translation component comprises:

a dictionary component comprising format information for the target database;

a translator component configured to utilize the format information to translate the outgoing information into a format compatible with the target database.

4. The database system of claim 1 wherein the first outgoing information comprises date information and time information relating to transmission of the first outgoing information.

5. The database system of claim 1 further comprising:

a transmission tracking database in communication with the sync application, the transmission tracking database configured to receive the first outgoing information that could not be transmitted out of the database system; and

a transmission tracking component in communication with the tracking database, the transmission tracking component configured to track a period of time that the first outgoing information could not be transmitted.

6. The database system of claim 5 wherein the transmission tracking component is further configured to transmit a message to an administrator after a predefined period of time.

7. The database system of claim 5 wherein the transmission tracking component is further configured to transmit the first outgoing information out of the database system.

8. The database system of claim 1 further comprising:

an application tracking database in communication with the sync application, the application tracking database configured to receive first incoming information that could not be applied to the database; and

an application tracking component in communication with the application tracking database, application tracking component configured to track a period of time that the first incoming information could not be applied to the database.

9. The database system of claim 8 wherein the application tracking component is further configured to transmit a message to an administrator after a predefined period of time.

10. The database system of claim 8 wherein the application tracking component is further configured to apply the first incoming information to the database.

11. The database system of claim 1 further comprising a connection component in communication with the database and an external system.

12. The database system of claim 11 further comprising a gathering component in communication with the connection component, the gathering component configured to receive second incoming information from the external system and transmit the second incoming information to the connection component.

13. The database system of claim 11 further comprising a delivery component in communication with the connection component, the delivery component configured to receive second outgoing information from the connection component and transmit the second outgoing information to the external system.

14. A database system comprising:

a database;

a sync application configured to receive first outgoing information from the database; and

a communication component associated with the sync application, the communication component configured to identify a target database system to receive the first outgoing information, wherein the sync application is configured to transmit the first outgoing information to the target database system,

wherein the database system and the target database system are disparate database system types.

15. The database system of claim 14 further comprising a translation component associated with the sync application, the translation component configured to translate the first outgoing information into a format compatible with the target database system.

16. The database system of claim 15 wherein the translation component comprises:

a dictionary component comprising format information for the target database;

a translator component configured to utilize the format information to translate the outgoing information into a format compatible with the target database.

17. The database system of claim 14 wherein the first outgoing information comprises date information and time information relating to transmission of the first outgoing information.

18. The database system of claim 14 further comprising:

a transmission tracking database in communication with the sync application, the transmission tracking database configured to receive the first outgoing information that could not be transmitted out of the database system; and

a transmission tracking component in communication with the tracking database, the transmission tracking component configured to track a period of time that the first outgoing information could not be transmitted.

19. The database system of claim 18 wherein the transmission tracking component is further configured to transmit a message to an administrator after a predefined period of time.

20. The database system of claim 18 wherein the transmission tracking component is further configured to transmit the first outgoing information out of the database system.

21. The database system of claim 14 further comprising:

an application tracking database in communication with the sync application, the application tracking database configured to receive first incoming information that could not be applied to the database; and

an application tracking component in communication with the application tracking database, application tracking component configured to track a period of time that the first incoming information could not be applied to the database.

22. The database system of claim 21 wherein the application tracking component is further configured to transmit a message to an administrator after a predefined period of time.

23. The database system of claim 21 wherein the application tracking component is further configured to apply the first incoming information to the database.

24. The database system of claim 14 further comprising a connection component in communication with the database and an external system.

25. The database system of claim 24 further comprising a gathering component in communication with the connection component, the gathering component configured to receive second incoming information from the external system and transmit the second incoming information to the connection component.

26. The database system of claim 24 further comprising a delivery component in communication with the connection component, the delivery component configured to receive second outgoing information from the connection component and transmit the second outgoing information to the external system.

27. A database system on a network, the database system comprising:

a database;

and an identification application in communication with the database, the identification application configured to apply a unique identification to a record in the database, whereby the record has a unique record identification in the network.

28. A method of network-based communication comprising:

designating a unique identifier for a database system on a network, wherein the unique identifier provides a unique identification across the network for each record in the database system;

establishing synchronized communications between the database system and any other database system on the network.