{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,27]],"date-time":"2025-03-27T14:11:48Z","timestamp":1743084708422,"version":"3.40.3"},"publisher-location":"Cham","reference-count":30,"publisher":"Springer International Publishing","isbn-type":[{"type":"print","value":"9783030114039"},{"type":"electronic","value":"9783030114046"}],"license":[{"start":{"date-parts":[[2019,1,1]],"date-time":"2019-01-01T00:00:00Z","timestamp":1546300800000},"content-version":"tdm","delay-in-days":0,"URL":"http:\/\/www.springer.com\/tdm"}],"content-domain":{"domain":["link.springer.com"],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2019]]},"DOI":"10.1007\/978-3-030-11404-6_9","type":"book-chapter","created":{"date-parts":[[2019,1,29]],"date-time":"2019-01-29T03:02:59Z","timestamp":1548730979000},"page":"110-125","update-policy":"https:\/\/doi.org\/10.1007\/springer_crossmark_policy","source":"Crossref","is-referenced-by-count":1,"title":["Benchmarking and Performance Analysis of Event Sequence Queries on Relational Database"],"prefix":"10.1007","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-5746-1743","authenticated-orcid":false,"given":"Yuto","family":"Hayamizu","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Ryoji","family":"Kawamichi","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-0618-4157","authenticated-orcid":false,"given":"Kazuo","family":"Goda","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"ORCID":"https:\/\/orcid.org\/0000-0003-4027-2994","authenticated-orcid":false,"given":"Masaru","family":"Kitsuregawa","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"297","published-online":{"date-parts":[[2019,1,30]]},"reference":[{"key":"9_CR1","unstructured":"Agrawal, R., Srikant, R.: Mining sequential patterns. In: Proceedings of the Eleventh International Conference on Data Engineering, ICDE 1995, pp. 3\u201314. IEEE Computer Society, Washington, DC (1995)"},{"key":"9_CR2","doi-asserted-by":"crossref","unstructured":"Alagiannis, I., Borovica, R., Branco, M., Idreos, S., Ailamaki, A.: NoDB: efficient query execution on raw data files. In: Proceedings of the 2012 ACM SIGMOD International Conference on Management of Data, SIGMOD 2012, pp. 241\u2013252. ACM, New York (2012)","DOI":"10.1145\/2213836.2213864"},{"key":"9_CR3","doi-asserted-by":"crossref","unstructured":"Ayres, J., Flannick, J., Gehrke, J., Yiu, T.: Sequential PAttern mining using a bitmap representation. In: Proceedings of the Eighth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, KDD 2002, pp. 429\u2013435. ACM, New York (2002)","DOI":"10.1145\/775047.775109"},{"key":"9_CR4","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"103","DOI":"10.1007\/978-3-319-72401-0_8","volume-title":"Performance Evaluation and Benchmarking for the Analytics Era","author":"P Boncz","year":"2018","unstructured":"Boncz, P., Anatiotis, A.-C., Kl\u00e4be, S.: JCC-H: adding join crossing correlations with\u00a0skew to TPC-H. In: Nambiar, R., Poess, M. (eds.) TPCTC 2017. LNCS, vol. 10661, pp. 103\u2013119. Springer, Cham (2018). \n                    https:\/\/doi.org\/10.1007\/978-3-319-72401-0_8"},{"key":"9_CR5","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"61","DOI":"10.1007\/978-3-319-04936-6_5","volume-title":"Performance Characterization and Benchmarking","author":"P Boncz","year":"2014","unstructured":"Boncz, P., Neumann, T., Erling, O.: TPC-H analyzed: hidden messages and lessons learned from an influential benchmark. In: Nambiar, R., Poess, M. (eds.) TPCTC 2013. LNCS, vol. 8391, pp. 61\u201376. Springer, Cham (2014). \n                    https:\/\/doi.org\/10.1007\/978-3-319-04936-6_5"},{"key":"9_CR6","unstructured":"Chan, K.P., Fu, A.W.C.: Efficient time series matching by wavelets. In: Proceedings 15th International Conference on Data Engineering (Cat. No. 99CB36337), pp. 126\u2013133, March 1999"},{"key":"9_CR7","doi-asserted-by":"crossref","unstructured":"Chaudhuri, S.: An overview of query optimization in relational systems. In: Proceedings of the Seventeenth ACM SIGACT-SIGMOD-SIGART Symposium on Principles of Database Systems, PODS 1998, pp. 34\u201343. ACM, New York (1998)","DOI":"10.1145\/275487.275492"},{"issue":"2","key":"9_CR8","doi-asserted-by":"publisher","first-page":"187","DOI":"10.1016\/0004-3702(85)90003-7","volume":"25","author":"TG Dietterich","year":"1985","unstructured":"Dietterich, T.G., Michalski, R.S.: Discovering patterns in sequences of events. Artif. Intell. 25(2), 187\u2013232 (1985)","journal-title":"Artif. Intell."},{"key":"9_CR9","unstructured":"Hacigumus, H., Chi, Y., Wu, W., Zhu, S., Tatemura, J., Naughton, J.F.: Predicting query execution time: are optimizer cost models really unusable? In: Proceedings of the 2013 IEEE International Conference on Data Engineering (ICDE 2013), ICDE 2013, pp. 1081\u20131092. IEEE Computer Society, Washington, DC (2013)"},{"key":"9_CR10","unstructured":"Han, J., Dong, G., Yin, Y.: Efficient mining of partial periodic patterns in time series database. In: Proceedings 15th International Conference on Data Engineering (Cat. No. 99CB36337), pp. 106\u2013115, March 1999"},{"key":"9_CR11","doi-asserted-by":"crossref","unstructured":"Han, J., Pei, J., Mortazavi-Asl, B., Chen, Q., Dayal, U., Hsu, M.C.: FreeSpan: frequent pattern-projected sequential pattern mining. In: Proceedings of the Sixth ACM SIGKDD International Conference on Knowledge Discovery and Data Mining, KDD 2000, pp. 355\u2013359. ACM, New York (2000)","DOI":"10.1145\/347090.347167"},{"key":"9_CR12","doi-asserted-by":"crossref","unstructured":"Keogh, E.: Exact indexing of dynamic time warping. In: Proceedings of the 28th International Conference on Very Large Data Bases, VLDB 2002, pp. 406\u2013417. VLDB Endowment (2002)","DOI":"10.1016\/B978-155860869-6\/50043-3"},{"key":"9_CR13","doi-asserted-by":"crossref","unstructured":"Law, Y.N., Wang, H., Zaniolo, C.: Query languages and data models for database sequences and data streams. In: Proceedings of the Thirtieth International Conference on Very Large Data Bases - Volume 30, VLDB 2004, pp. 492\u2013503. VLDB Endowment (2004)","DOI":"10.1016\/B978-012088469-8.50045-0"},{"issue":"3","key":"9_CR14","doi-asserted-by":"publisher","first-page":"204","DOI":"10.14778\/2850583.2850594","volume":"9","author":"V Leis","year":"2015","unstructured":"Leis, V., Gubichev, A., Mirchev, A., Boncz, P., Kemper, A., Neumann, T.: How good are query optimizers, really? Proc. VLDB Endow. 9(3), 204\u2013215 (2015)","journal-title":"Proc. VLDB Endow."},{"issue":"1","key":"9_CR15","doi-asserted-by":"publisher","first-page":"982","DOI":"10.14778\/1687627.1687738","volume":"2","author":"G Moerkotte","year":"2009","unstructured":"Moerkotte, G., Neumann, T., Steidl, G.: Preventing bad plans by bounding the impact of cardinality estimation errors. Proc. VLDB Endow. 2(1), 982\u2013993 (2009)","journal-title":"Proc. VLDB Endow."},{"key":"9_CR16","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"61","DOI":"10.1007\/978-3-319-31409-9_5","volume-title":"Performance Evaluation and Benchmarking: Traditional to Big Data to Internet of Things","author":"R Moussa","year":"2016","unstructured":"Moussa, R.: Big-SeqDB-Gen: a formal and scalable approach for parallel generation of big synthetic sequence databases. In: Nambiar, R., Poess, M. (eds.) TPCTC 2015. LNCS, vol. 9508, pp. 61\u201376. Springer, Cham (2016). \n                    https:\/\/doi.org\/10.1007\/978-3-319-31409-9_5"},{"key":"9_CR17","unstructured":"Nambiar, R.O., Poess, M.: The making of TPC-DS. In: Proceedings of the 32nd International Conference on Very Large Data Bases, VLDB 2006, pp. 1049\u20131058. VLDB Endowment (2006)"},{"key":"9_CR18","series-title":"Lecture Notes in Computer Science","doi-asserted-by":"publisher","first-page":"237","DOI":"10.1007\/978-3-642-10424-4_17","volume-title":"Performance Evaluation and Benchmarking","author":"P O\u2019Neil","year":"2009","unstructured":"O\u2019Neil, P., O\u2019Neil, E., Chen, X., Revilak, S.: The star schema benchmark and augmented fact table indexing. In: Nambiar, R., Poess, M. (eds.) TPCTC 2009. LNCS, vol. 5895, pp. 237\u2013252. Springer, Heidelberg (2009). \n                    https:\/\/doi.org\/10.1007\/978-3-642-10424-4_17"},{"key":"9_CR19","first-page":"50","volume":"200","author":"PE O\u2019Neil","year":"2007","unstructured":"O\u2019Neil, P.E., O\u2019Neil, E.J., Chen, X.: The star schema benchmark (SSB). Pat 200, 50 (2007)","journal-title":"Pat"},{"issue":"4","key":"9_CR20","doi-asserted-by":"publisher","first-page":"64","DOI":"10.1145\/369275.369291","volume":"29","author":"M Poess","year":"2000","unstructured":"Poess, M., Floyd, C.: New TPC benchmarks for decision support and web commerce. SIGMOD Rec. 29(4), 64\u201371 (2000)","journal-title":"SIGMOD Rec."},{"issue":"5","key":"9_CR21","doi-asserted-by":"publisher","first-page":"675","DOI":"10.1109\/69.877502","volume":"12","author":"D Rafiei","year":"2000","unstructured":"Rafiei, D., Mendelzon, A.O.: Querying time series data based on similarity. IEEE Trans. Knowl. Data Eng. 12(5), 675\u2013693 (2000)","journal-title":"IEEE Trans. Knowl. Data Eng."},{"key":"9_CR22","unstructured":"Ramakrsihnan, R., Donjerkovic, D., Ranganathan, A., Beyer, K.S., Krishnaprasad, M.: SRQL: sorted relational query language. In: Proceedings of Tenth International Conference on Scientific and Statistical Database Management (Cat. No. 98TB100243), pp. 84\u201395, July 1998"},{"key":"9_CR23","doi-asserted-by":"crossref","unstructured":"Ray, S., Simion, B., Brown, A.D.: Jackpine: a benchmark to evaluate spatial database performance. In: 2011 IEEE 27th International Conference on Data Engineering, pp. 1139\u20131150, April 2011","DOI":"10.1109\/ICDE.2011.5767929"},{"key":"9_CR24","unstructured":"Reinsel, D., Gantz, J., Rydning, J.: Data Age 2025: The Evolution of Data to Life-Critical. Don\u2019t Focus on Big Data (2017)"},{"key":"9_CR25","doi-asserted-by":"crossref","unstructured":"Sadri, R., Zaniolo, C., Zarkesh, A., Adibi, J.: Optimization of sequence queries in database systems. In: Proceedings of the Twentieth ACM SIGMOD-SIGACT-SIGART Symposium on Principles of Database Systems, PODS 2001, pp. 71\u201381. ACM, New York (2001)","DOI":"10.1145\/375551.375563"},{"key":"9_CR26","unstructured":"Seshadri, P., Livny, M., Ramakrishnan, R.: SEQ: a model for sequence databases. In: Proceedings of the Eleventh International Conference on Data Engineering, pp. 232\u2013239, March 1995"},{"key":"9_CR27","doi-asserted-by":"crossref","unstructured":"Seshadri, P., Livny, M., Ramakrishnan, R.: Sequence query processing. In: Proceedings of the 1994 ACM SIGMOD International Conference on Management of Data, SIGMOD 1994, pp. 430\u2013441. ACM, New York (1994)","DOI":"10.1145\/191843.191926"},{"key":"9_CR28","series-title":"The Springer International Series in Engineering and Computer Science","doi-asserted-by":"publisher","DOI":"10.1007\/978-1-4615-2289-8","volume-title":"The TSQL2 Temporal Query Language","author":"R Snodgrass","year":"2012","unstructured":"Snodgrass, R.: The TSQL2 Temporal Query Language. The Springer International Series in Engineering and Computer Science. Springer, New York (2012). \n                    https:\/\/doi.org\/10.1007\/978-1-4615-2289-8"},{"issue":"2","key":"9_CR29","doi-asserted-by":"publisher","first-page":"12","DOI":"10.1145\/846183.846188","volume":"1","author":"J Srivastava","year":"2000","unstructured":"Srivastava, J., Cooley, R., Deshpande, M., Tan, P.N.: Web usage mining: discovery and applications of usage patterns from web data. SIGKDD Explor. Newsl. 1(2), 12\u201323 (2000)","journal-title":"SIGKDD Explor. Newsl."},{"key":"9_CR30","unstructured":"Yi, B.K., Jagadish, H.V., Faloutsos, C.: Efficient retrieval of similar time sequences under time warping. In: Proceedings 14th International Conference on Data Engineering, pp. 201\u2013208, February 1998"}],"container-title":["Lecture Notes in Computer Science","Performance Evaluation and Benchmarking for the Era of Artificial Intelligence"],"original-title":[],"language":"en","link":[{"URL":"http:\/\/link.springer.com\/content\/pdf\/10.1007\/978-3-030-11404-6_9","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,5,20]],"date-time":"2019-05-20T06:13:38Z","timestamp":1558332818000},"score":1,"resource":{"primary":{"URL":"http:\/\/link.springer.com\/10.1007\/978-3-030-11404-6_9"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2019]]},"ISBN":["9783030114039","9783030114046"],"references-count":30,"URL":"https:\/\/doi.org\/10.1007\/978-3-030-11404-6_9","relation":{},"ISSN":["0302-9743","1611-3349"],"issn-type":[{"type":"print","value":"0302-9743"},{"type":"electronic","value":"1611-3349"}],"subject":[],"published":{"date-parts":[[2019]]},"assertion":[{"value":"30 January 2019","order":1,"name":"first_online","label":"First Online","group":{"name":"ChapterHistory","label":"Chapter History"}},{"value":"TPCTC","order":1,"name":"conference_acronym","label":"Conference Acronym","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Technology Conference on Performance Evaluation and Benchmarking","order":2,"name":"conference_name","label":"Conference Name","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Rio de Janeiro","order":3,"name":"conference_city","label":"Conference City","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"Brazil","order":4,"name":"conference_country","label":"Conference Country","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"2018","order":5,"name":"conference_year","label":"Conference Year","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"31 August 2018","order":7,"name":"conference_start_date","label":"Conference Start Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"31 August 2018","order":8,"name":"conference_end_date","label":"Conference End Date","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"10","order":9,"name":"conference_number","label":"Conference Number","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"tpctc2018","order":10,"name":"conference_id","label":"Conference ID","group":{"name":"ConferenceInfo","label":"Conference Information"}},{"value":"http:\/\/www.tpc.org\/tpctc\/tpctc2018\/default.asp","order":11,"name":"conference_url","label":"Conference URL","group":{"name":"ConferenceInfo","label":"Conference Information"}}]}}