DATABASE-LEVEL AUTOMATIC STORAGE MANAGEMENT

• US 20170109246A1
• Filed: 10/17/2016
• Published: 04/20/2017
• Est. Priority Date: 10/15/2015
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: CHIEN, HANLIN D., BAGAL, PRASAD V., SOLIS, ANA L., SELVARAJ, SANTHOSH, NANDYALA, HARISH
• Granted Patent: US 11,016,865 B2
• Time in Patent Office: Days
• CPC Class Codes: G06F 11/2058 using more than 2 mirrored copies
• CPC Class Codes: G06F 11/2069 Management of state, configuration or failover
• CPC Class Codes: G06F 16/13 File access structures, e.g. distributed indices arrangements of input from, or output to, record carriers G06F3/06
• CPC Class Codes: G06F 16/164 File meta data generation
• CPC Class Codes: G06F 16/182 Distributed file systems
• CPC Class Codes: G06F 16/185 Hierarchical storage management [HSM] systems, e.g. file migration or policies thereof details of archiving G06F16/11
• CPC Class Codes: G06F 16/21 Design, administration or maintenance of databases
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2246 Trees, e.g. B+trees
• 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

Techniques are describe herein for associating storage management properties with a group of files of a database referred to herein as a “file group”. In this system, storage management properties are defined at the database-level. Thus, multiple databases can be stored across a single disk group, gaining the benefits of having multiple block access devices working in parallel, but each respective database may be associated with a respective file group in a one-to-one relationship, so that each database can have different storage management properties.

Claims

1. A method comprising:

associating a plurality of block addressable storage units as a part of a disk group configured to store files for a plurality of databases;

storing a plurality of file groups in the disk group, each file group of said plurality of file groups having files for a single respective database of said plurality of databases;

for each file group of said file groups, storing, in association with said file group, storage management properties describing how to manage storage of said respective file group;

wherein the method is performed by one or more computing devices.

2. The method of claim 1, wherein the storage management properties include a particular storage management property, wherein storing storage management properties for each file group includes:

storing a first value for the particular storage management property for a first file group;

storing a second value for the particular storage management property for a second file group;

wherein the first value is different than the second value.

3. The method of claim 2, wherein the particular storage management property is redundancy, the method further comprising:

automatically, maintaining, on the block addressable storage units of the disk group, a first number of copies of a first database of the plurality of databases according to a first redundancy property of the first file group that has files for the first database;

automatically, maintaining, on the block addressable storage units of the disk group, a second number of copies of a second database of the plurality of databases according to a second redundancy property of the second file group that has files for the second database;

wherein the first number of copies and the second number of copies are different.

4. The method of claim 2, further comprising:

striping each file of the first file group across a first subset of the plurality of block addressable storage units of the disk group;

striping each file of the second file group across a second subset of the plurality of block addressable storage units of the disk group;

wherein the first subset and the second subset intersect with respect to at least one block addressable storage unit causing a first set of stripes from the files of the first file group on the at least one block addressable storage unit to have different storage management properties than a second set of stripes from the files of the second file group.

5. The method of claim 1, further comprising:

detecting a failure in at least one block addressable storage unit of the plurality of the block addressable storage units of the disk group;

automatically, restoring a first set of lost data from files in a particular file group according to a particular property of the particular file group.

6. The method of claim 5, wherein the particular property of the particular file group is priority, the method further comprising:

based on the particular property, restoring the first set of lost data from the files in the particular file group prior to restoring a second set of lost data from files in another particular file group.

7. The method of claim 6, further comprising:

based on a copy of the first set of lost data, determining a file-type of each stripe in the first set of lost data;

restoring a first set of stripes of a first particular file-type prior to restoring a second set of stripes of a second particular file-type.

8. One or more non-transitory computer-readable media storing one or more sequences of instructions which, when executed by one or more processors, cause performing of:

associating a plurality of block addressable storage units as a part of a disk group configured to store files for a plurality of databases;

storing a plurality of file groups in the disk group, each file group of said plurality of file groups having files for a single respective database of said plurality of databases;

for each file group of said file groups, storing, in association with said file group, storage management properties describing how to manage storage of said respective file group.

9. The one or more non-transitory computer-readable media of claim 8, wherein the storage management properties include a particular storage management property;

wherein storing storage management properties for each file group includes;

storing a first value for the particular storage management property for a first file group;

storing a second value for the particular storage management property for a second file group;

wherein the first value is different than the second value.

10. The one or more non-transitory computer-readable media of claim 9, wherein the particular storage management property is redundancy;

wherein the one or more non-transitory computer-readable media store instructions which, when executed by the one or more processors, further cause;

automatically, maintaining, on the block addressable storage units of the disk group, a first number of copies of a first database of the plurality of databases according to a first redundancy property of the first file group that has files for the first database;

automatically, maintaining, on the block addressable storage units of the disk group, a second number of copies of a second database of the plurality of databases according to a second redundancy property of the second file group that has files for the second database;

wherein the first number of copies and the second number of copies are different.

11. The one or more non-transitory computer-readable media of claim 9, wherein the one or more non-transitory computer-readable media store instructions which, when executed by the one or more processors, further cause:

striping each file of the first file group across a first subset of the plurality of block addressable storage units of the disk group;

striping each file of the second file group across a second subset of the plurality of block addressable storage units of the disk group;

wherein the first subset and the second subset intersect with respect to at least one block addressable storage unit causing a first set of stripes from the files of the first file group on the at least one block addressable storage unit to have different storage management properties than a second set of stripes from the files of the second file group.

12. The one or more non-transitory computer-readable media of claim 8, wherein the one or more non-transitory computer-readable media store instructions which, when executed by the one or more processors, further cause:

detecting a failure in at least one block addressable storage unit of the plurality of the block addressable storage units of the disk group;

automatically, restoring a first set of lost data from files in a particular file group according to a particular property of the particular file group.

13. The one or more non-transitory computer-readable media of claim 12, wherein the particular property of the particular file group is priority;

wherein the one or more non-transitory computer-readable media store instructions which, when executed by the one or more processors, further cause;

based on the particular property, restoring the first set of lost data from the files in the particular file group prior to restoring a second set of lost data from files in another particular file group.

14. The one or more non-transitory computer-readable media of claim 13, wherein the one or more non-transitory computer-readable media store instructions which, when executed by the one or more processors, further cause:

based on a copy of the first set of lost data, determining a file-type of each stripe in the first set of lost data;

restoring a first set of stripes of a first particular file-type prior to restoring a second set of stripes of a second particular file-type.

15. A storage management system comprising one or more computing devices configured to:

associate a plurality of block addressable storage units as a part of a disk group configured to store files for a plurality of databases;

store a plurality of file groups in the disk group, each file group of said plurality of file groups having files for a single respective database of said plurality of databases;

for each file group of said file groups, store, in association with said file group, storage management properties describing how to manage storage of said respective file group.

16. The storage management system of claim 15, wherein the storage management properties include a particular storage management property;

wherein the one or more computing devices are further configured to;

store a first value for the particular storage management property for a first file group;

store a second value for the particular storage management property for a second file group;

wherein the first value is different than the second value.

17. The storage management system of claim 16, wherein the particular storage management property is redundancy;

wherein the one or more computing devices are further configured to;

automatically, maintain, on the block addressable storage units of the disk group, a first number of copies of a first database of the plurality of databases according to a first redundancy property of the first file group that has files for the first database;

automatically, maintain, on the block addressable storage units of the disk group, a second number of copies of a second database of the plurality of databases according to a second redundancy property of the second file group that has files for the second database;

wherein the first number of copies and the second number of copies are different.

18. The storage management system of claim 16, wherein the one or more computing devices are further configured to:

stripe each file of the first file group across a first subset of the plurality of block addressable storage units of the disk group;

stripe each file of the second file group across a second subset of the plurality of block addressable storage units of the disk group;

wherein the first subset and the second subset intersect with respect to at least one block addressable storage unit causing a first set of stripes from the files of the first file group on the at least one block addressable storage unit to have different storage management properties than a second set of stripes from the files of the second file group.

19. The storage management system of claim 15, wherein the one or more computing devices are further configured to:

detect a failure in at least one block addressable storage unit of the plurality of the block addressable storage units of the disk group;

automatically, restore a first set of lost data from files in a particular file group according to a particular property of the particular file group.

20. The storage management system of claim 19, wherein the particular property of the particular file group is priority;

wherein the one or more computing devices are further configured to;

based on the particular property, restore the first set of lost data from the files in the particular file group prior to restoring a second set of lost data from files in another particular file group.

21. The storage management system of claim 20, wherein the one or more computing devices are further configured to:

based on a copy of the first set of lost data, determine a file-type of each stripe in the first set of lost data;

restore a first set of stripes of a first particular file-type prior to restoring a second set of stripes of a second particular file-type.