Querying event sequences by exact match or similarity search: Design and empirical evaluation

Interacting with Computers

Volumn 24, Issue 2, 2012, Pages 55-68

  Wongsuphasawat, Krist ^a,b   Plaisant, Catherine ^a   Taieb Maimon, Meirav ^a,c   Shneiderman, Ben ^a,b  

^a UNIVERSITY OF MARYLAND   (United States)

^b Ben Gurion University of the Negev ^*  (United States)

^c BEN GURION UNIVERSITY OF THE NEGEV   (Israel)

Author keywords

Event sequence; Similan; Similarity measure; Similarity search; Temporal categorical data; Temporal query interface

Indexed keywords

QUERY PROCESSING; REAL TIME SYSTEMS; SEARCH ENGINES;

CATEGORICAL DATA; EVENT SEQUENCE; SIMILAN; SIMILARITY MEASURE; SIMILARITY SEARCH; TEMPORAL QUERIES;

GRAPHICAL USER INTERFACES;

EID: 84857286889     PISSN: 09535438     EISSN: None     Source Type: Journal    
DOI: 10.1016/j.intcom.2012.01.003     Document Type: Article

References (61)

1. W. Aigner, and S. Miksch CareVis: integrated visualization of computerized protocols and temporal patient data Artificial Intelligence in Medicine 37 2006 203 218 (Pubitemid 43903613)
2. S. Altschul, W. Gish, W. Miller, E. Myers, and D. Lipman Basic local alignment search tool Journal of Molecular Biology 215 1990 403 410
3. H. André-Jönsson, and D.Z. Badal Using signature files for querying time-series data Proceedings of the First European Symposium on Principles of Data Mining and Knowledge Discovery (PKDD) 1997 Springer 211 220 (Pubitemid 127097506)
4. B. Bederson, J. Grosjean, and J. Meyer Toolkit design for interactive structured graphics IEEE Transactions on Software Engineering 30 2004 535 546
5. Berndt, D.J.; Clifford, J.; 1994. Using dynamic time warping to find patterns in time series. In: AAAI-94 Workshop on Knowledge Discovery in Databases, pp. 229-248.
6. Bonhomme, C.; Aufaure, M.A.; 2002. Mixing icons, geometric shapes and temporal axis to propose a visual tool for querying spatio-temporal databases. In: Proceedings of Working Conference on Advanced Visual Interfaces (AVI). ACM, pp. 282-289.
7. Bonhomme, C.; Trépied, C.; Aufaure, M.A.; Laurini, R.; 1999. A visual language for querying spatio-temporal databases. In: Proceedings of ACM International Symposium on Advances in Geographic Information Systems (GIS). ACM, pp. 34-39.
8. Carenini, G.; Loyd, J.; 2004. ValueCharts: analyzing linear models expressing preferences and evaluations. In: Proceedings of Working Conference on Advanced Visual Interfaces (AVI). ACM, pp. 150-157.
9. N. Chang, and K. Fu Query-by-pictorial-example IEEE Transactions on Software Engineering 6 1980 519 524
10. Chang, R.; Ghoniem, M.; Kosara, R.; Ribarsky, W.; Yang, J.; Suma, E.; Ziemkiewicz, C.; Kern, D.; Sudjianto, A.; 2007. WireVis: visualization of categorical, time-varying data from financial transactions. In: Proceedings of IEEE Symposium on Visual Analytics Science and Technology (VAST). IEEE, pp. 155-162.
11. Chomicki, J.; 1994. Temporal query languages: a survey. In: Proceedings of International Conference on Temporal Logic. Springer, pp. 506-534.
12. Clifford, J.; Croker, A.; 1987. The historical relational data model (HRDM) and algebra based on lifespans. In: Proceedings of IEEE International Conference on Data Engineering (ICDE). IEEE, pp. 528-537. (Pubitemid 17580404)
13. S. Dobrisek, J. Zibert, N. Pavesić, and F. Mihelic An edit-distance model for the approximate matching of timed strings IEEE Transactions on Pattern Analysis and Machine Intelligence 31 2009 736 741
14. Fails, J.; Karlson, A.; Shahamat, L.; Shneiderman, B.; 2006. A visual interface for multivariate temporal data: finding patterns of events across multiple histories. In: Proceedings of IEEE Symposium on Visual Analytics Science and Technology (VAST). IEEE, pp. 167-174. (Pubitemid 351245909)
15. C. Gómez-Alonso, and A. Valls A similarity measure for sequences of categorical data based on the ordering of common elements V. Torra, Y. Narukawa, Modeling Decisions for Artificial Intelligence vol. 1 2008 Springer 134 145 (Chapter 13)
16. R.W. Hamming Error detecting and error correcting codes The Bell System Technical Journal 29 1950 147 160
17. Hibino, S.; Rundensteiner, E.; 1995. A visual query language for identifying temporal trends in video data. In: Proceedings of International Workshop on Multi-Media Database Management Systems. IEEE, pp. 74-81.
18. Hibino, S.; Rundensteiner, E.A.; 1997. User interface evaluation of a direct manipulation temporal visual query language. In: Proceedings of ACM International Conference on Multimedia (MULTIMEDIA). ACM, pp. 99-107.
19. H. Hochheiser, and B. Shneiderman Dynamic query tools for time series data sets: timebox widgets for interactive exploration Information Visualization 3 2004 1 18
20. B. Jacobs, and C. Walczak A generalized query-by-example data manipulation language based on database logic IEEE Transactions on Software Engineering SE-9 1983 40 57 (Pubitemid 13489525)
21. Jin, J.; Szekely, P.; 2009. QueryMarvel: a visual query language for temporal patterns using comic strips. In: Proceedings of IEEE Symposium on Visual Languages and Human-Centric Computing (VL/HCC). IEEE, pp. 207-214.
22. Karam, G.; 1994. Visualization using timelines. In: Proceedings of ACM SIGSOFT International Symposium on Software Testing and Analysis. ACM, pp. 125-137.
23. Kato, T.; Kurita, T.; Otsu, N.; Hirata, K.; 1992. A sketch retrieval method for full color image database-query by visual example. In: Proceedings of IAPR International Conference on Pattern Recognition. IEEE, pp. 530-533.
24. D. Klimov, Y. Shahar, and M. Taieb-Maimon Intelligent selection and retrieval of multiple time-oriented records Journal of Intelligent Information Systems 35 2009 261 300
25. D. Klimov, Y. Shahar, and M. Taieb-Maimon Intelligent visualization and exploration of time-oriented data of multiple patients Artificial Intelligence in Medicine 49 2010 11 31
26. Klug, A.C.; 1981. Abe: a query language for constructing aggregates-by-example. In: Proceedings of LBL Workshop on Statistical Database Management (SSDBM). Lawrence Berkeley Lab, pp. 190-205.
27. H.W. Kuhn The Hungarian method for the assignment problem Naval Research Logistics Quarterly 2 1955 83 97
28. V.I. Levenshtein Binary codes capable of correcting deletions, insertions and reversals Soviet Physics Doklady 10 1966 707 710
29. Li, W.S.; Candan, K.S.; Hirata, K.; Hara, Y.; 1997. IFQ: a visual query interface and query generator for object-based media retrieval. In: Proceedings of IEEE International Conference on Multimedia Computing and Systems. IEEE, pp. 353-361.
30. Mannila, H.; Moen, P.; 1999. Similarity between event types in sequences. In: Proceedings of International Conference on Data Warehousing and Knowledge Discovery (DaWaK). Springer, pp. 271-280.
31. Mannila, H.; Ronkainen, P.; 1997. Similarity of event sequence. In: Proceedings of International Workshop on Temporal Representation and Reasoning (TIME), pp. 136-139.
32. Mannila, H.; Seppänen, J.; 2001. Finding similar situations in sequences of events via random projections. In: Proceedings of SIAM International Conference on Data Mining, Citeseer, pp. 1-16.
33. M. Mongeau, and D. Sankoff Comparison of musical sequences Computer and the Humanities 24 1990 161 175
34. J. Munkres Algorithms for the assignment and transportation problems Journal of the Society for Industrial and Applied Mathematics 5 1957 32 38
35. G. Navarro A guided tour to approximate string matching ACM Computing Surveys 33 2001 31 88 (Pubitemid 33768480)
36. Obweger, H.; Suntinger, M.; Schiefer, J.; Raidl, G.; 2010. Similarity searching in sequences of complex events. In: Proceedings of International Conference on Research Challenges in Information Science (RCIS). IEEE, pp. 631-640.
37. G. Ozsoyoglu, and H. Wang Example-based graphical database query languages Computer 26 1993 25 38
38. G. Ozsoyoglu, V. Matos, and M. Ozsoyoglu Query processing techniques in the summary-table-by-example database query language ACM Transactions of Database Systems 14 1989 526 573 (Pubitemid 20636901)
39. W.R. Pearson, and D.J. Lipman Improved tools for biological sequence comparison Proceedings of National Academy of Sciences of the United States of America 1988 2444 2448
40. I. Rigoutsos, and a. Floratos Combinatorial pattern discovery in biological sequences: the TEIRESIAS algorithm Bioinformatics 14 1998 55 67 (Pubitemid 28397726)
41. Y. Shahar, D. Goren-Bar, D. Boaz, and G. Tahan Distributed, intelligent, interactive visualization and exploration of time-oriented clinical data and their abstractions Artificial Intelligence in Medicine 38 2006 115 135 (Pubitemid 44693341)
42. Sherkat, R.; Rafiei, D.; 2006. Efficiently evaluating order preserving similarity queries over historical market-basket data. In: Proceedings of International Conference on Data Engineering (ICDE), pp. 19-30.
43. B. Shneiderman Direct manipulation: a step beyond programming languages Computer 16 1983 57 69 (Pubitemid 13590936)
44. Shneiderman, B.; Plaisant, C.; 2006. Strategies for evaluating information visualization tools. In: Proceedings of AVI Workshop on Beyond Time and Errors Novel Evaluation Methods for Information Visualization (BELIV). ACM, pp. 1-7.
45. R. Snodgrass The temporal query language TQuel ACM Transactions of Database Systems 12 1987 247 298
46. R.T. Snodgrass The TSQL2 Temporal Query Language 1995 Kluwer Academic Publishers
47. A. Tansel, and E. Tin The expressive power of temporal relational query languages IEEE Transactions on Knowledge and Data Engineering 9 1997 120 134 (Pubitemid 127772253)
48. A. Tansel, M. Arkun, and G. Ozsoyoglu Time-by-example query language for historical databases IEEE Transactions on Software Engineering 15 1989 464 478 (Pubitemid 20603370)
49. J.W. Tukey Exploratory Data Analysis 1977 Addison-Wesley
50. Vrotsou, K.; 2010. Everyday Mining Exploring Sequences in Event-based Data. Ph.D. thesis. Linkoping University.
51. Vrotsou, K.; Forsell, C.; 2011. A qualitative study of similarity measures in event-based data. In: Proceedings of Human Interface and the Management of Information. Interacting with Information Symposium on Human Interface, Springer. pp. 170-179.
52. K. Vrotsou, J. Johansson, and M. Cooper ActiviTree: interactive visual exploration of sequences in event-based data using graph similarity IEEE Transactions on Visualization and Computer Graphics 15 2009 945 952
53. Wang, T.D.; Plaisant, C.; Quinn, A.J.; Stanchak, R.; Murphy, S.; Shneiderman, B.; 2008. Aligning temporal data by sentinel events: discovering patterns in electronic health records. In: Proceedings of Annual SIGCHI Conference on Human Factors in Computing Systems (CHI). ACM, pp. 457-466.
54. T.D. Wang, C. Plaisant, B. Shneiderman, N. Spring, D. Roseman, G. Marchand, V. Mukherjee, and M. Smith Temporal summaries: supporting temporal categorical searching, aggregation and comparison IEEE Transactions on Visualization and Computer Graphics 15 2009 1049 1056
55. Watai, Y.; Yamasaki, T.; Aizawa, K.; 2007. View-based web page retrieval using interactive sketch query. In: Proceedings of IEEE International Conference on Image Processing. IEEE, pp. 357-360.
56. Wattenberg, M.; 2001. Sketching a graph to query a time-series database. In: Proceedings of Annual SIGCHI Conference on Human Factors in Computing Systems (CHI) - Extended Abstracts. ACM, pp. 381-382.
57. White, R.W.; Roth, R.A.; 2009. Exploratory search: beyond the query-response paradigm. In: Synthesis Lectures on Information Concepts, Retrieval, and Services, pp. 1-98.
58. Winkler, W.E.; 1999. The State of Record Linkage and Current Research Problems. Technical Report. Statistical Research Division, US Census Bureau.
59. Wongsuphasawat, K.; Shneiderman, B.; 2009. Finding comparable temporal categorical records: a similarity measure with an interactive visualization. In: Proceedings of IEEE Symposium on Visual Analytics Science and Technology (VAST). IEEE, pp. 27-34.
60. Zloof, M.M.; 1975. Query by example. In: Proceedings of National Computer Conference and Exposition (AFIPS). ACM, pp. 431-438.
61. M. Zloof Office-by-example: a business language that unifies data and word processing and electronic mail IBM Systems Journal 21 1982 272 304 (Pubitemid 12548529)