Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Posted Feb 11, 2010

What Drives Database Innovation

By DatabaseJournal.com Staff

Carl Olofson, research vice president of information management and data integration software at IDC, answered some questions put forth by Oracle Magazine concerning database management technology. Questions revolved around clustering, lower cost, and overall better performance for the system.

Insightful responses from Mr. Olofson when asked about reducing storage costs included:

"Data compression and database partitioning are two ways. One of Oracle’s 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?
View Article

Daily News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.