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