Create entry

Netezza vs. Microsoft SQL Server 2017

Netezza Microsoft SQL Server 2017 + Add column
Category
Preference (62% global votes) (20% global votes)
Website www-01.​ibm.​com/​software/​data/​netezza/​ www.​microsoft.​com/​sqlserver
License
Design
Database model
Data storage ?
Embeddable Yes Yes
Features
Query language
Data types
Conditional entry updates Yes Yes
Map and reduce Yes No
Unicode Yes Yes
TTL for entries ? No
Compression Yes Yes
Integrity
Integrity model
Atomicity Yes Yes
Consistency Yes Yes
Isolation Yes Yes
Durability (data storage) Yes Yes
Transactions Conditional Conditional
Referential integrity No Yes
Revision control No ?
Locking model
Indexing
Secondary Indexes No Yes
Composite keys Yes Yes
Full text search No Yes
Geospatial Indexes Yes Yes
Graph support No ?
Distribution
Horizontal scalable No Yes
Replication Yes Yes
Replication mode
Sharding Yes ?
Shared nothing architecture Yes Yes
Restrictions
Value size max. 2.5 PB 2.15 GB
System requirements
Operating system
Native driver
Memory minimum 5 TB ?
Architecture
Programming language ?
More
Description AMPP implementation Relational Database Management System
Brand
Multi-user system Conditional Yes
Database ?
Multilingual content Yes ?
Price rating ★★★★☆ ?
Standard compliance Yes Yes
Software distribution No ?
Release Date January 2005 ?
Documentation level ★★★★☆ ★★★★☆
Free to use No Conditional
Active Yes ?
Database Connection Pooling Yes Yes
Real time analytics Conditional Yes
Community Driven No No
Web interface Yes Yes
Versioning Good ?
Data encryption Yes Yes
Online backup Yes Yes
Partial Index No ?
Log Yes ?
Implementation flexibility (40% global votes) (0% global votes)
Backup functionality Good Good
Query Cache No Yes
Ease of use ★★★★☆ ?
In-Place Update Yes ?
Free for commercial use No Yes
Sorts Yes Yes
Open Source Yes No
XInclude Support Yes ?
Triggers Yes Yes
Perfomance ★★★★☆ ★★★★☆
Predictive Analytics Yes ?
Geospatial Yes ?
Text Analytics Yes ?
Server Side Java Script Yes No
OData Yes ?
HTML5 Charts Yes ?
Decision Tables Yes ?
JSON Yes Yes
Flexible Table(Schema) Yes ?
Stored Procedure Yes Yes
Concurrency Yes ?
24/7 support Yes ?
Free edition Yes Yes
Websphere Dyna Cache Integration Yes ?
SQL Queries Yes ?
Monitoring UI Yes ?
Recursive queries Yes ?
Online backup (no locking) Yes ?
CLI` Yes ?
Columner No ?
Apache Spark Integration Yes ?
Object-Relational Mapping (ORM) ? Yes
Cloud platform support ?
Key length max ? 68
Materialized Views ? Yes
User and Group role based security model ? Yes
Does your mom understand it ? No
+ Add row ++
Netezza Microsoft SQL Server 2017
  • vsChart is like a wiki

    Just click a data cell to edit it.
    Take part and share your knowledge with the world.

  • blue
    = good
    darker
    = better
    Legend
  • Embed it on your site
  • Copy & Share
  • Creative Commons License License
  • EnglishGerman (Deutsch)

Write a review or comment

Please login (with Facebook, Twitter or OpenID) to use this form.

Type
Review
Comment