Database Administrator (DBA)
The Database Administrator is a person responsible for
maintenance of databases
Data Warehouse Administrator
It is a
stand-alone repository of information, integrated from several, possibly heterogeneous
It is a process,
not a product.
Data warehouse administrator roles:
New role, coming
with the growth in data warehouses
Similar to DBA/DA
level agreements regarding data warehouses and data marts
Involved in KPI (Key,
Ø The KPI has
Comparison between DBA && DWA
accommodate ad hoc queries. You may not know the workload of your data
warehouse in advance, so it should be optimized to perform well for a wide variety
of possible queries.
predefined operations. Your applications might be specifically tuned or
designed to support only these operations.
Updated on a regular
basis by the ETL process using bulk data modification techniques. End users
of a data warehouse do not directly update the database.
Subject to individual
DML statements routinely issued by end users. The OLTP database is always up
to date and reflects the current state of each business transaction.
Uses de-normalized or
partially de-normalized schemas (such as a star schema) to optimize query
Uses fully normalized
schemas to optimize DML performance and to guarantee data consistency.
A typical query scans
thousands or millions of rows. For example, a user may request the total
sales for all customers last month.
A typical operation
accesses only a handful of records. For example, a user may retrieve the
current order for a single customer.
Stores many months or
years of data to support historical analysis.
Stores data from only
a few weeks or months. Historical data retained as needed to meet the
requirements of the current transaction.