MySQL is a popular Database Management
System (RDBMS), from the open source domain. It is extensively used by
communities that wish to establish a dynamic Web presence.
MySQL
they have dual licensing policy that helps support open source values while
being a profitable, sustainable business. All software that wishes to
participate in the open source game plan must abide by the GNU public license
(GPL). The GPL indicates that all software, (in this case MySQL) can be used at
no cost and that its source code is also made available under GPL.
Benefits
of MySQL:
MySQL’s outstanding benefits are:
·
Sharply reduced database
licensing costs
·
A cut in system downtime
·
Lower hardware expenditure
·
A reduction in
administration and support costs.
·
Delivers noticeably less
complicated solutions, that complement an existing corporate database such as
Oracle,IBM,DB2 and Microsoft SQL Server
·
Effortlessly handles large
databases i.e. more than 50,000,0000 records
·
With MySQL there are no
memory leakages
MySQL helps reduce/ eliminate major problems associated
with downtime, maintenance, administration and support. It offers superior
speed, reliability and ease of use.
Using
JAVA with MySQL:
The
Sales Management System developed demonstrates using Java, a platform
independent language with MySQL as the data Storage system. In this application
business data will be stored and retrieved form the sales Management System
Database (created earlier) in MySQL named SMS.
The system consists of:
·
A console that displays
the product details
·
A database/table(s) that
stores business data running on a windows or Linux computer.
To begin the development of the Sales Management
System, the following applications should exist on the Windows or Linux
computer:
·
Java as the development
environment (Version J2SDK 1.4.1_02)
·
MySQL as the data storage
System (Version MySQL 5.0.9)
·
Driver for connectivity
between Java and MySQL (Version 3.2.0-alpha)