Introduction

An application in a data warehouse domain represents a business process, a tool, or in some cases a business vertical. Database admins are broadly divided into two classes:

• System admins: Who manages the system in a broader perspective
• Application admins: Who manages one or more application or tool on the system

System admins are responsible for overall system health; application admins are more focused on application performance and health. Let's look at the various jobs performed by each kind of admin:

System Admin	Application Admin
Responsible for overall health of the system	Only for application
Defines overall system policies	Defines policies based on application as per system policies
Does not maintain service level agreement	Maintains application-based service level agreement
Responsible for system-wide audit and security	Maintains application audit and security defined by system admin
Takes care of overall growth of system	Only for an application they are responsible for

 

The application...