On conjunctive queries containing inequalities
Journal of the ACM (JACM)
Principles of database and knowledge-base systems, Vol. I
Principles of database and knowledge-base systems, Vol. I
Processing Implication on Queries
IEEE Transactions on Software Engineering
Fast subsequence matching in time-series databases
SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
Solving satisfiability and implication problems in database systems
ACM Transactions on Database Systems (TODS)
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
Temporal aggregation in active database rules
SIGMOD '97 Proceedings of the 1997 ACM SIGMOD international conference on Management of data
PREDATOR: a resource for database research
ACM SIGMOD Record
A fast string searching algorithm
Communications of the ACM
Two-dimensional substring indexing
PODS '01 Proceedings of the twentieth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Models and issues in data stream systems
Proceedings of the twenty-first ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Data Mining Techniques: For Marketing, Sales, and Customer Support
Data Mining Techniques: For Marketing, Sales, and Customer Support
Semantic Query Optimization for Tree and Chain Queries
IEEE Transactions on Knowledge and Data Engineering
IEEE Transactions on Knowledge and Data Engineering
Querying Time Series Data Based on Similarity
IEEE Transactions on Knowledge and Data Engineering
ICDE '95 Proceedings of the Eleventh International Conference on Data Engineering
SEQ: A Model for Sequence Databases
ICDE '95 Proceedings of the Eleventh International Conference on Data Engineering
Using SQL to Build New Aggregates and Extenders for Object- Relational Systems
VLDB '00 Proceedings of the 26th International Conference on Very Large Data Bases
Composite Event Specification in Active Databases: Model & Implementation
VLDB '92 Proceedings of the 18th International Conference on Very Large Data Bases
SRQL: Sorted Relational Query Language
SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
TelegraphCQ: continuous dataflow processing
Proceedings of the 2003 ACM SIGMOD international conference on Management of data
Optimization of sequence queries in database systems
Optimization of sequence queries in database systems
Efficient randomized pattern-matching algorithms
IBM Journal of Research and Development - Mathematics and computing
Monitoring streams: a new class of data management applications
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Efficient evaluation of parameterized pattern queries
Proceedings of the 14th ACM international conference on Information and knowledge management
High-performance complex event processing over streams
Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Data & Knowledge Engineering
Visual Methods for Analyzing Time-Oriented Data
IEEE Transactions on Visualization and Computer Graphics
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Efficient pattern matching over event streams
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Towards a streaming SQL standard
Proceedings of the VLDB Endowment
ZStream: a cost-based query processor for adaptively detecting composite events
Proceedings of the 2009 ACM SIGMOD International Conference on Management of data
A Framework for Trajectory Clustering
GSN '09 Proceedings of the 3rd International Conference on GeoSensor Networks
Querying trajectories using flexible patterns
Proceedings of the 13th International Conference on Extending Database Technology
Online constrained pattern detection over streams
FSKD'09 Proceedings of the 6th international conference on Fuzzy systems and knowledge discovery - Volume 5
Framing the question: detecting and filling spatial-temporal windows
Proceedings of the ACM SIGSPATIAL International Workshop on GeoStreaming
Proceedings of the VLDB Endowment
Recognizing patterns in streams with imprecise timestamps
Proceedings of the VLDB Endowment
Sequenced event set pattern matching
Proceedings of the 14th International Conference on Extending Database Technology
Relational languages and data models for continuous queries on sequences and data streams
ACM Transactions on Database Systems (TODS)
Efficient event stream processing: handling ambiguous events and patterns with negation
DASFAA'11 Proceedings of the 16th international conference on Database systems for advanced applications
Processing flows of information: From data stream to complex event processing
ACM Computing Surveys (CSUR)
Capturing episodes: may the frame be with you
Proceedings of the 6th ACM International Conference on Distributed Event-Based Systems
Event-based concepts for user-driven visualization
Information Visualization
Efficient event pattern matching with match windows
Proceedings of the 18th ACM SIGKDD international conference on Knowledge discovery and data mining
Recognizing patterns in streams with imprecise timestamps
Information Systems
Hi-index | 0.00 |
The need to search for complex and recurring patterns in database sequences is shared by many applications. In this paper, we investigate the design and optimization of a query language capable of expressing and supporting efficiently the search for complex sequential patterns in database systems. Thus, we first introduce SQL-TS, an extension of SQL to express these patterns, and then we study how to optimize the queries for this language. We take the optimal text search algorithm of Knuth, Morris and Pratt, and generalize it to handle complex queries on sequences. Our algorithm exploits the interdependencies between the elements of a pattern to minimize repeated passes over the same data. Experimental results on typical sequence queries, such as double bottom queries, confirm that substantial speedups are achieved by our new optimization techniques.