jagomart
digital resources
picture1_Business Spread Sheet 42701 | Data Warehousing And Mining


 166x       Filetype PPT       File size 0.51 MB       Source: ridha.staff.gunadarma.ac.id


File: Business Spread Sheet 42701 | Data Warehousing And Mining
some definitions a data warehouse dw is a collection of integrated databases designed to support a dss an operational data store ods stores data for a specific application it feeds ...

icon picture PPT Filetype Power Point PPT | Posted on 16 Aug 2022 | 3 years ago
Partial capture of text on file.
                    Some Definitions …
       •  A data warehouse (DW) is a collection of integrated 
          databases designed to support a DSS
       •  An operational data store (ODS) stores data for a specific 
          application.  It feeds the data warehouse a stream of desired 
          raw data.
       •  A data mart is a lower-cost, scaled-down version of a data 
          warehouse, usually designed to support a small group of 
          users (rather than the entire firm)
       •  The metadata is information that is kept about the warehouse
       •  Online Analytical Processing (OLAP) is the broad category of 
          software technology that enables multidimensional analysis of 
          enterprise data
             Slides adapted by Michael Lang, NUI Galway from Turban et al.  (2005) Decision Support Systems and 
        2
             Intelligent Systems, 7th ed, © Prentice Hall
                    Business Intelligence and 
                                       Analytics
        •   Business intelligence (BI)
             – Acquisition of data and information for use in decision-making 
                activities
        •   Business analytics (BA)
             – Models and solution methods
        •   Web intelligence
             – Application of business intelligence techniques to Web sites
        •   Web analytics
             – Application of business analytics to Web sites
        •   Data mining
             – Applying models and methods to data to identify patterns and 
                trends
                Slides adapted by Michael Lang, NUI Galway from Turban et al.  (2005) Decision Support Systems and 
          3
                Intelligent Systems, 7th ed, © Prentice Hall
                        Data Warehouse
       •  Subject-oriented (as opposed to application-oriented)
           – Data is organised based on its intended use
       •  “Scrubbed” and “cleansed” so that data from heterogeneous 
          sources are standardised
       •  Time series, historical data
       •  Non-volatile (read only)
       •  Summarised: in decision-usable format
       •  Data from both internal and external sources is present
       •  Metadata included
           – Business metadata
           – Semantic metadata
             Slides adapted by Michael Lang, NUI Galway from Turban et al.  (2005) Decision Support Systems and 
        4
             Intelligent Systems, 7th ed, © Prentice Hall
        Data Warehouse: Environment
       • The organisation’s legacy systems and data stores 
         provide data to the data warehouse (DW) or mart
       • During the transfer of data from the various sources, 
         cleansing or transformation may occur, so the data in 
         the DW is more uniform
       • Simultaneously, metadata is recorded
       • Finally, the DW or mart may be used to create one or 
         more “personal” warehouses
            Slides adapted by Michael Lang, NUI Galway from Turban et al.  (2005) Decision Support Systems and 
       5
            Intelligent Systems, 7th ed, © Prentice Hall
        Data Warehouse: Environment
            Slides adapted by Michael Lang, NUI Galway from Turban et al.  (2005) Decision Support Systems and 
       6
            Intelligent Systems, 7th ed, © Prentice Hall
The words contained in this file might help you see if this file matches what you are looking for:

...Some definitions a data warehouse dw is collection of integrated databases designed to support dss an operational store ods stores for specific application it feeds the stream desired raw mart lower cost scaled down version usually small group users rather than entire firm metadata information that kept about online analytical processing olap broad category software technology enables multidimensional analysis enterprise slides adapted by michael lang nui galway from turban et al decision systems and intelligent th ed prentice hall business intelligence analytics bi acquisition use in making activities ba models solution methods web techniques sites mining applying identify patterns trends subject oriented as opposed organised based on its intended scrubbed cleansed so heterogeneous sources are standardised time series historical non volatile read only summarised usable format both internal external present included semantic environment organisation s legacy provide or during transfer ...

no reviews yet
Please Login to review.