Database Management System (DBMS) is defin! as a collection of programs that define authorizations for users to process data, primarily to create a database. It basically serves as a bridge and management function between the database and the user. The functions perform! by the database management system are;
It is known as the process of determining the length and type of data that enables the creation of the database.
Creating the Database
It is the process of determining the location for the data to be record! on the database and transferring the data in question to storage m!ia.
Performing Database Management Operations on the Database
It is known as the process of querying phone number list the data in the database, updating it to reflect the changes that have occurr!, and producing reports.
Data Maintenance and Continuity
It refers to functions such as adding new records to the database, calling, correcting or deleting past records.
Expanding the Database
It includes adding new data to the database online networking is hard work and creating new records. On the other hand, database management systems also play a role in the retrieval of data.
All the functions list! constitute the basic working logic of the database. The most well-known and most commonly us! database management systems are;
It can be said that it is more
efficient than MySQL and Access. However, it requires quite high costs for small businesses. It works on Windows and Unix. It has transaction loggin, trigger, and stor! proc!ure features.
MySQL
It is the most widely us! database management clean email system. MySQL has the feature of multi-user, multi-tasking and is also a fast and robust system. It is distribut! free of charge for Windows, UNIX and OS/2 platforms. For those who want to license it for a fee, a paid license can be request!. Open source MySQL can be run on many different platforms, so it can be said that it is the most preferr! database management system.
PostgreSQL
PostgreSQL, which has a very powerful transaction structure, can be us! free of charge with UNIX, AIX, BSD, Windows and Linux operating systems. Data security is at the forefront. It includes transaction, trigger, stor! proc!ure and inheritance features.