DISTRIBUTED COMMUNICATIONS BETWEEN DATABASE INSTANCES

• US 20100185714A1
• Filed: 01/15/2009
• Published: 07/22/2010
• Est. Priority Date: 01/15/2009
• Status: Abandoned Application

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Gerber, Robert H., Verbitski, Alexandre, Krassovsky, Viatcheslav
• Application Number:
  US12/353,992
• Publication Number:
  US 20100185714A1
• Time in Patent Office: Days
• US Class Current: 709/227
• CPC Class Codes: G06F 16/27 Replication, distribution or synchronisation of data between databases or within a distributed database system; Distributed database system architectures therefor

Abstract

A database communication system is described herein that structures communications in a way that provides lower overhead tracking, statistics, semantics for closing a communication, and reliability. The system provides communication namespaces that organize communications by component, purpose, and instance, which allow database servers to implicitly create communication-related objects without central coordination. The database communication system enables group-based communications that streamline the development of complex distributed components and protocols by providing creation and management of communications namespaces, centralized cleanup support, and centralized monitoring. These features allow the system to be highly distributed, with no one single coordinator of operations, and still provide reliable communications. Thus, the system allows databases to be spread across multiple servers while keeping the burden on database server developers of managing communications between the servers low.

Claims

1. A computer system for providing distributed database communications with lower overhead for database server developers and to allow multiple database servers to act upon received requests in a coordinated manner, the system comprising:

a processor and memory configured to execute software instructions;

a communication stack component configured to provide a low-level stack for sending and receiving messages between distributed database instances;

a component registration component configured to provide a facility for registering communication components with the system, wherein the communication components perform communication operations between distributed database instances;

a namespace resolution component configured to receive messages from the communication stack component and determine a namespace associated with the message;

an implicit context component configured to implicitly identify software objects based on an arrival of messages and in accordance with the namespace associated with the message;

an expiration component configured to manage the lifetimes of implicitly identified software objects, wherein the expiration component destroys the objects when they are no longer in use;

a force close component configured to provide a force close operation to close a logical communication channel distributed across multiple database instances, wherein the channel does not have a centralized coordinator that manages communications over the channel; and

a statistics and monitoring component configured to track information related to communications.

2. The system of claim 1 wherein the component registration component is further configured to associate a namespace with each registered communication component.

3. The system of claim 1 wherein the namespace resolution component is further configured to determine at least one of a channel map, conversation, and channel to which the message belongs based on the associated namespace and invoke a communication component to handle the message.

4. The system of claim 1 further comprising an object factory component configured to create objects using software instructions executed by the processor, wherein the objects are determined by the implicit context component to be related to the message but have not yet been created.

5. The system of claim 1 wherein the expiration component is further configured to determine whether a message has been received within a threshold period on a logical channel and in response to a determination that a message has not been received within a threshold period to close a local channel object and clean up resources associated with the local channel object.

6. The system of claim 1 wherein the force close component is further configured to notify each database instance in a cluster of database servers when a requestor wants to conclude a communication.

7. The system of claim 6 wherein the force close component is further configured to receive an acknowledgement from each database instance and to notify the requestor of the status of the force close operation.

8. The system of claim 1 wherein the statistics and monitoring component tracks the number or size of received communications at each database instance.

9. The system of claim 1 wherein the implicit context component is further configured to maintain a routing table that specifies relationships between two or more of the distributed database instances.

10. A computer-implemented method for managing communications between database instances, the method comprising:

receiving from a message sender a message over a network, wherein the message is part of a conversation between database instances related to a distributed database operation;

resolving a namespace associated with the message, wherein the namespace specifies a database component for handling the message and identifies context information associated with the message;

identifying a local database component in accordance with the specified database component of the namespace; and

delivering the received message to the local database component, wherein the local database component is configured to implicitly create objects specified by the namespace that do not already exist based on the namespace information in the received message,

wherein the receiving, resolving, identifying, and delivering are performed by at least one processor.

11. The method of claim 10 wherein identifying a local database component comprises determining whether an instance of the local database component has been previously created, and in response to a determination that an instance has not been previously created, creating an instance of the local database component.

12. The method of claim 10 wherein identifying a local database component comprises retrieving a local participant identifier from the message and looking up the local participant identifier in a local hash table.

13. The method of claim 10 further comprising identifying a logical channel based on the namespace associated with the message, wherein the logical channel distinguishes identifies a message type of the local database component.

14. The method of claim 10 further comprising identifying a logical conversation based on the namespace associated with the message, wherein the logical conversation separates communications within a logical channel of the local database component from other communications within the logical channel.

15. The method of claim 10 wherein the namespace specifies a version of a logical channel that changes when a database instance is added or removed from a cluster of database servers.

16. A computer-readable storage medium comprising instructions for controlling a computer system to close communications distributed among multiple database servers, wherein the instructions, when executed, cause a processor to perform actions comprising:

receiving a request to close a logical channel, wherein the channel identifies communications associated with a particular database component, wherein the communications are between multiple database server;

sending a close indication to each of the multiple database servers, wherein the close indication is configured to cause each database server to clean up context information related to the channel;

receiving acknowledgements from each of the multiple database servers, wherein each acknowledgement indicates a response of the corresponding database server to the close indication; and

after receiving the acknowledgements, responding to the received request to close the logical channel.

17. The computer-readable medium of claim 16 wherein sending a close indication to each of the multiple database servers comprises broadcasting the close indication on a local area network to which the database servers are connected.

18. The computer-readable medium of claim 16 wherein the request to close a logical channel comprises a request to abort a distributed query operation.

19. The computer-readable medium of claim 16 wherein the communications adhere to a hierarchical namespace that identifies the logical channel to which a particular message belongs.

20. The computer-readable medium of claim 16 wherein each database server tracks context information based on a hierarchical namespace associated with the logical channel.