DBMS > Microsoft Access vs. Sqrrl vs. TempoIQ
System Properties Comparison Microsoft Access vs. Sqrrl vs. TempoIQ
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Microsoft Access Xexclude from comparison||Sqrrl Xexclude from comparison||TempoIQ formerly TempoDB Xexclude from comparison|
|Sqrrl has been acquired by Amazon and became a part of Amazon Web Services. It has been removed from the DB-Engines ranking.||TempoIQ seems to be decommissioned. It will be removed from the DB-Engines ranking.|
|Description||Microsoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. The Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)||Adaptable, secure NoSQL built on Apache Accumulo||Scalable analytics DBMS for sensor data, provided as a service (SaaS)|
|Primary database model||Relational DBMS||Document store|
Wide column store
|Time Series DBMS|
|Developer||Microsoft||Amazon originally Sqrrl Data, Inc.||TempoIQ|
|Current release||1902 (16.0.11328.20222), March 2019|
|License Commercial or Open Source||commercial Bundled with Microsoft Office||commercial||commercial|
|Cloud-based only Only available as a cloud service||no||no||yes|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||Windows Not a real database server, but making use of DLLs||Linux|
|Typing predefined data types such as float or date||yes||yes||yes|
|SQL Support of SQL||yes but not compliant to any SQL standard||no||no|
|APIs and other access methods||ADO.NET|
RESTful HTTP API
|Supported programming languages||C|
C using GLib
|Server-side scripts Stored procedures||yes since Access 2010 using the ACE-engine||no||no|
|Triggers||yes since Access 2010 using the ACE-engine||no||yes Realtime Alerts|
|Partitioning methods Methods for storing different data on different nodes||none||Sharding making use of Hadoop|
|Replication methods Methods for redundantly storing data on multiple nodes||none||selectable replication factor making use of Hadoop|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency Document store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.|
|Foreign keys Referential integrity||yes||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID but no files for transaction logging||Atomic updates per row, document, or graph entity||no|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes but no files for transaction logging||yes||yes|
|User concepts Access control||no a simple user-level security was built in till version Access 2003||Cell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)||simple authentication-based access control|
More information provided by the system vendor
Related products and services
|Microsoft Access||Sqrrl||TempoIQ formerly TempoDB|
|DB-Engines blog posts|
MS Access drops in DB-Engines Ranking Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking New DB-Engines Ranking shows the popularity of database management systems
Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking New DB-Engines Ranking shows the popularity of database management systems
New DB-Engines Ranking shows the popularity of database management systems
|Recent citations in the news|
Abusing Microsoft Access "Linked Table" Feature to Perform NTLM ...
Adherence to Multiple Sclerosis Disease-Modifying Therapy Lowers ...
How to Connect MS Access to MySQL via ODBC Driver
MS access program to increase awareness and independence of ...
Here's how you can connect Microsoft Access to SQL server
provided by Google News
Celebrate The Season With Classic And Contemporary Holiday ...
Lee Ritenour is Taking the Stage at Rams Head On Stage!
Millennials possess the advantage of time for wealth creation, says Yashoraj Tyagi of Sqrrl
Amazon's cloud business acquires Sqrrl, a security start-up with ...
Here we go, Annapolis catches sugar plum fever for the holidays
provided by Google News
6 IoT Startups That Make Connecting Things To The Cloud A Breeze
Big Data and Analytics Industry Growth Factors, Applications, and ...
Spillover effect: Oil price crash bankrupting 'small oil'
The Industrial IoT: Startups Transforming Factory Floors, Oil Fields ...
IIoT and Cloud Computing Market Business Strategy and Growth ...
provided by Google News
Data Coordinator (Remote)
Business Reporting Analyst - Remote - Accountable Care - 1.0FTE Days
Personnel Security Technician I
Entry-Level IT Assistant
Share this page