New Challenges in Physical Database Design - Automated Physical Database Design and Tuning - page 234

estimating their sizes, 2 , 9 and automated layout of database objects. 1 , 11 Bruno
and Chaudhuri 4 discuss some ideas on interactive physical design sessions and
comment on the architecture that we discussed in this chapter, including the
use of Windows PowerShell 7 , 12 as the scripting engine. 6 Some recent work
discusses challenges and pitfalls in benchmarking physical design tools. 3 , 5 , 13
References
1. Sanjay Agrawal, Surajit Chaudhuri, Abhinandan Das, and Vivek
Narasayya. Automating layout of relational databases. In Proceedings
of the International Conference on Data Engineering (ICDE) , 2003.
2. Bishwaranjan Bhattacharjee, Lipyeow Lim, Timothy Malkemus, George
Mihaila, Kenneth Ross, Sherman Lau, Cathy McArthur, Zoltan Toth,
and Reza Sherkat. Ecient index compression in DB2 LUW. In Proceed-
ings of the International Conference on Very Large Databases (VLDB) ,
2(2), 2009.
3. Nicolas Bruno. A critical look at the TAB benchmark for physical design
tools. SIGMOD Record , 36(4), 2007.
4. Nicolas Bruno and Surajit Chaudhuri. Interactive physical design tun-
ing. In Proceedings of the International Conference on Data Engineering
(ICDE) , 2010.
5. Mariano P. Consens, Denilson Barbosa, Adrian M. Teisanu, and Laurent
Mignet. Goals and benchmarks for autonomic configuration recom-
menders. In Proceedings of the ACM International Conference on Man-
agement of Data (SIGMOD) , 2005.
6. Microsoft Corporation. Interactive physical design tuner, 2010. Acces-
sible at http://research.microsoft.com/en-us/downloads/f97b957c-38fb-
445a-ba9e-7ebde5f2e0cf.
7. Microsoft Corporation. Scripting with Windows PowerShell, 2006. Ac-
cessible at http://technet.microsoft.com/en-us/scriptcenter/dd742419.
aspx.
8. Microsoft Corporation. Transact-SQL reference, 2008. Accessible at
http://msdn.microsoft.com/en-us/library/ms189826(SQL.90).aspx.
9. Stratos Idreos, Raghav Kaushik, Vivek Narasayya, and Ravishankar
Ramamurthy. Estimating the compression fraction of an index using
sampling. In Proceedings of the International Conference on Data En-
gineering (ICDE) , 2010.