DATABASE AND DBMS
Database Management System (DBMS) contains a collection of interrelated data and a set of programs to access that data. Database and DBMS consists of Set Program manager for add data, delete data, retrieve, and read the data.
The database is a collection of files that relate to each other, the relationship is shown by the usual key of each existing file. The database shows one set of data / tables used in the scope of the enterprise, institution. It means that the database is a collection of data related to an object, a particular topic or purpose. For example the phone book, dictionary, books in the library catalog, the data collection of music and videos, customer data, supplier data, student data, employee data, and others.
In the data file / table records are similar, equal, same shape, is a collection of uniform entity. The record consists of fields that are interconnected to show that the field in one sense a complete and recorded in one record.
To refer to the contents of a field then use the title attribute or an entity of a particular group, such as Address attribute indicates the address of the student entity. Entity is an object which is real and will be recorded.
Set management program is a package of programs designed to facilitate and streamline the income or information recording and retrieval or reading the information into a database, called the DBMS package. There are several kinds of packages DBMS, such as MySQL, postgresql, FoxPro, Oracle, DB2, etc..
MySQL
MySQL is one example of software / package is extremely popular DBMS. MySQL popularity is possible because of the ease of use, the faster query performance, and insufficient for the needs of enterprise database-small-medium scale enterprises.
MySQL is the DBMS that is client-server and multi-user. The point is that there is software which runs as a MySQL client, and those that run as a server. Server serves to provide service upon a request made by the Client. There are a lot of users who can simultaneously access the database server through the client program.
Therefore, before we do the processing to the database, then we have to run the program first MySQL Database Server that provides services such as data. After that we can only make requests to the server in the form of data services through the client program. Services provided can include income or information recording and retrieval or reading information to / from the database.
Connection to the MySQL server through the MySQL client
As already mentioned that MySQL is a multi-user program. Therefore, when we will make a connection, then we should have the right of access to existing data in the database server and each user can have different passwords. This is one of the security facilities usually provided by the DBMS software is multi-user. In addition, clients can connect from any computer connected on the network and have permissions to connect from another computer specified. To make a connection, use a client program called mysql. In use, MySQL has several parameters. Parameters are often used to connect is username and password and host name (if connection via another computer). Writing parameter can be reversed and forth between the parameters, not between its value.
for more details please download this module:
click here to download Database moduls
Also Read :
How Install BBM (BlackBerry Messenger) in Android
Database Management System (DBMS) contains a collection of interrelated data and a set of programs to access that data. Database and DBMS consists of Set Program manager for add data, delete data, retrieve, and read the data.
The database is a collection of files that relate to each other, the relationship is shown by the usual key of each existing file. The database shows one set of data / tables used in the scope of the enterprise, institution. It means that the database is a collection of data related to an object, a particular topic or purpose. For example the phone book, dictionary, books in the library catalog, the data collection of music and videos, customer data, supplier data, student data, employee data, and others.
In the data file / table records are similar, equal, same shape, is a collection of uniform entity. The record consists of fields that are interconnected to show that the field in one sense a complete and recorded in one record.
To refer to the contents of a field then use the title attribute or an entity of a particular group, such as Address attribute indicates the address of the student entity. Entity is an object which is real and will be recorded.
Set management program is a package of programs designed to facilitate and streamline the income or information recording and retrieval or reading the information into a database, called the DBMS package. There are several kinds of packages DBMS, such as MySQL, postgresql, FoxPro, Oracle, DB2, etc..
MySQL
MySQL is one example of software / package is extremely popular DBMS. MySQL popularity is possible because of the ease of use, the faster query performance, and insufficient for the needs of enterprise database-small-medium scale enterprises.
MySQL is the DBMS that is client-server and multi-user. The point is that there is software which runs as a MySQL client, and those that run as a server. Server serves to provide service upon a request made by the Client. There are a lot of users who can simultaneously access the database server through the client program.
Therefore, before we do the processing to the database, then we have to run the program first MySQL Database Server that provides services such as data. After that we can only make requests to the server in the form of data services through the client program. Services provided can include income or information recording and retrieval or reading information to / from the database.
Connection to the MySQL server through the MySQL client
As already mentioned that MySQL is a multi-user program. Therefore, when we will make a connection, then we should have the right of access to existing data in the database server and each user can have different passwords. This is one of the security facilities usually provided by the DBMS software is multi-user. In addition, clients can connect from any computer connected on the network and have permissions to connect from another computer specified. To make a connection, use a client program called mysql. In use, MySQL has several parameters. Parameters are often used to connect is username and password and host name (if connection via another computer). Writing parameter can be reversed and forth between the parameters, not between its value.
for more details please download this module:
click here to download Database moduls
Also Read :
How Install BBM (BlackBerry Messenger) in Android
