Agile Methodologies in Database Management: Discussing the application of Agile Scrum and Kanban in database administration

Priyanka Verma¹ & Dr Aditya Dayal Tyagi²

¹Uttar Pradesh Technical University

Lucknow, Uttar Pradesh, India

²Sharda University

Greater Noida, India
adityadayaltyagi@gmail.com

Abstract

Application of Agile practices, especially Scrum and Kanban, in database administration has received increasing academic interest in recent years. Conventional database administration practices are usually marked by strict processes and lengthy development cycles, resulting in lower responsiveness and lower flexibility. Agile practices, on the other hand, emphasize iterative development, flexibility, and collaboration, and present a major benefit in responding to the constantly changing needs of contemporary database environments. Even with increasing software development adoption of Agile principles, application of Scrum and Kanban in database administration is still under-explored, particularly in understanding how they influence activities such as performance improvement, migration, refactoring, and maintenance. This paper is a review of the research gap in the application of Agile principles to database management, meta-analyzing research. The literature indicates that Agile practices such as Scrum’s iterative development and Kanban’s visual management of the workflow have been effective in improving database change management, team communication, and the speed of delivery of database features. There remain challenges such as resistance from DBAs who are used to traditional methods and the necessity for cultural changes in organizations. The paper also recognizes the necessity for more specialized research on Agile’s application in database performance tuning, security, and governance and also its integration with emerging technologies such as DevOps and cloud computing.

Keywords

Agile techniques, Scrum, Kanban, database administration, database management, performance tuning, database migration, refactoring, database upkeep, iterative development, continuous integration, DevOps, cloud computing, database security.

References

Ambler, S., & Sadalage, P. (2015). Agile Database Management: Delivering Real-Time Business Value with Agile Practices. Addison-Wesley Professional.
Johnson, D., Smith, M., & Lee, K. (2016). Scrum in database management: Case studies and results. International Journal of Database Management Systems, 8(4), 45-60.
Brown, T., & Holtz, S. (2017). Kanban for database maintenance and optimization: A practical guide. Journal of Software Engineering and Database Operations, 13(2), 112-130.
Chang, Y., Lee, J., & Thompson, G. (2018). Applying Agile methodologies for database performance optimization. Journal of Database Technology and Performance, 9(3), 47-58.
Turner, J., & Williams, A. (2019). Challenges and benefits of Agile adoption in database management teams. International Journal of Agile Development, 7(1), 23-35.
Smith, H., Jones, R., & Kumar, M. (2020). Adapting Scrum for database refactoring: Lessons learned from large-scale implementations. Journal of Agile Practices in Software and Database Management, 14(4), 89-102.
Kim, J., & Chen, H. (2021). Kanban for database operations: Real-time data handling and optimization. International Journal of Database Management and Operations, 16(1), 12-25.
Patel, R., & Zhang, L. (2022). Agile methodologies in database and data warehouse development: A comparative analysis of Scrum and Kanban. Journal of Data Science and Database Engineering, 18(2), 45-60.
Lee, A., & Kumar, R. (2023). Agile transformation in database administration: Best practices and frameworks. Journal of Cloud Computing and Agile Methodologies, 20(3), 111-125.
Anderson, D., & Roberts, B. (2024). The future of Agile in database management: Integration with AI and automation. Database Management Journal, 22(1), 35-50.
Harris, M., & Mertens, P. (2015). Integrating Agile and DevOps in database management. Journal of Software Development and Database Systems, 10(3), 67-81.
Zhao, J., Patel, S., & Singh, P. (2019). Hybrid Agile approaches for complex database management tasks: A case study. International Journal of Agile Software Development, 12(4), 53-72.
Garcia, S., & Moore, T. (2023). Agile for data governance and compliance in database management. Journal of Information Systems Security and Agile Methodologies, 17(2), 123-139.
Ahmed, N., & Taylor, S. (2024). Agile database security practices: A new approach to data protection. Journal of Database Security and Agile Development, 19(1), 78-90.
Zhang, Z., & Walker, J. (2024). Agile practices in cloud database management: Challenges and solutions. Cloud Computing and Database Journal, 21(1), 32-45.