Create entry

Microsoft SQL Server 2005 vs. BigTable

Microsoft SQL Server 2005 BigTable + Add column
Microsoft SQL Server 2012 BigTable
Category
Preference (63% global votes) (26% global votes)
Website www.​microsoft.​com/​sqlserver/​ en.​wikipedia.​org/​wiki/​BigTable
License
Design
Database model
Data storage
Embeddable Yes ?
Features
Query language
Data types
Conditional entry updates Yes No
Map and reduce No Yes
Unicode Yes Yes
TTL for entries Yes ?
Compression Yes Yes
Integrity
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes No
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity Yes ?
Revision control Yes Yes
Locking model No
Indexing
Secondary Indexes Yes Yes
Composite keys 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 ?
Restrictions
Value size max. 1 TB ?
System requirements
Operating system ?
Native driver ?
Memory minimum 100 MB ?
Architecture
Programming language
More
Description Relational database Key-value
Brand
Multi-user system Yes Yes
Extension/Plug-in Yes ?
Database ?
Multilingual content Yes ?
Price rating ★★★★★ ?
WYSIWYG-Editor Yes ?
Standard compliance Yes ?
Software distribution ?
Object-Relational Mapping (ORM) Yes ?
Release Date 24ᵗʰ July 2016 ?
Documentation level ★★★★★ ?
RESTful Yes ?
Distributed Counter Yes ?
Free to use Conditional ?
Active Yes Yes
Database Connection Pooling Yes ?
Real time analytics Yes Yes
Creation Date 2011 ?
WSDL Yes ?
Web interface Yes ?
Data encryption Yes ?
API Good ?
XML Aware Good ?
Cloud platform support
Online backup Yes ?
Function Based Index Yes ?
Key length max 800 ?
Log Yes ?
Implementation flexibility (43% global votes) (0% global votes)
Download www.​microsoft.​com/​sqlserver ?
Level of access authorization ?
Backup functionality Good ?
Query Cache Yes Yes
Ease of use ★★★★★ ★★★★☆
In-Place Update Yes ?
Free for commercial use No ?
Sorts Yes ?
Event Driven Architecture Yes ?
Triggers Yes ?
Perfomance ★★★★☆ ?
Materialized Views Yes ?
OData Yes ?
JSON Yes ?
Flexible Table(Schema) Yes ?
Stored Procedure Yes ?
Continuous query Yes ?
24/7 support Yes Yes
Free edition Yes No
Offheap Memory Yes ?
User and Group role based security model Yes ?
Multi-statement Transactions Yes ?
Does your mom understand it No ?
Recursive queries Yes ?
Online backup (no locking) Yes ?
CLI` Yes Yes
Geospatial ? No
Max rows in query result ? 5
ORM Join Support ? No
SQL Queries ? Yes
memcached protocol ? Yes
+ Add row ++
Microsoft SQL Server 2005 BigTable
  • 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