The promise of solid state disks: increasing efficiency and reducing cost of DBMS processing

Most database systems (DBMSs) today are operating on servers equipped with magnetic disks. In our contribution, we want to motivate the use of two emerging and striking technologies, namely native XML DBMSs (XDBMSs for short) and solid state disks. In this context, the traditional read/write model optimized by a sophisticated cache hierarchy and the IO cost model for databases needs adjustment. Such new devices together with optimized storage mapping of XML documents provide a number of challenging characteristics. We discuss howtheir optimization potential ca be exploited to enhance transactional DB performance under reduced energy consumption to match increasing application demands and, at the same time, to guarantee economic energy use in data centers.

[1]  Matthias Nicola,et al.  An XML transaction processing benchmark , 2007, SIGMOD '07.

[2]  David J. DeWitt,et al.  The design and performance evaluation of alternative XML storage strategies , 2002, SGMD.

[3]  Kyuseok Shim,et al.  Storage and retrieval of XML data using relational databases , 2001, Proceedings 19th International Conference on Data Engineering (Cat. No.03CH37405).

[4]  Cong Yu,et al.  TIMBER: A native XML database , 2002, The VLDB Journal.

[5]  Goetz Graefe,et al.  Fast scans and joins using flash drives , 2008, DaMoN '08.

[6]  Wolf-Dietrich Weber,et al.  Power provisioning for a warehouse-sized computer , 2007, ISCA '07.

[7]  Jim Gray,et al.  Flash Disk Opportunity for Server Applications , 2008, ACM Queue.

[8]  Christian Mathis,et al.  Comparison of Complete and Elementless Native Storage of XML Documents , 2007, 11th International Database Engineering and Applications Symposium (IDEAS 2007).

[9]  Yuanyuan Zhou,et al.  Hibernator: helping disk arrays sleep through the winter , 2005, SOSP '05.