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 ... |