Create entry

Microsoft SQL Server 2017 vs. Essbase

Microsoft SQL Server 2017 Essbase + Add column
Preference (20% global votes) (71% global votes)
Website www.​microsoft.​com/​sqlserver www.​oracle.​com/​bi
Database model
Data storage
Embeddable Yes No
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 model ?
Atomicity Yes ?
Consistency Yes ?
Isolation Yes ?
Durability (data storage) Yes Yes
Transactions Conditional ?
Referential integrity Yes ?
Locking model
Secondary Indexes Yes ?
Composite keys Yes ?
Full text search Yes ?
Geospatial Indexes Yes ?
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding ? Yes
Shared nothing architecture Yes ?
Value size max. 2.15 GB ?
System requirements
Operating system
Native driver
Memory minimum ? 64 MB
Programming language
Description Relational Database Management System ?
Multi-user system Yes Yes
Standard compliance Yes Yes
Object-Relational Mapping (ORM) Yes ?
Documentation level ★★★★☆ ★★★★☆
Free to use Conditional No
Database Connection Pooling Yes ?
Real time analytics Yes Yes
Community Driven No No
Web interface Yes Yes
Data encryption Yes ?
Cloud platform support ?
Online backup Yes Yes
Key length max 68 ?
Implementation flexibility (0% global votes) (100% global votes)
Backup functionality Good Good
Query Cache Yes Yes
Free for commercial use Yes No
Sorts Yes Yes
Open Source No No
Triggers Yes Yes
Perfomance ★★★★☆ ★★★★☆
Materialized Views Yes ?
Server Side Java Script No ?
JSON Yes ?
Flexible Table(Schema) Yes ?
Stored Procedure Yes Yes
Free edition Yes ?
User and Group role based security model Yes ?
Does your mom understand it No ?
Database ?
Multilingual content ? Yes
Price rating ? ★★★★☆
Multiple projects ? Yes
Programming paradigm ?
Active ? Yes
API ? Good
Log ? Yes
Community feedback ? ★★★★☆
Ease of use ? ★★★★☆
In-Place Update ? Yes
Easy of Use ? Yes
Revenue Tracking ? Yes
Predictive Analytics ? Yes
+ Add row ++
Microsoft SQL Server 2017 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
    = 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.