DB-EnginesExtremeDB: benchmark about the mission critical dbmsEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > FileMaker vs. OpenSearch vs. SiteWhere

System Properties Comparison FileMaker vs. OpenSearch vs. SiteWhere

Please select another system to include it in the comparison.

Editorial information provided by DB-Engines
NameFileMaker  Xexclude from comparisonOpenSearch  Xexclude from comparisonSiteWhere  Xexclude from comparison
DescriptionFileMaker is a cross-platform RDBMS that includes a GUI frontend.A distributed, RESTful search and analytics engine forked from Elasticsearch and based on Apache LuceneM2M integration platform for persisting/querying time series data
Primary database modelRelational DBMSSearch engineTime Series DBMS
Secondary database modelsVector DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score54.18
Rank#21  Overall
#15  Relational DBMS
Score13.60
Rank#42  Overall
#4  Search engines
Score0.15
Rank#362  Overall
#35  Time Series DBMS
Websitewww.claris.com/­filemakergithub.com/­opensearch-project
opensearch.org
sitewhere.io
Technical documentationwww.claris.com/­resources/­documentationopensearch.org/­docs/­latestsitewhere.io/­docs/­2.1.0
DeveloperFileMaker infoa subsidiary of AppleAmazon Web ServicesSiteWhere
Initial release198320212010
Current release19.4.1, November 20212.5.0, January 2023
License infoCommercial or Open SourcecommercialOpen Source infoApache Version 2.0Open Source infoCommon Public Attribution License Version 1.0
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.
Aiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
Implementation languageJavaJava
Server operating systemsiOS infoclient part only
Linux
OS X
Windows
All OS with a Java VMLinux
OS X
Windows
Data schemeyesschema-free infoFlexible type definitions. Once a type is defined, it is persistentpredefined scheme
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 formatno
Secondary indexesyesyes infoAll search fields are automatically indexedno
SQL infoSupport of SQLyes infovia pluginsSQL-like query languageno
APIs and other access methodsFilemaker WebDirect
JDBC
ODBC
Java API
RESTful HTTP/JSON API
HTTP REST
Supported programming languagesPHPGo
Java
JavaScript (Node.js)
PHP
Python
Ruby infoElasticsearch client
Server-side scripts infoStored proceduresyesyes
Triggersyesyes infoby using the 'percolation' feature
Partitioning methods infoMethods for storing different data on different nodesnoneShardingSharding infobased on HBase
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replication, warm standby infosince Version 14yesselectable replication factor infobased on HBase
MapReduce infoOffers an API for user-defined Map/Reduce methodsnono
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency infoSynchronous doc based replication. Get by ID may show delays up to 1 sec. Configurable write consistency: one, quorum, allImmediate Consistency
Foreign keys infoReferential integrityyesnono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datanonono
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.no
User concepts infoAccess controlsimple rights management via user accounts and connection to external directory servicesUsers with fine-grained authorization concept
More information provided by the system vendor
FileMakerOpenSearchSiteWhere
Specific characteristicsOpenSearch is a highly scalable and extensible open-source software suite for search,...
» more
Competitive advantagesDistributed as fully open source under Apache License, Version 2.0 (ALv2), OpenSearch...
» more
Typical application scenariosThe OpenSearch platform is used across a broad range of search , analytics, and observability...
» more
Licensing and pricing modelsThe OpenSearch Project offers open source software licensed under Apache License...
» more

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
3rd partiesAiven for OpenSearch: Fully managed open source search and analytics suite. Out-of-the-box integrations get you up and running in a couple of clicks.
» more

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

More resources
FileMakerOpenSearchSiteWhere
Recent citations in the news

Case47 山形大学医学部附属病院 植込みデバイスの診療をFileMaker ...
1 December 2023, インナビネット

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

Claris FileMaker Pro & FileMaker Server updated with macOS Ventura compatibility
30 November 2022, AppleInsider

An Apple subsidiary once led by legendary Silicon Valley 'coach' Bill Campbell is getting a complete rebrand
6 August 2019, CNBC

Apple subsidiary Claris releases FileMaker 19.5 update
17 June 2022, 9to5Mac

provided by Google News

Amazon DynamoDB Zero-ETL Integration Now Available with ...
30 November 2023, Database Trends and Applications

AWS-Announces-Four-Zero-ETL-Integrations-to-Make-Data-Access ...
28 November 2023, Amazon Press Release

AWS Adds Vector Capabilities to More Databases
30 November 2023, Datanami

Navigating the cloud landscape: Innovations and insights from ...
30 November 2023, SiliconANGLE News

AWS 'standing at the edge of a new technical era'
29 November 2023, ARNnet

provided by Google News

Ten Popular IoT Platforms You Should be Aware of
27 March 2023, Open Source For You

How Oil and Gas Industry can Benefit from Open Source Software
2 May 2023, Open Source For You

67 open source tools and resources for the Internet of Things (IoT)
23 January 2019, TechBeacon

IoT Platform Market To Reach USD 21.55 Billion, Expanding at ...
11 October 2022, GlobeNewswire

Industry 4.0 and Embedded Internet of Things: An Introduction
26 December 2022, Open Source For You

provided by Google News

Job opportunities

Ebook Production Associate (Open to Remote)
Penguin Random House LLC, New York, NY

Managing Editorial Assistant, Berkley (Open to Remote)
Penguin Random House LLC, New York, NY

Festival Programming Assistant
SIFF, Seattle, WA

Talent Booking Assistant
The Talent, Los Angeles, CA

Newsreel Assistant
UCLA, Los Angeles, CA

Staff Data Scientist
ThredUp Inc., Oakland, CA

Senior Member of Technical Staff: OpenSearch/OCI
Oracle, United States

Senior Linux Systems Administrator
FriendFinder Networks, Remote

Support Engineer, Tier 3
Ringba: Culture, Values, & Careers, Remote

Jaspersoft/Applications Developer - Secret Clearance
Blu Omega, Remote

jobs by Indeed



Share this page

Featured Products

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

SingleStore logo

Build AI apps with Vectors on SQL and JSON with milliseconds response times.
Try it today.

Neo4j logo

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

Redis logo

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

Present your product here