Data Warehouse Paper Presentation

Data Warehouse Paper Presentation PowerPoint PPT Presentation

  • Uploaded on
  • Presentation posted in: General

Strategic planning for data warehousing. Information

Download Presentation

Data Warehouse Paper Presentation

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript

1. Data Warehouse Paper Presentation Teacher:Don-Lin Yang Professor Student:Chi-Hsiang Chen

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 Mainframe system Mid-frame systems Client-Server systems, geographic information systems, LAN Data resource

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 m=mid-frame computer S=local sever P=stand-alone personal computer O=on-line service from an external source

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 information category R=reading information for inquiries, reports or analysis

18. 2012/8/13 18 Temporal status c=current(up-to-date) f=frozen

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.

  • Login