Relevant bibliographies by topics / MySQL databáze / Journal articles
To see the other types of publications on this topic, follow the link: MySQL databáze.

Journal articles on the topic 'MySQL databáze'

Author: Grafiati
Published: 4 June 2021
Last updated: 16 February 2022

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles

Select a source type:

Consult the top 50 journal articles for your research on the topic 'MySQL databáze.'

Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.

You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.

Browse journal articles on a wide variety of disciplines and organise your bibliography correctly.

1

Stěhule, Pavel. "PostgreSQL 8.3." Geoinformatics FCE CTU 2 (December 19, 2007): 91–100. http://dx.doi.org/10.14311/gi.2.12.

Full text
Abstract:
Práce na Open Source databázích pokračují nezadržitelným tempem. Vývojáři se musí vyrovnat s rostoucími požadavky uživatelů na objem dat ukládaných do databází, na náročnější požadavky na odezvu atd. Zatím nedostižnou metou je implementace celého standardu ANSI SQL 200x. Všechny databáze z velké trojky (Firebird, MySQL a PostgreSQL) používají multigenerační architekturu, cenově orientované hledání optimálního prováděcího plánu, write ahead log atd. MySQL se profiluje jako SQL databáze schopná používat specializované databázové backendy schopné maximální efektivity pro určité konkrétní prostředí. PostgreSQL je široce použitelná databáze, těžící z vynikající stability, s perfektní rozšiřitelností a komfortním prostředím. Konečně Firebird je vynikající embeded databáze, která se osvědčuje v tisících instalacích na desktopech.<br />Podle původního plánu mělo dojít k uvolnění verze 8.3 koncem léta - mělo jít o verzi obsahující patche dokončené pro 8.2, ale v té době nedostatečně otestované. Nakonec se ukázalo, že ty nejdůležitější patche je třeba dopracovat. Jednalo se o tak atraktivní vlastnosti, že se rozhodlo s vydáním nové verze počkat. 8.3 obsahuje integrovaný fulltext, podporu opožděného potvrzování (asynchronní commit), synchronizované sekvenční čtení datových souborů, úspornější ukládání dynamických datových typů (kratších 256byte), HOT updates a sofistikovanější aktualizaci indexů (hot indexes). Z patchů připravených pro 8.2 se v 8.3 neobjeví podpora bitmapových indexů a podpora aktualizovatelných pohledů. Původní řešení založené na pravidlech (rules) bylo příliš komplikované. 8.3 obsahuje podporu aktualizovatelných kurzorů, a je docela dobře možné, že aktualizovatelné pohledy budou ve verzi 8.4 implementovány právě s pomocí této třídy kurzorů.<br />Vývoj pokračuje implementací dalších modulů SQL. Ve verzi 8.3 je to konkrétně SQL/XML (rozšíření ANSI SQL), která umožňuje operace s XML dokumenty přímo v databázi a zjednodušuje generování XML dokumentů. Zásadní (interní) změnou je zkrácení hlavičky řádku z 28 bajtů na 24 bajtů. Další změnou, která by měla vést k minimalizaci velikosti uložených dat je diverzifikace typu varlena. Tento typ se v PostgreSQL používá pro serializaci hodnot všech typů s variabilní délkou. Trochu připomíná string v Pascalu. První byty nesou informaci o délce, další nesou obsah. Starší verze PostgreSQL znaly jen typ varlena s 4byte informací o délce. 8.3 podporuje také typ varlena s 1byte záhlavím. Úspora by se měla projevit hlavně u typu NUMERIC a krátkých řetězců. K překladu PostgreSQL lze počínaje touto verzí použít jak gcc, MINGW tak Microsoft Visual C++ (na platformě Microsoft Windows).
APA, Harvard, Vancouver, ISO, and other styles
2

Noh, Woo-seon, Sung-min Jang, Chul-hoon Kang, Kyung-min Lee, and Sang-jin Lee. "The Method of Deleted Record Recovery for MySQL MyISAM Database." Journal of the Korea Institute of Information Security and Cryptology 26, no. 1 (February 29, 2016): 125–34. http://dx.doi.org/10.13089/jkiisc.2016.26.1.125.

Full text
APA, Harvard, Vancouver, ISO, and other styles
3

Smirnov, Y., T. Wlodek, K. De, J. Hover, N. Ozturk, J. Smith, T. Wenaus, and D. Yu. "Experience with ATLAS MySQL PanDA database service." Journal of Physics: Conference Series 219, no. 4 (April 1, 2010): 042059. http://dx.doi.org/10.1088/1742-6596/219/4/042059.

Full text
APA, Harvard, Vancouver, ISO, and other styles
4

Korhonen, K., F. Donadini, P. Riisager, and L. J. Pesonen. "GEOMAGIA50: An archeointensity database with PHP and MySQL." Geochemistry, Geophysics, Geosystems 9, no. 4 (April 2008): n/a. http://dx.doi.org/10.1029/2007gc001893.

Full text
APA, Harvard, Vancouver, ISO, and other styles
5

Mohamed, Asghaiyer. "Network load traffic on MySQL atomic transaction database." Bulletin of Social Informatics Theory and Application 4, no. 1 (April 23, 2020): 35–39. http://dx.doi.org/10.31763/businta.v4i1.188.

Full text
Abstract:
Internet technology is developing very rapidly especially on the database system. Today's database has led to data that cannot be processed into the traditional way that we call big data. Some data stored on the server requires a way for the data to be valid and intact for that transaction mechanism appears on RDBMS which ensures that the data stored will become a unified whole as in customer account data, withdrawal of money at ATMs, e-transactions -commerce and so on. Of course the use of transactions in a database by not using Atomic transactions has a difference in terms of traffic on the network. This research appears by analyzing network traffic or density from a database that uses transactions and not to users who access them. This research method uses a questionnaire method by distributing questionnaires quantitatively to 300 respondents. The results of the study of approximately 300 respondents, researchers get the results that the use of transactions in databases and databases without transactions after being accessed by 300 people, the densest network is a network owned by a system that uses transaction features, this is because there is a slight increase of about 13% of traffic when compared to a network without transactions. This statement shows that two-way communication from a database that has the transaction provides feedback to the user so that the data is reliable as an indicator that the data has been stored safely. Further research can be done by finding other information or a study of big data using the atomic transaction model.
APA, Harvard, Vancouver, ISO, and other styles
6

Rakhmawati, Nur Aini, Muhammad Zuhri, Radityo Prasetianto Wibowo, Anwar Romadhon, Herdy Ardiansyah, and Olive Khoirul. "Benchmarking MySQL and NoSQL Databases on Egovbench Application." Journal of Information Technology and Its Utilization 2, no. 1 (August 21, 2019): 18. http://dx.doi.org/10.30818/jitu.2.1.2080.

Full text
Abstract:
E-Government is a result of technological advances in the government field. E-government assessment is needed to encourage the development of e-government in a better direction. The e-Government assessment can be measured using the Egovbench application. Egovbench performs crawling to obtain information from related websites or social media. The process of crawling done by Egovbench produces extensive data, which reduced performance in data processing. Therefore, there is a need for a database solution that has the best performance such as high processing speed and small database size. This study examined the comparison between relational databases and non-relational databases based on selected metrics to obtain the most suitable database solution for Egovbench. The results show that the MySQL database has the advantage of complex query processing and the use of the database with the smallest storage space. MongoDB database has the advantage of low data transfer volumes. Couchbase database has the advantage of short and straightforward query processing with a high number. The evaluation results show that MySQL is more suitable for Egovbench needs, which is the best response time and query per second. MySQL outperformed the other two databases on backup and storage file sizes testing.
APA, Harvard, Vancouver, ISO, and other styles
7

SUNG, HYUN-IL, SANG CHUL KIM, IN SUNG YIM, BONG GYU KIM, YOUNG SUK AHN, HYUN-WOONG NAM, SANGMO SOHN, and HONG-JIN YANG. "CONSTRUCTION OF ASTRONOMICAL DATABASE BASED ON MySQL AND JSP." Publications of The Korean Astronomical Society 19, no. 1 (December 1, 2004): 109–19. http://dx.doi.org/10.5303/pkas.2004.19.1.109.

Full text
APA, Harvard, Vancouver, ISO, and other styles
8

McDonald, Andrew G., Sinéad Boyce, Gerard P. Moss, Henry BF Dixon, and Keith F. Tipton. "ExplorEnz: a MySQL database of the IUBMB enzyme nomenclature." BMC Biochemistry 8, no. 1 (2007): 14. http://dx.doi.org/10.1186/1471-2091-8-14.

Full text
APA, Harvard, Vancouver, ISO, and other styles
9

Sukisno, Sukisno. "Perancangan Sistem Informasi Puskesmas Menggunakan PHP dan Database MySQL." UNISTEK 5, no. 1 (January 19, 2018): 23–27. http://dx.doi.org/10.33592/unistek.v5i1.281.

Full text
Abstract:
Teknologi informasi sekarang ini berkembang sangat pesat. Banyak bermunculan aplikasiaplikasibaru yang mendukung kebutuhan masyarakat. Tidak bisa dipungkiri lagi bahwa teknologiinformasi sangat dibutuhkan oleh masyarakat untuk mempermudah pekerjaan, melancarkantransaksi, mencatat seluruh kegiatan dalam suatu bisnis proses suatu perusahaan. Pusat KesehatanMasyarakat, disingkat Puskesmas, adalah organisasi fungsional yang menyelenggarakan upayakesehatan yang bersifat menyeluruh, terpadu, merata, dapat diterima dan terjangkau olehmasyarakat, dengan peran serta aktif masyarakat dan menggunakan hasil pengembangan ilmupengetahuan dan teknologi tepat guna, dengan biaya yang dapat dipikul oleh pemerintah danmasyarakat. Upaya kesehatan tersebut diselenggarakan dengan menitikberatkan kepada pelayananuntuk masyarakat luas guna mencapai derajad kesehatan yang optimal, tanpa mengabaikan mutupelayanan kepada perorangan. Karena berhubungan dengan masyarakat luas, maka untuk transaksiyang ada di dalam sebuah Puskesmas harus dibuat cepat supaya efektif dan efisien. Berlatarbelakangkurang banyaknya aplikasi komputer yang ada di Puskesmas, maka peneliti melakukan perancangan,membuat desain, melakukan coding, testing dan implementasi terhadap aplikasi yang dibuat. Aplikasiini bertujuan untuk merancang sistem informasi layanan di Puskesmas, menyimpan data sebagaimaster data, mencatat seluruh kegiatan business process yang ada di Puskesmas.Kata kunci: Puskesmas, Kesehatan Masyarakat, Sistem Informasi
APA, Harvard, Vancouver, ISO, and other styles
10

Matallah, Houcine, Ghalem Belalem, and Karim Bouamrane. "Comparative Study Between the MySQL Relational Database and the MongoDB NoSQL Database." International Journal of Software Science and Computational Intelligence 13, no. 3 (July 2021): 38–63. http://dx.doi.org/10.4018/ijssci.2021070104.

Full text
Abstract:
NoSQL databases are new architectures developed to remedy the various weaknesses that have affected relational databases in highly distributed systems such as cloud computing, social networks, electronic commerce. Several companies loyal to traditional relational SQL databases for several decades seek to switch to the new “NoSQL” databases to meet the new requirements related to the change of scale in data volumetry, the load increases, the diversity of types of data handled, and geographic distribution. This paper develops a comparative study in which the authors will evaluate the performance of two databases very widespread in the field: MySQL as a relational database and MongoDB as a NoSQL database. To accomplish this confrontation, this research uses the Yahoo! Cloud Serving Benchmark (YCSB). This contribution is to provide some answers to choose the appropriate database management system for the type of data used and the type of processing performed on that data.
APA, Harvard, Vancouver, ISO, and other styles
11

Zhang, Yong Qiang, and Wen Ming Li. "Research and Design of the High-Performance Cluster Architecture Based on the MySQL and NoSQL." Advanced Materials Research 460 (February 2012): 313–16. http://dx.doi.org/10.4028/www.scientific.net/amr.460.313.

Full text
Abstract:
This paper aims at improve the MySQL relational database in the high concurrent read and write to the database, the high efficiency of mass data storage and access, database scalability and high availability aspects of the performance, presents a the High-performance Cluster Architecture Based on the MySQL and NoSQL. Use the MySQL on the advantages of relational data and the NoSQL on the advantages of storage areas for enterprise to save the development costs and maintenance costs. The combination of the MySQL and NoSQL has brought new ideas for the database development of web2.0.
APA, Harvard, Vancouver, ISO, and other styles
12

Madyatmadja, Evaristus Didik, and Chelsea Adora. "Designing and Using a MySQL Database for Human Resource Management." Advances in Science, Technology and Engineering Systems Journal 4, no. 6 (2019): 285–90. http://dx.doi.org/10.25046/aj040636.

Full text
APA, Harvard, Vancouver, ISO, and other styles
13

Asabere, Prince, Francois Sekyere, and Willie K. Ofosu. "Wireless Biometric Fingerprint Attendance System using Arduino and Mysql Database." International Journal of Computer Science, Engineering and Applications 10, no. 5 (October 31, 2019): 1–10. http://dx.doi.org/10.5121/ijcsea.2019.9501.

Full text
APA, Harvard, Vancouver, ISO, and other styles
14

Puspitasari, D., P. P. Arhandi, P. Y. Saputra, Y. W. Syaifudin, H. A. Himawan, and P. A. Sholihah. "Online judge MySQL for learning process of database practice course." IOP Conference Series: Materials Science and Engineering 523 (July 8, 2019): 012046. http://dx.doi.org/10.1088/1757-899x/523/1/012046.

Full text
APA, Harvard, Vancouver, ISO, and other styles
15

Cranshaw, J., D. Malon, A. Vaniachine, V. Fine, J. Lauret, and P. Hamill. "Petaminer: Using ROOT for efficient data storage in MySQL database." Journal of Physics: Conference Series 219, no. 4 (April 1, 2010): 042036. http://dx.doi.org/10.1088/1742-6596/219/4/042036.

Full text
APA, Harvard, Vancouver, ISO, and other styles
16

Veikkolainen, Toni, Lauri J. Pesonen, and David A. D. Evans. "PALEOMAGIA: A PHP/MYSQL database of the Precambrian paleomagnetic data." Studia Geophysica et Geodaetica 58, no. 3 (April 23, 2014): 425–41. http://dx.doi.org/10.1007/s11200-013-0382-0.

Full text
APA, Harvard, Vancouver, ISO, and other styles
17

Ohyver, Margaretha, Jurike V. Moniaga, Iwa Sungkawa, Bonifasius Edwin Subagyo, and Ian Argus Chandra. "The Comparison Firebase Realtime Database and MySQL Database Performance using Wilcoxon Signed-Rank Test." Procedia Computer Science 157 (2019): 396–405. http://dx.doi.org/10.1016/j.procs.2019.08.231.

Full text
APA, Harvard, Vancouver, ISO, and other styles
18

Pariyasto, Sofyan, Ema Utami, and Suwanto Raharjo. "Analisis Keamanan Dalam Desain Database PMB (Penerimaan Mahasiswa Baru) Dengan MySQL." Creative Information Technology Journal 5, no. 4 (March 19, 2020): 314. http://dx.doi.org/10.24076/citec.2018v5i4.155.

Full text
Abstract:
Keamanan dalam desaian suatu database merupakan hal yang sangat penting untuk diterapkan dalam membangun sebuah sistem informasi. Sering kali dalam implementasi keamanan database tidak begitu diperhatikan, baik dari segi tipe data, panjang data, maupun paramter yang berkaitan dengan transaksi data. Kesalahan dalam desain database biasanya baru akan disadari pada saat aplikasi sudah selesai dan sudah digunakan. Untuk memastikan sebuah sistem informasi berjalan dengan lancar maka akan digunakan analisa data berdasarkan rentang data tertinggi dan data terendah. Dengan menggunakan analisa rentang data maka data yang nilainya lebih rendah dari paremeter yang ditentukan akan dirubah ke nilai terendah yang sesuai dengan paramter. Begitu juga data yang nilainya lebih tinggi dari paramter yang telah ditentukan akan dirubah ke nilai tertinggi yang sesuai dengan parameter. Dari hasil pengujian yang dilakukan sebelum adanya filter check dan patameter tipe data dengan memasukan data yang berupa huruf, angka minus serta angka yang melebihi batas atas pada kolom nilai, data masih bisa tersimpan ke database. Pengujian selanjutnya dilakukan dengan memasukan angka -2,-3,-4,-5,-7,-7 serta angka diatas ambang batas atas 12,13,14,15,16,17, dari hasil pengujian yang dilakukan dapat disimpulkan bawah sebuah database dengan fungsi trigger jauh lebih aman dibandingkan dengan database yang hanya menerapkan fungsi pembatasan berdasarkan tipe datanya saja.Kata Kunci —Keamanan Desain Database MySQL, Analisis Keamanan DatabaseSecurity in the design of a database is very important to be applied in building an information system. Often in the implementation of a database security is not given much attention, both in terms of data types, length, and parameters relating to data transactions. Errors in database design are usually only noticed when the application is complete and has been used. To ensure an information system runs well, data analysis will be used based on the highest and lowest data ranges. By using data range analysis, data whose value is lower than the specified parameter will be changed to the lowest value in accordance with the parameters. Data whose value is higher than predetermined parameters will be changed to the highest value in accordance with parameters. Results of tests conducted before the filter check and data type patameter by entering data in the form of letters, minus numbers and numbers that exceed the upper limit in the value column, data can still be saved to database. Further testing is done by entering the numbers -2, -3, -4, -5, -7, -7 and numbers above the upper threshold of 12,13,14,15,16,17, from some of the results of tests conducted can be concluded below a database with a trigger function is more secure than a database that only applies restrictions based on its data type.Keywords— Security Database Design MySQL, Security Analysis Database
APA, Harvard, Vancouver, ISO, and other styles
19

Suryanto, Bagus. "Sistem Monitoring Panel Surya Berbasis Website." MSI Transaction on Education 2, no. 1 (February 10, 2021): 7–18. http://dx.doi.org/10.46574/mted.v2i1.47.

Full text
Abstract:
Monitoring panel surya sangat perlukan dilakukan untuk untuk melihat karekteristik panel surya tersebut, karena terjadinya perubahan intensitas cahaya matahari, suhu, arus dan tegangan membuat proses pendataan dilakukan secara manual. Berubahnya intensitas cahaya matahari dan suhu membuat arus serta tegangan yang dihasilkan juga berubah. Penelitian ini ialah melakukan pembacaan arus, tegangan, suhu dan intensitas cahaya matahari secara online, monitoring tersebut berbasis website yang menampung data tersebut pada database MySQL. Dengan menggunakan NodeMCU ESP8266 sebagai mikrokontroler yang terkoneksi dengan jaringan wifi yang terhubung dengan komputer maka data dapat dikirim ke database MySQL. Data yang dikirim ke database MySQL website berupa kolom tabel dan dalam bentul grafik. Dengan adanya proses monitoring panel surya melalui website. Hasil yang di peroleh tersebut dapat dianalisis dengan melihat data yang tersimpan di database MySQL.
APA, Harvard, Vancouver, ISO, and other styles
20

Cao, Wei, Feng Yu, and Jiasen Xie. "Realization of the low cost and high performance MySQL cloud database." Proceedings of the VLDB Endowment 7, no. 13 (August 2014): 1742–47. http://dx.doi.org/10.14778/2733004.2733077.

Full text
APA, Harvard, Vancouver, ISO, and other styles
21

Wlodek, Tomasz, Michael Ernst, John Hover, Dimitrios Katramatos, Jay Packard, Yuri Smirnov, and Dantong Yu. "Experience with Multi-Tier Grid MySQL Database Service Resiliency at BNL." Journal of Physics: Conference Series 331, no. 4 (December 23, 2011): 042044. http://dx.doi.org/10.1088/1742-6596/331/4/042044.

Full text
APA, Harvard, Vancouver, ISO, and other styles
22

Warman, Indra, and Wildani Wildani. "ANALISA KINERJA QUERY STORED PROCEDURE PADA DATABASE MANAGEMENT SYSTEM (DBMS) MYSQL." Jurnal Sains dan Teknologi: Jurnal Keilmuan dan Aplikasi Teknologi Industri 21, no. 1 (June 30, 2021): 58. http://dx.doi.org/10.36275/stsp.v21i1.366.

Full text
APA, Harvard, Vancouver, ISO, and other styles
23

Yoga Ananda Putra, Sumijan, and Mardison. "Perancangan Sistem Informasi Akademik Menggunakan Bahasa Pemograman Php dan Database Mysql." Jurnal Teknologi 9, no. 1 (June 26, 2019): 25–40. http://dx.doi.org/10.35134/jitekin.v9i1.5.

Full text
Abstract:
merancang suatu aplikasi yang menyajikan informasi yang dibutuhkan elemen sekolah agar dapat diperoleh secara lebih mudah dan efisien.Metode penelitian menggunakan analisis dan perancangan sisteminformasi dimana pada tahap analisis akan dibahas analisa sistem yang sedang berjalan. Kemudian pada tahap perancangan akan dibahas dan dilihat aliran sistem informasi baru, UML, disain user interfacedan disain file database.Hasil yang dicapai berupa pembuatan aplikasiyang mampu mempercepat proses pembuatan laporan atau informasi sesuai dengan apa yang diinginkansekolah.Dan sebagai bentuk penerapan dari teknologi yang ada pada saat ini.Kesimpulan adalah dengan penggunaan teknologi komputer secara optimal dapat membantu kinerja dari pihak sekolah dalam memberikan informasi mengenai data siswa
APA, Harvard, Vancouver, ISO, and other styles
24

Atmaja, Niko Surya. "Kerahasiaan Teks Basis Data MySQL Menggunakan Algoritma Elgamal." Jurnal Sistim Informasi dan Teknologi 1, no. 4 (November 2, 2019): 65–71. http://dx.doi.org/10.35134/jsisfotek.v1i4.17.

Full text
Abstract:
The common method used to secure a MySQL database is in access control. The technique is the use of a password. To better secure the data sent cryptographic techniques need to be done. This study uses the Elgamal method in conducting cryptography. The results of this study generate MySQL databases in random form during safer delivery and can only be accessed by parties who have a password. So this research can further improve MySQL data security
APA, Harvard, Vancouver, ISO, and other styles
25

Sugiantoro, Bambang, Retantyo Wardoyo, Sri Hartati, and Jazi Eko Istiyanto. "APPLICATION FOR MOBILE AGENT TO ACCESS MYSQL." IJID (International Journal on Informatics for Development) 1, no. 2 (April 12, 2017): 22. http://dx.doi.org/10.14421/ijid.2012.01204.

Full text
Abstract:
Availability of information is increasing rapidly, the method for encoding and storage of information also increased. The number of sources of information brings several problems, among them about how to combine the distributed data storage and different. Information on an organization or company is usually stored in separate locations and different formats. When there is an increase in storage capacity and the amount of information search costs, the company faced with an abundance amount of data. System development methodology used is Rapid Application Development (RAD) with a development framework Guidlines for Rapid Application Engineering (GRAPPLE). The software used in building this application is Borland Jbuilder 9. Rational Rose 2000 is used for the analysis and design using Unified Modeling Language (UML). Mysql server is a type of database to be accessed on each operating system. Operating system used in this study is Windows XP and Linux Fedora Core. This application was developed with aglets, which is one of software for building mobile agent applications.
APA, Harvard, Vancouver, ISO, and other styles
26

Silalahi, Mesri. "PERBANDINGAN PERFORMANSI DATABASE MONGODB DAN MYSQL DALAM APLIKASI FILE MULTIMEDIA BERBASIS WEB." Computer Based Information System Journal 6, no. 1 (March 31, 2018): 63. http://dx.doi.org/10.33884/cbis.v6i1.574.

Full text
Abstract:
Database appeared and began to develop in line with the needs of processing and data storage to meet the information needs. Database is part of an important building block in an information system. In addition to a relational database (SQL), which stores structured datas in tables with defined schemes, there is a non-relational databases (NoSQL) with a dynamic scheme or unstructured. This study will compare the performance between NoSQL database (MongoDB) and SQL database (MySQL) for a web-based multimedia file storage application that stores files as BLOBs. Performance comparison is based on the speed of execution and the computer resources usage (CPU, memory, and virtual memory).
APA, Harvard, Vancouver, ISO, and other styles
27

Murfi, Yohanes, Sugiyatno Sugiyatno, and Mugiarso Mugiarso. "Sistem Informasi Layanan Online Menggunakan Enkripsi MD5 Untuk Pelayanan Warga Berbasis Web." Journal of Students‘ Research in Computer Science 1, no. 1 (May 20, 2020): 45–54. http://dx.doi.org/10.31599/jsrcs.v1i1.78.

Full text
Abstract:
Abstract Online Service Information System Uses MD5 Encryption for Web-Based Citizens' Services for residents of the purple cottage in Central Kaliai, North Bekasi. From the research found the findings in the cover letter service. The application uses the codeigniter framework template, and uses the MYSQL database, PHP Myadmin. this study uses the waterfall method. The results of this study improve efficiency in terms of community service, especially for submission services. Keywords: Service Information System, PHP, Database, MySQL Abstrak Sistem Informasi Layanan Online Menggunakan Enkripsi MD5 untuk Layanan Warga Berbasis Web untuk warga pondok ungu di Kaliai Tengah, Bekasi Utara. Dari penelitian ditemukan temuan dalam layanan surat pengantar. Aplikasi ini menggunakan templat kerangka codeigniter, dan menggunakan database MYSQL, PHP Myadmin. penelitian ini menggunakan metode waterfall. Hasil penelitian ini meningkatkan efisiensi dalam hal layanan masyarakat, terutama untuk layanan pengiriman. Kata Kunci: Service Information System, PHP, Database, MySQL
APA, Harvard, Vancouver, ISO, and other styles
28

Rokhmah, Siti, and Ihsan Cahyo Utomo. "Binary Log Analysis on MySQL to Help Investigation Process Against Database Privillege Attacks." International Journal of Computer and Information System (IJCIS) 1, no. 1 (May 18, 2020): 11–15. http://dx.doi.org/10.29040/ijcis.v1i1.7.

Full text
Abstract:
Abstract—Database is an important part in managing information, because a database is a collection of data that is processed to produce information. because of the importance of the database, many crimes are directed to attack the database, both attacks against access rights or attacks against the data itself. My SQL is a Database Management System (DBMS) that provides several facilities, one of which is the logging facility. Binary Log is a type of database log in the form of binary digits that contains some information including the record of the time of the transaction, the user who made the transaction and the order in the transaction. With the Binary Log, it can be seen when the transaction occurred, who made the transaction and what transaction occurred in the database. The recording of transactions in the Binary Log can be used as one way to carry out an investigation process in the event of an attack on the database. In this study the focus is on analyzing transaction records in binary logs, namely when, who, dam and what information can be taken from the Binary Log. The output of this research is a table of binary log investigation results and its relation to database attacks.
APA, Harvard, Vancouver, ISO, and other styles
29

Solarz, Arkadiusz, and Tomasz Szymczyk. "Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison." Journal of Computer Sciences Institute 17 (December 30, 2020): 373–78. http://dx.doi.org/10.35784/jcsi.2281.

Full text
Abstract:
This article presents a comparative analysis of four popular database technologies. Commercial Oracle Database and SQL Server systems are compared with open source database management systems: PostgreSQL and MySQL. These systems have been available on the market for over a dozen years. Versions released in 2019 were selected for testing and comparasion. For the purposes of the comparative analysis, a database schema was developed and instantiated. Then, test scenarios were developed. They were prepared on the basis of the most popular operations performed with the use of database systems.
APA, Harvard, Vancouver, ISO, and other styles
30

Krocz, Katarzyna, Oleksandra Kizun, and Maria Skublewska-Paszkowska. "Perfomance analysis of relational databases MySQL, PostgreSQL, MariaDB and H2." Journal of Computer Sciences Institute 14 (March 30, 2020): 1–7. http://dx.doi.org/10.35784/jcsi.1565.

Full text
Abstract:
This article will compare the performance of relational databases MySQL, PostgreSQL, MariaDB and H2. The speed of executing will be tested on simple and more complex SQL queries. The tests results will show which database is more efficient.
APA, Harvard, Vancouver, ISO, and other styles
31

Milošević, Danijela, Selver Pepić, Muzafer Saračević, and Milan Tasić. "Weighted Moore–Penrose generalized matrix inverse: MySQL vs. Cassandra database storage system." Sādhanā 41, no. 8 (August 2016): 837–46. http://dx.doi.org/10.1007/s12046-016-0523-6.

Full text
APA, Harvard, Vancouver, ISO, and other styles
32

Ramadhan, Rizky Fajar, and Riki Mukhaiyar. "Penggunaan Database Mysql dengan Interface PhpMyAdmin sebagai Pengontrolan Smarthome Berbasis Raspberry Pi." JTEIN: Jurnal Teknik Elektro Indonesia 1, no. 2 (November 8, 2020): 129–34. http://dx.doi.org/10.24036/jtein.v1i2.55.

Full text
Abstract:
Penggunaan Smarthome pada masa modern seperti ini sangat efisien untuk mengendalikan perangkat dan alat-alat rumah tangga. Untuk membuat suatu pengendalian tersebut, dibutuhkan sebuah platform aplikasi sebagai jembatan untuk mengakses sistem yang telah dirancang pada Smarthome tersebut. Dalam penggunaanya database tersebut memerlukan server untuk menyimpan data, dimana server tersebut harus disewa perbulannya dan mengeluarkan biaya yang besar. Maka dari itu sistem penggunaan database MySQL dengan menggunakan Raspberry Pi sebagai server utama. Dimana Raspberry Pi yang digunakan akan diatur untuk menjadi server publik sehingga bisa diakses secara bebas melalui perangkat yang tersambung dengan internet dimanapun user berada, pengaksesan database ini hanya menggunakan dns public dengan interface phpMyAdmin pada web browser contohnya: raspibroker.ddns.net/phpMyAdmin. Hasilnya penggunaan database tersebut tidak perlu penyewaan server agar bias diakses oleh user melalui perangkat yang memiliki akses internet karena penggunaan server telah diatasi melalui pembuatan server public menggunakan Raspberry Pi, selain memudahkan user dalam mengakses system penggunaan server public dari Raspberry Pi juga menghemat dana.
APA, Harvard, Vancouver, ISO, and other styles
33

Tanjung, Sindi Raharjo, and Dedi Suhendro. "Aplikasi Sistem Akuntansi Rekapitulasi Pendapatan pada Perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsiantar." JURNAL PETIK 6, no. 1 (March 31, 2020): 7–17. http://dx.doi.org/10.31980/jpetik.v6i1.739.

Full text
Abstract:
Abstact — The Tirtauli Pematangsiantar Regional Water Company (PDAM) is classified as a state-owned company that has operational objectives to meet the needs of the community. Revenues at the Tirtauli Regional Water Company (PDAM) are divided into two, namely water revenues and non-water revenues. Regional income recapitulation Tirtauli Pematangsaiantar still uses Microsoft Excel application where the application is still often an error in revenue recapitulation. Based on this, the authors designed a recapitulation income accounting system application program using Microsoft Basic Net and MySQL database to produce applications better than those running. Application of income recapitulation accounting system using Microsoft Visual Basic Net is designed to produce a better application using a MySQL database designed to perform database manipulation processes with various facilities. The purpose of the authors designed the application to facilitate the User in recapitulation of income with the Visual Basic Net application system so that it can help or simplify the process of inputing income recapitulation.Keywords : Application, Revenue Recapitulation, Microsoft Visual Basic Net, MySQL Database.Abstrak — Perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsiantar digolongkan sebagai perusahaan negara yang memiliki tujuan operasional untuk memenuhi kebutuhan masyarakat. Pendapatan pada Perusahaan Daerah Air Minum (PDAM) Tirtauli terbagi menjadi dua, yaitu penerimaan air dan pendapatan non-air. Rekapitulasi pendapatan perusahaan Daerah Air Minum (PDAM) Tirtauli Pematangsaiantar masih menggunakan aplikasi Microsoft Excel di mana aplikasi masih sering kesalahan dalam rekapitulasi pendapatan. Berdasarkan hal ini, penulis merancang program aplikasi sistem akuntansi pendapatan rekapitulasi dengan menggunakan Microsoft Basic Net dan database MySQL untuk menghasilkan aplikasi lebih baik yang sedang berjalan. Aplikasi sistem akuntansi rekapitulasi pendapatan menggunakan Microsoft Visual Basic Net dirancang untuk menghasilkan suatu aplikasi yang lebih baik dengan menggunakan database MySQL yang didesain untuk melakukan proses manipulasi database dengan berbagai fasilitas. Tujuan penulis merancang aplikasi untuk mempermudah User dalam melakukan rekapitulasi pendapatan dengan sistem aplikasi Visual Basic Net sehingga dapat membantu atau mempermudah proses penginputan rekapitulasi pendapatan.Kata Kunci : Aplikasi, Rekapitulasi Pendapatan, Microsoft Visual Basic Net, Database MySQL.
APA, Harvard, Vancouver, ISO, and other styles
34

Kristian, Dolly Simon, Adian Fatchur Rochim, and Eko Didik Widianto. "Pengembangan Sistem Replikasi dan Redundansi untuk Meningkatkan Kehandalan Basisdata MySQL." Jurnal Teknologi dan Sistem Komputer 3, no. 4 (October 20, 2015): 523. http://dx.doi.org/10.14710/jtsiskom.3.4.2015.523-529.

Full text
Abstract:
With the development of information technology, humans make it easy to complete every duty. Any information about the work carried out to be very valuable, therefore the information should be stored properly, by organizing a reliable database system when performing data storage on the server information. Build a design application virtualization master slave database servers that are connected with the management node using the virtual application to get the test results replication system performance and redundancy in the design of the cluster system. Methodology of this research include the study of literature, collecting data by interview, observation, literature studies, system design, and testing of the system. In a literature study on the use of research methods to study the literature books, records that can be used as a support in the research. The design of this thesis using MySQL Cluster system with Ndbcluster engine. Last is testing this system on its performance on the server failure or failures occur and reliability in performance. The results obtained are when there is a failure on the primary server, it will be immediately replaced by another server is a slave. And the replication of data between the main server and slave.
APA, Harvard, Vancouver, ISO, and other styles
35

Jia, Xin Wei, and Gui Cheng Shen. "Research on Relational Database and NoSQL Based on XML Data." Applied Mechanics and Materials 713-715 (January 2015): 2329–34. http://dx.doi.org/10.4028/www.scientific.net/amm.713-715.2329.

Full text
Abstract:
With the rapid development of electronic commerce, huge transaction data is produced every day. How to store these data effectively and mine knowledge from these data has become the key urgent problem to solve. This paper first introduces the NO_SQL database MongoDB and its advantages. Then we have a compare on writing and reading performance between MogoDB and MySQL when storing XML document. Finally we have a conclusion that MongoDB has higher performance than MySQL by experiment, and No-SQL is a good choice when querying in massive data.
APA, Harvard, Vancouver, ISO, and other styles
36

Pohanka, Tomáš, and Vilém Pechanec. "Evaluation of Replication Mechanisms on Selected Database Systems." ISPRS International Journal of Geo-Information 9, no. 4 (April 17, 2020): 249. http://dx.doi.org/10.3390/ijgi9040249.

Full text
Abstract:
This paper is focused on comparing database replication over spatial data in PostgreSQL and MySQL. Database replication means solving various problems with overloading a single database server with writing and reading queries. There are many replication mechanisms that are able to handle data differently. Criteria for objective comparisons were set for testing and determining the bottleneck of the replication process. The tests were done over the real national vector spatial datasets, namely, ArcCR500, Data200, Natural Earth and Estimated Pedologic-Ecological Unit. HWMonitor Pro was used to monitor the PostgreSQL database, network and system load. Monyog was used to monitor the MySQL activity (data and SQL queries) in real-time. Both database servers were run on computers with the Microsoft Windows operating system. The results from the provided tests of both replication mechanisms led to a better understanding of these mechanisms and allowed informed decisions for future deployment. Graphs and tables include the statistical data and describe the replication mechanisms in specific situations. PostgreSQL with the Slony extension with asynchronous replication synchronized a batch of changes with a high transfer speed and high server load. MySQL with synchronous replication synchronized every change record with low impact on server performance and network bandwidth.
APA, Harvard, Vancouver, ISO, and other styles
37

Dalimunthe, Yulia Agustina. "Pengujian Kinerja Pencarian Data." Jurnal Inotera 1, no. 1 (July 27, 2017): 17. http://dx.doi.org/10.31572/inotera.vol1.iss1.2016.id4.

Full text
Abstract:
Database sudah merupakan kebutuhan wajib bagi para pembuat program dalam merancang suatu aplikasi yang berkaitan dengan record-record atau pun transaksi yang membutuhkan data yang berkelanjutan, database digunakan sebagai pusat data yang bias digunakan untuk mengambil suatu kebijakan kedepannya.Pemilihan database tentunya mempertimbangkan banyak factor mulai dari kapasitas penyimpanan, keamanan, kemudahan pengaksesan database, dari banyak factor pemilihan database yang digunakan kecepatan merupakan faktor yang paling utama dalam pemilihan database.PostgreSQL dan MySQL merupakan database yang banyak digunakan untuk menyimpan data, database tersebut biasanya dikombinasikan dengan bahasa pemrograman sehingga mudah digunakan untuk menyim panin formasi yang di inginkan.Pengujian database Postgresql dan Mysql akan dilakukan berdasarkan kecepatan dan pencarian data dari tabel yang sesuai di masing-masing database.
APA, Harvard, Vancouver, ISO, and other styles
38

Sari, Selvi Yona, and Novi Trisna. "PERANCANGAN SISTEM INFORMASI PENGOLAHAN DATA TRANSAKSI PENERIMAAN DAN PENGELUARAN KAS UNTUK PERENCANAAN PENGENDALIAN KEUANGAN." JURNAL TEKNOLOGI INFORMASI 3, no. 1 (July 20, 2019): 25. http://dx.doi.org/10.36294/jurti.v3i1.684.

Full text
Abstract:
Abstract - The aim of the research is to design and build an information system application for processing cash receipts and disbursements data for financial planning and control at the Wali Nagari Kenagarian Harau Office using the Java Netbean programming language and MySQL database which aims to speed up data entry for receipt and expenditure transactions cash and report presentation quickly, precisely and accurately. The conclusion in this study is the programming language Java Netbeans and MySQL proven to be able to be used in a performance that is fast, precise and accurate in data entry cash receipts and disbursements transactions, as well as more secure data security.Keywords - Cash Receipts and Expenditures, Java Netbeans, MySQL Abstrak - Tujuan penelitian adalah merancang dan membangun sebuah aplikasi sistem informasi pengolahan data transaksi penerimaan dan pengeluaran kas untuk perencanaan serta pengendalian keuangan pada Kantor Wali Nagari Kenagarian Harau dengan menggunakan bahasa pemrograman Java Netbean dan database MySQL yang memiliki tujuan untuk mempercepat entry data transaksi penerimaan dan pengeluaran kas dan penyajian laporan dengan cepat, tepat dan akurat. Kesimpulan dalam penelitian ini adalah bahasa pemograman Java Netbeans dan MySQL terbukti mampu digunakan dalam sebuah kinerja yang cepat, tepat dan akurat dalam entry data transaksi penerimaan dan pengeluaran kas, serta keamanan data lebih terjamin.Kata Kunci - Penerimaan dan Pengeluaran Kas ,Java Netbeans, MySQL
APA, Harvard, Vancouver, ISO, and other styles
39

Sudiartha, I. K. G., I. N. E. Indrayana, I. W. Suasnawa, S. A. Asri, and Putu Wijaya Sunu. "Data Structure Comparison Between MySql Relational Database and Firebase Database NoSql on Mobile Based Tourist Tracking Application." Journal of Physics: Conference Series 1569 (July 2020): 032092. http://dx.doi.org/10.1088/1742-6596/1569/3/032092.

Full text
APA, Harvard, Vancouver, ISO, and other styles
40

Maulana, Halim. "ANALISIS DAN PERANCANGAN SISTEM REPLIKASI DATABASE MYSQL DENGAN MENGGUNAKAN VMWARE PADA SISTEM OPERASI OPEN SOURCE." InfoTekJar (Jurnal Nasional Informatika dan Teknologi Jaringan) 1, no. 1 (September 9, 2016): 32–37. http://dx.doi.org/10.30743/infotekjar.v1i1.37.

Full text
Abstract:
Replikasi adalah suatu teknik untuk melakukan copy dan pendistribusian data dan objek-objek database dari satu database ke database lain dan melaksanakan sinkronisasi antara database sehingga konsistensi data dapat terjamin. Replikasi database dapat digunakan apabila sebuah organisasi atau perusahaan didukung oleh hardware dan aplikasi software dalam sebuah sistem yang terdistribusi melalui koneksi jaringan lokal maupun internet. Aplikasi yang berbeda mempunyai kebutuhan yang berbeda untuk otonomi dan konsistensi data dan pengguna dapat bekerja dengan mengcopy data pada saat tidak terkoneksi kemudian melakukan perubahan untuk dibuat database baru pada saat terkoneksi. Dengan menggunakan Vmware workstation dan Ubuntu server 14.0 yang menyediakan fasilitas simulasi jaringan antar PC meski tidak terpasang Network card maupun hub atau switch. Dengan menggunakan Vmware wokstation dan Ubuntu server ini pula akan dibangun Sistem Replikasi Database.Dengan memanfaatkan sistem replikasi database tersebut setiap client ataupun user dapat saling menggunakan database yang direplikasi dari server, sehingga setiap perubahan dari sisi server maupun client akan dapat langsung tersimpan pada seluruh sistem.
APA, Harvard, Vancouver, ISO, and other styles
41

Indrayana, INE, IKG Sudiartha, and IW Suasnawa. "MIGRASI MODEL DATA RELASIONAL KE MODEL DATA REALTIME DATABASE FIREBASE UNTUK APLIKASI MONITORING WISATAWAN." Just TI (Jurnal Sains Terapan Teknologi Informasi) 11, no. 1 (January 30, 2019): 12. http://dx.doi.org/10.46964/justti.v11i1.125.

Full text
Abstract:
Aplikasi Monitoring Wisatawan berbasis mobile membutuhkan akses data yang cepat untuk mendapatkan akses data yang optimal. Aplikasi Monitoring Wisatawan ini akan mencatat setiap posisi GPS perangkat yang terhubung ke dalam suatu group wisata dalam aplikasi ini. . Ada beberapa model data yang dapat digunakan untuk menyimpan data untuk aplikasi mobile diantaranya model data relational dan model data document . Model Data relasional seperti MySql tidak bersifat realtime, sedangkan model data document seperti Firebase bersifat realtime database. Aplikasi Monitoring Wisatawan ini lebih sesuai menggunakan database firebase karena hubungan antar data tidak terlalu rumit dan membutuhkan akses data yang cepat. Penelitian ini bertujuan untuk mengetahui tahapan migrasi dari database MySQL ke Realtime Database Firebase untuk aplikasi monitoring wisatawan. Migrasi dari MySQL ke Firebase pada aplikasi moitoring wisatawan melibatkan beberapa data utama yaitu data guide, data wisatawan dan data chating antar anggota group wisatawan. Aplikasi ini menggunakan google map untuk mempermudah visualisasi posisi wisatawan dalam satu group wisata.
APA, Harvard, Vancouver, ISO, and other styles
42

Gül, Ömer, and Uğur Bayrak. "A Smart Home System based on Microcontroller using Android Application and MySQL Database." Academic Perspective Procedia 3, no. 1 (October 25, 2020): 455–64. http://dx.doi.org/10.33793/acperpro.03.01.90.

Full text
Abstract:
In recent years, people may disremember to turn off various devices or not be sure open or closed. Predefined scenarios for these people, home comfort and efficiency in the workplace will help a lot. Most people spend time with mobile phones throughout the day. Therefore, the control of smart devices by phones would be an appropriate solution. In this study, it is designed with microcontroller based intelligent building automation system hardware and software to provide energy efficient, security and comfort. The programming of the microcontroller, writing the android application program for the mobile phone and MySQL database software were realized. Microcontroller with GSM shield, it is possible to control the devices connected to the system by an android application automatically and manually by means of the internet connection by the MySQL database on the remote server. It is ensured that all devices are adjusted with a single touch according to predefined scenarios.
APA, Harvard, Vancouver, ISO, and other styles
43

Bandyopadhyay, Abhijit. "Extraction and Analytics from Twitter Social Media with Pragmatic Evaluation of MySQL Database." International Journal of Computer Trends and Technology 57, no. 2 (March 25, 2018): 74–79. http://dx.doi.org/10.14445/22312803/ijctt-v57p114.

Full text
APA, Harvard, Vancouver, ISO, and other styles
44

Al Hakim, Aldie Lukman, Ilham Maulana, Itmamul Wafa, Yoga Koswara, and Yulianti Yulianti. "Perancangan Aplikasi Inventaris Gudang Menggunakan Bahasa Program PHP dan Database MySQL Berbasis WEB." Jurnal Teknologi Sistem Informasi dan Aplikasi 4, no. 1 (January 31, 2021): 7. http://dx.doi.org/10.32493/jtsi.v4i1.7754.

Full text
Abstract:
CV. Gema Insani Press is a company that operates in the printing of books, calendars, books and so on. To support the production of goods, the role of the inventory warehouse is very important. The problem that often occurs is that the recording of incoming and outgoing goods is still using traditional methods using software from Microsoft Excel so that there is often an error in the amount of materials that makes the stock insufficient when needed. Therefore an application is needed that can help record incoming and outgoing goods from the warehouse so that the existing stock of materials is the same as the data entered. The development of this application uses a method that is often used, namely the waterfall method and the programming language used is PHP using MySQL as the database center. This application is can make it easier to record items in the warehouse.
APA, Harvard, Vancouver, ISO, and other styles
45

Regina Adelia, Regina Adelia. "Perancangan Sistem Informasi Peminjaman Buku Diperpustakaan Menggunakan Bahasa Pemrograman PHP Dan Database Mysql." Jurnal Teknologi 10, no. 1 (July 12, 2021): 14–21. http://dx.doi.org/10.35134/jitekin.v10i1.18.

Full text
Abstract:
Web design of borrowing books at SMAN 1 Lembah Melintang PasamanBarat Library aims to make it easier for librarians to enter books that were previously done manually, thus saving time. In this application I make it easy for library staff to do computerized input so that it can be efficient and effective. Application of SMAN 1 Valley Melintang Valley Pasaman Barat Library. The library makes it easy for library staff to enter new book data, member data and employee data at SMAN 1 Lembah Valley Pasaman Barat Library. Book data that has been inputted is stored with a MySQLdatabase so that the data is safe.This research helps in establishing a book loan system. The design system in making a book loan application at SMAN 1 Lembah Melintang Pasaman Barat was developed by using some software namely Xampp, Sublime Text, Server which is a combination of Web Server, PHP and MySQL.
APA, Harvard, Vancouver, ISO, and other styles
46

Győrödi, Cornelia A., Diana V. Dumşe-Burescu, Robert Ş. Győrödi, Doina R. Zmaranda, Livia Bandici, and Daniela E. Popescu. "Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases." Applied Sciences 11, no. 15 (July 23, 2021): 6794. http://dx.doi.org/10.3390/app11156794.

Full text
Abstract:
Databases are an important part of today’s applications where large amounts of data need to be stored, processed, and accessed quickly. One of the important criteria when choosing to use a database technology is its data processing performance. In this paper, some methods for optimizing the database structure and queries were applied on two popular open-source database management systems: MySQL as a relational DBMS, and document-based MySQL as a non-relational DBMS. The main objective of this paper was to conduct a comparative analysis of the impact that the proposed optimization methods have on each specific DBMS when carrying out CRUD (CREATE, READ, UPDATE, DELETE) requests. To perform the analysis and performance evaluation of CRUD operations for different amounts of data, a case study testing architecture based on Java was developed and used to show how the databases’ proposed optimization methods can influence the performance of the application, and to highlight the differences in response time and complexity. The results obtained show the degree to which the proposed optimization methods contributed to the application’s performance improvement in the case of both databases; based on these, a detailed analysis and several conclusions are presented to support a decision for choosing a specific approach.
APA, Harvard, Vancouver, ISO, and other styles
47

Rahman, Muhammad Arif, and Lutfi Rahmatuti Maghfiroh. "KAJIAN DATABASE RELASIONAL DAN NONRELASIONAL PADA DATA BPS DALAM MENGHADAPI ERA BIG DATA." Seminar Nasional Official Statistics 2019, no. 1 (May 11, 2020): 25–30. http://dx.doi.org/10.34123/semnasoffstat.v2019i1.170.

Full text
Abstract:
Big data merupakan tantangan yang perlu dihadapi kedepannya, terutama bagi BPS sebagai badan penyedia data sensus dan survei. Teknologi penyimpanan data seperti MySQL, PostgreSQL, dan lainnya yang merupakan penyimpanan berbasis relasional mempunyai batasan-batasan dalam menghadapi era big data. Untuk mengatasi batasan-batasan yang ada tersebut, kemudian berkembanglah teknologi penyimpanan data berbasis nonrelasional yang dikenal dengan istilah NoSQL Database. Hingga saat ini telah banyak teknologi nonrelational database yang berkembang, contohnya Hadoop dan Couchbase. Perlunya penentuan teknologi penyimpanan data yang sesuai merupakan salah satu faktor penting dalam menghadapi era big data agar dapat memberikan performa kinerja yang maksimal. Atas dasar tersebut, penulis melakukan penelitian dengan mengkaji beberapa sistem database terpilih sebagai alternatif dalam menghadapi era big data. Penelitian dilakukan dengan membandingkan tiga teknologi database yaitu Hadoop, Couchbase, dan MySQL untuk melihat perbedaan performa dari ketiga database tersebut dalam penerapannya terhadap data Sensus/Survei BPS. Dari hasil penelitian menggunakan data individu SUSENAS, diperoleh hasil yaitu setiap database mempunyai keunggulan dan kelemahan masing-masing baik dari segi performa maupun fitur yang diberikan. MySQL memiliki keunggulan pada operasi write dengan multiple insert, Couchbase memiliki keunggulan pada operasi write dengan single insert, sedangkan Hadoop lebih unggul pada operasi read.
APA, Harvard, Vancouver, ISO, and other styles
48

Truskowski, Wojciech, Rafał Klewek, and Maria Skublewska-Paszkowska. "Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization." Journal of Computer Sciences Institute 16 (September 30, 2020): 279–84. http://dx.doi.org/10.35784/jcsi.2026.

Full text
Abstract:
Oracle, MSSQL, MySQL and PostgreSQL are four of the most popular relational databases. They are often used in internet applications. This paper aims to compare the efficiency of these technologies in terms of speed using virtualization with Docker. No publications that include virtualization were found among previous papers. After review of the literature, it was hypothesized that the Oracle engine would be the fastest. During the research, a series of experiments was carried out using the application, in which tests for measuring the time of instruction execution were implemented. Each query was measured 100 times and the first measurement was rejected. The obtained results confirmed the hypothesis about the superiority of the Oracle database. As in previous studies, it proved to be the fastest, also using virtualization.
APA, Harvard, Vancouver, ISO, and other styles
49

Talanov, V. M., D. S. Fomin, and V. P. Atmanzin. "CHOICE OF CRITERIA FOR COMPARATIVE ANALYSIS BETWEEN RELATIONAL DATABASE MANAGEMENT SYSTEMS SUCH AS MYSQL AND MICROSOFT SQL SERVER ON EXAMPLE OF DATABASE FOR TASK MANAGEMENT SYSTEM." Scientific and Technical Volga region Bulletin 7, no. 6 (December 2017): 223–26. http://dx.doi.org/10.24153/2079-5920-2017-7-6-223-226.

Full text
APA, Harvard, Vancouver, ISO, and other styles
50

Dewi, Melany Mustika, and Novandi Rezeki. "Analisis Perbandingan Optimasi Query Nasted Join dan Hash Join pada MySQL Server." CSRID (Computer Science Research and Its Development Journal) 9, no. 1 (June 22, 2017): 31. http://dx.doi.org/10.22303/csrid.9.1.2017.31-42.

Full text
Abstract:
<em>Optimasi query dapat menjadi salah satu cara yang digunakan untuk melakukan proses pengolahan data dalam mencari jalur tercepat pada database menagement system (DBMS). Membandingkan beberapa teknik optimasi untuk mengetahui mana yang tercepat dalam melakukan proses eksekusi data pada kondisi tertentu. Dalam penelitian ini proses pengujian yang dilakukan adalah mengolah data dengan menerapkan teknik optimasi dengan Nested Join Query dan Hash Join Query yang merupakan dua query yang banyak digunakan dalam basis data. Masalah yang dibahas dalam penelitian ini adalah bagaimana membandingkan kecepatan pengolahan data dengan query yang telah dilakukan join relasi dengan beberapa tabel yang berbeda dan menggunakan dua teknik optimasi. Sehingga dapat diambil kesimpulan teknik apa yang paling cocok digunakan dalam proses sesuai dengan kondisi tertentu. Proses ini dilakukan menggunakan MySQL sebagai DBMS dan data yang akan diolah adalah database yang berisi data pegawai. Hasil akhir dari penelitian ini berbentuk grafik dengan hasil teknik optimasi query yang terbaik yaitu Nasted Join Scalar.</em>
APA, Harvard, Vancouver, ISO, and other styles
You might also be interested in the bibliographies on the topic 'MySQL databáze' for other source types:
Dissertations / Theses Books
We offer discounts on all premium plans for authors whose works are included in thematic literature selections. Contact us to get a unique promo code!

To the bibliography