S
Sam Lightstone
Researcher at IBM
Publications - 116
Citations - 3623
Sam Lightstone is an academic researcher from IBM. The author has contributed to research in topics: Database design & Database tuning. The author has an hindex of 32, co-authored 116 publications receiving 3510 citations.
Papers
More filters
Book ChapterDOI
DB2 design advisor: integrated automatic physical database design
Daniel C. Zilio,Jun Rao,Sam Lightstone,Guy M. Lohman,Adam J. Storm,Christian Garcia-Arellano,Scott Fadden +6 more
TL;DR: The DB2 Design Advisor in IBM DB2® Universal DatabaseTM (DB2 UDB) Version 8.2 for Linux®, UNIX® and Windows® is a tool that, for a given workload, automatically recommends physical design features that are any subset of indexes, materialized query tables (also called materialized views), shared-nothing database partitionings, and multidimensional clustering of tables.
The Morgan Kaufmann Series in Data Management Systems
Jim Gray,Mamdouh Refaat,Jim Melton,Stephen Buxton,Jiawei Han,Micheline Kamber,Toby J. Teorey,Sam Lightstone,Hanan Samet,Joe Celko,Markus Schneider,Gerhard Weikum,Gottfried Vossen,Philippe Rigaux,Michel Scholl,Klaus R. Dittrich,Malcolm Chisholm,Andrew Eisenberg,Joseph M. Hellerstein,V. S. Subrahmanian,Philip A. Bernstein,Eric Newcomer +21 more
TL;DR: In this article, the most significant algorithms and impossibility results in the area of distributed algorithms are presented in a simple automata-theoretic setting, and their complexity is analyzed according to precisely defined complexity measures.
Journal ArticleDOI
DB2 with BLU acceleration: so much more than just a column store
Vijayshankar Raman,Gopi K. Attaluri,Ronald J. Barber,Naresh K. Chainani,David Kalmuk,Vincent Kulandaisamy,Jens Leenstra,Sam Lightstone,Shaorong Liu,Guy M. Lohman,Tim Malkemus,Rene Mueller,Ippokratis Pandis,Berni Schiefer,David C. Sharpe,Richard S. Sidle,Adam J. Storm,Liping Zhang +17 more
TL;DR: Full integration with DB2 ensures that DB2 with BLU Acceleration benefits from the full functionality and robust utilities of a mature product, while still enjoying order-of-magnitude performance gains from revolutionary technology without even having to change the SQL.
Proceedings ArticleDOI
Adaptive self-tuning memory in DB2
TL;DR: This work believes this is the first known use of cost-benefit analysis and control theory in database memory tuning across heterogeneous memory consumers.