(21) Improvements on I/O Performance of Parallel Active Database

[Features of the Software]

The software has the following functions:

• It supports parallel nested transactions for efficient rule execution. Using the nested transaction mechanism, an abortion of a child transaction has no effect upon the parent transaction.
• A distributed deadlock detection mechanism makes the system avoid bottlenecks in concurrency control processing.
• Several levels of parallelism are implemented, such as, intra relational algebra operation parallelism by partitioning data horizontally, inter algebra operation parallelism by pipeline execution of KLIC's logical variables, and parallel nested transactions.
• It supports interactive SQL clients as well as relational algebra streams from KLIC clients.
• The rule manager, which utilizes the suspending and resuming mechanism of KL1 processes, enables active data handling under the nested transaction.
• Page based I/O sub-system provides about ten times better performance than the original KLIC I/O. The page based I/O is implemented by using generic object of KLIC. Some relational operations are executed as method calls to the page object. Currently, only projection, selection, and join operations are supported.

[Required Environment]

• nCUBE2:nCX 5.105a 3.4.0 (nbsd and nsdisk are required)
• SunOS 4.1.3
• Solaris 2.4 for Sparc
• Solaris 2.6 for Intel
• 386 BSD (BSDI BSD/OS 2.0.1)
• FreeBSD (RELEASE 2.2.5)
• NEWS: NEWS-OS 6.1.1

[File Configuration]

COPYRIGHT

Readme-E.html

Readme-J.txt

advertise-E.html

advertise-J.html

use-of-software-E

use-of-software-J

rdbhosts

Makefile

common/

client/

sqlclt/

dict.kl1

hostname.kl1

parser.kl1

sqlclt.kl1

uif.kl1

oqlclt/

hostname.kl1

paraio.kl1

uif.kl1

dict.kl1

oqlclt.kl1

parser.kl1

server/

access.kl1

access0.kl1 (obsolete)

access1.kl1 (obsolete)

algebra.kl1

condition.c

create.kl1

deadlock.kl1

delete.kl1

drop.kl1

exec.kl1

gobjdef.h

gpage.c

insert.kl1

join.kl1

lock.kl1

log.kl1

node_io.kl1

processor.kl1

projection.kl1

rdbserv.kl1

selection.kl1

trans.kl1

rule.kl1

btree/

bt_add.kl1

bt_del.kl1

bt_del1.kl1

bt_del2.kl1

bt_del3.kl1

bt_get.kl1

bt_name.kl1

bt_page.kl1

bt_pagename.kl1

bt_util.kl1

btinit.dat

btree.kl1

coding/

Makefile

decoder.kl1

encoder.kl1

fastio.kl1

util/

Makefile

util.kl1

rel/

Makefile

attributes

audit

dept

emp

faculty

location

relations.skel

nrelations.skel

rule

newrel/

doc/

catalogue.tex

papers.tex

parade_doc.tex

sun/

client/

sqlclt/

Makefile

oqlclt/

Makefile

javaQBE/

readme

index.html

makefile

DropPanel.java

ScrollableTable.java

GroupTable.java

SelectPanel.java

Attribute.java

QbePanel.java

Tag.java

AttributePanel.java

QbeSettingPanel.java

TagTable.java

AttributeTable.java

QueryAttributes.java

VStackLayout.java

QueryCreate.java

Client.java

QueryData.java

Communicate.java

QueryDelete.java

Const.java

QueryDrop.java

CreatePanel.java

QueryInsert.java

server/

Makefile

catalog.kl1.skel

socket/

paraio.kl1

socket.kl1

ncube/

client/

Makefile

server/

Makefile

catalog.kl1

socket/

paraio.kl1

socket.kl1

[Others]

This software is still under development.

[FTP]

• README
• Program and Documents in Japanese [135K]

---

To the Home Page

www-admin@icot.or.jp