The vertica analytic database: Cstore 7 years later

Proceedings of the VLDB Endowment

Volumn 5, Issue 12, 2012, Pages 1790-1801

  Lamb, Andrew ^a   Fuller, Matt ^a   Varadarajan, Ramakrishna ^a   Tran, Nga ^a   Vandiver, Ben ^a   Doshi, Lyric ^a   Bear, Chuck ^a  

^a Vertica An HP Company   (United States)

Author keywords

[No Author keywords available]

Indexed keywords

ACADEMIC SYSTEM; C-STORE; RESEARCH PROTOTYPE; SYSTEM ARCHITECTURES;

EID: 84867732945     PISSN: None     EISSN: 21508097     Source Type: Conference Proceeding    
DOI: 10.14778/2367502.2367518     Document Type: Article

References (27)

1. Actian Vectorwise. http://www.actian.com/products/vectorwise.
2. HP Completes Acquisition of Vertica Systems, Inc. http://www.hp.com/hpinfo/newsroom/press/ 2011/110322c.html.
3. Infobright. http://www.infobright.com/.
4. Oracle Hybrid Columnar Compression on Exadata. http://www.oracle.com/technetwork/middleware/bifoundation/ ehcc-twp-131254.pdf.
5. PostgreSQL. http://www.postgresql.org/.
6. Why Verticas Compression is Better. http://www.vertica.com/2010/05/26/ why-verticas-compression-is-better.
7. A. Thusoo, J.S. Sarma, N. Jain, Z. Shao, P. Chakka, S. Anthony, H. Liu, P. Wyckoff and R. Murthy. Hive -A Warehousing Solution Over a MapReduce Framework. PVLDB, 2(2):1626-1629, 2009.
8. D. J. Abadi, D. S. Myers, D. J. Dewitt, and S. R. Madden. Materialization Strategies in a Column-Oriented DBMS. In ICDE, pages 466-475, 2007.
9. B. Chattopadhyay, L. Lin, W. Liu, S. Mittal, P. Aragonda, V. Lychagina, Y. Kwon and M. Wong. Tenzing: A SQL Implementation On The MapReduce framework. PVLDB, 4(12):1318-1327, 2011.
10. P. A. Boncz, M. Zukowski, and N. Nes. MonetDB/X100: Hyper-Pipelining Query Execution. In CIDR, pages 225-237, 2005.
11. S. Ceri and J. Widom. Deriving Production Rules for Incremental View Maintenance. In VLDB, pages 577-589, 1991.
12. J. Dean and S. Ghemawat. MapReduce: Simplified Data Processing on Large Clusters. In OSDI, pages 137-150, 2004.
13. G. DeCandia, D. Hastorun, M. Jampani, G. Kakulapati, A. Lakshman, A. Pilchin, S. Sivasubramanian, P. Vosshall, and W. Vogels. Dynamo: Amazon's Highly Available Key-value Store. In SOSP, pages 205-220, 2007.
14. F. F̈arber, S. K. Cha, J. Primsch, C. Bornḧovd, S. Sigg, and W. Lehner. SAP HANA Database: Data Management for Modern Business Applications. ACM SIGMOD Record, 40(4):45-51, 2012.
15. J. Gray and A. Reuter. Transaction Processing: Concepts and Techniques. Morgan Kaufmann Publishers Inc., 1992.
16. P. J. Haas, J. F. Naughton, S. Seshadri, and L. Stokes. Sampling-Based Estimation of the Number of Distinct Values of an Attribute. In VLDB, pages 311-322, 1995.
17. W. Kim. On Optimizing a SQL-like Nested Query. ACM TODS, 7(3):443-469, 1982.
18. R. Kimball and M. Ross. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling. Wiley, John & Sons, Inc., 2002.
19. A. Lakshman and P. Malik. Cassandra: A Decentralized Structured Storage System. SIGOPS Operating Systems Review, 44(2):35-40, 2010.
20. P.-Å. Larson, E. N. Hanson, and S. L. Price. Columnar Storage in SQL Server 2012. IEEE Data Engineering Bulletin, 35(1):15-20, 2012.
21. M. Stonebraker, D. J. Abadi, A. Batkin, X. Chen, M. Cherniack, M. Ferreira, E. Lau, A. Lin, S. Madden and E. J. O'Neil et.al. C-Store: A Column-oriented DBMS. In VLDB, pages 553-564, 2005.
22. G. Moerkotte. Small Materialized Aggregates: A Light Weight Index Structure for data warehousing. In VLDB, pages 476-487, 1998.
23. R. Barber, P. Bendel, M. Czech, O. Draese, F. Ho, N. Hrle, S. Idreos, M.S. Kim, O. Koeth and J.G. Lee et.al. Business Analytics in (a) Blink. IEEE Data Engineering Bulletin, 35(1):9-14, 2012.
24. D. Slezak, J. Wroblewski, V. Eastwood, and P. Synak. Brighthouse: An Analytic Data Warehouse for Ad-hoc Queries. PVLDB, 1(2):1337-1345, 2008.
25. M. Staudt and M. Jarke. Incremental Maintenance of Externally Materialized Views. In VLDB, pages 75-86, 1996.
26. M. Stonebraker. One Size Fits All: An Idea Whose Time has Come and Gone. In ICDE, pages 2-11, 2005.
27. J. D. Ullman. Principles of Database and Knowledge-Base Systems, Volume II. Computer Science Press, 1989.