Strategic planning for data warehousing. Information
1. Data Warehouse Paper Presentation Teacher:Don-Lin Yang Professor
2. Strategic planning for data warehousing Information & Management 33 (1997)
Ashok Subramanian, L. Douglas Smith, Anthony C. Nelson, James F. Campbell, David A. Bird
3. 2012/8/13 3 Abstract Describe processes and analytical methods for shaping a data warehousing strategy and for determining the contents of the data warehouse
4. 2012/8/13 4 Basic Problems Legacy systems
Client-Server systems, geographic information systems, LAN
5. 2012/8/13 5 Expectation Methodologies would be equally applicable to organization in the private sector.
Methodologies would be especially useful in the wake of corporate restructuring through mergers and acquisitions.
6. 2012/8/13 6 Approach Melds elements from various methodologies as following:
• business systems planning (BSP)
• strategic data planning (SDP)
• strategic information systems planning (SISP)
• information technology planning (ITP)
• critical success factors (CSF)
• frequently asked questions (FAQ)
• strategic business objectives (SBO)
7. 2012/8/13 7 Key elements(1/7) Use of a strategic planning oversight committee for the entire process.
Provision of departmental orientation session to prepare managers and technical staff for their participation.
8. 2012/8/13 8 Key elements(2/7) Compilation of departmental MIS surveys to describe functions, needs for information, interdepartmental of communication, and usage of technology by representatives of each category of employee in the department.
9. 2012/8/13 9 Key elements(3/7) Use of technology surveys to describe current configuration of information technology and to derive suggestions for improvements from operational staff, similar to that from a reengineering effort.
Provision of presentation to educate managers and staff regarding current systems and their capabilities.
10. 2012/8/13 10 Key elements(4/7) Creation of a data-usage matrix to illustrate interdepartmental information usage.
Production of project profiles for current and potential MIS initiatives in each department.
Production of MIS planning profiles for each of 35 major departments.
11. 2012/8/13 11 Key elements(5/7) Consideration of organizational issues for the planning and management of MIS resources.
Feedback to departmental managers to before consolidation of information in the production of the plan.
Study and depiction of the current computing infrastructure.
12. 2012/8/13 12 Key elements(6/7) Evaluation of alternative topologies for the computing infrastructure and recommendation of a preferred alternative.
Study of practices in other cities.
Review of reports from past planning efforts and documentation pertaining to current systems.
13. 2012/8/13 13 Key elements(7/7) Use of the oversight subcommittees in refining draft recommendations.
14. 2012/8/13 14 Departmental surveys(1/2) The mission and function of the departmental and its subdivisions
The types of information used or generated by the department
The associated computing platform or storage medium and the functions supported by the information
15. 2012/8/13 15 Departmental surveys(2/2) The transmission of information to or from other departmental or external entities
The temporal requirements for the various types of information
The list of recommended MIS projects or initiatives
16. 2012/8/13 16 Delivery system H=hard copy
M=main frame computer
P=stand-alone personal computer
O=on-line service from an external
17. 2012/8/13 17 Use of the information C=creating elements of data in the
information category that are added
to a database
U=updating elements of data in the
R=reading information for inquiries,
reports or analysis
18. 2012/8/13 18 Temporal status c=current(up-to-date)
19. 2012/8/13 19
20. 2012/8/13 20
21. 2012/8/13 21 Proposed MIS initiatives With new information generated by users of the data warehouse, and feedback to correct errors at the original source, the flows of information in a data warehousing environment are better represented by a cyclical network than by a tree.
22. 2012/8/13 22 Outcome A change from a mainframe-centric to a network-centric philosophy and the adoption of the data warehousing strategy.
23. 2012/8/13 23 Conclusion The implementation begin with the creation of small warehouse or data marts for prime users with considerable end-user computing experience.
Much of the potential benefit from data warehousing may be realized from using the concept on a selective basis and at a modest scale.