The Three Categories Of Database Environment

Introduction:

Database environment can be classified into three simple categories:

a. Human: Database Administrator - They are responsible to monitor and maintain the databases in an organization. Systems Developers - They are responsible for the development of the computer applications which will talk to the database in do the necessary operations and display the results to the end users.

b. Machine:

User Interface - This is how the computer application looks and what the end user will use to interact.

Application Programs- This is the core of the computer application. These are the programs which are related to the application, so that user can use the system to get output

They take care of the security and maintain the data backups.

The execution of SQL commands can be done by the SQL developers but the changes should be approved by the DBA , because finally they are the responsible for maintaining the structure and security of the database. Developers should not create the SQL commands as this might lead to conflicts on the data, sometimes they might not be aware of the complete structure of the database.

For instance if a query needs to be written which generates reports, if the application developer writes the query it can be used only in the application but if the a SQL developer writes the query it can be used by the application developer and also independently to generate reports. Because the SQL developer places the queries in the database as a view and that is accessed by the developer and others .

The end users should not execute queries, as they might also not be the aware of the structure except the understanding of functionality.

Basic troubleshooting queries can be executed by the DBA but when there is a bigger issue SQL developers can resolve them as they have better understanding of the low level