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)…

3

Database Technologies for Decision Support System

Database Technologies for Decision Support System Database technologies can be applied into two types of scenarios:- Transaction Processing(OLTP)- Analytic Processing, using statistical method(OLAP) or machine/computational learning method(Data Mining)OLTP, which is based on E.F. Codd’s relation model, is the traditional (maybe most popular) application type of DBMS and most people are very familiar with it. This…

1

Parallel DBMS V.S. Distributed DBMS

Parallel DBMS V.S. Distributed DBMS  Large Scale Data Intensive Computing is a hot topic today, many people starts to talk so called Parallel Database System and Distributed Database System technologies. But these two concepts seem very confusing, so I devoted sometime to try to make it clear.Parallel Database System seeks to improve performance through parallelization…