DYNAMIC STORAGE BLOCKS TIERING

摘要

Storage management for database access, in which selected data blocks are associated with particular business operations, and in which those data blocks are disposed in response to an assessment of which of those business operations are more important, more urgent, or have a greater need to be reliable. This has the effect that overall transaction performance is improved without significantly increasing infrastructure cost. Noting the relative importance of those particular business transactions and the relative probability that those data blocks will be needed by those particular business transactions, and assuring that data blocks associated with relatively important business transactions are moved to relatively superior storage in advance of requests for access.

主权项

1. A method of dynamic storage blocks tiering including steps of:
associating data blocks with one or more business operations, wherein the data blocks are associated with database structures accessible by a database server, wherein the database server is coupled to at least a first storage device and a second storage device, wherein the storage devices have different performance parameters; maintaining a set of information for the data blocks, wherein the set of information comprises a rank that indicates a significance of the business operation with which the data blocks are associated and a probability of near-term access requests for the data blocks; determining an anticipated order of the one or more business operations based on the step of maintaining; and repositioning at least some of the data blocks between the at least first and second storage devices, wherein the repositioning includes moving one or more of the data blocks from the first storage device to the second storage device in response to the step of determining.