Database Switch enabling a database area network

• US 20030154236A1
• Filed: 01/22/2002
• Published: 08/14/2003
• Est. Priority Date: 01/22/2002
• Status: Abandoned Application

• Current Assignee: Boaz Ripin, Gil Hecht, Roni Gutherz, Shaul Dar
• Original Assignee: Boaz Ripin, Gil Hecht, Roni Gutherz, Shaul Dar
• Inventors: Hecht, Gil, Ripin, Boaz, Gutherz, Roni, Dar, Shaul
• Application Number:
  US10/055,443
• Publication Number:
  US 20030154236A1
• Time in Patent Office: Days
• US Class Current: 709/201
• CPC Class Codes: H04L 67/1001 for accessing one among a plurality of replicated servers
• CPC Class Codes: H04L 67/1006 with static server selection, e.g. the same server being selected for a specific client
• CPC Class Codes: H04L 67/1025 Dynamic adaptation of the criteria on which the server selection is based
• CPC Class Codes: H04L 67/1036 Load balancing of requests to servers for services different from user content provisioning, e.g. load balancing across domain name servers

Abstract

A method and system for improving utilization of the typical DBMS client-server configuration is provided. Specifically, the present invention can include a Database Switch (dBSwitch) situated between the applications and database servers in a network, capable of dynamically and transparently connecting applications to databases using standard database servers and standard protocols. The Database Switch appliance performs this database routing in real time, with high bandwidth and negligible latency. The Database Switch enables the formation of a Database Area Network (DAN) architecture, which promotes database virtualization by integrating the database servers, the shared storage, and the interconnecting network, making them appear to be one large, scalable database server. This DAN architecture yields high utilization, high availability, scalability on demand, simplified management and security, in a shared and heterogeneous application environment.

Claims

1. A database area network (DAN) system comprising:

a plurality of database management systems adapted for providing access to database data;

a shared storage system, connected to said database management systems for storing said database data;

a database switching system adapted for directing the transfer of data packets between at least one database client and said database management systems.

2. The system of claim 1, wherein said database switching system includes a switching device adapted for switching or routing said data packets between said at least one database client and said database management systems.

3. The system of claim 1, wherein said database switching system is adapted for translating a network destination address of a database service request received from a database client to a network destination address of a database management system.

4. The system of claim 3, wherein said translated network destination address of a database service is a network layer addresses or data link layer addresses.

5. The system of claim 3, wherein said network destination address of a database service is translated from a virtual network address to an actual network destination address.

6. The system of claim 1, wherein said database switching system includes a routing or switching device adapted to provide data packet routing or switching functions and said routing or switching functions can be controlled using a command line interface procedure or a network management protocol.

7. The system of claim 1, wherein said database switching system includes a redirection module adapted for relocating a database instance from a first database server to a second database server.

8. The system of claim 1, wherein said database switching system includes a resource management module adapted for managing an association between database instances and database servers.

9. The system of claim 8, wherein said resource management module further includes a data storage device and is adapted for storing server resource information or database instance requirements in said data storage device.

10. The system of claim 9, wherein said resource management module is further adapted for managing the association between database instances and database servers as a function of the server resource information or the database instance requirements.

11. The system of claim 9, wherein said resource management module is adapted for storing constraints or preferences regarding database instance redirection in said data storage device.

12. The system of claim 11, wherein said resource management module is further adapted for managing the association between database instances and database servers as a function of said constraints or preferences regarding database instance redirection stored in said data storage device.

13. The system of claim 1, wherein said database switching system further includes a module adapted for relocating a database instance from a first database server to a second database server as a function of defined database performance criteria.

14. The system of claim 1, wherein said database switching system includes a database switching module adapted for associating database services with network addresses.

15. The system of claim 14, wherein said network addresses are virtual network addresses.

16. The system of claim 14, wherein said network addresses are network layer addresses or data link layer addresses.

17. The system of claim 14 wherein said database switching system is adapted for directing the transfer of data packets between said database clients and said database management systems as a function of the associations between said database services and said network addresses.

18. The system of claim 14, wherein said database switching system is adapted for directing the transfer of data packets between said database clients and said database management systems by replacing a network address of said data packet containing a service request with the network address associated with that service.

19. The system of claim 18, wherein the network address of said data packet containing a service request is a virtual network address and said virtual network address is replaced with a real network address associated with said service.

20. The system of claim 18, wherein the network address of said data packet containing a service request is for a network address on a first subnetwork and said network address is replaced with a network address associated with said database service on a second subnetwork.

21. The system of claim 14, wherein said database switching system includes a content switch adapted to read at least a portion of the contents of packets transferred between said at least on database client and said database management systems.

22. The system of claim 14, wherein said database switching system includes

a network device adapted for routing or switching data packets across said database area network, said network device including network management means for managing routing or switching functions of the network device and

said database switching module is adapted to use said network management means to control the routing or switching functions of the network device.

23. The system of claim 22, wherein said network device is adapted to provide real time routing of data packets across said database area network with low latency.

24. The system of claim 22, wherein said network device is adapted to provide real time routing of data packets across said database area network with high bandwidth.

25. The system of claim 22, wherein said database switching module is adapted for dynamically establishing said associations between database services and network addresses, and for automatically communicating the establishment or modification to said associations to said network device, whereby said database area network continues to function if said database switching module stops operating.

26. The system of claim 25, wherein said database switching module stops operating because of a failure of said database switching module or a connection between said database switching module and said network device.

27. The system of claim 25, wherein said database switching module stops operating because it is taken out of service for modification or upgrade.

28. The system of claim 14, wherein said database switching device is further adapted for dynamically associating database services with network addresses as a function of predefined resource management objectives.

29. The system of claim 28, wherein said resource management objectives are selected from the group consisting of load balancing, quality of service, high availability and scalability.

30. The system of claim 28, wherein said database services are executed on a plurality of database servers corresponding to said associated network addresses and said database switching module further includes:

monitoring means for monitoring a plurality database servers for server status and server resource usage;

mapping means for changing the associations between database services and network addresses as a function said server status and said server resource usage.

31. The system of claim 30, wherein said mapping means is adapted for changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of load balancing in order to balance the server resource usage over a plurality of database servers.

32. The system of claim 30, wherein said mapping means is adapted for changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of quality of service in order to make server resources available to provide a predefined level of quality of service.

33. The system of claim 32, wherein said predefined level of quality of service is measured as a function of allocated server resources.

34. The system of claim 32, wherein said predefined level of quality of service is measured as function of a quantity of database server operations processed in a specified unit of time.

35. The system of claim 32, wherein said predefined level of quality of service is measured as a function of a unit of time used to complete a database server operations or set of database server operations.

36. The system of claim 30, wherein said mapping means is adapted for changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of high availability in order to provide that a database service is available from an alternative database server if said monitoring means detects that a database server providing said database service experiences a failure.

37. The system of claim 30, wherein said mapping means is adapted for changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of scalability in order to distribute database resource usage over additional database resources added to the database area network.

38. The system of claim 1, wherein said database switching system includes a database area network administration module adapted for controlling administrative access to devices and services connected to the database area network.

39. The system of claim 38, wherein said database area network administration module provides a plurality of levels of access including a first level which provides access to all devices or services included in said database area network;

and a second level of access which provides access to specific databases and their associated instances.

40. The system of claim 38, wherein said database area network administration module is adapted for controlling access by a first network device connected to said data area network to a second network device connected to said data area network.

41. A method for operating a database area network (DAN) comprising the steps of:

connecting a plurality of database servers to a communication medium, each database server including at least one database management system adapted for providing a plurality of database services;

associating at least one database service with at least one database server; and

directing the transfer of database service requests to an associated database server as a function of the association between at least one database service and at least one database server.

42. A method according to claim 41, wherein said step of directing the transfer of database service requests includes routing or switching data packets containing the database service requests between a database client and said database servers.

43. A method according to claim 41, wherein said step of directing the transfer of database service requests includes translating a network destination address of a database service request received from a database client to a network destination address of a database service.

44. A method according to claim 43, wherein said translated network destination address of a database service is a network layer address or data link layer address.

45. A method according to claim 43, wherein said network destination address of a database service is translated from a virtual network address to an actual network destination address.

46. A method according to claim 41, further including the step of relocating a database instance from a first database server to a second database server.

47. A method according to claim 41, further including the steps of:

storing server resource information or database instance requirements in a data storage device; and

said step of associating at least one database service with at least one database server includes associating a database service with a database server as a function of the server resource information or the database instance requirements stored in said data storage device

48. A method according to claim 41, further including the step of moving a database instance from a first database server to a second database server as a function of a defined database performance criteria.

49. A method according to claim 41, wherein the step of directing the transfer of database service requests includes directing the transfer of database service requests to a database server as a function of a portion of the content of a data packet containing said database service request.

50. A method according to claim 41 further comprising the step of transferring database service requests in real time with low latency between the database servers and database clients.

51. A method according to claim 41 further comprising the step of transferring database service requests in real time with high bandwidth between the database servers and database clients.

52. A method according to claim 41 further comprising the step of:

connecting a database switch (dBSwitch) to said communications medium and wherein said dBSwitch is adapted for associating at least one database service with at least one database server and directing the transfer of database service requests to said database servers as a function of the association between said database services and said at least one database server.

53. A method according to claim 52, wherein said dBSwitch includes a network device adapted to provide data packet routing or switching functions to said communications medium, and said routing or switching functions can be controlled using a command line interface procedure or a network management protocol;

and said method further includes the step of controlling the routing or switching function of the routing or switching device using a command line interface procedure or a network management protocol.

54. A method according to claim 53, further comprising the step of modifying the switching or routing function of said switching or routing device as a function of said associations between the database services and said at least one database server.

55. A method according to claim 52, wherein said dBSwitch includes a database switching module and method includes the steps of:

said database switching module dynamically establishing associations between database services and database servers;

automatically communicating the establishment or modification to said associations to said network device, and,

continuing to transfer said database service requests to an associated database server even if said database switching module stops operating.

56. A method according to claim 55, wherein said database switching module stopped operating because of a failure in said database switching module.

57. A method according to claim 55, wherein said database switching module stopped operating because it was taken out of service for modification or upgrade.

58. A method according to claim 55, further comprising the step of said database switching module dynamically associating database services with network addresses as a function of predefined resource management objectives.

59. A method according to claim 58, wherein said resource management objectives are selected from the group consisting of load balancing, quality of service, high availability and scalability.

60. A method according to claim 58, wherein said database services are executed on a plurality of database servers corresponding to said associated network addresses and said method further includes the steps of

said database switching module monitoring a plurality of database servers for server status and resource usage;

and

said database switching module changing the associations between database services and network addresses as a function of said server resource usage.

61. A method according to claim 60, wherein the step of changing the associations between database services and network addresses includes changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of load balancing in order to balance the server resource usage over a plurality of database servers.

62. A method according to claim 60, wherein said step of changing the associations between database services and network addresses includes changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of quality of service in order to make server resources available to provide a predefined level of quality of service.

63. A method according to claim 62, wherein said predefined level of quality of service is measured as a function of allocated server resources.

64. A method according to claim 62, wherein said predefined level of quality of service is measured as function of a quantity of database server operations processed in a specified unit of time.

65. A method according to claim 62, wherein said predefined level of quality of service is measured as a function of a unit of time used to complete a database server transaction or set of database server transactions.

66. A method according to claim 60, wherein said step of changing the associations between database services and network addresses includes changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of high availability in order to provide that a database service is available from an alternative database server if said monitoring means detects that a database server providing said database service experiences a failure.

67. A method according to claim 60, wherein said step of changing the associations between database services and network addresses includes changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of scalability in order to distribute database resource usage over additional database resources added to the database area network.

68. A method according to claim 41, wherein said database switching module includes a database area network administration module and said method includes the steps of said database area network administration module providing administrative access control to devices and services connected to the database area network.

69. A method according to claim 68, further comprising the step of:

said database area network administration module providing a plurality of levels of access including a first level which provides access to all devices or services included in connected to said database area network; and

a second level of access which provides access to specific databases and their associated instances.

70. A method according to claim 68, further comprising the step of said database area network administration module controlling access by a first network device connected to said data area network to a second network device connected to said data area network.

73. An apparatus according to claim 70 wherein

said directing means includes translation means for translating a network destination address of a database service request received from a database client to a network destination address of a database server.

74. An apparatus according to claim 73 wherein said translated network destination address of a database service is a network layer addresses or data link layer addresses.

75. An apparatus according to claim 73 wherein said network destination address of a database service is translated from a virtual network address to an actual network destination address.

71. An apparatus adapted for transferring data packets between at least one database server and at least one database user, said apparatus comprising:

connecting means for connecting at least one database client and at least one database server; and

switching means for directing the transfer of said data packets between a database user and at least one database server.

72. An apparatus according to claim 71 wherein said switching means includes a switching or routing device adapted for routing said data packets between said database client and at least one of said database management systems.

76. An apparatus according to claim 71 further comprising a routing or switching device adapted to provide data packet routing or switching functions and said routing or switching functions can be controlled using a command line interface procedure or a network management protocol.

77. An apparatus according to claim 71 further comprising a redirection module adapted for relocating a database instance from a first database server to a second database server.

78. An apparatus according to claim 71 further comprising a resource management module adapted for managing database instance assignments to database servers.

79. An apparatus according to claim 78 wherein said resource management module further includes a data storage device and is adapted for storing server resource information or database instance requirements in said data storage device.

80. An apparatus according to claim 79 wherein said resource management module is further adapted for managing database instance assignments as a function of the server resource information or the database instance requirements.

81. An apparatus according to claim 79 wherein said resource management module is adapted for storing constraints or preferences regarding database instance redirection in said data storage device.

82. An apparatus according to claim 81 wherein said resource management module is further adapted for managing the association between database instances and database servers as a function of said constraints or preferences regarding database instance redirection stored in said data storage device.

83. An apparatus according to claim 71 further comprising a module adapted for moving a database instance from a first database server to a second database server as a function of a defined database performance criteria.

84. An apparatus according to claim 71 further comprising a database switching module adapted for associating database services with network addresses.

85. An apparatus according to claim 84 wherein said network address are virtual network addresses.

86. An apparatus according to claim 84 wherein said network address are network layer addresses or data link layer addresses.

87. An apparatus according to claim 84 wherein said switching means is adapted for directing the transfer of data packets between said database clients and said database servers as a function said associations between said database services and said network addresses.

88. An apparatus according to claim 84 wherein said switching means is adapted for directing the transfer of data packets between said database clients and said database management systems by replacing a network address of said data packet containing a database service request with the network address associated with that service.

89. An apparatus according to claim 88 wherein the network address of said data packet containing a service request is a virtual network address and said virtual network address is replaced with a real network address associated with said service.

90. An apparatus according to claim 88 wherein the network address of said data packet containing a service request is for a network address on a first subnetwork and said network address is replaced with a network address associated with said database service on a second subnetwork.

91. An apparatus according to claim 84 wherein said database switching system includes a content switch adapted to read at least a portion of the contents of packets transferred between said at least on database client and said database management systems.

92. An apparatus according to claim 84 further comprising

a network device adapted for routing or switching data packets across said database area network, said network device including network management means for managing routing or switching functions of the network device and

said database switching module is adapted to use said network management means to control the routing or switching functions of the network device.

93. An apparatus according to claim 92 wherein said network device provides real time routing of data packets across said database area network with low latency.

94. An apparatus according to claim 92 wherein said network device provides real time routing of data packets across said database area network with high bandwidth.

95. An apparatus according to claim 92 wherein said database switching module is adapted for dynamically establishing said associations between database services and network addresses, and for automatically communicating the establishment or modification to said associations to said network device, whereby said database area network continues to function if said database switching module stops operating.

96. An apparatus according to claim 95 wherein said database switching module stops operating because of a failure of said database switching module or a connecting between said database switching module and said network device.

97. An apparatus according to claim 95 wherein said database switching module stops operating because it is taken out of service for modification or upgrade.

98. An apparatus according to claim 84 wherein said database switching de vice is further adapted for dynamically associating database services with network addresses as a function of predefined resource management objectives.

99. An apparatus according to claim 98 wherein said resource management objectives are selected from the group consisting of load balancing, quality of service, high availability and scalability.

100. An apparatus according to claim 98 wherein said database services are executed on a plurality of database servers corresponding to said associated network addresses and said database switching module further includes:

monitoring means for monitoring a plurality database servers for server status and server resource usage;

mapping means for changing the associations between database services and network addresses as a function said server status and server resource usage.

101. An apparatus according to claim 100 wherein said mapping means is adapted for changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of load balancing in order to balance the server resource usage over a plurality of database servers.

102. An apparatus according to claim 100 wherein said mapping means is adapted for changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of quality of service in order to make server resources available to provide a predefined level of quality of service.

103. An apparatus according to claim 102 wherein said predefined level of quality of service is measured as a function of allocated of server resources.

104. An apparatus according to claim 102 wherein said predefined level of quality of service is measured as function of a quantity of database server operations processed in a specified unit of time.

105. An apparatus according to claim 102 wherein said predefined level of quality of service is measured as a function of a unit of time used to complete a database server operation or set of database server operations.

106. An apparatus according to claim 100 wherein said mapping means is adapted for changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of high availability in order to provide that a database service is available from an alternative database server if said monitoring means detects that a database server providing said database service experiences a failure.

107. An apparatus according to claim 100 wherein said mapping means is adapted for changing the associations between database services and network addresses as a function of server resource usage and said management resource objective of scalability in order to distribute database resource usage over additional database resources added to the database area network.

108. An apparatus according to claim 71 wherein said database switching system includes a database area network administration module adapted for controlling administrative access to devices and services connected to the database area network.

109. An apparatus according to claim 108 wherein said database area network administration module provides a plurality of levels of access including a first level which provides access to all devices connected to said database area network;

and a second level of access which provides access to specific databases and associated instances of said specific databases.

110. An apparatus according to claim 108 wherein said database area network administration module is adapted to control said database switching system to control database area network access to network devices or databases.

111. An apparatus according to claim 71 wherein said connecting means allows for connection of the apparatus between two data link layer switches, where one data link layer switch is connected to at least one database server, and the other data link layer switch is connected to at least one database client

112. An apparatus according to claim 71 wherein said connecting means allows for connection of the apparatus to a data link layer switch, where the data link layer switch is connected to at least one database server and at least one database client