DBMS Concepts

                                        DBMS Concepts

• DBMS allows users to create their own databases as per their requirements. 

• It consists of a group of programs which manipulate the database and provide an interface between the databases. 


• The relational model represents the database as a collection of relations. 


• A data dictionary contains metadata and detail about all the table in the database, such as their owners, their security constraints, when they were created. 


• ODBC makes it possible to access data from any application, regardless of which database management system is handling the data. 


• Developers can store translated strings with the XML Type and retrieve and operate on these strings depending on the languages settings of the user. 


• Databases have been largely secured against hackers through network security measures such as firewalls, and network based intrusion detection systems.


• Access rights are specified by user because there are no administration rights, the access right implies administration of itself. 


• The goal of access control is minimize the risk of unauthorized access to physical and logical systems.

KEYWORDS:

DBMS            -        Database Management System

ODBC            -        Open Database Connectivity

SAML            -        Security Assertion Markup Language

MAC             -         Mandatory Access Control

DAC             -          Discretionary Access Control

RBAC          -           Role Based Access Control