Create entry

Microsoft SQL Server 2005 vs. Tarantool

Microsoft SQL Server 2005 Tarantool + Add column
Microsoft SQL Server 2012 Tarantool
Category
Preference (63% global votes) (40% global votes)
Website www.​microsoft.​com/​sqlserver/​ tarantool.​org
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 Yes Conditional
Compression Yes Yes
Integrity
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity Yes ?
Revision control Yes ?
Locking model
Indexing
Secondary Indexes Yes Yes
Composite keys Yes Yes
Full text search Yes No
Geospatial Indexes Yes Yes
Graph support Yes ?
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding Yes Yes
Shared nothing architecture Yes Yes
Restrictions
Value size max. 1 TB 50 MB
System requirements
Operating system
Native driver
Memory minimum 100 MB 64 MB
Architecture
Programming language
More
Description Relational database Hybrid database and Application server in one
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
Database
Multilingual content Yes Yes
Price rating ★★★★★ ★★★★☆
WYSIWYG-Editor Yes ?
Standard compliance Yes No
Software distribution
Object-Relational Mapping (ORM) Yes ?
Release Date 24ᵗʰ July 2016 2016
Documentation level ★★★★★ ★★★☆☆
RESTful Yes Conditional
Distributed Counter Yes Yes
Free to use Conditional Yes
Active Yes Yes
Database Connection Pooling Yes Yes
Real time analytics Yes Yes
Creation Date 2011 2008
WSDL Yes ?
Web interface Yes Yes
Data encryption Yes ?
API Good Good
XML Aware Good ?
Cloud platform support
Online backup Yes Yes
Function Based Index Yes ?
Key length max 800 4 000 000
Log Yes Yes
Implementation flexibility (43% global votes) (100% global votes)
Download www.​microsoft.​com/​sqlserver tarantool.​org/​download.​html
Level of access authorization
Backup functionality Good Good
Query Cache Yes Yes
Ease of use ★★★★★ ★★★★☆
In-Place Update Yes Yes
Free for commercial use No Yes
Sorts Yes Yes
Event Driven Architecture Yes Yes
Triggers Yes Yes
Perfomance ★★★★☆ ★★★★★
Materialized Views Yes No
OData Yes ?
JSON Yes Yes
Flexible Table(Schema) Yes Yes
Stored Procedure Yes Yes
Continuous query Yes ?
24/7 support Yes Yes
Free edition Yes Yes
Offheap Memory Yes Yes
User and Group role based security model Yes ?
Multi-statement Transactions Yes Yes
Does your mom understand it No No
Recursive queries Yes Yes
Online backup (no locking) Yes Yes
CLI` Yes Yes
Synchronisation ?
Lines of code ? 250 k
Community Driven ? Good
Versioning ? Good
2 Letter Country Code ? US
Color ?
Partial Index ? Yes
Geographic Replication ? Yes
Capped Collections ? Yes
Tuneable write concerns ? No
Read preferences ? Yes
Bitmap index ? Yes
Open Source ? Yes
Op/s ? 1 000 000
Maven support ? Yes
Server side custom code ? Yes
Cloud-enabled ? Yes
Licenses model ?
Minimal memory footprint ? 1 B
Pipeline Aggregation ? Yes
Predictive Analytics ? Yes
Geospatial ? Yes
Geo-distributed ? Yes
Ajax ? Yes
Batch Loading ? Yes
Max rows in query result ? 1 111 111 111
Clustering over WAN ? Yes
Fully Distributed ? Yes
Corruption Resistant ? Yes
Second Level Caching ? Yes
Concurrency ? Yes
Auto-Sharding ? Yes
Contributors ? 48
Delta read ? Yes
Delta Update ? Yes
Aggregators ? Yes
HTTP Session replication ? Yes
In business since ? 2008
Number of systems in production ? 153
Distributed code Deployment ? Yes
Rolling Upgrade ? Yes
Kafka Integration ? Yes
SQL Queries ? Yes
Atomic Persistence ? Yes
Average Latency (milliseconds)) ? 1
Maximum Database Size ? 3 PB
memcached protocol ? Yes
Monitoring UI ? No
Network datatype ? Yes
Web Page Caching ? Yes
Web Page Fragment Caching ? Yes
In Memory Data Grid ?
Hadoop Integration ? Yes
Compute Grid ? Yes
Point In Time Recovery ? Yes
Does your boss understand it? ? No
+ Add row ++
Microsoft SQL Server 2005 Tarantool
  • 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