DBMS > BigObject vs. openGauss vs. Sphinx
System Properties Comparison BigObject vs. openGauss vs. Sphinx
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||BigObject Xexclude from comparison||openGauss Xexclude from comparison||Sphinx Xexclude from comparison|
|Description||Analytic DBMS for real-time computations and queries||An enterprise-class RDBMS compatible with high-performance, high-availability and high-performance originally developed by Huawei||Open source search engine for searching in data from different sources, e.g. relational databases|
|Primary database model||Relational DBMS a hierachical model (tree) can be imposed||Relational DBMS||Search engine|
|Secondary database models||Document store|
|Developer||BigObject, Inc.||Huawei and openGauss community||Sphinx Technologies Inc.|
|Current release||3.0, March 2022||3.5.1, February 2023|
|License Commercial or Open Source||commercial free community edition available||Open Source||Open Source GPL version 2, commercial licence available|
|Cloud-based only Only available as a cloud service||no||no||no|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Implementation language||C, C++, Java||C++|
|Server operating systems||Linux distributed as a docker-image|
OS X distributed as a docker-image (boot2docker)
Windows distributed as a docker-image (boot2docker)
|Typing predefined data types such as float or date||yes||yes||no|
|XML support Some form of processing data in XML format, e.g. support for XML data structures, and/or support for XPath, XQuery or XSLT.||no||no|
|Secondary indexes||yes||yes||yes full-text index on all search fields|
|SQL Support of SQL||SQL-like DML and DDL statements||ANSI SQL 2011||SQL-like query language (SphinxQL)|
|APIs and other access methods||fluentd|
RESTful HTTP API
|Supported programming languages||C|
|C++ unofficial client library|
Perl unofficial client library
Ruby unofficial client library
|Server-side scripts Stored procedures||Lua||yes||no|
|Partitioning methods Methods for storing different data on different nodes||none||horizontal partitioning (by range, list and hash)||Sharding Partitioning is done manually, search queries against distributed index is supported|
|Replication methods Methods for redundantly storing data on multiple nodes||none||Source-replica replication||none|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||no||no|
|Consistency concepts Methods to ensure consistency in a distributed system||none||Immediate Consistency|
|Foreign keys Referential integrity||yes automatically between fact table and dimension tables||yes||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID||no|
|Concurrency Support for concurrent manipulation of data||yes Read/write lock on objects (tables, trees)||yes||yes|
|Durability Support for making data persistent||yes||yes||yes The original contents of fields are not stored in the Sphinx index.|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||yes||no|
|User concepts Access control||no||Access rights for users, groups and roles according to SQL-standard||no|
More information provided by the system vendor
We invite representatives of system vendors to contact us for updating and extending the system information,
Related products and services
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|DB-Engines blog posts|
The DB-Engines ranking includes now search engines 软通动力：发布openGauss数据库商业发行版 软通动力天鹤数据库获开源社区认证持续深耕信创国产化 软通动力(301236.SZ)：发布openGauss数据库商业发行版 Centos 7 安装系列(8)：openGauss 3.0.0_你的凯子很吊的博客 晚间公告全知道：二连板精伦电子和华为没有业务往来，软通动力发布 ... provided by Google News The FAIR Cookbook - the essential resource for and by FAIR doers ... A Future Jewish President? The Pirate Bay was recently down for over a week due to a DDoS ... 7 Tips for Effective Communication with Chat AI Assistants Mark Hill: The future looks dim: Silicon Valley and the race to make ... provided by Google News
Centos 7 安装系列(8)：openGauss 3.0.0_你的凯子很吊的博客
provided by Google News
The FAIR Cookbook - the essential resource for and by FAIR doers ...
A Future Jewish President?
The Pirate Bay was recently down for over a week due to a DDoS ...
7 Tips for Effective Communication with Chat AI Assistants
Mark Hill: The future looks dim: Silicon Valley and the race to make ...
provided by Google News
Share this page