scispace - formally typeset
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

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

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

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.