Daniel C. Zilio, PhD, MMath, BMath, BEd

PhD - University of Toronto, Dept. of Computer Science 1998

MMath - University of Waterloo, Dept. of Computer Science 1989

BMath - University of Waterloo, Dept. of Computer Science 1988

BEd - University of Western Ontatio 1990

Current position: IBM Infosphere Optim Query Workload Tuner Team, IBM Toronto Lab, 1997 - present


University of Toronto

Short Bio, Areas of Interest and Expertise

Daniel Zilio is a senior developer in the IBM Infosphere Optim Query Workload Tuner group in the IBM Silicon Valley Lab. He is currently working from the IBM Toronto Lab. He joined IBM in 1997 on the IBM DB2 Optimizer team and has worked on the IBM DB2 Autonomic Computing team. As a member of the IBM DB2 team, he has worked on database design decision algorithms, query access planning, optimizer cost modeling, query access plan visualization (the explain facility), database simulation, self-tuning memory management, XML design selection, and automatic statistics collection. He was also a member of the team that designed and developed the initial DB2 LUW index advisor, and he later led the team that designed and devloped its predecessor: the Design Advisor, which included materialized view, multi-node partitioning, and multidimensional clustering selection. While on the Query Workload Team, Daniel has designed and created (for DB2 zOS and LUW) a data mart advisor, a workload statistical views advisor (extending the workload statistics advisor), and the facility to capture/gather/view actual and estimated cardinalities for query plans. He also assisted in the development of the workload index advisor, workload statistics advisor, access plan comparison, and what-if index analysis.

Before joining IBM, Daniel obtained his PhD from the University of Toronto in the area of physical DB design selection, which included creating automatic partition and index selection algorithms. During his PhD, he had a student fellowship internship at IBM Yorktown Heights Research Center in 1994 and was an IBM Center for Advanced Studies Student Fellow from 1994 to 1997.

Daniel was also a lecturer in the Departments of Computer Science at the University of Waterloo, University of Toronto, and York University between 1990 and 2002.

During his Honours Bachelor of Mathematics program at the University of Waterloo, Daniel held positions at: (1) the Ontario Government's Office of Municipal Affairs and Housing, where Daniel was developing software for the office's economists on both mainframe and desktop computers, (2) Watcom in Waterloo, developing an application to process and apply a Generalized System Markup Language (GSML) that was used as the interface between the software Watcom developed and the systems on which the applications would execute, (3) ITT in which Daniel developed internal telephony applications, (4) NCR where Daniel developed an optimal cheque imaging system to automatically scan, process and store cheques processed by NCR's high speed cheque processing system.

Daniel's interests and expertise are in the areas of: Physical Database Design Decision Algorithms for relational and XML database systems, Autonomic Computing in Database Systems, Query Optimization and Compilation, Query Performance tuning, Self-tuning Memory Management, Automatic Statistics Collection, Learning Database Optimizers, and Concurrent Reorganization for Parallel Database Systems.

DBLP References

Daniel Zilio's DBLP References


Getting Started with IBM Data Studio 3.1 for DB2

Publically Available XML Index Advisor Application

IBM DB2 XML Index Advisor for Linux, UNIX, and Windows

Some of My Papers -- Including PhD Thesis (Supervised by Prof. Ken Sevcik)

DB2 Design Advisor: Integrated Automatic Physical Database Design, Daniel C. Zilio, Jun Rao, Sam Lightstone, Guy M. Lohman, Adam Storm, Christian Garcia-Arellano, Scott Fadden, VLDB, 2004.

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, IEEE Int. Conf. on Autonomic Computing (ICAC), 2004.

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

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, Nov. 2001, ACM.

DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes, Gary Valentin, Michael Zuliani, Daniel C. Zilio, Guy M. Lohman, Alan Skelley, Proceedings of the Sizteenth IEEE Conf. on Data Engineering, San Diego, CA, Feb. 2000, IEEE Computer Society.

Physical Database Design Decision Algorithms and Concurrent Reorganization for Parallel Database Systems Daniel C. Zilio, PhD Thesis Department of Computer Science, University of Toronto, 1998.

Modeling On-line Rebalancing with Priorities and Executing on Parallel Database Systems Daniel C. Zilio, IBM CASCON'96 (CD-ROM) Toronto, Ontario, Canada, Nov. 1996.

Partitioning Key Selection for a Shared-Nothing Parallel Database System Daniel C. Zilio, Anant Jhingran, Sriram Padmanabhan, IBM Research Report RC 19820 (87739) 11/10/94 ,T. J. Watson Research Center, Yorktown Heights, NY, October 1994.

Data Reorganization in Parallel Database Systems Chaitanya Baru, Daniel C. Zilio, Proceedings of the IEEE Workshop on Advances in Parallel and Distributed Systems ,Princeton, NJ, October 1993, IEEE Computer Society, pp. 102-107.

Other Activities

External PhD Thesis Committee member for Jozsef Patvarczki in the Department of Computer Science at Worcester Polytechnic Institute.

Daniel's contact information:

IBM Canada Ltd.
8200 Warden Ave
Markham, Ontario, Canada
L6G 1C7
Phone: 1-905-413-2693
Fax: 1-905-413-4840
E-mail: zilio@ca.ibm.com

Department of Computer Science
University of Toronto
Toronto, ON
M5S 1A4
E-mail: zilio@cs.utoronto.ca