DBMS > AlaSQL vs. Infobright vs. Netezza
System Properties Comparison AlaSQL vs. Infobright vs. Netezza
Please select another system to include it in the comparison.
|Editorial information provided by DB-Engines
|AlaSQL Xexclude from comparison
|Infobright Xexclude from comparison
|Netezza Also called PureData System for Analytics by IBM Xexclude from comparison
|High performant column-oriented DBMS for analytic workloads using MySQL or PostgreSQL as a frontend
|Data warehouse and analytics appliance part of IBM PureSystems
|Primary database model
|Andrey Gershun & Mathias R. Wulff
|Ignite Technologies Inc.; formerly InfoBright Inc.
|License Commercial or Open Source
|Open Source MIT-License
|commercial The open source (GPLv2) version did not support inserts/updates/deletes and was discontinued with July 2016
|Cloud-based only Only available as a cloud service
|DBaaS offerings (sponsored links) Database as a Service
Providers of DBaaS offerings, please contact us to be listed.
|Server operating systems
|Linux included in appliance
|Typing predefined data types such as float or date
|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 Knowledge Grid Technology used instead
|SQL Support of SQL
|Close to SQL99, but no user access control, stored procedures and host language bindings.
|APIs and other access methods
|Supported programming languages
|Server-side scripts Stored procedures
|Partitioning methods Methods for storing different data on different nodes
|Replication methods Methods for redundantly storing data on multiple nodes
|MapReduce Offers an API for user-defined Map/Reduce methods
|Consistency concepts Methods to ensure consistency in a distributed system
|Foreign keys Referential integrity
|Transaction concepts Support to ensure data integrity after non-atomic manipulations of data
|yes only for local storage and DOM-storage
|Concurrency Support for concurrent manipulation of data
|Durability Support for making data persistent
|yes by using IndexedDB, SQL.JS or proprietary FileStorage
|In-memory capabilities Is there an option to define some or all structures to be held in-memory only.
|User concepts Access control
|fine grained access rights according to SQL-standard exploiting MySQL or PostgreSQL frontend capabilities
|Users with fine-grained authorization concept
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.
|Netezza Also called PureData System for Analytics by IBM
|Recent citations in the news
Multi faceted data exploration in the browser using Leaflet and amCharts
provided by Google News
AWS and IBM Netezza come out in support of Iceberg in table format face-off
U.S. Navy Chooses Yellowbrick, Sunsets IBM Netezza
IBM Brings Back a Netezza, Attacks Yellowbrick
provided by Google News
Share this page