DBMS > AlaSQL vs. Google BigQuery
System Properties Comparison AlaSQL vs. Google BigQuery
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||AlaSQL Xexclude from comparison||Google BigQuery Xexclude from comparison|
|Primary database model||Document store|
|Developer||Andrey Gershun & Mathias R. Wulff|
|License Commercial or Open Source||Open Source MIT-License||commercial|
|Cloud-based only Only available as a cloud service||no||yes|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Typing predefined data types such as float or date||no||yes|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||no|
|SQL Support of SQL||Close to SQL99, but no user access control, stored procedures and host language bindings.||yes|
|Partitioning methods Methods for storing different data on different nodes||none||none|
|Replication methods Methods for redundantly storing data on multiple nodes||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||none||Immediate Consistency|
|Foreign keys Referential integrity||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||yes only for local storage and DOM-storage||no Since BigQuery is designed for querying data|
|Concurrency Support for concurrent manipulation of data||yes|
|Durability Support for making data persistent||yes by using IndexedDB, SQL.JS or proprietary FileStorage||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||no|
|User concepts Access control||no||Access privileges (owner, writer, reader) on dataset, table or view level Google Cloud Identity & Access Management (IAM)|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
|Related products and services|
|3rd parties||SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.|
CData: Connect to Big Data & NoSQL through standard Drivers.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|