Query optimization in microsoft SQL server PDW

Proceedings of the ACM SIGMOD International Conference on Management of Data

Volumn , Issue , 2012, Pages 767-775

  Shankar, Srinath ^a   Nehme, Rimma ^a   Aguilar Saborit, Josep ^a   Chung, Andrew ^a   Elhemali, Mostafa ^a   Halverson, Alan ^a   Robinson, Eric ^a   Subramanian, Mahadevan Sankara ^a   DeWitt, David ^a   Galindo Legaria, César ^a  

^a MICROSOFT   (United States)

Author keywords

query optimization

Indexed keywords

CARDINALITY ESTIMATIONS; COST MODELS; DISTRIBUTED EXECUTION; DISTRIBUTED QUERY EXECUTION; DISTRIBUTED QUERY PROCESSING; HIGH QUALITY; MASSIVELY PARALLEL PROCESSORS; MICROSOFT SQL SERVER; OPTIMIZERS; PERFORMANCE IMPROVEMENTS; QUERY OPTIMIZATION; QUERY OPTIMIZER; SPACE EXPLORATIONS; SQL SERVERS;

DATA WAREHOUSES; METADATA; SPACE RESEARCH;

OPTIMIZATION;

EID: 84862673165     PISSN: 07308078     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/2213836.2213953     Document Type: Conference Paper

References (10)

1. Aster Data. http://www.asterdata.com/.
2. Greenplum. http://www.greenplum.com/.
3. M. M. Astrahan, M. W. Blasgen, D. D. Chamberlin, K. P. Eswaran, J. Gray, P. P. Griffiths, W. F. K. III, R. A. Lorie, P. R. McJones, J. W. Mehl, G. R. Putzolu, I. L. Traiger, B. W. Wade, and V. Watson. System R: Relational approach to database management. ACM Trans. Database Syst., 1(2):97-137, 1976.
4. M. Elhemali and L. Giakoumakis. Unit-testing query transformation rules. In DBTest, pages 1-6, 2008.
5. G. Graefe. The Cascades framework for query optimization. Data Engineering Bulletin, 18(3), 1995.
6. G. Graefe and W. J. McKenna. The Volcano optimizer generator: Extensibility and efficient search. In ICDE, 1993.
7. J. R. Haritsa. The picasso database query optimizer visualizer. PVLDB, 3(2):1517-1520, 2010.
8. W. Hong and M. Stonebraker. Optimization of parallel query execution plans in XPRS. Technical Report UCB/ERL M91/50, EECS Department, University of California, Berkeley, 1991.
9. Microsoft Corporation. Microsoft SQL Server PDW. http://www.microsoft. com/sqlserver/en/us/solutions-technologies/ data-warehousing/pdw.aspx.
10. R. V. Nehme and N. Bruno. Automated partitioning design in parallel database systems. In SIGMOD, 2011.