PRISMA/DB: A Parallel Main-Memory Relational DBMS

Peter M.G. Apers; Jan Flokstra; P.W.P.J. Grefen; A.N. Wilschut; Martin L. Kersten; Carel A. van den Berg

doi:10.1109/69.180605

PRISMA/DB: A Parallel Main-Memory Relational DBMS

Peter M.G. Apers, Jan Flokstra, P.W.P.J. Grefen, A.N. Wilschut, Martin L. Kersten, Carel A. van den Berg

Databases (Former)

Research output: Contribution to journal › Article › Academic › peer-review

49 Citations (Scopus)

387 Downloads (Pure)

Abstract

PRISMA/DB, a full-fledged parallel, main memory relational database management system (DBMS) is described. PRISMA/DB's high performance is obtained by the use of parallelism for query processing and main memory storage of the entire database. A flexible architecture for experimenting with functionality and performance is obtained using a modular implementation of the system in an object-oriented programming language. The design and implementation of PRISMA/DB are described in detail. A performance evaluation of the system shows that the system is comparable to other state-of-the-art database machines. The prototype implementation of the system runs on a 100-node parallel multiprocessor.

Original language	English
Pages (from-to)	541-554
Number of pages	14
Journal	IEEE transactions on knowledge and data engineering
Volume	4
Issue number	6
DOIs	https://doi.org/10.1109/69.180605
Publication status	Published - Dec 1992

Keywords

DB-PDB: PARALLEL DATABASES
DB-DFDB: DISTRIBUTED OR FEDERATED DATABASES
METIS-118725
IR-55724
EWI-6251

Access to Document

10.1109/69.180605

49 Citations
1 Report

PRISMA/DB: A Parallel Main-Memory Relational DBMS
Apers, P. M. G., van de Berg, C. A., Flokstra, J., Grefen, P. W. P. J., Kersten, M. L. & Wilschut, A. N., 1992, University of Twente. 24 p. (Memoranda informatica; no. 92-12)
Research output: Book/Report › Report › Professional

Cite this

@article{61ec1aee087746b49491c6917208fb97,

title = "PRISMA/DB: A Parallel Main-Memory Relational DBMS",

abstract = "PRISMA/DB, a full-fledged parallel, main memory relational database management system (DBMS) is described. PRISMA/DB's high performance is obtained by the use of parallelism for query processing and main memory storage of the entire database. A flexible architecture for experimenting with functionality and performance is obtained using a modular implementation of the system in an object-oriented programming language. The design and implementation of PRISMA/DB are described in detail. A performance evaluation of the system shows that the system is comparable to other state-of-the-art database machines. The prototype implementation of the system runs on a 100-node parallel multiprocessor.",

keywords = "DB-PDB: PARALLEL DATABASES, DB-DFDB: DISTRIBUTED OR FEDERATED DATABASES, METIS-118725, IR-55724, EWI-6251",

author = "Apers, {Peter M.G.} and Jan Flokstra and P.W.P.J. Grefen and A.N. Wilschut and Kersten, {Martin L.} and {van den Berg}, {Carel A.}",

note = "Imported from EWI/DB PMS [db-utwente:arti:0000002035]. Also appeared in Parallel Architectures for Data/Knowledge-Based Systems, Miller, Hurson and Pakzad (eds.), IEEE Computer Society Press, 1995",

year = "1992",

month = dec,

doi = "10.1109/69.180605",

language = "English",

volume = "4",

pages = "541--554",

journal = "IEEE transactions on knowledge and data engineering",

issn = "1041-4347",

publisher = "IEEE",

number = "6",

}

TY - JOUR

T1 - PRISMA/DB: A Parallel Main-Memory Relational DBMS

AU - Apers, Peter M.G.

AU - Flokstra, Jan

AU - Grefen, P.W.P.J.

AU - Wilschut, A.N.

AU - Kersten, Martin L.

AU - van den Berg, Carel A.

N1 - Imported from EWI/DB PMS [db-utwente:arti:0000002035]. Also appeared in Parallel Architectures for Data/Knowledge-Based Systems, Miller, Hurson and Pakzad (eds.), IEEE Computer Society Press, 1995

PY - 1992/12

Y1 - 1992/12

N2 - PRISMA/DB, a full-fledged parallel, main memory relational database management system (DBMS) is described. PRISMA/DB's high performance is obtained by the use of parallelism for query processing and main memory storage of the entire database. A flexible architecture for experimenting with functionality and performance is obtained using a modular implementation of the system in an object-oriented programming language. The design and implementation of PRISMA/DB are described in detail. A performance evaluation of the system shows that the system is comparable to other state-of-the-art database machines. The prototype implementation of the system runs on a 100-node parallel multiprocessor.

AB - PRISMA/DB, a full-fledged parallel, main memory relational database management system (DBMS) is described. PRISMA/DB's high performance is obtained by the use of parallelism for query processing and main memory storage of the entire database. A flexible architecture for experimenting with functionality and performance is obtained using a modular implementation of the system in an object-oriented programming language. The design and implementation of PRISMA/DB are described in detail. A performance evaluation of the system shows that the system is comparable to other state-of-the-art database machines. The prototype implementation of the system runs on a 100-node parallel multiprocessor.

KW - DB-PDB: PARALLEL DATABASES

KW - DB-DFDB: DISTRIBUTED OR FEDERATED DATABASES

KW - METIS-118725

KW - IR-55724

KW - EWI-6251

U2 - 10.1109/69.180605

DO - 10.1109/69.180605

M3 - Article

SN - 1041-4347

VL - 4

SP - 541

EP - 554

JO - IEEE transactions on knowledge and data engineering

JF - IEEE transactions on knowledge and data engineering

IS - 6

ER -

PRISMA/DB: A Parallel Main-Memory Relational DBMS

Abstract

Keywords

Access to Document

Fingerprint

Research output

PRISMA/DB: A Parallel Main-Memory Relational DBMS

Cite this