NoSQL 的局限性
- NoSQL不支持关系数据模型，以及标准的SQL/API；
- NoSQL不遵从ACID原则；
- NoSQL在架构设计时，没有考虑对结构化数据存储的要求，进而易于导致数据的丢失；
- NoSQL不支持复杂的数据操作，例如UPDATE；
- 在使用NoSQL时，很难避免重复数据的出现；
- 使用NoSQL很难进行数据的备份与恢复；
- NoSQL不适用于即席查询与数据分析场景；
- NoSQL产品的成熟度低，稳定性与可靠性也较差；
- NoSQL在安装与维护上也很麻烦；
- NoSQL的用户很难获得及时的技术支持；
- 在NoSQL领域的专家较少。
General
| Item | Altibase | NoSQL |
|---|---|---|
| Purpose | General Purpose | Special Purpose |
| Product Maturity | 15 Years | Under 4 ~ 5 Years |
| License | Commercial | Open Source |
| BI | Real time OLAP | Not supported |
Architecture
| Item | Altibase | NoSQL |
| Database Model | Relational | Simple key-value store |
| Query Language | ANSI SQL | Non-standard functions for each product |
| Data Types | All types Supported | Limited data types |
| Scalability | Scale up/out | Scale out |
Transaction
| Item | Altibase | NoSQL |
| Transaction | ACID | - |
| Data Loss | Impossible | Possible |
| MVCC | Supported | Not supported |
Features
| Item | Altibase | NoSQL |
| Secondary indexes | Supported | Limitedly supported |
| Foreign keys | Supported | Not supported |
| Triggers | Supported | Not supported |
| Server-side scripts | Supported | Not supported |
| Spatial data type | Supported | Not supported |
| Lob type | Supported | Not supported |
| Database link | Supported | Not supported |
| Complex query | Supported | Not supported |
| Analytic query | Supported | Not supported |
| Sorting by query language | Supported | Not supported |
| Join | Supported | Not supported |
| Grouping | Supported | Not supported |
| Range Query | Supported | Not supported |
Development
| Item | Altibase | NoSQL |
| ODBC interface | Supported | Not supported |
| JDBC interface | Supported | Not supported |
| ADO.Net interface | Supported | Not supported |
| Development Convenience | Easy (Familiar) | Difficult (Unfamiliar) |
| Table Design | general, flexible | complex, fixed |
| Data Redundancy | Seldom(Normalized) | Frequent(Not normalized) |
| Data scheme | Yes | No (Schema-free) |
| Included Tools and Utilities | Many | Limited |
Other
| Item | Altibase | NoSQL |
| Technical Support | Strong | Weak |
| Backup / Restore | Simple(online & offline) | Complex |
| Expert Pool | Many | Few |
| Reference site | Many | Few |
| Education | Easy | Difficult |
| System Administration | Easy | Complicated |
| Maintenance | Easy | Difficult |
| Maintenance cost | General | High |
| Security | Strong | Weak |
| Eco-System | Many | Limited |