Data Connectivity & Mainframe Inegration

Data Services Journal

Subscribe to Data Services Journal: eMailAlertsEmail Alerts newslettersWeekly Newsletters
Get Data Services Journal: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Data Services Authors: Scott Allen, Jacob Spencer, Reza Koohrang, Tony Shan, Charlie Clark

Related Topics: Data Services Journal, SOA & WOA Magazine, Big Data on Ulitzer

Data Services: Article

Vertica - Relational MPP Column-Store Database on Commodity Hardware

Vertica is an analytical, column-oriented relational database management system

Vertica is featuring MPP - shared nothing, commodity based architecture, column oriented database and HA based on automatic, transparent, multi-node replication. Vertica has built-in, automatic replication to distribute database across commodity hardware nodes. If a node goes down, Vertica automatically and transparently rebuilds data from other nodes (K-safety).

Vertica is an analytical, column-oriented relational database management system, meaning that data is stored and retrieved in units of columns. It also has built-in compression.

Vertica is also distributed database, where data to be queried (grouped and stored as projections - construct similar to materialized views) is split into chunks called segments across multiple nodes, which both improves performance and reliability.

More Stories By Ranko Mosic

Ranko Mosic, BScEng, is specializing in Big Data/Data Architecture consulting services ( database/data architecture, machine learning ). His clients are in finance, retail, telecommunications industries. Ranko is welcoming inquiries about his availability for consulting engagements and can be reached at 408-757-0053 or ranko.mosic@gmail.com