Create entry

BigTable vs. Microsoft SQL Server 2017

BigTable Microsoft SQL Server 2017 + Add column
Category
Preference (26% global votes) (20% global votes)
Website en.​wikipedia.​org/​wiki/​BigTable www.​microsoft.​com/​sqlserver
License
Design
Database model
Data storage
Embeddable ? Yes
Features
Query language
Data types
Conditional entry updates No Yes
Map and reduce Yes No
Unicode Yes Yes
TTL for entries ? No
Compression Yes Yes
Integrity
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation No Yes
Durability (data storage) Yes Yes
Transactions Yes Conditional
Referential integrity ? Yes
Revision control Yes ?
Locking model No
Indexing
Secondary Indexes Yes Yes
Composite keys ? Yes
Full text search No Yes
Geospatial Indexes Yes Yes
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding Yes ?
Shared nothing architecture ? Yes
Restrictions
Value size max. ? 2.15 GB
System requirements
Operating system ?
Native driver ?
Architecture
Programming language
More
Description Key-value Relational Database Management System
Brand
Multi-user system Yes Yes
Active Yes ?
Real time analytics Yes Yes
Cloud platform support
Query Cache Yes Yes
Ease of use ★★★★☆ ?
Geospatial No ?
Max rows in query result 5 ?
ORM Join Support No ?
24/7 support Yes ?
Free edition No Yes
SQL Queries Yes ?
memcached protocol Yes ?
CLI` Yes ?
Standard compliance ? Yes
Object-Relational Mapping (ORM) ? Yes
Documentation level ? ★★★★☆
Free to use ? Conditional
Database Connection Pooling ? Yes
Community Driven ? No
Web interface ? Yes
Data encryption ? Yes
Online backup ? Yes
Key length max ? 68
Implementation flexibility (0% global votes) (0% global votes)
Backup functionality ? Good
Free for commercial use ? Yes
Sorts ? Yes
Open Source ? No
Triggers ? Yes
Perfomance ? ★★★★☆
Materialized Views ? Yes
Server Side Java Script ? No
JSON ? Yes
Stored Procedure ? Yes
User and Group role based security model ? Yes
Does your mom understand it ? No
+ Add row ++
BigTable Microsoft SQL Server 2017
  • 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