Venn Versus Relation Diagram Models For Database Relation in SQL Command Line

Kustian, Nunu; Julaeha, Siti; Parulian, Dudi; Selvia, Noni; Ambarsari, Erlin Windia

doi:10.1088/1742-6596/1783/1/012050

Cited by 3 publications

(5 citation statements)

References 5 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Misalkan pada penelitian [1] menunjukkan adanya pengolahan data yang digambarkan dalam suatu relasi basis data. Kemudian, basis data dapat direalisasikan ke dalam diagram relasi [2] dan diagram venn [3]- [5] untuk menunjukkan relevansi dari data tersebut untuk setiap subtansinya. Oleh karena itu, dalam data science, pemodelan mempunyai fundamental untuk memvisualisasikan data dengan tujuan memahami data secara mendalam dan menjadi dasar pembuatan kesimpulan.…”

Section: Pendahuluanunclassified

Pendekatan Violin Plot sebagai Pengenalan Pola untuk Interpretasi Data Penjualan Spare Part Komputer

Furqoni Yudhistira,

Erlin Windia Ambarsari,

Frieyadie

2023

jieee

View full text Add to dashboard Cite

This study examines the use of visual modeling in understanding the sales patterns of computer spare parts at PT Prima Krida Solusindo. The use of violin plots serves as a method for data interpretation, focusing on the distribution of sales data to gain a deeper understanding of customer needs. This study involves 3893 samples with eight features being analyzed. Initial results show a broad variation in the sales of computer spare parts. For example, the highest unit sales occur in the first quarter, but the sales volume tends to be low. Opposite, sales in the second quarter tend to focus on purchases with a relatively similar volume. In addition, preferences for distribution channels, sales segmentation, sub-segmentation, and product types also vary in sales volume. While the violin plot aids in visualizing data distribution, this study also found that this method has limitations, such as category overlapping, that complicate interpretation. The inclusion of additional plots can facilitate a more detailed interpretation

show abstract

Section: Pendahuluanunclassified

Pendekatan Violin Plot sebagai Pengenalan Pola untuk Interpretasi Data Penjualan Spare Part Komputer

Furqoni Yudhistira,

Erlin Windia Ambarsari,

Frieyadie

2023

jieee

View full text Add to dashboard Cite

show abstract

“…Banyaknya data yang saling berhubungan dikumpulkan ke dalam basis data agar mudah diklasifikasi. Keterkaitan datapun dapat digambarkan ke dalam pemodelan data, diantaranya Entity Relationship Diagram yang ditransformasikan ke dalam basis data [2], Diagram Venn digunakan sebagai pemetaan data [3], dan Diagram Relasi yang menggambarkan relasi data yang terhubung antar tabel [4]. Adanya pemodelan data tersebut memperlihatkan bagaimana proses kerja pada basis data.…”

Section: Pendahuluanunclassified

“…Namun, hal ini berbeda dengan Diagram Relasi di mana terlihat jelas data-data berelasi dalam basis data. Kelemahan Diagram Venn tidak memperlihatkan data saling berhubungan seperti berapa jumlah record data yang dihasilkan dari pemilahan data Query, apalagi jika berkaitan dengan data yang lebih kompleks [3]. Dengan demikian, berkenaan penelitian ini menggunakan tabulasi silang untuk menunjukkan data yang berasosiasi dalam basis data.…”

Section: Jurnal Publikasi Teknik Informatikaunclassified

See 1 more Smart Citation

Interpretasi Basis Data Dengan Pendekatan Tabulasi Silang Untuk Pemetaan Diagram Venn

Nurfidah Dwitiyanti,

Erlin Windia Ambarsari,

Nunu Kustian

2022

jupti

View full text Add to dashboard Cite

Venn diagrams group data sets based on relations, either in the form of combined or slice sets. Venn Diagram mapping occurs when there are interrelated data sets. Weaknesses Venn diagrams do not show interconnected data, such as how many data records come from sorting Query data. In this study, cross-tabulation supports indicating related data in the database, making a Venn Diagram. This research uses cross-tabulation results to facilitate Venn Diagram mapping in database exploration. The variable used as experimental material is student test scores. Database interpretation has evidenced cross-tabulation to map Venn Diagram by separating Grade levels. The breakdown of Grade levels makes it easier to understand the visualization of data in the Venn Diagram. Merging Assignments, UTS, and UAS workable if they have the same goal, referring to the Grade as the data centre. The results obtained that the Grade value with the highest achievement is A-. Assignments worth >= 81.5 by 41%, UTS between values of 73-85.5 by 21%, and UAS between values of 77.5-82.5 by 24%.

show abstract

“…One method was to analyze data with clustering. Several cases had handling differences, such as grouping data that had a label to observe, which correlated-forming a Venn diagram to determine the data relationship between datasets [1], [2]. However, some data have characteristics that need observation to discover patterns and behavior.…”

Section: Introductionmentioning

confidence: 99%

Comparison Approaches of the Fuzzy C-Means and Gaussian Mixture Model in Clustering the Welfare of the Indonesian People

Ambarsari

Dwitiyanti

Selvia

et al. 2023

KSS

View full text Add to dashboard Cite

We compared the previous study about clustering the welfare of the Indonesian people using the Fuzzy C-Means (FCM) approach to a recent study, the Gaussian mixture model (GMM). Both of which were soft clustering. The case analyzes by classifying 34 provincial data in Indonesia, based on eight welfare of people indicator variables in 2017, which the Central Statistics Agency had issued. We compared the FCM and the GMM approaches to determine a better level of accuracy in clustering data using the Silhouette index, the Davies-Bouldin index, and the Calinski-Harabasz index values as a validity test method. The FCM and GMM methods found that the optimal clusters were 2 and 6. When we observed the consistency of the three tests’ validity results, the GMM method was preferable to the FCM clustering method. Keywords: fuzzy, Gaussian mixture model, clustering

show abstract

Venn Versus Relation Diagram Models For Database Relation in SQL Command Line

Cited by 3 publications

References 5 publications

Pendekatan Violin Plot sebagai Pengenalan Pola untuk Interpretasi Data Penjualan Spare Part Komputer

Pendekatan Violin Plot sebagai Pengenalan Pola untuk Interpretasi Data Penjualan Spare Part Komputer

Interpretasi Basis Data Dengan Pendekatan Tabulasi Silang Untuk Pemetaan Diagram Venn

Comparison Approaches of the Fuzzy C-Means and Gaussian Mixture Model in Clustering the Welfare of the Indonesian People

Contact Info

Product

Resources

About