How does Altibase compare to NoSQL?

Altibase provides real time ACID and SQL compliance whereas NoSQL does not support these features.

Other shortcomings of NoSQL:

  • NoSQL is not a relational database and often does not support ACID, SQL and standard interfaces.
  • NoSQL is not designed to store structured data and is prone to data loss.
  • It is difficult to prevent data duplication with NoSQL.
  • Backup and recovery is significantly more complex.
  • NoSQL is not suitable for ad-hoc queries and analysis.
  • NoSQL has low product maturity and has stability and reliability issues.
  • It is difficult to install and maintain NoSQL.
  • There is inadequate support for NoSQL users.
  • There are few experts available specialized in NoSQL.

Following case studies include related stories.

Altibase vs. NoSQL

Category

Class

Item

Altibase

NoSQL

Business

Use

Versatile

General

Restricted, specific

Relational

Relational

Non-relational

H/W configuration

General

Dependent on HW

Competitor

Competitor

Enterprise RDBMSs
(Oracle, MSSQL)

Many products

(Cassandra, MongoDB, Redis)

Standard

ANSI

Support ANSI

Non-standard

Technique

Transaction

Guaranteed

Guaranteed (ACID)

Not guaranteed

Query

Update

Easy

Difficult

Complex query

Available

Not supported

Sorting

Available, easy

Not supported or difficult

Join

Available

Not supported

Grouping

Available

Not supported

Range query

Available

Not supported

Index

Available

Not supported

Development and Maintenance

Development

Development

Familiar

Unfamiliar

Expert pool

Rich

Poor

Table design

General, flexible

Complex, fixed

Data redundancy

Rare (normalization)

Many (denormalization)

Schema

Check by DB

Check by app

Hybrid

Supported

Not supported

Maintenance

Technical support

Strong

Vendor support weak, Community support strong

Reference site

Many

Many

Training

Strong

Weak

Maintenance

Easy

Hard

Backup

Simple

Complex

 

Comments are closed.