Insightful responses from Mr. Olofson when asked about reducing storage costs included:
|"Data compression and database partitioning are two ways. One of Oracles approaches entails database partitioning. Customers can establish partitions or tiers in the database that let them move infrequently accessed data to less-expensive storage platforms. For example, high-throughput transactional databases can reside on Tier 1 storage to get the best performance. Transactional data that has reached the end of its lifecycle can be moved to less-expensive Tier 2 storage devices."|
As well as, answering questions about maximizing I/O performance without spending more, Mr. Olofson answered:
|" One way that database management systems do this is by caching in the form of in-memory databases, which serve as a front end to the database and reduce the number of requests that have to go back to the data server itself. And compression not only helps reduce storage costs, it also effectively makes your database buffers bigger because you can put more data in them, and therefore you do less I/O."|
Check out the full interview for responses to:
- How does database management technology today influence the choice of system hardware?
- How are DBAs dealing with the challenge of maintaining large database management systems?
- What are some of the ways that companies can reduce data storage costs?
- How can organizations maximize I/O performance without investing in faster hardware?
- What are the benefits of file storage in the database?