understand the basic definitions and concepts of data warehouses describe data warehouse...
TRANSCRIPT
![Page 1: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/1.jpg)
![Page 2: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/2.jpg)
Understand the basic definitions and concepts of data warehouses
Describe data warehouse architectures (high level).
Describe the processes used in developing and managing data warehouses
Explain data warehousing operations Explain the role of data warehouses in
decision support
![Page 3: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/3.jpg)
Explain data integration and the extraction, transformation, and load (ETL) processes
Describe real-time (active) data warehousing
Understand data warehouse administration and security issues
![Page 4: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/4.jpg)
Data warehousing is a Subject oriented, integrated, time variant and non-volatile collection of data in support of management’s decision making process.
![Page 5: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/5.jpg)
Subject Oriented: Data that gives information about a particular subject instead of about a company's ongoing operations.
Integrated: Data that is gathered into the data warehouse from a variety of sources and merged into a coherent whole.
Time-variant: All data in the data warehouse is identified with a particular time period.
Non-volatile: Data is stable in a data warehouse. More data is added but data is never removed.
![Page 6: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/6.jpg)
Characteristics of data warehousing
Subject oriented Integrated Time variant (time series) Nonvolatile Web based Relational/multidimensional Client/server Real-time Include metadata
![Page 7: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/7.jpg)
Data mart A departmental data warehouse that stores only relevant data
Dependent data mart A subset that is created directly from a data warehouse
Independent data martA small data warehouse designed for a strategic business unit or a department
![Page 8: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/8.jpg)
Operational data stores (ODS)A type of database often used as an interim (Used for a particular period of time) area for a data warehouse, especially for customer information files
Enterprise data warehouse (EDW)A technology that provides a vehicle for pushing data from source systems into a data warehouse
Metadata Data about data. In a data warehouse, metadata describe the contents of a data warehouse and the manner of its use
![Page 9: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/9.jpg)
Organizations continuously collect data, information, and knowledge at an increasingly accelerated rate and store them in computerized systems
The number of users needing to access the information continues to increase as a result of improved reliability and availability of network access, especially the Internet
![Page 10: Understand the basic definitions and concepts of data warehouses Describe data warehouse architectures (high level). Describe the processes used](https://reader030.vdocuments.us/reader030/viewer/2022032722/56649f435503460f94c635e7/html5/thumbnails/10.jpg)
Thank you