Chapter 4 - Chapter 4. The CIO The Chief Information...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 4. The CIO The Chief Information Officer (CIO) is responsible for the effective deployment of information technology resources and staff to meet the strategic, decisional, and operational information requirements of the enterprise. Data warehousing, with its accompanying array of new technologies and its dependence on operational systems, naturally makes strong demands on the technical and human resources under the jurisdiction of the CIO. For this reason, it is natural for the CIO to be strongly involved in any data warehousing effort. This chapter attempts to answer the typical questions of CIOs who participate in data warehousing initiatives. How Do I Support the Data Warehouse? After the data warehouse goes into production, different support services are required to ensure that the implementation is not derailed. These support services fall into the categories described below. Regular Warehouse Load The data warehouse needs to be constantly loaded with additional data. The amount of work required to load data into the warehouse on a regular basis depends on the extent to which the extraction, transformation, and loading processes have been automated, as well as the load frequency required by the warehouse. The frequency of the load depends on the user requirements, as determined during the data warehouse design activity. The most frequent load possible with a data warehouse is once a day, although it is not unusual to find organizations that load their warehouses once a week, or even once a month. The regular loading activities fall under the responsibilities of the warehouse support team, who almost invariably report to directly or indirectly to the CIO. Applications After the data warehouse and related data marts have been deployed, the IT department or division may turn its attention to the development and deployment of Executive Systems or custom applications that run directly against the data warehouse or the data marts. These applications are developed or targeted to meet the needs of specific user groups. Any in-house application development will likely be handled by internal IT staff; otherwise, such projects should be outsourced under the watchful eye of the CIO. Warehouse DB Optimization Apart from the day-to-day database administration support of production systems, the warehouse DBA must also collect and monitor new sets of query statistics with each rollout or phase of the data warehouse.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
The data structure of the warehouse is then refined or optimized on the basis of these usage statistics, particularly in the area of stored aggregates and table indexing strategies. User Assistance or Help Desk As with any information system in the enterprise, a User Assistance Desk or Help Desk can provide users with general information, assistance, and support. An analysis of the help requests received by the Help Desk provides insight on possible subjects for follow-on training with end users. In addition, the Help Desk is an ideal site for publicizing the status of the system after every
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/09/2012 for the course COMPUTER S a303 taught by Professor None during the Spring '11 term at BEM Bordeaux Management School.

Page1 / 22

Chapter 4 - Chapter 4. The CIO The Chief Information...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online