Optimization of sequence queries in database systems

Authors:
Reza Sadri;Carlo Zaniolo;Amir Zarkesh;Jafar Adibi
Affiliations:
Computer Science Department, University of California, Los Angeles, CA;Computer Science Department, University of California, Los Angeles, CA;ZAIAS Technologies Corporation, 5086 Avenida Oriente, Tarzana, CA;ZAIAS Technologies Corporation, 5086 Avenida Oriente, Tarzana, CA
Venue:
PODS '01 Proceedings of the twentieth ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Year:
2001

Citing 13
Cited 30

Fast subsequence matching in time-series databases

SIGMOD '94 Proceedings of the 1994 ACM SIGMOD international conference on Management of data
Sequence query processing

SIGMOD '94 Proceedings of the 1994 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
Data Mining Techniques: For Marketing, Sales, and Customer Support

Data Mining Techniques: For Marketing, Sales, and Customer Support
On Satisfiability, Equivalence, and Implication Problems Involving Conjunctive Queries in Database Systems

IEEE Transactions on Knowledge and Data Engineering
Mining Sequential Patterns

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
SRQL: Sorted Relational Query Language

SSDBM '98 Proceedings of the 10th International Conference on Scientific and Statistical Database Management
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

A Sequential Pattern Query Language for Supporting Instant Data Mining for e-Services

Proceedings of the 27th International Conference on Very Large Data Bases
Complex Temporal Patterns Detection over Continuous Data Streams

ADBIS '02 Proceedings of the 6th East European Conference on Advances in Databases and Information Systems
Pattern Matching over Multi-attribute Data Streams

SPIRE 2002 Proceedings of the 9th International Symposium on String Processing and Information Retrieval
PSoup: a system for streaming queries over streaming data

The VLDB Journal — The International Journal on Very Large Data Bases
Event analyzer: a tool for sequential data processing

CIKM '03 Proceedings of the twelfth international conference on Information and knowledge management
Detection of complex temporal patterns over data streams

Information Systems - Special issue: ADBIS 2002: Advances in databases and information systems
Events on the edge

Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Order checking in a CPOE using event analyzer

Proceedings of the 14th ACM international conference on Information and knowledge management
Efficient evaluation of parameterized pattern queries

Proceedings of the 14th ACM international conference on Information and knowledge management
Mobility Patterns

Geoinformatica
A deferred cleansing method for RFID data analytics

VLDB '06 Proceedings of the 32nd international conference on Very large data bases
A data stream language and system designed for power and extensibility

CIKM '06 Proceedings of the 15th ACM international conference on Information and knowledge management
Parameterized pattern queries

Data & Knowledge Engineering
Streaming queries over streaming data

VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Query languages and data models for database sequences and data streams

VLDB '04 Proceedings of the Thirtieth international conference on Very large data bases - Volume 30
OLAP on sequence data

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Designing an inductive data stream management system: the stream mill experience

SSPS '08 Proceedings of the 2nd international workshop on Scalable stream processing system
The design and implementation of an OLAP system for sequence data analysis

Proceedings of the 2nd SIGMOD PhD workshop on Innovative database research
Scalable complex pattern search in sequential data

Proceedings of the 17th ACM conference on Information and knowledge management
Flexible Framework for Time-Series Pattern Matching over Multi-dimension Data Stream

New Frontiers in Applied Data Mining
Supporting ranking pattern-based aggregate queries in sequence data cubes

Proceedings of the 18th ACM conference on Information and knowledge management
K*SQL: a unifying engine for sequence patterns and XML

Proceedings of the 2010 ACM SIGMOD International Conference on Management of data
From regular expressions to nested words: unifying languages and query execution for relational and XML sequences

Proceedings of the VLDB Endowment
Relational languages and data models for continuous queries on sequences and data streams

ACM Transactions on Database Systems (TODS)
I/O-efficient algorithms for answering pattern-based aggregate queries in a sequence OLAP system

Proceedings of the 20th ACM international conference on Information and knowledge management
AISS: an index for non-timestamped set subsequence queries

DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Querying temporal clinical databases on granular trends

Journal of Biomedical Informatics
Partition and compose: parallel complex event processing

Proceedings of the 6th ACM International Conference on Distributed Event-Based Systems
OLAP-Like analysis of time point-based sequential data

ER'12 Proceedings of the 2012 international conference on Advances in Conceptual Modeling
Fast evaluation of iceberg pattern-based aggregate queries

Proceedings of the 22nd ACM international conference on Conference on information & knowledge management

Quantified Score

Hi-index	0.00

Visualization

Abstract

The need to search for complex and recurring patterns in database sequences is shared by many applications. In this paper, we discuss how to express and support efficiently sophisticated sequential pattern queries in databases. Thus, we first introduce SQL-TS, an extension of SQL, to express these patterns, and then we study how to optimize search 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 inter-dependencies between the elements of a sequential 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.