PRISMA/DB: A Parallel Main-Memory Relational DBMS

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

Research output: Contribution to journalArticleAcademicpeer-review

46 Citations (Scopus)
38 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 languageUndefined
Pages (from-to)541-554
Number of pages14
JournalIEEE transactions on knowledge and data engineering
Volume4
Issue number6
DOIs
Publication statusPublished - Dec 1992

Keywords

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

Cite this

Apers, P. M. G., Flokstra, J., van den Berg, C. A., Grefen, P. W. P. J., Wilschut, A. N., Kersten, M. L., & van den Berg, C. A. (1992). PRISMA/DB: A Parallel Main-Memory Relational DBMS. IEEE transactions on knowledge and data engineering, 4(6), 541-554. https://doi.org/10.1109/69.180605
Apers, Peter M.G. ; Flokstra, Jan ; van den Berg, Carel A. ; Grefen, P.W.P.J. ; Wilschut, A.N. ; Kersten, Martin L. ; van den Berg, C.A. / PRISMA/DB: A Parallel Main-Memory Relational DBMS. In: IEEE transactions on knowledge and data engineering. 1992 ; Vol. 4, No. 6. pp. 541-554.
@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 {van den Berg}, {Carel A.} and P.W.P.J. Grefen and A.N. Wilschut and Kersten, {Martin L.} and {van den Berg}, C.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 = "12",
doi = "10.1109/69.180605",
language = "Undefined",
volume = "4",
pages = "541--554",
journal = "IEEE transactions on knowledge and data engineering",
issn = "1041-4347",
publisher = "IEEE Computer Society",
number = "6",

}

Apers, PMG, Flokstra, J, van den Berg, CA, Grefen, PWPJ, Wilschut, AN, Kersten, ML & van den Berg, CA 1992, 'PRISMA/DB: A Parallel Main-Memory Relational DBMS' IEEE transactions on knowledge and data engineering, vol. 4, no. 6, pp. 541-554. https://doi.org/10.1109/69.180605

PRISMA/DB: A Parallel Main-Memory Relational DBMS. / Apers, Peter M.G.; Flokstra, Jan; van den Berg, Carel A.; Grefen, P.W.P.J.; Wilschut, A.N.; Kersten, Martin L.; van den Berg, C.A.

In: IEEE transactions on knowledge and data engineering, Vol. 4, No. 6, 12.1992, p. 541-554.

Research output: Contribution to journalArticleAcademicpeer-review

TY - JOUR

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

AU - Apers, Peter M.G.

AU - Flokstra, Jan

AU - van den Berg, Carel A.

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

AU - Wilschut, A.N.

AU - Kersten, Martin L.

AU - van den Berg, C.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

VL - 4

SP - 541

EP - 554

JO - IEEE transactions on knowledge and data engineering

JF - IEEE transactions on knowledge and data engineering

SN - 1041-4347

IS - 6

ER -