DBMS > FatDB vs. Netezza vs. Sqrrl
System Properties Comparison FatDB vs. Netezza vs. Sqrrl
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines|
|Name||FatDB Xexclude from comparison||Netezza Also called PureData System for Analytics by IBM Xexclude from comparison||Sqrrl Xexclude from comparison|
|FatDB/FatCloud has ceased operations as a company with February 2014. FatDB is discontinued and excluded from the ranking.||Sqrrl has been acquired by Amazon and became a part of Amazon Web Services. It has been removed from the DB-Engines ranking.|
|Description||A .NET NoSQL DBMS that can integrate with and extend SQL Server.||Data warehouse and analytics appliance part of IBM PureSystems||Adaptable, secure NoSQL built on Apache Accumulo|
|Primary database model||Document store|
|Relational DBMS||Document store|
Wide column store
|Developer||FatCloud||IBM||Amazon originally Sqrrl Data, Inc.|
|License Commercial or Open Source||commercial||commercial||commercial|
|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.
|Server operating systems||Windows||Linux included in appliance||Linux|
|Typing predefined data types such as float or date||yes||yes||yes|
|SQL Support of SQL||no Via inetgration in SQL Server||yes||no|
|APIs and other access methods||.NET Client API|
RESTful HTTP API
Windows WCF Bindings
RESTful HTTP API
|Supported programming languages||C#||C|
C using GLib
|Server-side scripts Stored procedures||yes via applications||yes||no|
|Triggers||yes via applications||no||no|
|Partitioning methods Methods for storing different data on different nodes||Sharding||Sharding||Sharding making use of Hadoop|
|Replication methods Methods for redundantly storing data on multiple nodes||selectable replication factor||Source-replica replication||selectable replication factor making use of Hadoop|
|MapReduce Offers an API for user-defined Map/Reduce methods||yes||yes||yes|
|Consistency concepts Methods to ensure consistency in a distributed system||Eventual Consistency|
|Immediate Consistency Document store kept consistent with combination of global timestamping, row-level transactions, and server-side consistency resolution.|
|Foreign keys Referential integrity||no||no||no|
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data||no||ACID||Atomic updates per row, document, or graph entity|
|Concurrency Support for concurrent manipulation of data||yes||yes||yes|
|Durability Support for making data persistent||yes||yes||yes|
|User concepts Access control||no Can implement custom security layer via applications||Users with fine-grained authorization concept||Cell-level Security, Data-Centric Security, Role-Based Access Control (RBAC), Attribute-Based Access Control (ABAC)|
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.
|FatDB||Netezza Also called PureData System for Analytics by IBM||Sqrrl|
|Recent citations in the news|
AWS and IBM Netezza come out in support of Iceberg in table format face-off
UK-based PhysicsX raises €29.2M to reinvent AI and simulation ...
U.S. Navy Chooses Yellowbrick, Sunsets IBM Netezza
IBM Brings Back a Netezza, Attacks Yellowbrick
These Are The 10 Highest-Paying Tech Jobs In The U.S.
provided by Google News
Celebrate The Season With Classic And Contemporary Holiday ...
Lee Ritenour is Taking the Stage at Rams Head On Stage!
Millennials possess the advantage of time for wealth creation, says Yashoraj Tyagi of Sqrrl
Amazon's cloud business acquires Sqrrl, a security start-up with ...
Here we go, Annapolis catches sugar plum fever for the holidays
provided by Google News
SQL developer with Netezza
Senior Data Analyst
Senior, Business Consulting
Share this page