Expressing and optimizing sequence queries in database systems

ACM Transactions on Database Systems

Volumn 29, Issue 2, 2004, Pages 282-318

  Sadri, Reza ^a   Zaniolo, Carlo ^b   Zarkesh, Amir ^c   Adibi, Jafar ^d  

^a Procom Technology Inc   (United States)

^b Engineering IV   (United States)

^c 3Plus1 Technology Inc   (United States)

^d UNIVERSITY OF SOUTHERN CALIFORNIA   (United States)

Author keywords

Query optimization; Searching; Sequences; Time series

Indexed keywords

QUERY OPTIMIZATION; SEARCHING; SEQUENCES; TIME SERIES;

ALGORITHMIC LANGUAGES; ALGORITHMS; DATABASE SYSTEMS; ONLINE SEARCHING; OPTIMIZATION; SOFTWARE PROTOTYPING; TIME SERIES ANALYSIS;

QUERY LANGUAGES;

EID: 3142592507     PISSN: 03625915     EISSN: None     Source Type: Journal    
DOI: 10.1145/1005566.1005568     Document Type: Article

References (38)

1. AGRAWAL, R. AND SRIKANT, R. 1995. Mining sequential patterns. In Proceedings of the International Conference on Data Engineering.
2. ALUR, N., HAAS, P., MOMIROSKA, D., READ, P., SUMMERS, N., TOTANBS, V., AND ZUZARTE, C. 2002. Db2 UDBS high-function business intelligence in e-business. IBM redbooks, IBM, http://www.redbooks.ibm.com/redbooks/pdfs/ sg246546.pdf.
3. ARASU, A., BABU, S., AND WIDOM, J. 2002. An abstract semantics and concrete language for continuous queries over streams and relations. Tech. rep., Stanford Univ., Stanford, Calif.
4. BABCOCK, B., BABU, S., DATAR, M., MOTAWANI, R., AND WIDOM, J. 2002. Models and issues in data stream systems. In Proceedings of the 21st ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems. ACM, New York, 1-16.
5. BERRY, M. AND LINOFF, M. 1996. Data Mining Techniques for Marketing, Sales, and Customer Support. Wiley, New York.
6. BOAG, S., CHAMBERLIN, D., FERNANDEZ, M. F., FLORESCU, D., ROBIE, J., AND SIMEON, J. (EDS.). 2003. Xquery 1.0: An XML query language-working draft 22 august 2003. Working Draft 22 August 2003. W3C, http://www.w3.org/tr/xquery/.
7. BOYER, R. S. AND MOORE, J. S. 1977. A fast string searching algorithm. Commun. ACM 20, 10, 762-772.
8. CARNEY, D., CETINTEMEL, U., CHERNIACK, M., CONVEY, C., LEE, S., SEIDMAN, G., STONEBRAKER, M., TATBUL, N., AND ZDONIK, S. 2002. Monitoring streams - A new class of data management applications. In VLDB (Hong Kong, China).
9. CHANDRASEKARAN, S., COOPER, O., DESHPANDE, A., FRANKLIN, M. J., HELLERSTEIN, J. M., HONG, W., KRISHNAMURTHY, S., MADDEN, S. R., RAMAN, V., REISS, F., AND SHAH, M. A. 2003. Telegraphcq: Continuous dataflow processing for an uncertain world. In CIDR 2003: First Biennial Conference on Innovative Data Systems Research (Asilomar, Calif., Jan. 5-8).
10. EDWARDS, R. AND MAGEE, J. 1997. Technical Analysis of Stock Trends. AMACOM.
11. FALOUTSOS, C., RANGANATHAN, M., AND MANOLOPOULOS, Y. 1994. Fast subsequence matching in time-series databases. In Proceedings of the International Conference on Management of Data. 419-429.
12. FERRAGINA, P., KOUDAS, N., MUTHUKHISHNAN, S., AND SRIVASTAVA, D. 2001. Two-dimensional substring indexing. In Proceedings of the 20th ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems (Santa Barbara, Calif., May 21-23). ACM, New York.
13. GATZIU, S. AND DITTRICH, K. R. 1993. Events in an object-oriented database system. In Proceedings of the 1st International Conference on Rules in Database Systems.
14. GEHANI, N. H., JAGADISH, H. V. AND SHMUELI, O. 1992. Composite event specification in active databases: Model and implementation. In Proceedings of the 18th International Conference on Very Large Data Bases.
15. GUO, S., SUN, W., AND WEISS, M. 1996a. On satisfiability, equivalence, and implication problems involving conjunctive queries in database systems. IEEE Trans. Knowl. Data Eng. 8, 4, 604-616.
16. GUO, S., SUN, W., AND WEISS, M. A. 1996b. Solving satisfiability and implication problems in database systems. ACM Trans. Datab. Syst. 21, 2, 270-293.
17. HELLERSTEIN, J. M., HASS, P. J., AND WANG, H. J. 1997. Online aggregation. In Proceedings of the International Conference on Management of Data. ACM, New York, 171-182.
18. INFORMIX SOFTWARE, INC. 1998. Managing time-series data in financial applications. White Paper.
19. KARP, R. AND RABIN, M. O. 1987. Efficient randomized pattern matching algorithms. IBM J. Res. Devel. 31, 2 (Mar.), 249-260.
20. KLUG, A. 1988. On conjunctive queries containing inequalities. J. ACM 35, 1, 146-160.
21. KNUTH, D. E., MORRIS, J. H., AND PRATT, V. R. 1997. Fast pattern matching in strings. SIAM J. Comput. 6, 2 (June), 323-350.
22. MESROBIAN, E., MUNTZ, R., SANTOS, J., SHEK, E., MECHOSO, C., FARHARA, J., AND STOLORZ, P. 1994, Extracting spatio-temporal patterns from geoscience datasets. In Proceedings of the IEEE Workshop on Visualization and Machine Vision.
23. MOTAKIS, I. AND ZANIOLO, C. 1997. Temporal aggregation in active databases. In Int. Conf. on the Managment of Data.
24. PERNG, C.-S. AND PARKER, D. S. 1999. SQL/LPP: A time series extension of SQL based on limited patience patterns. In Database and Expert Systems Applications, 10th International Conference (DEXA '99). Lecture Notes in Computer Science, vol. 1677. Springer-Verlag, New York.
25. RAFIEI, D. AND MENDELZON, A. 2000. Querying time series data based on similarity. TKDE 12, 5, 675-693.
26. RAMAKRISHNAN, R., DONJERKOVIC, D., RANGANATHAN, A., BEYER, K., AND KRISHNAPRASAD, M. 1998. SRQL: Sorted relational query language. In Proceedings of the 10th Annual International Conference on Scientific and Statistical Database Management (Capri, Italy, July 1-3). IEEE Computer Society Press, Los Alamitos, Calif., 84-95.
27. ROSENKRANTZ, D. AND HUNT III, H. B. 1970. Processing conjunctive predicates and queries. In Proceedings of the 6th International Conference on Very Large Databases. 64-72.
28. SADRI, R. 2001. Optimization of sequence queries in database systems. Ph.D. thesis, University of California, Los Angeles.
29. SESHADRI, P. 1998. Predator: A resource for database research. SIGMOD Record 27, 1, 16-20.
30. SESHADRI, P., LINVY, M., AND RAMAKRISHNAN, R. 1994. Sequence query processing. In Proceedings of ACM SIGMOD Conference on Management of Data. ACM, New York, 430-441.
31. SESHADRI, P., LIVNY, M., AND RAMAKRISHNAN, R. 1995. SEQ: A model for sequence databases. In ICDE. 232-239.
32. SUN, W. AND YU, C. 1994. Semantic query optimization for tree and chain queries. IEEE Trans. Knowl. Data Eng. 6, 5.
33. SUN, X., KAMELL, N. N., AND NI, L. M. 1989. Processing implication on queries. IEEE Trans. Softw. Eng. B, 10 (Oct.), 168-175.
34. ULLMAN, J. D. 1989. Principles of Database and Knowledge-Base Systems. Vol. 2. Computer Science Press.
35. WANG, H. AND PERNG, C. 2003. The s2-tree: An index structure for subsequence matching of spatial objects. In Proceedings of the 5th Pacific-Asic Conference on Knowledge Discovery and Data Mining (PAKDD) (Hong Kong, China).
36. WANG, H. AND ZANIOLO, C. 2000. Using SQL to build new aggregates and extenders for object-relational systems. In Proceedings of 26th International Conference on Very Large Data Bases.
37. WEIGHT, C. A., CUMBERLAND, L., AND FENG, Y. 1998. A performance comparison between five string pattern matching algorithms. Technical Report, http://ocean.st.usm.edu/~cawright/pattern.matching.html.
38. ZEMKE, F., KULKARNI, K., WITKOWSKI, A., AND LYLE, B. 1999. Proposal for OLAF functions. Tech. Rep. ANSI NCITS H2-99-155, ISO/IEC JTC1/SC32 WG3:YGJ-nnn, http://ganga.iiml.ac.in/~bhasker/dmds/99-154.pdf.