Communication cost optimization for cloud Data Warehouse queries

CloudCom 2012 - Proceedings: 2012 4th IEEE International Conference on Cloud Computing Technology and Science

Volumn , Issue , 2012, Pages 512-519

  Kurunji, Swathi ^a   Ge, Tingjian ^a   Liu, Benyuan ^a   Chen, Cindy X ^a  

^a University of Massachusetts Lowell   (United States)

Author keywords

Cloud Strorage; Communication Cost; Data Warehouse; Multi join Query; Query Optimization; Read Optimized Database

Indexed keywords

BANDWIDTH USAGE; CLOUD DATA; CLOUD ENVIRONMENTS; COMMUNICATION COST; COMMUNICATION MESSAGES; DATA SIZE; EXECUTE QUERY; FLEXIBLE ENVIRONMENTS; INTER-NODE COMMUNICATION; LOAD DATA; MULTI-JOIN; ON DEMANDS; PERFORMANCE DEGRADATION; PHYSICAL SYSTEMS; QUERY EXECUTION PLAN; QUERY OPTIMIZATION; QUERY PROCESSING ALGORITHMS; SCALED-UP; STORAGE STRUCTURES; WAREHOUSE APPLICATIONS; WORK LOADS;

CLOUD COMPUTING; DATA WAREHOUSES; DIGITAL STORAGE; OPTIMIZATION; QUERY PROCESSING;

COMMUNICATION;

EID: 84874267341     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1109/CloudCom.2012.6427580     Document Type: Conference Paper

References (24)

1. AmazonEC2: http://aws.amazon.com/ec2/
2. GoogleCloud: http://www.google.com/enterprise/cloud/storage/
3. Greenplum,EMC: http://www.greenplum.com/products/greenplumdatabase
4. IBM: http://www-01.ibm.com/software/data/infosphere/warehouse/
5. Microsoft:http://msdn.microsoft.com/enus/library/aa197903 (v=sql.80).aspx
6. Microstrategy: http://www.microstrategy.com/
7. OracleBI:http://www.oracle.com/us/solutions/entperformancebi/ enterprise-edition-066546.html
8. SqlServer: http://technet.microsoft.com/enus/sqlserver/cc510300.aspx
9. TPC-H: http://www.tpc.org/tpch/spec/tpch2.14.4.pdf.
10. Vertica:http://184.106.12.19/wpcontent/uploads/2011/01/ VerticaArchitectureWhitePaper.pdf
11. D. J. Abadi. Data management in the cloud: Limitations and opportunities. IEEE Data Eng. Bulletin '09, Volume 32(1):3-12
12. D. J. Abadi, P. A. Boncz, and S. Harizopoulos. Columnoriented database systems. In Proceeding, VLDB '09, 2(2):1664-1665.
13. D. J. Abadi, S. R. Madden, and N. Hachem. Column-stores vs. row-stores: how different are they really? In Proceeding, ACM SIGMOD '08, pages 967-980, New York, NY, USA.
14. A. Abouzeid, K. Bajda-Pawlikowski, D. Abadi, A. Silberschatz, and A. Rasin. Hadoopdb: an architectural hybrid of mapreduce and dbms technologies for analytical workloads. In Proceeding, VLDB '09, 2(1):922-933.
15. M. O. Akinde, M. H. Bohlen,T. Johnson, L. V. Lakshmanan, and D. Srivastava. efficient olap query processing in distributed data warehouses, 2002.
16. G. Candea, N. Polyzotis, and R. Vingralek. A scalable, predictable join operator for highly concurrent data warehouses. In Proceeding, VLDB '09, 2(1):277-288.
17. A. L. Holloway and D. J. DeWitt. Read-optimized databases, in depth. In Proceeding, VLDB '08, 1(1):502-513.
18. M. Ivanova, M. L. Kersten, and N. Nes. Self-organizing strategies for a column-store database. In Proceeding, EDBT '08, pages 157-168, New York, NY, USA.
19. R. MacNicol and B. French. Sybase iq multiplex designed for analytics.In Proceeding, VLDB '04, pages 1227-1230.
20. D. P. Panos Kalnis. Multi-query optimization for on-line analytical processing.. In Journal, Information Systems, Volume 28 Issue 5, July 2003.
21. M. Stonebraker, D. J. Abadi, A. Batkin, X. Chen, M. Cherniack, M. Ferreira, E. Lau, A. Lin, S. Madden, E. O'Neil, P. O'Neil, A. Rasin, N. Tran, and S. Zdonik. C-store: a columnoriented dbms. In Proceeding, VLDB '05, pages 553-564.
22. H. Wang, X. Meng, and Y. Chai. Efficient data distribution strategy for join query processing in the cloud. In Proceeding, CloudDB '11, pages 15-22, New York, NY, USA.
23. Waqar Hasan, Rajeev Motwani. Optimization Algorithms for Exploiting the Parallelism-Communication Tradeoff in Pipelined Parallelism. In Proceeding, VLDB '94, Santiago de Chile, Chile.
24. Jian Li, Amol Deshpande, Samir Khuller. Minimizing Communication Cost in Distributed Multi-query Processing. In Proceeding, ICDE '09, Shanghai, China.