User profiles for S. Lightstone

Sam S. Lightstone

Meta, ex-IBM CTO and Fellow
Verified email at fb.com
Cited by 4606

[PDF][PDF] DB2 design advisor: integrated automatic physical database design

DC Zilio, J Rao, S Lightstone, G Lohman… - Proceedings of the …, 2004 - vldb.org
… It’s unlikely for a system to support two features that duplicate each other on functionalities.
… we currently support in Table 1, where an S represents strong and a W represents weak. We …

[BOOK][B] Database modeling and design: logical design

TJ Teorey, SS Lightstone, T Nadeau, HV Jagadish - 2011 - books.google.com
… Details on how to seek permission, further information about the Publisher’s permissions
policies and our arrangements with organizations such as the Copyright Clearance Center and …

DB2 with BLU acceleration: So much more than just a column store

…, J Leenstra, S Lightstone, S Liu… - Proceedings of the …, 2013 - dl.acm.org
… A stride typically contains on the order of thousands of rows, but its exact size is chosen so
that the evaluator’s working set fits in the processor’s cache, so is dependent on the query, …

[BOOK][B] Data mining: know it all

…, RH Güting, J Han, X Jiang, M Kamber, SS Lightstone… - 2008 - books.google.com
This book brings all of the elements of data mining together in a single volume, saving the
reader the time and expense of making multiple purchases. It consolidates both introductory …

[PDF][PDF] Adaptive self-tuning memory in DB2

AJ Storm, C Garcia-Arellano, SS Lightstone… - Proceedings of the 32nd …, 2006 - vldb.org
… find it difficult to tune a database’s memory because the workload … Performance tuning is
time-consuming – Tuning a database’s … The net effect is a reduction in the product’s total cost of …

[BOOK][B] Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more

SS Lightstone, TJ Teorey, T Nadeau - 2010 - books.google.com
The rapidly increasing volume of information contained in relational databases places a
strain on databases, performance, and maintainability: DBAs are under greater pressure than …

Memory-efficient hash joins

…, R Sidle, G Attaluri, N Chainani, S Lightstone… - Proceedings of the …, 2014 - dl.acm.org
… Further, our memory usage is mostly insensitive to the outer’s cardinality. Our join is also
faster in most cases than this prior work, assuming that all the joins fully run in memory. We …

Recommending materialized views and indexes with the IBM DB2 design advisor

DC Zilio, C Zuzarte, S Lightstone, W Ma… - International …, 2004 - ieeexplore.ieee.org
… The key idea of our approach is to extend the database engine’s query optimizer in order
to both: (1) suggest good candidate objects (MQTs and indexes), and (2) evaluate the benefit …

[HTML][HTML] Comparing CMAQ Forecasts with a Neural Network Forecast Model for PM2.5 in New York

SD Lightstone, F Moshary, B Gross - Atmosphere, 2017 - mdpi.com
… Finally, S. Lightstone would like to acknowledge partial support of this project through a …
Samuel Lightstone was responsible for the NN experiments and the CMAQ assessment; …

Smart: Making db2 (more) autonomic

GM Lohman, SS Lightstone - VLDB'02: Proceedings of the 28th …, 2002 - Elsevier
Publisher Summary DB2's Self-Managing And Resource Tuning (SMART) project is developing
a stream of autonomic technology—not just GUIs and handholding—that will actually …