|
ABSTRACT
Database management systems will continue to manage large data volumes. Thus, efficient algorithms for accessing and manipulating large sets and sequences will be required to provide acceptable performance. The advent of object-oriented and extensible database systems will not solve this problem. On the contrary, modern data models exacerbate the problem: In order to manipulate large sets of complex objects as efficiently as today's database systems manipulate simple records, query-processing algorithms and software will become more complex, and a solid understanding of algorithm and architectural issues is essential for the designer of database management software.
This survey provides a foundation for the design and implementation of query execution facilities in new database management systems. It describes a wide array of practical query evaluation techniques for both relational and postrelational database systems, including iterative execution of complex query evaluation plans, the duality of sort- and hash-based set-matching algorithms, types of parallel query execution and their implementation, and special operators for emerging database application domains.
REFERENCES
Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.
 |
1
|
|
| |
2
|
|
| |
3
|
|
 |
4
|
|
| |
5
|
|
| |
6
|
|
 |
7
|
M. M. Astrahan , M. W. Blasgen , D. D. Chamberlin , K. P. Eswaran , J. N. Gray , P. P. Griffiths , W. F. King , R. A. Lorie , P. R. McJones , J. W. Mehl , G. R. Putzolu , I. L. Traiger , B. W. Wade , V. Watson, System R: relational approach to database management, ACM Transactions on Database Systems (TODS), v.1 n.2, p.97-137, June 1976
[doi> 10.1145/320455.320457]
|
| |
8
|
|
 |
9
|
|
 |
10
|
|
 |
11
|
|
| |
12
|
|
 |
13
|
|
 |
14
|
|
| |
15
|
|
 |
16
|
|
| |
17
|
D. S. Batory , J. R. Barnett , J. F. Garza , K. P. Smith , K. Tsukuda , C. Twichell , T. E. Wise, GENESIS: An Extensible Database Management System, IEEE Transactions on Software Engineering, v.14 n.11, p.1711-1730, November 1988
[doi> 10.1109/32.9057]
|
 |
18
|
|
| |
19
|
|
| |
20
|
BAYER, R., AND MCCREIGHTON, E. 1972. Organisation and maintenance of large ordered indices. Acta Informatica 1, 3, 173.
|
| |
21
|
|
 |
22
|
Bruno Becker , Hans-Werner Six , Peter Widmayer, Spatial priority search: an access technique for scaleless maps, Proceedings of the 1991 ACM SIGMOD international conference on Management of data, p.128-137, May 29-31, 1991, Denver, Colorado, United States
|
 |
23
|
Norbert Beckmann , Hans-Peter Kriegel , Ralf Schneider , Bernhard Seeger, The R*-tree: an efficient and robust access method for points and rectangles, Proceedings of the 1990 ACM SIGMOD international conference on Management of data, p.322-331, May 23-26, 1990, Atlantic City, New Jersey, United States
|
 |
24
|
|
 |
25
|
|
 |
26
|
|
 |
27
|
Philip A. Bernstein , Nathan Goodman , Eugene Wong , Christopher L. Reeve , James B. Rothnie, Jr., Query processing in a system for distributed databases (SDD-1), ACM Transactions on Database Systems (TODS), v.6 n.4, p.602-625, Dec. 1981
[doi> 10.1145/319628.319650]
|
| |
28
|
|
| |
29
|
|
| |
30
|
|
| |
31
|
|
| |
32
|
|
| |
33
|
|
| |
34
|
|
 |
35
|
|
| |
36
|
BITTON-FRIEDLAND, D. 1982. Design, analysis, and implementation of parallel external sorting algorithms PhD. Thesis, Univ. of Wisconsin-Madison.
|
| |
37
|
|
 |
38
|
|
| |
39
|
|
| |
40
|
|
 |
41
|
|
| |
42
|
BLASGEN, M., AND ESWARAN, K. 1977. Storage and access in relational databases. IBM Syst. J. 1G, 4, 363.
|
| |
43
|
BLASGEN, M., AND ESWARAN, K. 1976. On the evaluation of queries in a relational database system IBM Res. Rep RJ 1745, IBM, San Jose, Calif.
|
 |
44
|
|
| |
45
|
|
| |
46
|
|
| |
47
|
H. Boral , W. Alexander , L. Clay , G. Copeland , S. Danforth , M. Franklin , B. Hart , M. Smith , P. Valduriez, Prototyping Bubba, A Highly Parallel Database System, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.4-24, March 1990
[doi> 10.1109/69.50903]
|
| |
48
|
|
| |
49
|
BROWN, K. P., CAREY, M. J., DEWITT, D. J., MEHTA, M., AND NAUGHTON, J. F. 1992. Scheduling issues for complex database workloads. Computer Science Tech. Rep. 1095, Univ. of Wisconsin--Madison.
|
| |
50
|
|
 |
51
|
|
 |
52
|
|
| |
53
|
|
| |
54
|
|
| |
55
|
|
| |
56
|
CARTER, J. L., AND WEGMAN, M.N. 1979. Universal classes of hash functions. J. Comput. Syst. Scz. 18, 2, 143.
|
 |
57
|
Donald D. Chamberlin , Morton M. Astrahan , Michael W. Blasgen , James N. Gray , W. Frank King , Bruce G. Lindsay , Raymond Lorie , James W. Mehl , Thomas G. Price , Franco Putzolu , Patricia Griffiths Selinger , Mario Schkolnick , Donald R. Slutz , Irving L. Traiger , Bradford W. Wade , Robert A. Yost, A history and evaluation of System R, Communications of the ACM, v.24 n.10, p.632-646, Oct. 1981
[doi> 10.1145/358769.358784]
|
 |
58
|
D. D. Chamberlin , M. M. Astrahan , W. F. King , R. A. Lorie , J. W. Mehl , T. G. Price , M. Schkolnick , P. Griffiths Selinger , D. R. Slutz , B. W. Wade , R. A. Yost, Support for repetitive transactions and ad hoc queries in System R, ACM Transactions on Database Systems (TODS), v.6 n.1, p.70-94, March 1981
[doi> 10.1145/319540.319550]
|
 |
59
|
|
 |
60
|
|
| |
61
|
|
| |
62
|
Josephine M. Cheng , Donald J. Haderle , Richard Hedges , Balakrishna R. Iyer , Ted Messinger , C. Mohan , Yun Wang, An Efficient Hybrid Join Algorithm: A DB2 Prototype, Proceedings of the Seventh International Conference on Data Engineering, p.171-180, April 08-12, 1991
|
| |
63
|
|
 |
64
|
|
| |
65
|
|
| |
66
|
|
 |
67
|
|
| |
68
|
|
| |
69
|
CLUET, S., DELOBEL, C., LECLUSE, C., ANn RICHARD, P. 1989. Reloops, an algebra based query language for an object-oriented database system. In Proceedings of the 1st International Conference on Deductive and Object-Ortented Databases (Kyoto, Japan, Dec. 4-6).
|
 |
70
|
|
 |
71
|
George Copeland , William Alexander , Ellen Boughter , Tom Keller, Data placement in Bubba, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.99-108, June 01-03, 1988, Chicago, Illinois, United States
|
 |
72
|
P. Dadam , K. Kuespert , F. Andersen , H. Blanken , R. Erbe, A DBMS prototype to support extended NF2 relations: an integrated view on flat tables and hierarchies, Proceedings of the 1986 ACM SIGMOD international conference on Management of data, p.356-367, May 28-30, 1986, Washington, D.C., United States
|
| |
73
|
DANIELS, D., AND NG, P. 1982. Distributed query compilation and processing in R*. IEEE Database Eng. 5, 3 (Sept.).
|
| |
74
|
Scott Daniels , Goetz Graefe , Thomas Keller , David Maier , Duri Schmidt , Bennet Vance, Query optimization in revelation, an overview, Data Engineering, v.14 n.2, p.58-62, June 1991
|
 |
75
|
|
| |
76
|
DAVIS, D. D. 1992. Oracle's parallel punch for OLTP. Datamation (Aug. 1), 67.
|
 |
77
|
|
| |
78
|
U. Deppisch , H.-B. Paul , H.-J. Schek, A storage system for complex objects, Proceedings on the 1986 international workshop on Object-oriented database systems, p.183-195, September 23-26, 1986, Pacific Grove, California, United States
|
| |
79
|
|
| |
80
|
DESHPANDE, V., AND LARSON, P.A. 1991. An algebra for nested relations with support for nulls and aggregates. Computer Science Dept., Univ. of Waterloo, Waterloo, Ontario, Canada.
|
| |
81
|
|
| |
82
|
DEWI~?, D.J. 1991. The Wisconsin benchmark: Past, present, and future. In Database and Transaction Processing System Performance Handbook. Morgan-Kaufman, San Mateo, Calif.
|
| |
83
|
DEWITT, D. J., m'~D G~RBER, R.H. 1985. Multiprocessor hash-based join algorithms. In Proceedings of the International Conference on Very Large Dato Bases (Stockholm, Sweden, Aug.). VLDB Endowment, 151.
|
 |
84
|
|
| |
85
|
DEWITT, D. J., AND HAWTHORN, P. B. 1981. A performance evaluation of database machine architectures. In Proceedings of the International Conference on Very Large Data Bases (Cannes, France, Sept.). VLDB Endowment, 199.
|
| |
86
|
David J. DeWitt , Goetz Graefe , Krishna B. Kumar , Robert H. Gerber , Michael L. Heytens , M. Muralikrishna, GAMMA—a high performance dataflow database machine, Readings in database systems, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1988
|
 |
87
|
D. J. DeWitt , S. Ghanderaizadeh , D. Schneider, A performance analysis of the gamma database machine, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.350-360, June 01-03, 1988, Chicago, Illinois, United States
|
| |
88
|
D. J. Dewitt , S. Ghandeharizadeh , D. A. Schneider , A. Bricker , H. -I. Hsiao , R. Rasmussen, The Gamma Database Machine Project, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.44-62, March 1990
[doi> 10.1109/69.50905]
|
 |
89
|
David J DeWitt , Randy H Katz , Frank Olken , Leonard D Shapiro , Michael R Stonebraker , David Wood, Implementation techniques for main memory database systems, Proceedings of the 1984 ACM SIGMOD international conference on Management of data, June 18-21, 1984, Boston, Massachusetts
|
| |
90
|
|
| |
91
|
|
| |
92
|
|
 |
93
|
|
 |
94
|
|
 |
95
|
|
| |
96
|
ENGLERT, S., GRAY, J., KOCHER, R., AND SHAH, P. 1989. A benchmark of nonstop SQL release 2 demonstrating near-linear speedup and scaleup on large databases. Tandem Computers Tech. Rep. 89.4, Tandem Corp., Cupertino, Calif.
|
| |
97
|
EPSTEIN, R. 1979. Techniques for processing of aggregates in relational database systems UCB/ERL Memo. M79/8, Univ. of California, Berkeley, Calif.
|
| |
98
|
EPSTEIN, R., AND STONEBRAKER, M. 1980. Analysis of distributed data base processing strategies. In Proceedings o/the International Conference on Very Large Data Bases iMontreal, Canada, Oct.). VLDB Endowment, 92.
|
 |
99
|
|
 |
100
|
|
 |
101
|
|
| |
102
|
|
| |
103
|
|
| |
104
|
FINKEL, R. A., AND BENTLEY, J. L. 1974. Quad trees: A data structure for retrieval on composite keys. Acta Informatzca 4, 1, 1.
|
 |
105
|
|
| |
106
|
|
 |
107
|
|
| |
108
|
|
| |
109
|
|
| |
110
|
GOODMAN, J. R., AND WORST, P. J 1988. The Wisconsin Multicube: A new large-scale cachecoherent multiprocessor. Computer Science Tech Rep. 766, Umv. of Wisconsin Madison
|
 |
111
|
|
| |
112
|
GRAEFE, G. 1993a. Volcano, An extensible and parallel datafiow query processing system. IEEE Trans. Knowledge Data Eng. To be published.
|
| |
113
|
GRAEFE, G. 1993b. Performance enhancements for hybrid hash join Available as Computer Science Tech. Rep. 606, Univ. of Colorado, Boulder.
|
| |
114
|
GRAEFE, G. 1993c Sort-merge-join: An idea whose time has passed? Revised in Portland State Univ. Computer Science Tech. Rep. 93-4.
|
| |
115
|
|
| |
116
|
GRAEFE, G. 1990a. Parallel external sorting in Volcano. Computer Science Tech. Rep. 459, Umv. of Colorado, Boulder.
|
 |
117
|
|
| |
118
|
|
| |
119
|
GRAEFE, G., AND COLE, R. L. 1993. Fast algorithms for universal quantification in large databases. Portland State Univ. and Univ. of Colorado at Boulder.
|
| |
120
|
|
 |
121
|
|
| |
122
|
|
| |
123
|
|
| |
124
|
GRAEFE, G., AND SHAPIRO, L.D. 1991. Data compression and database performance. In Proceedings of the ACM/IEEE-Computer Science Symposium on Applied Computing. ACM/IEEE, New York.
|
 |
125
|
|
| |
126
|
GRAErE, G., AND WOLNmWICZ, R.H. 1992. Algebraic optimization and parallel execution of computations over scientific databases. In Proceedings of the Workshop on Metadata Management in Sc~ent~ftc Databases (Salt Lake City, Utah, Nov. 3-5).
|
| |
127
|
GRAEFE, G., COLE, R. L., DAVISON, D. L., McKENNA, W. J., AND WOLNmW~CZ, R.H. 1992. Extensible query optimization and parallel execution in Volcano. In Query Processing for Advanced Database Applications. Morgan-Kaufman, San Mateo, Calif.
|
| |
128
|
GRASFE, G., LINWLLE, A., AND SHAPIRO, L.D. 1993. Sort versus hash revisited. IEEE Trans. Knowledge Data Eng. To be published.
|
| |
129
|
GRAY, J. 1990. A census of Tandem system availability between 1985 and 1990. Tandem Computers Tech. Rep. 90.1, Tandem Corp., Cupertino, Calif.
|
 |
130
|
|
| |
131
|
|
 |
132
|
Jim Gray , Paul McJones , Mike Blasgen , Bruce Lindsay , Raymond Lorie , Tom Price , Franco Putzolu , Irving Traiger, The Recovery Manager of the System R Database Manager, ACM Computing Surveys (CSUR), v.13 n.2, p.223-242, June 1981
[doi> 10.1145/356842.356847]
|
 |
133
|
|
| |
134
|
|
| |
135
|
GUIBAS, L., AND SEDGEWICK, R. 1978. A dichromatic framework for balanced trees. In Proceedings of the 19th Symposium on the Foundations of Computer Science.
|
| |
136
|
|
| |
137
|
|
| |
138
|
|
| |
139
|
|
| |
140
|
|
| |
141
|
|
| |
142
|
L. M. Haas , W. Chang , G. M. Lohman , J. McPherson , P. F. Wilms , G. Lapis , B. Lindsay , H. Pirahesh , M. J. Carey , E. Shekita, Starburst Mid-Flight: As the Dust Clears, IEEE Transactions on Knowledge and Data Engineering, v.2 n.1, p.143-160, March 1990
[doi> 10.1109/69.50910]
|
 |
143
|
L. M. Haas , J. C. Freytag , G. M. Lohman , H. Pirahesh, Extensible query processing in starburst, Proceedings of the 1989 ACM SIGMOD international conference on Management of data, p.377-388, June 1989, Portland, Oregon, United States
|
| |
144
|
HAAs, L. M., SELINGER, P. G., BERTINO, E., DANIELS, D., LINDSAY, B., LEHMAN, G., MASUNAGA, Y., MOHAN, C., NG, P., WmMs, P., AND YOST, R. 1982. R*: A research project on distributed relational database management. IBM Res. Division, San Jose, Calif.
|
 |
145
|
|
| |
146
|
|
| |
147
|
|
| |
148
|
HAMMING, R. W. 1977. Digital Filters. Prentice- Hall, Englewood Cliffs, N.J.
|
 |
149
|
|
| |
150
|
|
 |
151
|
|
| |
152
|
|
| |
153
|
|
 |
154
|
|
 |
155
|
|
 |
156
|
Wen-Chi Hou , Gultekin Ozsoyoglu , Erdogan Dogdu, Error-constrained COUNT query evaluation in relational databases, Proceedings of the 1991 ACM SIGMOD international conference on Management of data, p.278-287, May 29-31, 1991, Denver, Colorado, United States
|
| |
157
|
|
| |
158
|
|
| |
159
|
|
 |
160
|
|
 |
161
|
|
| |
162
|
|
 |
163
|
Andreas Hutflesz , Hans-Werner Six , Peter Widmayer, Twin grid files: space optimizing access schemes, Proceedings of the 1988 ACM SIGMOD international conference on Management of data, p.183-190, June 01-03, 1988, Chicago, Illinois, United States
|
| |
164
|
|
 |
165
|
|
| |
166
|
|
 |
167
|
|
 |
168
|
|
 |
169
|
|
 |
170
|
|
 |
171
|
|
 |
172
|
Tom Keller , Goetz Graefe , David Maier, Efficient assembly for complex objects, Proceedings of the 1991 ACM SIGMOD international conference on Management of data, p.148-157, May 29-31, 1991, Denver, Colorado, United States
|
 |
173
|
|
| |
174
|
|
 |
175
|
|
 |
176
|
Alfons Kemper , Christoph Kilger , Guido Moerkotte, Function materialization in object bases, Proceedings of the 1991 ACM SIGMOD international conference on Management of data, p.258-267, May 29-31, 1991, Denver, Colorado, United States
|
| |
177
|
|
 |
178
|
|
 |
179
|
|
| |
180
|
|
| |
181
|
|
| |
182
|
KiTSUREGAWA, M., TANAKA, H., AND MOTOOKA, T. 1983. Application of hash to data base machine and its architecture. New Gener. Camput. 1, 1, 63.
|
| |
183
|
|
 |
184
|
|
 |
185
|
|
| |
186
|
|
 |
187
|
|
| |
188
|
|
| |
189
|
KooI, R. P., AND FRANI~'ORTH, D. 1982. Query optimization in Ingres. IEEE Database Eng. 5, 3 (Sept.), 2.
|
| |
190
|
|
| |
191
|
|
| |
192
|
|
| |
193
|
|
| |
194
|
|
| |
195
|
|
| |
196
|
|
 |
197
|
|
 |
198
|
|
| |
199
|
LARSON, P., AND YANG, H. 1985. Computing queries from derived relations. In Proceedings of the International Conference on Very Large Data Bases (Stockholm, Sweden, Aug.). VLDB Endowment, 259.
|
 |
200
|
|
 |
201
|
|
| |
202
|
|
| |
203
|
|
| |
204
|
|
| |
205
|
|
 |
206
|
|
| |
207
|
LOHMAN, G., MOHAN, C., HAAS, L., DANIELS, D., LINDSAY, B., SELINGER, P., AND WILMS, P. 1985. Query processing in R~. In Query Processing m Database Systems. Springer, Berlin, 31.
|
 |
208
|
|
 |
209
|
|
 |
210
|
|
| |
211
|
Lorenz, R. A., AND NmSSON, J.F. 1979. An access specification language for a relational database management system IBM J. Res. Devel. 23, 3 (May), 286
|
| |
212
|
|
| |
213
|
LYNCH, C A., AND BROWNRIGG, E.B. 1981. Application of data compression to a large bibliographic data base In Proceedings of the Internatmnal Conference on Very Large Data Bases (Cannes, France, Sept.). VLDB Endowment, 435
|
 |
214
|
|
 |
215
|
|
| |
216
|
|
| |
217
|
|
| |
218
|
MAIER, D., GRAEFE, G., SHAPIRO, L., DANIELS, S., KELLER, T., AND VANCE~ B. 1992 Issues in distributed complex object assembly In Proceedings of the Workshop on Distributed Object Management (Edmonton, BC, Canada, Aug.).
|
 |
219
|
|
 |
220
|
|
| |
221
|
MEDEIROS, C., AND TOMPA, F. 1985. Understandmg the implications of view update pohcms. In Proceedings of the International Conference on Very Large Data Bases (Stockholm, Sweden, Aug.). VLDB Endowment, 316.
|
| |
222
|
|
 |
223
|
|
| |
224
|
|
| |
225
|
C. Mohan , Don Haderle , Yun Wang , Josephine Cheng, Single table access using multiple indexes: optimization, execution, and concurrency control techniques, Proceedings of the international conference on extending database technology on Advances in database technology, p.29-43, March 1990, Venice, Italy
|
| |
226
|
|
| |
227
|
|
| |
228
|
|
| |
229
|
NECHES, P M. 1988. The Ynet: An interconnect structure for a highly concurrent data base computer system. In Proceedings o/ the 2rid Symposium on the Frontiers of Massively Parallel Computatmn (Fairfax, Virginia, Oct.).
|
| |
230
|
|
 |
231
|
|
 |
232
|
Raymond Ng , Christos Faloutsos , Timos Sellis, Flexible buffer allocation based on marginal gains, Proceedings of the 1991 ACM SIGMOD international conference on Management of data, p.387-396, May 29-31, 1991, Denver, Colorado, United States
|
 |
233
|
|
| |
234
|
NYBERG, C., BERCLAY, T., CVETANOVIC, Z., GRAY. J., AND LOMET, D. 1993. AlphaSort: A RISC machine sort. Teeh. Rep. 93.2. DEC San Francisco Systems Center. Digital Equipment Corp., San Francisco.
|
| |
235
|
|
| |
236
|
OMIECINSKI, E. 1985. Incremental file reorganization schemes. In Proceedings of the International Conference on Very Large Data Bases (Stockholm, Sweden, Aug.). VLDB Endowment, 346.
|
| |
237
|
|
| |
238
|
|
| |
239
|
OUSTERHOUT, J. 1990. Why aren't operating systems getting faster as fast as hardware. In USENIX Summer Conference (Anaheim, Calif., June). USENIX.
|
| |
240
|
|
 |
241
|
|
| |
242
|
|
| |
243
|
|
| |
244
|
|
 |
245
|
|
 |
246
|
Hamid Pirahesh , C. Mohan , Josephine Cheng , T. S. Liu , Pat Selinger, Parallelism in relational data base systems: architectural issues and design approaches, Proceedings of the second international symposium on Databases in parallel and distributed systems, p.4-29, July 02-04, 1990, Dublin, Ireland
[doi> 10.1145/319057.319060]
|
| |
247
|
|
| |
248
|
REW, R. K., AND DAWS, G.P. 1990. The Unidata NetCDF: Software for scientific data access. In the 6th Internahonal Con/~rence on Interactive Information and Processing Systems for Meterology, Oceanography, and Hydrology (Anaheim, Calif.).
|
 |
249
|
|
 |
250
|
James P. Richardson , Hongjun Lu , Krishna Mikkilineni, Design and evaluation of parallel pipelined join algorithms, Proceedings of the 1987 ACM SIGMOD international conference on Management of data, p.399-409, May 27-29, 1987, San Francisco, California, United States
|
 |
251
|
|
| |
252
|
ROSENTHAL, A., AND REINER, D.S. 1985. Querying relational views of networks. In Query Processing in Database Systems. Springer, Berlin, 109.
|
| |
253
|
ROSENTHAL, h., RICH, C., AND SCHOLL, M. 1991. Reducing duplicate work in relational join(s): A modular approach using nested relations. ETH Tech. Rep., Zurich, Switzerland.
|
| |
254
|
|
 |
255
|
|
 |
256
|
J. B. Rothnie, Jr. , P. A. Bernstein , S. Fox , N. Goodman , M. Hammer , T. A. Landers , C. Reeve , D. W. Shipman , E. Wong, Introduction to a system for distributed databases (SDD-1), ACM Transactions on Database Systems (TODS), v.5 n.1, p.1-17, March 1980
[doi> 10.1145/320128.320129]
|
 |
257
|
|
| |
258
|
|
| |
259
|
RUTH, S. S , AND KEUTZER, P J 1972. Data compression for business files. Datamatlon 18 (Sept.), 62.
|
| |
260
|
G. Saake , V. Linnemann , P. Pistor , L. Wegner, Sorting, grouping and duplicate elimination in the advanced information management prototype, Proceedings of the 15th international conference on Very large data bases, p.307-316, July 1989, Amsterdam, The Netherlands
|
| |
261
|
|
 |
262
|
|
| |
263
|
|
| |
264
|
SACKS-DAVIS, R., AND RAMAIVIOHANARAO, K. 1983. two-level superimposed coding scheme for partial match retrieval. In{. Syst. 8, 4, 273.
|
 |
265
|
|
| |
266
|
|
| |
267
|
|
 |
268
|
Betty Salzberg , Alex Tsukerman , Jim Gray , Michael Stuewart , Susan Uren , Bonnie Vaughan, FastSort: a distributed single-input single-output external sort, Proceedings of the 1990 ACM SIGMOD international conference on Management of data, p.94-101, May 23-26, 1990, Atlantic City, New Jersey, United States
|
 |
269
|
|
| |
270
|
|
| |
271
|
SCHNEIDER, D.A. 1991. Bit filtering and multiway join query processing. Hewlett-Packard Labs, Pale Alto, Calif. Unpublished Ms
|
| |
272
|
|
| |
273
|
|
 |
274
|
|
| |
275
|
SCHOLL, M.H. 1988. The nested relational model Efficient support for a relational database interface. Ph.D. thesis, Technical Univ. Darmstadt. In German.
|
| |
276
|
|
 |
277
|
|
| |
278
|
|
 |
279
|
P. Griffiths Selinger , M. M. Astrahan , D. D. Chamberlin , R. A. Lorie , T. G. Price, Access path selection in a relational database management system, Proceedings of the 1979 ACM SIGMOD international conference on Management of data, May 30-June 01, 1979, Boston, Massachusetts
[doi> 10.1145/582095.582099]
|
 |
280
|
|
| |
281
|
SEPPI, K., BARNES, J., AND MORRIS, C. 1989. A Bayesian approach to query optimization m large scale data bases The Univ. of Texas at Austin ORP 89-19, Austin.
|
| |
282
|
SERLIN, O. 1991. The TPC benchmarks. In Database and Transactmn Processing System Performance Handbook. Morgan-Kaufman, San Mateo, Callf
|
| |
283
|
|
| |
284
|
SEVEPaNCF~, D.G. 1983. A practitioner's guide to data base compression. Inf. Syst. 8, 1, 51.
|
 |
285
|
|
| |
286
|
|
 |
287
|
|
| |
288
|
|
| |
289
|
|
| |
290
|
|
 |
291
|
|
 |
292
|
|
 |
293
|
|
 |
294
|
|
| |
295
|
|
 |
296
|
|
| |
297
|
|
 |
298
|
|
 |
299
|
|
 |
300
|
|
| |
301
|
|
 |
302
|
|
| |
303
|
STAMOS, J. W., AND YOUNG, H. C. 1989. A symmetric fragment and replicate algorithm for distributed joins. Tech. Rep. RJ7188, IBM Research Labs, San Jose, Calif.
|
 |
304
|
|
| |
305
|
|
| |
306
|
STONEBRAKER, M. 1986a. The case for sharednothing. IEEE Database Eng. 9, 1 (Mar.).
|
| |
307
|
|
 |
308
|
|
 |
309
|
|
| |
310
|
STONEBRAKER, M., AOKI, P., AND SELTZER, M. 1988a. Parallelism in XPRS. UCB/ERL Memorandum M89/16, Univ. of California, Berkeley.
|
 |
311
|
Michael Stonebraker , Anant Jhingran , Jeffrey Goh , Spyros Potamianos, On rules, procedure, caching and views in data base systems, Proceedings of the 1990 ACM SIGMOD international conference on Management of data, p.281-290, May 23-26, 1990, Atlantic City, New Jersey, United States
|
| |
312
|
|
| |
313
|
|
| |
314
|
STRAUBE, D. D., AND OZSU, M. T. 1989. Query transformation rules for an object algebra. ept. of Computing Sciences Tech. Rep. 89-23, Univ. of Alberta, Albertm Canada.
|
| |
315
|
|
 |
316
|
|
 |
317
|
|
| |
318
|
TERADATA. 1983. DBC/1012 Data Base Computer, Concepts and Facilities. Teradata Corporation, Los Angeles.
|
 |
319
|
Gomer Thomas , Glenn R. Thompson , Chin-Wan Chung , Edward Barkmeyer , Fred Carter , Marjorie Templeton , Stephen Fox , Berl Hartman, Heterogeneous distributed database systems for production use, ACM Computing Surveys (CSUR), v.22 n.3, p.237-266, Sept. 1990
[doi> 10.1145/96602.96607]
|
| |
320
|
|
 |
321
|
|
 |
322
|
|
 |
323
|
|
| |
324
|
TUKEY, J. W. 1977. Exploratory Data Analyas. Addison-Wesley, Reading, Mass.
|
| |
325
|
UNIDATA 1991. NetCDF User's Guide, An Interface fbr Data Access, Versmn I.H. NCAR Tech Note TS-334 + 1A, Boulder, Colo
|
 |
326
|
|
 |
327
|
Scott L. Vandenberg , David J. DeWitt, Algebraic support for complex objects with arrays, identity, and inheritance, Proceedings of the 1991 ACM SIGMOD international conference on Management of data, p.158-167, May 29-31, 1991, Denver, Colorado, United States
|
| |
328
|
|
| |
329
|
|
 |
330
|
|
| |
331
|
WHANG, K. Y., WIEDERHOLD G., AND SAGALOWICZ, D. 1985 The property of separahlity and its application to physical database demgn. In Query Processmg m Database Systems. Springer, Berhn, 297.
|
| |
332
|
WHANG, K. Y., WIEDERHOLD, G., AND SAGLOWICZ, D. 1984. Separability An approach to physical database design. IEEE Trans. Comput. 33, 3 (Mar.), 209.
|
| |
333
|
R. Williams , D. Daniels , L. Haas , G. Lapis , Lindsay P. Ng , R. Obermarck , P. Selinger , A. Walker , P. Wilms , R. Yost, R*: An overview of the architecture, Readings in database systems, Morgan Kaufmann Publishers Inc., San Francisco, CA, 1988
|
| |
334
|
WILSCHUT, A. N. 1993. Parallel query executmn in a mare memory database system. Ph.D. the sis, Univ. of Tweuk, The Netherlands.
|
| |
335
|
|
 |
336
|
|
| |
337
|
|
| |
338
|
|
 |
339
|
|
 |
340
|
|
| |
341
|
|
| |
342
|
YOUSSEFL K, ANn WONG, E 1979. Query processing in a relational database management system. In Proceedmg,s of the Internatmnal Conference on Very Large Data Bases (Rio de Janeiro, Oct ). VLDB Endowment, 409.
|
 |
343
|
|
| |
344
|
|
| |
345
|
|
 |
346
|
|
| |
347
|
ZELLER, H. 1990. Parallel query execution in NonStop SQL. In Dzgest of Papers, 35th Comp- Con Conference. San Francisco.
|
| |
348
|
|
CITED BY 240
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Andrew Lim , Jennifer Lai-Pheng Kwan , Wee-Chong Oon, Page access scheduling in join processing, Proceedings of the eighth international conference on Information and knowledge management, p.276-283, November 02-06, 1999, Kansas City, Missouri, United States
|
|
|
Jin-Yi Cai , Venkatesan T. Chakaravarthy , Raghav Kaushik , Jeffrey F. Naughton, On the complexity of join predicates, Proceedings of the twentieth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, p.207-214, May 2001, Santa Barbara, California, United States
|
|
|
Lars Arge , Octavian Procopiuc , Sridhar Ramaswamy , Torsten Suel , Jeffrey Scott Vitter, Theory and practice of I/O-efficient algorithms for multidimensional batched searching problems, Proceedings of the ninth annual ACM-SIAM symposium on Discrete algorithms, p.685-694, January 25-27, 1998, San Francisco, California, United States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Luc Bouganim , Olga Kapitskaia , Patrick Valduriez, Memory-adaptive scheduling for large query execution, Proceedings of the seventh international conference on Information and knowledge management, p.105-115, November 02-07, 1998, Bethesda, Maryland, United States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Alexander S. Szalay , Peter Z. Kunszt , Ani Thakar , Jim Gray , Don Slutz , Robert J. Brunner, Designing and mining multi-terabyte astronomy archives: the Sloan Digital Sky Survey, ACM SIGMOD Record, v.29 n.2, p.451-462, June 2000
|
|
|
Nilesh N. Dalvi , Sumit K. Sanghai , Prasan Roy , S. Sudarshan, Pipelining in multi-query optimization, Proceedings of the twentieth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, p.59-70, May 2001, Santa Barbara, California, United States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dimitris Papadias , Nikos Mamoulis , Yannis Theodoridis, Processing and optimization of multiway spatial joins using R-trees, Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, p.44-55, May 31-June 03, 1999, Philadelphia, Pennsylvania, United States
|
|
|
|
|
|
Y. Chen , M. Winslett , Y. Cho , S. Kuo, Automatic parallel I/O performance optimization in Panda, Proceedings of the tenth annual ACM symposium on Parallel algorithms and architectures, p.108-118, June 28-July 02, 1998, Puerto Vallarta, Mexico
|
|
|
|
|
|
Yossi Matias , Eran Segal , Jeffrey Scott Vitter, Efficient bundle sorting, Proceedings of the eleventh annual ACM-SIAM symposium on Discrete algorithms, p.839-848, January 09-11, 2000, San Francisco, California, United States
|
|
|
|
|
|
|
|
|
|
|
|
Michael Ortega , Yong Rui , Kaushik Chakrabarti , Sharad Mehrotra , Thomas S. Huang, Supporting similarity queries in MARS, Proceedings of the fifth ACM international conference on Multimedia, p.403-413, November 09-13, 1997, Seattle, Washington, United States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Francis Chu , Joseph Y. Halpern , Praveen Seshadri, Least expected cost query optimization: an exercise in utility, Proceedings of the eighteenth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, p.138-147, May 31-June 03, 1999, Philadelphia, Pennsylvania, United States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Jens-Peter Dittrich , Bernhard Seeger , David Scot Taylor , Peter Widmayer, On producing join results early, Proceedings of the twenty-second ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems, p.134-142, June 09-11, 2003, San Diego, California
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gene Fuh , Jyh-Herng Chow , Nelson Mattos , Brian Tran, Supporting procedural constructs in existing SQL compilers, Proceedings of the 1996 conference of the Centre for Advanced Studies on Collaborative research, p.11, November 12-14, 1996, Toronto, Ontario, Canada
|
|
|
Philippe Rigaux , Michel Scholl , Luc Segoufin , Stéphane Grumbach, Building a constraint-based spatial database system: model, languages, and implementation, Information Systems, v.28 n.6, p.563-595, September 2003
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Yingying Tao , Qiang Zhu , Calisto Zuzarte, Exploiting common subqueries for complex query optimization, Proceedings of the 2002 conference of the Centre for Advanced Studies on Collaborative research, p.12, September 30-October 03, 2002, Toronto, Ontario, Canada
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Jim Smith , Paul Watson , Sandra de F. Mendes Sampaio , Norman Paton, Polar: an architecture for a parallel ODMG compliant object database, Proceedings of the ninth international conference on Information and knowledge management, p.352-359, November 06-11, 2000, McLean, Virginia, United States
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Mike Stonebraker , Daniel J. Abadi , Adam Batkin , Xuedong Chen , Mitch Cherniack , Miguel Ferreira , Edmond Lau , Amerson Lin , Sam Madden , Elizabeth O'Neil , Pat O'Neil , Alex Rasin , Nga Tran , Stan Zdonik, C-store: a column-oriented DBMS, Proceedings of the 31st international conference on Very large data bases, August 30-September 02, 2005, Trondheim, Norway
|
|
|
Jim Smith , Sandra Sampaio , Paul Watson , Norman W. Paton, The Design, Implementation and Evaluation of an ODMG Compliant, Parallel Object Database Server, Distributed and Parallel Databases, v.16 n.3, p.275-319, November 2004
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Michael Ortega , Yong Rui , Kaushik Chakrabarti , Kriengkrai Porkaew , Sharad Mehrotra , Thomas S. Huang, Supporting Ranked Boolean Similarity Queries in MARS, IEEE Transactions on Knowledge and Data Engineering, v.10 n.6, p.905-925, November 1998
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Gültekin Özsoyoǧlu , Ismail Sengör Altingövde , Abdullah Al-Hamdani , Selma Ayşe Özel , Özgür Ulusoy , Zehra Meral özsoyoǧlu, Querying web metadata: Native score management and text support in databases, ACM Transactions on Database Systems (TODS), v.29 n.4, p.581-634, December 2004
|
|
|
Yingying Tao , Qiang Zhu , Calisto Zuzarte , Wing Lau, Optimizing large star-schema queries with snowflakes via heuristic-based query rewriting, Proceedings of the 2003 conference of the Centre for Advanced Studies on Collaborative research, p.279-293, October 06-09, 2003, Toronto, Ontario, Canada
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Q. Yang , W. Zhang , C. Liu , J. Wu , C. Yu , H. Nakajima , N. D. Rishe, Efficient Processing of Nested Fuzzy SQL Queries in a Fuzzy Database, IEEE Transactions on Knowledge and Data Engineering, v.13 n.6, p.884-901, November 2001
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Irina Botan , Donald Kossmann , Peter M. Fischer , Tim Kraska , Dana Florescu , Rokas Tamosevicius, Extending XQuery with window functions, Proceedings of the 33rd international conference on Very large data bases, September 23-27, 2007, Vienna, Austria
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
E. Bertino , S. Salerno , B. Shidlovsky, Enhanced nested-inherited index for OODBMS, Proceedings of the fourth international conference on Information and knowledge management, p.58-65, November 29-December 02, 1995, Baltimore, Maryland, United States
|
|
|
|
|
|
|
|
|
|
|
|
Lei Chen , Raghu Ramakrishnan , Paul Barford , Bee-Chung Chen , Vinod Yegneswaran, Composite subset measures, Proceedings of the 32nd international conference on Very large data bases, September 12-15, 2006, Seoul, Korea
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ryan Huebsch , Joseph M. Hellerstein , Nick Lanham , Boon Thau Loo , Scott Shenker , Ion Stoica, Querying the internet with PIER, Proceedings of the 29th international conference on Very large data bases, p.321-332, September 09-12, 2003, Berlin, Germany
|
|
|
|
|
|
Daniela Florescu , Chris Hillery , Donald Kossmann , Paul Lucas , Fabio Riccardi , Till Westmann , Michael J. Carey , Arvind Sundararajan , Geetika Agrawal, The BEA/XQRL streaming XQuery processor, Proceedings of the 29th international conference on Very large data bases, p.997-1008, September 09-12, 2003, Berlin, Germany
|
|
|
|
|
|
|
|
|
Jens-Peter Dittrich , Bernhard Seeger , David Scot Taylor , Peter Widmayer, Progressive merge join: a generic and non-blocking sort-based join algorithm, Proceedings of the 28th international conference on Very Large Data Bases, p.299-310, August 20-23, 2002, Hong Kong, China
|
|
|
G. Özsoyoǧlu , A. Al-Hamdani , I. S. Altingövde , S. A. Özel , Ö. Ulusoy , Z. M. Özsoyoǧlu, Sideway value algebra for object-relational databases, Proceedings of the 28th international conference on Very Large Data Bases, p.59-70, August 20-23, 2002, Hong Kong, China
|
|
|
|
|
|
|
|
|
Young-Koo Lee , Kyu-Young Whang , Yang-Sae Moon , Il-Yeol Song, A one-pass aggregation algorithm with the optimal buffer size in multidimensional OLAP, Proceedings of the 28th international conference on Very Large Data Bases, p.790-801, August 20-23, 2002, Hong Kong, China
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
T. Fiebig , S. Helmer , C.-C. Kanne , G. Moerkotte , J. Neumann , R. Schiele , T. Westmann, Anatomy of a native XML base management system, The VLDB Journal — The International Journal on Very Large Data Bases, v.11 n.4, p.292-314, December 2002
|
|
|
|
|
|
Stefan Deßloch , Theo Härder , Nelson Mattos , Bernhard Mitschang , Joachim Thomas, Advanced data processing in KRISYS: modeling concepts, implementation techniques, and client/server issues, The VLDB Journal — The International Journal on Very Large Data Bases, v.7 n.2, p.79-95, May 1998
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
R. Braumandl , M. Keidl , A. Kemper , D. Kossmann , A. Kreutz , S. Seltzsam , K. Stocker, ObjectGlobe: Ubiquitous query processing on the Internet, The VLDB Journal — The International Journal on Very Large Data Bases, v.10 n.1, p.48-71, August 2001
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Jim Gray , Surajit Chaudhuri , Adam Bosworth , Andrew Layman , Don Reichart , Murali Venkatrao , Frank Pellow , Hamid Pirahesh, Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals, Data Mining and Knowledge Discovery, v.1 n.1, p.29-53, 1997
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Sameet Agarwal , Rakesh Agrawal , Prasad Deshpande , Ashish Gupta , Jeffrey F. Naughton , Raghu Ramakrishnan , Sunita Sarawagi, On the Computation of Multidimensional Aggregates, Proceedings of the 22th International Conference on Very Large Data Bases, p.506-521, September 03-06, 1996
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Johan List , Vojkan Mihajlovic , Vojkan Mihajlovi , Georgina Ramírez , Arjen P. Vries , Djoerd Hiemstra , Henk Ernst Blok, TIJAH: Embracing IR Methods in XML Databases, Information Retrieval, v.8 n.4, p.547-570, December 2005
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
David E. Simmen , Mehmet Altinel , Volker Markl , Sriram Padmanabhan , Ashutosh Singh, Damia: data mashups for intranet applications, Proceedings of the 2008 ACM SIGMOD international conference on Management of data, June 09-12, 2008, Vancouver, Canada
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Roald Lengu , Paolo Missier , Alvaro A. A. Fernandes , Giovanna Guerrini , Marco Mesiti, Time-completeness trade-offs in record linkage using adaptive query processing, Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology, March 24-26, 2009, Saint Petersburg, Russia
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Dimitris Tsirogiannis , Stavros Harizopoulos , Mehul A. Shah , Janet L. Wiener , Goetz Graefe, Query processing techniques for solid state drives, Proceedings of the 35th SIGMOD international conference on Management of data, June 29-July 02, 2009, Providence, Rhode Island, USA
|
|
|
|
INDEX TERMS
Primary Classification:
E.
Data
Additional Classification:
A.
General Literature
H.
Information Systems
H.2
DATABASE MANAGEMENT
H.2.4
Systems
Subjects:
Query processing
General Terms:
Algorithms,
Performance
Keywords:
complex query evaluation plans,
dynamic query evaluation plans,
extensible database systems,
iterators,
object-oriented database systems,
operator model of parallelization,
parallel algorithms,
relational database systems,
set-matching algorithms,
sort-hash duality
REVIEW
"Margaret H. Dunham : Reviewer"
Graefe has written the first comprehensive study of database query
processing techniques. It is an extremely well written overview of
various query processing problems and solutions. As stated in the
introduction, its target is to survey algor
more...
|