Create entry

InterBase vs. Oracle

InterBase Oracle + Add column
InterBase Oracle (Database)
Category
Preference (33% global votes) (44% global votes)
Website www.​embarcadero.​com/​products/​interbase www.​oracle.​com/​us/​product…e/​index.​html
License
Design
Database model
Data storage ?
Embeddable Yes No
Features
Query language
Data types ?
Conditional entry updates Yes Yes
Map and reduce No No
Unicode Yes Yes
TTL for entries ? Yes
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 Yes
Revision control ? Yes
Locking model
Indexing
Secondary Indexes No Yes
Composite keys No Yes
Full text search Yes Yes
Geospatial Indexes ? Yes
Graph support ? Yes
Distribution
Horizontal scalable ? Yes
Replication No Yes
Replication mode ?
Sharding ? Yes
Shared nothing architecture ? No
Restrictions
Value size max. ? 4 B
System requirements
Operating system
Native driver ?
Memory minimum ? 512 MB
Architecture
Programming language
More
Brand
Multi-user system Yes Yes
Database
Price rating ★★★★☆ ★★☆☆☆
Documentation level ★★☆☆☆ ★★★★★
Free to use Conditional Conditional
Active Yes Yes
Online backup Yes Yes
Backup functionality Good Good
Query Cache No Yes
Ease of use ★★★★☆ ★★★★☆
Free for commercial use No No
Open Source No No
Triggers Yes Yes
Perfomance ★★★★☆ ★★★★★
Does your mom understand it No No
Description ? Multi-Model Data Management Platform
Extension/Plug-in ? Yes
Multilingual content ? Yes
WYSIWYG-Editor ? Yes
Multiple projects ? Yes
Standard compliance ? Yes
Software distribution ?
Object-Relational Mapping (ORM) ? Yes
Release Date ? January 1936
RESTful ? Yes
Dynamic typing ? Yes
Distributed Counter ? Yes
Database Connection Pooling ? Yes
Real time analytics ? Yes
Creation Date ? 1977
Community Driven ? No
WSDL ? No
Web interface ? Yes
Data encryption ? Yes
API ? Good
XML Aware ? Good
Color ?
Cloud platform support ?
Partial Index ? Yes
Function Based Index ? Yes
Geographic Replication ? Yes
Log ? Yes
Implementation flexibility (0% global votes) (31% global votes)
Download ? www.​oracle.​com
Level of access authorization ?
In-Place Update ? Yes
Sorts ? Yes
Read preferences ? Yes
Event Driven Architecture ? Yes
Allowed number of content elements ? Yes
Op/s ? 58 000
XQuery Support ? Yes
Server side custom code ? Yes
Cloud-enabled ? Yes
Cross Domain Testing ? Yes
Licenses model ?
Materialized Views ? Yes
Pipeline Aggregation ? No
Spring Data Support ? Yes
Predictive Analytics ? Yes
Geospatial ? Yes
Text Analytics ? Yes
Server Side Java Script ? Yes
HTML5 Charts ? Yes
JSON ? Yes
Flexible Table(Schema) ? Yes
Geo-distributed ? Yes
Extensibility ? Yes
Ajax ? Yes
Batch Loading ? Yes
Max rows in query result ? -1
ORM Join Support ? Yes
Clustering over WAN ? Yes
Fully Distributed ? Yes
Stored Procedure ? Yes
Second Level Caching ? Yes
Concurrency ? Yes
Auto-Sharding ? Yes
Native Adsense Integration ? Yes
Continuous query ? Yes
In business since ? 1977
Number of systems in production ? 430 000
24/7 support ? Yes
Free edition ? Yes
Rolling Upgrade ? Yes
Dynamic index ? Yes
SQL Queries ? Yes
Atomic Persistence ? Yes
User and Group role based security model ? Yes
3D Support ? No
Multi-statement Transactions ? Yes
Monitoring UI ? Yes
Recursive queries ? Yes
Windowed aggregate ? Yes
Online backup (no locking) ? Yes
CLI` ? Yes
command-line console ? Yes
Local Flash Storage support ? Yes
Hadoop Integration ? Yes
Apache Spark Integration ? Yes
Point In Time Recovery ? Yes
Incremental Backup ? Yes
Performance ? 4 500 000
+ Add row ++
InterBase Oracle
  • 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