Patent US5822780A successfully refreshed from Google Patents.
US5822780A
Expired / Lapsed
US
⏱️ 0.0 years remaining
Method and apparatus for hierarchical storage management for data base management systems
Assignee: EMC Corp
•
Filing: 1996-12-31
•
Granted: 1998-10-13
•
Expires: 2016-12-31
Abstract
Abstract A hierarchical storage management system for database management systems that divides a database logically into separately managed regions, with each region being described by an entry in a vector kept in a regions file. The region entry contains a time stamp of the last time the region was accessed, the staging identifier of the region if it has been migrated, the base level backup staging identifier of the region if it has been baselined, and an indicator telling whether or not the region is resident online. Each managed region of the database is migrated to a separate staging file. When the database software issues a read or write input/output operation, the present invention sends the migration software a signal signifying this has occurred. The migration software of the present invention then updates the accessed time stamp, and checks to see if the region is resident. If it is not resident, it is staged in. The present invention creates and updates a migration candidate list ordered by date last accessed and region size. Both demand staging by the HSM, and user--initiated staging can then operate on the migration candidate list to migrate suitable files to tertiary storage.
Inventors
- 👤 Neil F. Schutzman
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-05 16:56
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/90; G06F16/901; G06F16/9017; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932; Y10S707/99941; Y10S707/99944; Y10S707/99945; Y10S707/99951; Y10S707/99952; Y10S707/99953
Claims Analysis
Total Claims: 15
Claim 1
Independent Claim
209 words
In a computer system having secondary storage media and tertiary storage media accessible to it through a filesystem operating as part of the computer systems's operating system, the computer system also communicating with an hierarchical storage management system for migrating data between secondary and tertiary storage media, and the computer system also having database software for accessing databases stored on the secondary storage media, an apparatus for performing hierarchical storage management for a database, comprising: a managed regions file residing on secondary storage media and having at least one entry in it corresponding to a physical area of the database, the entry including a last accessed timestamp and region attributes; an interceptor operating with the filesystem to intercept input/output requests made by the database software to the database, the interceptor communicating with the managed regions file for the database in such as way as to update the last accessed timestamp and region attributes and create a migration candidates list; migration software operating as part of the hierarchical storage management system and responsive to signals sent by the interceptor to recall regions previously migrated to tertiary storage by copying them into secondary storage and to select from the candidates list any region to be migrated from secondary to tertiary storage.
Claim 2
Dependent Claim
209 words
In a computer system having secondary storage media and tertiary storage media accessible to it through a filesystem operating as part of the computer systems's operating system, the computer system also communicating with an hierarchical storage management system for migrating data between secondary and tertiary storage media, and the computer system also having database software for accessing databases stored on the secondary storage media, an apparatus for performing hierarchical storage management for a database, comprising: a managed regions file residing on secondary storage media and having at least one entry in it corresponding to a physical area of the database, the entry including a last accessed timestamp and region attributes; an interceptor operating with the filesystem to intercept input/output requests made by the database software to the database, the interceptor communicating with the managed regions file for the database in such as way as to update the last accessed timestamp and region attributes and create a migration candidates list; migration software operating as part of the hierarchical storage management system and responsive to signals sent by the interceptor to recall regions previously migrated to tertiary storage by copying them into secondary storage and to select from the candidates list any region to be migrated from secondary to tertiary storage.
Claim 3
Dependent Claim
31 words
The apparatus of claim 1, wherein the entry in the managed regions file further comprises an entry having a size that is optimized for input/output performance on disk and tape media.
Claim 4
Dependent Claim
30 words
The apparatus of claim 1, wherein the region attributes in the managed regions file further comprise a staging identifier field, a baseline backup identifier field, and a residency indicator field.
Claim 5
Dependent Claim
94 words
The apparatus of claim 1, wherein the interceptor further comprises a sequential input/output detector capable of determining when a series of sequential input/output requests are being made to the database and saving the status of the managed regions file before such requests are completed by copying the managed regions file to a second secondary storage area, so that when the sequential requests are completed, the managed regions file can be copied back to its first secondary storage area, thereby preventing a distorted view of activity on the database that sequential requests might have caused.
Claim 6
Dependent Claim
209 words
In a computer system having secondary storage media and tertiary storage media accessible to it through a filesystem operating as part of the computer systems's operating system, the computer system also communicating with an hierarchical storage management system for migrating data between secondary and tertiary storage media, and the computer system also having database software for accessing databases stored on the secondary storage media, a method for performing hierarchical storage management for a database, comprising the steps of: creating a managed regions file residing on secondary storage media and having at least one entry in it corresponding to a physical area of the database, the entry including a last accessed timestamp and region attributes; intercepting, through the filesystem input/output requests made by the database software to the database, and communicating with the managed regions file for the database in such as way as to update the last accessed timestamp and region attributes and create a migration candidates list; operating migration software as part of the hierarchical storage management system and responsive to signals sent by the intercepting step to recall regions previously migrated to tertiary storage by copying them into secondary storage and to select from the candidates list any region to be migrated from secondary to tertiary storage.
Claim 7
Dependent Claim
209 words
In a computer system having secondary storage media and tertiary storage media accessible to it through a filesystem operating as part of the computer systems's operating system, the computer system also communicating with an hierarchical storage management system for migrating data between secondary and tertiary storage media, and the computer system also having database software for accessing databases stored on the secondary storage media, a method for performing hierarchical storage management for a database, comprising the steps of: creating a managed regions file residing on secondary storage media and having at least one entry in it corresponding to a physical area of the database, the entry including a last accessed timestamp and region attributes; intercepting, through the filesystem input/output requests made by the database software to the database, and communicating with the managed regions file for the database in such as way as to update the last accessed timestamp and region attributes and create a migration candidates list; operating migration software as part of the hierarchical storage management system and responsive to signals sent by the intercepting step to recall regions previously migrated to tertiary storage by copying them into secondary storage and to select from the candidates list any region to be migrated from secondary to tertiary storage.
Claim 8
Dependent Claim
39 words
The method of claim 5, wherein the step of creating an entry in the managed regions file further comprises the step of creating an entry having a size that is optimized for input/output performance on disk and tape media.
Claim 9
Dependent Claim
36 words
The method of claim 5, wherein the step of creating an entry in the regions file further comprises the step of creating a staging identifier field, a baseline backup identifier field, and a residency indicator field.
Claim 10
Dependent Claim
93 words
The method of claim 5, wherein the step of intercepting further comprises the step of determining when a series of sequential input/output requests are being made to the database and saving the status of the managed regions file before such requests are completed by copying the managed regions file to a second secondary storage area, so that when the sequential requests are completed, the managed regions file can be copied back to its first secondary storage area, thereby preventing a distorted view of activity on the database that sequential requests might have caused.
Claim 11
Dependent Claim
212 words
In a computer system having secondary storage media and tertiary storage media accessible to it through a filesystem operating as part of the computer systems's operating system, the computer system also communicating with an hierarchical storage management system for migrating data between secondary and tertiary storage media, and the computer system also having database software for accessing databases stored on the secondary storage media, an apparatus for performing hierarchical storage management for a database, comprising: means for creating a managed regions file residing on secondary storage media and having at least one entry in it corresponding to a physical area of the database, the entry including a last accessed timestamp and region attributes; means for intercepting, through the filesystem input/output requests made by the database software to the database, and communicating with the managed regions file for the database in such as way as to update the last accessed timestamp and region attributes and create a migration candidates list; means for operating migration software as part of the hierarchical storage management system and responsive to signals sent by the intercepting step to recall regions previously migrated to tertiary storage by copying them into secondary storage and to select from the candidates list any region to be migrated from secondary to tertiary storage.
Claim 12
Dependent Claim
212 words
In a computer system having secondary storage media and tertiary storage media accessible to it through a filesystem operating as part of the computer systems's operating system, the computer system also communicating with an hierarchical storage management system for migrating data between secondary and tertiary storage media, and the computer system also having database software for accessing databases stored on the secondary storage media, an apparatus for performing hierarchical storage management for a database, comprising: means for creating a managed regions file residing on secondary storage media and having at least one entry in it corresponding to a physical area of the database, the entry including a last accessed timestamp and region attributes; means for intercepting, through the filesystem input/output requests made by the database software to the database, and communicating with the managed regions file for the database in such as way as to update the last accessed timestamp and region attributes and create a migration candidates list; means for operating migration software as part of the hierarchical storage management system and responsive to signals sent by the intercepting step to recall regions previously migrated to tertiary storage by copying them into secondary storage and to select from the candidates list any region to be migrated from secondary to tertiary storage.
Claim 13
Dependent Claim
38 words
The apparatus of claim 9, wherein means for creating an entry in the managed regions file further comprises a means for creating an entry having a size that is optimized for input/output performance on disk and tape media.
Claim 14
Dependent Claim
35 words
The apparatus of claim 9, wherein the means for creating an entry in the regions file further comprises means for creating a staging identifier field, a baseline backup identifier field, and a residency indicator field.
Claim 15
Dependent Claim
92 words
The apparatus of claim 9, wherein the means for intercepting further comprises means for determining when a series of sequential input/output requests are being made to the database and saving the status of the managed regions file before such requests are completed by copying the managed regions file to a second secondary storage area, so that when the sequential requests are completed, the managed regions file can be copied back to its first secondary storage area, thereby preventing a distorted view of activity on the database that sequential requests might have caused.
References Cited (Backward Citations)
US5579507A
Cited
US5564037A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2001-10-12 | 2002-04-13 | 2002-10-13 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2005-10-12 | 2006-04-13 | 2006-10-13 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2009-10-12 | 2010-04-13 | 2010-10-13 | $7700.00 | Window Closed / Lapsed |