This Article 
 Bibliographic References 
 Add to: 
Petri-Net-Based Modeling and Evaluation of Pipelined Processing of Concurrent Database Queries
November 1988 (vol. 14 no. 11)
pp. 1656-1667

A description is given of a Petri-net-based methodology for modeling and evaluation of pipelined processing of concurrent database queries in an integrated data network (IDN). An extended Petri-net model is presented and used to model two key approaches to concurrent database query processing in the IDN, namely, pipelined and data-flow-based execution of queries and intermediate data sharing among concurrent queries. Database operations are categorized, and the models for the data flow and control flow in them are presented. A general-purpose Petri-net simulator has been developed using event-driven programming techniques and used to simulate the execution of the Petri-net models of some test queries. The results validate the results of a previous analytical evaluation in which the advantages of pipeline and intermediate data sharing were established. Since all the essential details of query processing in the IDN have been simulated, the results of this simulation study are believed to present closely the workings of the actual system.

[1] T. Agerwala, "Some applications of Petri-nets," inProc. Nat. Electron. Conf., Dec. 1978.
[2] T. Agerwala, "Putting Petri-nets to work,"IEEE Comput., Dec. 1979.
[3] M. M. Astrahanet al., "System R: Relational approach to database management,"Trans. Database Syst., vol. 1, no. 1, pp. 97-137, 1976.
[4] Y. Bard, "IBM contribution to performance modelling and simulation," IBM, Res. Rep. RC 8364, July 1980.
[5] L. Bie and M. Herendeen, "An architecture for a relational dataflow database machine," inJoint Proc. SIGMOD Symp. Small Syst. Workshop Small Database Syst., Oct. 1981.
[6] H. Boral and D. J. Dewitt, "Design considerations for dataflow database machines," inProc. ACM-SIGMOD, 1980.
[7] H. Boral and D. J. Dewitt, "Processor allocation strategies for multiprocessor database machines,"ACM Trans. Database Syst., vol. 6, no. 2. June 1981.
[8] H. Boral, "On the use of dataflow techniques in database machines," Dep. Comput. Sci., Univ. Wisconsin, Madison, WI, CSTR#432, May 1981.
[9] S. Ceri and G. Pelagetti, "Correctness of query execution strategies in distributed databases,"ACM Trans. Database Syst., Dec. 1983.
[10] U. S. Chakravarty and J. Minker, "Processing multiple queries in database systems,"IEEE Database Eng., vol. 5, no. 3. Sept. 1982.
[11] J. E. Coolahan and N. Roussopoulos, "Timing requirements for time driven systems using augmented Petri-nets,"IEEE Trans. Software Eng., vol. SE-9, Sept. 1983.
[12] D. J. Dewitt and P. Hawthorn, "A performance evaluation of data-base machine architectures," Dep. Comput. Sci., Univ. Wisconsin, Madison, WI, CSTR# 437, June 1981.
[13] S. Finkelstein, "Common expression analysis in database applications," inProc. 1982 ACM-SIGMOD Int. Conf. Management of Data, Orlando, FL, June 1982.
[14] D. H. Fishman, M. Lai, and K. Wilkinson, "Overview of the Jasmin database machine," inProc. SIGMOD '84, alsoSIGMOD Rec., vol. 14, no. 2, pp. 234-238, 1984.
[15] D. Gajski and W. Kim, "A parallel pipeline relational query processor: An architectural overview," IBM, Res. Rep. RJ4087, Oct. 1983.
[16] M. Hack, "Decidability questions for Petri-nets," Ph.D. dissertation, Dept. Elec. Eng., Massachusetts Inst. Technol., Dec. 1975.
[17] P. Heidelberger and S. S. Lavenberg, "Computer performance evaluation methodology,"IEEE Trans. Comput., vol. C-33, Dec. 1984.
[18] M. Jarke, "Common subexpression isolation in multiple query optimization," inQuery Processing in Database Systems, W. Kim, D. Reiner, and D. Batory, Eds. New York: Springer-Verlag, 1984.
[19] W. Kim, D. Gajski, and D. Kuck, "A parallel pipelined relational query processor,"ACM Trans. Database Syst., June 1984.
[20] P. M. Kogge,The Architecture of Pipelined Computers. New York: McGraw-Hill, 1981.
[21] D. E. Lang, T. Agerwala, and K. M. Chandy, "A modelling approach and design tool for pipelined computers," inProc. Int. Conf. Comput. Architecture, 1979.
[22] K. P. Mikkilineni and S. Y. W. Su, "A dynamic interquery optimization methodology for achieving data sharing among concurrent queries," inProc. Int. Workshop Future Trends of Distributed Computer Systems in the '90s, Sept. 1988.
[23] R. E. Miller, "A comparison of some theoretical methods of parallel computation,"IEEE Trans. Comput., vol. C-22, Aug. 1973.
[24] J. D. Noe and G. J. Nutt, "Macro E nets for representation of parallel systems,"IEEE Trans. Comput., vol. C-22, Aug. 1973.
[25] T. Ozsu, "Modelling and analysis of distributed database concurrency algorithms using an extended petri formalism,"IEEE Trans. Software Eng., vol. SE-11, pp. 1225-1239, Oct. 1985.
[26] J. L. Peterson, "Petri nets,"ACM Comput. Surveys, vol. 9, no. 3, pp. 223-252, Sept. 1977.
[27] J. L. Peterson,Petri Net Theory and the Modeling of Systems. Englewood Cliffs, NJ: Prentice-Hall, 1981.
[28] C. V. Ramamoorthy and S. G. Ho, "Performance evaluation of asynchronous concurrent systems using Petri-nets,"IEEE Trans. Software Eng., vol SE-6, Sept. 1980.
[29] R. K. Shultz and R. J. Zingg, "Response time analysis of multiprocessor computers for database support,"ACM Trans. Database Syst., Mar. 1984.
[30] J. M. Smith and P. Y.-T. Chang, "Optimizing the performance of a relational algebra database interface,"Commun. ACM, vol. 18, no. 10, pp. 568-579, 1975.
[31] J. Smithet al., "Multibase-integrating heterogeneous distributed database systems," inProc. Nat. Comput. Conf., 1981.
[32] M. Stonebraker,et al., "The design and implementation of INGRES,"ACM Trans. Database Syst., vol. 1, no. 3, Sept. 1976.
[33] S. Y. W. Su, K. P. Mikkilineni, R. Liurzi, and R. Chow, "A distributed query processing strategy based on decomposition, pipelining, intermediate result sharing techniques," inProc. COMDEC-86.
[34] J. D. Ullman,Principles of Databases Systems. Rockville, MD: Computer Science Press, 1982.
[35] P. Valduriez and G. Gardarin, "Join and semi-join algorithms for a multiprocessor database machine,"ACM Trans. Database Syst., vol. 9, no. 1, pp. 133-161, 1984.
[36] E. Wong and K. Youssefi, "Decomposition: A strategy for query processing,"ACM Trans. Database Syst., vol. 1, no. 3, Sept. 1976.
[37] W. M. Zuberek, "Timed Petri nets and preliminary performance evaluation," inProc. 7th Annu. Symp. Computer Architecture, May 6-8, 1980, pp. 88-96.
[38] W. M. Zuberek, "Performance evaluation using extended timed Petri-nets," presented at the Int. Worship Timed Petri-Nets, 1985.

Index Terms:
distributed databases; pipelined processing; concurrent database queries; integrated data network; Petri-net model; query processing; intermediate data sharing; event-driven programming; computer networks; digital simulation; distributed databases; Petri nets; pipeline processing; program testing
K.P. Mikkilineni, Y.-C. Chow, S.Y.W. Su, "Petri-Net-Based Modeling and Evaluation of Pipelined Processing of Concurrent Database Queries," IEEE Transactions on Software Engineering, vol. 14, no. 11, pp. 1656-1667, Nov. 1988, doi:10.1109/32.9053
Usage of this product signifies your acceptance of the Terms of Use.