Abstract
A Query-Driven Simulation (QDS) system Cassandra+ is described that allows end-users to ask temporal queries about outcomes of running simulation models written in various simulation languages. The architecture of Cassandra+, its query language SimQL, and the implementation of the system are described. It is argued that Cassandra+ provides a more effective information systems (IS) support for simulations than the more traditional approaches by letting the users ask questions of interest about simulation outcomes in a declarative, flexible, and interactive fashion. To demonstrate the usefulness and practicality of the QDS approach and Cassandra+ in particular to asking queries about simulation outcomes, we present a case study. In this case study, we show how Cassandra+ performs on an "industrial-strength" manufacturing application developed by the management consulting company of Booz, Allen & Hamilton.
Similar content being viewed by others
Explore related subjects
Discover the latest articles, news and stories from top researchers in related subjects.References
P. Balasubramanian and A. Tuzhilin, Cassandra+: A system for doing query-driven simulation, Working Paper IS-93-40, Leonard N. Stern School of Business, NYU, 1993.
P. Balasubramanian and A. Tuzhilin, Using query-driven simulations for querying outcomes of business processes, Decision Support Systems 16(1996)275–295.
J. Banks and J.S. Carson, Discrete-Event System Simulation, Prentice-Hall, Englewood Cliffs, NJ 07632, 1st ed., 1984.
R. Belanger, B. Donovan, K. Morse and D. Rockower, MODSIM II Reference Manual, CACI, 1990.
J. Clifford, A. Croker and A. Tuzhilin, On completeness of historical query languages, ACM Transactions on Database Systems 19(1994)64–116.
Consolidated Analysis Centers, Inc., UNIX SIMSCRIPT II.5 User's Manual, 1987.
R. Elmasri and S. Navathe, Fundamental of Database Systems, Benjamin/Cummings, 2nd ed., 1990.
P. Heidelberger and P.D. Welch, Simulation run length control in the presence of an initial transient, Operations Research 31(1983)1109–1144
Ingres, INGRES/OpenSQL Reference Manual for the UNIX and VMS Operating System, Relational Technology Inc., 1989.
R. Koymans, Specifying real-time properties with metric temporal logic, Journal of Real-Time Systems 2(1990).
A.M. Law and D.W. Kelton, Simulation Modeling and Analysis, McGraw-Hill, 2nd ed., 1991.
Z. Manna and A. Pnueli, The Temporal Logic of Reactive and Concurrent Systems, Springer, 1992.
W. Mendenhall, D.D. Wackerly, and R.L. Scheaffer, Mathematical Statistics with Applications, PWS-KENT, 4th ed., 1990.
J.A. Miller and O.R. Weyrich, Query driven simulation using SIMODULA, in: Proceedings of the 22nd Annual Simulation Symposium, 1989, pp. 167–181.
C.D. Pegden, R.E. Shannon and P.P. Sadowski, Introduction to simulation using SIMAN, McGraw-Hill, New York, 1990.
SAS Institute, Raleigh, NC, SAS User's Guide, 1989.
R. Snodgrass, The temporal query language TQuel, ACM Transactions on Database Systems 12 (1987)247–298.
R. Snodgrass, A relational approach to monitoring complex systems, ACM Transactions on Computer Systems 6((1988)157–196.
R. Snodgrass, I. Ahn, G. Ariav, D.S. Batory, J. Clifford, C.E. Dyreson, R. Elmasri, F. Grandi, C.S. Jensen, W. Káfer, N. Kline, K. Kulkarni, T.Y.C. Leung, N. Lorentzos, J.F. Roddick, A. Segev, M.D. Soo and S.M. Sripada, TSQL2 language specification, ACM SIGMOD Record 23(1994)65–86.
M. Stonebarker, The INGRES Papers: Anatomy of a Relational Database System, Addison-Wesley, 1986.
A. Tuzhilin, SimTL: A simulation language based on temporal logic, Transactions of The Society for Computer Simulation 9(1992)87–100.
A. Tuzhilin, Applications of temporal databases to knowledge-based simulations, in: Temporal Databases, A. Tansel, J. Clifford, S. Gadia, S. Jajodia, A. Segev and R. Snodgrass, eds., Benjamin Cummings, 1993, pp. 580–593.
A. Tuzhilin and J. Clifford, A temporal relational algebra as a basis for temporal relational completeness, in: Proceedings of the International Conference on Very Large Databases, 1990, pp. 13–23.
Rights and permissions
About this article
Cite this article
Balasubramanian, P., Tuzhilin, A. Providing information system support for simulations using the Cassandra+ system. Annals of Operations Research 72, 183–208 (1997). https://doi.org/10.1023/A:1018996221025
Issue Date:
DOI: https://doi.org/10.1023/A:1018996221025