Building Enterprise Class Real-Time Energy Efficient Decision Support Systems

In today’s highly competitive marketplace, companies have an insatiable need for up-to-the-second information about their business’ operational state, while generating Terabytes of data per day [2]. The ability to convert this data into meaningful business information in a timely, cost effective manner is critical to their competitiveness. For many, it is no longer acceptable to move operational data into specialized analytical tools because of the delay this additional step would take. In certain cases they prefer to directly run queries on their operational data. To keep the response time of these queries low while data volume increases, IT departments are forced to buy faster processors or increase the number of processors per system. At the same time they need to scale the I/O subsystem to keep their systems balanced. While processor performance has been doubling every two years in accordance with Moore’s Law, I/O performance is lagging far behind. As a consequence, storage subsystems not only have to cope with the increase in data capacity, but, foremost, with the increase in I/O throughput demand, which is often limited by the disk drive performance and the wire bandwidth between the server and storage.

[1]  Meikel Pöss,et al.  New TPC benchmarks for decision support and web commerce , 2000, SGMD.

[2]  Raghunath Othayoth Nambiar,et al.  Why You Should Run TPC-DS: A Workload Analysis , 2007, VLDB.

[3]  Raghunath Othayoth Nambiar,et al.  Energy cost, the key challenge of today's data centers: a power consumption analysis of TPC-C results , 2008, Proc. VLDB Endow..

[4]  Raghunath Nambiar,et al.  Large scale data warehouses on grid: Oracle database 10 g and HP proliant servers , 2005, VLDB 2005.

[5]  Raghunath Othayoth Nambiar,et al.  Tuning servers, storage and database for energy efficient data warehouses , 2010, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010).

[6]  Raghunath Othayoth Nambiar,et al.  A power consumption analysis of decision support systems , 2010, WOSP/SIPEW '10.

[7]  Kushagra Vaid,et al.  Energy benchmarks: a detailed analysis , 2010, e-Energy.

[8]  Detlef D. Nauck,et al.  Real Time Business Intelligence for the Adaptive Enterprise , 2006, The 8th IEEE International Conference on E-Commerce Technology and The 3rd IEEE International Conference on Enterprise Computing, E-Commerce, and E-Services (CEC/EEE'06).