Article

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

Authors:

Chang-Shing Perng,

Douglas Stott Parker, Jr.Authors Info & Claims

DEXA '99: Proceedings of the 10th International Conference on Database and Expert Systems Applications

Pages 218 - 227

Published: 30 August 1999 Publication History

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.

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.

Crossref

Google Scholar

[2]

C. Faloutsos, M. Ranganathan, Y.Manolopoulos. "Fast Subsequence Matching in Time-Series Databases", Proc. SIGMOD'94.

Crossref

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.

Crossref

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.

Crossref

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.

Crossref

Google Scholar

Cited By

View all

Law YWang HZaniolo C(2011)Relational languages and data models for continuous queries on sequences and data streamsACM Transactions on Database Systems10.1145/1966385.196638636:2(1-32)Online publication date: 2-Jun-2011
https://dl.acm.org/doi/10.1145/1966385.1966386
Thakkar HMozafari BZaniolo CLee B(2008)Designing an inductive data stream management systemProceedings of the 2nd international workshop on Scalable stream processing system10.1145/1379272.1379286(79-88)Online publication date: 29-Mar-2008
https://dl.acm.org/doi/10.1145/1379272.1379286
Sadri RZaniolo CZarkesh AAdibi J(2004)Expressing and optimizing sequence queries in database systemsACM Transactions on Database Systems10.1145/1005566.100556829:2(282-318)Online publication date: 1-Jun-2004
https://dl.acm.org/doi/10.1145/1005566.1005568
Show More Cited By

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

Recommendations

Sql: Learn Basics of Queries and Implement Easily (sql programming, SQL 2016, sql database programming, sql for beginners, sql beginners guide, sql ... sql workbook, sql guide, MSSQL) (Volume 1)
SQL/LPP+: A Cascading Query Language for Temporal Correlation Verification
DaWaK '99: Proceedings of the First International Conference on Data Warehousing and Knowledge Discovery

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 ...
2D-LPP: A two-dimensional extension of locality preserving projections

We consider the problem of locality preserving projections (LPP) in two-dimensional sense. Recently, LPP was proposed for dimensionality reduction, which can detect the intrinsic manifold structure of data and preserve the local information. As far as ...

Comments

Information & Contributors

Information

Published In

DEXA '99: Proceedings of the 10th International Conference on Database and Expert Systems Applications

August 1999

1101 pages

ISBN:3540664483

Publisher

Springer-Verlag

Berlin, Heidelberg

Publication History

Published: 30 August 1999

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

4
Total Citations
View Citations
0
Total Downloads

Downloads (Last 12 months)0
Downloads (Last 6 weeks)0

Reflects downloads up to 18 Jan 2025

Other Metrics

View Author Metrics

Citations

Cited By

View all

Law YWang HZaniolo C(2011)Relational languages and data models for continuous queries on sequences and data streamsACM Transactions on Database Systems10.1145/1966385.196638636:2(1-32)Online publication date: 2-Jun-2011
https://dl.acm.org/doi/10.1145/1966385.1966386
Thakkar HMozafari BZaniolo CLee B(2008)Designing an inductive data stream management systemProceedings of the 2nd international workshop on Scalable stream processing system10.1145/1379272.1379286(79-88)Online publication date: 29-Mar-2008
https://dl.acm.org/doi/10.1145/1379272.1379286
Sadri RZaniolo CZarkesh AAdibi J(2004)Expressing and optimizing sequence queries in database systemsACM Transactions on Database Systems10.1145/1005566.100556829:2(282-318)Online publication date: 1-Jun-2004
https://dl.acm.org/doi/10.1145/1005566.1005568
Perng CParker D(2000)Temporal Coupling Verification in Time Series DatabasesJournal of Intelligent Information Systems10.1023/A:100877771133315:1(29-49)Online publication date: 1-Jul-2000
https://dl.acm.org/doi/10.1023/A%3A1008777711333

Abstract

References

Cited By

Recommendations

Sql: Learn Basics of Queries and Implement Easily (sql programming, SQL 2016, sql database programming, sql for beginners, sql beginners guide, sql ... sql workbook, sql guide, MSSQL) (Volume 1)

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

2D-LPP: A two-dimensional extension of locality preserving projections

Comments

Information

Published In

Publisher

Publication History

Qualifiers

Contributors

Other Metrics

Bibliometrics

Article Metrics

Other Metrics

Citations

Cited By

View options

Figures

Other

Share

Share this Publication link

Share on social media

Affiliations