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 > Alibaba Cloud ApsaraDB for PolarDB vs. BigObject vs. Machbase vs. Manticore Search vs. Postgres-XL

System Properties Comparison Alibaba Cloud ApsaraDB for PolarDB vs. BigObject vs. Machbase vs. Manticore Search vs. Postgres-XL

Editorial information provided by DB-Engines
NameAlibaba Cloud ApsaraDB for PolarDB  Xexclude from comparisonBigObject  Xexclude from comparisonMachbase infoFormer name was Infiniflux  Xexclude from comparisonManticore Search  Xexclude from comparisonPostgres-XL  Xexclude from comparison
DescriptionA cloud-native relational database compatible with MySQL, PostgreSQL, and Oracle. Designed for business critical applications.Analytic DBMS for real-time computations and queriesTimeSeries DBMS for AIoT and BigDataMulti-storage database for search, including full-text search.Based on PostgreSQL enhanced with MPP and write-scale-out cluster features
Primary database modelRelational DBMSRelational DBMS infoa hierachical model (tree) can be imposedTime Series DBMSSearch engineRelational DBMS
Secondary database modelsTime Series DBMS infousing the Manticore Columnar LibraryDocument store
Spatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score0.63
Rank#216  Overall
#105  Relational DBMS
Score0.08
Rank#313  Overall
#141  Relational DBMS
Score0.03
Rank#331  Overall
#31  Time Series DBMS
Score0.08
Rank#311  Overall
#17  Search engines
Score0.72
Rank#204  Overall
#99  Relational DBMS
Websitewww.alibabacloud.com/­product/­polardbbigobject.iowww.machbase.commanticoresearch.comwww.postgres-xl.org
Technical documentationwww.alibabacloud.com/­help/­doc-detail/­58764.htmdocs.bigobject.ioendoc.machbase.commanual.manticoresearch.comwww.postgres-xl.org/­documentation
DeveloperAlibabaBigObject, Inc.MachbaseManticore Software
Initial release2015201320172014 infosince 2012, originally named StormDB
Current releaseV6.5, August 20214.2, December 202110 R1, October 2018
License infoCommercial or Open Sourcecommercialcommercial infofree community edition availablecommercial infofree test version availableOpen Source infoGPL version 2Open Source infoMozilla public license
Cloud-based only infoOnly available as a cloud serviceyesnononono
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageCC++C
Server operating systemshostedLinux infodistributed as a docker-image
OS X infodistributed as a docker-image (boot2docker)
Windows infodistributed as a docker-image (boot2docker)
Linux
Windows
FreeBSD
Linux
macOS
Windows
Linux
macOS
Data schemeyesyesyesFixed schemayes
Typing infopredefined data types such as float or dateyesyesyesInt, Bigint, Float, Timestamp, Bit, Int array, Bigint array, JSON, Booleanyes
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.yesnonoCan index from XMLyes infoXML type, but no XML query functionality
Secondary indexesyesyesyesyes infofull-text index on all search fieldsyes
SQL infoSupport of SQLyesSQL-like DML and DDL statementsSQL-like query languageSQL-like query languageyes infodistributed, parallel query execution
APIs and other access methodsJDBC
ODBC
fluentd
ODBC
RESTful HTTP API
HTTP REST
JDBC
ODBC
Binary API
RESTful HTTP/JSON API
RESTful HTTP/SQL API
SQL over MySQL
ADO.NET
JDBC
native C library
ODBC
streaming API for large objects
Supported programming languagesJava
Python
C
C#
C++
Java
JavaScript
PHP infovia ODBC
Python
R infovia ODBC
Scala
Elixir
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
.Net
C
C++
Delphi
Erlang
Java
JavaScript (Node.js)
Perl
PHP
Python
Tcl
Server-side scripts infoStored proceduresyesLuanouser defined functionsuser defined functions
Triggersyesnononoyes
Partitioning methods infoMethods for storing different data on different nodesSharding infoImplicit feature of the cloud servicenoneShardingSharding infoPartitioning is done manually, search queries against distributed index is supportedhorizontal partitioning
Replication methods infoMethods for redundantly storing data on multiple nodesyes infoImplicit feature of the cloud servicenoneselectable replication factorSynchronous replication based on Galera library
MapReduce infoOffers an API for user-defined Map/Reduce methodsnonononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencynoneImmediate Consistency
Foreign keys infoReferential integrityyesyes infoautomatically between fact table and dimension tablesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDnonoyes infoisolated transactions for atomic changes and binary logging for safe writesACID infoMVCC
Concurrency infoSupport for concurrent manipulation of datayesyes infoRead/write lock on objects (tables, trees)yesyesyes
Durability infoSupport for making data persistentyesyesnoyes infoThe original contents of fields are not stored in the Manticore index.yes
In-memory capabilities infoIs there an option to define some or all structures to be held in-memory only.yesyesyes infovolatile and lookup tableno
User concepts infoAccess controlfine grained access rights according to SQL-standardnosimple password-based access controlnofine grained access rights according to SQL-standard
More information provided by the system vendor
Alibaba Cloud ApsaraDB for PolarDBBigObjectMachbase infoFormer name was InfinifluxManticore SearchPostgres-XL
Specific characteristicsApsaraDB for PolarDB is a cloud-native relational database 100% compatible with MySQL...
» more
Machbase is an extremely fast time series database which processes large volumes...
» more
Competitive advantagesWebinar: Top Scientists Live: Tech Secrets to Double 11's Success Revealed. White...
» more
Fastest Database for IIoT, Independently verified, on Industry Standard Benchmarks....
» more
Typical application scenariosCreating a Robust Cloud-Based Database for Fintech, E-Commerce and Gaming. Learn...
» more
Distributed Query In Machbase Cluster Edition, a broker node, which is responsible...
» more
Key customersMachbase has over 50 customers, including Samsung, POSCO, and Hyundai.
» more
Market metricsReal-time data processing Real-time index creation Optimized DBMS for processing...
» more
Licensing and pricing modelsSpecification and pricing. You can use either of the following billing methods to...
» more
Machbase provide several product editions, including: Intelligent Edge Device, Fog...
» 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
Alibaba Cloud ApsaraDB for PolarDBBigObjectMachbase infoFormer name was InfinifluxManticore SearchPostgres-XL
Recent citations in the news

Alibaba Cloud’s growing clout in databases
21 January 2022, ComputerWeekly.com

Top Cloud Providers: Alibaba Cloud vs. AWS
6 October 2021, IT Business Edge

An introduction to Alibaba cloud offerings
28 September 2020, TechTarget

provided by Google News

MachBase Bests the Competition to Take Top Slot as Fastest IoT Database Ranks #1 in Industry standard TPCx-IoT Database Benchmark
20 November 2019, PR Web

provided by Google News

Build A Web Crawler with Search bar Using Wget and Manticore [A Step By Step Guide]
18 April 2020, hackernoon.com

How To Develop Your Custom Autocorrect Implementation with Manticore [A Step by Step Guide]
20 February 2020, hackernoon.com

provided by Google News

Building a scalable PostgreSQL solution
14 April 2019, Packt Hub

When PostgreSQL Doesn't Scale Well Enough
18 April 2016, DZone News

provided by Google News



Share this page

Featured Products

AllegroGraph logo

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

Datastax Astra logo

Build cloud-native apps fast with Astra, the open-source, multi-cloud stack for
modern data apps.
Get started with 80GB free.

Neo4j logo

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

MariaDB logo

SkySQL, the ultimate
MariaDB cloud, is here.

Get started with SkySQL today!

Couchbase logo

The modern database for enterprise applications. Build fast. Scale Big. Save more.
Get started today.

Present your product here