Create entry

MySQL vs. Essbase

MySQL Essbase + Add column
Category
Preference (29% global votes) (71% global votes)
Website www.​mysql.​com www.​oracle.​com/​bi
License
Design
Database model
Data storage
Embeddable Yes No
Features
Query language
Data types ?
Conditional entry updates Yes Yes
Map and reduce No Yes
Unicode Yes Yes
TTL for entries No ?
Compression Yes Yes
Integrity
Integrity model ?
Atomicity Yes ?
Consistency Yes ?
Isolation Yes ?
Durability (data storage) Yes Yes
Transactions Yes ?
Referential integrity Yes ?
Revision control Yes ?
Locking model
Indexing
Secondary Indexes Yes ?
Composite keys Yes ?
Full text search Yes ?
Geospatial Indexes Yes ?
Graph support No ?
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding No ?
Shared nothing architecture No ?
Restrictions
Value size max. 10 EB ?
System requirements
Operating system
Native driver
Memory minimum 11 MB 64 MB
Architecture
Programming language
More
Description Relational database system ?
Brand
Multi-user system Conditional Yes
Extension/Plug-in Yes ?
Database
Multilingual content Yes Yes
Price rating ★★★★★ ★★★★☆
Multiple projects Yes Yes
Standard compliance Yes Yes
Software distribution ?
Object-Relational Mapping (ORM) No ?
Release Date May 1995 ?
Documentation level ★★★★☆ ★★★★☆
RESTful No ?
Lines of code 1 100 k ?
Free to use Yes No
Active Yes Yes
Database Connection Pooling Yes ?
Real time analytics Conditional Yes
Community Driven Good No
Web interface Yes Yes
Data encryption Yes ?
Cloud platform support ?
Online backup Yes Yes
Partial Index Yes ?
Function Based Index Yes ?
Key length max 3 072 ?
Log Yes Yes
Implementation flexibility (21% global votes) (100% global votes)
Download dev.​mysql.​com/​downloads/​ ?
Backup functionality Good Good
Query Cache Yes Yes
Ease of use ★★★★★ ★★★★☆
In-Place Update No Yes
Free for commercial use Yes No
Sorts Yes Yes
Tuneable write concerns Yes ?
Open Source Yes No
Triggers Yes Yes
Perfomance ★★★★☆ ★★★★☆
Cloud-enabled Yes ?
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 ?
Geo-distributed No ?
Stored Procedure Yes Yes
Concurrency Yes ?
24/7 support Yes ?
Free edition Yes ?
SQL Queries Yes ?
3D Support Yes ?
Monitoring UI Yes ?
Online backup (no locking) Yes ?
CLI` Yes ?
Abstracts complexity of UI Components Yes ?
Point In Time Recovery Yes ?
Does remove features when broken? Yes ?
Programming paradigm ?
API ? Good
Community feedback ? ★★★★☆
Easy of Use ? Yes
Revenue Tracking ? Yes
Predictive Analytics ? Yes
+ Add row ++
MySQL Essbase
  • vsChart is like a wiki

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

  • blue
    = good
    darker
    = better
    Legend
  • 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.

Type
Review
Comment