M YSQ L
C E DATA BA S E
AN OPEN SOUR
WHAT IS OPEN SOURCE?
OPEN SOURCE – is another way of designing, developing and distributing
a software, providing flexible accessibility of software source code. In
software development , open source software became popular with the
increase of Internet users and developed web-based applications. Thus the
term open source emphasizes “free-software” shared freely to the public.
ADVANTAGES OF USING OPEN SOURCE SOFTWARE
FLEXIBILITY
AVAILABILITY
RELIABILITY
SHARED- FREELY
SOFTWARE UPDATES ARE AVAILABLE ONLINE
REDISTRIBUTION OF SOFTWARE MODIFICATIONS AND IMPROVEMENTS
NO- REQUIRED FEES FOR SOFTWARE UPDATES AND VERSION
DISADVANTAGES OF USING OPEN SOURCE
SOFTWARES
SUPPORT FOR SOFTWARE ISSUES ARE LIMITED AND NOT FREE
INTELLECTUAL PROPERTY INFRINGEMENT
QUALITY CAN NOT BE GUARANTED
OPEN SOURCE DATABASE MANAGEMENT SYSTEMS
MySQL is an open source relational database management system
(RDBMS) which provides robust functionalities for managing information.
This database system can be integrated with open source testing servers
such as Apache. Moreover MySQL is used for free-software projects, which
requires highly practical database management systems. MySQL can be
installed in Linux, Unix, and Windows operating system.
FEATURES:
CROSS- PLATFORM SUPPORT
STORED PROCEDURES AND TRIGGERS
STORAGE ENGINE SUPPORT
QUERY CACHING
SUPPORT FOR DATABASE REPLICATION
CURSOR AND VIEWS
Quick Facts About MySQL
• First Release: May 23, 1995
• Michael Widenius and David Axmark originally developed MySQL.
• MySQL is developed by MySQL AB
• Sun Microsystems acquired MySQL AB in 2008 including the copyrights for MySQL.
• In 2009, Oracle Corporation acquired the copyrights for MySQL code base.
• Recent Release: MySQL 8.0 /April 19,2018 – April 2026
• Developed in: C / C++
• License: GNU / General Public License
• Website: www.mysql.com
PostgrSQL
An open source Object Relational Database Management System
(ORDBMS), which supports server side-scripting languages and data
warehousing. PostgreSQL offers functions, triggers, inheritance and user-
defined objects for transactional processing and management.
Furthermore, there are registered global communities of developers and
companies which maintain and developed it.
FEATURES:
Functions
Indexes and Views
Triggers and Transactions
Multiversion Concurrency Control (MVCC)
User- defined Objects
Inheretance
Referential Integrity
Regular Expressions
Quick Facts About PostgreSQL
First Release: Version 1 in June 1989
The Ingres project at the University of California, Berkeley initially started the development of
PostgreSQL.
Yahoo and MySpace are one of the prominent users of PostgreSQL.
In 2006, Awards for Best Database were given by Linux Journal Editor’s Choice.
Developed in: C
License: BSD License
Recent Release: Version 16.1 November 9,2023 –November 9,2028
Website: www.postgresql.org
FIREBIRD
An open source Relational Database Management System
(RDBMS) supported by GNU/Linux, Windows and Unix platforms. The
Firebird Project initiated the development of its first release. Software
developers used SourceForge as centralized a repository of source code
collected from the developers to administer open source software
development.
FEATURES:
Stored procedures and Triggers
Complaint for Atomic, Consistent, Isolated, Durable (ACID) transactions
Referential Integrity
Multiversion Concurrency Control (MVCC)
Incremental Backups
Supports GUI administrative and replication
Quick Facts About Firebird
First Release: March 11,2002
Developer: Firebird Project
Developed in: C++
License: Interbased Public License (IPL), Initial Developer’s Public License (IDPL)
Recent Release: 4.0.4 / 3 NOVEMBER 2023
APACHE DERBY
An open source Java relational database management system that
supports online transaction processing and can also be integrated with
Java programs. Moreover, it supports IBM DB2 SQL syntax in order to
enhance software scalability and flexibility. Cloudscape Inc. was the original
authors and started the development of Apache Derby which was
continued by IBM under Apache Software Foundation.
FEATURES:
Cross-platform support
Supports IBM DB2 SQL
Supports Java Programs and JDBC drivers
Supports for client/server architecture such as Derby Network Client
JDBC driver and Derby Network Server.
QUICK FACTS ABOUT APACHE DERBY
• First Release: 1997
• Apache Software Foundation manages the development of Apache Derby
• Developer: Apache Software Foundation
• Developed in: Java
• License: Apache License 2.0
• Recent Release: 10.16.1.1 / MAY 19, 2022
• Website: http://db.apache.org/derby/
MaxDB
One of the well-known open source database management system
developed by SAP AG. The development of MaxDB was started as a
research project at the Technical University of Berlin headed by Rudolf
Munz, which is available free-of-charge and without support and usage
restrictions under GNU/ General Public License.
FEATURES:
• Cross-platform support
• Terabyte – range data support
• Supports JDBC, ODBC and SQLDBC drivers
• Supports backup and recovery
• Clustering support
• GUI-Based Installation and Manager
Quick Facts About MaxDB
• First Release: 2003
• Recent Release: 7.9.10 / JANUARY 2020
• Developer: SAP AG
• Written in: C++
• License: GNU/ General Public License
• Website: https://www.sdn.sap.com/irj/sdn/maxdb
Benefits of using Open source Database Systems
In using open source database management systems, users can
expect the following benefits.
RELIABILITY- users can expect that open source database systems
can perform tasks/ procedures in specified period of time. Maintaining
open source database systems is now an easier task since there are
available tools that can be downloaded for free to ensure database
performance and accessibility.
STABILITY- In the business area, improving business outcomes will be greatly
achieved using stable open source database systems. Developers ensure that
database systems are continually checked in order to sustain user requirements
in transaction processing as well as making the software more stable and
efficient.
AUDITABILITY- allowing users to access code bases will help to easily identify
software bugs, which can be fixed by community developers of open source
databases. Moreover, transparency of system to external audits will provide
improved robustness and reliability.
COST- Open source database system are available for free. Software
projects normally consider cost as one of the important factor in software
development wherein open source database systems are highly
considered. In 2008, the number of software houses that uses open
source database system increased because it provides free licensing
under GNU/ General Public Licensing or Open-License Agreement which
lessens the cost of software development and maintenance.
