Parallel Database for OLTP and OLAP

Parallel Database for OLTP and OLAP

Just a
survey article on materials on parallel database products and
technologies for OLTP/OLAP applications. It mainly covers major
commercial/academic efforts on developing parallel dbms to solve the
ever growing large amount of relational data processing problem.

Part I - Parallel DBMSs

1.1 Parallel Database for OLAP (Shared-Nothing/MPP)

TeraData

- TeraData Home

- Teradata DBC/1012 Paper

- NCR Teradata VS Oracle Exadata (Teradata's perspective)

Vertica

- Vertica Home

- The original research project: C-Strore

Paraccel

- Paraccel Home

- MPP Based Architecture

- Columnar Based Storage

- Flash Based Storage

DataLlegro(now MS Madison)

- Design Choices in MPP Data Warehousing Lessons from DATAllegro V3

- Microsoft SQL Server Parallel Data Warehousing

Netezza

- Netezza Home

- Acquired by IBM

- Hadoop & Netezza: Synergy in Data Analytics (Part 1, Part 2) 

- Netezza Twinfin VS Oracle Exadata (eBook, Blog, Netezza's perspective)

GreenPlum:

- GreenPlum Home

- Combined: PostGreSQL/ZFS/MapReduce

- Acquired by EMC

Oracle ExaData:

- ExaData Home (Technical Overview, White Paper)
>> - OLTP & OLAP Hybrid Orientation

>> - 1 * RAC + N * Exadata Cells (Storage Node) + Infiniband Network

>> - Exadata Cell: Flash Cache + Disk Array + Data Filtering Logic (partial SQL execution)
- Oracle Exadata VS Netezza TwinFin (Oracle Engineer's perspective)

IBM DB2 Data Partitioning Feature (can work with both OLAP/OLTP)

- formerly known as DB2 Parallel Edition (An Shorter Overview)

- DB2 At a Glance - Data Partitioning Feature

- Simulating Massively Parallel Database Processing on Linux

AsterData:

- Supercharging Analytics with SQL-MapReduce

- Aster Data brings Applications inside an MPP Database 

Misc Articles:

- What's MPP?

- Comparison of Oracle to IBM DB2 UDB and NCR Teradata for Data Warehousing

- SMP or MPP for Data Warehouse

- Dividing the data Warehousing work among MPP Nodes

- SANs vs. DAS in MPP data Warehousing

- Three ways Oracle or Microsoft could go MPP

1.2 Parallel Database for OLTP (Shared-Disk/SMP)

Oracle Real Application Cluster

- Oracle RAC Concepts

- Oracle Parallel Database Server Concepts

- Oracle RAC Case Study on 16-Node Linux Cluster

IBM DB2 for z/OS (with Sysplex Technology)

- Share Disk and Share Nothing for IBM DB2

- What's DB2 Data Sharing?

IBM DB2 for LUW (with pureScale Technology)

- IBM DB2 pureScale: The Next Big Thing or a Solution Looking for a Problem?

- What is DB2 pureScale?

- DB2 pureScale Scalability (section 1, section 2)

Part II - Academic Readings

2.1 Overview

1). Parallel Database System: The Future of High Performance Database Processing

2). Survey of Architecture of Parallel Database System

3). The Case for Shared Nothing

4). Much Ado About Shared-Nothing

2.2 Research System

1). XPS: A High Performance Parallel Database Server

2). The Design of XPRS

3). Prototyping Buuba, H High Parallel Database System

4). The Gamma Database Machine Project

5). NonStop SQL, A Distributed, High-Performance, High-Availability Implementation of SQL

6). Parallel Query Processing in Shared Disk Database System

7). Architecture of SDC, the Super Database Computer

2.3 Commercial System

1). A Study of A Parallel Database Machine and Its Performance - The NCR/TERADATA DBC/1012

2). A Practical Implementation of the Database Machine - Teradata DBC/1012

3). DB2 Parallel Edition

4). Parallel SQL Execution in Oracle 10g

6). Shared Cache - The Future of Parallel Database

7). Cache Fusion: Extending Shared-Disk Clusters with Shared Caches

Comments

• Anonymous
  December 21, 2010
  Best be aware, the Terradata paper mentioned above, "Exadata – the Sequel is a great Exadata study article" does have bias (naturally, it was written by a Terradata consultant) which is OK.  However, the question you should ask yourself, did Mr. Burns actually have access to an Exadata machine or is he simply claiming things for marketing purposes?This one, structureddata.org/.../oracle-exadata-and-netezza-twinfin-compared-%E2%80%93-an-engineer%E2%80%99s-analysis, is by an Oracle engineer with a couple of years experience on the machine. There is bias, I'm sure, but it is factual in nature.chet
• Anonymous
  December 21, 2010
  Chet,Thanks for your reminder. It's understandable that there would be some bias when someone is doing comparison with competitor's product, but such biased stuff should not be treated as good study material for competitors product.I had added links to both of these comparison articles.-csliu
• Anonymous
  December 28, 2010
  Vertica links seems to point to wrong site, should be www.vertica.com. Thanks.