DB-EnginesextremeDB - solve IoT connectivity disruptionsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by Redgate Software

DBMS > Apache Spark (SQL) vs. FileMaker vs. Google Cloud Datastore

System Properties Comparison Apache Spark (SQL) vs. FileMaker vs. Google Cloud Datastore

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameApache Spark (SQL)  Xexclude from comparisonFileMaker  Xexclude from comparisonGoogle Cloud Datastore  Xexclude from comparison
DescriptionApache Spark SQL is a component on top of 'Spark Core' for structured data processingFileMaker is a cross-platform RDBMS that includes a GUI frontend.Automatically scaling NoSQL Database as a Service (DBaaS) on the Google Cloud Platform
Primary database modelRelational DBMSRelational DBMSDocument store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score18.45
Rank#31  Overall
#19  Relational DBMS
Score40.22
Rank#21  Overall
#14  Relational DBMS
Score3.69
Rank#71  Overall
#12  Document stores
Websitespark.apache.org/­sqlwww.claris.com/­filemakercloud.google.com/­datastore
Technical documentationspark.apache.org/­docs/­latest/­sql-programming-guide.htmlwww.claris.com/­resources/­documentationcloud.google.com/­datastore/­docs
DeveloperApache Software FoundationClaris infoa subsidiary of AppleGoogle
Initial release201419832008
Current release3.5.0 ( 2.13), September 202319.4.1, November 2021
License infoCommercial or Open SourceOpen Source infoApache 2.0commercialcommercial
Cloud-based only infoOnly available as a cloud servicenonoyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageScala
Server operating systemsLinux
OS X
Windows
iOS infoclient part only
Linux
OS X
Windows
hosted
Data schemeyesyesschema-free
Typing infopredefined data types such as float or dateyesyesyes, details here
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.noyes infoA http query request can return the data in XML formatno
Secondary indexesnoyesyes
SQL infoSupport of SQLSQL-like DML and DDL statementsyes infovia pluginsSQL-like query language (GQL)
APIs and other access methodsJDBC
ODBC
Filemaker WebDirect
JDBC
ODBC
gRPC (using protocol buffers) API
RESTful HTTP/JSON API
Supported programming languagesJava
Python
R
Scala
PHP.Net
Go
Java
JavaScript (Node.js)
PHP
Python
Ruby
Server-side scripts infoStored proceduresnoyesusing Google App Engine
TriggersnoyesCallbacks using the Google Apps Engine
Partitioning methods infoMethods for storing different data on different nodesyes, utilizing Spark CorenoneSharding
Replication methods infoMethods for redundantly storing data on multiple nodesnoneSource-replica replication, warm standby infosince Version 14Multi-source replication using Paxos
MapReduce infoOffers an API for user-defined Map/Reduce methodsnoyes infousing Google Cloud Dataflow
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency or Eventual Consistency depending on type of query and configuration infoStrong Consistency is default for entity lookups and queries within an Entity Group (but can instead be made eventually consistent). Other queries are always eventual consistent.
Foreign keys infoReferential integritynoyesyes infovia ReferenceProperties or Ancestor paths
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonoACID infoSerializable Isolation within Transactions, Read Committed outside of Transactions
Concurrency infoSupport for concurrent manipulation of datayesyesyes
Durability infoSupport for making data persistentyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.nono
User concepts infoAccess controlnosimple rights management via user accounts and connection to external directory servicesAccess rights for users, groups and roles based on Google Cloud Identity and 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,
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
Apache Spark (SQL)FileMakerGoogle Cloud Datastore
Recent citations in the news

How to run Pandas code on Spark
25 January 2025, Theodo UK

Introducing generative AI troubleshooting for Apache Spark in AWS Glue (preview)
22 November 2024, AWS Blog

18 Top Big Data Tools and Technologies to Know About in 2025
22 January 2025, TechTarget

Cracking the Apache Spark Interview: 80+ Top Questions and Answers for 2025
12 November 2024, Simplilearn

Query Execution Optimization in Spark SQL - Ji - 2020 - Scientific Programming
13 June 2024, Wiley Online Library

provided by Google News

Problemista - Features
1 March 2024, Reverse Shot

Claris’s Plans for FileMaker Bode Well for Individual Users
23 August 2022, TidBITS

Claris FileMaker Pro 19 review
2 March 2022, TechRadar

Claris launches the last-ever annual FileMaker Pro release
20 May 2020, AppleInsider

Tilda Swinton on 'Problemista' Fan Horror Stories About Her Character
1 March 2024, IndieWire

provided by Google News

AWS vs Azure vs Google Cloud in 2025: Cloud Comparison
23 December 2024, Cloudwards

17 Top Cloud Storage Companies to Know
9 April 2024, Built In

Cloud Storage pricing
23 September 2014, cloud.google.com

NetApp Cloud Volumes Service datastore support for Google Cloud VMware Engine
7 February 2023, NetApp

Your Memories. Their Cloud. (Published 2022)
1 January 2023, The New York Times

provided by Google News



Share this page

Featured Products

Neo4j logo

See for yourself how a graph database can make your life easier.
Use Neo4j online for free.

Datastax Astra logo

Bring all your data to Generative AI applications with vector search enabled by the most scalable
vector database available.
Try for Free

SingleStore logo

The data platform to build your intelligent applications.
Try it free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Present your product here