A Detailed Study On Features of Data Warehousing Database-Vertica
DOI:
https://doi.org/10.26438/ijcse/v6i5.336348Keywords:
Column Orientation, Hybrid Store, Projections, Partitions, Tuple Mover, High Availability, Automatic Database DesignerAbstract
The data which are to be stored and analyzed for various purposes have gone beyond the storage limit of the traditional relational database system. This has led in emerge of various big data technologies to store and process this huge collection of varieties of data. Vertica is an HP enterprise product, which is used in data warehouses to store and perform data analysis that are stored for decades. Vertica is not only used in data warehouses but also it can be integrated with Hadoop ecosystem for big data analysis. This paper basically describes the architecture, features, storage, various operations in Vertica analytics database that has made Vertica to be used for managing and analysis of large volumes of fast-growing data for achieving higher performance in query intensive applications and data warehouses.
References
D.J. Abadi, P.A. Boncz, S.Harizopoulos, “Column-oriented database systems”, In The Proceedings of the VLDB Endowment, pp. 1664–1665, 2009.
T. Siivola, “A Short Introduction To Vertica”, RedHat Software Developer Meetup, 2014.
“Vertica Analytics Platform”, Vertica Documentation, Version: 8.1.x, 2018.
C. Bear, A. Lamb, N. Tran, “The Vertica Database: SQL RDBMS For Managing Big Data”, In The Proceedings of the workshop on Management of big data systems, 2012.
M. Stonebraker, “One size fits all: an idea whose time has come and gone”, In The Proceedings of 21st International Conference on Data Engineering, pp. 2-11, 2005.
A. Lamb, et al., “The Vertica Analytic Database : C-Store 7 Years Later”, In The Proceedings of the VLDB Endowment vol.5, No.12, pp 1790–1801, 2012.
D. Abadi, D. Myers, D. DeWitt, S. Madden, “Materialization Strategies in a Column-Oriented DBMS”, In The Proceedings IEEE 23rd International Conference on Data Engineering, pp 466—475, 2007.
S.Chakraborty , J. Doshi, “Data Retrieval from Data Warehouse Using Materialized Query Database”, International Journal of Computer Sciences and Engineering, Vol.6, Issue.1, pp-280-284, 2018.
Ramakrishna Varadarajan, V. Bharathan, A. Cary, J. Dave, S. Bodagala, “DBDesigner: A Customizable Physical Design Tool for Vertica Analytic Database”, In The Proceedings of IEEE 30th International Conference, pp. 1084-1095, 2014.
“A DBMS Architecture Optimized for Next-Generation Data Warehousing” , The Vertica Analytic Database Technical Overview White Paper, Vertica System, 2010.
Downloads
Published
How to Cite
Issue
Section
License
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors contributing to this journal agree to publish their articles under the Creative Commons Attribution 4.0 International License, allowing third parties to share their work (copy, distribute, transmit) and to adapt it, under the condition that the authors are given credit and that in the event of reuse or distribution, the terms of this license are made clear.
