{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,4,8]],"date-time":"2025-04-08T18:11:20Z","timestamp":1744135880689},"reference-count":23,"publisher":"IGI Global","issue":"1","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2020,1,1]]},"abstract":"<p>Existing work on multiple databases (MDBs) sequential pattern mining cannot mine frequent sequences to answer exact and historical queries from MDBs having different table structures. This article proposes the transaction id frequent sequence pattern (TidFSeq) algorithm to handle the difficult problem of mining frequent sequences from diverse MDBs. The TidFSeq algorithm transforms candidate 1-sequences to get transaction subsequences where candidate 1-sequences occurred as (1-sequence, itssubsequenceidlist) tuple or (1-sequence, position id list). Subsequent frequent i-sequences are computed using the counts of the sequence ids in each candidate i-sequence position id list tuples. An extended version of the general sequential pattern (GSP)-like candidate generates and a frequency count approach is used for computing supports of itemset (I-step) and separate (S-step) sequences without repeated database scans but with transaction ids. Generated patterns answer complex queries from MDBs. The TidFSeq algorithm has a faster processing time than existing algorithms.<\/p>","DOI":"10.4018\/ijdwm.2020010101","type":"journal-article","created":{"date-parts":[[2019,11,25]],"date-time":"2019-11-25T12:58:53Z","timestamp":1574686733000},"page":"1-21","source":"Crossref","is-referenced-by-count":3,"title":["Mining Integrated Sequential Patterns From Multiple Databases"],"prefix":"10.4018","volume":"16","author":[{"given":"Christie I.","family":"Ezeife","sequence":"first","affiliation":[{"name":"University of Windsor, Ontario, Canada"}]},{"given":"Vignesh","family":"Aravindan","sequence":"additional","affiliation":[{"name":"Royal Bank of Canada, Canada"}]},{"given":"Ritu","family":"Chaturvedi","sequence":"additional","affiliation":[{"name":"School of Computer Science, University of Guelph, Ontario, Canada"}]}],"member":"2432","reference":[{"key":"IJDWM.2020010101-0","doi-asserted-by":"publisher","DOI":"10.1016\/j.ins.2013.02.043"},{"key":"IJDWM.2020010101-1","first-page":"487","article-title":"Fast algorithms for mining association rules in large databases.","author":"R.Agrawal","year":"1994","journal-title":"Proceedings of the 20th International Conference on very Large Databases"},{"key":"IJDWM.2020010101-2","unstructured":"Aravindan, V. (2016). Mining frequent sequential patterns from MDBs using transaction Ids [MSc thesis]. University of Windsor, Canada."},{"key":"IJDWM.2020010101-3","doi-asserted-by":"publisher","DOI":"10.1145\/775047.775109"},{"key":"IJDWM.2020010101-4","doi-asserted-by":"publisher","DOI":"10.1007\/s10618-005-0248-3"},{"key":"IJDWM.2020010101-5","doi-asserted-by":"publisher","DOI":"10.1145\/1133905.1133910"},{"key":"IJDWM.2020010101-6","doi-asserted-by":"crossref","unstructured":"Ezeife, C. I., & Zhang, D. (2009). TidFP: Mining frequent patterns in different databases with transaction ID. Proceedings of the 11th International Conference on Data Warehousing and Knowledge Discovery (DAWAK) (pp. 125-137). Springer Verlag.","DOI":"10.1007\/978-3-642-03730-6_11"},{"key":"IJDWM.2020010101-7","author":"J.Han","year":"2012","journal-title":"Data mining: Concepts and techniques"},{"key":"IJDWM.2020010101-8","doi-asserted-by":"publisher","DOI":"10.1023\/B:DAMI.0000005258.31418.83"},{"key":"IJDWM.2020010101-9","doi-asserted-by":"publisher","DOI":"10.1007\/s10618-005-0017-3"},{"key":"IJDWM.2020010101-10","doi-asserted-by":"publisher","DOI":"10.1016\/j.dss.2013.06.003"},{"key":"IJDWM.2020010101-11","doi-asserted-by":"publisher","DOI":"10.1109\/69.940731"},{"key":"IJDWM.2020010101-12","doi-asserted-by":"publisher","DOI":"10.1016\/j.patrec.2012.05.014"},{"key":"IJDWM.2020010101-13","doi-asserted-by":"publisher","DOI":"10.1016\/S0169-023X(01)00008-8"},{"key":"IJDWM.2020010101-14","doi-asserted-by":"publisher","DOI":"10.1145\/223784.223813"},{"issue":"1","key":"IJDWM.2020010101-15","doi-asserted-by":"crossref","first-page":"1424","DOI":"10.1109\/TKDE.2004.77","article-title":"Prefix span: Mining sequential patterns efficiently by prefix-projected pattern growth.","volume":"16","author":"J.Pei","year":"2004","journal-title":"IEEE Transactions on Knowledge and Data Engineering"},{"key":"IJDWM.2020010101-16","doi-asserted-by":"publisher","DOI":"10.1007\/3-540-45571-X_47"},{"key":"IJDWM.2020010101-17","doi-asserted-by":"publisher","DOI":"10.1016\/j.datak.2009.04.009"},{"key":"IJDWM.2020010101-18","first-page":"432","article-title":"An efficient algorithm for mining association rules in large databases.","author":"A.Savasere","year":"1995","journal-title":"Proceeding of the 1995 International Conference on Very Large Data Bases (VLDB\u201995)"},{"key":"IJDWM.2020010101-19","first-page":"407","article-title":"Mining generalized association rules.","author":"R.Srikant","year":"1995","journal-title":"Proceedings of the 21st International Conference on Very Large Databases (VLDB)"},{"key":"IJDWM.2020010101-20","doi-asserted-by":"publisher","DOI":"10.1007\/BFb0014140"},{"key":"IJDWM.2020010101-21","doi-asserted-by":"publisher","DOI":"10.1002\/9780470391365"},{"issue":"1","key":"IJDWM.2020010101-22","first-page":"5","article-title":"Mining multi-database mining.","volume":"2","author":"S.Zhang","year":"2003","journal-title":"IEEE Computational Intelligence Bulletin"}],"container-title":["International Journal of Data Warehousing and Mining"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=243411","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,5,6]],"date-time":"2022-05-06T20:41:25Z","timestamp":1651869685000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/IJDWM.2020010101"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2020,1,1]]},"references-count":23,"journal-issue":{"issue":"1","published-print":{"date-parts":[[2020,1]]}},"URL":"https:\/\/doi.org\/10.4018\/ijdwm.2020010101","relation":{},"ISSN":["1548-3924","1548-3932"],"issn-type":[{"value":"1548-3924","type":"print"},{"value":"1548-3932","type":"electronic"}],"subject":[],"published":{"date-parts":[[2020,1,1]]}}}