Physical Database Design

Physical Database Design

Volumn , Issue , 2007, Pages

  Lightstone, Sam ^a   Teorey, Toby ^b   Nadeau, Tom ^c  

^a IBM CANADA LTD   (Canada)

^b UNIVERSITY OF MICHIGAN   (United States)

^c Ubiquiti Inc   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

EID: 85013741022     PISSN: None     EISSN: None     Source Type: Book    
DOI: 10.1016/B978-0-12-369389-1.X5000-1     Document Type: Book

References (449)

1. Agarwal S., Chaudhuri S., Kollar L., Maranthe A., Narasayya V., Syamala M. Database Tuning Advisor for Microsoft SQL Server 2005. 30th Very Large Database Conference (VLDB) 2004.
2. Burleson D. Physical Database Design Using Oracle 2005, Auerbach Publishers, Boca Raton, FL.
3. Elmasri R., Navathe S.B. Fundamentals of Database Systems 2004, Redwood City, CA, Addison-Wesley, Boston. 4th ed.
4. Garcia-Molina H., Ullman J., Widom J. Database System Implementation 2000, Prentice-Hall, Englewood Cliffs, NJ.
5. Garcia-Molina H., Ullman J., Widom J. Database Systems: The Complete Book 2001, Prentice-Hall, Englewood Cliffs, NJ.
6. Oracle-SQL Tuning Advisor, at http://www.oracle-base.com/articles/10g/AutomaticSQLTuning10g.php.
7. Ramakrishnan R., Gehrke J. Database Management Systems 2004, McGraw-Hill, New York. 3rd ed.
8. Shasha D., Bonnet P. Database Tuning 2003, Morgan Kaufmann, San Francisco.
9. Silberschatz A., Korth H.F., Sudarshan S. Database System Concepts 2006, McGraw-Hill, New York. 5th ed.
10. Zilio D.C., Rao J., Lightstone S., Lohman G.M., Storm A., Garcia-Arellano C., Fadden S. DB2 Design Advisor: Integrated Automatic Physical Database Design 2004, 1087-1097, VLDB, Toronto, Canada.
11. Bayer R., McCreight E. Organization and Maintenance of Large Ordered Indexes. Acta. Inf. 1972, 1(3):173-189.
12. Date C.J. An Introduction to Database Systems 2003, Vol. 1. Addison-Wesley. 8th Ed.
13. Elmasri R., Navathe S.B. Fundamentals of Database Systems 2004, Addison-Wesley, Boston. 4th ed.
14. Grosshans D. File Systems Design and Implementation 1986, Prentice-Hall, Englewood Cliffs, NJ.
15. Harbron T.R. File Systems Structures and Algorithms 1988, Prentice-Hall, Englewood Cliffs, NJ.
16. O'Neil P., Graefe G. Multi-Table Joins through Bitmapped Join Indices. SIGMOD Record 1995, 24(3):8-11. Sept.
17. O'Neil P., O'Neil E. Database: Principles, Programming, and Performance 2001, Morgan Kaufmann, San Francisco. 2nd ed.
18. Ramakrishnan R., Gehrke J. Database Management Systems 2004, McGraw-Hill, New York. 3rd ed.
19. Silberschatz A., Korth H.F., Sudarshan S. Database System Concepts 2006, McGraw-Hill, New York. 5th ed.
20. Teorey T.J., Fry J.P. Design of Database Structures 1982, Prentice-Hall, Englewood Cliffs, NJ.
21. Wiederhold G. File Organization for Database Design 1987, McGraw-Hill, New York.
22. Burleson D. Physical Database Design Using Oracle 2005, Auerbach Publishers, Boca Raton, FL.
23. Date C.J. An Introduction to Database Systems 2003, vol. 1. Addison-Wesley, Boston. 8th ed.
24. Elmasri R., Navathe S.B. Fundamentals of Database Systems 2004, and Redwood City, CA, Addison-Wesley, Boston. 4th ed.
25. Garcia-Molina H., Ullman J., Widom J. Database Systems: The Complete Book 2001, Prentice-Hall, Englewood Cliffs, NJ.
26. O'Neil P., O'Neil E. Database: Principles, Programming, and Performance 2001, Morgan Kaufmann, San Francisco. 2nd ed.
27. Ozsu M.T., Valduriez P. Principles of Distributed Database Systems 1991, Prentice-Hall, Englewood Cliffs, NJ.
28. Roussopoulos N. View Indexing in Relational Databases. ACM Trans Database Systems 1982, 7(2):258-290.
29. Ramakrishnan R., Gehrke J. Database Management Systems 2004, McGraw-Hill, New York. 3rd ed.
30. Selinger P.G., Astrahan M.M., Chamberlin D.D., Lorie R.A., Price T.G. Access Path Selection in a Relational Database Management System. ACM SIGMOD Conference 1979, 23-34.
31. Silberschatz A., Korth H.F., Sudarshan S. Database System Concepts 2006, McGraw-Hill, New York. 5th ed.
32. Burleson D. Physical Database Design Using Oracle 2005, Auerbach Publishers, Boca Raton, FL.
33. Date C.J. An Introduction to Database Systems 2003, vol. 1. Addison-Wesley, Boston. 8th ed.
34. Elmasri R., Navathe S.B. Fundamentals of Database Systems 2004, and Redwood City, CA, Addison-Wesley, Boston. 4th ed.
35. Garcia-Molina H., Ullman J., Widom J. Database Systems: The Complete Book 2001, Prentice-Hall, Englewood Cliffs, NJ.
36. Hoffer J.A., Prescott M.B., McFadden F.R. Modern Database Management 2007, Prentice-Hall, Englewood Cliffs, NJ. 8th ed.
37. Hubel M.A. Simple Approach to DB2 Index Redesign. IDUG Solutions Journal 2001, 8(3).
38. Ramakrishnan R., Gehrke J. Database Management Systems 2004, McGraw-Hill, New York. 3rd ed.
39. Rees S. Index Design for Performance. IDUG-North America 2004.
40. Shasha D., Bonnet P. Database Tuning 2003, Morgan Kaufmann, San Francisco.
41. Shekhar S., Chawla S. Spatial Databases 2003, Prentice-Hall, Englewood Cliffs, NJ.
42. Silberschatz A., Korth H.F., Sudarshan S. Database System Concepts 2006, McGraw-Hill, Boston. 5th ed.
43. Harinarayan V., Rajaraman A., Ullman J.D. Implementing Data Cubes Efficiently. Proceedings of the 1996 ACM-SIGMOD Conference 1996, 205-216.
44. Kimball R., Reeves L., Ross M., Thornthwaite W. The Data Warehouse Life Cycle Toolkit 1998, John Wiley, New York.
45. Kimball R., Ross M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling 2002, John Wiley, New York. 2nd ed.
46. Kotidis Y., Roussopoulos N. DynaMat: A Dynamic View Management System for Data Warehouses. Proceedings of SIGMOD 1999 1999, 371-382.
47. Uchiyama H., Runapongsa K., Teorey T.J. Progressive View Materialization Algorithm. Proceedings of DOLAP 1999 1999, 36-41.
48. Baru C.K., Fecteau G., Goyal A., Hsiao H., Jhingran A., Padmanabhan S., Wilson W.G. An Overview of DB2 Parallel Edition. SIGMOD Conference 1995, 460-462.
49. Baru C.K., Fecteau G., Goyal A., Hsiao H., Jhingran A., Padmanabhan S., Copeland G.P., Wilson W.G. DB2 Parallel Edition. IBM Systems Journal 1995, 34(2):292-322.
50. DeWitt D.J., Gray J. Parallel Database Systems: The Future of High-Performance Database Systems. Commun. ACM 1992, 35(6):85-98.
51. Furtado P. Physical Design: Experimental Evidence on Partitioning in Parallel Data Warehouses. Proceedings of the 7th ACM International Workshop on Data Warehousing and OLAP 2004.
52. Goddard O.L. 17 Laws of Building Terabyte Class DB Systems. IBM DB2 Information Management Technical Conference 2005.
53. Gottemukkala V., Jhingran A., Padmanabhan S. Interfacing Parallel Applications and Parallel Databases. ICDE 1997, 355-364.
54. Hitz M., Mück T.A. Interconnection Topologies for Shared Nothing DBMS Architectures. Australian Database Conference 1993, 228-249.
55. Jhingran A., Malkemus T., Padmanabhan S. Query Optimization in DB2 Parallel Edition. IEEE Data Eng. Bull. 1997, 20(2):27-34.
56. Kudlur M., Govindarajan R. Performance Analysis of Methods That Overcome False Sharing Effects in Software DSMs. Journal of Parallel and Distributed Computing 2004, 64(8):887-907.
57. Kuznetsov, A. Using Materialized Query Tables to Speed up Queries in DB2 UDB, IBM developerWorks, at http://www.128. ibm.com/developerworks/db2/library/ techarticle/0208kuznetsov/0208kuznetsov.html.
58. Laing W.A. Shared Nothing Will Ultimately Prevail. HPTS 1993.
59. Mehta M., DeWitt D.J. Data Placement in Shared-Nothing Parallel Database Systems. VLDB Journal 1997, 6(1):53-72.
60. Padmanabhan S. Extracting Large Data Sets Using DB2 Parallel Edition. VLDB 1996, 582.
61. Stonebraker M. The Case for Shared Nothing. IEEE Database Eng. Bull. 1986, 9(1):4-9.
62. Weikum G. Tutorial on Parallel Database Systems. ICDT 1995, 33-37.
63. Talwadker A.S. Survey of Performance Issues in Parallel Database Systems. Journal of Computing Sciences in Colleges Archive 2003, 18(6):5-9. June.
64. Teradata Database Design Release V2R6.1 2005, NCR Corp.
65. Ceri S., Negri M., Pelagatti G. Horizontal Data Partitioning in Database Design. SIGMOD Conference 1982, 128-136.
66. DeWitt D.J., Gerber R.H., Graefe G., Heytens M.L., Kumar K.B., Muralikrishna M. GAMMA-A High-Performance Dataflow Database Machine. VLDB 1986, 228-237.
67. Ganesan P., Bawa M., Garcia-Molina H. Online Balancing of Range Partitioned Data with Applications to Peer-to-Peer Systems. VLDB 2004, 444-455.
68. Nguyen K.Q., Thompson T., Bryan G. An Enhanced Hybrid Range Partitioning Strategy for Parallel Database Systems. DEXA Workshop 1997, 289-294.
69. Tripp K. L. SQL Server 2005 Partitioned Tables and Indexes, at http://www.sqlskills.com/resources/Whitepapers/ Partitioning %20in%20SQL%20Server%202005%20Beta%20II.htm#_Toc79339950.
70. Bhattacharjee B., Padmanabhan S., Malkemus T., Lai T., Cranston L., Huras M. Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2. Proceedings of VLDB 2003.
71. Jagadish H.V., Lakshmanan L.V.S., Srivastava D. Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse. Proceedings of the 1999 International Conference on Management of Data 1999, 37-48.
72. Kennedy J.P. Introduction to MDC with DB2 UDB LUW. IBM DB2 Information Management Technical Conference 2005.
73. Lightstone S., Bhattacharjee B. Automating the Design of Multi-dimensional Clustering Tables in Relational Databases. VLDB 2004, Toronto, Canada.
74. Liou J.H., Yao S.B. Multi-dimensional Clustering for Database Organizations. Information Systems 1977, 2:187-198.
75. Malkemus T., Padmanabhan S., Bhattacharjee B., Cranston L. Predicate Derivation and Monotonicity Detection in DB2 UDB. ICDE 2005, 939-947.
76. Markl V., Ramsak F., Bayer R. Improving OLAP Performance by Multi-dimensional Hierarchical Clustering. Proceedings of IDEAS 1999, Montreal, Canada.
77. The OLAP Report, at http://www.olapreport.com/.
78. Padmanabhan S., Bhattacharjee B., Malkemus T., Cranston L., Huras M. Multi-Dimensional Clustering: A New Data Layout Scheme in DB2. SIGMOD 2003, San Diego, CA.
79. Pendse, N., and Creeth, R. Benchmarking an Extremely Large Decision Support Requirement: Proof Point of Scalability with IBM and DB2, Winter Corporation (www.wintercorp.com) DB2 9 Technical Library, at http://publib.boulder.ibm.com/infocenter/db2luw/v9/index.jsp?topic=/ com.ibm.db2.udb.doc/doc/r000.
80. Stöhr T., Märtens H., Rahm E. Multi-Dimensional Database Allocation for Parallel Data Warehouses. Proceedings of VLDB 2000, Cairo, Egypt.
81. Agrawal Sanjay, Chaudhuri Surajit, Vivek R. Narasayya Automated Selection of Materialized Views and Indexes in SQL Databases. VLDB 2000, 496-505.
82. Zilio D.C., Rao J., Lightstone S., Lohman G.M., Storm A.J., Garcia-Arellano C., Fadden S. DB2 Design Advisor: Integrated Automatic Physical Database Design. VLDB 2004, 1087-1097.
83. Acharya S., Gibbons P., Poosala V., Ramaswamy S. Join Synopses for Approximate Query Answering. Proceedings of 1999 SIGMOD 1999, 275-286. ACM Press, New York.
84. Chan T.F., Golub G.H., LeVeque R.J. Algorithms for Computing the Sample Variance: Analysis and Recommendation. Amer. Statist. 1983, 37:242-247.
85. Chaudhuri S., Motwani R., Narasayya V.R. On Random Sampling over Joins. Proceedings of 1999 SIGMOD 1999, 263-274. ACM Press, New York.
86. Chaudhuri S., Motwani R., Narasayya V.R. Random Sampling for Histogram Construction: How Much Is Enough?. SIGMOD Conference 1998, 436-447.
87. Devroye L. Non-Uniform Random Variate Generation 1986, Springer-Verlag, New York.
88. Flajolet P., Martin G.N. Probabilistic Counting Algorithms for Database Applications. Journal of Computer and System Sciences 1985, 31:182-209.
89. Ganguly S., Gibbons P.B., Matias Y., Silberschatz A. Bifocal Sampling for Skewresistant Join Size Estimation. Proceedings of 1996 SIGMOD 1996, 271-281. ACM Press, New York.
90. Haas P.J., Knig C. A Bi-level Bernoulli Scheme for Database Sampling. Proceedings of 2004 SIGMOD 2004, 275-286. ACM Press, New York.
91. Haas P.J. The Need for Speed: Speeding Up DB2 Using Sampling. IDUG Solutions Journal 2003, 10:32-34.
92. Haas P.J., Hellerstein J.M. Ripple Joins for Online Aggregation. Proceedings of 1999 SIGMOD 1999, 287-298. ACM Press, New York.
93. Haas P.J., Stokes L. Estimating the Number of Classes in a Finite Population. J. American Statistical Association 1998, 93:1475-1487. Dec.
94. Haas P.J., Naughton J.F., Seshadri S., Swami A.N. Selectivity and Cost Estimation for Joins Based on Random Sampling. J. Comput. Sys. Sci. 1996, 52:550-569.
95. Haas P.J., Naughton J.F., Seshadri S., Stokes L. Sampling-based Estimation of the Number of Distinct Values of an Attribute. Proceedings of the 21st International Conference on Very Large Databases 1995.
96. Haas P.J., Naughton J.F., Swami A.N. On the Relative Cost of Sampling for Join Selectivity Estimation. PODS 1994, 14-24.
97. Hellerstein J.M., Haas P.J., Wang H.J. Online Aggregation. Proceedings of 1997 SIGMOD 1997, 171-182. ACM Press, New York.
98. Hou W., Ozsoyoglu G., Taneja B. Statistical Estimators for Relational Algebra Expressions. Proceedings of Seventh ACM SIGACT-SIGMOD-SIGART Symp. Principles of Database Sys. 1988, 176-287. ACM Press, New York.
99. König A.C., Nabar S.U. Scalable Exploration of Physical Database Design. ICDE 2006, 37.
100. Nadeau T.P., Teorey T.J. A Pareto Model for OLAP View Size Estimation. Information Systems Frontiers 2003, 5(2):137-147.
101. Olken F. Random Sampling from Databases. Ph.D. Dissertation 1993, University of California, Berkeley, CA.
102. Runapongsa K., Nadeau T.P., Teorey T.J. Storage Estimation for Multidimensional Aggregates in OLAP. Proceedings of 10th CASCON Conference 1999, 40-54.
103. Shukla A., Deshpande P.M., Naughton J.F., Ramasamy K. Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies. Proceedings of 22nd VLDB Conference 1996, 522-531.
104. DB2 database, at http://www-306.ibm.com/software/data/db2/udb/.
105. Deigin Y. DB2 UDB Query Execution Plans: Up Close and Personal. DB2 Information Management Technical Conference Agenda 2005.
106. Microsoft SQL Server Home, at http://www.microsoft.com/sql/default.mspx. Oracle Database, at http://www.oracle.com/database/index.html.
107. Ramakrishnan R., Gehrke J. Database Management Systems 2004, McGraw-Hill, New York. 3rd ed.
108. Selinger P.G., Astrahan M.M., Chamberlin D.D., Lorie R.A., Price T.G. Access Path Selection in a Relational Database Management System. ACM SIGMOD Conference 1979, 23-34.
109. Agrawal S., Chaudhuri S., Kollar L., Narasayya V. Index Tuning Wizard for Microsoft SQL Server 2000, white paper. http://www.msdn.microsoft.com/library/techart/itwforsql.htm.
110. Agrawal S., Chaudhuri S., Narasayya V. Automated Selection of Materialized Views and Indexes for SQL Databases. Proceedings of VLDB 2000, 496-505.
111. Agrawal S., Narasayya V., Yang B. Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design. Proceedings of ACM SIGMOD 2004.
112. Agrawal S., Chaudhuri S., Kollár L., Marathe A., Narasayya V., Syamala M. Database Tuning Advisor for Microsoft SQL Server 2005. VLDB 2004, 1110-1121. Toronto, Canada.
113. BMC Index Advisor, at http://www.bmc.com.
114. Bruno N., Chaudhuri S. Automatic Physical Design Tuning: A Relaxation-based Approach. Proceedings of the ACM SIGMOD 2005.
115. Bruno N., Chaudhuri S. Physical Design Refinement. The Merge-Reduce Approach. Proceedings of EDBT Conference 2006.
116. Chaudhuri S., Gupta A., Narasayya V. Workload Compression. Proceedings of ACM SIGMOD 2002.
117. Chaudhuri S., Dageville B., Lohman G.M. Self-managing Technology in Database Management Systems. VLDB 2004, 1243.
118. Chaudhuri S., Narasayya V. An Efficient Cost-driven Index Selection Tool for Microsoft SQL Server. VLDB 1997, 146-155.
119. Chaudhuri S., Narasayya V. AutoAdmin /ldWhat-If " Index Analysis Utility. Proceedings of ACM SIGMOD 1998.
120. Chaudhuri S., Narasayya V. Index Merging. Proceedings of 15th International Conference on Data Engineering 1999.
121. Dageville B., Das D., Dias K., Yagoub K., Zaït M., Ziauddin M. Automatic SQL Tuning in Oracle 10g. VLDB 2004, 1098-1109.
122. Dias K., Ramacher M., Shaft U., Venkataramani V., Wood G. Automatic Performance Diagnosis and Tuning in Oracle. CIDR 2005, 84-94.
123. Finkelstein S., Schikolnick M., Tiberio P. Physical Database Design for Relational Databases. ACM Transactions of Database Systems 1988, 13(1):91-128.
124. König A., Nabar S. Scalable Exploration of Physical Database Design. Proceedings of 22nd International Conference on Data Engineering 2006.
125. Lehner W., Cochrane R., Pirahesh H., Zaharioudakis M. Fast Refresh Using Mass Query Optimization. ICDE 2001, 391-398.
126. Li W.S., Zilio D.C., Batra V.S., Subramanian M., Zuzarte C., Narang I. Load Balancing for Multitiered Database Systems through Autonomic Placement of Materialized Views. ICDE 2006, 102.
127. Lightstone S., Bhattacharjee B. Automating the Design of Multidimensional Clustering Tables in Relational Databases. VLDB 2004, 1170-1181.
128. Lightstone S., Schiefer B., Zilio D., Kleewein J. Autonomic Computing for Relational Databases: the ten year vision. Proceedings. IEEE International Conference on Industrial Informatics 2003, 419-424. 21-24 Aug. 2003, INDIN.
129. Rao J., Zhang C., Lohman G., Megiddo N. Automating Physical Database Design in a Parallel Database. Proceedings of the ACM SIGMOD 2002.
130. Schiefer K.Bernhard Gary Valentin: DB2 Universal Database Performance Tuning. IEEE Data Eng. Bull. 1999, 22(2):12-19.
131. Stohr T., Martens H., Rahm E. Multidimensional Aware Database Allocation for Parallel Data Warehouses. Proceedings of VLDB 2000.
132. Valentin G., Zuliani M., Zilio D., Lohman G. DB2 Advisor: An Optimizer That Is Smart Enough to Recommend Its Own Indexes. Proceedings of ICDE 2000.
133. Zilio D.C., Rao J., Lightstone S., Lohman G.M., Storm A.J., Garcia-Arellano C., Fadden S. DB2 Design Advisor: Integrated Automatic Physical Database Design. VLDB 2004, 1087-1097.
134. Zilio D.C., Zuzarte C., Lightstone S., Ma W., Lohman G.M., Cochrane R., Pirahesh H., Colby L.S., Gryz J., Alton E., Liang D., Valentin G. Recommending Materialized Views and Indexes with IBM DB2 Design Advisor. ICAC 2004, 180-188.
135. Zilio D.C., Lightstone S., Lohman G. Trends in automating physical database design. Proceedings IEEE International Conference on Industrial Informatics 2003, 441-445. INDIN, 21-24 Aug. 2003.
136. Adler R.M. Distributed Coordination Models for Client/Sever Computing. Computer 1995, 28(4):14-22. April.
137. Dickman A. Two-Tier versus Three-Tier Apps. InformationWeek 1995, 553:74-80. Nov. 13.
138. Diao Y., Hellerstein J.L., Storm A.J., Surendra M., Lightstone S., Parekh S.S., Edelstein H. Unraveling Client/Server Architecture. DBMS 1994, 7(5):34. May, (7).
139. Gallaugher J., Ramanathan S. Choosing a Client/Server Architecture: A Comparison of Two-Tier and Three-Tier Systems. Information Systems Management Magazine 1996, 13(2):7-13. Spring.
140. Garcia-Arellano C. Incorporating Cost of Control into the Design of a Load Balancing Controller. IEEE Real-Time and Embedded Technology and Applications Symposium 2004, 376-387.
141. Garcia-Molina H., Polyzois C.A. Issues in Disaster Recovery. COMPCON 1990, 573-577.
142. Gibson G.A., Hellerstein L., Karp R.M., Katz R.H., Patterson D.A. Failure Correction Techniques for Large Disk Arrays. ASPLOS 1989, 123-132.
143. Hennessy J.L., Patterson D.A. Computer Architecture: A Quantitative Approach 1996, Morgan Kaufmann, San Francisco. 2nd ed.
144. Hester P. Technology Analyst Day. AMD 2006, June 1.
145. Lightstone S., Storm A., Garcia-Arellano C., Carroll M., Colaco J., Diao Y., Surendra M. Self-tuning Memory Management in a Relational Database System. Fourth Annual Workshop on Systems and Storage Technology 2005, IBM Research Lab, Haifa University campus, Mount Carmel, Haifa, Israel.
146. Patterson D.A. Latency Lags Bandwidth. ICCD 2005, 3-6.
147. Patterson D.A. Terabytes-Teraflops or Why Work on Processors When I/O Is Where the Action Is? (Abstract.). ACM Conference on Computer Science 1994, 410.
148. Patterson D.A., Gibson G.A., Katz R.A. A Case for Redundant Arrays of Inexpensive Disks (RAID). SIGMOD Conference 1988, 109-116.
149. Pruscino A. Oracle RAC: Architecture and Performance. SIGMOD Conference 2003, 635.
150. Ramakrishnan R., Gehrke J. Database Management Systems 2003, McGraw-Hill, New York. 3rd ed.
151. Rudin K. Scalable Systems Architecture: Scalable I/O, Part I: Disk Striping. DM Review Magazine 1998, May.
152. Schulze M., Gibson G.A., Katz R.A., Patterson D.A. How Reliable Is a RAID?. COMPCON 1989, 118-123.
153. Schussel G. Client/Server Past, Present, and Future [online] 1995, http://www.dciexpo.com/geos.
154. Shelton R.E. The Distributed Enterprise (Shared, Reusable Business Models the Next Step in Distributed Object Computing). Distributed Computing Monitor 1993, 8:10. October.
155. Silberschatz A., Galvin P., Gagne G. Operating System Concepts 2002, John Wiley, New York. 6th ed.
156. Storm A.J., Garcia-Arellano C.M., Lightstone S., Diao Y., Surendra M. Adaptive Self-tuning Memory in DB2 UDB. VLDB 2006, Seoul, South Korea.
157. Zikopoulos, P. C., and Eaton, C. Availability with Clicks of a Button Using DB2's HADR, at http://www.dbazine.com/db2/db2-disarticles/zikopouloZikopoulos,9.
158. Harinath S., Quinn S. SQL Server Analysis Services 2005 with MDX 2006, John Wiley, New York.
159. Hindshaw, F., Metzger, J., and Zane, B. Optimized Database Appliance, Patent No. U.S. 7,010,521 B2, Assignee: Netezza Corporation, Framingham, MA, issued Marc.
160. IBM Data Warehousing, Analysis, and Discovery: Overview: IBM Software, at http:// www.306.ibm.com/software/data/db2bi/.
161. Kimball R., Reeves L., Ross M., Thornthwaite W. The Data Warehouse Life Cycle Toolkit 1998, John Wiley, New York.
162. Kimball R., Ross M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling 2002, John Wiley, New York. 2nd ed.
163. Kimball R., Caserta J. The Data Warehouse ETL Toolkit 2004, John Wiley, New York. 2nd ed.
164. Microsoft SQL Server: Business Intelligence Solutions, at http://www.microsoft.com/ sql/solutions/bi/default.mspx.
165. Netezza Corporation, at netezza.com.
166. Oracle Business Intelligence Solutions, at http://www.oracle.com/solutions/business_intelligence/index.html.
167. Patent Full-Text and Full-Page Image Databases, at www.uspto.gov/patft/index.html.
168. Powell G. Oracle Data Warehouse Tuning for 10g 2005, Elsevier, Boston.
169. Teorey T., Lightstone S., Nadeau T. Database Modeling and Design: Logical Design 2006, Morgan Kaufmann, San Francisco. 4th ed.
170. Ramakrishnan R., Gehrke J. Database Management Systems 2004, McGraw-Hill, New York. 3rd ed.
171. Rodgers U. Denormalization: Why, What, and How?. Database Programming and Design 1989, 2(12):46-53. Dec.
172. Schkolnick M., Sorenson P. Denormalization: A Performance-Oriented Database Design Technique. Proceedings from the AICA 1980 Congress 1980, 363-377. AICA, Bologna, Italy. Brussels.
173. Shasha D., Bonnet P. Database Tuning 2003, Morgan Kaufmann, San Francisco.
174. Silberschatz A., Korth H.F., Sudarshan S. Database System Concepts 2006, McGraw-Hill, New York. 5th ed.
175. Teorey T., Lightstone S., Nadeau T. Database Modeling and Design: Logical Design 2006, Morgan Kaufmann, San Francisco. 4th ed.
176. Betawadkar-Norwood A., Lin E., Ursu I. Using Data Federation Technology in IBM WebSphere Information Integrator: Data Federation Design and Configuration.developerWorks 2005, part 1 of 2, June. http://www.128.ibm.com/developerworks/db2/library/techarticle/0203haas/0203haas.html.
177. Burks A.R., Burks A.W. The First Electronic Computer: The Atanasoff Story 1988, University of Michigan Press, Ann Arbor.
178. Burks A.R. Who Invented the Computer? The Legal Battle That Changed History 2003, Prometheus Books, Amherst, New York.
179. Ceri S., Pelagatti G. Distributed Databases: Principles and Systems 1984, McGraw-Hill, New York.
180. Ceri S., Pernici B., Wiederhold G. Distributed Database Design Methodologies. Proceedings of the IEEE 1987, 533-546. May.
181. Chu W.W. Optimal File Allocation in Multiple Computer System. IEEE Transactions on Computers 1969, 885-889. Oct.
182. Chu W.W. Distributed Data Bases. Handbook of Software Engineering 1984, Van Nostrand Reinhold, New York. C.R. Vick, C.V. Ramamoorthy (Eds.).
183. Fisher P., Hollist P., Slonim J. A Design Methodology for Distributed Databases. Proceedings of the IEEE Conference on Distributed Computing 1980, 199-202.
184. Haas L., Lin E. IBM Federated Database Technology. developerWorks 2002, Mar. http://www.128.ibm.com/developerworks/db2/library/techarticle/Dm.
185. Haas L., Lin E., Roth M. Data Integration through Database Federation. IBM Systems Journal 2002, 41(4):578-596.
186. Janakiraman J., Warack C., Bhal G., Teorey T.J. Progressive Fragment Allocation. Proceedings 10th International Conference on the Entity Relationship Approach 1991, 543-560.
187. Josifovski V., Schwarz P., Haas L., Lin E. Garlic: A New Flavor of Federated Query Processing for DB2. ACM SIGMOD Conference 2002, 524-532.
188. Ozsu T., Valduriez P. Principles of Distributed Database Systems 1999, Prentice-Hall, Englewood Cliffs, NJ. 2nd ed.
189. Acharya S., Gibbons P., Poosala V., Ramaswamy S. Join Synopses for Approximate Query Answering. Proceedings of 1999 SIGMOD 1999, 275-286. ACM Press, New York.
190. Adler R.M. Distributed Coordination Models for Client/Server Computing. Computer 1995, 28(4):14-22. April.
191. Agrawal S., Agrawal V., Yang B. Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design. Proceedings of ACM SIGMOD 2004.
192. Agrawal S., Chaudhuri S., Kollar L., Maranthe A., Narasayya V., Syamala M. Database Tuning Advisor for Microsoft SQL Server 2005. International Conference on Very Large Databases (VLDB) 2004, 1110-1121.
193. Agrawal S., Chaudhuri S., Narasayya V.R. Automated Selection of Materialized Views and Indexes in SQL Databases. International Conference on Very Large Databases (VLDB) 2000, 496-505.
194. Agrawal S., Gehrke J., Gunopulos D., Raghavan P. Automatic Subspace Clustering of High-dimensional Data for Data Mining Applications. Proceedings of ACM SIGMOD International Conference on Management of Data 1998, 94-105.
195. Ailamaki A., DeWitt D.J., Hill M.D., Skounakis M. Weaving Relations for Cache Performance. International Conference on Very Large Databases (VLDB) 2001, 169-180.
196. Ailamaki A., DeWitt D.J., Hill M.D., Wood D.A. DBMSs on a Modern Processor: Where Does Time Go?. VLDB 1999, 266-277.
197. Alhamed A., Lakshmivarahan S. A Clustering Approach to Multimodel Ensemble Analysis Using SAMEX Data: Preliminary Results. Proceedings of the 2000 ACM Symposium on Applied Computing 2000, 1:111-116.
198. Asami S., Talagala N., Patterson D.A. Designing a Self-maintaining Storage System. IEEE Symposium on Mass Storage Systems 1999, 222-233.
199. Baluja S., Caruana R. Removing the Genetics from the Standard Genetic Algorithm. Technical Report No. CMU-CS-95-141 1995, Carnegie Mellon University, Pittsburgh, PA.
200. Barucci E., Pinzani R., Sprug-noli R. Optimal Selection of Secondary Indexes. IEEE Trans. on Software Engineering 1990, 16(1):32-38. Jan.
201. Bayer R., McCreight E. Organization and Maintenance of Large Ordered Indexes. Acta. Inf. 1972, 1(3):173-189.
202. Bell G., Gray J. What's Next in High-performance Computing?. Commun. ACM 2002, 45(2):91-95.
203. Bernstein P., Brodie M., Ceri S., DeWitt D., Franklin M., Garcia-Molina H., Gray J., Held J., Hellerstein J., Jagadish H.V., Lesk M., Maier D., Naughton J., Pirahesh H.Stonebraker, M.Ullman J. The Asilomar Report on Database Research. SIGMOD Record 1998, 27(4). Dec. http://www.acm.org/sigs/sigmod/record/issues/9812/asilomar.html.
204. Betawadkar-Norwood A., Lin E., Ursu I. Using Data Federation Technology in IBM WebSphere Information Integrator: Data Federation Design and Configuration. developerWorks 2005, June.
205. Bhattacharjee B., Padmanabhan S., Malkemus T., Lai T., Cranston L., Huras M. Efficient Query Processing for Multi-Dimensionally Clustered Tables in DB2. International Conference on Very Large Databases (VLDB) 2003, 963-974.
206. Blasgen M.W., Astrahan M.M., Chamberlin D.D., Gray J., King W.F., Lindsay B.G., Lorie R.A., Mehl J.W., Price T.G., Putzolu G.R., Schkolnick M., Selinger P.G., Slutz D.R., Strong H.R., Traiger I.L., Wade B.W., Yost R.A. System R: An Architectural Overview. IBM Systems Journal 1999, 38(2/3):375-396.
207. BMC Index Advisor, at http://www.bmc.com.
208. Bornhövd C., Altinel M., Mohan C., Pirahesh H., Reinwald B. Adaptive Database Caching with DBCache. IEEE Data Eng. Bull. 2004, 27(2):11-18.
209. Brown K.P., Carey M.J., Livny M. Goal-Oriented Buffer Management Revisited. ACM SIGMOD 1996, 353-364.
210. Brown K., Carey M., Livny M. Managing Memory to Meet Multiclass Workload Response Time Goals. International Conference on Very Large Databases (VLDB) 1993, 328-341.
211. Brown K., Mehta M., Carey M., Livny M. Towards Automated Performance Tuning for Complex Workloads. International Conference on Very Large Databases (VLDB) 1994.
212. Bruno N., Chaudhuri S., Physical Design Refinement. The Merge-Reduce Approach, Proceedings of the 2006 EDBT Conference, Munich, 386-404.
213. Bruno N., Chaudhuri S. Automatic Physical Design Tuning: A Relaxation-based Approach. Proceedings of the ACM SIGMOD 2005.
214. Burks A.R. Who Invented the Computer? The Legal Battle That Changed History 2003, Prometheus Books, Amherst, New York.
215. Burks A.R., Burks A.W. The First Electronic Computer: The Atanasoff Story 1988, University of Michigan Press, Ann Arbor.
216. Burleson D.K. Physical Database Design Using Oracle 2004, Auerbach Publishers, Boca Raton, FL.
217. Callahan P.B., Kosaraju S.R. A Decomposition of Multidimensional Point Sets with Applications to k-nearest Neighbors and n-body Potential Fields. Journal of the ACM 1995, 42(1):67-90.
218. Capara A., Fischetti M., Maio D. Exact and Approximate Algorithms for the Index Selection Problem in Physical Database Design. IEEE Transactions on Knowledge and Data Engineering 1995, 7(6):955-967. Dec.
219. Ceri S., Negri M., Pelagatti G. Horizontal Data Partitioning in Database Design. Proceedings of ACM-SIGMOD International Conference on Management of Data 1982, 128-136.
220. Ceri S., Pelagatti G. Distributed Databases: Principles and Systems 1984, McGraw-Hill, New York.
221. Ceri S., Pernici B., Wiederhold G. Distributed Database Design Methodologies. Proceedings of the IEEE 1987, 533-546.
222. Chan T.F., Golub G.H., LeVeque R.J. Algorithms for Computing the Sample Variance: Analysis and Recommendation. Amer. Statist. 1983, 37:242-247.
223. Chaudhuri S., Christensen E., Graefe G., Narasayya V., Zwilling M. Self-Tuning Technology in Microsoft SQL Server. IEEE Data Engineering Bulletin 1999, 22(2):20-26. June.
224. Chaudhuri S., Dageville B., Lohman G.M. Self-managing Technology in Database Management Systems. International Conference on Very Large Databases (VLDB) 2004, 1243.
225. Chaudhuri S., Das G., Datar M., Motwani R., Narasayya V.R. Overcoming Limitations of Sampling for Aggregation Queries. Proceedings of the 17th International Conference of Data Engineering 2001, 534-542. IEEE Computer Society Press.
226. Chaudhuri S., Gupta A., Narasayya V. Workload Compression. Proceedings of ACM SIGMOD 2002.
227. Chaudhuri S., Motwani R., Narasayya V.R. On Random Sampling over Joins. Proceedings of 1999 SIGMOD 1999, 263-274. ACM Press, New York.
228. Chaudhuri S., Motwani R., Narasayya V.R. Random Sampling for Histogram Construction: How Much Is Enough?. SIGMOD Conference 1998, 436-447.
229. Chaudhuri S., Narasayya V. AutoAdmin What-if Index Analysis Utility. Proceedings of the 1998 ACM SIGMOD Conference 1998, 367-378.
230. Chaudhuri S., Narasayya V. Microsoft Index Tuning Wizard for SQL Server 7.0. Proceedings of the 1998 ACM SIGMOD Conference 1998, 553-554.
231. Chaudhuri S., Narasayya V. An Efficient Cost-driven Index Selection Tool for Microsoft SQL Server. VLDB 1997, 146-155.
232. Chaudhuri S., Narasayya V. Index Merging. Proceedings of 15th International Conference on Data Engineering 1999.
233. Chen J., DeWitt D.J., Naughton J.F. Design and Evaluation of Alternative Selection Placement Strategies in Optimizing Continuous Queries. ICDE 2002, 345-356.
234. Chen P.M., Lee E.K., Drapeau A.L., Lutz K., Miller E.L., Seshan S., Shirriff K., Patterson D.A., Katz R.H. Performance and Design Evaluation of the RAIDII Storage Server. Distributed and Parallel Databases 1994, 2:243-260.
235. Chen P.M., Patterson D.A. A New Approach to I/O Performance Evaluation-Self-scaling I/O Benchmarks, Predicted I/O Performance. ACM Trans. Comput. Syst. 1994, 12(4):308-339.
236. Cheng C.H., Fu A.W., Zhang Y. Entropy-based Subspace Clustering for Mining Numerical Data. Proceedings of the 5th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining 1999, 84-93.
237. Choenni S., Blanken H.M., Chang T. On the Selection of Secondary Indices in Relational Databases. Data & Knowledge Engineering 1993, 11(3):207-233.
238. Christensen R. Analysis of Variance, Design, and Regression: Applied Statistical Methods 1996, Chapman & Hall, New York.
239. Chu W.W. Distributed Database Systems. Software Engineering Handbook 1984, Chapter 14, New York. C.R. Vick, C.V. Ramamoorthy (Eds.).
240. Chu W.W. Optimal File Allocation in Multiple Computer System. IEEE Transaction on Computers 1969, 885-889. Oct.
241. Chung J., Ferguson D., Wang G., Nikolaou C., Teng J. Goal-oriented Dynamic Buffer Pool Management for Data Base Systems. IEEE ICECCS 1995, 191-198.
242. Clark J., Downing D.A. Forgotten Statistics: A Self-teaching Refresher Course 1996, Hauppauge, NY, Barrons Educational Series, ISBN.
243. Cochran W.G. Sampling Techinques 1977, John Wiley, New York. 3rd ed.
244. Codd E.F. The Relational Model for Database Management 1990, Addison-Wesley, Reading, MA. 2nd ed.
245. Codd E.F. A Relational Model of Data for Large Shared Data Banks (Reprint). Commun. ACM 1983, 26(1):64-69.
246. Codd E.F. Extending the Data Base Relational Model to Capture More Meaning (Abstract). SIGMOD Conference 1979, 161.
247. Codd E.F. A Relational Model of Data for Large Shared Data Banks. Commun. ACM 1970, 13(6):377-387.
248. Dageville B., Das D., Dias K., Yagoub K., Zaït M., Ziauddin M. Automatic SQL Tuning in Oracle 10g. VLDB 2004, 1098-1109.
249. Dageville B., Zaït M. SQL Memory Management in Oracle9i. VLDB 2002, 962-973.
250. Date C.J. An Introduction to Database Systems 2003, vol. 1. Addison-Wesley, Boston. 8th ed.
251. Date C.J. Defining Data Types in a Database Language-A Proposal for Adding Date and Time Support to SQL. SIGMOD Record 1988, 17(2):53-76.
252. Date C.J. A Critique of the SQL Database Language. SIGMOD Record 1984, 14(3):8-54.
253. Date C.J. Database Usability (Abstract). SIGMOD Conference 1983, 1.
254. Date C.J. Referential Integrity. VLDB 1981, 2-12.
255. Davison D., Graefe G. Memory Contention Responsive Hash Join. VLDB 1994.
256. DB2 Database, at http://www-306.ibm.com/software/data/db2/udb/.
257. DB2 UDB: The Autonomic Computing Advantage, at http://www.db2mag.com/epub/ autonomic/.
258. Deigin Y. DB2 UDB Query Execution Plans: Up Close and Personal. DB2 Information Management Technical Conference AGENDA 2005.
259. Devroye L. Non-Uniform Random Variate Generation 1986, Springer-Verlag, New York.
260. DeWitt D.J., Gray J. Parallel Database Systems: The Future of High-Performance Database Systems. Commun. ACM 1992, 35(6):85-98.
261. DeWitt D.J., Naughton J.F., Schneider D.A., Seshadri S. Practical Skew Handling in Parallel Joins. International Conference on Very Large Databases (VLDB) 1992, 27-40.
262. Diao Y., Hellerstein J.L., Storm A.J., Surendra M., Lightstone S., Parekh S.S., Garcia-Arellano C. Incorporating Cost of Control into the Design of a Load Balancing Controller. IEEE Real-Time and Embedded Technology and Applications Symposium 2004, 376-387.
263. Diao Y., Hellerstein J.L., Storm A.J., Surendra M., Lightstone S., Parekh S.S., Garcia-Arellano C. Using MIMO Linear Control for Load Balancing in Computing Systems. American Control Conference 2004.
264. Diao Y., Wu C.W., Hellerstein J.L., Storm A.J., Surendra M., Lightstone S., Parekh S.S., Garcia-Arellano C., Carroll M., Chu L., Colaco J. Comparative Studies of Load Balancing with Control and Optimization Techniques. 24th American Control Conference (ACC) 2005.
265. Dias K., Ramacher M., Shaft U., Venkataramani V., Wood G. Automatic Performance Diagnosis and Tuning in Oracle. CIDR 2005.
266. Dickman A. Two-Tier versus Three-Tier Apps. InformationWeek 1995, 553:74-80. Nov. 13.
267. Dröge G., Schek H.J. Query-Adaptive Data Space Partitioning Using Variable-Size Storage Clusters. SSD 1993, 337-356.
268. Edelstein H. Unraveling Client/Server Architecture. DBMS 1994, 7(5):34. May, (7).
269. Elmasri R., Navathe S.B. Fundamentals of Database Systems 2004, Addison-Wesley, Boston. 4th ed.
270. Epter S., Krishnamoorthy M. A Multiple-resolution Method for Edge-centric Data Clustering. Proceedings of the 8th International Conference on Information Knowledge Management 1999, 491-498.
271. Falkowski B.J. Comments on an Optimal Set of Indices for a Relational Database. IEEE Trans. on Software Engineering 1992, 18(2):168-171. Feb.
272. Ferhatosmanoglu H., Agrawal D., El Abbadi A. Clustering Declustered Data for Efficient Retrieval. Proceedings of the 8th International Conference on Information Knowledge Management 1999, 343-350.
273. Finkelstein S., Schkolnick M., Tiberio P. Physical Database Design for Relational Databases. ACM Transactions on Database Systems 1988, 13(1):91-128. Mar.
274. Fisher P., Hollist P., Slonim J. A Design Methodology for Distributed Databases. Proceedings of the IEEE Conference on Distributed Computing 1980, 199-202.
275. Flajolet P., Martin G.N. Probabilistic Counting Algorithms for Database Applications. Journal of Computer and System Sciences 1985, 31:182-209.
276. Frank M.R., Omiecinski E.R., Navathe S.B. Adaptive and Automated Index Selection in RDBMS. International Conference on Extending Database Technology (EDBT) 1992, 277-292.
277. Fushimi S., Kitsuregawa M., Nakayama M., Tanaka H., Moto-oka T. Algorithm and Performance Evaluation of Adaptive Multidimensional Clustering Technique. Proceedings of the 1985 International Conference on Management of Data 1985, 308-318.
278. Gallaugher J., Ramanathan S. Choosing a Client/Server Architecture. A Comparison of Two-Tier and Three-Tier Systems. Information Systems Management Magazine 1996, 13(2):7-13. Spring.
279. Ganguly S., Gibbons P.B., Matias Y., Silberschatz A. Bifocal Sampling for Skewresistant Join Size Estimation. Proceedings of the 1996 SIGMOD 1996, 271-281. ACM Press, New York.
280. Ganti V., Gehrke J., Ramakrishnan R. CACTUS-Clustering Categorical Data Using Summaries. Proceedings of the 5th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining 1999, 73-83.
281. Garcia-Arellano C.M., Lightstone S., Lohman G., Markl V., Storm A. Autonomic Features of the IBM DB2 Universal Database for Linux, UNIX, and Windows. IEEE Transactions on Systems, Man, and Cybernetics: Special Issue on Engineering Autonomic Systems 2006.
282. Garcia-Arellano C.M., Lightstone S., Storm A. A Self-managing Relational Database Server: Examples from IBM's DB2 Universal Database for Linux, Unix, and Windows. IEEE Transactions on Systems, Man, and Cybernetics: Special Issue on Engineering Autonomic Systems 2005.
283. Garcia-Molina H., Polyzois C.A. Issues in Disaster Recovery. COMPCON 1990, 573-577.
284. Garcia-Molina H., Ullman J., Widom J. Database Systems: The Complete Book 2001, Prentice-Hall, Englewood Cliffs, NJ.
285. Gibson G.A., Hellerstein L., Karp R.M., Katz R.H., Patterson D.A. Failure Correction Techniques for Large Disk Arrays. ASPLOS 1989, 123-132.
286. Goldstein J., Larson P. Optimizing Queries Using Materialized Views: A Practical, Scalable Solution. Proceedings of the ACM SIGMOD International Conference on Management of Data 2001.
287. Gonick L., Smith W. The Cartoon Guide to Statistics 1994, HarperCollins, New York.
288. Gray J. A "Measure of Transaction Processing" 20 Years Later. IEEE Data Eng. Bull. 2005, 28(2):3-4.
289. Gray J. Distributed Computing Economics CoRR cs.NI/0403019 2004.
290. Gray J. The Next Database Revolution. SIGMOD Conference 2004, 1-4.
291. Gray J. The Revolution in Database System Architecture. ADBIS (Local Proceedings) 2004.
292. Gray J. Where the Rubber Meets the Sky: The Semantic Gap between Data Producers and Data Consumers. SSDBM 2004, 3.
293. Gray J. Review-Benchmarking Database Systems: A Systematic Approach. ACM SIGMOD Digital Review 1999, 1. http://www.informatik.unitrier.de/ley/db/indices/a.
294. Gray J. Super Servers: Commodity Computer Clusters Pose a Software Challenge. BTW 1995, 30-47.
295. Gray J., Shenoy P.J. Rules of Thumb in Data Engineering. ICDE 2000, 3-12.
296. Gray P., Watson H.J. Decision Support in the Data Warehouse 1998, Prentice-Hall, Englewood Cliffs, NJ.
297. Grosshans D. File Systems Design and Implementation 1986, Prentice-Hall, Englewood Cliffs, NJ.
298. Gupta H., Harinarayan V., Rajaraman A., Ullman J.D. Index Selection for OLAP. Proceedings of the International Conference on Data Engineering 1997, 208-219.
299. Haas L., Lin E. IBM Federated Database Technology. developerWorks 2002, 1-11. http://www.128.ibm.com/developerworks/db2/library/techarticle/0203haas/0203haas.html.
300. Haas L., Lin E., Roth M. Data Integration through Database Federation. IBM Systems Journal 2002, 41(4):578-596.
301. Haas P.J. The Need for Speed: Speeding Up DB2 Using Sampling. IDUG Solutions Journal 2003, 10:32-34.
302. Haas P.J., Hellerstein J.M. Ripple Joins for Online Aggregation. Proceedings of the 1999 SIGMOD 1999, 287-298. ACM Press, New York.
303. Haas P.J., Knig C. A Bi-level Bernoulli Scheme for Database Sampling. Proceedings of the 2004 SIGMOD 2004, 275-286. ACM Press, New York.
304. Haas P.J., Naughton J.F., Seshadri S., Stokes L. Sampling-based Estimation of the Number of Distinct Values of an Attribute. International Conference on Very Large Databases 1995.
305. Haas P.J., Naughton J.F., Seshadri S., Swami A.N. Selectivity and Cost Estimation for Joins Based on Random Sampling. J. Comput. Sys. Sci. 1996, 52:550-569.
306. Haas P.J., Naughton J.F., Swami A.N. On the Relative Cost of Sampling for Join Selectivity Estimation. PODS 1994, 14-24.
307. Haas P.J., Stokes L. Estimating the Number of Classes in a Finite Population. Journal of the American Statistical Association (JASA) 1998, 93:1475-1487. Dec.
308. Harbron T.R. File Systems Structures and Algorithms 1988, Prentice-Hall, Englewood Cliffs, NJ.
309. Harinarayan V., Rajaraman A., Ullman J.D. Implementing Data Cubes Efficiently. Proceedings of the 1996 ACM-SIGMOD Conference 1996, 205-216.
310. Harinath S., Quinn S. SQL Server Analysis Services 2005 with MDX 2006, John Wiley, New York.
311. Hellerstein J.L., Diao Y., Parekh S., Tilbury D.M. Feedback Control of Computing Systems 2004, John Wiley, New York.
312. Hellerstein J.M., Haas P.J., Wang H.J. Online Aggregation. Proceedings of the 1997 SIGMOD 1997, 171-182. ACM Press, New York.
313. Hennessy J.L., Patterson D.A. Computer Architecture: A Quantitative Approach 1996, Morgan Kaufmann, San Francisco. 2nd ed.
314. Hester P. Technology Analyst Day 2006, June 1, AMD. http://www.amd.com/usen/Corporate/InvestorRelations/0,,51_306_14047,00.html.
315. Hindshaw F., Metzger J., Zane B. Optimized Database Appliance 2006, Patent No. U.S. 7,010,521 B2, issued March 7, Netezza Corporation, Framingham, MA, Assignee.
316. Hoffer J.A., Prescott M.B., McFadden F.R. Modern Database Management 2007, Prentice-Hall, Englewood Cliffs, NJ. 8th ed.
317. Holland J.H. Adaptation in Natural and Artificial Systems 1975, University of Michigan Press, Ann Arbor.
318. Hou W., Ozsoyoglu G., Taneja B. Statistical Estimators for Relational Algebra Expressions. Proceedings of the 7th ACM SIGACT-SIGMOD-SIGART Symposium. Principles of Database Systems 1988, 276-287. ACM Press, New York.
319. Hu Q., Lee W., Lee D. Indexing Techniques for Wireless Data Broadcast under Data Clustering and Scheduling. Proceedings of the 8th International Conference on Information Knowledge Management 1999, 351-358.
320. Hua K., Lang S., Lee W. A Decomposition-based Simulated Annealing Technique for Data Clustering. Proceedings of the 13th ACM SIGACT-SIGMODSIGART Symposium on Principles of Database Systems 1994, 117-128.
321. Hubel M. A Simple Approach to DB2 Index Redesign. IDUG Solutions Journal 2001, 8(3).
322. IBM Data Warehousing, Analysis, and Discovery-Overview-IBM Software, at http:/ /www.306.ibm.com/software/data/db2bi/.
323. Ioannidis Y.E., Poosala V. USA Balancing Histogram Optimality and Practicality for Query Result Size Estimation. Proceedings of the 1995 ACM SIGMOD International Conference on Management of Data 1995, 233-244.
324. Ip M.Y.L., Saxton L.V., Raghavan V.V. On the Selection of an Optimal Set of Indexes. IEEE Transactions on Software Engineering 1983, 9(2):135-143. Mar.
325. SQL 2003. ISO/IEC 9075-2:2003, Information Technology-Database Languages -SQL: Part 2: Foundation (SQL/Foundation). See http://www.iso.org/iso/ en/CatalogueDetailPage.CatalogueDetail?CSNUMBER=34133.
326. Jagadish H.V., Lakshmanan L.V.S., Srivastava D. Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse. Proceedings of the 1999 International Conference on Management of Data 1999, 37-48.
327. Jain A.K., Murty M.N., Flynn P.J. Data Clustering: A Review. ACM Computing Survey 1999, 31(3):264-323. Sept.
328. Jaisingh L.R. Statistics for the Utterly Confused 2000, McGraw-Hill, New York.
329. Janakiraman J., Warack C., Bhal G., Teorey T.J. Progressive Fragment Allocation. Proceedings of the 10th International Conference on the Entity Relationship Approach 1991, 543-560.
330. Keim D.A., Hinneburg A. Clustering Techniques for Large Data Sets-From the Past to the Future. Tutorial Notes for ACM SIGKDD 1999 International Conference on Knowledge Discovery and Data Mining 1999, 141-181.
331. Kimball R., Caserta J. The Data Warehouse ETL Toolkit 2004, John Wiley, New York.
332. Kimball R., Reeves L., Ross M., Thornthwaite W. The Data Warehouse Life Cycle Toolkit 1998, John Wiley, New York. 2nd ed.
333. Kimball R., Ross M. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling 2002, John Wiley, New York. 2nd ed.
334. Kolovson C.P., Stonebraker M. Indexing Techniques for Historical Databases. ICDE 1989, 127-137.
335. König A., Nabar S. Scalable Exploration of Physical Database Design. Proceedings of 22th International Conference on Data Engineering 2006.
336. Koopman J. Introduction to Oracle 10g's New SQL Tuning Advisor. Database Journal 2004, July 29.
337. Kotidis Y., Roussopoulos N. DynaMat: A Dynamic View Management System for Data Warehouses. ACM SIGMOD Conference 1999, 371-382.
338. Kurzweil R. The Age of Spiritual Machines 1999, Penguinbooks, New York.
339. Kwan E., Lightstone S., Schiefer B., Storm A., Wu L. 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, Feb. 26-28, University of Leipzig, Germany.
340. Larsen R.P. Rules-based Object Clustering: A Data Structure for Symbolic VLSI Synthesis and Analysis. Proceedings of the 23rd ACM/IEEE Conference on Design Automation 1986, 768-777.
341. Larson P., Graefe G. Memory Management during Run Generation in External Sorting. SIGMOD 1998.
342. Lee J.H., Kim D.H., Chung C.W. Multidimensional Selectivity Estimation Using Compressed Histogram Information. Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data 1999, 205-214.
343. Lehner W., Cochrane R., Pirahesh H., Zaharioudakis M. Fast Refresh Using Mass Query Optimization. ICDE 2001, 391-398.
344. Li W.S., Zilio D.C., Batra V.S., Subramanian M., Zuzarte C., Narang I. Load Balancing for Multi-tiered Database Systems through Autonomic Placement of Materialized Views. ICDE 2006, 102.
345. Lightstone S., Bhattacharjee B. Automating the Design of Multi-dimensional Clustering Tables in Relational Databases. Proceedings of VLDB 2004.
346. Lightstone S., Hellerstein J., Tetzlaff W., Janson P., Lassettre E., Norton C., Rajaraman B., Spainhower L. Towards Benchmarking Autonomic Computing Maturity. IEEE Workshop on Autonomic Computing Principles and Architectures (AUCOPA) 2003.
347. Lightstone S., Lohman G., Zilio D. Toward Autonomic Computing with DB2 Universal Database. SIGMOD Record 2002, 31(3):55-61.
348. Lightstone S., Schiefer B., Zilio D., Kleewein J. Autonomic Computing for Relational Databases: The Ten-year Vision. IEEE Workshop on Autonomic Computing Principles and Architectures (AUCOPA) 2003.
349. Lightstone S., Storm A., Garcia-Arellano C., Carroll M., Colaco J., Diao Y., Surendra M. Self-tuning Memory Management in a Relational Database System. Fourth Annual Workshop on Systems and Storage Technology 2005, IBM Research Lab, Haifa University, Mount Carmel, Haifa, Israel.
350. Lindgren B.W. Statistical Theory 1976, MacMillan, New York. 3rd ed.
351. Liou J.H., Yao S.B. Multi-dimensional Clustering for Database Organizations. Information Systems 1977, 2:187-198.
352. Lohman G., Valentin G., Zilio D., Zuliani M., Skelly A. DB2 Advisor: An Optimizer Smart Enough to Recommend Its Own Indexes. Proceedings of the 16th IEEE Conference on Data Engineering 2000.
353. Manku G.S., Rajagopalan S., Lindsay B.G. Random Sampling Techniques for Space Efficient Online Computation of Order Statistics of Large Datasets. SIGMOD Conference 1999, 251-262.
354. Markl V., Popivanov I., Lightstone S., Raman V., Aboulnaga A., Haas P., Lohman G. Automated Statistics Collection in DB2 Stinger. Proceedings of VLDB 2004.
355. Markl V., Ramsak F., Bayer R. Improving OLAP Performance by Multi-dimensional Hierarchical Clustering. Proceedings of IDEAS '99 1999.
356. Martin P., Li H., Zheng M., Romanufa K., Powley W. Dynamic Reconfiguration Algorithm: Dynamically Tuning Multiple Buffer Pools. DEXA 2000, 92-101.
357. McCallum A., Nigam K., Ungar L.H. Efficient Clustering of High-dimensional Data Sets with Application to Reference Matching. Proceedings of the 6th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining 2000, 169-178.
358. Mehta M., DeWitt D.J. Data Placement in Shared-nothing Parallel Database Systems. VLDB 1997, 6(1):53-72.
359. Mehta M., DeWitt D.J. Managing Intra-operator Parallelism in Parallel Database Systems. VLDB 1995, 382-394.
360. Mehta M., DeWitt D. Dynamic Memory Allocation for Multiple-Query Workloads. International Conference on Very Large Databases (VLDB) 1993.
361. Microsoft SQL Server Home, at http://www.microsoft.com/sql/default.mspx.
362. Microsoft SQL Server: Business Intelligence Solutions, at http://www.microsoft.com/ sql/solutions/bi/default.mspx.
363. Miller R.G. Beyond ANOVA, Basics of Applied Statistics 1986, John Wiley, New York.
364. Mitchell M. An Introduction to Genetic Algorithms 1996, MIT Press, Cambridge, MA.
365. Moravec H. Mind Children: The Future of Robot and Human Intelligence 1988, Harvard University Press, Boston.
366. Nadeau T.P., Teorey T.J. A Pareto Model for OLAP View Size Estimation. Information Systems Frontiers 2003, 5(2):137-147.
367. Nadeau T.P., Teorey T.J. Achieving Scalability in OLAP Materialized View Selection. Proceedings of DOLAP '02 2002, 28-34.
368. Nag B., DeWitt D.J. Memory Allocation Strategies for Complex Decision Support Queries. CIKM 1998, 116-123.
369. Netezza Corporation, at www.netezza.com.
370. Nievergelt J., Hinterberger H., Sevcik K.C. The Grid File: An Adaptable, Symmetric Multikey File Structure. ACM Transactions on Database Systems (TODS) 1984, 9(1):38-71. Jan.
371. O'Neil P., Graefe G. Multi-table Joins through Bitmapped Join Indices. SIGMOD Record 1995, 24(3):8-11. Sept.
372. O'Neil P., O'Neil E. Database: Principles, Programming, and Performance 2001, Morgan Kaufmann, San Francisco. 2nd ed.
373. Olken F. Random Sampling from Databases. Ph.D. Dissertation 1993, University of California, Berkeley.
374. Oracle Business Intelligence Solutions, at http://www.oracle.com/solutions/business_intelligence/index.html.
375. Oracle Database, at http://www.oracle.com/database/index.html. Oracle 9i Memory Management, at http://www.oracle.com/technology/products/oracle9i/daily/apr15.
376. Oracle-SQL Tuning Advisor, at http://www.oracle-base.com/articles/10g/AutomaticSQLTuning10g.php.
377. Ozsu M.T., Valduriez P. Principles of Distributed Database Systems 1991, Prentice-Hall, Englewood Cliffs, NJ.
378. Padmanabhan S., Bhattacharjee B., Malkemus T., Cranston L., Huras M. Multidimensional Clustering: A New Data Layout Scheme in DB2. ACM SIGMOD/ PODS 2003 Conference 2003, 637-641.
379. Palmer C.R., Faloutsos C. Density-biased Sampling: An Improved Method for Data Mining and Clustering. Proceedings of the 2000 ACM SIGMOD on Management of Data 2000, 82-92.
380. Pang H., Carey M., Livny M. Partially Preemptible Hash Joins. SIGMOD 1993.
381. Patent Full-text and Full-page Image Databases, at www.uspto.gov/patft/index.html.
382. Patterson D.A. Latency Lags Bandwidth. ICCD 2005, 3-6.
383. Patterson D.A. Latency Lags Bandwith. Commun. ACM 2004, 47(10):71-75.
384. Patterson D.A. Hardware Technology Trends and Database Opportunities, SIGMOD Conference 1998 Keynote Speech. Video ACM SIGMOD Digital Symposium Collection 1999, 1. 2.
385. Patterson D.A. Terabytes-Teraflops or Why Work on Processors When I/O Is Where the Action Is? (Abstract.). ACM Conference on Computer Science 1994, 410.
386. Patterson D.A., Gibson G.A., Katz R.A. A Case for Redundant Arrays of Inexpensive Disks (RAID). SIGMOD Conference 1988, 109-116.
387. Pendse, N., Creeth, R., "The OLAP Report," http://www.olapreport.com/.
388. Powell G. Oracle Data Warehouse Tuning for 10g 2005, Elsevier, Boston.
389. Pruscino A. Oracle RAC: Architecture and Performance. SIGMOD Conference 2003, 635.
390. Ramakrishnan R., Gehrke J. Database Management Systems 2003, McGraw-Hill, New York. 3rd ed.
391. Rao J., Lightstone S., Lohman G., Zilio D., Storm A., Garcia-Arellano C., Fadden S. DB2 Design Advisor: Integrated Automated Physical Database Design. International Conference on Very Large Databases (VLDB) 2004.
392. Rao J., Zhang C., Megiddo N., Lohman G. Automating Physical Database Design in a Parallel Database. Proceedings of the 2002 ACM SIGMOD/PODS Conference 2002, 558-569.
393. Rees, S. Index Design for Performance. IDUG 2004-North America.
394. Rodgers U. Denormalization: Why, What, and How?. Database Programming and Design 1989, 2(12):46-53. Dec.
395. Roussopoulos N. View Indexing in Relational Databases. ACM Trans Database Systems 1982, 7(2):258-290.
396. Rudin K. Scalable Systems Architecture: Scalable I/O, Part I: Disk Striping. DM Review Magazine 1998, 1-3. May.
397. Runapongsa K., Nadeau T.P., Teorey T.J. Storage Estimation for Multidimensional Aggregates in OLAP. Proceedings of the 10th CASCON Conference 1999, 40-54.
398. Runkler T.A., Glesner M. Multidimensional Defuzzification-Fast Algorithms for the Determination of Crisp Characteristic Subsets. Proceedings of the 1995 ACM Symposium on Applied Computing 1995, 575-579.
399. Sarndal C.-E., Swensson B., Wretman J. Model Assisted Survey Sampling 1992, Springer-Verlag, New York.
400. Schiefer B., Valentin G. DB2 Universal Database Performance Tuning. IEEE Data Engineering Bulletin 1999, 22(2):12-19. June.
401. Schkolnick M., Sorenson P. Denormalization: A Performance-Oriented Database Design Technique. Proceedings of AICA 1980 Congress, Bologna, Italy 1980, 363-377. AICA, Brussels.
402. Schulze M., Gibson G.A., Katz R.A., Patterson D.A. How Reliable Is a RAID?. COMPCON 1989, 118-123.
403. Schussel G. Client/Server Past, Present, and Future 1995, http://www.dciexpo.com/geos/.
404. The Self-managing Database: Automatic SGA Memory Management. Oracle White Paper 2003, http://www.oracle.com/technology/products/manageability/database/pdf/twp03/TWP_manage_self_managing_database.pdf.
405. Selinger P.G., Astrahan M.M., Chamberlin D.D., Lorie R.A., Price T.G. Access Path Selection in a Relational Database Management System. ACM SIGMOD Conference 1979, 23-34.
406. Shasha D., Bonnet P. Database Tuning: Principles, Experiments, and Troubleshooting Techniques 2003, Morgan Kaufmann, San Francisco.
407. Sheikholeslami G., Chang W., Zhang A. Semantic Clustering and Querying on Heterogeneous Features for Visual Data. Proceedings of the 6th ACM International Conference on Multimedia 1998, 3-12.
408. Shekhar S., Chawla S. Spatial Databases 2003, Prentice-Hall, Englewood Cliffs, NJ.
409. Shelton R.E. The Distributed Enterprise (Shared, Reusable Business Models the Next Step in Distributed Object Computing. Distributed Computing Monitor 1993, 8(10). Oct.
410. Shukla A., Deshpande P., Naughton J., Ramasamy K. Storage Estimation for Multidimensional Aggregates in the Presence of Hierarchies. International Conference on Very Large Databases 1996.
411. Silberschatz A., Galvin P., Gagne G. Operating System Concepts 2002, John Wiley, New York. 6th ed.
412. Silberschatz A., Korth H.F., Sudarshan S. Database System Concepts 2006, McGraw-Hill, New York. 5th ed.
413. Sinnwell M., Konig A.C. Managing Distributed Memory to Meet Multiclass Workload Response Time Goals. ICDE 1995, 87-94.
414. Sipper, M. A Brief Introduction to Genetic Algorithms, at http://lslwww.epfl.ch/Rmoshes/ga.html.
415. Son E.J., Kang I.S., Kim T.W., Li K.J. A Spatial Data Mining Method by Clustering Analysis. Proceedings of the 6th International Symposium on Advances in Geographic Information Systems 1998, 157-158.
416. Special Issue on Heterogeneous Databases. ACM Computing Surveys 1990, 22(3):173-293. Sept.
417. SQL Server Architecture: Memory Architecture, at http://msdn.microsoft.com/library/ default.asp?url=/library/en-us/architec/8_ar_sa_4rc5.asp.
418. Stohr T., Martens H., Rahm E. Multidimensional Aware Database Allocation for Parallel Data Warehouses. Proceedings of VLDB 2000.
419. Stonebraker M. Outrageous Ideas and/or Thoughts While Shaving. ICDE 2004, 869-870.
420. Stonebraker M. Too Much Middleware. SIGMOD Record 2002, 31(1):97-106.
421. Stonebraker M., Sellis T.K., Hanson E.N. An Analysis of Rule Indexing Implementations in Data Base Systems. Expert Database Conference 1986, 465-476.
422. Storm A.J., Garcia-Arellano C.M., Lightstone S., Diao Y., Surendra M. Adaptive Self-tuning Memory in DB2 UDB. International Conference on Very Large Databases (VLDB) 2006.
423. Sun J., Grosky W.I. Dynamic Maintenance of Multidimensional Range Data Partitioning for Parallel Data Processing. Proceeding of the ACM First International Workshop on Data Warehousing and OLAP 1998, 72-79.
424. Szalay A.S., Gray J., vandenBerg J. Petabyte Scale Data Mining: Dream or Reality? 2002, CoRR cs.DB/0208013.
425. Telford R., Horman R., Lightstone S., Markov N., O'Connell S., Lohman G. Usability and Design Considerations for an Autonomic Relational Database Management System. IBM Systems Journal 2003, 42(4):568-581.
426. Teorey T.J. Distributed Database Design: A Practical Approach and Example. SIGMOD Record 1989, 18(4):23-39. Dec.
427. Teorey T., Fry J. Design of Database Structures 1982, Prentice-Hall, Englewood Cliffs, NJ.
428. Teorey T., Lightstone S., Nadeau T. Database Modeling and Design: Logical Design 2006, Morgan Kaufmann, San Francisco. 4th ed.
429. Thompson M.E. Theory of Sample Surveys 1997, Chapman & Hall.
430. Thomsen E. OLAP Solutions 1997, John Wiley, New York.
431. Tian W., Powley W., Martin P. Techniques for Automatically Sizing Multiple Buffer Pools in DB2. CASCON 2003.
432. Transaction Processing Performance Council, at http://www.tpc.org.
433. Uchiyama H., Runapongra K., Teorey T. Progressive View Materialization Algorithm. DOLAP 1999, 36-41.
434. Valentin G., Zuliani M., Zilio D., Lohman G. DB2 Advisor: An Optimizer That Is Smart Enough to Recommend Its Own Indexes. Proceedings of ICDE 2000.
435. Wan S.J., Wong S.K.M., Prusinkiewicz P. An Algorithm for Multidimensional Data Clustering. ACM Transactions on Mathematical Software 1988, 14(2):153-162. June.
436. Wang J.T.L., Wang X., Lin K.I., Shasha D., Shapiro B.A., Zhang K. Evaluating a Class of Distance-mapping Algorithms for Data Mining and Clustering. Proceedings of the 5th ACM SIGKDD International Conference on Knowledge Discovery and Data Mining 1999, 307-311.
437. Weikum G., Hasse C. Moenkeberg, A., and Zabback, P. The COMFORT Automatic Tuning Project. Information Systems 1994, 19(5):381-432.
438. Whang K.Y. Index Selection in Relational Databases. Proceedings of the International Conference on Foundations on Data Organization (FODO) 1985, 369-378. Reprinted in.
439. Foundations of Data Organization 1987, 487-500. Plenum Press, Tokyo, Japan. S.P. Ghosh, Y. Kambayashi, K. Tanaka (Eds.).
440. Wiederhold G. File Organization for Database Design 1987, McGraw-Hill, New York.
441. Zaman K.A., Padmananbhan S. An Efficient Workload-based Data Layout Scheme for Multidimensional Data. IBM Technical Report 2000, July.
442. Zhang T., Ramakrishnan R., Livny M. BIRCH: An Efficient Data Clustering Method for Very Large Databases. Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data 1996, 103-114.
443. Zhang W., Larson P. Dynamic Memory Adjustment for External Merge Sort. VLDB 1997.
444. Zikopoulos, P. C., and Eaton, C. Availability with Clicks of a Button Using DB2's HADR, at http://www.dbazine.com/db2/db2-disarticles/zikopouloZikopoulos,9.
445. Zilio D.C. Physical Database Design Decision Algorithms and Concurrent Reorganization for Parallel Database Systems. Ph.D. Thesis 1998, University of Toronto, Toronto, Canada.
446. Zilio D., Lightstone S., Lohman G. Trends in Automated Database Design. IEEE Workshop on Autonomic Computing Principles and Architectures (AUCOPA) 2003.
447. Zilio D., Lohman G., Zuzarte C., Ma W., Lightstone S., Cochrane B., Pirahesh H. Recommending Materialized Views and Indexes by IBM's DB2 Design Advisor. International Conference on Autonomic Computing (ICAC) 2004, May 17-18.
448. Zilio D.C., Rao J., Lightstone S., Lohman G.M., Storm A.J., Garcia-Arellano C., Fadden S. DB2 Design Advisor: Integrated Automatic Physical Database Design. International Conference on Very Large Databases (VLDB) 2004, 1087-1097.
449. Zilio D.C., Lightstone S., Lohman G. Trends in Automating Physical Database Design". Proceedings IEEE International Conference on Industrial Informatics 2003, 441-445. INDIN, 21-24 Aug.