This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
An Object-Oriented Query Evaluation Scheme for Logical Databases in Massively Parallel Environment
February 1994 (vol. 6 no. 1)
pp. 181-187

Taking advantage of the structure of logical representations, we report an algorithm that evaluates conjunctive queries in a massively parallel environment under an object-based representation for deductive databases. By distributing objects in a database, we show that parallel evaluation of a query can be achieved in a cooperative way so that the conventional tuple-by-tuple, operation-by-operation evaluation strategy can be replaced by a global, parallel matching approach. With the proposed scheme, all conjuncts of a given query can be examined at the same time, which enables us to eliminate the need of any temporary relation. On the other hand, compared with the interpretive method, we show that any data dependency imposed by shared variables is no longer a major problem in achieving AND-parallelism by the proposed scheme.

[1] H. Gallaire, J. Minker, and J. Nicolas, "Logic and databases: A deductive approach,"ACM Comput. Surveys, vol. 16, pp. 153-185,1984.
[2] W. S. Lee, "Parallel evaluation of queries for deductive databases on massively parallel computers," Ph.D. dissertation, School of Elect. Eng., Purdue Univ., May, 1990.
[3] D. Bittonet al., "Parallel algorithms for the execution of relational database operation,"ACM Trans. Database Syst., vol. 8, no. 3, pp. 324-353, Sept. 1983.
[4] M. K. Vernon, E.D. Lazowska, and J. Zahorjan, "An accurate and efficient performance analysis technique for multiprocessor snooping cache-consistency protocols," inProc. 15th Annu. Int. Symp. Comput. Architecture, Honolulu, HI, May 1988, pp. 308-315.
[5] D. J. Dewitt, "Direct-a multiprocessor organization for supporting relational database management systems," inProc. 5th Annu. Symp. Computer Architecture, 1978, pp. 128-189.
[6] H. T. Kung and P. L. Lehman, "Systolic (VLSI) arrays for relational database operations," inProc. ACM Sigmod 1980 Int. Conf. Management Data, May 1980, pp. 105-116.
[7] B. T. Hillyer, D. E. Shaw, and A. Nigram, "NON-VON's performance on certain database benchmarks,"IEEE Trans. Software Eng., Apr. 1986.
[8] C. K. Baru and O. Frieder, "Implementing relational database operations in a cube-connected multicomputer," inProc. IEEE 3rd Int. Conf. Data Eng., Feb. 1987, pp. 36-43.
[9] A. Barr and E. A. Feigenbaum,The Handbook of Artificial Intelligence, vol. I, Los Altos, CA: William Kaufmann, 1981.
[10] C. A. Lee, "Logic, parallelism and semantic networks: The binary predicate execution model," Ph.D. dissertation, Dept. of Inform. and Comput. Sci., Univ. of California, Irvine, 1988.
[11] Y.-J. Lin and V. Kumar, "An execution model for exploiting ANDparallelism in logic programs,"New Generation Computing, vol. 5, 1988.
[12] J.-H. Chang, A. M. Despain, and D. DeGroot, "AND-parallelism of logic programs based on a static data dependency analysis," inProc. COMPCON 85, Feb. 1985.
[13] B. C. Walton, G. D. Dale, and M. R. Jenevein, "A taxonomy and performance model of data skew effects in parallel joins," inProc. 17th Int. Conf. Very Large Databases, 1991, pp. 537-548.
[14] A. K. Hua and C. Lee, "An adaptive data placement scheme for parallel database computer systems," inProc. 16th Int. Conf. Very Large Databases, 1990, pp. 493-506.
[15] O. Ohmori, M. Kitsuregawa, and H. Tanaka, "Scheduling batch transactions on shared nothing parallel database machines: Effect of concurrency and parallelism," inProc. IEEE Int. Conf. Data Engineering, 1991, pp. 210-219.
[16] O. Ohmori, M. Kitsuregawa, and H. Tanaka, "Concurrency control of bulk access transactions on shared nothing parallel catabase machines," inProc. IEEE Int. Conf. Data Eng., 1990, pp. 476-486.
[17] H. Hsiao and D. DeWitt, "Chained Declustering: A New Availability Strategy for Multiprocessor Database Machines,"Proc. Sixth Int'l Conf. Data Engineering, IEEE CS Press, Los Alamitos, Calif., Order No. 2025, 1990, pp. 456-465.
[18] J. Li, J. Srivastava, and D. Rotem, "CMD: A multidimensional declustering method for parallel database systems," inProc. 18th Int. Conf. Very Large Databases, 1992, pp. 3-14.

Index Terms:
object-oriented databases; parallel programming; deductive databases; knowledge based systems; distributed databases; object-oriented query evaluation scheme; logical databases; massively parallel environment; logical representations; conjunctive queries; object-based representation; deductive databases; parallel evaluation; parallel matching approach; interpretive method; data dependency; shared variables; AND-parallelism
Citation:
W.S. Lee, P.C.-Y. Sheu, "An Object-Oriented Query Evaluation Scheme for Logical Databases in Massively Parallel Environment," IEEE Transactions on Knowledge and Data Engineering, vol. 6, no. 1, pp. 181-187, Feb. 1994, doi:10.1109/69.273036
Usage of this product signifies your acceptance of the Terms of Use.