Computer Science – Databases
Scientific paper
2011-12-31
Proceedings of the VLDB Endowment (PVLDB), Vol. 5, No. 4, pp. 274-285 (2011)
Computer Science
Databases
VLDB2012
Scientific paper
Data center operators face a bewildering set of choices when considering how to provision resources on machines with complex I/O subsystems. Modern I/O subsystems often have a rich mix of fast, high performing, but expensive SSDs sitting alongside with cheaper but relatively slower (for random accesses) traditional hard disk drives. The data center operators need to determine how to provision the I/O resources for specific workloads so as to abide by existing Service Level Agreements (SLAs), while minimizing the total operating cost (TOC) of running the workload, where the TOC includes the amortized hardware costs and the run time energy costs. The focus of this paper is on introducing this new problem of TOC-based storage allocation, cast in a framework that is compatible with traditional DBMS query optimization and query processing architecture. We also present a heuristic-based solution to this problem, called DOT. We have implemented DOT in PostgreSQL, and experiments using TPC-H and TPC-C demonstrate significant TOC reduction by DOT in various settings.
Hacıgümüş Hakan
Patel Jignesh M.
Tatemura Junichi
Zhang Ning
No associations
LandOfFree
Towards Cost-Effective Storage Provisioning for DBMSs does not yet have a rating. At this time, there are no reviews or comments for this scientific paper.
If you have personal experience with Towards Cost-Effective Storage Provisioning for DBMSs, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Towards Cost-Effective Storage Provisioning for DBMSs will most certainly appreciate the feedback.
Profile ID: LFWR-SCP-O-672709