1 / 15

DSS/EIS/DW/OLAP

DSS/EIS/DW/OLAP. DSS - Introduction. Concept Phases of decision making : : :.

bill
Download Presentation

DSS/EIS/DW/OLAP

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DSS/EIS/DW/OLAP Postech Strategic Management of Information Systems LAB

  2. DSS - Introduction • Concept • Phases of decision making : : : an interactive, flexible, and adaptable computer-based information system using information and model specially developed for supporting the solution of a semi-structured management problem for improved decision making • Intelligence • Activity Design Activity Choice Activity Review Activity Searching the environment for conditions calling for a solution Inventing, developing, and analyzing possible courses of action Selecting a particular course of action from those available Assessing past choice Postech Strategic Management of Information Systems LAB

  3. DSS framework Management levels Operational Control Management Control Strategic Planning Structured Budget analysis- engineered costs Account receivable Tanker fleet mix Degree of Problem Structure Order Entry Short-term forecasting Warehouse and factory location Inventory Control Semistructured Production Scheduling Variance analysis- overall budget Merge and acquisition New product planning Cash Management Budget preparation R&D planning PERT/COST systems Sales and Production Unstructured Postech Strategic Management of Information Systems LAB

  4. DSS model Environment Individual problem solver Other group members Mathematical models Report writing software Groupware Database Decision support system Environment Data Communication Information Postech Strategic Management of Information Systems LAB

  5. GDSS • Concept • GDSS Environmental settings A computer-based system that supports groups of people engaged in a common task and that provides an interface to a shared environment Group size Smaller Larger Decision room Legislative session Face-to-face Member proximity Local area decision network Computer-mediated conference Dispersed Postech Strategic Management of Information Systems LAB

  6. EIS concept(1/2) • Concept • Capabilities A computerized user-friendly system specially designed to meet the needs of top executives and to eliminate the need for intermediaries Tracking and control Tailoring to the individual executives decision making style status access, namely rapid access to current information extensive use of data from external source Postech Strategic Management of Information Systems LAB

  7. EIS concept(2/2) • CSF for achieving successful EIS • A Committed and Informed Executive sponsor • An Operating Sponsor • An Appropriate Information service staff • An Appropriate Information Technology • Data management • Clear Links to Business Objectives • Management of Organizational Resistance • Management of the Spread and Evolution of the system Postech Strategic Management of Information Systems LAB

  8. EIS development framework • Development methodology(CSF) • Standard(naming convention) • External & Internal Pressure • Spread • EIS capabilities • Development skills • Cost/time EIS DEVELOPMENT EIS product Executive Requirement • Software(EIS generator, DBMS) • Hardware • Personnel • Internal & External Data • MIS environment(system config.) Postech Strategic Management of Information Systems LAB

  9. EIS development process DELIVERABLE STAGE Needs for EIS development I. Preliminary Study General Info. for EIS II. Application Study Design info. For Prototype III. Prototype Construction Prototype IV. System Design Implementation Plan V. Final System Construction VI. Testing Full-systems VII. Installation Improved systems VIII. Extension Plan for extension Postech Strategic Management of Information Systems LAB

  10. Definition - DW • A data warehouse is a collection of data in support of management’s decisions. Integrated Non-volatile Time variant operational data warehouse change insert access delete delete load insert change access Postech Strategic Management of Information Systems LAB

  11. Data warehouse architecture Postech Strategic Management of Information Systems LAB

  12. Technical architecture for a data warehousing system external data Data Manager Component Data Delivery Component source data Data Acquisition Component Middleware Component Data Access Component warehouse data Information Directory Component Design Component warehouse metadata external metadata Management Component Postech Strategic Management of Information Systems LAB

  13. Definition of OLAP • Fast Analysis of Shared Multidimensional Information (FASMI) - This definition was first used in early 1995, and has not needed revision since. • FAST • ANALYSIS • SHARED • MULTIDIMENSIONAL • INFORMATION Postech Strategic Management of Information Systems LAB

  14. OLAP architecture Postech Strategic Management of Information Systems LAB

  15. OLTP vs. OLAP Postech Strategic Management of Information Systems LAB

More Related