DB-EnginesDo you need a hard real time database?English
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > FileMaker vs. IBM Db2 vs. InterSystems Caché

System Properties Comparison FileMaker vs. IBM Db2 vs. InterSystems Caché

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFileMaker  Xexclude from comparisonIBM Db2 infoformerly named DB2 or IBM Database 2  Xexclude from comparisonInterSystems Caché  Xexclude from comparison
DescriptionFileMaker is a cross-platform RDBMS that includes a GUI frontend.Common in IBM host environments, 2 different versions for host and Windows/LinuxA multi-model DBMS and application server
Primary database modelRelational DBMSRelational DBMS infoSince Version 10.5 support for JSON/BSON documents compatible with MongoDBKey-value store
Object oriented DBMS
Relational DBMS
Secondary database modelsDocument store
RDF store infoin Db2 LUW (Linux, Unix, Windows)
Spatial DBMS infowith Db2 Spatial Extender
Document store
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score51.58
Rank#22  Overall
#14  Relational DBMS
Score159.19
Rank#7  Overall
#5  Relational DBMS
Score3.09
Rank#100  Overall
#18  Key-value stores
#1  Object oriented DBMS
#52  Relational DBMS
Websitewww.claris.com/­filemakerwww.ibm.com/­analytics/­db2www.intersystems.com/­products/­cache
Technical documentationwww.claris.com/­resources/­documentationwww.ibm.com/­support/­knowledgecenter/­SSEPGGdocs.intersystems.com
DeveloperFileMaker infoa subsidiary of AppleIBMInterSystems
Initial release19831983 infohost version1997
Current release19.4.1, November 202112.1, October 20162018.1.4, May 2020
License infoCommercial or Open Sourcecommercialcommercial infofree version is availablecommercial
Cloud-based only infoOnly available as a cloud servicenonono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC and C++
Server operating systemsiOS infoclient part only
Linux
OS X
Windows
AIX
HP-UX
Linux
Solaris
Windows
z/OS
AIX
HP Open VMS
HP-UX
Linux
OS X
Solaris
Windows
Data schemeyesyesdepending on used data model
Typing infopredefined data types such as float or dateyesyesyes
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 infoA http query request can return the data in XML formatyes
Secondary indexesyesyesyes
SQL infoSupport of SQLyes infovia pluginsyesyes
APIs and other access methodsFilemaker WebDirect
JDBC
ODBC
ADO.NET
JDBC
JSON style queries infoMongoDB compatible
ODBC
XQuery
.NET Client API
JDBC
ODBC
RESTful HTTP API
Supported programming languagesPHPC
C#
C++
Cobol
Delphi
Fortran
Java
Perl
PHP
Python
Ruby
Visual Basic
C#
C++
Java
Server-side scripts infoStored proceduresyesyesyes
Triggersyesyesyes
Partitioning methods infoMethods for storing different data on different nodesnoneSharding infoonly with Windows/Unix/Linux Versionnone
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replication, warm standby infosince Version 14yes infowith separate tools (MQ, InfoSphere)Source-replica replication
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate Consistency
Foreign keys infoReferential integrityyesyesyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanoACIDACID
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.yes
User concepts infoAccess controlsimple rights management via user accounts and connection to external directory servicesfine grained access rights according to SQL-standardAccess rights for users, groups and roles

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
FileMakerIBM Db2 infoformerly named DB2 or IBM Database 2InterSystems Caché
Recent citations in the news

Apple subsidiary Claris releases FileMaker 19.5 with new features and improvements
17 June 2022, 9to5Mac

Database Management Systems (DBMS) Market 2022 Industrial Analysis Of Key Players – FileMaker Inc., IBM, Tandem, Pervasive Software, NCR, etc – Indian Defence News
22 June 2022, Indian Defence News

Claris FileMaker Pro updated with Shortcuts support, more
17 November 2021, AppleInsider

Apple subsidiary Claris apologizes for hours-long FileMaker Cloud outage
15 December 2021, AppleInsider

Huge Growth of No-Code and Low-Code Development Platforms Software Market by 2029 | Appian, Quick Base, Kissflow – Indian Defence News
23 June 2022, Indian Defence News

provided by Google News

Wikibon: Enterprises must embrace real-time analytics
24 June 2022, SiliconANGLE News

GraphQL and NoSQL Databases: The Type Mismatch
27 May 2022, thenewstack.io

Transition from Legacy Databases to a Modern Data Architecture
14 June 2022, DevPro Journal

Db2, where are you? Big Blue is oddly reluctant to discuss recent enhancements to its flagship database
23 December 2021, The Register

Extending IBM i applications with cloud-based data analytics
7 June 2022, DatacenterDynamics

provided by Google News

InterSystems
22 December 2019, International Spectrum Magazine

Halfaker and Associates, LLC | US GAO
2 February 2022, Government Accountability Office

AWS, GCP, Oracle, Azure, SAP lead cloud DBMS market: Gartner
15 February 2022, CRN Australia

Multivalue Database Listing
22 July 2019, International Spectrum Magazine

provided by Google News

Job opportunities

Online Sales Assistant
Museum of Contemporary Art Chicago, Chicago, IL

HLN Packer
Huhtamaki Group, Los Angeles, CA

Production Assistant - YA Urban Fantasy
Tit Mouse Inc, Los Angeles, CA

Marketing & Social Media Coordinator, Charlotte Center
Wake Forest University, Charlotte, NC

Development Assistant for Development Operations
GBH Boston, Boston, MA

DB2 Database Programmer (REMOTE)
Kyndryl, Inc., Austin, TX

Mainframe DB2 Logical Database Administrator
Ensono, Remote

Mainframe DB2 Database Management
JPMorgan Chase Bank, N.A., Jersey City, NJ

Database Administrator
ActioNet, Remote

Mainframe DB2 Database Administrator
DMI, Washington, DC

Intersystems Cache ObjectScript Developer
Career Soft Solutions, Providence, RI

Test Engineer
Initiate Government Solutions, Remote

Client/Server Programmer Associate (Work From Home - USA)
Geisinger, Danville, PA

Software Developer
Initiate Government Solutions, Remote

Web Developer (Cache)
The Evolvers Group, Tallahassee, FL

jobs by Indeed



Share this page

Featured Products

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Neo4j logo

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

The definitive guide for Cassandra

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

Vertica logo

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

Redis logo

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

Present your product here