Performance is an important non-functional attribute of the software system to be considered for producing quality software. Performance analysis by estimating development effort of the database application and workload estimation during preliminary design stages is an important consideration. In this paper It is propose a methodology for estimation of effort by considering Entity Relation model and combination of technical and environment factor(weak, strong) for performance analysis during preliminary design stages. Estimation of effort based on the complexity of ER by considering the entities set, attributes, relationship complexity, and structural constraints. The results are validated using multiple regression technique with case studies.

1. Samaresh Mishra, Prasant Ku. Pattnaik, Rajib Mall Early Estimation of Back-End Software Development Effort International Journal of Computer Applications (0975 – 8887) Volume 33– No.2, November 2011
2. Parastoo Mohagheghi, Bente Anda, Reidar Conradi, Effort Estimation of Use Cases for Incremental Large-Scale Software Development, ICSE’05, May 15–21, 2005, ACM 1-58113-963-2/05/000.
3. Evangelin Geetha, D., Suresh Kumar, T. V. Rajani Kanth, K..: ‘Framework for Integrated Performance Prediction Process (IP3) Model’, Technical Report, Department of MCA, MSRIT, TRMCA 03, March 2010.Jhk;
4. Yuan Zhao, and Hee Beng Kuan Tan, Wei Zhang, Software Cost Estimation through Conceptual Requirement, Third International Conference On Quality Software (QSIC’03), 2003 IEEE, pp.141
5. B. Londeix, Cost Estimation for Software Development, STC Telecommunications, UK, Addison-Wesley Publishing Company, 1987.
6. Ramez Elmasri, S. B. Navathe. D VLN Somayajulu, S.K Gupta, Fundamentals of Database Systems, Pearson Education 2006.
7. Capers Jones, Estimating Software Costs, Bringing Realism to estimation, 2nd Edition, TMH 2007.
8. Geoffrey J. Kennedy, Elementary structures in entity-relationship diagrams: a new metric for effort estimation, 1996 IEEE, pp. 86-92
9. B. W. Boehm, C. Abts, A. W. Brown, S. Chulani, B. K. Clark, E. Horowitz, R. Madachy, D. J. Reifer, and B. Steece, Software Cost Estimation with COCOMO II, Prentice Hall PTR, 2000.
10. Narayan S. Umanath, Richard W. Scamell, Data Modeling and Data base Design, THOMSON INDIA Edition 2007.
11. Emilia Mendes, Nile Mosley, Steve Counsell, Web Effort Estimation, Web Engineering, Springer International Edition 2006.
12. Samaresh Mishra, P.K. Pattnaik, Rajib Mall, A Novel Effort Estimation Model for Data Centric Software, National Conference on Embedded System, Current Issues and Applications, NCESA-2009, Feb14-15, 2009.
13. Mile Pavlic, Marin Kaluza, Neven Vrcek: Database complexity measuring method, Proceedings of the ISRM 2002 Conference, Las. Vegas, NV, USA, 2002.
14. Marcela Genero, Luis Jiménez, and Mario Piattini Measuring the Quality of Entity Relationship Diagrams,
15. A.H.F. Laender, S.W. Liddle, V.C. Storey (Eds.): ER2000 Conference, LNCS 1920, pp. 513-526, 2000. Springer-Verlag Berlin Heidelberg 2000
16. A. Silberschatz, H. F. Korth, S. Sudarshan, Database System Concepts, 5th Edition, McGRAW HILL Publication. pp-234.
17. Samaresh Mishra, Krushna Chandra Tripathy, Manoj Kumar Mishra, Effort Estimation Based on Complexity and Size of Relational Database System, International Journal of Computer Science and Communication, Vol. 1, No. 2, July-December 2010, pp. 419-422.
18. Koh, T.W., M.H. Selamat and A.A.A. Ghani, Exponential effort estimation model using unadjusted function points, Information Technology Journal, 2008, Volume: 7, Issue: 6, pp 830-839.
19. Jianfeng Wen, Shixian Li, Linyan Tang, Improve Analogy-Based Software Effort Estimation using Principal Components Analysis and Correlation Weighting, 16th Asia-Pacific Software Engineering Conference,2009, pp 179-186
20. Bushra Jamil, Javed Ferzund, Asma Batool, Shaista Ghafoor, Empirical Validation of Relational Database Metrics for Effort Estimation, 6th International Conference on Network Computing, IEEE, 11-13 May 2010, pp-1-5
21. Samaresh Mishra, Kabita Hazra, Rajib Mall, A Survey of Metrics for Software Development Effort Estimation, International Journal of Research and Reviews in Computer Science, Vol. 2, No. 5, October 2011, pp. 1199-1204.
22. Connie, U. Smith: ‘Performance Engineering of Software Systems’ (Addison-Wesley, 1990).
23. Connie, U. Smith, and Lloyd G. Williams: ‘Performance Solutions’ (Addison-Wesley, 2000).
24. Connie, U. Smith: ‘Software Performance Engineering: A Case Study including Performance Comparison with Design Alternatives’, IEEE Transactions on Software Engineering, 19,(7), July 1993, pp. 720-740.
25. Vittorio Cortellessa, Raffaela Mirandola, ‘PRIMA-UML: A Performance Validation Incremental Methodology on Early UML Diagrams’, Science of Computer Programming, Elsevier, 44, (1), 2002, pp. 101-129.
26. Dorin, B. Petriu, Daniel Amyot, Murray Woodside, and Bo Jiang: ‘Traceability and Evaluation in Scenario Analysis by Use Case Maps’, LNCS, 3466, 2005, pp. 134-151.
27. Andrea D’Ambrogio, Paolo Bocciarelli: ‘A model-driven approach to describe and predict the performance of composite services’, Proc. Workshop on Software and Performance 6th International Workshop on Software and Performance’ , WOSP’07, ACM ,Buenos Aires, Argentina, February 5–8, 2007 , pp: 78 – 89.
28. Simonetta Balsamo Moreno Marzolla: ‘Performance Evaluation of UML Software Architectures with Multiclass Queueing Network Models’, Proc. 5th International Workshop on Software and Performance, Spain, July, 2005, pp. 37 – 42.
29. Evangelin Geetha, D., Suresh Kumar, T. V., and Rajani Kanth, K.: ‘Early Performance Modeling for Web Based Applications”, Proc CIT ’04, Hyderabad, LNCS, 3356/2005, Springer Verlag, December 2004, pp. 400-409.
30. Evangelin Geetha, D., Suresh Kumar, T. V., and Rajani Kanth, K.: ‘Early Performance Modeling for Multi Agent Systems using UML 2.0’, IJCSNS International Journal of Computer Science and Network Security, March 2006, 6, (3A), pp.247-254.
31. Evangelin Geetha, D., Ram Mohan Reddy, Suresh Bente Anda, Hege Dreiem, Dag, I. K., Sjobergand Magne Jorgensen: ‘Estimating Software development Effort based on Use Cases – Experiences from Industry’, www.idi.ntnu.no/emner/tdt4290/docs/faglig/uml2001-anda.pdf. Accessed January 2007.
32. Edward, R., Carroll: ‘Estimating Software Based on Use Case Points’, OOPSALA ’05, San Diego, California, October 2005, pp.257-26.
33. Kusumoto, S., Matukawa, F., Inoue, K.: ‘Estimating Effort by Use Case Points: Method, Tool and Case Study’, Proc.10th International Symposium on Software Metrics (METRICS'04), September 2004, pp. 292-299.
34. Suresh Nageswaran: ‘Test Effort Estimation using Use Case Points’, Quality Week, San Francisco, June 2001, pp.1-6.
35. Roy, K., Clemmons: ‘Project Estimation with Use Case Points’, Cross Talk-The Journal of Defence Software Engineering, February 2006, pp:18-22.
36. James Rumbaing, Ivar Jacobson, Grady Booch: ‘The Unified Modeling Language Reference Manual’, (2nd Edition, Pearson Education, 2006).
37. Robert, T., Futrell, Donald, F., Shafer, and Linda, I. Shafer: ‘Quality Software Project Management’, (Pearson Education, 2006).
38. Linda, M., Laird, Carol Brennan: ‘Software Measurement and Estimation – A Practical Approach’, (John Wiley & Sons, 2006).
39. Rajib Mall, Fundamentals of Software Engineering, PHI, Second Edition, 2007.
40. Karner, G.: ‘Metrics for Objectory’, Diploma thesis, University of Linkoping, Sweden, No. LiTH-IDA-Ex-9344:21, December 1993.
41. Bente Anda, Hege Dreiem, Dag, I. K., Sjobergand Magne Jorgensen: ‘Estimating Software development Effort based on Use Cases – Experiences from Industry’, www.idi.ntnu.no/emner/tdt4290/docs/faglig/uml2001-anda.pdf. Accessed January 2007.
42. Bushra Jamil, Javed Ferzund, Asma Batool, Shaista Ghafoor, Empirical Validation of Relational Database Metrics for Effort Estimation, 6th International Conference on Network Computing, IEEE, 11-13 May 2010, pp-1-5

ER model Performance Engineering Distributed Database