.png)
Understanding MySQL as RDBMS
For students and web developers, if the database talk, most likely going to MySQL. But, why should MySQL? What about Oracle? The short answer, solid and exact is: free and user friendly.
MySQL is one application of RDBMS (Relational Database Management System). The simple notion of RDBMS is: a database application that uses relational principles. What is a relational principle? We will discuss it in the next tutorial.
MySQL is also not the only RDBMS, the full list is on wikipedia. Among the many known are: Oracle, Sybase, Microsoft Access, Microsoft SQL Server, and PostgreSQL.
MySQL is free and open source. This means everyone can use and develop this app. But although free, MySQL is supported by thousands of programmers from around the world, and is a complete RDBMS application, fast, and reliable. Here are some advantages of MySQL compared to other RDBMS:
Easy to use
Installation and MySQL simulation is quite easy and do not mess around with many settings. Simply download the MySQL application and install, we can use MySQL in less than 5 minutes (with no theme off lights).
Portability and Compliance Standards
MySQL database can easily move from one system to another. Suppose from Windows system to Linux. MySQL applications can also run on Linux systems (RedHat, SuSE, Mandrake, Debian), Embedded Linux (MontaVista, LynuxWorks BlueCat), Unix (Mac OS X, FreeBSD), Windows (Windows 2000, Windows NT) and RTOS (QNX).
Multiuser support
By applying client-server architecture. Thousands of users can access the MySQL database at the same time.
Internationalization
Or in simple language, language unhelpful. By using unicode commands, non-Latin characters like japan, china, and korea can be used in MySQL.
Wide Application Support
Usually RDBMS databases can not be used anymore, but accompanied by applications or other programming languages to provide interfaces, such as C, C ++, C #, Java, Delphi, Visual Basic, Perl Python and PHP. All of that is supported by the API (Application Programming Interface) by MySQL.
Open source code
We can (if able and understand) develop MySQL with the programm code. MySQL is developed with C and C ++ languages. There's even been a variety of new RDBMS flavors developed from MySQL code, following: Drizzle, MariaDB, Percona Server and OurDelta.
So much about the understanding and advantages of MySQL, and the reason why MySQL is more widely used and popular among web programmers. But if we ask a big IT company IT company, they might mention Oracle or Microsoft SQL Server as favorite RDBMS.
For the next tutorial, we will discuss about the history and future of MySQL, whether MySQL purchase by MySQL is no longer free and free to use? next on MySQL Learning Tutorial: History and the Future of MySQL.
Source:
Wikipedia - MySQL
MySQL.com
Vikram Vaswani: The Use and Administration of MySQL Database, McGraw-Hill 2010
For students and web developers, if the database talk, most likely going to MySQL. But, why should MySQL? What about Oracle? The short answer, solid and exact is: free and user friendly.
MySQL is one application of RDBMS (Relational Database Management System). The simple notion of RDBMS is: a database application that uses relational principles. What is a relational principle? We will discuss it in the next tutorial.
MySQL is also not the only RDBMS, the full list is on wikipedia. Among the many known are: Oracle, Sybase, Microsoft Access, Microsoft SQL Server, and PostgreSQL.
MySQL is free and open source. This means everyone can use and develop this app. But although free, MySQL is supported by thousands of programmers from around the world, and is a complete RDBMS application, fast, and reliable. Here are some advantages of MySQL compared to other RDBMS:
Easy to use
Installation and MySQL simulation is quite easy and do not mess around with many settings. Simply download the MySQL application and install, we can use MySQL in less than 5 minutes (with no theme off lights).
Portability and Compliance Standards
MySQL database can easily move from one system to another. Suppose from Windows system to Linux. MySQL applications can also run on Linux systems (RedHat, SuSE, Mandrake, Debian), Embedded Linux (MontaVista, LynuxWorks BlueCat), Unix (Mac OS X, FreeBSD), Windows (Windows 2000, Windows NT) and RTOS (QNX).
Multiuser support
By applying client-server architecture. Thousands of users can access the MySQL database at the same time.
Internationalization
Or in simple language, language unhelpful. By using unicode commands, non-Latin characters like japan, china, and korea can be used in MySQL.
Wide Application Support
Usually RDBMS databases can not be used anymore, but accompanied by applications or other programming languages to provide interfaces, such as C, C ++, C #, Java, Delphi, Visual Basic, Perl Python and PHP. All of that is supported by the API (Application Programming Interface) by MySQL.
Open source code
We can (if able and understand) develop MySQL with the programm code. MySQL is developed with C and C ++ languages. There's even been a variety of new RDBMS flavors developed from MySQL code, following: Drizzle, MariaDB, Percona Server and OurDelta.
So much about the understanding and advantages of MySQL, and the reason why MySQL is more widely used and popular among web programmers. But if we ask a big IT company IT company, they might mention Oracle or Microsoft SQL Server as favorite RDBMS.
For the next tutorial, we will discuss about the history and future of MySQL, whether MySQL purchase by MySQL is no longer free and free to use? next on MySQL Learning Tutorial: History and the Future of MySQL.
Source:
Wikipedia - MySQL
MySQL.com
Vikram Vaswani: The Use and Administration of MySQL Database, McGraw-Hill 2010
Tidak ada komentar:
Posting Komentar