Skip to main content
SpringerLink
Log in

Temporal PSM

  • Reference work entry
  • First Online:
Encyclopedia of Database Systems

  • 10 Accesses

Synonyms

Persistent Stored Modules

Definition

Temporal PSM is an extension of persistent stored modules (PSM) in SQL to add temporal support [1]. Persistent stored modules make up the Turing-complete portion of SQL and provide structured programming constructs (e.g., IF, WHILE). PSM also includes support for procedures which can be called directly and functions which can be invoked from within an SQL query (modification, view, cursor, etc.). Temporal PSM requires minor new syntax beyond that already in SQL/Temporal to define and to invoke PSM procedures and functions, thereby extending the current, sequenced, and nonsequenced semantics of queries to such routines.

Historical Background

Temporal query languages are now fairly well understood, as indicated by support in prominent DBMSes. Procedures and functions in the form of Persistent Stored Modules (PSM) have been included in the SQL standard and implemented in numerous DBMSes [2].

The SQL standard includes stored routines in part 4:...

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

Access this chapter

Log in via an institution
Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 4,499.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Hardcover Book
USD 6,499.99
Price excludes VAT (USA)
  • Durable hardcover edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Recommended Reading

  1. Snodgrass RT, Gao D, Zhang R, Thomas SW. Temporal support for persistent stored modules. In: Proceedings of the 28th International Conference on Data Engineering, Arlington; 2012. p. 114–25.

    Google Scholar 

  2. Melton J. Understanding SQL’s stored procedures: a complete guide to SQL/PSM. San Francisco: Kaufmann Publishers; 1998.

    MATH  Google Scholar 

  3. ISO/IEC. Information technology—database languages—SQL 9075. Geneva: ISO; 2011.

    Google Scholar 

  4. Snodgrass RT. Developing time-oriented database applications in SQL; San Francisco: Morgan Kaufmann Publishers; 1999, p. 504+xxiii. ISBN:1-55860-436-7.

    Google Scholar 

  5. Snodgrass RT, Böhlen MH, Jensen CS, Steiner A. Adding transaction time to SQL/temporal. SQL3 Standards Committee, change proposal ANSI X3H2-96-502r2, ISO/IEC JTC1/SC21/ WG3 DBL MAD-147r2; Nov 1996.

    Google Scholar 

  6. Snodgrass RT, Böhlen MH, Jensen CS, Steiner A. Adding valid time to SQL/temporal. SQL3 Standards Committee, change proposal ANSI X3H2-96-501r2, ISO/IEC JTC1/SC21/ WG3 DBL MAD-146r2; Nov 1996.

    Google Scholar 

  7. Snodgrass RT, Ahn I. Temporal databases. IEEE Comput. 1986;19(9):35–42.

    Article  MATH  Google Scholar 

  8. Bair J, Böhlen M, Jensen CS, Snodgrass RT. Notions of upward compatibility of temporal query languages. Bus Inform (Wirtschafts Informatik). 1997;39(1):25–34.

    Google Scholar 

  9. Böhlen MH, Jensen CS, Snodgrass RT. Temporal statement modifiers. ACM Trans Database Syst. 2000;25(4):407–56.

    Article  MATH  Google Scholar 

  10. Gao D. Supporting the procedural component of query languages over time-varying data. Ph.D. dissertation, Computer Science Department, University of Arizona, Apr 2009.

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Computer Science, University of Arizona, Tucson, AZ, USA

    Richard T. Snodgrass

  2. IBM Silicon Valley Lab, San Jose, CA, USA

    Dengfeng Gao

  3. University of Melbourne, Melbourne, VIC, Australia

    Rui Zhang

  4. Dataware Ventures, Tucson, AZ, USA

    Richard T. Snodgrass & Rui Zhang

  5. Dataware Ventures, Redondo Beach, CA, USA

    Rui Zhang

  6. Dataware Ventures, Kingston, ON, Canada

    Stephen W. Thomas

  7. University of Arizona, Tucson, AZ, USA

    Jennifer Dempsey

  8. Raytheon Missile Systems, Tucson, AZ, USA

    Jennifer Dempsey

Authors
  1. Richard T. Snodgrass
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Dengfeng Gao
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Rui Zhang
    View author publications

    You can also search for this author in PubMed Google Scholar

  4. Stephen W. Thomas
    View author publications

    You can also search for this author in PubMed Google Scholar

  5. Jennifer Dempsey
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Richard T. Snodgrass .

Editor information

Editors and Affiliations

  1. Georgia Institute of Technology College of Computing, Atlanta, GA, USA

    Ling Liu

  2. University of Waterloo School of Computer Science, Waterloo, ON, Canada

    M. Tamer Özsu

Rights and permissions

Reprints and permissions

Copyright information

© 2018 Springer Science+Business Media, LLC, part of Springer Nature

About this entry

Check for updates. Verify currency and authenticity via CrossMark

Cite this entry

Snodgrass, R.T., Gao, D., Zhang, R., Thomas, S.W., Dempsey, J. (2018). Temporal PSM. In: Liu, L., Özsu, M.T. (eds) Encyclopedia of Database Systems. Springer, New York, NY. https://doi.org/10.1007/978-1-4614-8265-9_80731

Download citation

Publish with us

Policies and ethics

Search

Navigation