jagomart
digital resources
picture1_Information Ppt 74366 | 5 Datawarehouse Concepts


 136x       Filetype PPTX       File size 1.13 MB       Source: www.oicstatcom.org


File: Information Ppt 74366 | 5 Datawarehouse Concepts
turkish statistical institute outline users problems and necessity for data warehouse bi definition and components data warehousing concepts dw goals and objectives olap and oltp terms data warehouse vs operational ...

icon picture PPTX Filetype Power Point PPTX | Posted on 01 Sep 2022 | 3 years ago
Partial capture of text on file.
  TURKISH STATISTICAL INSTITUTE
                                   OUTLINE
     Users Problems and necessity for Data Warehouse
     BI Definition and Components
     Data Warehousing Concepts 
     DW  Goals and Objectives 
     OLAP and  OLTP terms 
     Data Warehouse vs: Operational DBMS 
     Datamarts methodology 
     Explanation of Star Schema and Snowflake Schema
     DMQL (Data Mining Query Language)
     OLAP Functions
  INFORMATION TECHNOLOGIES DEPARTMENT                                          2
  TURKISH STATISTICAL INSTITUTE
                            INTRODUCTION
       There are 2 types of  users:  Operational users and Decision-Maker users
       Operational users use local data while decision-makers use  historical data 
       Database design is changed if data is used for take decision. 
       Data Warehousing is used for take decisions
       Data Warehouses captures data different operational sources
       Data Warehouses contain historical data
  INFORMATION TECHNOLOGIES DEPARTMENT                                                3
  TURKISH STATISTICAL INSTITUTE
      Operational Data :                                             Operational user
       local data  
      gets frequent updates and queries 
      specific queries are needed
        Historical Data:                                               Decision maker
        “tells” about something
        Very infrequent updates
        Integrated data
        Analytical queries that require huge amounts of aggregation
        Query Performance is crucial
  INFORMATION TECHNOLOGIES DEPARTMENT                                                4
   TURKISH STATISTICAL INSTITUTE
     Example OLTP queries:
     What is the salary of Mr .Johnson  ?    (point query)
     What is address and phone number of  Mr. Johnson ? (point query)
       
     How many employees have received an 'excellent' credential in the last
     appraisal?
     Example OLAP queries:
     Is there a correlation between the geographical location of a company 
     and profit of the company?
     How is the age of the employee effect their performance ?
     Is gender of a staff effect the performance ?
  INFORMATION TECHNOLOGIES DEPARTMENT                                                  5
   TURKISH STATISTICAL INSTITUTE
       Data Problems and necessity for Data Warehouse
        Without DW :
        Data is everywhere and hard to manage
        Same data is exist at different places
        Data inconsistency
        It is hard to deploy  new data
        Data is so complex and detailed
        Data can not be analysed
        There isn’t time series
  INFORMATION TECHNOLOGIES DEPARTMENT                                                   6
The words contained in this file might help you see if this file matches what you are looking for:

...Turkish statistical institute outline users problems and necessity for data warehouse bi definition components warehousing concepts dw goals objectives olap oltp terms vs operational dbms datamarts methodology explanation of star schema snowflake dmql mining query language functions information technologies department introduction there are types decision maker use local while makers historical database design is changed if used take decisions warehouses captures different sources contain user gets frequent updates queries specific needed tells about something very infrequent integrated analytical that require huge amounts aggregation performance crucial example what the salary mr johnson point address phone number how many employees have received an excellent credential in last appraisal a correlation between geographical location company profit age employee effect their gender staff without everywhere hard to manage same exist at places inconsistency it deploy new so complex detailed...

no reviews yet
Please Login to review.