Skip to main content
SpringerLink
Log in

Providing information system support for simulations using the Cassandra+ system

  • Published:
Annals of Operations Research Aims and scope Submit manuscript

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.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Similar content being viewed by others

References

  1. 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.

  2. P. Balasubramanian and A. Tuzhilin, Using query-driven simulations for querying outcomes of business processes, Decision Support Systems 16(1996)275–295.

    Google Scholar 

  3. J. Banks and J.S. Carson, Discrete-Event System Simulation, Prentice-Hall, Englewood Cliffs, NJ 07632, 1st ed., 1984.

    Google Scholar 

  4. R. Belanger, B. Donovan, K. Morse and D. Rockower, MODSIM II Reference Manual, CACI, 1990.

  5. J. Clifford, A. Croker and A. Tuzhilin, On completeness of historical query languages, ACM Transactions on Database Systems 19(1994)64–116.

    Google Scholar 

  6. Consolidated Analysis Centers, Inc., UNIX SIMSCRIPT II.5 User's Manual, 1987.

  7. R. Elmasri and S. Navathe, Fundamental of Database Systems, Benjamin/Cummings, 2nd ed., 1990.

  8. P. Heidelberger and P.D. Welch, Simulation run length control in the presence of an initial transient, Operations Research 31(1983)1109–1144

    Google Scholar 

  9. Ingres, INGRES/OpenSQL Reference Manual for the UNIX and VMS Operating System, Relational Technology Inc., 1989.

  10. R. Koymans, Specifying real-time properties with metric temporal logic, Journal of Real-Time Systems 2(1990).

  11. A.M. Law and D.W. Kelton, Simulation Modeling and Analysis, McGraw-Hill, 2nd ed., 1991.

  12. Z. Manna and A. Pnueli, The Temporal Logic of Reactive and Concurrent Systems, Springer, 1992.

  13. W. Mendenhall, D.D. Wackerly, and R.L. Scheaffer, Mathematical Statistics with Applications, PWS-KENT, 4th ed., 1990.

  14. J.A. Miller and O.R. Weyrich, Query driven simulation using SIMODULA, in: Proceedings of the 22nd Annual Simulation Symposium, 1989, pp. 167–181.

  15. C.D. Pegden, R.E. Shannon and P.P. Sadowski, Introduction to simulation using SIMAN, McGraw-Hill, New York, 1990.

    Google Scholar 

  16. SAS Institute, Raleigh, NC, SAS User's Guide, 1989.

  17. R. Snodgrass, The temporal query language TQuel, ACM Transactions on Database Systems 12 (1987)247–298.

    Google Scholar 

  18. R. Snodgrass, A relational approach to monitoring complex systems, ACM Transactions on Computer Systems 6((1988)157–196.

    Google Scholar 

  19. 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.

    Google Scholar 

  20. M. Stonebarker, The INGRES Papers: Anatomy of a Relational Database System, Addison-Wesley, 1986.

  21. A. Tuzhilin, SimTL: A simulation language based on temporal logic, Transactions of The Society for Computer Simulation 9(1992)87–100.

    Google Scholar 

  22. 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.

  23. 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.

Download references

Authors
  1. P. Balasubramanian
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Alexander Tuzhilin
    View author publications

    You can also search for this author in PubMed Google Scholar

Rights and permissions

Reprints 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

Download citation

  • Issue Date:

  • DOI: https://doi.org/10.1023/A:1018996221025

Search

Navigation