SYSTEM AND METHOD FOR PROVIDING DIFFERENTIATED STORAGE SERVICE IN A DATABASE

• US 20160314188A1
• Filed: 06/30/2016
• Published: 10/27/2016
• Est. Priority Date: 12/29/2011
• Status: Abandoned Application

• Current Assignee: Intel Corporation
• Original Assignee: Intel Corporation
• Inventors: Mesnier, Michael P., Luo, Tian, Chen, Feng
• Application Number:
  US15/198,881
• Publication Number:
  US 20160314188A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/285 Clustering or classification
• CPC Class Codes: H04L 67/1097 for distributed storage of data in networks, e.g. transport arrangements for network file system [NFS], storage area networks [SAN] or network attached storage [NAS]
• CPC Class Codes: H04L 67/61 taking into account QoS or priority requirements

Abstract

In accordance with some embodiments, classification of input/output requests from a database to a storage system may be performed. Each input/output request may be associated with a database class, and each database class may be mapped to a quality of service policy. Thus, quality of service may be enforced such that different data blocks within the storage system of the database may be afforded appropriate quality of service.

Claims

1-20. -20. (canceled)

21. At least one machine accessible storage medium having instructions stored thereon, the instructions when executed on a machine, cause the machine to:

determine that a particular one of a plurality of classes is to be associated with a request for data from a database;

assign a tag to the request, wherein the tag identifies the particular class and the particular class corresponds to one or more performance policies specifying performance characteristics to be applied to servicing of the request; and

transmit the request with the tag for servicing by a database system, wherein the request is to be serviced by the database system according to the one or more performance policies based on the tag.

22. The storage medium of claim 21, wherein the particular class is based at least in part on a type of system used to implement the database.

23. The storage medium of claim 22, wherein the type of system comprises a server pool.

24. The storage medium of claim 22, the one or more performance policies apply to the type of system.

25. The storage medium of claim 21, wherein the request comprises an input/output (I/O) request.

26. The storage medium of claim 21, wherein the request is received from a particular system and sent to the database system.

27. The storage medium of claim 26, wherein the particular system is remote from the database system.

28. The storage medium of claim 26, wherein the request is received by a database manager, the particular class is determined by the database manager, and the request with the tag are transmitted by the database manager to the database system.

29. The storage medium of claim 28, wherein the database manager is remote from the database system.

30. The storage medium of claim 28, wherein the database manager manages a plurality of database systems.

31. The storage medium of claim 21, wherein the particular class corresponds to one or more performance policies identifying the performance characteristics.

32. The storage medium of claim 31, wherein the one or more performance policies comprise one of a fast write policy, low latency policy, and high bandwidth policy.

33. The storage medium of claim 21, wherein the instructions when executed further cause the machine to generate the tag.

34. A method comprising:

receiving, from a particular system, a request for data from a database;

determining that a particular one of a plurality of classes is to be associated with the request;

determining a tag to the request, wherein the tag identifies the particular class and the particular class corresponds to one or more performance policies specifying performance characteristics to be applied to servicing of the request; and

transmitting the request with the tag for servicing by a database system, wherein the request is to be serviced by the database system according to the one or more performance policies based on the tag.

35. The method of claim 34, wherein the particular class is based at least in part on a type of the database system.

36. The method of claim 35, wherein the type of the database system comprises a server pool.

37. The method of claim 35, the one or more performance policies apply to the type of the database system.

38. The method of claim 34, wherein the request comprises an input/output (I/O) request.

39. The method of claim 34, wherein the request is forwarded to the database system with the tag.

40. The method of claim 39, wherein the particular system is remote from the database system.

41. The method of claim 39, wherein the request is received by a database manager, the particular class is determined by the database manager, and the request with the tag are transmitted by the database manager to the database system.

42. The method of claim 41, wherein the database manager is remote from the database system.

43. The method of claim 41, wherein the database manager manages a plurality of database systems.

44. The method of claim 34, wherein the particular class corresponds to one or more performance policies identifying the performance characteristics.

45. The method of claim 44, wherein the one or more performance policies comprise one of a fast write policy, low latency policy, and high bandwidth policy.

46. The method of claim 34, further comprising generating the tag.

47. A database system comprising:

a memory;

a processor to execute instructions stored in the memory, the instructions comprising;

receiving a request for data from a database manager, wherein the request comprises a tag;

determining, from the tag, that a particular performance policy is to apply to the request for data; and

generate a response to the request according to the particular performance policy; and

send the response according to the particular performance policy.

48. The database system of claim 47, wherein the database manager is remote from the database system.

49. The database system of claim 47, wherein the tag corresponds to a particular class associated with the database system.

50. The database system of claim 49, wherein the particular class is based at least in part on a type of the database system.

51. The database system of claim 50, wherein the type of the database system comprises a server pool.

52. The database system of claim 51, the one or more performance policies apply to the type of the database system.

53. The database system of claim 47, wherein the request comprises an input/output (I/O) request.

54. The database system of claim 47, wherein the request originates from a host system and is forwarded to the database system with the tag by the database manager.

55. The database system of claim 54, wherein the tag is added to the request by the database manager.

56. The database system of claim 54, wherein the host system is remote from the database system.

57. The database system of claim 47, wherein the database manager manages a plurality of database systems.

58. A system comprising:

a processor;

a database; and

a database manager, executable by the processor to;

determine that a particular one of a plurality of classes is to be associated with a request for data from a database;

assign a tag to the request, wherein the tag identifies the particular class and the particular class corresponds to one or more performance policies specifying performance characteristics to be applied to servicing of the request; and

transmit the request with the tag for servicing by a database system, wherein the request is to be serviced by the database system according to the one or more performance policies based on the tag.

59. The system of claim 58, wherein the request is received from a host system remote from the database.

60. The system of claim 58, wherein the database is hosted by a host system remote from a host of the database manager and the database manager manages classification of requests to a plurality of different database host systems.

61. The system of claim 58, wherein the particular class is based at least in part on a type of system used to implement the database.

62. The system of claim 61, wherein the type of system comprises a server pool.

63. The system of claim 61, the one or more performance policies apply to the type of system.

64. The system of claim 58, wherein the request comprises an input/output (I/O) request.

65. The system of claim 58, wherein the particular class corresponds to one or more performance policies identifying the performance characteristics.

66. The system of claim 65, wherein the one or more performance policies comprise one of a fast write policy, low latency policy, and high bandwidth policy.

67. The system of claim 58, wherein the database manager is further executable to generate the tag.