Publications

Sam Lightstone

Sam Lightstone

Distinguished Engineer at IBM
BIO: Sam Lightstone is Distinguished Engineer for relational Cloud Data repositories as well as co-founder of IBM's technology incubation initiative.He is author or several books, papers, and patents on computer science, careers, and data engineering.
Sam Lightstone

Per Google Scholar, there are over 1,900 citations of these publications. http://bit.ly/QIoCYX

 

1. 2015 R. Barber, G.M. Lohman, V. Raman, R. Sidle, S. Lightstone, B. Schiefer: “In-memory BLU acceleration in IBM’s DB2 and dashDB: Optimized for modern workloads and hardware architectures”, ICDE 2015: 1246-1252
2. 2014 R. Barber, Guy M. Lohman, I. Pandis, V. Raman, R. Sidle, G.K. Attaluri, N. Chainani, S. Lightstone, D. Sharpe: “Memory-Efficient Hash Joins”. PVLDB 8(4): 353-364 (2014)
3. 2014 J. Lee, G. K. Attaluri, R. Barber, N. Chainani, O. Draese, F. Ho, S. Idreos, M.S. Kim, S. Lightstone, G.M. Lohman, K. Morfonios, K. Murthy, I. Pandis, L. Qiao, V. Raman, V. Kulandai Samy, R. Sidle, K. Stolze, L. Zhang: “Joins on Encoded and Partitioned Data”, PVLDB 7(13): 1355-1366 (2014)
4. 2013 P. Zikopoulos, S. Lightstone, M. Huras, A. Sachedina, G. Baklarz, “DB2 10.5 with BLU Acceleration – New Dynamic In-Memory Analytics for the Era of Big Data”, McGraw-Hill Osborne Media, Oct 2013. 10-ISBN 0071823492
5. 2013 V. Raman, G. Attaluri, R. Barber, N. Chainani, D. Kalmuk, V. Kulandai Samy, J. Leenstra, S. Lightstone, S. Liu, G. M. Lohman, T. Malkemus , R. Mueller, I. Pandis, B. Schiefer, D. Sharpe, R. Sidle, A. Storm, L. Zhang, “DB2 with BLU Acceleration: So Much More than Just a Column Store” VLDB August 2013
6. 2013 S. Lightstone, G. Lohman, B. Schiefer ,“Super Analytics, Super Easy: Introducing IBM DB2 10.5 with BLU Acceleration”, IBM Data Magazine,   April 3, 2013
7. 2010 R. Xin, P. Dantressangle, S. Lightstone, W. McLaren, S. Schormann, M. Schwenger: “MEET DB2: Automated Database Migration Evaluation”, PVLDB 3(2): 1426-1434 (2010)
8. 2010 S. Lightstone, “Making It Big In Software: Get the job. Work the org. Become great.”, Prentice Hall, March 2010. ISBN-10: 0137059671
9. 2009 Sam Lightstone: Physical Database Design for Relational Databases. Encyclopedia of Database Systems 2009: 2108-2114
10. 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: Report: 3rd Int’l Workshop on Self-Managing Database Systems (SMDB 2008). IEEE Data Eng. Bull. 31(4): 2-5 (2008)
11. 2008 S. Lightstone, C. Tsounis, A. Colangelo, S. Tsounis,  “Best Practices: Physical Database Design”, IBM developerWorks, http://www.ibm.com/developerworks/db2/bestpractices/, May 22, 2008.
12. 2008 H. Rizvi, J. Coleman, S. Lightstone, “Poster session: Simplifying business intelligence with a hybrid appliance: the IBM Balanced Warehouse”,  3rd International Workshop on Self-Managing Database Systems (SMDB 2008), 7 April 2008, Cancun Mexico in conjunction with the 24th International Conference on Data Engineering (ICDE 2008)
13. 2008 Said Elnaffar, Patrick Martin, Berni Schiefer, Sam Lightstone: Is it DSS or OLTP: automatically identifying DBMS workloads. J. Intell. Inf. Syst. 30(3): 249-271 (2008)
14. 2007 A. Ailamaki, S. Chaudhuri, S. Lightstone, G. Lohman, P. Martin, K. Salem, G. Weikum, “Report on the Second International Workshop on Self-Managing Database Systems (SMDB 2007)”,  IEEE Computer Society Bulletin of the Technical Committee on Data Engineering, June 2007 Vol. 30 No. 2
15. 2007 A. Teisanu, M. Consens, M. Kandil, S. Lightstone, D. Zilio, C. Zuzarte, “Poster: Problem Definition for Effective Workload Management”, 2nd International Workshop on Self-Managing Database Systems (SMDB 2007), 16 April 2007, Istanbul, Turkey  in conjunction with 23rd International Conference on Data Engineering (ICDE 2007)
16. 2007 S. Lightstone, M. Surendra, Y. Diao, S. Parekh, J. Hellerstein, K. Rose, A. Storm, C. Garcia-Arellano, “Control Theory: a Foundational Technique for Self Managing Databases”, 2nd International Workshop on Self-Managing Database Systems (SMDB 2007), 16 April 2007, Istanbul, Turkey  in conjunction with 23rd International Conference on Data Engineering (ICDE 2007)
17. 2007 Sam S. Lightstone, “Seven software engineering principles for autonomic computing development”,  Innovations in Systems and Software Engineering, Journal 11334, Volume 3, Issue 1, March 2007
18. 2007 Sam S. Lightstone, Chris Eaton, Yun Han Lee, Adam J. Storm “Optimizing Concurrency Through Automated Lock Memory Tuning in DB2” IEEE 23rd International Conference on Data Engineering (ICDE 2007)   April 16-20, 2007 The Marmara Hotel, Istanbul, Turkey
19. 2007 S. Lightstone, T. Teory, T. Nadeau, “Physical Database Design: the database professional’s guide to exploiting indexes, views, storage, and more”, Morgan Kaufmann Press, 2007. ISBN: 0123693896
20. 2006 A.J. Storm, C.M. Garcia-Arellano, S. Lightstone, Y.Diao, M. Surendra, “Adaptive Self-tuning Memory in DB2 UDB”, VLDB 2006, Sept 10-15 2006, Seoul South Korea.
21. 2006 Sam Lightstone, Guy M. Lohman, Peter J. Haas, Volker Markl, Jun Rao, Adam Storm, Maheswaran Surendra, Daniel C. Zilio “Making DB2 Products Self-Managing: Strategies and Experiences”, IEEE Data Eng. Bull. 29 No. 3, 2006
22. 2006 S. Lightstone, “Letter from Chair of Working Group on Self-Managing Database Systems”. IEEE Data Eng. Bull.  Special Issue on Self Managing Database Systems Sept 2006, Vol. 29 No. 3, IEEE Computer Society.
23. 2006 C. M. Garcia-Arellano, S. Lightstone, G. Lohman, V. Markl, A.Storm “A Self-Managing Relational Database Server: Examples from IBM’s DB2 Universal Database for Linux Unix and Windows”, the IEEE Transactions on Systems, Man and Cybernetics, Part C, May 2006 volume: 36,  Issue: 3 pp: 365- 376
24. 2006 S. Lightstone, “Foundations of Autonomic Computing Development”, IEEE Computer Society – Task Force on Autonomous and Autonomic Systems (TFAAS), Newsletter – Issue 3 (Feb/Mar 2006) – Letters, http://tab.computer.org/aas/
25. 2006 S. Lightstone, “Letter from Chair of Working Group on Self-Managing Database Systems”, Bulletin of the Technical Committee on Data Engineering: Special Issue on Probabilistic Data Management, March 2006, Vol. 29 No. 1, IEEE Computer Society.
26. 2005 T. Teorey, S. Lightstone, T. Nadeau, “Database Modeling & Design: Logical Design, 4th edition”, Morgan Kaufmann Press, 2005. ISBN: 0-12-685352-5
27. 2005 Y. Diao, C. Wah Wu, J. L. Hellerstein, A. J. Storm, M. Surendra, S. Lightstone, S. Parekh, C. Garcia-Arellano, M. Carroll, L. Chu, J. Colaco “Comparative Studies of Load Balancing With Control and Optimization Techniques” 24th American Control Conference (ACC),  June 8-10, 2005, Portland, Oregon.
28. 2004 A. Brown, J. Hellerstein, M. Hogstrom, T. Lau, S. Lightstone, P. Shum, M. Yost. “Benchmarking Autonomic Capabilities: Promises and Pitfalls”, International Conference on Autonomic Computing (ICAC-04) New York, NY, on 17-18 May 2004,
29. 2004 D. Zilio, G. Lohman, C. Zuzarte, W. Ma, S. Lightstone,  B. Cochrane,  H. Pirahesh.”Recommending Materialized Views and Indexes by IBM’s DB2 Design Advisor”, International Conference on Autonomic Computing (ICAC-04) New York, NY, on 17-18 May 2004.
30. 2004 J. Rao, S. Lightstone , G. Lohman, D. Zilio , A. Storm,  C. Garcia-Arellano,   S. Fadden. “DB2 Design Advisor: integrated automated physical database design”, VLDB 2004, Toronto, Canada
31. 2004 S. Lightstone, B. Bhattacharjee “Automating the design of multi-dimensional clustering tables in relational databases”, VLDB 2004, Toronto, Canada,
32. 2004 S. Parekh, K. R. Rose, J. L. Hellerstein, S. Lightstone, M. Huras, and V. Chang.  “Throttling Utilities in the IBM DB2 Universal Database Server”, Proceedings of the American Control Conference, Boston, MA, June 1, 2004.
33. 2004 S. Parekh, K. Rose, Y. Diao, V.  Chang, J. Hellerstein, S. Lightstone, M. Huras “Throttling Utilities in the IBM DB2 Universal Database Server”,  IBM Research Report No. RC23163
34. 2004 V. Markl  I. Popivanov  S. Lightstone  V. Raman , A. Aboulnaga , P. Haas , G. Lohman  “Automated Statistics Collection in DB2 Stinger”, VLDB 2004, Toronto, Canada,
35. 2004 Y. Diao, J. Hellerstein, A. Storm, M. Surendra, S. Lightstone, S. Parekh, C. Garcia-Arellano, ”Incorporating Cost of Control into the Design of a Load Balancing Controller”,  IBM Research Report No. RC23230
36. 2004 Y. Diao, J. Hellerstein, A. Storm, M. Surendra, S. Lightstone, S. Parekh, C. Garcia-Arellano “Load Balancing Using MIMO Linear Control”, IBM Research Report No. RC23213.
37. 2004 Y. Diao, J. Hellerstein, A.Storm, M. Surendra, S. Lightstone, S. Parekh, C. Garcia-Arellano “Using MIMO Linear Control for Load Balancing in Computing Systems”, American Control Conference, 2004.
38. 2004 Y. Diao, J. Hellerstein, A.Storm, M. Surendra, S. Lightstone, S. Parekh, C. Garcia-Arellano. “Incorporating Cost of Control Into the Design of a Load Balancing Controller”, IEEE Real-Time and Embedded Technology and Application Systems Symposium, March 1, 2004,
39. 2003 D. Zilio, S. Lightstone, G. lohman.  “Trends in automated database design”, IEEE Workshop on Autonomic Computing Principles and Architectures (AUCOPA’ 2003), Banff AB, Aug. 2003.
40. 2003 E. Kwan, S. Lightstone,  B. Schiefer, A Storm, L Wu. “Automatic Configuration for IBM DB2 Universal Database: Compressing years of performance tuning experience into seconds of execution”, 10th Conference on Database Systems for Business, Technology, and the Web (BTW 2003),February 26 – 28, 2003, University of Leipzig, Germany.
41. 2003 R. Telford,  R. Horman, S. Lightstone, N. Markov,  S. O’Connell, G. Lohman. “Usability and design considerations for an autonomic relational database management system”, IBM Systems Journal, Volume 42, Number 4, 2003,
42. 2003 S. Lightstone, B. Schiefer, D. Zilio, J. Kleewein “Autonomic Computing for Relational Databases: the ten year vision”,   IEEE Workshop on Autonomic Computing Principles and Architectures (AUCOPA’ 2003), Banff AB, Aug. 2003.
43. 2003 S. Lightstone, J. Hellerstein, W. Tetzlaff, P. Janson, E. Lassettre, C. Norton, B. Rajaraman, L. Spainhower, “Towards Benchmarking Autonomic Computing Maturity”,. IEEE Workshop on Autonomic Computing Principles and Architectures (AUCOPA’ 2003), Banff AB, Aug. 2003.
44. 2003 S. Parekh, K. Rose, J. Hellerstein , S. Lightstone, M. Huras , V. Chang. “Managing the Performance Impact of Administrative Utilities”, Computer Science IBM Research Report RC22864 (W0308-003) August 1, 2003,
45. 2003 S. Parekh, K. Rose, J. Hellerstein, V. Chang, S. Lightstone, M. Huras  “A General Approach to Policy-Based Mangement of the Performance Impact of Administrative Utilities”, DSOM 2003: 14th IFIP/IEEE International Workshop on Distributed Systems: Operations and Management, 20-22 October 2003, Heidelberg, Germany
46. 2002 D. Zilio, S. Lightstone, “CASCON 2001 Workshop Report: Self-Managed Database Systems”, IBM Technical Report TR-74.182-10
47. 2002 G. Lohman, S. Lightstone “SMART: Making DB2 (More) Autonomic”,  VLDB 2002: 877-879,
48. 2002 S. Lightstone,  G. Lohman, B. Smith, R. Horman, J. Teng. “A SMARTer DB2”, DB2 Magazine, Quarter 4, 2002 • Vol. 7, Issue 4,
49. 2002 S. Lightstone,  G. Lohman, D. Zilio. “Toward Autonomic Computing with DB2 Universal Database”, SIGMOD Record Vol 31 Number 3 September 2002,
50. 2001 D. Zilio,  S. Lightstone,  K. Lyons, G. Lohman (IBM) “Self-Managing Technology in IBM DB2 Universal Database” ACM CIKM 2001, Tenth International Conference on Information and Knowledge Management, Georgia Industry Session Data Management: Beyond the Traditional November 5-10, 2001 Atlanta,
51. 2001 S. Lightstone,  E. Kwan, L Wu, and A Storm “Automatic Configuration for IBM® DB2® Universal Database: Compressing years of  performance tuning experience into seconds of execution”, 2001 Performance Technical Journal, IBM Corp.,
52. 1995 T. Greer, S. Lightstone,  “Inventions By Software Testers: Natural, Neutral, or Not Real?”, 8th Annual Software Testing Symposium, Poughkeepsie, NY.,
53. 1994 S. Lightstone, “A Successful Approach to Development Toolkit Functional Verification Testing”, 7th Annual IBM Software Testing Symposium, Boca Raton, FLA.
54. 1991 F. Fan, S. Lightstone, E. Wiseman, “Speech Coder Interface For Skywave Satellite Terminal”, Telecommunications Research Institute of Ontario.