Network-based database communication system

• US 7,584,197 B2
• Filed: 03/17/2004
• Issued: 09/01/2009
• Est. Priority Date: 03/17/2003
• Status: Expired due to Fees

• Current Assignee: Centric Isolutions, Inc.
• Original Assignee: Be-Centric LLC
• Inventors: Dant, Robert
• Primary Examiner(s): LEWIS, CHERYL RENEA
• Application Number:
  US10/802,661
• Publication Number:
  US 20040249788A1
• Time in Patent Office: 1,994 Days
• Field of Search: 707/10, 707/104.1, 707/3, 707/4, 707/9, 707/100, 707/101, 709/203
• US Class Current: 1/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, comprising;

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;

a first translation component operating on the first server, comprising;

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 and translate the first information into a format compatible with any database system in communication with the 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 assign unique identification to data stored within each of the first and second database systems;

wherein the first database system, second database system, and identification system are configured to support direct and indirect communication with each other.

2. The database communication network of claim 1 wherein the unique identification of data includes providing a first unique database identification schema to databases within the first database system and providing a second unique database identification schema to databases within the second database system.

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

4. The database communication network of claim 1, 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.

5. The database communication network of claim 1, 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.

6. The database communication network of claim 5, 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.

7. The database communication network of claim 5, 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.

8. The database communication network of claim 1, 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.

9. The database communication network of claim 8, 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.

10. The database communication network of claim 8, 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.

11. The database communication network of claim 10, 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.

12. The database communication network of claim 8, 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.

13. The database communication network of claim 12, 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.

14. The database communication network of claim 12, 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.

15. The database communication network of claim 8, 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.

16. The database communication network of claim 8, 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.

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

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

19. The database communication network of claim 18, 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.

20. The database communication network of claim 18, 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.

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

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

23. The database communication network of claim 22, 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.

24. The database communication network of claim 22, 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.

25. The database communication network of claim 1, 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.

26. The database communication network of claim 1, 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.

27. A database system comprising:

a database;

a server configured to receive information from the database and transmit the information out of the database;

a translation component operating on the server, comprising;

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

a translator component configured to utilize the format information from the dictionary component and translate the information from the database into a format compatible with any database in communication with the database system; 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;

wherein direct or indirect communication occurs between the database and matching component.

28. The database system of claim 27, 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.

29. 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 to transmit the first information out of the first database;

a first translation component operating on the first server, comprising;

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

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

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 to transmit the second information out of the second database;

a second translation component operating on the second server, comprising;

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

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

an identification system in communication with each of the first and second database systems, the identification system configured to assign unique identification to data stored within each of the first and second database systems;

wherein the first database system, second database system, and identification system are configured to support direct and indirect communication with each other.

30. 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;

a translation component operating on the server, comprising;

a dictionary component comprising format information for each of the at least two database systems in communication with the database; and

a translator component configured to utilize format information from the dictionary component and translate the information from the database into a format compatible with each of the at least two database systems in communication with the database;

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;

wherein the at least two database systems are configured to support direct and indirect communication with each other.

31. The communication network of claim 30, 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.

32. The communication network of claim 30, 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.

33. 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;

providing a dictionary component comprising format information for a second database in communication with the first database;

providing a translator component configured to utilize the format information from the dictionary component and translate the information transmitted out of the first database into a format compatible with the second database;

adding time information to the information; and

transmitting the information to the second database via direct or indirect communication to the second database.

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

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

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

37. The method of claim 33, 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.

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

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

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