DB-EnginesInfluxDB: Focus on building software with an easy-to-use serverless, scalable time series platformEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > EJDB vs. Faircom EDGE vs. Microsoft Access vs. Splice Machine vs. Sqrrl

System Properties Comparison EJDB vs. Faircom EDGE vs. Microsoft Access vs. Splice Machine vs. Sqrrl

Editorial information provided by DB-Engines
NameEJDB  Xexclude from comparisonFaircom EDGE infoformerly c-treeEDGE  Xexclude from comparisonMicrosoft Access  Xexclude from comparisonSplice Machine  Xexclude from comparisonSqrrl  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.
DescriptionEmbeddable document-store database library with JSON representation of queries (in MongoDB style)FairCom EDGE is an Industry 4.0 solution built to integrate, collect, aggregate and synchronize mission-critical data in edge computing environmentsMicrosoft Access combines a backend RDBMS (JET / ACE Engine) with a GUI frontend for data manipulation and queries. infoThe Access frontend is often used for accessing other datasources (DBMS, Excel, etc.)Open-Source SQL RDBMS for Operational and Analytical use cases with native Machine Learning, powered by Hadoop and SparkAdaptable, secure NoSQL built on Apache Accumulo
Primary database modelDocument storeKey-value store
Relational DBMS
Relational DBMSRelational DBMSDocument store
Graph DBMS
Key-value store
Wide column store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.14
Rank#307  Overall
#42  Document stores
Score0.05
Rank#338  Overall
#51  Key-value stores
#151  Relational DBMS
Score140.03
Rank#9  Overall
#6  Relational DBMS
Score0.92
Rank#191  Overall
#91  Relational DBMS
Websiteejdb.orgwww.faircom.com/­products/­faircomedge-iot-databasewww.microsoft.com/­en-us/­microsoft-365/­accesssplicemachine.comsqrrl.com
Technical documentationgithub.com/­Softmotions/­ejdb/­blob/­master/­README.mdlearn.faircomcorp.com/­developers/­documentation_directorydeveloper.microsoft.com/­en-us/­accessdoc.splicemachine.com
DeveloperSoftmotionsFairCom CorporationMicrosoftSplice MachineAmazon infooriginally Sqrrl Data, Inc.
Initial release20121979199220142012
Current releaseV3, October 20201902 (16.0.11328.20222), March 20193.1, March 2021
License infoCommercial or Open SourceOpen Source infoGPLv2commercial infoRestricted, free version availablecommercial infoBundled with Microsoft OfficeOpen Source infoAGPL 3.0, commercial license availablecommercial
Cloud-based only infoOnly available as a cloud servicenonononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCANSI C, C++C++JavaJava
Server operating systemsserver-lessAndroid
Linux infoARM, x86
Raspbian
Windows
Windows infoNot a real database server, but making use of DLLsLinux
OS X
Solaris
Windows
Linux
Data schemeschema-freeFlexible Schema (defined schema, partial schema, schema free)yesyesschema-free
Typing infopredefined data types such as float or dateyes infostring, integer, double, bool, date, object_idyes, ANSI Standard SQL Typesyesyesyes
XML support infoSome form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.yes
Secondary indexesnoyesyesyesyes
SQL infoSupport of SQLnoyes infoANSI SQL queriesyes infobut not compliant to any SQL standardyesno
APIs and other access methodsin-process shared libraryADO.NET
Direct SQL
IoT Microservice layer
JDBC
MQTT (Message Queue Telemetry Transport)
ODBC
RESTful HTTP API
ADO.NET
DAO
ODBC
OLE DB
JDBC
Native Spark Datasource
ODBC
Accumulo Shell
Java API
JDBC
ODBC
RESTful HTTP API
Thrift
Supported programming languagesActionscript
C
C#
C++
Go
Java
JavaScript (Node.js)
Lua
Objective-C
Pike
Python
Ruby
C
C#
C++
Java
JavaScript
PHP
Python
VB.Net
C
C#
C++
Delphi
Java (JDBC-ODBC)
VBA
Visual Basic.NET
C#
C++
Java
JavaScript (Node.js)
Python
R
Scala
Actionscript
C infousing GLib
C#
C++
Cocoa
Delphi
Erlang
Go
Haskell
Java
JavaScript
OCaml
Perl
PHP
Python
Ruby
Smalltalk
Server-side scripts infoStored proceduresnoyes info.Net, JavaScript, C/C++yes infosince Access 2010 using the ACE-engineyes infoJavano
Triggersnoyesyes infosince Access 2010 using the ACE-engineyesno
Partitioning methods infoMethods for storing different data on different nodesnoneFile partitioning infoCustomizable business rules for partitioningnoneShared Nothhing Auto-Sharding, Columnar PartitioningSharding infomaking use of Hadoop
Replication methods infoMethods for redundantly storing data on multiple nodesnoneyes infoSynchronous and asynchronous realtime replication based on transaction logsnoneMulti-source replication
Source-replica replication
selectable replication factor infomaking use of Hadoop
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononoYes, via Full Spark Integrationyes
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Tunable Consistency
Immediate ConsistencyImmediate Consistency infoDocument store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.
Foreign keys infoReferential integrityno infotypically not needed, however similar functionality with collection joins possibleyes infowhen using SQLyesyesno
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACID infobut no files for transaction loggingACIDAtomic updates per row, document, or graph entity
Concurrency infoSupport for concurrent manipulation of datayes infoRead/Write Lockingyes infoacross SQL and NoSQLyesyes, multi-version concurrency control (MVCC)yes
Durability infoSupport for making data persistentyesyesyes infobut no files for transaction loggingyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyes
User concepts infoAccess controlnoFine grained user, group and file access rights managed across SQL (per ANSI standard) and NoSQL.no infoa simple user-level security was built in till version Access 2003Access rights for users, groups and roles according to SQL-standardCell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)
More information provided by the system vendor
EJDBFaircom EDGE infoformerly c-treeEDGEMicrosoft AccessSplice MachineSqrrl
News

How to Break Data Silos to Drive Enterprise-Wide AI
11 June 2021

Point-in-Time Correctness in Machine Learning
1 June 2021

The Compliance Nightmare Lurking in Your Data Science Team
6 May 2021

Whose Job Is It Anyway?
23 April 2021

How Optimizing MLOps Can Revolutionize Enterprise AI
15 April 2021

We invite representatives of system vendors to contact us for updating and extending the system information,
and for displaying vendor-provided information such as key customers, competitive advantages and market metrics.

Related products and services

We invite representatives of vendors of related products to contact us for presenting information about their offerings here.

More resources
EJDBFaircom EDGE infoformerly c-treeEDGEMicrosoft AccessSplice MachineSqrrl
DB-Engines blog posts

MS Access drops in DB-Engines Ranking
2 May 2013, Paul Andlinger

Microsoft SQL Server regained rank 2 in the DB-Engines popularity ranking
3 December 2012, Matthias Gelbmann

New DB-Engines Ranking shows the popularity of database management systems
3 October 2012, Matthias Gelbmann, Paul Andlinger

show all

Recent citations in the news

Trend-Setting Products in Data and Information Management for 2022
8 December 2021, Database Trends and Applications

World's First Converged IIoT Hub to be Showcased at IoT Tech Expo
3 September 2021, Automation.com

provided by Google News

Data Use Specialist - Liberia
26 September 2022, ReliefWeb

Microsoft fixes Access apps failing to open after July updates
22 July 2022, BleepingComputer

Microsoft investigates July updates breaking Access applications
15 July 2022, BleepingComputer

Global Surge Team Roster: Health Coordinator
19 September 2022, ReliefWeb

The 12 Best Features of Microsoft Access for Database Management - MUO
9 December 2021, MakeUseOf

provided by Google News

Machine learning data pipeline outfit Splice Machine files for insolvency
26 August 2021, The Register

Splice Machine database travels full circle to predictive application platform
25 September 2017, ZDNet

Splice Machine Launches the Splice Machine Feature Store to Simplify Feature Engineering and Democratize Machine Learning
19 January 2021, PR Newswire

Unified MLOps: Feature Stores and Model Deployment
13 May 2022, InfoQ.com

Real-time Data and Database Design: Why You Should Sweat the Small Stuff
1 June 2022, RTInsights

provided by Google News

Financial awareness growing among millennials, says this survey; 47% respondents choose SIP as preferred in...
7 September 2022, Zee Business

Amazon's cloud business acquires Sqrrl, a security start-up with NSA roots
23 January 2018, CNBC

Bullsmart announces partnership with the Global Fintech Fest 2022
20 September 2022, First India

sqrrl Making NSA's Big Data Analytics More Accessible
11 March 2013, Data Center Knowledge

SIP is the most preferred investment avenue among millennials: Survey | Mint
16 August 2022, Mint

provided by Google News

Job opportunities

Account Manager
FairCom, Salt Lake City, UT

Account Manager
FairCom, Columbia, MO

Software Engineer (Hybrid)
FairCom, Salt Lake City, UT

QA Engineer (Hybrid)
FairCom, Salt Lake City, UT

Technical Account Manager
FairCom, Sandy, UT

MS Access Programer
Rattan Consulting, Oklahoma City, OK

Data Analyst - MS Access Programming
Super Micro Computer, Inc., San Jose, CA

Administrative Assistant
Occidental Petroleum Corporation, The Woodlands, TX

Investigator
UnitedHealthcare, Minnetonka, MN

Maintenance Planner-Fish-1st Shift-6:00am-3:30pm-$34.03
Conagra Brands, Jackson, TN

Hadoop Developer / Admin Jr
Unisoft Technology Inc., Gaithersburg, MD

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

Neo4j NODES 2022
Free online conference for developers and data scientists.
November 16/17 2022.
Register now for free!

Vertica logo

Vertica Accelerator. The fastest analytics and machine learning, delivered as SaaS, with automated setup, administration, and management. Free trial.

The definitive guide for Cassandra

Imagine What You Could Do if Scalability Wasn‘t a Problem!
Download the Cassandra e-book for free!

Redis logo

The world’s most loved real‑time data platform.
Try free

Present your product here