Skip to main content
SpringerLink
Log in

SQL/LPP+: A Cascading Query Language for Temporal Correlation Verification

  • Conference paper
  • First Online:
Book cover DataWarehousing and Knowledge Discovery (DaWaK 1999)

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

Included in the following conference series:

  • 840 Accesses

Abstract

In this paper, we present SQL/LPP+, a temporal correlation verification language for time series databases, SQL/LPP+ is an extension of SQL/LPP[6] and inherits its ability to define time series patterns. SQL/LPP+ enables users to cascade multiple patterns using one or more of Allens temporal relationships, and obtain the desired aggregates or meta-aggregates of the composition. The issues of pattern composition control are also discussed.

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 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.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. Allen, J.F. Maintaining knowledge about temporal intervals. Communications of the ACM, vol.26, (no.11), Nov. 1983. p.832–43.

    Article  MATH  Google Scholar 

  2. Usama M. Fayyad, Gregory Piatetsky-Shapiro, Padhraic Smyth, and Ramasamy Uthurusamy, Advances in Knowledge Discovery and Data Mining, ISBN 0-262-56097-6, MIT Press, 1996.

    Google Scholar 

  3. D.E. Knuth. The Texbook: A Complete Guide to Computer Typesetting With Tex. Addison-Wesley Pub Co; ISBN: 0201134489, April 1988.

    Google Scholar 

  4. R. D. Edwards, J. Magee. Technical Analysis of Stock Trends. 7th Edition, AMACOM, May 1, 1997.

    Google Scholar 

  5. C.S. Perng, D.S. Parker SQL/LPP:a Time Series Extension of SQL based on Limited Patience Patterns, Technical Report 980034 UCLA, Computer Science.

    Google Scholar 

  6. C.S. Perng, D.S. Parker SQL/LPP:a Time Series Extension of SQL based on Limited Patience Patterns, DEXA 1999.

    Google Scholar 

  7. Hagit Shatkay, Stanley B. Zdonik. Approximate Queries and Representations for Large Data Sequences. ICDE 1996: 536–545

    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. School of Computer and Information Science, University of South Australia, The Levels, Adelaide, Australia, 05

    Mukesh Mohania

  2. 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., Stott Parker, D. (1999). SQL/LPP+: A Cascading Query Language for Temporal Correlation Verification. In: Mohania, M., Tjoa, A.M. (eds) DataWarehousing and Knowledge Discovery. DaWaK 1999. Lecture Notes in Computer Science, vol 1676. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48298-9_36

Download citation

  • DOI: https://doi.org/10.1007/3-540-48298-9_36

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-66458-1

  • Online ISBN: 978-3-540-48298-7

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation