{"id":"https://openalex.org/W4411077892","doi":"https://doi.org/10.3390/computers14060220","title":"GARMT: Grouping-Based Association Rule Mining to Predict Future Tables in Database Queries","display_name":"GARMT: Grouping-Based Association Rule Mining to Predict Future Tables in Database Queries","publication_year":2025,"publication_date":"2025-06-06","ids":{"openalex":"https://openalex.org/W4411077892","doi":"https://doi.org/10.3390/computers14060220"},"language":"en","primary_location":{"id":"doi:10.3390/computers14060220","is_oa":true,"landing_page_url":"https://doi.org/10.3390/computers14060220","pdf_url":"https://www.mdpi.com/2073-431X/14/6/220/pdf?version=1749202202","source":{"id":"https://openalex.org/S4210228075","display_name":"Computers","issn_l":"2073-431X","issn":["2073-431X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computers","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/2073-431X/14/6/220/pdf?version=1749202202","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100459651","display_name":"Peixiong He","orcid":"https://orcid.org/0009-0000-4507-2364"},"institutions":[{"id":"https://openalex.org/I82497590","display_name":"Auburn University","ror":"https://ror.org/02v80fc35","country_code":"US","type":"education","lineage":["https://openalex.org/I82497590"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Peixiong He","raw_affiliation_strings":["Department of Computer Science and Software Engineering, Auburn University, Auburn, AL 36849, USA"],"raw_orcid":"https://orcid.org/0009-0000-4507-2364","affiliations":[{"raw_affiliation_string":"Department of Computer Science and Software Engineering, Auburn University, Auburn, AL 36849, USA","institution_ids":["https://openalex.org/I82497590"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033147483","display_name":"Libo Sun","orcid":"https://orcid.org/0000-0002-7838-9410"},"institutions":[{"id":"https://openalex.org/I82497590","display_name":"Auburn University","ror":"https://ror.org/02v80fc35","country_code":"US","type":"education","lineage":["https://openalex.org/I82497590"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Libo Sun","raw_affiliation_strings":["Department of Computer Science and Software Engineering, Auburn University, Auburn, AL 36849, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Department of Computer Science and Software Engineering, Auburn University, Auburn, AL 36849, USA","institution_ids":["https://openalex.org/I82497590"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5033867212","display_name":"Xian Jun Gao","orcid":null},"institutions":[{"id":"https://openalex.org/I199172307","display_name":"Columbus State University","ror":"https://ror.org/002nf6z37","country_code":"US","type":"education","lineage":["https://openalex.org/I199172307"]}],"countries":["US"],"is_corresponding":false,"raw_author_name":"Xian Gao","raw_affiliation_strings":["TSYS School of Computer Science, Columbus State University, Columbus, GA 31907, USA"],"raw_orcid":"https://orcid.org/0009-0006-4583-5513","affiliations":[{"raw_affiliation_string":"TSYS School of Computer Science, Columbus State University, Columbus, GA 31907, USA","institution_ids":["https://openalex.org/I199172307"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5100753053","display_name":"Yi Zhou","orcid":"https://orcid.org/0000-0002-1460-322X"},"institutions":[{"id":"https://openalex.org/I199172307","display_name":"Columbus State University","ror":"https://ror.org/002nf6z37","country_code":"US","type":"education","lineage":["https://openalex.org/I199172307"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Yi Zhou","raw_affiliation_strings":["TSYS School of Computer Science, Columbus State University, Columbus, GA 31907, USA"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"TSYS School of Computer Science, Columbus State University, Columbus, GA 31907, USA","institution_ids":["https://openalex.org/I199172307"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5042766429","display_name":"Xiao Qin","orcid":"https://orcid.org/0000-0002-8345-3587"},"institutions":[{"id":"https://openalex.org/I82497590","display_name":"Auburn University","ror":"https://ror.org/02v80fc35","country_code":"US","type":"education","lineage":["https://openalex.org/I82497590"]}],"countries":["US"],"is_corresponding":true,"raw_author_name":"Xiao Qin","raw_affiliation_strings":["Department of Computer Science and Software Engineering, Auburn University, Auburn, AL 36849, USA"],"raw_orcid":"https://orcid.org/0000-0002-8345-3587","affiliations":[{"raw_affiliation_string":"Department of Computer Science and Software Engineering, Auburn University, Auburn, AL 36849, USA","institution_ids":["https://openalex.org/I82497590"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":5,"corresponding_author_ids":["https://openalex.org/A5042766429","https://openalex.org/A5100753053"],"corresponding_institution_ids":["https://openalex.org/I199172307","https://openalex.org/I82497590"],"apc_list":{"value":1600,"currency":"CHF","value_usd":1732},"apc_paid":{"value":1600,"currency":"CHF","value_usd":1732},"fwci":0.0,"has_fulltext":true,"cited_by_count":0,"citation_normalized_percentile":{"value":0.16867914,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":"14","issue":"6","first_page":"220","last_page":"220"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10538","display_name":"Data Mining Algorithms and Applications","score":0.9998999834060669,"subfield":{"id":"https://openalex.org/subfields/1710","display_name":"Information Systems"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9991000294685364,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11063","display_name":"Rough Sets and Fuzzy Logic","score":0.9959999918937683,"subfield":{"id":"https://openalex.org/subfields/1703","display_name":"Computational Theory and Mathematics"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/association-rule-learning","display_name":"Association rule learning","score":0.8416404128074646},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.6546992063522339},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5865159034729004},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.5145754218101501},{"id":"https://openalex.org/keywords/information-retrieval","display_name":"Information retrieval","score":0.4337865710258484},{"id":"https://openalex.org/keywords/association","display_name":"Association (psychology)","score":0.4276350140571594},{"id":"https://openalex.org/keywords/psychology","display_name":"Psychology","score":0.04159456491470337}],"concepts":[{"id":"https://openalex.org/C193524817","wikidata":"https://www.wikidata.org/wiki/Q386780","display_name":"Association rule learning","level":2,"score":0.8416404128074646},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6546992063522339},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5865159034729004},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.5145754218101501},{"id":"https://openalex.org/C23123220","wikidata":"https://www.wikidata.org/wiki/Q816826","display_name":"Information retrieval","level":1,"score":0.4337865710258484},{"id":"https://openalex.org/C142853389","wikidata":"https://www.wikidata.org/wiki/Q744778","display_name":"Association (psychology)","level":2,"score":0.4276350140571594},{"id":"https://openalex.org/C15744967","wikidata":"https://www.wikidata.org/wiki/Q9418","display_name":"Psychology","level":0,"score":0.04159456491470337},{"id":"https://openalex.org/C542102704","wikidata":"https://www.wikidata.org/wiki/Q183257","display_name":"Psychotherapist","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"doi:10.3390/computers14060220","is_oa":true,"landing_page_url":"https://doi.org/10.3390/computers14060220","pdf_url":"https://www.mdpi.com/2073-431X/14/6/220/pdf?version=1749202202","source":{"id":"https://openalex.org/S4210228075","display_name":"Computers","issn_l":"2073-431X","issn":["2073-431X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computers","raw_type":"journal-article"},{"id":"pmh:oai:doaj.org/article:e0d629b9076f4917a58083b844f1fbd8","is_oa":true,"landing_page_url":"https://doaj.org/article/e0d629b9076f4917a58083b844f1fbd8","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Computers, Vol 14, Iss 6, p 220 (2025)","raw_type":"article"}],"best_oa_location":{"id":"doi:10.3390/computers14060220","is_oa":true,"landing_page_url":"https://doi.org/10.3390/computers14060220","pdf_url":"https://www.mdpi.com/2073-431X/14/6/220/pdf?version=1749202202","source":{"id":"https://openalex.org/S4210228075","display_name":"Computers","issn_l":"2073-431X","issn":["2073-431X"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Computers","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4411077892.pdf","grobid_xml":"https://content.openalex.org/works/W4411077892.grobid-xml"},"referenced_works_count":19,"referenced_works":["https://openalex.org/W1599136575","https://openalex.org/W1994189501","https://openalex.org/W2001082095","https://openalex.org/W2001199771","https://openalex.org/W2016352575","https://openalex.org/W2045487373","https://openalex.org/W2137968973","https://openalex.org/W2210278139","https://openalex.org/W2384824705","https://openalex.org/W2493839961","https://openalex.org/W2894630172","https://openalex.org/W3084515140","https://openalex.org/W3188222881","https://openalex.org/W4389539860","https://openalex.org/W4392865259","https://openalex.org/W4396991986","https://openalex.org/W6657084543","https://openalex.org/W6782858568","https://openalex.org/W6967286523"],"related_works":["https://openalex.org/W2392697706","https://openalex.org/W366033468","https://openalex.org/W128746893","https://openalex.org/W2367573304","https://openalex.org/W2537030075","https://openalex.org/W2006971496","https://openalex.org/W2065998343","https://openalex.org/W2369717039","https://openalex.org/W2384676159","https://openalex.org/W2982449560"],"abstract_inverted_index":{"In":[0],"modern":[1],"data":[2,27,45],"management":[3,38],"systems,":[4],"structured":[5,22],"query":[6,41,118],"language":[7],"(SQL)":[8],"databases,":[9],"as":[10],"a":[11,65,78,91],"mature":[12],"and":[13,34,39,76],"stable":[14],"technology,":[15],"have":[16],"become":[17],"the":[18,104,114],"standard":[19],"for":[20,120],"processing":[21,42],"data.":[23],"These":[24,111],"databases":[25],"ensure":[26],"integrity":[28],"through":[29],"strongly":[30],"typed":[31],"schema":[32],"definitions":[33],"support":[35],"complex":[36],"transaction":[37],"efficient":[40,121],"capabilities.":[43],"However,":[44],"sparsity\u2014where":[46],"most":[47,56],"fields":[48],"in":[49,60,124],"large":[50],"table":[51,86],"sets":[52],"remain":[53],"unused":[54],"by":[55],"queries\u2014leads":[57],"to":[58,83,101,103],"inefficiencies":[59],"access":[61,87],"optimization.":[62],"We":[63],"propose":[64],"grouping-based":[66],"approach":[67],"(GARMT)":[68],"that":[69,95],"partitions":[70],"SQL":[71],"queries":[72],"into":[73],"fixed-size":[74],"groups":[75],"applies":[77],"modified":[79],"FP-Growth":[80],"algorithm":[81],"(GFP-Growth)":[82],"identify":[84],"frequent":[85],"patterns.":[88],"Experiments":[89],"on":[90],"real-world":[92],"dataset":[93],"show":[94],"grouping":[96,119],"significantly":[97],"reduces":[98],"runtime\u2014by":[99],"up":[100],"40%\u2014compared":[102],"ungrouped":[105],"baseline":[106],"while":[107],"preserving":[108],"rule":[109],"relevance.":[110],"results":[112],"highlight":[113],"practical":[115],"value":[116],"of":[117],"pattern":[122],"discovery":[123],"sparse":[125],"database":[126],"environments.":[127]},"counts_by_year":[],"updated_date":"2026-05-21T06:26:12.895304","created_date":"2025-10-10T00:00:00"}