Optimization of Transaction Database Design with MySQL and MongoDB

Mumtahana, Hani Atun

doi:10.33395/sinkron.v7i3.11528

Cited by 3 publications

(3 citation statements)

References 7 publications

Supporting

Mentioning

Contrasting

Unclassified

Order By: Relevance

“…Leveraging the power of a MySQL database, the application efficiently stores each examination or measurement performed. [25] [20] This ensures that the recorded data remains accessible for future reference and analysis. Moreover, the application offers the functionality to download the stored data in the form of an xlsx file.…”

Section: End Figure 2 Flowchart Operation System Max30102 Sensor Of M...mentioning

confidence: 99%

Spo2 Analysis on Development of IoT-Based Lung Function and Spo2 Measuring Device

Shavira,

Ariswati,

Hamzah

2024

Indones.J.electronic.electromed.med.inf

View full text Add to dashboard Cite

Pulmonary dysfunction is a widespread issue, particularly in developing nations. It encompasses restrictive, obstructive, and mixed pulmonary function disorders that lead to a decrease in vital lung capacity, an increase in functional residual capacity, and a decline in blood oxygen concentration and saturation. This study aims to combine oximetry and spirometry into a single device, using the Internet of Things (IoT) technology to display results via a smartphone app. The focus is on analyzing oxygen saturation, with normal levels ranging from 96% to 100% in adults, alongside a heart rate of 60-100 beats per minute. The MAX30102 sensor measures oxygen saturation, and the Arduino Pro Mini and D1 Mini ESP32 microcontrollers process data. The Android-based app, developed using Kodular platform, integrates a MySQL database and connects to the device module via Wi-Fi. Ten respondents underwent five measurements, revealing an average error of ±0.88% for oxygen saturation (SpO2) and ±2.82% for heart rate measurements. The average data loss rate during transmission was ±0.66% for SpO2 and ±0.89% for heart rate. These findings highlight existing errors in the module. The research aims to facilitate remote health monitoring for healthcare professionals, improving accessibility and healthcare provision.

show abstract

Section: End Figure 2 Flowchart Operation System Max30102 Sensor Of M...mentioning

confidence: 99%

Spo2 Analysis on Development of IoT-Based Lung Function and Spo2 Measuring Device

Shavira,

Ariswati,

Hamzah

2024

Indones.J.electronic.electromed.med.inf

View full text Add to dashboard Cite

show abstract

“…Metode ini dinilai dapat menjawab pokok permasalahan karena sifatnya yang non formal sehingga memungkinkan peserta dapat menyampaikan ide-ide secara terbuka (Nuzul ZA et al, 2022). Metode tanya jawab merupakan proses komunikasi yang dilakukan secara langsung dan bersifat dua arah sehingga dapat menciptakan hubungan timbal balik antara penyuluh dan peserta (Mumtahana et al, 2022). Menurut Ependi (2018), metode ini bermanfaat untuk membiasakan peserta dalam mencurahkan pendapatnya tanpa ada rasa takut dan bimbang sehingga dapat meningkatkan keaktifan berpikir.…”

Section: Hasil Dan Pembahasanunclassified

Edukasi Gizi Seimbang sebagai Upaya Pencegahan ?Penyakit Degeneratif pada Remaja SMP

Solikhah,

Tumewu,

Weiha

et al. 2023

JPKM

View full text Add to dashboard Cite

Penyakit degeneratif tidak hanya terjadi pada lansia dan dewasa saja, melainkan juga pada remaja jika pola makannya tidak sesuai dengan pedoman gizi seimbang. Pedoman gizi seimbang merupakan kumpulan makanan dan minuman dengan kualitas dan kuantitas yang sesuai dengan kebutuhan harian tubuh dengan tetap memperhatikan prinsip keberagaman makanan, aktivitas fisik, perilaku hidup bersih, dan pemantauan berat badan secara teratur. Pengabdian masyarakat ini bertujuan untuk meningkatkan pengetahuan siswa/siswi tentang gizi seimbang. Metode yang digunakan adalah ceramah, Focus Groub Discussion (FGD), dan tanya jawab. Instrumen yang digunakan adalah kuesioner pengetahuan yang diberikan sebelum dan sesudah edukasi. Hasil yang diperoleh adalah adanya peningkatan pengetahuan siswa/siswi terkait gizi seimbang dari nilai rata-rata 59% menjadi 85%. Kesimpulan dari kegiatan ini adalah edukasi mampu meningkatkan pengetahuan gizi siswa/siswi sehingga tenaga gizi di puskesmas setempat disarankan untuk turut memberikan edukasi tentang pedoman gizi seimbang pada siswa/siswi agar pencegahan penyakit degeneratif dapat dilakukan sejak dini.

show abstract

“…The information generated from the database is obtained from several interconnected data [3]. There are several benefits of using a database, namely 1) Ease of storing data, 2) Minimizing data redundancy, 3) Data accuracy, 4) Availability of data according to user needs, 5) Data Security, 6) Availability of user sharing, 7) Providing data completely [4]. An application called the Database Management System is used to process data in the database, including MySQL, PostgreSQL, Ms. Access, SCL Server, and others [5], [1].…”

Section: Introductionmentioning

confidence: 99%

Optimizing transaction data performance in database management systems

Hartono,

Masyhur

2023

MATRIX

View full text Add to dashboard Cite

One indicator of the quality of an information system is the speed of data processing. A database's most common data processing operations are adding, displaying, changing, and deleting data. The amount of data stored in the database significantly impacts the performance of data processing and, therefore, the performance of information systems. The update command changes some or all of the data in a table. The update command works by retrieving the data in the table to be changed, entering the new data in a form, and then sending it back to the database. The update command is often combined with a condition specifying which data rows must be changed. This research is an experimental study that compares the use of the update command with a stored procedure to the use of the update command without a stored procedure. The results showed that the average processing time for the update command with the stored procedure was 348.896 milliseconds for the minimum data category, 266.462 milliseconds for the medium data category, and 279.543 milliseconds for the maximum data category. The average processing time for the update command without a stored procedure was 297.132 milliseconds for the minimum data category, 747.670 milliseconds for the medium data category, and 1256.273 milliseconds for the maximum data category. These results suggest that the update command with a stored procedure is more efficient than the one without a stored procedure. This is because the stored procedure can pre-compile the SQL statement, which reduces the time it takes to execute the statement.

show abstract

Optimization of Transaction Database Design with MySQL and MongoDB

Cited by 3 publications

References 7 publications

Spo2 Analysis on Development of IoT-Based Lung Function and Spo2 Measuring Device

Spo2 Analysis on Development of IoT-Based Lung Function and Spo2 Measuring Device

Edukasi Gizi Seimbang sebagai Upaya Pencegahan ?Penyakit Degeneratif pada Remaja SMP

Optimizing transaction data performance in database management systems

Contact Info

Product

Resources

About