Set-Oriented Memory Management In A Multiprocessor Database Machine

In the past few years research in the area of database machines has been centered mainly around efficient query processing and increased I/O-bandwidth. A large variety of software and hardware mechanisms has been proposed, including various forms of filtering techniques and parallel query evaluation in multiprocessor systems. However, the issue of memory management under these new techniques has received only little attention. In this paper we analyze the effects of employing filtering techniques and set-oriented query evaluation in multiprocessor systems on memory management. We propose a set-oriented memory management method which has been designed for a multiprocessor database machine utilizing software filtering and parallel query processing under dataflow control. We also address the problem of performing updates in a set oriented environment.

[1]  David J. DeWitt,et al.  Applying Data Flow Techniques to Data Base Machines , 1982, Computer.

[2]  Michel Scholl,et al.  VERSO: A Relational Backend Database Machine , 1983, Advanced Database Machine Architecture.

[3]  Rubén González-Rubio,et al.  The schuss filter: A processor for non-numerical data processing. , 1984, ISCA 1984.

[4]  Irving L. Traiger,et al.  The notions of consistency and predicate locks in a database system , 1976, CACM.

[5]  Hidehiko Tanaka,et al.  An Overview of The System Software of A Parallel Relational Database Machine GRACE , 1986, VLDB.

[6]  Patrick Valduriez,et al.  SABRE: A Relational Database System for a Multimicroprocessor Machine , 1983, Advanced Database Machine Architecture.

[7]  Hans Christoph Zeidler,et al.  RDBM: A Dedicated Multiprocessor System for Database Management , 1983, Advanced Database Machine Architecture.

[8]  J. Banerjee,et al.  Precision locks , 1981, SIGMOD '81.

[9]  Jean-Marc Thévenin,et al.  A Reliable Backend Using Multiattribute Clustering and Select-Join Operator , 1986, Very Large Data Bases Conference.

[10]  Andreas Reuter,et al.  Principles of transaction-oriented database recovery , 1983, CSUR.

[11]  David J. DeWitt,et al.  GAMMA - A High Performance Dataflow Database Machine , 1986, VLDB.

[12]  H. Boral,et al.  Database Machines , 1985, Springer New York.

[13]  David K. Hsiao,et al.  Advanced Database Machine Architecture , 1983, Advanced Database Machine Architecture.

[14]  Wolfgang Effelsberg,et al.  Principles of database buffer management , 1984, TODS.