Abstract
Conceptual modeling describes the physical or social aspects of the world abstractly, encompassing the interpretation of data production, gathering, visualization, and analysis. The quality of the data analysis system will limit the excellence of any decision-making process. Thus, accurately specifying the physical data model is essential. The primary goal of our work is to compare tools that can create this physical model. We recognize several types of data models, but we only include the relational data model. We evaluate free and commercial data modeling tools. But it is challenging to decide how to compare them and which elements are crucial. We propose a new approach for software tools’ evaluation based on the Business Readiness Rating (BRR) model and the OSSpal evaluation methodology. In this work, we show that this new methodology can be tailored to the needs of each individual developer or team, thus providing proper and meaningful results. Also, by applying this hybrid approach to the evaluation of data modelling tools, we show it can robustly handle the bias from lesser relevant evaluation categories.
Highlights
A data model is a set of concepts that can describe the data structure and operations on a database [1]
THE EVALUATION METHODOLOGY Since we focus on evaluating data modeling tools for relational databases, this section will explain how to perform this assessment
MODELING TOOLS EVALUATION we present the application of the methodology proposed in the previous section to evaluate the data modeling tools
Summary
A data model is a set of concepts that can describe the data structure and operations on a database [1]. These data structures include objects, relationships between these objects, and rules that define how data is organized. Data modeling creates a visual representation of either a whole information system or parts of it to reveal connections between data points and structures. This is the first step in data design, and Simsion and Witt [3] defined it as “a design activity which classifies information in an organized way and defines their relations.”. The data model is an essential element of the system development or database design processes. The process of data modeling is not simple, meaning it usually demands multiple iterations [23]
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
