BIT Joint School seminar
Thu Nov 24, 2011 at 14:30
Meeting room Toblino Via Sommarive, 5
Database cracking targets dynamic and exploratory environments where there is no sufficient workload knowledge and idle time to invest in physical design preparations and tuning. With DB cracking indexes are built incrementally, adaptively and on demand; each query is seen as an advice on how data should be stored. With each incoming query, data is reorganized on-the-fly as part of the query operators, while future queries exploit and continuously enhance this knowledge. Autonomously, adaptively and without any external human administration, the system quickly adapts to a new workload and reaches optimal performance when the workload stabilizes.
We will talk about the basics of DB cracking including selection cracking, partial and sideways cracking and updates. We will also talk about important open and on going research issues such as disk based cracking, concurrency control and intergration of cracking with offline and online index analysis.
About the speaker
Stratos holds a tenure track senior researcher position with CWI, the Dutch National Research Center for Mathematics and Computer Science. The main focus of his research is on adaptive query processing and database architectures, mainly in the context of column-stores. He also works on stream processing, distributed query processing and scientific databases. Stratos won the 2011 ACM SIGMOD Jim Gray Dissertation Award for his thesis on database cracking, and the 2011 PVLDB Challenges and Visions best paper award for the vision on adaptive scientific data management. Also in 2010 he was named a "Distinguished Greek Scientist Excelling in Research abroad" by the Hellenic Minitry of National Defense. Stratos obtained his PhD from CWI and University of Amsterdam. In the past he has also been with the Technical University of Crete, Greece, and held research internship positions with Microsoft Research, Redmond, with EPFL, Switzerland and with IBM Almaden. In April 2011 he was also a visiting researcher with National University of Singapore.
Web page: http://homepages.cwi.nl/~idreos
Contact: Themis Palpanas