Please use this identifier to cite or link to this item: http://repository.kpi.kharkov.ua/handle/KhPI-Press/55546
Title: Guidelines for laboratory works on the topic "Learning the basics of working with DBMS MySQL: Fundamental DDL and DML tools of SQL language"
Authors: Orlovskyi, D. L.
Kopp, A. M.
Keywords: guidelines; database management systems; information technology; software; programming
Issue Date: 2021
Citation: Guidelines for laboratory works on the topic "Learning the basics of working with DBMS MySQL: Fundamental DDL and DML tools of SQL language" [Electronic resource] : for students of spec. 121 "Software engineering", 122 "Computer science", 126 "Information systems and technologies" / comp.: D. L. Orlovskyi, A. M. Kopp ; National Technical University "Kharkiv Polytechnic Institute". – Electronic text data. – Kharkiv, 2021. – 29 p. – URI: http://repository.kpi.kharkov.ua/handle/KhPI-Press/55546.
Abstract: MySQL Database Management System (DBMS) is a freely distributed relational database developed and maintained by Oracle. From the very beginning, MySQL was developed by the Swedish company MySQL AB, which was later acquired by Sun Microsystems, which, in turn, was later acquired by Oracle. MySQL is distributed under both the GNU General Public License (GPL) and its commercial license. Under the terms of the GPL, software that uses MySQL libraries must also be distributed under the GPL license. For cases where developers do not want to open the source code of their software, a commercial license is provided. The advantage of a commercial license is quality service support. Contrary to Oracle’s MySQL licensing policy and to ensure free DBMS status, a fork of MySQL was created and called MariaDB. This database supports high compatibility with MySQL, ensuring the exact correspondence of the programming interface, the socalled API (Application Programming Interface), and MySQL commands. MySQL is a great solution for small, medium, and sometimes even large software systems. MySQL is also part of the WAMP (Windows, Apache, MySQL, PHP/Perl/Python) and LAMP (Linux, Apache, MySQL, PHP/Perl/Python) web application development stacks. This database is included in many ready-made assemblies of servers designed for web applications, such as XAMPP (which is proposed for use in this laboratory workshop), OpenServer, Denwer, and more. Recently, however, it is because of openness support, server builders and hosting providers are increasingly incorporating MariaDB into WAMP and LAMP stacks. Typically, MySQL is used as a server accessed by local or remote clients. However, the distribution also contains a library that provides the deployment of an internal server for standalone applications. In this laboratory workshop, we get acquainted with the main features of MySQL in the role of the client-server database.
ORCID: orcid.org/0000-0002-8261-2988
orcid.org/0000-0002-3189-5623
URI: http://repository.kpi.kharkov.ua/handle/KhPI-Press/55546
Appears in Collections:Кафедра "Програмна інженерія та інтелектуальні технології управління ім. А. В. Дабагяна"

Files in This Item:
File Description SizeFormat 
prohramy_2021_Learning.pdf1,01 MBAdobe PDFView/Open
Show full item record  Google Scholar



Items in DSpace are protected by copyright, with all rights reserved, unless otherwise indicated.