Performing and analyzing non-formal inspections of entity relationship diagram (ERD)

Date

2013-08-01

Author

ÇAĞILTAY, NERGİZ
TOKDEMİR, GÜL
Kilic, Ozkan
Topalli, Damla

Metadata

Show full item record

This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.

Item Usage Stats

153
views

0
downloads

Designing and understanding of diagrammatic representations is a critical issue for the success of software projects because diagrams in this field provide a collection of related information with various perceptual signs and they help software engineers to understand operational systems at different levels of information system development process. Entity relationship diagram (ERD) is one of the main diagrammatic representations of a conceptual data model that reflects users' data requirements in a database system. In today's business environment, the business model is in a constant change which creates highly dynamic data requirements which also requires additional processes like modifications of ERD. However, in the literature there are not many measures to better understand the behaviors of software engineers during designing and understanding these representations. Hence, the main motivation of this study is to develop measures to better understand performance of software engineers during their understanding process of ERD. Accordingly, this study proposes two measures for ERD defect detection process. The defect detection difficulty level (DF) measures how difficult a defect to be detected according to the other defects for a group of software engineers. Defect detection performance (PP) measure is also proposed to understand the performance of a software engineer during the defect detection process. The results of this study are validated through the eye tracker data collected during the defect detection process of participants. Additionally, a relationship between the defect detection performance (PP) of a software engineer and his/her search patterns within an ERD is analyzed. Second experiment with five participants is also conducted to show the correlation between the proposed metric results and eye tracker data. The results of experiment-2 also found to be similar for DF and PP values. The results of this study are expected to provide insights to the researchers, software companies, and to the educators to improve ERD reasoning process. Through these measures several design guidelines can be developed for better graphical representations and modeling of the information which would improve quality of these diagrams. Moreover, some reviewing instructions can be developed for the software engineers to improve their reviewing process in ERD. These guidelines in turn will provide some tools for the educators to improve design and review skills of future software engineers. (c) 2013 Elsevier Inc. All rights reserved.

Subject Keywords

Hardware and Architecture, Software, Information Systems

URI

https://hdl.handle.net/11511/67824

Journal

JOURNAL OF SYSTEMS AND SOFTWARE

DOI

https://doi.org/10.1016/j.jss.2013.03.106

Collections

Department of Computer Engineering, Article

Suggestions

OpenMETU
Core

Modeling Distributed Real-Time Systems in TIOA and UPPAAL Schmidt, Klaus Verner; Schmidt, Şenan Ece (Association for Computing Machinery (ACM), 2016-11-01) The mission- and life-critical properties of distributed real-time systems require concurrent modeling, analysis, and formal verification in the design stage. The timed input/output automata (TIOA) framework and the UPPAAL software package are two widely used modeling and verification tools for this purpose. To this end, we develop the algorithm TUConvert for converting distributed TIOA models to UPPAAL behavioral models and formally prove its correctness. We demonstrate the applicability of our algorithm b...
An architecture for workflow scheduling under resource allocation constraints Karagöz, Pınar; Toroslu, İsmail Hakkı (Elsevier BV, 2005-07-01) Research on specification and scheduling of workflows has concentrated on temporal and causality constraints, which specify existence and order dependencies among tasks. However, another set of constraints that specify resource allocation is also equally important. The resources in a workflow environment are agents such as person, machine, software, etc. that execute the task. Execution of a task has a cost and this may vary depending on the resources allocated in order to execute that task. Resource alloca...
A process capability based assessment model for software workforce in emergent software organizations TANRIÖVER, ÖMER ÖZGÜR; Demirörs, Onur (Elsevier BV, 2015-01-01) Software process improvement frameworks for software organizations enable to identify opportunities for improving the processes as well as establishing road maps for improvement. However, software process improvement practice showed that to achieve a sustained, leveraged state, software organizations need to focus on the workforce as much as the process. Software process improvement frameworks address the people dimension indirectly through processes. To complement process assessment models/methods, there i...
A framework for reviewing domain specific conceptual models TANRIÖVER, ÖMER ÖZGÜR; Bilgen, Semih (Elsevier BV, 2011-09-01) Conceptual models are used in understanding and communicating the domain of interest during analysis phase of system development. As they are used in early phases, errors and omissions may propagate to later phases and may be very costly to correct. This paper proposes a framework for evaluating conceptual models when represented in a domain specific language based on UML constructs. The framework describes the main aspects to be considered when conceptual models are represented in a domain specific languag...
Efficiency and effectiveness of query processing in cluster-based retrieval Can, F; Altıngövde, İsmail Sengör; Demir, E (Elsevier BV, 2004-12-01) Our research shows that for large databases, without considerable additional storage overhead, cluster-based retrieval (CBR) can compete with the time efficiency and effectiveness of the inverted index-based full search (FS). The proposed CBR method employs a storage structure that blends the cluster membership information into the inverted file posting lists. This approach significantly reduces the cost of similarity calculations for document ranking during query processing and improves efficiency. For exa...

Citation Formats

N. ÇAĞILTAY, G. TOKDEMİR, O. Kilic, and D. Topalli, “Performing and analyzing non-formal inspections of entity relationship diagram (ERD),” JOURNAL OF SYSTEMS AND SOFTWARE, pp. 2184–2195, 2013, Accessed: 00, 2020. [Online]. Available: https://hdl.handle.net/11511/67824.