SLIDE 1
Outline
S
What is MySQL?
S
History
S
Uses
S
Platforms and Interfaces
S
GUIs
S
Syntax
S
Why MySQL?
MySQL Presentation Group members: Marco Tony Kassis Nourhan Sakr - - PowerPoint PPT Presentation
MySQL Presentation Group members: Marco Tony Kassis Nourhan Sakr - - PowerPoint PPT Presentation
MySQL Presentation Group members: Marco Tony Kassis Nourhan Sakr Roba Bairakdar Outline What is MySQL? S History S Uses S Platforms and Interfaces S GUIs S Syntax S Why MySQL? S What is MySQL? S It is the
SLIDE 2
SLIDE 3
What is MySQL?
S It is the world’s most commonly used RDBMS S It is named after developer Michael Widenius; daughter, MY S Its source code is available under the terms of the GNU General
Public License.
S MySQL was owned and sponsored by a single for-profit firm, the
Swedish company MySQL AB, now owned by Oracle Corporation
S MySQL is used in high-profile, large-scale World Wide Web
products, including Wikipedia, Google, Facebook and Twitter.
SLIDE 4
History
S Originally developed by Michael Widenius and David
Axmark in 1994
S First release on 23rd of May 1995 S Windows version was released in 1998 S … S MySQL server 5.5 was released in December 2010
SLIDE 5
Uses
S It is the most popular choice of database for use in web
applications
S It is a central component of the widely used LAMP open source
web application software stack (LAMP: Linux, Apache, MySQL, Perl/PHP/Python)
SLIDE 6
Platforms and interfaces
S MySQL is written in C and C++ S It works on many different system platforms, including Linux,
Mac OS X, Solaris, etc.
S Some programming languages include libraries for accessing
MySQL databases. These include MySQL Connector/Net for integration with Microsoft’s Visual Studio and JDBC driver for Java
SLIDE 7
Graphical User Interface
S MySQL has no GUI tools to administer the databases or
manage the data contained
S Official MySQL Workbench enables users to graphically
administer MySQL databases and visually design database structures
S MySQL Workbench allows the users to manage the following:
S Database design & modeling S SQL Development S Database Administration
SLIDE 8
MySQL Demo
S The video is a demonstration
done on MySQL on campus
S http://youtu.be/K6sQL39qYnk
SLIDE 9
Syntax
Point of Comparison Similarity or difference DDL Almost the same DML The same in everything except for the outer join DCL The same
SLIDE 10
Why MySQL?
MYSQL has proven itself to be fast, reliable and cost effective to
- ther competitors such as MS
SQL Server and Oracle
SLIDE 11
Why MySQL?
SLIDE 12
Open Source
S It is free and developers can amend its code to suit their
requirements, which makes MYSQL highly customizable.
SLIDE 13
Fast Development
S New modules are constantly being developed for integration
with MYSQL. This presents a wider and faster circle of patches, upgrades and fixes available.
SLIDE 14
Scalability
S MySQL supports the capacity to handle deeply embedded
application running massive data and holding terabytes of information.
SLIDE 15
Flexibility
S compatible with Windows, Linux, OS2 and Solaris. It also
includes APIs for integration with C, C++, PHP, Java, Perl, Python, Tcl, Ruby, etc.
SLIDE 16
Performance
S A unique storage-engine architecture allows server
configuration according to the application type - whether high-speed transactional processing system or high-volume web site servicing millions of queries a day.
SLIDE 17
Availability
S According to a MS Case Study: Stratus Technologies, SQL
Server delivers “six nines”. That is 99.9999% uptime availability.
S High availability options vary
SLIDE 18
Robust Transactional Support
S Complete ACID (atomic, consistent, isolated, durable)
transaction support, distributed transaction capability, and multi-version transaction support where readers never block writers and vice-versa.
S Full data integrity is also assured through server-enforced
referential integrity, specialized transaction isolation levels, and instant deadlock detection.
SLIDE 19
Security
S All access passwords are stored in an encrypted format and
unauthorized accesses are restricted. It also encrypts the transactions so eavesdroppers (=listeners/spies) and data harvest tools cannot replicate or regenerate the database transactions once they are processed.
SLIDE 20
Favorable for…
S Small Businesses: free, easy to learn and operate S High traffic websites: high performance, fast data insert
capability, support for web functions
S Data Warehouse: scales up into the terabyte range featuring
main memory tables, B-tree and hash indexes and compressed archive tables that reduce storage requirements by up to 80%
SLIDE 21
Sources
S http://www.quotebean.co.uk/
buying-services/database- development/help-to-buy-guides/ advantages-of-mysql-in-database- development/
S http://www.mysql.com/
SLIDE 22
Questions?
SLIDE 23