Skip to main content

Table 1 How SQL databases relate to some NoSQL databases

From: Automatic schema suggestion model for NoSQL document-stores databases

Heading level SQL databases Tables Hbase Document DB
Data model Relation-al Key/value store Column family store Document-store
Max size of data-base 100 s of GB 100 s of TBs 100 s of TBs 100 s of TBs
Storage concept Tables, rows, columns Tables, entities, partitions Tables, rows, cells, column families Collections, documents
Language for query SQL Subset of OData queries None Extended subset of SQL
Transaction support Rows and tables in a database One partition for all entities One row for all cells All documents in one collection
Secondary indexes Yes No No Yes
Triggers/stored proc T-SQL based None Java based JavaScript based
Valuing Unit of throughput 1 GBs of storage GBs of storage + VMs per hour Unit of throughput