IP Library › Granted Patent US 9,697,379
Granted Patent B2
US 9,697,379 · App. 14/733,922 · Granted Jul 4, 2017

Database virtualization

Inventors: Andrew E. Kimball (Sammamish, WA); Jeffrey R. Currier (Issaquah, WA); Xiaoyu Wu (Sammamish, WA); Zhongwei Wu (Sammamish, WA)
Assignee: Microsoft Technology Licensing, LLC
G06F21/6227G06F17/3056G06F17/30227G06F17/30368G06F21/33H04L63/0281H04L67/1021H04L67/2814H04L67/1014
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 9,697,379
App. No.
14/733,922
Granted
Jul 4, 2017
Kind
B2
Abstract

Aspects of the subject matter described herein relate database virtualization. In aspects, clusters of database servers may be located at various locations of the Internet. When a client seeks to access a logical database, the client may send a logical server and logical database name in a data structure. These names may be used to find a physical server(s) and database(s) that correspond to the logical database. Once the location is determined, a proxy component is used to intercept and/or forward communications between the client and the physical server(s) and database(s) corresponding to the logical database. Using this system, a client may access data from a logical database without knowing the physical address of the logical user database.

Claims (67)

1. A computer system, the computer system comprising:

a directory service, the directory service maintaining data that associates logical server names with one or more databases hosted on computer hardware;

one or more processors;

system memory coupled to the one or more processors, the system memory storing instructions that are executable by the one or more processors; and

the one or more processors executing the instructions stored in the system memory to perform the following:

receive a client request, the client request regarding data in a database, the client request conveyed in conjunction with a logical server name and a logical database name, the database included in the one or more databases; and

determine a location of the database using the directory service based on the logical server name and the logical database name.

2. The computer system of claim 1 , further comprising the one or more processors executing the instructions to select a network device to service the client request based on a load balancing algorithm.

3. The computer system of claim 1 , further comprising the one or more processors executing the instructions to forward communications between the client and the network device.

4. The computer system of claim 1 , further comprising one or more servers hosting one or more master databases, the one or more master databases including authentication and authorization information regarding the one or more databases, and

further comprising the one or more processors executing the instructions to act as a proxy between a client and a database, the database selected from among the one or more databases, including:

establish a connection with the client;

receive a logical server name and logical database name;

authenticate the client via authentication information included in a master database, the master database selected from among the one or more master databases;

determine a physical server and user database associated with the logical server name and the logical database name; and

establish a connection with the physical server for use in accessing the user database.

5. The computer system of claim 1 , further comprising the one or more processors executing the instructions to determine partitions of physical databases that include the database based on data in a data structure.

6. The computer system of claim 1 , further comprising the one or more processors executing the instructions to act as a proxy between the client and the database.

7. A processor implemented method for use at a network device, the network device communicatively connected to a directory service and to one or more databases, the one or more databases hosted on computer hardware, the method for determining the location of a database, the database included in the one or more databases, the method comprising:

receiving a client request, the client request regarding data in the database, the client request conveyed in conjunction with a logical server name and a logical database name; and

determining a location of the database through reference to the directory service and based on the logical server name and the logical database name, the directory service maintaining data that associates logical server names with the one or more databases.

8. The method of claim 7 , wherein determining a location of the database comprises determining a physical server associated with the logical server name.

9. The method of claim 7 , wherein receiving a client request comprises receiving a client request from a load balancer, the load balancer having selected the network device to service the request based on a load balancing algorithm.

10. The method of claim 7 , further comprising acting as a proxy between a client and the database.

11. The method of claim 10 , wherein acting as a proxy between a client and the database comprises:

establishing a connection with the client;

authenticating the client via authentication information included in another database; and

establishing a connection with the determined location of the database for use in accessing data contained in the database.

12. The method of claim 7 , wherein receiving a client request comprises receiving a database connection string, the database connection string including the logical server name and the logical database name.

13. The method claim 7 , wherein determining a location of the database comprises determining one or more partitions of physical databases that include the database.

14. A processor implemented method for use at a network device, the network device communicatively connected to a directory service and to one or more databases, the one or more databases hosted on computer hardware, the method for processing a database statement directed to a database, the database included in the one or more databases, the method comprising:

establishing a connection with a client;

establishing a connection with a logical database of the client by determining a location of the logical database based on a logical server name and a logical database name included in a client request, the location determined through reference to the directory service, the directory service maintaining data that associates the logical server name with a database hosted on computer hardware;

parsing a database statement from the client to identify how to implement the database statement; and

forwarding the database statement to the logical database.

15. The method of claim 14 , wherein parsing a database statement from the client to identify how to implement the database statement comprises determining that the database statement requests creation of a new database.

16. The method of claim 15 , further comprising:

assigning the new database to a physical server; and

updating the directory service to map the new database to the logical database.

17. The method of claim 14 , wherein parsing a database statement comprises determining if the database statement is included in a predetermined set of database language statements.

18. The method of claim 17 , wherein determining if the database statement is included in a predetermined set of database language statements comprises determining if the database statement is one of: a statement to create a database, a statement to delete a database, a statement to create a login, a statement to delete a login, a statement alter a login, a statement to create a user, a statement to delete a user, or a statement to alter a user.

19. The method of claim of 17 , wherein determining if the database statement is included in a predetermined set of database language statements comprises determining that the database statement is included in the predetermined set of database language statements; and

further comprising sending one or more additional requests to one or more of: the logical database and a master database to fulfill the client request, the master database including authentication and authorization information regarding the one or more databases.

20. The method of claim 14 , further comprising receiving the client request from a load balancer, the load balancer having selected the network device to service the request based on a load balancing algorithm.

21. A computer system, the computer system comprising:

a directory service, the directory service maintaining data that associates logical server names with one or more databases hosted on computer hardware;

one or more processors;

system memory coupled to the one or more processors, the system memory storing instructions that are executable by the one or more processors; and

the one or more processors executing the instructions stored in the system memory to perform the following:

establish a connection with a client;

establish a connection with a logical database of the client by determining a location of the logical database based on a logical server name and a logical database name included in a client request, the location determined through reference to the directory service;

parse a database statement from the client to identify how to implement the database statement; and

forward the database statement to the logical database.

22. The computer system of claim 21 , further comprising the one or more processors executing the instructions to receive the client request, the client request including the logical server name and the logical database name.

23. The computer system of claim 21 , wherein the one or more processors executing the instructions to establish a connection with the client comprises the one or more processors executing the instructions to:

negotiate connection parameters with the client; and

authenticate the client.

24. The computer system of claim 21 , wherein the one or more processors executing the instructions to parse a database statement comprises the one or more processors executing the instructions to determine if the database statement is included in a predetermined set of database language statements.

25. The computer system of claim 21 , wherein the one or more processors executing the instructions to determine if the database statement is included in a predetermined set of database language statements comprises the one or more processors executing the instructions to determine that the database statement is not included in a predetermined set of database language statements; and

further comprising the one or more processors executing the instructions to:

receive a response from the logical database; and

forward the response to the client.

26. The computer system of claim 21 , wherein the one or more processors executing the instructions to determine if the database statement is included in a predetermined set of database language statements comprises the one or more processors executing the instructions to determine that the database statement is included in a predetermined set of database language statements; and

further comprising the one or more processors executing the instructions to fulfill the client request based on the database statement by performing at least one of:

send a request to a master database;

update a master database; and

create a new logical database on a physical database.

Continuity (4)
Continuation 14568144 · Dec 12, 2014
Division 14170655 · Feb 3, 2014
Division 12707675 · Feb 18, 2010
Related Publication 20150269186A1 · Sep 24, 2015