Running Head: MySQL

1

MySQL University: Name: Course: Tutor: Date:

Running Head: MySQL

2

Abstract MySQL is basically an open-source Relational Database Management System (RDBMS) which is moderately well-known for light-weight website application programs. Over the last few decades, the software tool has also included various functionalities which let it to be adopted for larger company resources. This document will provide a brief introduction to the particular software tool. MySQL does not possess as many functions as PostgreSQL, and majority of the more innovative functions are not as mature as well. Though, the software programmer would expect it to work considerably better than due to its thread-based architecture (PostgreSQL works on a process-based architecture). Summary of the Tool: MySQL MySQL is a well-known open source database. It is formally pronounced as “My Ess Que Ell”, not my sequel. MySQL is capable to manage very large databases and it has a highly efficient performance (Kofler, 2001). The software tool of MySQL is primarily written in the language C/C++. It is developed by following the client-server architecture. This particular tool is available for MS Windows, Solaris, Linux and some other operating systems. MySQL is widely used among individual students and larger Organizations due to the following reasons.   MYSQL is almost free of cost; it is much less expensive than Oracle (Petri, 2005). Each and every individual student can set up MySQL locally on their own computer system.   It is really simple to use Shell in order to query tables, create tables etc. MySQL is simple to use with Java JDBC (Java Database Connectivity)

Running Head: MySQL

3

Type of Organizations that would benefit from MySQL Business Organizations that are research intensive and have large amounts of data to be stored use MySQL as a database management system. MySQL provides business solutions to a large number of Industries all over the globe. Examples of the Organizations that widely use MySQL as their database management system include Facebook, Google, LinkedIn, Walmart, Citrix and numerous others. Benefits and Limitations of MySQL Benefits of MySQL: Some important benefits of MySQL are as follows.  Performance: o Multi-threaded Architecture: Several clients of MySQL have simultaneous access. o Query Cache: Store the results of various common queries.  Ease of use: o MySQL has a command-line interface. o Major graphical tools of MySQL are web/desktop based.  Multi-user Support: o Several clients have a parallel access to single or multiple databases concurrently. o Flexible, powerful and efficient user privilege system. o MySQL possesses a user and host-based verification schemes.

Running Head: MySQL

4



Consistency, Reliability and Scalability: o MySQL can be successfully adopted for databases containing almost 50 million data records (Chervenak et al, 2004). o Organizations that use MySQL consist of Google, NASA and Yahoo etc.



Portability: o MySQL is portable to UNIX or Non-UNIX Platforms. It is best suitable with MS windows, Linux and Solaris etc.



Internationalization: o MySQL provides a support for numerous character sets and languages.



Wide Application Support: o MySQL offers a wide range of database driven software programs for web and desktop. o MySQL have already developed APIs for C/C++, Python, Ruby, PHP, Java, Perl etc.



Stored Programs: o MySQL has numerous stored functions and procedures. o It also allows a software developer to write triggers.

Limitations of MySQL: 32-bit binaries cannot deal with more than 4 Giga-Byte of storage. This is not actually a MySQL restriction, but this is a technological restriction. BLOB's are restricted to 1 Giga-Byte in size even though the developer uses LONGBLOB due to a restriction in MySQL protocol. The particular protocol restrict for max_allowed_packet is 1 Giga-Byte.

Running Head: MySQL

5

Different versions of MySQL have their own limitations on the number of joins. These versions allow different number of tables that may be referenced in a single join. Challenges in Data and Information Management Major challenges in data and information management are as follows.           Limits on scalability Continually changing site Data retrieval Growing data volumes Deficiency of correctly trained individuals Unsatisfactory utilization of resources Data safety and security Auditability Decentralized information management Low influence of information assets

MySQL Issues: Following are the known issues with MySQL.   Sub-query optimization for “IN” operator is not as efficient as for “=” operator. Dropping a constraint for foreign key does not work in repetition due to the reason that the particular constraint can have a different name on the slave.   Buffer sizes for MySQL are different on mater and slave. If a programmer runs the “Procedure” on some query that returns a null value, in a few scenarios the procedure does not alter the columns.

Running Head: MySQL

6

References Chervenak, A. L., Palavalli, N., Bharathi, S., Kesselman, C., & Schwartzkopf, R. (2004, June). Performance and scalability of a replica location service. In High performance Distributed Computing, 2004. Proceedings. 13th IEEE International Symposium on (pp. 182-191). IEEE. Kofler, M. (2001). What Is MySQL? (pp. 3-19). Apress. Petri, G. (2005). A Comparison of Oracle and MySQL. SELECT Journal, 12(1), 39-44.