Open Access Open Access  Restricted Access Subscription or Fee Access

Adaptive Fuzzy Query Approach for Measuring Time Estimation and Velocity in Agile Software Development

Adel A. Sabour, Nagy R. Darwish


Software development companies needs to estimate the size of what they are building and measure the velocity or rate at which they can get work done. Depend on that information, the companies can derive the likely product development duration and the corresponding cost. The estimation in the domain of software development depends on forecasting the amount of work effort required to develop software. Estimation is usually uncertainty, imprecise and vague in nature which unfortunately is used in prediction and speculated building the entire business decisions. To estimate the close time to reality, it should depend on historical data related to that team velocity, equivalent team velocity, or tasks close to estimated tasks. Based on fuzzy set theory and data-sensitive fuzzy sets, this paper proposes a more flexible fuzzy set-based approach for supporting adaptive time estimation and velocity in agile software development according to the user profiling criteria based on rates with scalable values, accordingly time estimation and velocity will varies depend on historical data in the current database state in a human-like query manner.


Agile, Velocity, Fuzzy Logic, Time Estimation, Fuzzy SQL.

Full Text:



Kenneth S. Rubin, “Essential Scrum: A Practical Guide to The Most Popular Agile Process,” 2013 Pearson Education, Inc.

Ashita Malik, Varun Pandey, Anupama Kaushik,”An Analysis of Fuzzy Approaches for COCOMO II”, International Journal of Intelligent Systems and Applications, Vol.5, 2013.

Komal Garg, Paramjeet Kaur, Shalini Kapoor, and Shilpa Narula, “Enhancement in COCOMO Model Using Function Point Analysis to Increase Effort Estimation”, IJCSMC, Vol. 3, Issue. 6, 2014.

Ratnesh Litoriya and Abhay Kothari “An Efficient Approach for Agile Web Based Project Estimation: AgileMOW”, Journal of Software Engineering and Applications, VOL.6, 2013.

C. Sathish Kumar, A. Anitha Kumari, and R. Srinivasa Perumal, “An Optimized Agile Estimation Plan Using Harmony Search Algorithm,” International Journal of Engineering and Technology (IJET), Vol 6 No 5, 2014.

Evita Coelho, Anirban Basu, “Effort Estimation in Agile Software Development using Story Points,” International Journal of Applied Information Systems (IJAIS), Volume 3– No.7, August 2012.

Ziauddin Zia, Shahid Kamal Tipu, and Shahrukh Zia “An Effort Estimation Model for Agile Software Development”, Advances in Computer Science and its Applications (ACSA), Vol.2, 2012.

Atef Tayh, Nagy Ramadan and Hesham Hefny, “Towards a Fuzzy based Framework for Effort Estimation in Agile Software Development” IJCSIS. International Journal of Computer Science and Information Security, Vol. 13, No. 1, 2015.

Masateru Tsunoda, Koji Toda, and Kyohei Fushida, Yasutaka Kamei, Meiyappan Nagappan, and Naoyasu Ubayashi, “Revisiting Software Development Effort Estimation Based on Early Phase Development Activities”,10th conference on mining software repositories (MSR), IEEE, 2013.

Amrita Raj Mukker, Anil Kumar Mishra,and Latika Singh, "Enhancing Quality in Scrum Software Projects",International Journal of Science and Research (IJSR), Vol. 3, Issue 4, 2014.

Ziauddin, Shahid Kamal, Shafiullah khan and Jamal Abdul Nasir, “ A Fuzzy Logic Based Software Cost Estimation Model”, International Journal of Software Engineering and Its Applications (IJSEIA), Vol. 7, Issue 2, 2013.

Andreas Schmietendorf, Martin Kunz,and Reiner Dumke, “Effort estimation for Agile Software Development Projects”, 5th Software Measurement European Forum, 2008.

Jitender Choudharia and Ugrasen Suman, “Story Points Based Effort Estimation Model for Software Maintenance”, Elsevier, Procedia Technology, Volume 4, 2012.

17 Sabour A. et al., Flexible Querying of Relational Databases: Fuzzy Set Based Approach, Springer CCIS 488, pp. 446–455, 2014.

Moore S.“ Oracle Database PL/SQL Language Reference, 12c”, pp. 1, 2014.

Elmasri and Navathe, “Fundamental of Database Systems”, 2011.

Garg A., and Rishi R., “Querying Capability Enhancement in Database Using Fuzzy Logic”, Global Journal of Computer Science and Technology, Vol. 12 Issue 6 Version 1.0 March 2012.

Singh K. et al., “Study of Imperfect Information Representation and FSQL processing”, International Journal of Scientific & Engineering Research Volume 3, Issue 5, May-2012

Qi Yang et al., “Efficient Processing of Nested Fuzzy SQL Queries in a Fuzzy Database”, IEEE Transactions On Knowledge And Data Engineering, Vol. 13, No. 6, November/December 2001.

Abbaci K. et al., “Selecting and Ranking Business Processes with Preferences: An Approach Based on Fuzzy Sets”, International Conference on Cooperative Information Systems, Greece (2011).

Samuel Lee, Lance Titchkosky, and Seth Bowen., “Software Cost Estimation” Department of Computer Science, University of Calgary, 2002.

Pivert O. and Bosc P., “Fuzzy Preference Queries to Relational Databases”, ISBN-10: 1848168691, 2012.

Eileen Wrubel, Jon Gross., “Contracting for Agile Software Development in the Department of Defense: An Introduction”, Software Engineering Institute, Carnegie Mellon University, 2015.

Ambler, Scott W., “Disciplined Agile Software Development: Definition.”,, 2012, last accessed 1, 2016.

Neha Jain, Seema Shukla.” Fuzzy Databases Using Extended Fuzzy C-Means Clustering”, International Journal of Engineering Research and Applications (IJERA), Vol. 2, Issue 3, May-Jun 2012, pp.1444-1451.

Victor M. Lopez, “A Guide for Indirect Cost Rate Determination”, Office of Acquisition Management Services Business Operations Center OASAM, 2015.

Adel Sabour, Ahmed Gadallah, Hesham Hefney, " Flexible Querying of Relational Databases: Fuzzy Set Based Approach", Advanced Machine Learning Technologies and Applications, Vol 488 , pp 446-4


  • There are currently no refbacks.

Creative Commons License
This work is licensed under a Creative Commons Attribution 3.0 License.