Hierarchical storage management for database systems

US8639880B2 · kind B2 · utility

Assignee

• International Business Machines Corporation · US

Inventors

• Oliver Augenstein · Eppelheim, DE
• Stefan Bender · Engen, DE
• Karl Fleckenstein · Malsch, DE
• Andreas Uhl · Eppelheim, DE

Key dates

• Filing date: Jul 31, 2012
• Grant date: Jan 28, 2014
• Expiry date: Jul 31, 2032

Classification

• Technology area (CPC Y): Emerging Cross-Sectional Technologies
• CPC primary: Y02D10/00
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

Embodiments for managing data in a hierarchical storage server storing data blocks of a database system comprising primary storage devices being in an active mode and secondary storage devices being in one of an active and passive mode are provided. In response to read and write requests for data blocks at logical storage locations, a block mapping device determines physical storage locations on the storage devices. Read requests switch over secondary storage devices to the active mode when they are in the passive mode. Write requests write data blocks only to the primary storage devices. Secondary storage devices that have not been accessed for a minimum activation time may be switched over from the active to the passive mode to save power consumption and cooling. Data migration and data recall policies control moving of data blocks between the primary and secondary storage devices and are primarily based on threshold values.