GREO is an attached database processor developed for midrange business computers. Since 1989, thousands of GREO’S have been shipped in the Japanese midrange market. GREO is the first commercial product of a high. speed sorting hardware, or a hardwan sorter. GREO implements the O(n) time pipelined merge sort algorithm with several enhancements [1]. To fully utilize this sorting capability, the language processor for GREO compiles a given query into a sorting-oriented dataflow graph, which is in turn executed by the hardware sorter in conjunction with multi-microprocessors. Another unique aspect of GREO is that it is a commercial product developed in collaboration between a university and an industry (which are actually authors’ current affiliations). In spite of not a few “academic flavors” in its architecture, it succeeded in faithfully meeting practical customers requirements, i.e., improving performance of a variety of existing (relational and even non-relational) business applications. The paper describes both of its technical and practical aspects. First, the query processing model underlying GREO architecture is presented. Its architectural features are then described. Our experiences on making research results an actual commercial product are also reported.
[1]
Masaru Kitsuregawa,et al.
Evaluation of lg-#t#g# pip#lin# i-i#dwa2# gotten
,
1989
.
[2]
Masaru Kitsuregawa,et al.
Design and Implementation of High Speed Pipeline Merge Sorter with Run Length Tuning Mechanism
,
1987,
IWDM.
[3]
David J. DeWitt,et al.
Parallel database systems: the future of high performance database systems
,
1992,
CACM.
[4]
Masaru Kitsuregawa,et al.
Performance evaluation of functional disk system (FDS-R2)
,
1991,
[1991] Proceedings. Seventh International Conference on Data Engineering.
[5]
Masaru Kitsuregawa,et al.
Implementation of lsi sort chip for bimodal sort memory
,
1989
.
[6]
Masaru Kitsuregawa,et al.
Performance evaluation of functional disk system with nonuniform data distribution
,
1990,
[1990] Proceedings. Second International Symposium on Databases in Parallel and Distributed Systems.
[7]
Hidehiko Tanaka,et al.
An Overview of The System Software of A Parallel Relational Database Machine GRACE
,
1986,
VLDB.