Multivocal Literature Mapping on DSLs and Tools for Entity-Relationship Modeling

A variedade de tecnologias de sistemas de banco de dados que se tornou disponível nos últimos anos dificulta a seleção de ferramentas para modelagem de entidade-relacionamento (ER). Nesse sentido, contribui-se com um levantamento de inovações recentes por meio de um mapeamento sistemático complementado por uma pesquisa na literatura cinza. Este trabalho abrange um conjunto final de 10 estudos primários focados em Linguagens Específicas de Domínio (DSL) e identifica 55 ferramentas já aplicadas na indústria e academia para modelagem ER em nível conceitual, lógico e físico. Assim, este estudo apresenta o estado da arte e da prática para modelagem ER, incluindo sua caracterização e lacunas de pesquisa.

Textual-based DSL for Conceptual Database Modeling: A Controlled Experiment

The variety of database system technologies that have become available in recent years makes it difficult to select tools for entity-relationship modeling (ER) in the teaching-learning context. This paper reports a replicated controlled experiment carried out with 33 subjects in order to compare effort spent (time) and quality, using the harmonic average between precision and recall, of the models produced with two different approaches. The models were produced in a proposed tool (ERtext) with a textual-based DSL and in another tool with a graphical approach (brModelo). Briefly, the data obtained indicate: i) both approaches present similar performance in relation to associated effort, and; ii) that there is a statistically significant difference in relation to the quality of the generated models, with a slightly advantage for the textual approach. Therefore, we conclude that the use of a textual-based DSL is feasible and our proposal is an acceptable solution in the context of conceptual database modeling.

PENENTUAN FITUR WEBSITE BIDANG PARIWISATA DAN KEBUDAYAAN DENGAN METODE FEATURE-ORIENTED DOMAIN ANALYSIS (FODA)

<p align="center"><strong><em>A</em></strong><strong><em>bstract</em></strong><strong><em></em></strong></p><p> </p><p><em>Determination of the features in creating a tourism and cultures websites is required to find out which features are can be implemented. To help determination of the feature, we can use a domain analysis method Feature-Oriented Domain Analysis (FODA). The method has some step, starting with application review to three sample websites to take on the features. The next step are the context analysis to gain a structure diagram and a context diagram. The next step are the modeling domain which divided into two steps, first, features analysis to get the features of the web application through the features diagram with an explanation through domain terminology dictionary. The next step is the entity-relationship modeling by making entity-relationship diagrams for database creation. The final step are architecture modelings to create a domain architecture for application development that only focus on the features. The results from the feature analysis get 38 mandatory features which be implemented on a web application </em><em>for tourism and culture.</em></p><p><strong><em>Keywords</em></strong><em>: </em><em>Tourism, Culture, Website, Features, Feature-Oriented Domain Analysis</em><em></em></p><p><em> </em></p><p align="center"><strong><em>A</em></strong><strong><em>bstrak</em></strong><strong><em> </em></strong></p><p class="isi"><em>Penentuan fitur dalam membuat website bidang pariwisata dan kebudayaan dibutuhkan untuk mengetahui fitur yang bisa diimplementasikan. Untuk membantu menentukan fitur tersebut, digunakan analisis domain dengan metode Feature-Oriented Domain Analysis (FODA). Metode tersebut mempunyai tahapan dimulai dari tinjauan aplikasi terhadap ketiga website sebagai sampel untuk mengambil fitur. Selanjutnya tahapan analisis konteks yang mendapatkan diagram struktur dan diagram konteks. Berikutnya tahapan pemodelan domain yang dibagi dua langkah yaitu analisis fitur untuk mendapatkan fitur-fitur pada aplikasi web melalui diagram fitur dengan penjelasan melalui kamus terminologi domain. Langkah berikutnya adalah pemodelan entity-relationship dengan membuat diagram entity-relationship untuk pembuatan database. Terakhir, pemodelan arsitektur dengan membuat arsitektur domain untuk pengembangan aplikasi yang hanya fokus pada fitur. Hasil dari analisis fitur adalah didapatkan sebanyak 38 fitur mandatory </em><em>yang berarti fitur tersebut wajib diimplementasika</em><em>n dalam aplikasi web untuk pariwisata dan kebudayaan.</em> </p><p><strong><em>Kata kunci</em></strong><em>: Pariwisata, Kebudayaan, Website, Fitur, Feature-Oriented Domain Analysis</em><em></em></p>