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

DBMS > CrateDB vs. FileMaker vs. LMDB vs. Milvus vs. Oracle NoSQL

System Properties Comparison CrateDB vs. FileMaker vs. LMDB vs. Milvus vs. Oracle NoSQL

Editorial information provided by DB-Engines
NameCrateDB  Xexclude from comparisonFileMaker  Xexclude from comparisonLMDB  Xexclude from comparisonMilvus  Xexclude from comparisonOracle NoSQL  Xexclude from comparison
DescriptionDistributed Date Store based on LuceneFileMaker is a cross-platform RDBMS that includes a GUI frontend.A high performant, light-weight, embedded key-value database libraryA DBMS designed for efficient storage of vector data and vector similarity searchesA multi-model, scalable, distributed NoSQL database, designed to provide highly reliable, flexible, and available data management across a configurable set of storage nodes
Primary database modelRelational DBMS
Search engine
Relational DBMSKey-value storeSearch engineDocument store
Key-value store
Relational DBMS
Secondary database modelsDocument store
Time Series DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.94
Rank#183  Overall
#88  Relational DBMS
#13  Search engines
Score53.12
Rank#23  Overall
#15  Relational DBMS
Score2.57
Rank#112  Overall
#21  Key-value stores
Score0.37
Rank#264  Overall
#18  Search engines
Score4.38
Rank#86  Overall
#16  Document stores
#14  Key-value stores
#45  Relational DBMS
Websitecrate.iowww.claris.com/­filemakerwww.symas.com/­symas-embedded-database-lmdbmilvus.iowww.oracle.com/­database/­technologies/­related/­nosql.html
Technical documentationcrate.io/­docswww.claris.com/­resources/­documentationmilvus.io/­docs/­overview.mddocs.oracle.com/­en/­database/­other-databases/­nosql-database/­index.html
DeveloperCrateFileMaker infoa subsidiary of AppleSymasOracle
Initial release20131983201120192011
Current release19.4.1, November 20210.9.29, March 20212.0, January 202222.2, August 2022
License infoCommercial or Open SourceOpen SourcecommercialOpen SourceOpen Source infoApache Version 2.0Open Source infoProprietary for Enterprise Edition (Oracle Database EE license has Oracle NoSQL database EE covered: details)
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 languageJavaCC++, GoJava
Server operating systemsAll OS with a Java 7 (and higher) VMiOS infoclient part only
Linux
OS X
Windows
Linux
macOS info10.14 or later
Windows infowith WSL 2 enabled
Linux
Solaris SPARC/x86
Data schemeFlexible Schema (defined schema, partial schema, schema free)yesschema-freeSupport Fixed schema and Schema-less deployment with the ability to interoperate between them.
Typing infopredefined data types such as float or dateyesyesNumeric and Stringoptional
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 formatnonono
Secondary indexesyesyesnonoyes
SQL infoSupport of SQLyes, but no triggers and constraintsyes infovia pluginsnonoSQL-like DML and DDL statements
APIs and other access methodsADO.NET infocommunity maintained client
JDBC
MQTT (Message Queue Telemetry Transport)
PostgreSQL wire protocol
Prometheus Remote Read/Write
RESTful HTTP API
Filemaker WebDirect
JDBC
ODBC
RESTful HTTP APIRESTful HTTP API
Supported programming languagesErlang
Go infocommunity maintained client
Java
JavaScript (Node.js) infocommunity maintained client
Perl infocommunity maintained client
PHP
Python
Ruby infocommunity maintained client
Scala infocommunity maintained client
PHPCC++
Go
Java
JavaScript (Node.js)
Python
C
C#
Go
Java
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresuser defined functionsyesnonono
Triggersnoyesnonono
Partitioning methods infoMethods for storing different data on different nodesShardingnonenoneShardingSharding
Replication methods infoMethods for redundantly storing data on multiple nodesselectable replication factorSource-replica replication, warm standby infosince Version 14noneElectable source-replica replication per shard. Support distributed global deployment with Multi-region table feature
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononowith Hadoop integration
Consistency concepts infoMethods to ensure consistency in a distributed systemEventual Consistency
Read Your Own Writes Consistency infofor primary key lookups
Immediate ConsistencyBounded Staleness
Eventual Consistency
Immediate Consistency
Session Consistency
Tunable Consistency
Eventual Consistency
Immediate Consistency infodepending on configuration
Foreign keys infoReferential integritynoyesnonono
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of datano infounique row identifiers can be used for implementing an optimistic concurrency control strategynoACIDnoconfigurable infoACID within a storage node (=shard)
Concurrency infoSupport for concurrent manipulation of datayesyesyesyesyes
Durability infoSupport for making data persistentyesyesyesyesyes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.noyesnoyes infooff heap cache
User concepts infoAccess controlrights management via user accountssimple rights management via user accounts and connection to external directory servicesnonoAccess rights for users and roles
More information provided by the system vendor
CrateDBFileMakerLMDBMilvusOracle NoSQL
Specific characteristicsCrateDB is an open source distributed SQL database that spreads data and processing...
» more
Milvus is an open-source and cloud-native vector database built for production-ready...
» more
Competitive advantagesCrateDB is typically used in operational analytics applications, particularly those...
» more
Highly available, versatile, and robust with millisecond latency. Supports batch...
» more
Typical application scenariosCrateDB is ideal for integrating and analyzing streams of data--often machine-generated--in...
» more
Video media : video understanding, video deduplication. E-commerce and mobile applications...
» more
Key customersCrateDB customers include McAfee, Qualtrics , Nokia, NBC Golfnow , Digital Domain...
» more
Milvus is trusted by over 1,000 enterprises, including Baidu, eBay, IKEA, LINE, Shopee,...
» more
Market metricsThe CrateDB open source project was started in 2014. CrateDB was the winner of TechCrunch...
» more
As of March 2022, 9.8k+ GitHub stars 1.4k+ Github forks 871k+ docker pulls 2k+ community...
» more
Licensing and pricing modelsCrateDB pricing CrateDB Community Edition is open source and free to use under the...
» more
Milvus was released under the open-source Apache License 2.0 in October 2019. Managed...
» 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

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

More resources
CrateDBFileMakerLMDBMilvusOracle NoSQL
Recent citations in the news

CrateDB 4.5 takes distributed SQL database open source
24 March 2021, TechTarget

Crate.io Launches New Tier Model for CrateDB Cloud
28 June 2022, Datanami

Crate.io raises $10M to grow its database platform
15 June 2021, VentureBeat

Crate.io extends database service offering to Google Cloud
13 April 2022, VentureBeat

Crate.io Announces CrateDB Will Switch to an Elasticsearch Fork Following License Change
11 February 2021, GlobeNewswire

provided by Google News

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

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

Rapid Mobile App Development Tools Market 2022 Is Growing Worldwide | Neptune Software, FileMaker, WaveMaker, Ionic
19 August 2022, Digital Journal

Filemaker Pro Updated For Apple Silicon
24 September 2021, GlobeNewswire

provided by Google News

The Lightning Memory-mapped Database
2 March 2016, InfoQ.com

Jaxon Repp on HarperDB Distributed Database Platform
23 March 2022, InfoQ.com

Akamai launches managed database service – Blocks and Files
25 April 2022, Blocks and Files

Predictive blood biomarkers of sheep pregnancy and litter size | Scientific Reports
20 June 2022, Nature.com

Connecting the worlds of metabolomics databases
15 June 2021, Medical Xpress

provided by Google News

Zilliz Announces Key Contributions to Milvus 2.1, the Leading Open-Source Vector Database for Structured and Unstructured Data
3 August 2022, Business Wire

Database technology evolves to combine machine learning and data storage
7 March 2022, VentureBeat

What Is Vector Similarity Search? | Business Applications of Vector Search
11 August 2021, CIO Insight

The Recommendation System
15 February 2022, News | Europeana Pro

Black Kites on a flyway between Western Siberia and the Indian Subcontinent | Scientific Reports
2 April 2022, Nature.com

provided by Google News

Oracle and Microsoft Rolling Out Database Service for Azure
25 July 2022, Datamation

Oracle NoSQL database comes to the cloud
2 April 2020, TechTarget

Oracle NoSQL Database
28 March 2022, TechTarget

Oracle, Uni. Of Mauritius develop breast cancer awareness app
21 April 2022, Africanews English

Oracle Beefs Up Its NoSQL Database Offering
3 April 2014, Data Center Knowledge

provided by Google News

Job opportunities

Senior Cloud Operations Engineer
Aptos, Atlanta, GA

Senior FileMaker Developer
Skeleton Key, St. Louis, MO

HLN Packer
Huhtamaki Group, Los Angeles, CA

Packer
Huhtamaki Group, Los Angeles, CA

Education Assistant
Asian Art Museum Foundation, San Francisco, CA

Customer Service Representative
NCCER, Gainesville, FL

Senior SAP Basis and Security Administrator
Faraday Future, Gardena, CA

Senior SAP Basis and Security Administrator
Faraday Future, Inc., Gardena, CA

Cybersecurity III
Oasis Systems LLC, Dayton, OH

Cyber Security Engineer 3
USfalcon, Inc., Dayton, OH

Cyber Security Engineer III (ISSM)
Bigbear.ai, Dayton, OH

Director of Developer Relations
Hire io, Remote

Talent Acquisition Lead
Zilliz, San Francisco, CA

Head of Developer Relations
Zilliz, San Francisco, CA

High Performance Computing Engineer
Zilliz, San Francisco, CA

Head of Product Management
Zilliz, San Francisco, CA

Backend Software Engineer
Snappyhires, Remote

Front End Engineer
Averoinc.com, Remote

Front End Engineer
Avero, Remote

Data Engineer, AWS, FSx for Lustre
Amazon Data Services, Inc., Texas

UI Developer
Zachary Piper Solutions, Remote

jobs by Indeed



Share this page

Featured Products

Neo4j logo

The right graph database.
Not a graph add-on.
Free forever.
Start solving today

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

The definitive guide for Cassandra

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

AllegroGraph logo

Graph Database Leader for AI Knowledge Graph Applications - The Most Secure Graph Database Available.
Free Download

Redis logo

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

Present your product here