System and method for providing differentiated storage service in a database

• US 9,842,156 B2
• Filed: 12/29/2011
• Issued: 12/12/2017
• Est. Priority Date: 12/29/2011
• Status: Active Grant

• Current Assignee: Intel Corporation
• Original Assignee: Intel Corporation
• Inventors: Mesnier, Michael P., Luo, Tian, Chen, Feng
• Primary Examiner(s): Gebresenbet, Dinku
• Application Number:
  US13/993,357
• Publication Number:
  US 20140122489A1
• Time in Patent Office: 2,175 Days
• 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. 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.