DB-EnginesExtremeDB for everyone with an RTOSEnglish
Deutsch
Knowledge Base of Relational and NoSQL Database Management Systemsprovided by solid IT

DBMS > Cubrid vs. Firebird vs. HEAVY.AI vs. PieCloudDB vs. Snowflake

System Properties Comparison Cubrid vs. Firebird vs. HEAVY.AI vs. PieCloudDB vs. Snowflake

Editorial information provided by DB-Engines
NameCubrid  Xexclude from comparisonFirebird  Xexclude from comparisonHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022  Xexclude from comparisonPieCloudDB  Xexclude from comparisonSnowflake  Xexclude from comparison
DescriptionCUBRID is an open-source SQL-based relational database management system with object extensions for OLTPFirebird is an open source RDBMS forked from Borland's InterBaseA high performance, column-oriented RDBMS, specifically developed to harness the massive parallelism of modern CPU and GPU hardwareA cloud-native analytic database platform with new technologoy for elastic MPPCloud-based data warehousing service for structured and semi-structured data
Primary database modelRelational DBMSRelational DBMSRelational DBMSRelational DBMSRelational DBMS
Secondary database modelsSpatial DBMS
DB-Engines Ranking infomeasures the popularity of database management systemsranking trend
Trend Chart
Score1.20
Rank#169  Overall
#78  Relational DBMS
Score20.82
Rank#30  Overall
#18  Relational DBMS
Score1.77
Rank#141  Overall
#65  Relational DBMS
Score0.25
Rank#304  Overall
#138  Relational DBMS
Score121.33
Rank#9  Overall
#6  Relational DBMS
Websitecubrid.com (korean)
cubrid.org (english)
www.firebirdsql.orggithub.com/­heavyai/­heavydb
www.heavy.ai
www.openpie.comwww.snowflake.com
Technical documentationcubrid.org/­manualswww.firebirdsql.org/­en/­reference-manualsdocs.heavy.aidocs.snowflake.net/­manuals/­index.html
DeveloperCUBRID Corporation, CUBRID FoundationFirebird FoundationHEAVY.AI, Inc.OpenPieSnowflake Computing Inc.
Initial release20082000 infoAs fork of Borland's InterBase20162014
Current release11.0, January 20215.0.0, January 20245.10, January 20222.1, January 2023
License infoCommercial or Open SourceOpen Source infoApache Version 2.0Open Source infoInitial Developer's Public LicenseOpen Source infoApache Version 2; enterprise edition availablecommercialcommercial
Cloud-based only infoOnly available as a cloud servicenononoyesyes
DBaaS offerings (sponsored links) infoDatabase as a Service

Providers of DBaaS offerings, please contact us to be listed.
Implementation languageC, C++, JavaC and C++C++ and CUDA
Server operating systemsLinux
Windows
AIX
FreeBSD
HP-UX
Linux
OS X
server-less infoFirebird Embedded Server
Solaris
Unix
Windows
Linuxhostedhosted
Data schemeyesyesyesyesyes infosupport of semi-structured data formats (JSON, XML, Avro)
Typing infopredefined data types such as float or dateyesyesyesyesyes
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.nonoyes
Secondary indexesyesyesnoyes
SQL infoSupport of SQLyesyesyesyesyes
APIs and other access methodsADO.NET
JDBC
ODBC
OLE DB
ADO.NET
C/C++ API
JDBC infoJaybird
ODBC
OLE DB
JDBC
ODBC
Thrift
Vega
CLI Client
JDBC
ODBC
CLI Client
JDBC
ODBC
Supported programming languagesC
C#
C++
Go
Java
JavaScript (Node.js)
Perl
PHP
Python
Ruby
C
C#
C++
Delphi
Java
JavaScript infoNode.js
Lua
Perl
PHP
Python
Ruby
All languages supporting JDBC/ODBC/Thrift
Python
Java
PL/SQL
Python
R
JavaScript (Node.js)
Python
Server-side scripts infoStored proceduresJava Stored ProceduresPSQLnouser defined functionsuser defined functions
Triggersyesyesnonono infosimilar concept for controling cloud resources
Partitioning methods infoMethods for storing different data on different nodesnonenoneSharding infoRound robinyesyes
Replication methods infoMethods for redundantly storing data on multiple nodesSource-replica replicationSource-replica replicationMulti-source replicationyesyes
MapReduce infoOffers an API for user-defined Map/Reduce methodsnononono
Consistency concepts infoMethods to ensure consistency in a distributed systemImmediate ConsistencyImmediate ConsistencyImmediate ConsistencyImmediate Consistency
Foreign keys infoReferential integrityyesyesnonoyes
Transaction concepts infoSupport to ensure data integrity after non-atomic manipulations of dataACIDACIDnoACIDACID
Concurrency infoSupport for concurrent manipulation of datayesyes infoFeatures a multi-generational MVCC architecture, readers do not block writersyesyesyes
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.noyesno
User concepts infoAccess controlfine grained access rights according to SQL-standardUsers with fine-grained authorization conceptfine grained access rights according to SQL-standardUser Roles and pluggable authentication with full SQL StandardUsers with fine-grained authorization concept, user roles and pluggable authentication
More information provided by the system vendor
CubridFirebirdHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022PieCloudDBSnowflake
Specific characteristicsPieCloudDB, OpenPie's flagship product, is a cutting-edge cloud-native data warehouse....
» more
Competitive advantagesExtreme Elastic: PieCloudDB utilizes a cutting-edge eMPP cloud-native architecture...
» more
Typical application scenariosPieCloudDB is ideal for Data mining applications that require extreme scalability...
» more
Key customersSail-Cloud China Shipbuilding Group Haizhou System Soochow Securities ​etc.,
» more
Licensing and pricing modelsPieCloudDB Community Edition: Community License, Free Download, Self-Hosted Deployment;...
» 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 partiesCData: Connect to Big Data & NoSQL through standard Drivers.
» more

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

More resources
CubridFirebirdHEAVY.AI infoFormerly named 'OmniSci', rebranded to 'HEAVY.AI' in March 2022PieCloudDBSnowflake
DB-Engines blog posts

Snowflake is the DBMS of the Year 2022, defending the title from last year
3 January 2023, Matthias Gelbmann, Paul Andlinger

Snowflake is the DBMS of the Year 2021
3 January 2022, Paul Andlinger, Matthias Gelbmann

show all

Recent citations in the news

12 Top Open Source Databases to Consider
1 May 2024, TechTarget

DoNot Team's New Firebird Backdoor Hits Pakistan and Afghanistan
23 October 2023, The Hacker News

Exploring the Firebird Database
9 August 2023, Open Source For You

Top Databases for Artificial Intelligence, IoT, Deep Learning, Machine Learning, Data Science, and Other Software Applications
23 July 2023, MarkTechPost

Top 15 Databases to Use in 2024 and Beyond
4 June 2021, Appinventiv

provided by Google News

Big Data Analytics: A Game Changer for Infrastructure
13 July 2023, Spiceworks News and Insights

HEAVY.AI Launches HEAVY 7.0, Introducing Real-Time Machine Learning Capabilities
19 April 2023, Business Wire

Making the most of geospatial intelligence
14 April 2023, InfoWorld

OmniSci Gets HEAVY New Name and New CEO
1 March 2022, Datanami

The insideBIGDATA IMPACT 50 List for Q4 2023
11 October 2023, insideBIGDATA

provided by Google News

云上Index:看「简墨」如何为云原生打造全新索引
2 August 2023, blog.csdn.net

provided by Google News

Snowflake Ventures invests in Metaplane to ensure trust in data across the Data Cloud
15 May 2024, PR Newswire

Persistent & Snowflake Partner Up: Are You Ready for Next-Level Data Analytics?
20 May 2024, DATAQUEST

Persistent Achieves Premier Services Partner Status with Snowflake, Boosting Data Management and Analytics ...
16 May 2024, Yahoo Finance

PurpleCube AI partners with Snowflake to Revolutionize Data Engineering with Next-Generation AI and Machine ...
15 May 2024, Business Wire

Snowflake Data Clean Rooms Democratize Secure Data Sharing Across Clouds
24 April 2024, Acceleration Economy

provided by Google News



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

Neo4j logo

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

SingleStore logo

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

RaimaDB logo

RaimaDB, embedded database for mission-critical applications. When performance, footprint and reliability matters.
Try RaimaDB for free.

Milvus logo

Vector database designed for GenAI, fully equipped for enterprise implementation.
Try Managed Milvus for Free

Present your product here