Functions of DBMS
Functions of DBMS
• DBMS free the programmers from the need to worry about the organization and location of the data i.e. it shields the users from complex hardware level details.
• DBMS can organize process and present data elements from the database. This capability enables decision makers to search and query database contents in order to extract answers that are not available in regular Reports.
• Programming is speeded up because programmer can concentrate on logic of the application.
• It includes special user friendly query languages which are easy to understand by non pro¬gramming users of the system.
The various common examples of DBMS are Oracle, Access, SQL Server, Sybase, FoxPro, Dbase etc.
The service provided by the DBMS includes:
• Authorization services like log on to the DBMS, start the database, stop the Database etc.
• Transaction supports like Recovery, Rollback etc,
• Import and Export of Data.
• Maintaining data dictionary
• User's Monitoring
• DBMS free the programmers from the need to worry about the organization and location of the data i.e. it shields the users from complex hardware level details.
• DBMS can organize process and present data elements from the database. This capability enables decision makers to search and query database contents in order to extract answers that are not available in regular Reports.
• Programming is speeded up because programmer can concentrate on logic of the application.
• It includes special user friendly query languages which are easy to understand by non pro¬gramming users of the system.
The various common examples of DBMS are Oracle, Access, SQL Server, Sybase, FoxPro, Dbase etc.
The service provided by the DBMS includes:
• Authorization services like log on to the DBMS, start the database, stop the Database etc.
• Transaction supports like Recovery, Rollback etc,
• Import and Export of Data.
• Maintaining data dictionary
• User's Monitoring
Leave a Comment