{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,6,10]],"date-time":"2026-06-10T16:11:50Z","timestamp":1781107910373,"version":"3.54.1"},"reference-count":24,"publisher":"IGI Global Scientific Publishing","issue":"4","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2011,10,1]]},"abstract":"<p>This research presents a way to identify attribute-value relationships already existing in a database by using association rule mining to optimize query processing. Once relationships have been determined, these relationships can be used as a basis for creating temporary structures like views to optimize query operations. This paper presents an architecture that shows how table partitions in the form of views, created based on association rules, can be used to optimize queries. The results of this study were statistically significant.<\/p>","DOI":"10.4018\/ijkbo.2011100103","type":"journal-article","created":{"date-parts":[[2011,10,19]],"date-time":"2011-10-19T12:38:00Z","timestamp":1319027880000},"page":"32-55","source":"Crossref","is-referenced-by-count":0,"title":["An Architecture for Query Optimization Using Association Rule Mining"],"prefix":"10.4018","volume":"1","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-1886-4582","authenticated-orcid":true,"given":"Sikha","family":"Bagui","sequence":"first","affiliation":[{"name":"University of West Florida, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Mohammad","family":"Islam","sequence":"additional","affiliation":[{"name":"University of West Florida, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Subhash","family":"Bagui","sequence":"additional","affiliation":[{"name":"University of West Florida, USA"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"2432","reference":[{"key":"ijkbo.2011100103-0","doi-asserted-by":"crossref","unstructured":"Agrawal, R., Imielinski, T., & Swami, A. (1993). Mining association rules between sets of items in large databases. In Proceedings of the ACM SIGMOD Conference on Management of Data (pp. 207-216).","DOI":"10.1145\/170036.170072"},{"key":"ijkbo.2011100103-1","doi-asserted-by":"publisher","DOI":"10.1504\/IJDATS.2009.024297"},{"key":"ijkbo.2011100103-2","doi-asserted-by":"publisher","DOI":"10.1145\/762471.762472"},{"key":"ijkbo.2011100103-3","doi-asserted-by":"publisher","DOI":"10.1145\/78922.78924"},{"key":"ijkbo.2011100103-4","unstructured":"Cheng, Q., Gryz, J., Koo, F., Leung, C., Liu, L., Qian, X., & Schiefer, B. (1999). Implementation of two semantic query optimization techniques in DB2 UDB. In Proceedings of the 25th Conference on Very Large Data Bases (pp. 688-698)."},{"key":"ijkbo.2011100103-5","doi-asserted-by":"crossref","unstructured":"Godfrey, P., Gryz, J., & Zuzarte, C. (2001). Exploiting constraint-like data characterizations in query optimization. In Proceedings of the ACM SIGMOD International Conference on Management of Data (pp. 582-592).","DOI":"10.1145\/376284.375749"},{"key":"ijkbo.2011100103-6","doi-asserted-by":"crossref","unstructured":"Gryz, J., Schiefer, B., Zheng, J., & Zuzarte, C. (2001). Discovery and application of check constraints in DB2. In Proceedings of the 17th International Conference on Data Engineering (p. 551).","DOI":"10.1109\/ICDE.2001.914869"},{"key":"ijkbo.2011100103-7","author":"J.Han","year":"2006","journal-title":"Data Mining: Concepts and techniques"},{"key":"ijkbo.2011100103-8","doi-asserted-by":"crossref","unstructured":"Hua, M., Pei, J., Zhang, W., & Lin, X. (2008). Ranking queries on uncertain data: A probabilistic threshold approach. In Proceedings of the ACM SIGMOD International Conference on Management of Data (pp. 673-686).","DOI":"10.1145\/1376616.1376685"},{"key":"ijkbo.2011100103-9","doi-asserted-by":"crossref","unstructured":"Huhtala, Y., Karkkainen, J., Porkka, P., & Toivonen, H. (1998). Efficient discovery of functional and approximate dependencies using partitions. In Proceedings of the 14th International Conference on Data Engineering (pp. 392-401).","DOI":"10.1109\/ICDE.1998.655802"},{"key":"ijkbo.2011100103-10","doi-asserted-by":"publisher","DOI":"10.1145\/1189769.1189772"},{"key":"ijkbo.2011100103-11","unstructured":"King, J. J. (1981). QUIST: A system for semantic query optimization in relational databases. In Proceedings of the 7th International Conference on Very Large Databases (pp. 510-517)."},{"key":"ijkbo.2011100103-12","unstructured":"MSDN. (2008). Viewing a mining model with the Microsoft association rules viewer. Retrieved from http:\/\/msdn.microsoft.com\/en-us\/library\/ms174768.aspx"},{"key":"ijkbo.2011100103-13","doi-asserted-by":"crossref","unstructured":"Park, J. S., Chen, M. S., & Yu, P. S. (1995). An effective hash based algorithm for mining association rules. In Proceedings of the ACM SIGMOD Conference on Management of Data (pp. 175-186).","DOI":"10.1145\/568271.223813"},{"key":"ijkbo.2011100103-14","doi-asserted-by":"publisher","DOI":"10.1023\/B:DAMI.0000023674.74932.4c"},{"key":"ijkbo.2011100103-15","unstructured":"Schnaitter, K., Spiegel, J., & Polyzotis, N. (2007). Depth estimation for ranking query optimization. In Proceedings of the 33rd International Conference on Very Large Data Bases, Vienna, Austria (pp. 902-913)."},{"key":"ijkbo.2011100103-16","doi-asserted-by":"publisher","DOI":"10.1109\/69.250077"},{"key":"ijkbo.2011100103-17","doi-asserted-by":"publisher","DOI":"10.1145\/146931.146932"},{"key":"ijkbo.2011100103-18","doi-asserted-by":"crossref","unstructured":"Simmen, D., Shekita, E., & Malkems, T. (1996). Fundamental techniques for order optimization. In Proceedings of the ACM SIGMOD International Conference on Management of Data (pp. 57-67).","DOI":"10.1145\/235968.233320"},{"key":"ijkbo.2011100103-19","unstructured":"Su, H., Rundensteiner, E. A., & Mani, M. (2005). Semantic query optimization for xquery over xml streams. In Proceedings of the 31st Very Large Data Bases Conference (pp. 277-288)."},{"key":"ijkbo.2011100103-20","unstructured":"Tan, P.-N. SteinBach, M., & Kumar, V. (2006). Introduction to data mining. Reading, MA: Addison-Wesley."},{"key":"ijkbo.2011100103-21","doi-asserted-by":"crossref","unstructured":"Trigoni, A., & Moody, K. (2001). Using association rules to add or eliminate query constraints automatically. In Proceedings of the Thirteenth International Conference on Scientific and Statistical Database Management (pp. 124-133).","DOI":"10.1109\/SSDM.2001.938545"},{"key":"ijkbo.2011100103-22","doi-asserted-by":"crossref","unstructured":"Yoon, S., Song, I., & Park, E. (1995). Semantic query processing in object-oriented databases using deductive approach. In Proceedings of the International Conference on Information and Knowledge Management (pp. 150-157).","DOI":"10.1145\/221270.221365"},{"key":"ijkbo.2011100103-23","doi-asserted-by":"publisher","DOI":"10.1109\/69.87981"}],"container-title":["International Journal of Knowledge-Based Organizations"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=58918","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T16:36:30Z","timestamp":1654101390000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/ijkbo.2011100103"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2011,10,1]]},"references-count":24,"journal-issue":{"issue":"4","published-print":{"date-parts":[[2011,10]]}},"URL":"https:\/\/doi.org\/10.4018\/ijkbo.2011100103","relation":{},"ISSN":["2155-6393","2155-6407"],"issn-type":[{"value":"2155-6393","type":"print"},{"value":"2155-6407","type":"electronic"}],"subject":[],"published":{"date-parts":[[2011,10,1]]}}}