Create entry

teradata vs. MySQL

teradata MySQL + Add column
Apache Hive MySQL
Preference 50% votes 50% votes
Website hive.​apache.​org www.​mysql.​com
Database model
Data storage
Embeddable Yes Yes
Query language
Data types
Conditional entry updates ? Yes
Map and reduce Yes No
Unicode Yes Yes
TTL for entries ? No
Compression Yes Yes
Integrity model ?
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions No Yes
Referential integrity Yes Yes
Revision control ? Yes
Locking model ?
Secondary Indexes ? Yes
Composite keys ? Yes
Full text search ? Yes
Geospatial Indexes No Yes
Graph support ? No
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding Yes Yes
Shared nothing architecture ? Yes
Value size max. ? 10 B
System requirements
Operating system
Native driver
Memory minimum ? 11 MB
Programming language
Description Big Data Relational database system
Multi-user system Yes Yes
Software distribution
Documentation level ★★★☆☆ ★★★★☆
Free to use Yes Conditional
Active Yes Yes
Real time analytics Yes No
Ease of use ★★★☆☆ ★★★★★
In-Place Update No Yes
Free for commercial use Yes Yes
Open Source Yes Yes
Yes ?
Extension/Plug-in ? Yes
Database ?
Multilingual content ? Yes
Price rating ? ★★★★★
WYSIWYG-Editor ? Yes
Multiple projects ? Yes
Standard compliance ? Yes
Object-Relational Mapping (ORM) ? Yes
Release Date ? 1995
RESTful ? Conditional
Lines of code ? 1 100 k
Database Connection Pooling ? Yes
Community Driven ? Good
Web interface ? Yes
Data encryption ? Yes
Color ?
Cloud platform support ?
Online backup ? Yes
Partial Index ? No
Function Based Index ? No
Key length max ? 765
Log ? Yes
Implementation flexibility (0% global votes) (21% global votes)
Download ? dev.​mysql.​com/​downloads/​
Backup functionality ? Basic
Query Cache ? Yes
Sorts ? Yes
Tuneable write concerns ? Yes
Triggers ? Yes
Perfomance ? ★★★★☆
Multivariate Testing ? No
Materialized Views ? No
Pipeline Aggregation ? Yes
Spring Data Support ? Yes
Geospatial ? Yes
Text Analytics ? Yes
Server Side Java Script ? No
JSON ? Yes
Flexible Table(Schema) ? No
Ajax ? Yes
Stored Procedure ? Yes
Concurrency ? Yes
Попаболь ? No
24/7 support ? Yes
Looks good on resumé ? Yes
Monitoring UI ? Yes
CLI` ? Yes
¿Es una Cagada? ? Yes
Will it make your rich ? Yes
Abstracts complexity of UI Components ? Yes
+ Add row ++
teradata MySQL
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    = better
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.