Model data includes a database hierarchy / tree, a database network, relational database, object-oriented database, hypermedia database, multidimensional database, geographic databases, knowledge databases, and multimedia databases.

Database Hierarchy
Database hierarchy / tree is a format similar to the inverted tree, which re-cord will contain the key fields and a number of fields lainnya.Seluruh record has only one "parent", and their respective parents have many "children." Therefore, hierarchy structure is marked by many to one relationship between the data.

Database Network
In the network database, records can be connected to more than one parent, allowing many to many relationships between data.Serupa model with the database hierarchy, the network using a database that relationship explicitly, called the pointer to member owner.Se and how physical address pointer is which contain the storage location of a record deal.

Relational database
Relational database using the order form data table that consists of rows and columns consistent with the business world situation nyata.Dalam relational database, called the table relations, and the model is based on the theory and mathematics from the collective relasi.Dalam this model, each row of data equivalen with the record and each column equivalen the field.

Object-Oriented Database
Object-oriented database is the main idea is that an object is from a small amount of data that is shared by all the data needed to be conducted an operation against tersebut.Database this data can be useful terutema in the multimedia environment.

Multidimensional database
The database is expanding two-dimensional data, including additional dimensions / double what's called a three-dimensional / cube.

Hypermedia database
Dtabase hypermedia is a database that stores pieces of information in the form of nodes that dikoneksikan with a link that was built by pemakai.Nodes can contain text, graphics, sound, viseo / computer program that can be executed.

Geographical Information Database
This database contains the location data, which is located on the map or use the data gambar.Dengan this model, the user can see the location of customers and suppliers in spatial, can even read the address easily.

Knowledge Database
Database of knowledge can save the rules of decision that is used to evaluate the situation and help users mambuat decision as an expert.

Multimedia Database
Multimedia database can store data in various media, in the form of text, sound, images, graphics, animation, and video.

MySQL is a software management system SQL database (in English: database management system) or the DBMS that multithread, multi-user, with around 6 million installations worldwide. MySQL AB makes MySQL available as a free software license under the GNU General Public License (GPL), but they also sell under a commercial license for cases where their use does not match the use of the GPL.

Is not the same with projects such as Apache, where software developed by the general community, and the copyright to the source code owned by their respective authors, MySQL is owned and sponsored by a commercial company MySQL AB of Sweden, which holds the copyright on almost all the code source. Both the Swedish and one Finnish, which is founded MySQL AB: David Axmark, Allan Larsson, and Michael "Monty" Widenius.


MySQL is a relational Database Management System (RDBMS) that is distributed free under the GPL license (General Public License). Where every person is free to use MySQL, but is not a derivative of a closed-source or commercial. MySQL is a derivative one of the main concepts in the database since a long time, namely the SQL (Structured Query Language). SQL is a concept of operation of the database, especially for the election or selection and income data, which allows the operation of the data easily done automatically. The reliability of a database system (DBMS) can be known from the way it works in the Optimizer process SQL commands, which are made by users and application programs. As the database server, MySQL can be considered more superior than the other database servers in the data query. This proved to queries made by single users, the speed of MySQL queries can be ten times faster than PostgreSQL, and five times faster than the box. In addition, MySQL also has several distinctive, among others:

1. 1. Portability

MySQL can run on a variety of stable operating system like Windows, Linux, FreeBSD, Mac OS X Server, Solaris, Amiga, and many more.

1. 2. Open Source

MySQL is distributed open-source (free), under the GPL license so it can be used freely.

1. 3. Multi

MySQL can be used by several users at the same time without any problems or conflict.

1. 4. Performance Tuning

MySQL has a stunning speed in handling queries simple, in other words, can process more SQL per unit of time.

1. 5. Column types

MySQL has a type of column that is very complex, such as signed / unsigned integer, float, double, char, text, date, timestamps, and others.

1. 6. Command and Functions

MySQL functions and operators have the full support of the Select and Where in the query.

1. 7. Security

MySQL has several layers of securities such as the level of subnetmask, host name, and permits the user to access the licensing system and play the encrypted password.

1. 8. Scalability and Limits

MySQL database capable of handling large-scale, with the number of records of more than 50 million and 60 thousand table and 5 billion lines. In addition, the limit index that can be reached 32 index on each table.

1. 9. Connectivity

MySQL can connect with the client to use TCP / IP protocols, Unix socket (UNIX), or named pipes commands (NT).

1. 10. Localization

MySQL can detect the error message on the client by using more than twenty languages. Nevertheless, the language is not included therein.

1. 11. Interface

MySQL has the interface (interface) to various applications and programming languages using the API (Application Programming Interface).

1. 12. Clients and tools

MySQL is equipped with various tools that can be used for database administration, and on each tool that is included instructions online.

1. 13. The structure of the table

MySQL has a table structure that is more flexible in dealing with ALTER TABLE, compared to other databases such as PostgreSQL or Oracle.

A relational database management system or in known in English as a relational database management system (RDBMS) is a computer program (or in a more typical is a computer program) that are designed to set / memanajemen a database as a set of data that is stored in a structured, and operations on the data at the request of users. Examples are the use of the DBMS and many work in various fields, such as accounting, human resources management, and others. Although initially only the DBMS owned by companies that have large-scale computer equipment in accordance with the specifications of the standard required (at the standard required can be very high) to support a large amount of data, the current implementation is very much and adaptatif with the needs of the data specification For the rational can be owned and implemented by all circles as part of the investment company.

History of the term RDBMS

Edgar F. Codd introduced the term in this seminarnya paper entitled "A relational model of Data for Large Shared Data Banks". One of the definitions are quite widely known on a relational database system is for 12 law Codd. However, at the beginning of the implementation many relational models that do not follow all the elements contained in the law that Codd made terminologinya developed to describe a typical database system that is more extensive. In the scope of the system to meet the minimum criteria of the following:

* Presents data on the user in the form of relational (shown in tabular form, as a collection of tables where each table beriisi set of columns and rows)
* Provide the service relasioanl to manipulate the data in tabular form

The system is the first time in a relatively meet the implementation of a relational model is the Center for Scientific Studies IB, England, in Peterlee; IS1 (1970-1972) and the implementation of the follow PRTV (1973-1979). The first system sold as a commercial RDBMS is Multics relational data Srore in 1978. The other is the Berkeley Ingres quel, and BS12 IBM.

Utilization of the current

Against ketidaksepahaman There are several definitions of the "relational" from the DBMS.

The most popular definition of a RDBMS is often considered less accurate; forward some circles that the data serving as a collection of columns and rows have been enough to qualify as a RDBMS said. Tipikalnya, said a database system to meet the criteria as RDBMS meet when the laws are set in 12 legal Codd, but in fact had most database systems do not fully support the implementation of the laws of the Codd.

The other thought when a database system is not implementing the overall law Codd, the system can not be called as a relational. Views such as this, that many received by the theoretical circle and other circles, which adhere to the principles Codd, of course, will mendiskualifikasikan many database systems that are currently "not pure relational." In fact, the system databases using SQL (Structured Query Language) to access and modify data can not be said as RDBMS, according to this definition. Meanwhile, the supporters of the system database that is mentioned a database system that implements only some of the laws of Codd is called as Semi-Relasional/Pseudo-Relational Database Management System Database Management Systems (PRDBMS). For database management system that fully implementing the laws Codd is hereinafter referred to as Murni-Relasional/Trully-Relational Database Management System Database Management Systems (TRDBMS).

Currently, almost all RDBMS that apply SQL as a query language but also to provide and implement some other alternative. Alpora Dataphor is RDBMS available in a commercial to follow the full twelve laws Codd, and the second group known as the RDBMS.


Dynamic variation

Complaints that appear and are known in general to the existence RDBMS is the fact that implementation is currently seen as too "static". Spekulasipun appear on the possibility to create a new generation database system that uses a model "relational dynamic" with a column that can be made dynamically, the size of the developing dynamically, is defined dynamically. Each line can be implemented as a map (or dictionary larik asosiatif) and the fields that are not presented as a simple field empty. Some circles consider this the model relasioal pure, but the other protest that the use of a map is only as a detailed implementation. Thus, in this view, a column that is not found / no "in a simple but seen as a subject of interpretation and is considered as a way of serving i