September 20, 2006

Netezza vs. conventional data warehousing RDBMS

For various reasons, I’m not going to try to give a comprehensive overview of the Netezza story. But I’d like to highlight four points that illustrate a lot of the difference between Netezza’s architecture and that of more conventional data warehousing DBMS.

Comments

5 Responses to “Netezza vs. conventional data warehousing RDBMS”

  1. DBMS2 — DataBase Management System Services»Blog Archive » Netezza’s chip story on September 20th, 2006 2:25 am

    [...] In addition to its software story, Netezza of course has a rather unique chip story. Where other vendors might have standard disk controllers and high-powered microprocessors, Netezza respectively has a FPGA (Field-Programmable Gate Array) and lesser microprocessor (PowerPC). Netezza claims that the advantages of these choices are: [...]

  2. DBMS2 — DataBase Management System Services»Blog Archive » Competitive issues in data warehouse ease of administration on September 22nd, 2006 3:03 am

    [...] Netezza has no indices at all. And no caches. And the hardware is preconfigured. This all makes administration pretty simple. [...]

  3. DBMS2 — DataBase Management System Services » Blog Archive » Infobright BrightHouse — columnar, VERY compressed, simple, and related to MySQL on April 25th, 2008 12:09 am

    [...] information is stored in data pack nodes,* one per data pack. If you’re familiar with Netezza zone maps, data pack nodes sound like zone maps on steroids. They store maximum values, minimum values, and [...]

  4. Data skipping | DBMS 2 : DataBase Management System Services on May 27th, 2013 1:11 am

    [...] back in 2006, I wrote about a cool Netezza feature called the zone map, which in essence allows you to do partition elimination even in the absence of strict range [...]

  5. tangier on May 28th, 2013 12:03 am

    This page definitely has all of the information I needed about this subject and didn’t know who to ask.

Leave a Reply




Feed: DBMS (database management system), DW (data warehousing), BI (business intelligence), and analytics technology Subscribe to the Monash Research feed via RSS or email:

Login

Search our blogs and white papers

Monash Research blogs

User consulting

Building a short list? Refining your strategic plan? We can help.

Vendor advisory

We tell vendors what's happening -- and, more important, what they should do about it.

Monash Research highlights

Learn about white papers, webcasts, and blog highlights, by RSS or email.