DATABASE

DATABASE

Database (database) is a collection of data stored systematically inside a computer that can be processed or manipulated using software (application program) to generate information. Database definitions include specifications of data types, data structures and also restrictions on data to be stored. Database is a very important aspect in information systems because it serves as a data storage warehouse that will be processed further. The database becomes important because it can organize data, avoid duplicate data, avoid unclear data relationships as well as complex updates.

The process of entering and retrieving data to and from data storage media requires software called database management system (DBMS). DBMS is a software system that enables database users (database users) to maintain, control and access data in a practical and efficient manner. In other words, all access to the database will be handled by the DBMS. This DBMS becomes the layer that connects the database with the application program to ensure that the database remains consistently organized and accessible easily.

Types of databases :

1. MYSQL

MySQL is the most popular open source database and widely used for web-based applications such as dynamic websites and e-commerce. In 2013, MySQL is the second most widely used database in the world and the first for open source databases. Judging from its history, MySQL was created in 1995 and sponsored by the Swedish company, MySQL AB. MySQL platform developers are Michael Widenius, David Axmark and Allan Larsson. MySQL is created to provide data management options that are efficient, reliable and reliable. In 2000, the MySQL platform changed to open source and following the GPL provisions.


The use of MySQL as the primary database for web applications is often integrated with PHP as an object-oriented script language. MySQL is one of the important components of LAMP web service solution stack (Linux, Apache, MySQL and PHP) which is an open source web development platform where Linux as the operating system, Apache as Web Server, MySQL as database and PHP as scripting language. If you build a blog or website using CMS like Joomla, Wordpress, Drupal or Magento, you are using MySQL as its database solution. MySQL is also widely used by major companies of the world such as Facebook, Google, Adobe, Alcatel Lucent and also Zappos.

2. ORACLE

Oracle is a leading relational database owned by Oracle Corporation. Oracle has been regarded as the best database for commercial database version. Oracle itself is available in a variety of configurations with customizable toolkits for small, medium to large companies that need the best and precise solution from a database for business purposes. Some say that Oracle is considered better for performance and scalability issues than other commercial databases.

Oracle's history began the first time in 1977 when the first version was developed by SDL (Software Development Laboratories) in which there was Larry Ellison and his two friends, Bob Miner and Ed Oates. The name Oracle itself comes from the code name (name-name) of a project funded by the CIA when Larry Ellison worked at his previous job at Ampex. In 1979, the commercial version of Oracle was available for the first time, while the latest version of Oracle is Oracle 12c, where "c" refers to cloud computing (cloud computing). Cloud computing is a reflection of Oracle's work to expand its data base that allows companies to consolidate and manage databases as cloud services.

3. MARIADB

Maybe some of you are still strangers or ever heard of this database name. MariaDB is a fully open source relational database system. All MariaDB database source code is released under GPL, LGPL or BSD license. MariaDB is actually a fork of the MySQL database. Fork here can be interpreted as a related project that can be considered as another version (mini) of the standard MySQL. MariaDB is another MySQL version development by Michael Widenius who has left Sun Microsystems after being officially acquired by Oracle Corporation.

The popularity of this database continues to climb. This is proven in 2013, Red Hat Enterprise Linux (RHEL) has got rid of MySQL and then replaced it with MariaDB. Likewise, Fedora preferred MariaDB over MySQL for Fedora 19 release. The latest stable release of MariaDB is version 10.1 which is also known as MariaDB Enterprise 2016. In this latest stable release, MariaDB has much better protection with database security on every layer . MariaDB can detect and prevent attacks by using access control, Key Management Services and authentication.


Thank you..