Sam (S.S.) Lightstone  Sam (S.S.) Lightstone photo         

contact information

CTO for Data & IBM Fellow, IBM Data and AI
Markham, ON, Canada
  

links



2017


Making Big Data Simple with dashDB Local
Sam Lightstone, Russ Ohanian, Michael Haide, James Cho, Michael Springgay, Torsten Steinbach
33rd IEEE International Conference on Data Engineering, ICDE 2017, San Diego, CA, USA, April 19-22, 2017, pp. 1195--1205


2015


In-memory BLU acceleration in IBM's DB2 and dashDB: Optimized for modern workloads and hardware architectures
Ronald Barber, Guy M. Lohman, Vijayshankar Raman, Richard Sidle, Sam Lightstone, Berni Schiefer
31st IEEE International Conference on Data Engineering, ICDE 2015, Seoul, South Korea, April 13-17, 2015, pp. 1246--1252


2014

Joins on Encoded and Partitioned Data
Jae-Gil Lee, Gopi K. Attaluri, Ronald Barber, Naresh Chainani, Oliver Draese, Frederick Ho, Stratos Idreos, Min-Soo Kim, Sam Lightstone, Guy M. Lohman, Konstantinos Morfonios, Keshava Murthy, Ippokratis Pandis, Lin Qiao, Vijayshankar Raman, Vincent Kulandai Samy, Richard Sidle, Knut Stolze, Liping Zhang
PVLDB 7(13), 1355--1366, 2014

Memory-Efficient Hash Joins
Ronald Barber, Guy M. Lohman, Ippokratis Pandis, Vijayshankar Raman, Richard Sidle, Gopi K. Attaluri, Naresh Chainani, Sam Lightstone, David Sharpe
PVLDB 8(4), 353--364, 2014


2013

DB2 with BLU Acceleration: So Much More than Just a Column Store
Vijayshankar Raman, Gopi K. Attaluri, Ronald Barber, Naresh Chainani, David Kalmuk, Vincent KulandaiSamy, Jens Leenstra, Sam Lightstone, Shaorong Liu, Guy M. Lohman, Tim Malkemus, Ren\'{e} M\"{u}ller, Ippokratis Pandis, Berni Schiefer, David Sharpe, Richard Sidle, Adam J. Storm, Liping Zhang
PVLDB 6(11), 1080--1091, 2013

DB2 10.5 with BLU Acceleration - New Dynamic In-Memory Analytics for the Era of Big Data
Paul Zikopoulos, Sam Lightstone, Matthew Huras, Aamer Sachedina, George Baklarz
McGraw-Hill Osborne Media, 2013


2010

MEET DB2: Automated Database Migration Evaluation
Reynold Xin, Patrick Dantressangle, Sam Lightstone, William McLaren, Steve Schormann, Maria Schwenger
PVLDB 3(2), 1426--1434, 2010

Making It Big In Software: Get the job. Work the org. Become great
Sam Lightstone
Prentice Hall, 2010


2009


Physical Database Design for Relational Databases
Sam Lightstone
Encyclopedia of Database Systems, pp. 2108--2114, 2009


2008


Poster session: Simplifying business intelligence with a hybrid appliance: the IBM balanced warehouse
Haider Rizvi, Joyce Coleman, Sam Lightstone
Proceedings of the 24th International Conference on Data Engineering Workshops, ICDE 2008, April 7-12, 2008, Canc\'un, Mexico, pp. 71--78

Is it DSS or OLTP: automatically identifying DBMS workloads
Said Elnaffar, Patrick Martin, Berni Schiefer, Sam Lightstone
J. Intell. Inf. Syst. 30(3), 249--271, 2008

Database Design - Know It All
Stephen Buxton, Lowell Fryman, Ralf Hartmut G\"{u}ting, Terry A. Halpin, Jan L. Harrington, William H. Inmon, Sam Lightstone, Jim Melton, Tony Morgan, Thomas P. Nadeau, Bonnie O'Neil, Elizabeth J. O'Neil, Patrick E. O'Neil, Markus Schneider, Graeme Simsion, Toby J. Teorey, Graham Witt
Morgan Kaufmann, 2008

Report: 3rd Int'l Workshop on Self-Managing Database Systems (SMDB 2008)
Anastassia Ailamaki, Shivnath Babu, Pedro Furtado, Sam Lightstone, Guy M. Lohman, Patrick Martin, Vivek R. Narasayya, Glenn Pauley, Kenneth Salem, Kai-Uwe Sattler, Gerhard Weikum
IEEE Data Eng. Bull. 31(4), 2--5, 2008

Data Mining - Know It All
Soumen Chakrabarti, Earl Cox, Eibe Frank, Ralf Hartmut G\"{u}ting, Jiawei Han, Xia Jiang, Micheline Kamber, Sam Lightstone, Thomas P. Nadeau, Richard E. Neapolitan, Dorian Pyle, Mamdouh Refaat, Markus Schneider, Toby J. Teorey, Ian H. Witten
Morgan Kaufmann, 2008


2007




Report on the Second International Workshop on Self-Managing Database Systems (SMDB 2007)
Anastassia Ailamaki, Surajit Chaudhuri, Sam Lightstone, Guy M. Lohman, Patrick Martin, Kenneth Salem, Gerhard Weikum
IEEE Data Eng. Bull. 30(2), 2--4, 2007


Optimizing Concurrency Through Automated Lock Memory Tuning in DB2
Sam Lightstone, Chris Eaton, Yun Han Lee, Adam J. Storm
Proceedings of the 23rd International Conference on Data Engineering, ICDE 2007, The Marmara Hotel, Istanbul, Turkey, April 15-20, 2007, pp. 1154--1163

Control Theory: a Foundational Technique for Self Managing Databases
Sam Lightstone, Maheswaran Surendra, Yixin Diao, Sujay S. Parekh, Joseph L. Hellerstein, Kevin Rose, Adam J. Storm, Christian Garcia-Arellano
Proceedings of the 23rd International Conference on Data Engineering Workshops, ICDE 2007, 15-20 April 2007, Istanbul, Turkey, pp. 395--403

Problem definition for effective workload management
Adrian M. Teisanu, Sam Lightstone, Mariano P. Consens, Daniel C. Zilio, Mokhtar Kandil, Calisto Zuzarte
Proceedings of the 23rd International Conference on Data Engineering Workshops, ICDE 2007, 15-20 April 2007, Istanbul, Turkey, pp. 492--497


2006




Adaptive Self-tuning Memory in DB2
Adam J. Storm, Christian Garcia-Arellano, Sam Lightstone, Yixin Diao, Maheswaran Surendra
Proceedings of the 32nd International Conference on Very Large Data Bases, Seoul, Korea, September 12-15, 2006, pp. 1081--1092

Making DB2Products Self-Managing: Strategies and Experiences
Sam Lightstone, Guy M. Lohman, Peter J. Haas, Volker Markl, Jun Rao, Adam J. Storm, Maheswaran Surendra, Daniel C. Zilio
IEEE Data Eng. Bull. 29(3), 16--23, 2006


2004

(e)Proceedings of the Thirtieth International Conference on Very Large Data Bases, Toronto, Canada, August 31 - September 3 2004

Morgan Kaufmann, 2004



Automated design of multidimensional clustering tables for relational databases
Sam Lightstone, Bishwaranjan Bhattacharjee
(e)Proceedings of the Thirtieth International Conference on Very Large Data Bases, Toronto, Canada, August 31 - September 3 2004, pp. 1170--1181

Automated Statistics Collection in DB2 UDB
Ashraf Aboulnaga, Peter J. Haas, Sam Lightstone, Guy M. Lohman, Volker Markl, Ivan Popivanov, Vijayshankar Raman
(e)Proceedings of the Thirtieth International Conference on Very Large Data Bases, Toronto, Canada, August 31 - September 3 2004, pp. 1146--1157

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
(e)Proceedings of the Thirtieth International Conference on Very Large Data Bases, Toronto, Canada, August 31 - September 3 2004, pp. 1087--1097

Incorporating Cost of Control into the Design of a Load Balancing Controller
Yixin Diao, Joseph L. Hellerstein, Adam J. Storm, Maheswaran Surendra, Sam Lightstone, Sujay S. Parekh, Christian Garcia-Arellano
10th IEEE Real-Time and Embedded Technology and Applications Symposium (RTAS 2004), 25-28 May 2004, Toronto, Canada, pp. 376--387

Recommending Materialized Views and Indexes with IBM DB2 Design Advisor
Daniel C. Zilio, Calisto Zuzarte, Sam Lightstone, Wenbin Ma, Guy M. Lohman, Roberta Cochrane, Hamid Pirahesh, Latha S. Colby, Jarek Gryz, Eric Alton, Dongming Liang, Gary Valentin
1st International Conference on Autonomic Computing (ICAC 2004), 17-19 May 2004, New York, NY, USA, pp. 180--188

Benchmarking Autonomic Capabilities: Promises and Pitfalls
Aaron B. Brown, Joseph L. Hellerstein, Matt Hogstrom, Tony Lau, Sam Lightstone, Peter Shum, Mary Peterson Yost
1st International Conference on Autonomic Computing (ICAC 2004), 17-19 May 2004, New York, NY, USA, pp. 266--267


2003


BTW 2003, Datenbanksysteme f\"ur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz, 26.-28. Februar 2003, Leipzig

GI, 2003

Managing the Performance Impact of Administrative Utilities
Sujay S. Parekh, Kevin Rose, Joseph L. Hellerstein, Sam Lightstone, Matthew Huras, Victor Chang
Self-Managing Distributed Systems, 14th IFIP/IEEE International Workshop on Distributed Systems: Operations and Management, DSOM 2003, Heidelberg, Germany, October 20-22, 2003, Proceedings, pp. 130--142

Automatic Database Configuration for DB2 Universal Database: Compressing Years of Performance Expertise into Seconds of Execution
Eva Kwan, Sam Lightstone, K. Bernhard Schiefer, Adam J. Storm, Leanne Wu
BTW 2003, Datenbanksysteme f\"ur Business, Technologie und Web, Tagungsband der 10. BTW-Konferenz, 26.-28. Februar 2003, Leipzig, pp. 620--629

Usability and design considerations for an autonomic relational database management system
Ric Telford, Randy Horman, Sam Lightstone, Nikolay Markov, Stephen O'Connell, Guy M. Lohman
IBM Systems Journal 42(4), 568--581, 2003


2002

VLDB 2002, Proceedings of 28th International Conference on Very Large Data Bases, August 20-23, 2002, Hong Kong, China

Morgan Kaufmann, 2002

SMART: Making DB2 (More) Autonomic
Guy M. Lohman, Sam Lightstone
VLDB 2002, Proceedings of 28th International Conference on Very Large Data Bases, August 20-23, 2002, Hong Kong, China, pp. 877--879

Toward Autonomic Computing with DB2 Universal Database
Sam Lightstone, Guy M. Lohman, Daniel C. Zilio
SIGMOD Record 31(3), 55--61, 2002


2001

Proceedings of the 2001 ACM CIKM International Conference on Information and Knowledge Management, Atlanta, Georgia, USA, November 5-10, 2001

ACM, 2001

Self-Managing Technology in IBM DB2 Universal Database
Daniel C. Zilio, Sam Lightstone, Kelly A. Lyons, Guy M. Lohman
Proceedings of the 2001 ACM CIKM International Conference on Information and Knowledge Management, Atlanta, Georgia, USA, November 5-10, 2001, pp. 541--543