Performance Analysis of Database Synchronization on DBMS MySQL and Oracle by Using Event-Driven and Time-Driven Data for Monitoring Weather

Abstrak. Data cuaca berupa suhu udara, kelembaban udara, curah hujan, dan kecepatan angin memerlukan proses penyimpanan yang baik supaya data cuaca dapat direkapitulasi selama satu tahun. Untuk itu membutuhkan proses penyimpanan data melalui Database Management System (DBMS). DBMS dapat mengelola, menyimpan sekumpulan data secara baik. Pengguna DBMS dapat membuat, mencari, memelihara, serta memiliki akses terkontrol terhadap data. Penyimpan data pada pemantauan cuaca menggunakan hardisk eksternal dalam format Comma Separated Values (CSV), penyimpanan data seperti ini kurang efisien diakibatkan data direkapitulasi secara manual ke dalam computer. Kinerja sinkronisasi database dianalisis menggunakan metode Event-Driven dan Time-Driven pada DBMS Oracle dan MySQL untuk pemantauan data cuaca. Hasilnya, pada saat proses penyimpanan 100 data (record), MySQL memiliki kemampuan yang lebih cepat yaitu 166 detik dibandingkan dengan Oracle dalam waktu eksekusi 188 detik. Pada saat proses penyimpanan mulai 200 sampai 1000 data (record) membutuhkan waktu eksekusi rata-rata pada Oracle yaitu 203,56 detik sedangkan pada MySQL waktu eksekusi rata-rata 1163,89 detik. Jadi, kinerja DBMS Oracle lebih baik dibandingkan dengan DBMS MySQL dalam proses penyimpanan data cuaca, namun DBMS Oracle belum bisa menyimpan data secara langsung dari mikrokontroler karena belum adanya program yang mendukung ke dalam DBMS Oracle. Abstract. Weather data in the form of air temperature, humidity, rainfall, and wind speed require a good storage process so that weather data can be recapitulated for one year. For this reason, it requires the process of storing data through a Database Management System (DBMS). DBMS can manage, store a collection of data well. DBMS users can create, search, maintain and have controlled access to data. Data storage in weather monitoring uses an external hard drive in Comma Separated Values (CSV) format, this kind of data storage is less efficient due to the data being recapitulated manually into a computer. Therefore, the author wants to analyze the performance of database synchronization on Oracle and MySQL DBMS by using Event-Driven and Time-Driven methods for monitoring weather data. As a result, when storing 100 data (records), MySQL has a faster capability of 166 seconds compared to Oracle in 188 seconds of execution time. When the storage process starts from 200 to 1000 data (records) the average execution time in Oracle is 203.56 seconds, while in MySQL the average execution time is 1163.89 seconds. So, the performance of the Oracle DBMS is better than the MySQL DBMS in the process of storing weather data, but the Oracle DBMS has not been able to store data directly from the microcontroller because no program supports it into the Oracle DBMS.

Download Full-text

How I Do it: A Practical Database Management System to Assist Clinical Research Teams with Data Collection, Organization, and Reporting

The Arab Journal of Interventional Radiology ◽

10.1055/s-0041-1728962 ◽

2017 ◽

Vol 01 (01) ◽

pp. 10-14

Author(s):

Amr Maged Elsaadany ◽

Fida Hasan Alaeddin ◽

Mohamed Farouk Badran ◽

Hamad Saleh Alsuhaibani

Keyword(s):

Data Collection ◽

Clinical Research ◽

Data Storage ◽

Management System ◽

Database Management ◽

Data Entry ◽

Database Management System ◽

Manual Search ◽

Significant Edge ◽

Efficient Data

AbstractWith the growing amount of research projects in the field of interventional radiology, storing and organizing the patients' data and information effectively is becoming more difficult. Existing hospital electronic medical record and archiving systems store patient information in the form of reports which put the physicians and researchers in a situation where they have to use time-consuming manual search through reports for suitable patients for different clinical researches. Spreadsheet programs such as Microsoft Excel® (Microsoft, Washington, USA) are often used as a data storage, which has limitations in both organization and the quality of the data. Higher risk of incorrect data entry and introducing duplicates are associated with data input and analysis without a database system. Furthermore, selection, as well as calculation of data, is time-consuming. This article aims to provide interventionists with an efficient data collection tool optimized for interventional oncology clinical research. The implementation of the current database and interface allows a much faster and more detailed retrospective analysis of patient cohorts. The database management system with an interface is a very time-efficient and robust tool that provides a significant edge over the manual retrieval of patient records by filtering data and assisting statistical analysis in a study-relevant fashion.

Download Full-text

Growth of relational model: Interdependence and complementary to big data

International Journal of Electrical and Computer Engineering (IJECE) ◽

10.11591/ijece.v11i2.pp1780-1795 ◽

2021 ◽

Vol 11 (2) ◽

pp. 1780

Author(s):

Sucharitha Shetty ◽

B. Dinesh Rao ◽

Srikanth Prabhu

Keyword(s):

Data Storage ◽

Data Model ◽

Concurrency Control ◽

Management System ◽

Database Management ◽

Data Retrieval ◽

Database Management System ◽

Relational Model ◽

Complete Model ◽

Relational Data Model

A database management system is a constant application of science that provides a platform for the creation, movement, and use of voluminous data. The area has witnessed a series of developments and technological advancements from its conventional structured database to the recent buzzword, bigdata. This paper aims to provide a complete model of a relational database that is still being widely used because of its well known ACID properties namely, atomicity, consistency, integrity and durability. Specifically, the objective of this paper is to highlight the adoption of relational model approaches by bigdata techniques. Towards addressing the reason for this in corporation, this paper qualitatively studied the advancements done over a while on the relational data model. First, the variations in the data storage layout are illustrated based on the needs of the application. Second, quick data retrieval techniques like indexing, query processing and concurrency control methods are revealed. The paper provides vital insights to appraise the efficiency of the structured database in the unstructured environment, particularly when both consistency and scalability become an issue in the working of the hybrid transactional and analytical database management system.

Download Full-text

USER-ORIENTED DATABASE MANAGEMENT SYSTEM, COOD, AND ITS APPLICATION TO ON-LINE DATA STORAGE AND RETRIEVAL

Data for Science and Technology ◽

10.1016/b978-0-08-026201-7.50123-8 ◽

1981 ◽

pp. 504-507

Author(s):

N. Tanaka ◽

T. Matsuda ◽

A. Yamada

Keyword(s):

Data Storage ◽

Management System ◽

Database Management ◽

Database Management System ◽

Storage And Retrieval ◽

On Line

Download Full-text

A Realization of Security Model on Unified Database Console

Advanced Materials Research ◽

10.4028/www.scientific.net/amr.756-759.3584 ◽

2013 ◽

Vol 756-759 ◽

pp. 3584-3589

Author(s):

Hui Wang ◽

Lian Zhong Liu

Keyword(s):

Data Storage ◽

Performance Index ◽

Management System ◽

Database Management ◽

Database Management System ◽

Security Model ◽

Database Administration

As an extremely important platform of data storage, database management system (DBMS) is widely used in all kinds of enterprises and departments. The availability and security is a critical performance index for database. How to help administrator keep database secure and effective is a key job of database administration. This paper proposes a secure model of database management for administrator and achieved a secure database console to implement this model.

Download Full-text

Comunicación y almacenamiento de datos de un compensador vectorial

Revista de Tecnologías Computacionales ◽

10.35429/joct.2019.10.3.1.6 ◽

2019 ◽

pp. 1-6

Author(s):

Efrain Villalvazo-Laureano ◽

Richard Jesus Guerrero-Deniz ◽

Ramón Octavio Jiménez-Betancourt

Keyword(s):

Data Storage ◽

Web Site ◽

Management System ◽

Database Management ◽

Serial Communication ◽

Web Server ◽

Database Management System ◽

Visual Data

This paper presents the communication and using a (DB) Database to Vectorial Compensator. Using the serial communication as means between the compensator and the DB. Employing a datab in MYSQL since the DB is in a web server, later get the visual data in a web site. MySQL was used to the electric’s device data storage. To greaster ease of handling of DB, employing as DataBase Management System; “XAMPP”.

Download Full-text

ANALYSIS OF ADDITION OF DATA IN INFORMATION PROCESSING AND DECODING GROUND SYSTEM

Issues of radio electronics ◽

10.21778/2218-5453-2018-12-117-121 ◽

2018 ◽

pp. 117-121

Author(s):

E. V. Starostin ◽

I. G. Sergina

Keyword(s):

Information Processing ◽

Execution Time ◽

Management System ◽

Database Management ◽

Database Management System ◽

Registration System ◽

Advantages And Disadvantages ◽

Loading Process ◽

Ground System ◽

Data Loading

This article discusses the question of adding data in the information processing and decoding ground system. The scheme of registration of messages by the onboard registration device is resulted. Describes the subsequent recording of registered messages in binary files. For processing the received files the information processing and decoding ground system parses messages by their type. The problem of adding a large amount of data to the database management system «Linter-VS» 7.0. The article identifies and describes various methods of adding data, their advantages and disadvantages. To estimate the execution time of the data loading process was chosen the model of the messages registration system. The table of results of adding data by the various methods is presented and the histogram demonstrating comparison of adding data by different methods are given.

Download Full-text

Cardiological Database Management System as a Mediator to Clinical Decision Support

Methods of Information in Medicine ◽

10.1055/s-0038-1634632 ◽

1996 ◽

Vol 35 (01) ◽

pp. 52-58 ◽

Cited By ~ 3

Author(s):

A. Mavromatis ◽

N. Maglaveras ◽

A. Tsikotis ◽

G. Pangalos ◽

V. Ambrosiadou ◽

...

Keyword(s):

Management System ◽

Database Management ◽

Medical Information ◽

Object Oriented ◽

Medical Personnel ◽

Database Management System ◽

Ease Of Use ◽

Medical Database ◽

Analysis And Design ◽

Object Oriented Design

AbstractAn object-oriented medical database management system is presented for a typical cardiologic center, facilitating epidemiological trials. Object-oriented analysis and design were used for the system design, offering advantages for the integrity and extendibility of medical information systems. The system was developed using object-oriented design and programming methodology, the C++ language and the Borland Paradox Relational Data Base Management System on an MS-Windows NT environment. Particular attention was paid to system compatibility, portability, the ease of use, and the suitable design of the patient record so as to support the decisions of medical personnel in cardiovascular centers. The system was designed to accept complex, heterogeneous, distributed data in various formats and from different kinds of examinations such as Holter, Doppler and electrocardiography.

Download Full-text