Welcome to D
SIGMOD 2004
PODS 2004
SIGMOD RECOR
CIKM 2004
DASFAA 2004
DBPL 2003
DE-BULLETIN
DEBS 2004
DMKD 2004
DMSN 2004
DOLAP 2004
DPDJ 2004
EDBT 2004
ER 2003
GIS 2004
HDP 2004
HYPERTEXT 20
ICDE 2004
ICDT 2003
JCDL 2004
MDM
MIR 2004
MIS 2004
MMDB 2004
MOBIDE 2003
RIDE 2004
SBBD 2003
SIGIR FORUM
SIGIR 2004
SIGKDD EXPLO
SIGKDD 2004
SSDBM 2004
SSTD 2003
TIME 2004
TODS 2004
VLDB 2004
VLDB Journal
WEBDB 2004
WIDM 2004
XIME-P 2004
Footer

Guy M. Lohman

Papers on DiSC'04


Robust Query Processing through Progressive Optimization

Tutorial 3: Self-Managing Technology in Database Management Systems

ROX: Relational Over XML

DB2 Design Advisor: Integrated Automatic Physical Database Design

Automated Statistics Collection in DB2 UDB

Progressive Optimization in Action

Publications


Note: Links lead to the DBLP on the Web.

Guy M. Lohman

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 : Recommending Materialized Views and Indexes with IBM DB2 Design Advisor. ICAC 2004 : 180-188

Volker Markl , Vijayshankar Raman , David E. Simmen , Guy M. Lohman, Hamid Pirahesh : Robust Query Processing through Progressive Optimization. SIGMOD Conference 2004 : 659-670

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

Ashraf Aboulnaga , Peter J. Haas , Sam Lightstone , Guy M. Lohman, Volker Markl , Ivan Popivanov , Vijayshankar Raman : Automated Statistics Collection in DB2 UDB. VLDB 2004 : 1146-1157

Surajit Chaudhuri , Benoît Dageville , Guy M. Lohman: Self-Managing Technology in Database Management Systems. VLDB 2004 : 1243

Vijayshankar Raman , Volker Markl , David E. Simmen , Guy M. Lohman, Hamid Pirahesh : Progressive Optimization in Action. VLDB 2004 : 1337-1340

Alan Halverson , Vanja Josifovski , Guy M. Lohman, Hamid Pirahesh , Mathias Mörschel : ROX: Relational Over XML. VLDB 2004 : 264-275

Ihab F. Ilyas , Jun Rao , Guy M. Lohman, Dengfeng Gao , Eileen Tien Lin : Estimating Compilation Time of a Query Optimizer. SIGMOD Conference 2003 : 373-384

Volker Markl , Guy M. Lohman, Vijayshankar Raman : LEO: An autonomic query optimizer for DB2. IBM Systems Journal 42 (1): 98-106 (2003)

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

Jun Rao , Chun Zhang , Nimrod Megiddo , Guy M. Lohman: Automating physical database design in a parallel database. SIGMOD Conference 2002 : 558-569

Volker Markl , Guy M. Lohman: Learning table access cardinalities with LEO. SIGMOD Conference 2002 : 613

Guy M. Lohman, Sam Lightstone : SMART: Making DB2 (More) Autonomic. VLDB 2002 : 877-879

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

Daniel C. Zilio , Sam Lightstone , Kelly A. Lyons , Guy M. Lohman: Self-Managing Technology in IBM DB2 Universal Database. CIKM 2001 : 541-543

Jun Rao , Bruce G. Lindsay , Guy M. Lohman, Hamid Pirahesh , David E. Simmen : Using EELs, a Practical Approach to Outerjoin and Antijoin Reordering. ICDE 2001 : 585-594

Chun Zhang , Jeffrey F. Naughton , David J. DeWitt , Qiong Luo , Guy M. Lohman: On Supporting Containment Queries in Relational Database Management Systems. SIGMOD Conference 2001

Michael Stillger , Guy M. Lohman, Volker Markl , Mokhtar Kandil : LEO - DB2's LEarning Optimizer. VLDB 2001 : 19-28

Guy M. Lohman, César A. Galindo-Legaria , Michael J. Franklin , Leonard J. Seligman : SIGMOD 2001 Industry Sessions. SIGMOD Record 30 (4): 86-89 (2001)

Gary Valentin , Michael Zuliani , Daniel C. Zilio , Guy M. Lohman, Alan Skelley : DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes. ICDE 2000 : 101-110

Guy M. Lohman: Review - Hash Joins and Hash Teams in Microsoft SQL Server. ACM SIGMOD Digital Review 2 : (2000)

Richard T. Snodgrass , Serge Abiteboul , Sophie Cluet , Michael J. Franklin , Guy M. Lohman, David B. Lomet , Gultekin Özsoyoglu , Raghu Ramakrishnan , Kenneth A. Ross , Timos K. Sellis , Patrick Valduriez : Reminiscences on Influential Papers. SIGMOD Record 28 (1): 110-114 (1999)

Surajit Chaudhuri , Hector Garcia-Molina , Henry F. Korth , Guy M. Lohman, David B. Lomet , David Maier : Future Directions in Database Research (Panel). ICDE 1998 : 456

K. Bernhard Schiefer , Jim Kleewein , Karen Brannon , Guy M. Lohman, Gene Fuh : IBM's DB2 Universal Database demonstrations at VLDB'98. VLDB 1998 : 703

Guy M. Lohman: You Think Your DBMS is Complex Now? ACM Comput. Surv. 28 (4es): article 81 (1996)

Peter Gassner , Guy M. Lohman, K. Bernhard Schiefer , Yun Wang : Query Optimization in the IBM DB2 Family. IEEE Data Eng. Bull. 16 (4): 4-18 (1993)

Guy M. Lohman, Amílcar Sernadas , Rafael Camps : 17th International Conference on Very Large Data Bases, September 3-6, 1991, Barcelona, Catalonia, Spain, Proceedings. Morgan Kaufmann 1991

Guy M. Lohman, George Lapis , Tobin J. Lehman , Rakesh Agrawal , Roberta Cochrane , John McPherson , C. Mohan , Hamid Pirahesh , Jennifer Widom : Starburst II: The Extender Strikes Back! SIGMOD Conference 1991 : 447

Guy M. Lohman, Bruce G. Lindsay , Hamid Pirahesh , K. Bernhard Schiefer : Extensions to Starburst: Objects, Types, Functions, and Rules. Commun. ACM 34 (10): 94-109 (1991)

George Lapis , Guy M. Lohman, Hamid Pirahesh : A Starburst is Born. SIGMOD Conference 1990 : 393

Kiyoshi Ono , Guy M. Lohman: Measuring the Complexity of Join Enumeration in Query Optimization. VLDB 1990 : 314-325

Laura M. Haas , Walter Chang , Guy M. Lohman, John McPherson , Paul F. Wilms , George Lapis , Bruce G. Lindsay , Hamid Pirahesh , Michael J. Carey , Eugene J. Shekita : Starburst Mid-Flight: As the Dust Clears. IEEE Trans. Knowl. Data Eng. 2 (1): 143-160 (1990)

Laura M. Haas , Johann Christoph Freytag , Guy M. Lohman, Hamid Pirahesh : Extensible Query Processing in Starburst. SIGMOD Conference 1989 : 377-388

Lothar F. Mackert , Guy M. Lohman: Index Scans Using a Finite LRU Buffer: A Validated I/O Model. ACM Trans. Database Syst. 14 (3): 401-424 (1989)

Guy M. Lohman: Grammar-like Functional Rules for Representing Query Optimization Alternatives. SIGMOD Conference 1988 : 18-27

Mavis K. Lee , Johann Christoph Freytag , Guy M. Lohman: Implementing an Interpreter for Functional Rules in a Query Optimizer. VLDB 1988 : 218-229

Guy M. Lohman: Do semantically equivalent SQL queries perform differently? ICDE 1986 : 225-226

Peter M. Schwarz , W. Chang , Johann Christoph Freytag , Guy M. Lohman, John McPherson , C. Mohan , Hamid Pirahesh : Extensibility in the Starburst Database System. OODBS 1986 : 85-92

Lothar F. Mackert , Guy M. Lohman: R* Optimizer Validation and Performance Evaluation for Local Queries. SIGMOD Conference 1986 : 84-95

Lothar F. Mackert , Guy M. Lohman: R* Optimizer Validation and Performance Evaluation for Distributed Queries. VLDB 1986 : 149-159

Guy M. Lohman: Letter from the Editor. IEEE Database Eng. Bull. 9 (4): 1 (1986)

Guy M. Lohman, C. Mohan , Laura M. Haas , Dean Daniels , Bruce G. Lindsay , Patricia G. Selinger , Paul F. Wilms : Query Processing in R* Query Processing in Database Systems 1985 : 31-47

Guy M. Lohman, Dean Daniels , Laura M. Haas , Ruth Kistler , Patricia G. Selinger : Optimization of Nested Queries in a Distributed Relational Database. VLDB 1984 : 403-415

Guy M. Lohman, Joseph C. Stoltzfus , Anita N. Benson , Michael D. Martin , Alfonso F. Cardenas : Remotely-Sensed Geophysical Databases: Experience and Implications for Generalized DBMS. SIGMOD Conference 1983 : 146-160

Laura M. Haas , Patricia G. Selinger , Elisa Bertino , Dean Daniels , Bruce G. Lindsay , Guy M. Lohman, Yoshifumi Masunaga , C. Mohan , Pui Ng , Paul F. Wilms , Robert A. Yost : R*: A Research Project on Distributed Relational DBMS. IEEE Database Eng. Bull. 5 (4): 28-32 (1982)

Guy M. Lohman, John A. Muckstadt : Optimal Policy for Batch Operations: Backup, Checkpointing, Reorganization, and Updating (Abstract). SIGMOD Conference 1977 : 157

Guy M. Lohman, John A. Muckstadt : Optimal Policy for Batch Operations: Backup, Checkpointing, Reorganization, and Updating. ACM Trans. Database Syst. 2 (3): 209-222 (1977)

Dennis G. Severance , Guy M. Lohman: Differential Files: Their Application to the Maintenance of Large Data Bases (Abstract). SIGMOD Conference 1976 : 43

Dennis G. Severance , Guy M. Lohman: Differential Files: Their Application to the Maintenance of Large Databases. ACM Trans. Database Syst. 1 (3): 256-267 (1976)

1 [ 28 ]

2 [ 46 ]

3 [ 22 ]

4 [ 49 ]

5 [ 6 ]

6 [ 5 ]

7 [ 26 ]

8 [ 23 ]

9 [ 6 ]

10 [ 18 ]

11 [ 12 ]

12 [ 18 ]

13 [ 27 ] [ 45 ]

14 [ 28 ]

15 [ 22 ] [ 49 ]

16 [ 49 ]

17 [ 45 ]

18 [ 5 ] [ 7 ] [ 8 ]

19 [ 33 ]

20 [ 47 ]

21 [ 28 ] [ 31 ]

22 [ 12 ] [ 14 ] [ 17 ]

23 [ 26 ]

24 [ 31 ]

25 [ 42 ]

26 [ 47 ]

27 [ 27 ]

28 [ 24 ]

29 [ 49 ]

30 [ 5 ] [ 7 ] [ 8 ] [ 17 ] [ 18 ]

31 [ 46 ]

32 [ 43 ]

33 [ 40 ]

34 [ 42 ]

35 [ 43 ]

36 [ 32 ]

37 [ 7 ]

38 [ 26 ]

39 [ 27 ]

40 [ 18 ] [ 20 ] [ 22 ]

41 [ 14 ]

42 [ 22 ]

43 [ 49 ]

44 [ 35 ] [ 36 ] [ 37 ] [ 40 ] [ 46 ] [ 47 ] [ 49 ]

45 [ 42 ]

46 [ 5 ] [ 8 ] [ 18 ] [ 21 ] [ 34 ]

47 [ 27 ] [ 28 ]

48 [ 33 ]

49 [ 35 ]

50 [ 49 ]

51 [ 10 ] [ 11 ] [ 16 ]

52 [ 27 ]

53 [ 32 ] [ 38 ] [ 41 ] [ 44 ] [ 46 ] [ 48 ]

54 [ 40 ]

55 [ 6 ]

56 [ 5 ]

57 [ 12 ] [ 18 ] [ 22 ]

58 [ 39 ]

59 [ 5 ] [ 8 ] [ 12 ] [ 22 ]

60 [ 43 ]

61 [ 3 ] [ 4 ]

62 [ 33 ]

63 [ 5 ]

64 [ 40 ]

65 [ 19 ]

66 [ 28 ]

67 [ 12 ] [ 17 ] [ 18 ] [ 20 ] [ 21 ] [ 22 ] [ 34 ] [ 43 ] [ 44 ] [ 48 ] [ 49 ]

68 [ 46 ]

69 [ 28 ]

70 [ 41 ] [ 44 ] [ 46 ] [ 48 ]

71 [ 34 ] [ 39 ] [ 42 ] [ 47 ]

72 [ 28 ]

73 [ 21 ] [ 24 ] [ 26 ]

74 [ 12 ]

75 [ 31 ]

76 [ 5 ] [ 7 ] [ 8 ]

77 [ 28 ]

78 [ 23 ]

79 [ 1 ] [ 2 ]

80 [ 18 ]

81 [ 34 ] [ 44 ] [ 48 ]

82 [ 30 ]

83 [ 28 ]

84 [ 32 ]

85 [ 6 ]

86 [ 47 ]

87 [ 40 ]

88 [ 28 ]

89 [ 30 ] [ 49 ]

90 [ 24 ]

91 [ 22 ]

92 [ 5 ] [ 8 ] [ 18 ]

93 [ 5 ]

94 [ 33 ] [ 39 ]

95 [ 30 ] [ 35 ] [ 36 ] [ 47 ] [ 49 ]

96 [ 30 ]

97 [ 49 ]




©2005 Association for Computing Machinery