Network-based database communication system

• US 20040249788A1
• Filed: 03/17/2004
• Published: 12/09/2004
• Est. Priority Date: 03/17/2003
• Status: Active Grant

• Current Assignee: Centric Isolutions, Inc.
• Original Assignee: Be-Centric LLC
• Inventors: Dant, Robert
• Granted Patent: US 7,584,197 B2
• Time in Patent Office: Days
• US Class Current: 707/1
• 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 communication network comprising:

a first database system;

a second database system in communication with the first database system; and

an identification system in communication with each of the first and second database systems, the identification system configured to provide a database identification to each of the first and second database systems.

2. The database communication network of claim 1 wherein the database identification is a first unique database identification associated with the first database system and a second unique database identification associated with the second database system.

3. The database communication network of claim 2 wherein the first and second unique database identifications result in unique identification for each record in the communication network.

4. The database communication network of claim 1, wherein the first database system comprises:

a first database; and

a first server configured to receive first information from the first database and transmit the first information out of the first database system.

5. The database communication network of claim 4, wherein the first server comprises a first communication component configured to identify a database system in communication with the first database system to receive the first information.

6. The database communication network of claim 4, wherein the first server comprises a first translation component configured to translate the first information into a format compatible with any database system in communication with the first database system.

7. The database communication network of claim 6, wherein the first translation component comprises:

a first dictionary component comprising format information for any database system in communication with the first database system; and

a first translator component configured to utilize format information from the first dictionary component to translate the first information into a format compatible with any database system in communication with the first database system.

8. The database communication network of claim 4, further comprising a first matching component in communication with the first database, the first matching component configured to receive information regarding an expected first transaction and compare the information regarding the expected first transaction with information regarding an actual first transaction at the first database.

9. The database communication network of claim 8, wherein the first matching component is further configured to cause a first matching notification to be transmitted out of the first database system if the information regarding the expected first transaction matches the information regarding the actual first transaction.

10. The database communication network of claim 8, wherein the first matching component is further configured to cause a first non-matching notification to be transmitted out of the first database system if the information regarding the expected first transaction does not match the information regarding the actual first transaction.

11. The database communication network of claim 4, wherein the second database system comprises:

a second database; and

a second server configured to receive second information from the second database and transmit the second information out of the second database system.

12. The database communication network of claim 11, wherein the second server comprises a second communication component configured to identify a database system in communication with the second database system to receive the second information.

13. The database communication network of claim 11, wherein the second server comprises a second translation component configured to translate the second information into a format compatible with any database system in communication with the second database system.

14. The database communication network of claim 13, wherein the second translation component comprises:

a second dictionary component comprising format information for any database system in communication with the second database system; and

a second translator component configured to utilize format information from the second dictionary component to translate the second information into a format compatible with any database system in communication with the second database system.

15. The database communication network of claim 11, further comprising a second matching component in communication with the second database, the second matching component configured to receive information regarding an expected second transaction and compare the information regarding the expected second transaction with information regarding an actual second transaction received at the second database.

16. The database communication network of claim 15, wherein the second matching component is further configured to cause a second matching notification to be transmitted out of the second database system if the information regarding the expected second transaction matches the information regarding the actual second transaction.

17. The database communication network of claim 15, wherein the second matching component is further configured to cause a second non-matching notification to be transmitted out of the second database system if the information regarding the expected second transaction does not match the information regarding the actual second transaction.

18. The database communication network of claim 1, further comprising a first external system in communication with the first database system.

19. The database communication network of claim 18, wherein the first database system further comprises a first connection component in communication with the first database and the first external system.

20. The database communication network of claim 19, wherein the first external system is configured to input data into the first database system, the first external system comprising:

a first gathering component in communication with the first connection component, the first gathering component configured to receive external data and transmit the external data to the first connection component; and

at least one first external file in communication with the first gathering component, the at least one first external file configured to provide the external data to the first gathering component.

21. The database communication network of claim 19, wherein the first external system is configured to receive data from the first database system, the first external system comprising:

a first delivery component in communication with the first connection component, the first delivery component configured to receive data from the first connection component and transmit the data; and

at least one first external file in communication with the first delivery component, the at least one first external file configured to receive the data from the first delivery component.

22. The database communication network of claim 18, further comprising a second external system in communication with the second database system.

23. The database communication network of claim 22, wherein the second database system further comprises a second connection component in communication with the second database and the second external system.

24. The database communication network of claim 23, wherein the second external system is configured to input data into the second database system, the second external system comprising:

a second gathering component in communication with the second connection component, the second gathering component configured to receive external data and transmit the external data to the second connection component; and

at least one second external file in communication with the second gathering component, the at least one second external file configured to provide the external data to the second gathering component.

25. The database communication network of claim 23, wherein the second external system is configured to receive data from the second database system, the second external system comprising:

a second delivery component in communication with the second connection component, the second delivery component configured to receive data from the second connection component and transmit the data; and

at least one second external file in communication with the second delivery component, the at least one second external file configured to receive the data from the second delivery component.

26. The database communication network of claim 4, wherein the first database system further comprises:

a first transmission tracker file in communication with the first server, the first transmission tracker file configured to receive the first information that could not be transmitted out of the first database system; and

a first transmission time tracking component in communication with the first transmission tracker file, the first transmission time tracking component configured to track a period of time that the first information could not be transmitted, the time tracking component further configured to transmit a message to an administrator after a predefined period of time.

27. The database communication network of claim 4, wherein the first database system further comprises:

a first application tracker file in communication with the first server, the first application tracker file configured to receive information that could not be applied to the first database; and

a first application time tracking component in communication with the first application tracker file, the first application time tracking component configured to track a period of time that the information could not be applied, the time tracking component further configured to transmit a message to an administrator after a predefined period of time.

28. The database communication network of claim 11, wherein the second database system further comprises:

a second transmission tracker file in communication with the second server, the second transmission tracker file configured to receive second information that could not be transmitted out of the second database system; and

a second transmission time tracking component in communication with the second transmission tracker file, the second transmission time tracking component configured to track a period of time that the second information could not be transmitted, the second time tracking component further configured to transmit a message to an administrator after a predefined period of time.

29. The database communication network of claim 11, wherein the second database system further comprises:

an second application tracker file in communication with the second server, the second application tracker file configured to receive information that could not be applied to the second database; and

a second application time tracking component in communication with the second application tracker file, the second application time tracking component configured to track a period of time that the information could not be applied, the second application time tracking component further configured to transmit a message to an administrator after a predefined period of time.

52. The method of claim 51, further comprising connecting the first database to a first external system.

53. The method of claim 52, further comprising receiving data at the first database from the first external system.

30. A database system comprising:

a database; and

a matching component in communication with the database, the matching component configured to receive information regarding an expected transaction and compare the information regarding the expected transaction with information regarding an actual transaction at the database.

31. The database system of claim 30, wherein the matching component is further configured to cause a matching notification to be transmitted out of the database system if the information regarding the expected transaction matches the information regarding the actual transaction.

32. 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.

33. The database system of claim 32 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.

34. The database system of claim 33 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.

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

36. The database system of claim 32 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.

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

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

39. The database system of claim 32 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.

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

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

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

43. The database system of claim 42 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.

44. The database system of claim 42 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.

45. 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.

46. A database communication network comprising:

a first database system comprising;

a first database configured to receive data; and

a first server comprising a first communication component configured upon receipt of data into the first database to identify a database system in communication with the first database system to receive first information and transmit the first information out of the first database;

a second database system in communication with the first database system, the second database system comprising;

a second database configured to receive data; and

a second server comprising a second communication component configured upon receipt of data into the second database to identify a database system in communication with the second database system to receive second information and transmit the second information out of the second database; and

an identification system in communication with each of the first and second database systems, the identification system configured to provide a database identification to each of the first and second database systems.

47. A communication network comprising:

at least two database systems, each of the at least two database systems comprising;

a database;

a server associated with the database, the server comprising a communication component configured to receive outgoing information from the database, identify at least one of the at least two database systems to receive the outgoing information, and transmit the outgoing information to the at least one of the at least two database systems; and

a connection component in communication with the database; and

at least one external system, each of the at least one external systems in communication with the connection component of one of the at least two database systems.

48. The communication network of claim 47, wherein the at least one external system is configured to input data into the database system with which the at least one external system is in communication, the at least one external system comprising:

a gathering component in communication with the connection component, the gathering component configured to receive external data and transmit the external data to the connection component; and

at least one external file in communication with the gathering component, the at least one external file configured to provide the external data to the gathering component.

49. The communication network of claim 47, wherein the at least one external system is configured to receive data from the database system with which the at least one external system is in communication, the at least one external system comprising:

a delivery component in communication with the connection component, the delivery component configured to receive data from the connection component and transmit the data; and

at least one external file in communication with the delivery component, the at least one external file configured to receive the data from the delivery component.

50. 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.

51. A method of network-based communication comprising:

automatically transmitting information out of a first database with assistance from a first transmission component within the first database upon input of data into the first database;

adding time information to the information; and

transmitting the information to a second database.

54. The method of claim 51, wherein adding time information to the notification information further comprises adding date information to the notification information.

55. The method of claim 51, further comprising:

receiving the notification information at the second database;

automatically transmitting receipt information out of the second database with assistance from a second transmission component within the second database upon input of the notification information into the second database;

adding time information to the receipt information; and

transmitting the receipt information to the first database.

56. The method of claim 55, further comprising connecting the second database to a second external system.

57. The method of claim 56, further comprising transmitting the notification information to the second external system.

58. The method of claim 55, wherein adding time information to the receipt information further comprises adding date information to the receipt information.