Experiments and Descriptive Analysis in The MariaDB Database Cluster System to Prepare Data Availability

Author(s):  
Suyud Widiono

A database server called the Database Management System (DBMS) that relates tables in a database is called the Relational Database Management System (RDBMS). DBMS/RDBMS is a computer program that provides data services for computers or other computer programs. One of the RDBMS type database server (hereinafter referred to as a database server) is MariaDB. The database server is in charge of managing and providing data, so data must always be ready, fast presented, accurate, and safe, it cannot be damaged or even lost. One way to provide this data is to install several database servers using the concept of replication in the Multiple Server Database system. Replication in a cluster server database is a method of installing several database server nodes that allow between node servers to copy each other and distribute data from one node to another database server node, which then synchronizes data between server nodes to maintain data consistency. This study looks for the most optimal number of minimal database server nodes to provide accurate, fast and safe data on the MariaDB Cluster RDBMS. From the results of the replication test from the cluster server database, it can be concluded that the number of 3 (three) node servers can be known to always synchronize and consistency of data between server nodes, so there are 3 (three) nodes of minimum database node with MariaDB RDBMS.

Author(s):  
Rashed Mustafa ◽  
Md Javed Hossain ◽  
Thomas Chowdhury

Distributed Database Management System (DDBMS) is one of the prime concerns in distributed computing. The driving force of development of DDBMS is the demand of the applications that need to query very large databases (order of terabytes). Traditional Client- Server database systems are too slower to handle such applications. This paper presents a better way to find the optimal number of nodes in a distributed database management systems. Keywords: DDBMS, Data Fragmentation, Linear Search, RMI.   DOI: 10.3329/diujst.v4i2.4362 Daffodil International University Journal of Science and Technology Vol.4(2) 2009 pp.19-22


10.28945/2409 ◽  
2001 ◽  
Author(s):  
Leszek A. Maciaszek ◽  
Mieczyslaw L. Owoc

Information systems must be protected from unauthorized access. Authorization has been studied extensively as the main form ofpreserving the security of databases. Every database management system provides a sophisticated set of options aimed at protecting the database from unauthorized access. An important practical problem is how to take advantage of the database security options to ensure that a user is permitted to access the database through the application program but may not be allowed to access the database directly via database query tools. A related issue is how to extend the user privileges on the client part of the application so that only authorized GUI controls are available to the user. In this paper we propose a model for the design of necessary authorization settings into both the client and the server parts of a database application. The settings are stored in an Authorization Database (ADB) to which the program connects to customize itself for the current user. The customization is based on an application role granted to the user. An application role is activated for a connection (user session). After the database server authenticates the user, the user login to the application role can be transparently obtained by the application from the ADB.


1996 ◽  
Vol 35 (01) ◽  
pp. 52-58 ◽  
Author(s):  
A. Mavromatis ◽  
N. Maglaveras ◽  
A. Tsikotis ◽  
G. Pangalos ◽  
V. Ambrosiadou ◽  
...  

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.


1999 ◽  
Author(s):  
V.G. Ivensky ◽  
A. Olesen ◽  
T. May ◽  
L. Sroka ◽  
A. Pellegrino

1995 ◽  
Vol 32 (4) ◽  
pp. 677
Author(s):  
M J Shin ◽  
G W Kim ◽  
T J Chun ◽  
W H Ahn ◽  
S K Balk ◽  
...  

1982 ◽  
Vol 61 (s109) ◽  
pp. 40-41
Author(s):  
W. E. Hammond ◽  
William W. Stead ◽  
Mark J. Straube ◽  
Frederick R. Jelovsek

2018 ◽  
Vol 23 (1) ◽  
pp. 66-79
Author(s):  
Condro Wibawa ◽  
Dessy Tri Anggraeni

PT Bukaka Teknik Utama adalah perusahaan yang bergerak di bidang engineering, konstruksi, dan manufaktur. Dalam operasional usaha, diperlukan berbagai izin seperti izin usaha dan izin proyek yang merupakan bagian dari Dokumen Legal. Saat ini informasi Dokumen Legal di PT Bukaka Teknik Utama dikelola dalam aplikasi desktop yang bernama SIDOL (Sistem Informasi Dokumen Legal). Aplikasi juga digunakan untuk memonitoring masa berlaku dokumen. Namun begitu, aplikasi ini memiliki beberapa kekurangan, diantaranya adalah hanya dapat diakses oleh komputer yang terpasang aplikasi tersebut, hanya dapat diakses dari jaringan lokal (LAN), dan sistem notifikasi yang hanya dapat dilihat saat pengguna membuka aplikasi. Untuk mengatasi kekurangan tersebut, akan dilakukan perancangan ulang aplikasi sehingga mampu menjawab kekurangan yang ada. Pembuatan aplikasi menggunakan metode prototipe. Metode ini memiliki lima tahapan pengembangan yaitu communication, quick plan, modeling quick design, construction of prototype, and deployment delivery and feedback. Aplikasi dibangun menggunakan bahasa pemrograman HTML untuk tampilan, PHP untuk pengolahan data di sisi server, CSS untuk page styling, Code Igniter sebagai framework, dan Micsosoft SQL Server sebagai Database Management System. Hasil akhir aplikasi adalah menyediakan aplikasi yang dapat diakses semua karyawan yang membutuhlkan informasi Dokumen Legal serta memberikan notifikasi melalui e-mail ketika terdapat dokumen yang masa berlakunya akan segera berakhir.


Sign in / Sign up

Export Citation Format

Share Document