Open Access   Article Go Back

A Detailed Study On Features of Data Warehousing Database-Vertica

Jisha Mariam Jose1

  1. Dept. Of CSE, New Horizon College Of Engineering , Bangalore, India.

Section:Review Paper, Product Type: Journal Paper
Volume-6 , Issue-5 , Page no. 336-348, May-2018

CrossRef-DOI:   https://doi.org/10.26438/ijcse/v6i5.336348

Online published on May 31, 2018

Copyright © Jisha Mariam Jose . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.

View this paper at   Google Scholar | DPI Digital Library

How to Cite this Paper

  • IEEE Citation
  • MLA Citation
  • APA Citation
  • BibTex Citation
  • RIS Citation

IEEE Style Citation: Jisha Mariam Jose, “A Detailed Study On Features of Data Warehousing Database-Vertica,” International Journal of Computer Sciences and Engineering, Vol.6, Issue.5, pp.336-348, 2018.

MLA Style Citation: Jisha Mariam Jose "A Detailed Study On Features of Data Warehousing Database-Vertica." International Journal of Computer Sciences and Engineering 6.5 (2018): 336-348.

APA Style Citation: Jisha Mariam Jose, (2018). A Detailed Study On Features of Data Warehousing Database-Vertica. International Journal of Computer Sciences and Engineering, 6(5), 336-348.

BibTex Style Citation:
@article{Jose_2018,
author = {Jisha Mariam Jose},
title = {A Detailed Study On Features of Data Warehousing Database-Vertica},
journal = {International Journal of Computer Sciences and Engineering},
issue_date = {5 2018},
volume = {6},
Issue = {5},
month = {5},
year = {2018},
issn = {2347-2693},
pages = {336-348},
url = {https://www.ijcseonline.org/full_paper_view.php?paper_id=1982},
doi = {https://doi.org/10.26438/ijcse/v6i5.336348}
publisher = {IJCSE, Indore, INDIA},
}

RIS Style Citation:
TY - JOUR
DO = {https://doi.org/10.26438/ijcse/v6i5.336348}
UR - https://www.ijcseonline.org/full_paper_view.php?paper_id=1982
TI - A Detailed Study On Features of Data Warehousing Database-Vertica
T2 - International Journal of Computer Sciences and Engineering
AU - Jisha Mariam Jose
PY - 2018
DA - 2018/05/31
PB - IJCSE, Indore, INDIA
SP - 336-348
IS - 5
VL - 6
SN - 2347-2693
ER -

VIEWS PDF XML
365 224 downloads 198 downloads
  
  
           

Abstract

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.

Key-Words / Index Term

Column Orientation, Hybrid Store, Projections, Partitions, Tuple Mover, High Availability, Automatic Database Designer

References

[1] D.J. Abadi, P.A. Boncz, S.Harizopoulos, “Column-oriented database systems”, In The Proceedings of the VLDB Endowment, pp. 1664–1665, 2009.
[2] T. Siivola, “A Short Introduction To Vertica”, RedHat Software Developer Meetup, 2014.
[3] “Vertica Analytics Platform”, Vertica Documentation, Version: 8.1.x, 2018.
[4] 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.
[5] 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.
[6] 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.
[7] 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.
[8] 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.
[9] 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.
[10] “A DBMS Architecture Optimized for Next-Generation Data Warehousing” , The Vertica Analytic Database Technical Overview White Paper, Vertica System, 2010.