Create entry

BigTable vs. kdb+

BigTable kdb+ + Add column
Category
Preference (26% global votes) (75% global votes)
Website en.​wikipedia.​org/​wiki/​BigTable kx.​com
License
Design
Database model
Data storage
Embeddable ? Yes
Features
Query language
Data types ?
Conditional entry updates No Yes
Map and reduce Yes Yes
Unicode Yes Yes
TTL for entries ? Conditional
Compression Yes Yes
Integrity
Integrity model ?
Atomicity Yes Yes
Consistency Yes Yes
Isolation No Yes
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 No Yes
Geospatial Indexes Yes Yes
Distribution
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode ?
Sharding Yes Yes
Shared nothing architecture ? Yes
Restrictions
Value size max. ? 10 TB
System requirements
Operating system ?
Native driver ?
Memory minimum ? 100 kB
Architecture
Programming language
More
Description Key-value In memory, high performance columnar
Brand
Multi-user system Yes Yes
Active Yes Yes
Real time analytics Yes Yes
Cloud platform support
Query Cache Yes Yes
Ease of use ★★★★☆ ★★★★☆
Geospatial No Yes
Max rows in query result 5 ?
ORM Join Support No ?
24/7 support Yes Yes
Free edition No Yes
SQL Queries Yes Yes
memcached protocol Yes Yes
CLI` Yes Yes
Extension/Plug-in ? Yes
Database ?
Price rating ? ★★★★★
Standard compliance ? Yes
Software distribution ?
Object-Relational Mapping (ORM) ? Yes
Release Date ? 1993
Documentation level ? ★★★★☆
RESTful ? Yes
Distributed Counter ? Yes
Free to use ? Conditional
Database Connection Pooling ? Yes
Creation Date ? 1993
Community Driven ? Good
Web interface ? Yes
Widgets Dashboard ? Good
API ? Good
Color ?
Online backup ? Yes
Function Based Index ? Yes
Geographic Replication ? Yes
Log ? Yes
Implementation flexibility (0% global votes) (100% global votes)
Download ? https:/​/​kx.​com/​software-download.​php
Level of access authorization ?
Backup functionality ? Good
In-Place Update ? Yes
Free for commercial use ? Yes
Sorts ? Yes
Capped Collections ? Yes
Tuneable write concerns ? Yes
Read preferences ? Yes
Event Driven Architecture ? Yes
Open Source ? No
Op/s ? 100 000
XInclude Support ? No
XQuery Support ? No
Maven support ? Yes
Global Assembly Cache ? Yes
Triggers ? Yes
Perfomance ? ★★★★★
Cloud-enabled ? Yes
Licenses model ?
Pipeline Aggregation ? Yes
Spring Data Support ? Yes
Predictive Analytics ? Yes
Text Analytics ? Yes
Server Side Java Script ? Yes
JSON ? Yes
Flexible Table(Schema) ? No
Geo-distributed ? Yes
Batch Loading ? Yes
Administrator responsive? ? Yes
Re-Reduce ? Yes
Clustering over WAN ? Yes
Fully Distributed ? Yes
Stored Procedure ? Yes
Second Level Caching ? Yes
Concurrency ? Yes
Auto-Sharding ? Yes
Native Adsense Integration ? No
Delta read ? Yes
Delta Update ? Yes
Aggregators ? Yes
Near cache ? Yes
Continuous query ? Yes
HTTP Session replication ? Yes
LDAP Integration ? Yes
In business since ? 1993
Number of systems in production ? 80 000
Distributed code Deployment ? Yes
Dynamic code deployment ? Yes
DB Delta Server ? Yes
Rolling Upgrade ? Yes
Dynamic index ? Yes
Data Grid interceptors ? Yes
Replication interceptors ? Yes
Kafka Integration ? No
Drools Integration ? No
Storm Integration ? No
Offheap Memory ? Yes
In-Memory File System ? Yes
CEP Streaming ? Yes
Does your mom understand it ? No
Monitoring UI ? Yes
Web Page Caching ? Yes
Web Page Fragment Caching ? Yes
Abstracts complexity of UI Components ? Yes
Hadoop Integration ? Yes
Apache Spark Integration ? Yes
+ Add row ++
BigTable kdb+
  • 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