Parallel Database for OLTP and OLAP

Parallel Database for OLTP and OLAP

Just A
Survey article on materials in 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
, Haven original 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 the high Performance database processing
2). Survey of Architecture of Parallel Database System
3). The case is Shared nothing
4). Much Ado about Shared-nothing

2.2 The 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). GKFX cache–the Future of Parallel Database
7). Cache fusion:extending shared-disk Clusters with Shared Caches

Tags Database Parallel

Parallel Database for OLTP and OLAP