SAP HANA DB vs Vertica DB 비교

728x90

업무 때문에 DB 접근이 잦다. 

일반적인 트랜잭션 위주의 프로그램은 로우 단위 DB를 사용한다.

 

Oracle, MS-SQL, MySQL 등이 그 대표적인 예이다.

 

요즘은 데이터가 너무 많고, 특정 컬럼에 대한 대량 데이터의 조회나 처리가 필요한 경우가 많다. 

 

그래서 대두되는 것이 컬럼형 DB다.

 

아래는 SAP HANA DB 와 Vertica DB 비교자료가 필요해 자료를 찾던 중 얻은 것이다.

 

반응형

 

Editorial information provided by DB-Engines
Name	SAP HANA  X	Vertica   X
Description	In-memory, column based data store. Available as appliance or cloud service	Columnar relational DBMS designed to handle modern analytic workloads, enabling fast query performance
Primary database model	Relational DBMS	Relational DBMS
Secondary database models	Document store Graph DBMS  Spatial DBMS	Document store Spatial DBMS
Website	www.sap.com/­products/­hana.html	www.vertica.com
Technical documentation	help.sap.com/­hana	www.vertica.com/­docs/­10.0.x/­HTML/­Content/­Home.htm
Developer	SAP	Vertica / Micro Focus
Initial release	2010	2005
Current release	2.0 SPS05 (June 26, 2020), June 2020	Vertica 10.0 Software, May 2020 Vertica for SQL on Hadoop 10.0 Software, May 2020
License	commercial	commercial
Cloud-based only	no	no
DBaaS offerings (sponsored links)
Server operating systems	Appliance or cloud-service	Linux
Data scheme	yes	yes
Typing	yes	yes
XML support	no	yes
Secondary indexes	yes	no
SQL	yes	yes
APIs and other access methods	JDBC ODBC	ADO.NET JDBC Kafka ODBC Proprietary protocol RESTful HTTP API
Supported programming languages		C++ Java Perl Python R
Server-side scripts	SQLScript, R	yes
Triggers	yes	no
Partitioning methods	yes	Sharding
Replication methods	yes	Multi-source replication
MapReduce	no	yes
Consistency concepts	Immediate Consistency	Immediate Consistency
Foreign keys	yes	yes
Transaction concepts	ACID	ACID
Concurrency	yes	yes
Durability	yes	yes
In-memory capabilities	yes
User concepts	yes	fine grained access rights according to SQL-standard; supports Kerberos, LDAP, Ident and hash
More information provided by the system vendor
	SAP HANA	Vertica
Specific characteristics		Columnar storage, MPP, Hybrid storage model, Aggressive data compression, High availability,... » more
Competitive advantages		Performance at exabyte scale, Deploy anywhere, Open source innovation, Analysis in... » more
Typical application scenarios		Communication and network analytics, Embedded analytics, Fraud monitoring and Risk... » more
Key customers		Abiba Systems, Adform, adMarketplace, AmeriPride, Anritsu, AOL, Avito, Auckland Transport,... » more
Licensing and pricing models		Cost-based models and subscription-based models are available » more
We invite representatives of system vendors to contact us for updating and extending the system information, and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.
Related products and services
3rd parties	CData: Connect to Big Data & NoSQL through standard Drivers. » more
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
More resources
	SAP HANA	Vertica
Recent citations in the news	SIOS Protection Suite for Linux 9.6 Offers Faster Recovery of SAP HANA Database 17 November 2021, Database Trends and Applications French Enterprises Overcome Concerns About S/4 Hana 29 November 2021, E3zine.com UKISUG 2021: S/4 Hana skills deficit and legacy custom code hamper migration 29 November 2021, ComputerWeekly.com New SIOS Protection Suite for Linux Version 9.6.0 Enhances Data Integrity Protection in Microsoft Azure and Enables Up to Five Times Faster Recovery Time for SAP HANA Databases 3 November 2021, Yahoo Finance SAP rolls out new low-code developer tools, next-gen UI and integrations 16 November 2021, ZDNet provided by Google News	Vertica to Leverage NetApp StorageGRID to Deliver Cloud-Scale Analytics to On-Premises Environments 10 November 2021, PRNewswire EDB unleashes BigAnimal in the cloud 2 November 2021, ZDNet Vertica Announces Vertica 11, Delivering on Vision of Unified Analytics 20 July 2021, PRNewswire Vertica Accelerator is Now Available on AWS 28 September 2021, Database Trends and Applications Vertica Announces Early Access of Vertica Eon Accelerator and Acquisition of Full360 16 June 2021, Database Trends and Applications provided by Google News
Job opportunities	Associate Agile Developer for SAP HANA Core SQL & SQLScript Team SAP C++ Developer for High-Performance Cloud Database Kernel (SAP HANA) SAP Azure Customer Engineer (FastTrack for Azure - SAP) Microsoft Project Senior SAP Consultant SAP 유화 ERP 구축 SAP 컨설턴트 채용 한화그룹	Senior Analytics Acceleration Lab SA Amazon Web Services Korea LLC Vertica Business Development/Inside Sales - Korea Vertica