Auflistung nach Autor:in "Lohman, Guy"
1 - 2 von 2
Treffer pro Seite
Sortieroptionen
- KonferenzbeitragEvolutionary integration of in-memory database technology into IBM's enterprise DB2 database systems(INFORMATIK 2013 – Informatik angepasst an Mensch, Organisation und Umwelt, 2013) Stolze, Knut; Lohman, Guy; Raman, Vijayshankar; Sidle, Richard; Beier, FelixRecently, IBM announced Blink Ultra (BLU) as an in-memory enhancement for DB2 for Linux, Unix, and Windows. The technology implemented in BLU was tested in various stages until it founds its current form as DB2 feature. In this paper, we give a brief summary on the origins of BLU and the adoption process from the BLINK prototype over the IBM Smart Analytics Optimizer to BLU itself.
- KonferenzbeitragQuery Optimization – Are We There Yet?(Datenbanksysteme für Business, Technologie und Web (BTW 2017), 2017) Lohman, GuyAfter nearly 4 decades and hundreds of scientific papers, relational query optimization can hardly be characterized as anything but a huge scientific and commercial success. The market in 2016 for relational database products was estimated by IDC to be about $40B, out of a total database market of $45.1B. And SQL still dominates database application development and is widely recognized as the most successful declarative language. None of this would have been possible without the success of query optimization, which transforms declarative SQL statements of what data the user needs into an “optimal” execution plan, i.e., a detailed, procedural specification for how that data will be accessed and processed. So are we “there” yet? Are we done? Are all the big and interesting problems solved? Is query optimization as an area of scientific inquiry dead, relegated to incremental improvements and mere engineering? Why do we continue see so many papers on query optimization? In this talk, I argue that current research appears to be incremental because we are largely attacking the wrong problems while ignoring much harder and more significant problems. We are solving the problems we know how to solve, not the problems that need solving.