The International Arab Journal of Information Technology (IAJIT)

..............................
..............................
..............................


Traceability between Code and Design Documentation in Database Management System:

Traceability builds many strong connections or links between requirements and design, so the main purpose of traceability is to maintain consistency between a high level conceptual view and a low level implementation view. The purpose of this paper is to have full consistency between all components over all phases in the oracle designer tool by allowing traceability to be carried out not only between the requirements and design but also between the code and design. In this paper, we propose a new methodology to support traceability and completeness checking between code and design of oracle database applications. The new algorithm consists of a set of interrelated steps to initialize the comparison environment. An example of a student information System is used to illustrate the work.


[1] Allround Automations, PL/SQL, 2012 Developer, http://www.allroundautomations.com, /plsqldev.html, Last Visited, 2016.

[2] Alves-Foss J., de Leon D., and Oman P., Experiments in the Use of Xml to Enhance Traceability between Object-Oriented Design Specifications and Source Code, in Proceedings of the 35th Annual Hawaii International Conference on System Sciences, Big Island, pp. 3959-3966, 2002.

[3] Antoniol G., Caprile B., Potrich A., and Tonella P., Design-Code Traceability for Object- Oriented Systems, Annals of Software Engineering, vol. 9, no. 1-4, pp. 35-58, 2000.

[4] Buchgeher G. and Weinreich R., Automatic Tracing of Decisions to Architecture and Implementation, in Proceedings of the 9th Working IEEE/IFIP Conference on Software, Boulder, pp. 46-55, 2011.

[5] CoEST: Center of Excellence for Software Traceability, http://www.CoEST.org. Last Visited, 2015.

[6] Cysneiros G. and Zisman A., Traceability and Completeness Checking for Agent-Oriented Systems, in Proceedings of the ACM Symposium on Applied Computing, Fortaleza, pp. 71-77, 2008.

[7] Diff checker tool, https://www.diffchecker.com/, Last Visited, 2016.

[8] Espinoza A., Botterweck G., and Garbajosa J., A Formal Approach to Reuse Successful 926 The International Arab Journal of Information Technology, Vol. 15, No. 5, September 2018 Traceability Practices in SPL Projects, in Proceedings of the ACM Symposium on Applied Computing, Sierre, pp. 2352-2359, 2010.

[9] Ghabi A. and Egyed A., Exploiting Traceability Uncertainty Between Architectural Models and Code, in Proceedings of Joint Working IEEE/IFIP Conference on Software Architecture and European Conference on Software Architecture, Helsinki, pp. 171-180, 2012.

[10] Haitzer T. and Zdun U., DSL-Based Support For Semi-Automated Architectural Component Model Abstraction Throughout the Software Lifecycle, in Proceedings of the 8th International ACM SIGSOFT Conference on Quality of Software Architectures, Bertinoro, pp. 61-70, 2012.

[11] Hammad M., Collard M., and Maletic J., Automatically Identifying Changes That Impact Code-To-Design Traceability During Evolution, Software Quality Journal, vol. 19, no. 1, pp. 35- 64, 2011.

[12] Ibrahim S., Idris N., Munro M., and Deraman A., Integrating Software Traceability for Change Impact Analysis, The International Arab Journal of Information Technology, vol. 2, no. 4, pp. 301-308, 2005.

[13] Javed M. and Zdun U., A Systematic Literature Review of Traceability Approaches between Software Architecture And Source Code, in Proceedings of the 18th International Conference on Evaluation and Assessment in Software Engineering, London, p. 16, 2014.

[14] Oracle Designer 6i Product Overview. http://www.oracle.com/technetwork/testcontent/o tn-des6i-pover-wp-134818.pdf. Last Visited, 2015.

[15] Padgham L. and Winikoff M., Developing Intelligent Agent Systems: A Practical Guide, John Wiley and Sons, 2005.

[16] Parr T., The Definitive ANTLR Reference: Building Domain Specific Languages, Pragmatic Programmer, 2007.

[17] Requirements Management Ensuring Project Success.http://www.serena.com/docs/repository/ products /rm/ds900-001-0704.pdf, Last Visited, 2016.

[18] Saifan A., Akour M., Alazzam I., and Hanandeh F., Regression Test-Selection Technique Using Component Model Based Modification: Code to Test Traceability, International Journal of Advanced Computer Science and Applications, vol. 7, no. 4, pp. 90-95, 2016.

[19] Spanoudakis G. and Zisman A., Handbook of Software Engineering and Knowledge Engineering, World Sci Pub Co, 2005.

[20] Tiako P., Designing Software-Intensive Systems: Methods and Principles: Methods and Principles, IGI Global, 2008.

[21] Tran H., Zdun U., and Dustdar S., VbTrace: Using View-Based and Model-Driven Development to Support Traceability in Process- Driven Soas, Software and Systems Modeling, vol. 10, no. 1, pp. 5-29, 2011.

[22] Ubayashi N. and Kamei Y., Architectural Point Mapping For Design Traceability, in Proceedings of the 11th Workshop on Foundations of Aspect-Oriented Languages, Potsdam, pp. 39-44, 2012.

[23] Urman S. and McClain L., Oracle database 10g PL/SQL programming. McGraw-Hill, Inc.; Last Visited, 2004.

[24] Winikoff M., Multi-Agent Programming, Springer, Boston, MA, 2005. Mohammed Akour is an Assistant Professor in the Department of Computer Information System at the Yarmouk University (YU). obtained his Ph.D degree in software engineering from NDSU with honor. Ahmad Saifan is an assistant professor in the department of computer information systems at Yarmouk University (YU). He obtained his Ph.D degree in software engineering from Queen's University (Canada). Osama Ratha'an is a master student in the department of computer information systems at Yarmouk University (YU).