System and method for providing differentiated storage service in a database

Patent metadata

Field	Value
Publication number	US-9842156-B2
Application number	US-201113993357-A
Country	US
Kind code	B2
Filing date	Dec 29, 2011
Priority date	Dec 29, 2011
Publication date	Dec 12, 2017
Grant date	Dec 12, 2017

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.

First claim

What is claimed is:

1. A method, comprising:
receiving, in a storage system, an input/output request directed from a database to a storage system;
determining from the input/out request that the database corresponds to a particular one of a plurality of database classes;
classifying, in the storage system, the input/output request under at least the particular database class, wherein a database classifier is included with the input/output request to identify the particular database class;
associating, in the storage system and prior to receipt of the input/output request, a particular quality of service policy with the particular database class; and
executing the input/output request in the storage system according to the particular quality of service policy.

2. The method of claim 1 , wherein each database class in the set of database classes is associated with at least one quality of service policy.

3. The method of claim 2 , wherein associations between each database class and the respective quality of service policies are stored in a table in the storage system before initialization of the database.

4. The method of claim 3 , wherein classifying the input/output request comprises appending the database classifier to the input/output request.

5. The method of claim 4 further comprising:
extracting the database classifier from the input/output request; and
performing a lookup in the table using the database classifier to determine an appropriate quality of service policy.

6. The method of claim 1 , wherein the particular policy comprises a performance-related policy.

7. The method of claim 6 , wherein executing the input/output operation according to the particular policy comprises storing the input/output operation in a cache memory according to the particular policy.

8. The method of claim 1 , wherein the particular policy comprises a reliability-related policy.

9. The method of claim 8 , wherein executing input/output operation according to the particular policy comprises replicating certain data blocks in the storage system.

10. The method of claim 1 , wherein the particular policy comprises a security-related policy for encrypting certain data blocks in the storage system.

11. A database system, comprising:
a memory; and
a processor to execute instructions stored in the memory to cause the processor to:
receive, in the memory, an input/output request directed from a database to a storage system;
determine from the input/out request that the database corresponds to a particular one of a plurality of database classes;
classify, in the memory, the input/output request under at least the particular database class, wherein a database classifier is included with the input/output request to identify the particular database class;
associate, in the memory and prior to receipt of the input/output request, a particular quality of service policy with the particular database class; and
execute the input/output request in the storage system according to the particular quality of service policy.

12. The system of claim 11 , wherein each database class in the set of database classes is associated with at least one quality of service policy.

13. The system of claim 12 , wherein associations between each database class and respective quality of service policies are stored in a table in the storage system before initialization of the database.

14. The system of claim 13 , wherein classifying the input/output request comprises appending the database classifier to the input/output request.

15. The system of claim 14 , wherein the instructions, when executed, further cause the processor to:
extracting the database classifier from the input/output request; and
performing a lookup in the table using the database classifier to determine an appropriate quality of service policy.

16. The system of claim 11 , wherein the particular policy comprises a performance-related policy.

17. The system of claim 16 , wherein executing the input/output operation according to the particular policy comprises storing the input/output operation in a cache memory.

18. The system of claim 11 , wherein the particular policy comprises a reliability-related policy.

19. The system of claim 18 , wherein executing input/output operation according to the particular policy comprises replicating certain data blocks in the storage system.

20. The system of claim 11 , wherein the set of database classes comprises a database index class, a database log class, a database table class, and a database record class.

21. A non-transitory computer-readable medium to store instructions executable by a processor, the instructions comprising:
receiving, in a storage system, an input/output request directed from a database to the storage system;
determining from the input/out request that the database corresponds to a particular one of a plurality of database classes;
classifying, in the storage system, the input/output request under at least the particular database class, wherein a database classifier is included with the input/output request to identify the particular database class;
associating, in the storage system and prior to receipt of the input/output request, a particular quality of service policy with the particular database class; and
executing the input/output request in the storage system according to the particular quality of service policy.

22. The medium of claim 21 , wherein each database class in the set of database classes is associated with at least one quality of service policy.

23. The medium of claim 22 , wherein associations between each database class and respective quality of service policies are stored in a table in the storage system before initialization of the database.

24. The medium of claim 23 , wherein classifying the input/output request comprises appending the database classifier to the input/output request.

25. The medium of claim 24 , the instructions further comprising:
extracting the database classifier from the input/output request; and
performing a lookup in the table using the database classifier to determine an appropriate quality of service policy.

26. The medium of claim 21 , wherein the particular policy comprises a performance-related policy.

27. The medium of claim 26 , wherein executing the input/output operation according to the particular policy comprises storing the input/output operation in a cache memory.

28. The medium of claim 21 , wherein the particular policy comprises a reliability-related policy.

29. The medium of claim 28 , wherein executing input/output operation according to the particular policy comprises replicating certain data blocks in the storage system.

30. The medium of claim 21 , wherein the plurality of database classes comprise a database index class, a database log class, a database table class, and a database record class.

Assignees

• Mesnier Michael P
• Luo Tian
• Chen Feng
• Intel Corp

Inventors

• Mesnier Michael P
• Luo Tian
• Chen Feng

Classifications

• H04L67/1097 Primary

  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 title

• G06F17/30312

  Physics · mapped topic

• G06F17/30598 Primary

  Physics · mapped topic

• H04L67/322

  Electricity · mapped topic

• H04L67/61

  taking into account QoS or priority requirements · CPC title