Skip to main content
SpringerLink
Log in

SQL/LPP: A Time Series Extension of SQL Based on Limited Patience Patterns

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 1999)

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 1677))

Included in the following conference series:

Abstract

In this paper, we introduce SQL/LPP, a time series extension of SQL. SQL/LPP is based on Limited Patience Patterns, a temporal pattern model that is expressive, practical, intuitive, and supports a declarative algebraic syntax permitting query optimization. We illustrate basic features of SQL/LPP, showing the definition and use of popular time series patterns.

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 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight 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

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. R. Agrawal, G. Psaila, E. L. Wimmers, M. Zait. Querying Shapes of Histories, Proc, of the 21st Int’l Conference on Very Large Databases, Zurich, Switzerland, September 1995.

    Google Scholar 

  2. C. Faloutsos, M. Ranganathan, Y. Manolopoulos. “Fast Subsequence Matching in Time-Series Databases”, Proc. SIGMOD—94.

    Google Scholar 

  3. Informix Software Inc. Informix TimeSeries DataBlade Module User’s Guide Version 3.1.

    Google Scholar 

  4. D. Schmidt et al. Time Series, a Neglected Issue in Temporal Database Research? In Recent Advances in Temporal Databases. 1995.

    Google Scholar 

  5. I. Motakis, C. Zaniolo. Temporal Aggregation in Active Database Rules SIGMOD Conference 1997: 440–451.

    Google Scholar 

  6. P. Seshadri, M. Livny, R. Ramakrishnan. SEQ: A Model for Sequence Databases. Proceedings of the IEEE Conference on Data Engineering, March 1995.

    Google Scholar 

  7. P. Seshadri, M. Livny, R. Ramakrishnan. Sequence Query Processing. Proceedings of the ACM SIGMOD Conference on Data Management. May 1994.

    Google Scholar 

  8. R.T. Snodgrass (ed.) The TSQL2 Temporal Query Language. New York: Kluwer Academic Publishing, 1995.

    MATH  Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Dept. of Computer Science, University of California, Los Angeles

    Chang-Shing Perng & D. Stott Parker

Authors
  1. Chang-Shing Perng
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. D. Stott Parker
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Editors and Affiliations

  1. Department of Computer Science, University of Liverpool, P.O. Box 147, Liverpool, L49 3BX, UK

    Trevor J.M. Bench-Capon

  2. Department of Systems and Computers, University of Florence, Via S. Marta, 3, I-50139, Florence, Italy

    Giovanni Soda

  3. IFS, Technical University of Vienna, Resselgasse 3, A-1040, Vienna, Austria

    A Min Tjoa

Rights and permissions

Reprints and permissions

Copyright information

© 1999 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Perng, CS., Parker, D.S. (1999). SQL/LPP: A Time Series Extension of SQL Based on Limited Patience Patterns. In: Bench-Capon, T.J., Soda, G., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 1999. Lecture Notes in Computer Science, vol 1677. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48309-8_20

Download citation

  • DOI: https://doi.org/10.1007/3-540-48309-8_20

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-66448-2

  • Online ISBN: 978-3-540-48309-0

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation