Enhancing Database Management System Performance Using Data Mining Techniques

References

[1] Chou, Hong-Tai, and David J. DeWitt. ”An evaluation of buffer management strategies for relational database systems.” Algorithmica 1.1-4 (1986): 311-336.

[2] Robinson, John T., and Murthy V. Devarakonda. Data cache management using frequency-based replacement. Vol. 18. No. 1. ACM, 1990.

[3] O’neil, Elizabeth J., Patrick E. O’neil, and Gerhard Weikum. ”The LRU-K page replacement algorithm for database disk buffering.” ACM SIGMOD Record 22.2 (1993): 297-306.

[4] Cherkasova, Ludmila. Improving WWW proxies performance with greedy-dual- size-frequency caching policy. Hewlett-Packard Laboratories, 1998.

[5] Kim, Jong Min, et al. ”A low-overhead high-performance unified buffer manage- ment scheme that exploits sequential and looping references.” Proceedings of the 4th conference on Symposium on Operating System Design & Implementation- Volume 4. USENIX Association, 2000.

[6] Lee, Donghee, et al. ”LRFU: A spectrum of policies that subsumes the least re- cently used and least frequently used policies.” IEEE transactions on Computers 50.12 (2001): 1352-1361.

[7] Jiang, Song, and Xiaodong Zhang. ”LIRS: an efficient low inter-reference recency set replacement policy to improve buffer cache performance.” ACM SIGMET- RICS Performance Evaluation Review 30.1 (2002): 31-42.

[8] Megiddo, Nimrod, and Dharmendra S. Modha. ”ARC: A Self-Tuning, Low Over- head Replacement Cache.” FAST. Vol. 3. No. 2003. 2003.163

[9] Bansal, Sorav, and Dharmendra S. Modha. ”CAR: Clock with Adaptive Replace- ment.” FAST. Vol. 4. 2004.

[10] Jiang, Song, and Xiaodong Zhang. ”Making LRU friendly to weak locality work- loads: A novel replacement algorithm to improve buffer cache performance.” IEEE Transactions on Computers 54.8 (2005): 939-952.

[11] Jiang, Song, Feng Chen, and Xiaodong Zhang. ”CLOCK-Pro: An Effective Im- provement of the CLOCK Replacement.” USENIX Annual Technical Conference, General Track. 2005.

[12] He, Zhen, Richard Lai, and Alonso Marquez. ”On using cache conscious cluster- ing for improving OODBMS performance.” Information and Software Technology 48.11 (2006): 1073-1082.

[13] Chiang, I. Robert, Paulo B. Goes, and Zhongju Zhang. ”Periodic cache replace- ment policy for dynamic content at application server.” Decision Support Systems 43.2 (2007): 336-348.

[14] Wan, Shenggang, et al. ”An adaptive cache management using dual LRU stacks to improve buffer cache performance.” Performance, Computing and Communi- cations Conference, 2008. IPCCC 2008. IEEE International. IEEE, 2008.

[15] Saurabh Chauhan, Dharamveer Singh, Atul Kumar Singh (2022) “Artificial Intelligence In The Military: An Overview Of The Capabilities, Applications, And Challenges”, Journal of Survey in Fisheries Sciences, Vol 9 (2) pp 984-991. https://doi.org/10.53555/sfs.v9i2.2911

[16] Kiran, Dharamveer Singh, Nitin Goyal, (2023) “Analysis Of How Digital Marketing Affect By Voice Search”, Journal of Survey in Fisheries Sciences, Vol. 30 (2) 407-412. https://doi.org/10.53555/sfs.v10i3.2890

[17] Yukti Tyagi, Dharamveer Singh, Ramander Singh, Sudhir Dawra (2024) “Analysis Of The Most Recent Trojans On The Android Operating System”, Educational Administration: Theory and Practice, Vol. 30(2) 1320-1327. https://doi.org/10.53555/kuey.v30i2.6846

[18] Shivanee Singh, Dharamveer Singh, Ravindra Chauhan (2023) “Manufacturing Industry: A Sustainability Perspective On Cloud And Edge Computing”, Journal of Survey in Fisheries Sciences, pp 1592-1598. https://doi.org/10.53555/sfs.v10i2.2889

@article{1709885,
      author = {Rajeev Maheshwari, Rajeev Kaushik},
      title = {Enhancing Database Management System Performance Using Data Mining Techniques},
      journal = {Iconic Research And Engineering Journals},
      year = {2025},
      volume = {9},
      number = {1},
      pages = {1316-1319},
      issn = {2456-8880},
      url = {https://www.irejournals.com/formatedpaper/1709885.pdf},
      abstract = {Cloud computing has gained significant traction due to its cost-effectiveness, scalability, and flexible pay-as-you-go model?trends further accelerated by the proliferation of IoT devices. As a result, many organizations now leverage Database-as-a-Service (DBaaS) for database deployment, enjoying benefits such as high availability, automated scaling, failover support, and reduced administrative overhead. This paper enhances the performance of shared cloud databases under mixed transactional and analytical workloads through two complementary strategies: Business intelligence and decision support systems often execute complex queries with multiple joins and aggregations. To minimize repeated computations, a scalable tree-mining algorithm is employed to identify frequently occurring sub-expressions from historical query plans. These are materialized as views, significantly lowering query execution costs. Web applications like e-commerce and online banking experience region-specific, time-dependent access patterns. To address this, a predictive model based on Parzen window estimation is used to identify time-varying working sets. A novel cache replacement strategy is then proposed, prioritizing blocks based on predicted reuse. Experimental evaluations demonstrate that the proposed methods significantly improve cache hit rates and overall performance compared to existing solutions.},
      month = {July},
  }