DBMS > Drizzle vs. Netezza vs. Snowflake
System Properties Comparison Drizzle vs. Netezza vs. Snowflake
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||Drizzle Xexclude from comparison||Netezza Also called PureData System for Analytics by IBM Xexclude from comparison||Snowflake Xexclude from comparison|
|Drizzle has published its last release in September 2012. The open-source project is discontinued and Drizzle is excluded from the DB-Engines ranking.|
|Description||MySQL fork with a pluggable micro-kernel and with an emphasis of performance over compatibility.||Data warehouse and analytics appliance part of IBM PureSystems||Cloud-based data warehousing service for structured and semi-structured data|
|Primary database model||Relational DBMS||Relational DBMS||Relational DBMS|
|Developer||Drizzle project, originally started by Brian Aker||IBM||Snowflake Computing Inc.|
|Current release||7.2.4, September 2012|
|License Commercial or Open Source||Open Source GNU GPL||commercial||commercial|
|Cloud-based only Only available as a cloud service||no||no||yes|
|DBaaS offerings (sponsored links) Database as a Service|
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems||FreeBSD|
|Linux included in appliance||hosted|
|Data scheme||yes||yes||yes support of semi-structured data formats (JSON, XML, Avro)|
|Typing predefined data types such as float or date||yes||yes||yes|
|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.||yes|
|SQL Support of SQL||yes with proprietary extensions||yes||yes|
|APIs and other access methods||JDBC||JDBC|
|Supported programming languages||C|
|Server-side scripts Stored procedures||no||yes||user defined functions|
|Triggers||no hooks for callbacks inside the server can be used.||no||no similar concept for controling cloud resources|
|Partitioning methods Methods for storing different data on different nodes||Sharding||Sharding||yes|
|Replication methods Methods for redundantly storing data on multiple nodes||Multi-source replication|
|MapReduce Offers an API for user-defined Map/Reduce methods||no||yes||no|
|Consistency concepts Methods to ensure consistency in a distributed system||Immediate Consistency|
|Foreign keys Referential integrity||yes||no||yes|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||ACID||ACID||ACID|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.||no|
|User concepts Access control||Pluggable authentication mechanisms e.g. LDAP, HTTP||Users with fine-grained authorization concept||Users with fine-grained authorization concept, user roles and pluggable authentication|
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|
|3rd parties||SQLFlow: Provides a visual representation of the overall flow of data. Automated SQL data lineage analysis across Databases, ETL, Business Intelligence, Cloud and Hadoop environments by parsing SQL Script and stored procedure.|
CData: Connect to Big Data & NoSQL through standard Drivers.
DBHawk: Secure access to SQL, NoSQL and Cloud databases with an all-in-one solution.
We invite representatives of vendors of related products to contact us for presenting information about their offerings here.
|Drizzle||Netezza Also called PureData System for Analytics by IBM||Snowflake|
|DB-Engines blog posts|
MySQL won the April ranking; did its forks follow?
|Recent citations in the news|
IBM Brings Back a Netezza, Attacks Yellowbrick
Accelerated Databases In The Fast Lane
IBM's New Deal: What the Heck is Netezza?
Yellowbrick shows that its data warehouse is not smoke and mirrors
IBM to Acquire Netezza for $1.78 Billion
provided by Google News
Snowflake launches Financial Services Data Cloud, touts big customer wins
Snowflake helps financial services organizations leverage data to drive business growth
Up 70% From May Lows, Is Snowflake Stock Still Attractive?
How Snowflake Is Capitalizing on a Blizzard of Data
Alation unveils Data Governance App and deepens partnership with Snowflake
provided by Google News
Sr. ETL Developer
BI Analyst II
Test Specialist - Custom Applications
Senior Data Analytics Engineer/Tableau Developer - Remote
PRINCIPAL DATABASE ADMINISTRATOR
Database Administrator 2
Share this page