Create entry

Oracle vs. kdb+

Oracle kdb+ + Add column
Oracle (Database) kdb+
Preference (44% global votes) (67% global votes)
Website www.​oracle.​com/​us/​product…e/​index.​html kx.​com
Database model
Data storage
Embeddable No Yes
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 model ?
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Yes Yes
Referential integrity Yes Yes
Revision control Yes Yes
Locking model
Secondary Indexes Yes Yes
Composite keys Yes Yes
Full text search Yes Yes
Geospatial Indexes Yes Yes
Graph support Yes ?
Horizontal scalable Yes Yes
Replication Yes Yes
Replication mode
Sharding Yes Yes
Shared nothing architecture No Yes
Value size max. 4 B 10 TB
System requirements
Operating system
Native driver
Memory minimum 512 MB 100 kB
Programming language
Description Multi-Model Data Management Platform In memory, high performance columnar
Multi-user system Yes Yes
Extension/Plug-in Yes Yes
Multilingual content Yes ?
Price rating ★★☆☆☆ ★★★★★
WYSIWYG-Editor Yes ?
Multiple projects Yes ?
Standard compliance Yes Yes
Software distribution
Object-Relational Mapping (ORM) Yes Yes
Release Date January 1936 1993
Documentation level ★★★★★ ★★★★☆
RESTful Yes Yes
Dynamic typing Yes ?
Distributed Counter Yes Yes
Free to use Conditional Conditional
Active Yes Yes
Database Connection Pooling Yes Yes
Real time analytics Yes Yes
Creation Date 1977 1993
Community Driven No Good
Web interface Yes Yes
Data encryption Yes ?
API Good Good
XML Aware Good ?
Cloud platform support
Online backup Yes Yes
Partial Index Yes ?
Function Based Index Yes Yes
Geographic Replication Yes Yes
Log Yes Yes
Implementation flexibility (31% global votes) (100% global votes)
Download www.​oracle.​com https:/​/​kx.​com/​software-download.​php
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
Read preferences Yes Yes
Event Driven Architecture Yes Yes
Open Source No No
Allowed number of content elements Yes ?
Op/s 58 000 100 000
XQuery Support Yes No
Triggers Yes Yes
Server side custom code Yes ?
Perfomance ★★★★★ ★★★★★
Cloud-enabled Yes Yes
Cross Domain Testing Yes ?
Licenses model
Materialized Views Yes ?
Pipeline Aggregation No Yes
Spring Data Support Yes Yes
Predictive Analytics Yes Yes
Geospatial Yes Yes
Text Analytics Yes Yes
Server Side Java Script Yes Yes
HTML5 Charts Yes ?
JSON Yes Yes
Flexible Table(Schema) Yes No
Geo-distributed Yes Yes
Extensibility Yes ?
Ajax Yes ?
Batch Loading Yes Yes
Max rows in query result -1 ?
ORM Join Support Yes ?
Clustering over WAN Yes Yes
Fully Distributed Yes Yes
Stored Procedure Yes Yes
Second Level Caching Yes Yes
Concurrency Yes Yes
Auto-Sharding Yes Yes
Native Adsense Integration Yes No
Continuous query Yes Yes
In business since 1977 1993
Number of systems in production 430 000 80 000
24/7 support Yes Yes
Free edition Yes Yes
Rolling Upgrade Yes Yes
Dynamic index Yes Yes
SQL Queries Yes Yes
Atomic Persistence Yes ?
User and Group role based security model Yes ?
3D Support No ?
Multi-statement Transactions Yes ?
Does your mom understand it No No
Monitoring UI Yes Yes
Recursive queries Yes ?
Windowed aggregate Yes ?
Online backup (no locking) Yes ?
CLI` Yes Yes
command-line console Yes ?
Local Flash Storage support Yes ?
Hadoop Integration Yes Yes
Apache Spark Integration Yes Yes
Point In Time Recovery Yes ?
Incremental Backup Yes ?
Performance 4 500 000 ?
Widgets Dashboard ? Good
Capped Collections ? Yes
Tuneable write concerns ? Yes
XInclude Support ? No
Maven support ? Yes
Global Assembly Cache ? Yes
Administrator responsive? ? Yes
Re-Reduce ? Yes
Delta read ? Yes
Delta Update ? Yes
Aggregators ? Yes
Near cache ? Yes
HTTP Session replication ? Yes
LDAP Integration ? Yes
Distributed code Deployment ? Yes
Dynamic code deployment ? Yes
DB Delta Server ? 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
memcached protocol ? Yes
Web Page Caching ? Yes
Web Page Fragment Caching ? Yes
Abstracts complexity of UI Components ? Yes
+ Add row ++
Oracle 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
    = 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.