Non-contiguous Sequence Pattern Queries

  • Nikos Mamoulis
  • Man Lung Yiu
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 2992)


Non-contiguous subsequence pattern queries search for symbol instances in a long sequence that satisfy some soft temporal constraints. In this paper, we propose a methodology that indexes long sequences, in order to efficiently process such queries. The sequence data are decomposed into tables and queries are evaluated as multiway joins between them. We describe non-blocking join operators and provide query preprocessing and optimization techniques that tighten the join predicates and suggest a good join order plan. As opposed to previous approaches, our method can efficiently handle a broader range of queries and can be easily supported by existing DBMS. Its efficiency is evaluated by experimentation on synthetic and real data.


Query Processing Range Query Temporal Constraint Pattern Query Query Graph 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    Baeza-Yates, R., Ribeiro-Neto, B.: Modern Information Retrieval. ACM and Mc-Graw Hill (1999)Google Scholar
  2. 2.
    Cheng, Y., Church, G.M.: Biclustering of expression data. In: Proc. of International Conference on Intelligent Systems for Molecular Biology (2000)Google Scholar
  3. 3.
    Dechter, R., Meiri, I., Pearl, J.: Temporal constraint networks. Artificial Intelligence 49(1-3), 61–95 (1991)zbMATHCrossRefMathSciNetGoogle Scholar
  4. 4.
    DeWitt, D.J., Naughton, J.F., Schneider, D.A.: An evaluation of non-equijoin algorithms. In: Proc. of VLDB Conference (1991)Google Scholar
  5. 5.
    Faloutsos, C., Ranganathan, M., Manolopoulos, Y.: Fast subsequence matching in time-series databases. In: Proc. of ACM SIGMOD International Conference on Management of Data (1994)Google Scholar
  6. 6.
    Floyd, R.W.: ACM Algorithm 97: Shortest path. Communications of the ACM 5(6), 345 (1962)CrossRefGoogle Scholar
  7. 7.
    Graefe, G.: Query evaluation techniques for large databases. ACM Computing Surveys 25(2), 73–170 (1993)CrossRefGoogle Scholar
  8. 8.
    Kahveci, T., Singh, A.K.: Efficient index structures for string databases. In: Proc. of VLDB Conference (2001)Google Scholar
  9. 9.
    Mamoulis, N., Papadias, D.: Multiway spatial joins. ACM Transactions on Database Systems (TODS) 26(4), 424–475 (2001)zbMATHCrossRefGoogle Scholar
  10. 10.
    Moon, Y.-S., Whang, K.-Y., Han, W.-S.: General match: a subsequence matching method in time-series databases based on generalized windows. In: Proc. of ACM SIGMOD International Conference on Management of Data (2002)Google Scholar
  11. 11.
    Navarro, G.: A guided tour to approximate string matching. ACM Computing Surveys 33(1), 31–88 (2001)CrossRefGoogle Scholar
  12. 12.
    Ramakrishnan, R., Gehrke, J.: Database Management Systems, 3rd edn. McGraw-Hill, New York (2003)zbMATHGoogle Scholar
  13. 13.
    Wang, H., Perng, C.-S., Fan, W., Park, S., Yu, P.S.: Indexing weighted-sequences in large databases. In: Proc. of Int’l Conf. on Data Engineering, ICDE (2003)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2004

Authors and Affiliations

  • Nikos Mamoulis
    • 1
  • Man Lung Yiu
    • 1
  1. 1.Department of Computer Science and Information SystemsUniversity of Hong KongHong Kong

Personalised recommendations