|
|
| |
 |
|
Data Warehouse Team
Oracle Tips by Burleson Consulting
|
The Data Warehouse Development Life Cycle
The Data Warehouse Team
While the size of a data warehouse team may vary
from a handful of participants to more than 100 full-time
developers, all data warehouse teams should consist of a project
sponsor, project manager, warehouse architect, systems
administrator, legacy database experts, data warehouse Remote DBA,
operations manager, metadata specialist, end-user interface
specialist, network administrator, Oracle developers, and a
statistician. The roles for each participant are as follows:
* Project Sponsor--The project sponsor for a data warehouse
should be a senior vice president who truly believes in the
necessity of the data warehouse and is zealous in her conviction
about developing a first-rate data warehouse.
The relationship between the project sponsor and the project manager
is defined such that the sponsor exists solely for the purpose of
facilitating communications among the end-user management and the
data warehouse management. Because the project sponsor is a
figurehead--in the sense that she is not directly involved in the
data warehouse project as a full-time occupation--it is desirable to
find a project sponsor from the highest ranks of management because
end-user managers are often highly-placed within most organizations.
Ideally, the project sponsor is at the vice president level or Chief
Information Officer (CIO), the top person in an information systems
organization. This ensures that the project sponsor is able to
facilitate the needs of the data warehouse project from the highest
levels of the organization. The right placement of the project
sponsor can also be invaluable when a project is delayed, and the
sponsor can remind end-user management about the value of the data
warehouse and obtain any additional staffing or capital required to
overcome the hurdle. participants. Consequently, a data warehouse
project manager must be well-versed in quantitative project
management techniques, such as PERT and CPM. Project managers must
always be up-to-date on warehouse development activities, and they
should be able to efficiently allocate resources to ensure a timely
and cost-effective project completion.
* Warehouse Architect--A warehouse architect is usually a
senior Oracle database administrator who has an extensive background
in data modeling and data design. For organizations that are new to
data warehousing, an outside consultant is often used to train an
in-house architect in the nuances of data warehouse design. The
ideal of massive de-normalization and data redundancy may sometimes
seem abhorrent to data architects for OLTP systems, and it can be a
wise investment to augment the architect with an outsider who has a
proven record in effective Oracle data warehouse design.
* Systems Administrator--A systems administrator is in charge
of low-level operating system software. The systems administrator
should understand the technical ramifications of the data warehouse
hardware, including parallel processing, RAID, and system access
security. Many of these technologies will be foreign to systems
administrators, and it is usually a good idea to hire data warehouse
consultants to review the hardware operations and computer
configurations.
 |
Expert Remote DBA
BC is America's oldest and largest Remote DBA Oracle support
provider. Get real Remote DBA experts, call
BC Remote DBA today. |
 |
|
|
|
|
