Oops! The input is malformed! Storage and the Cluttered Medicine Cabinet by Bill Inmon - BeyeNETWORK India


 

Storage and the Cluttered Medicine Cabinet

Originally published 23 February 2006

 

Multi-storage management of data is a reality. You undoubtedly are familiar with high-performance disk storage, but there are other forms of storage that should be part of an organization’s storage management practice. 

 

Some people are under the mistaken impression that when you move data to lower, mid-tiered forms of storage, performance suffers. However, by spreading your data over tiers of storage, performance actually improves. 

In order to explain why performance improves by spreading data across multiple levels of storage, consider the strange analogy that follows. 

Suppose you are moving to a new home. Some of the items you need to move include a toothbrush, skis, an encyclopedia and assorted reference books, socks and a variety of tools for your car. Now suppose you decide to do something strange. You decide to put your toothbrush, your books, your socks, your skis and your tools in the medicine cabinet. (Pretend for just a minute that you could put these items in a medicine cabinet!) 

Each morning when you need to get your toothbrush, it takes a lot of time to find it. You have to sift through the ski gear, socks and books. You then decide to move some of these items out of your medicine cabinet in order to access your toothbrush more easily. You move your skis to the garage. You move your books to the bookshelf. You move your socks to a chest of drawers. With the clutter reduced, you can efficiently access your toothbrush. 

The same is true for data in different levels of storage. To improve your storage performance, move the data that has a low probability of access to sequential storage. Move the data that you want to access often to high-performance storage. Everything else should be in to mid-tier storage. 

Now when your favorite technician asks if performance suffers when you move data to lower forms of storage, explain that if data needs to be accessed in a high-performance mode, it should be on high performance storage and that if data is accessed infrequently, it actually improves performance to place that data on mid-tier storage.

SOURCE: Storage and the Cluttered Medicine Cabinet

  • Bill InmonBill Inmon

    Bill is universally recognized as the father of the data warehouse. He has more than 36 years of database technology management experience and data warehouse design expertise. He has published more than 40 books and 1,000 articles on data warehousing and data management, and his books have been translated into nine languages. He is known globally for his data warehouse development seminars and has been a keynote speaker for many major computing associations.

    Editor's Note: More articles, resources and events are available in Bill's BeyeNETWORK Expert Channel. Be sure to visit today!

Recent articles by Bill Inmon

 

Comments

Want to post a comment? Login or become a member today!

Be the first to comment!