8 Hours at the Library: What I Learned About BI and Data Warehouse #2
Hello! I spent 8 hours studying in the library today and learned a lot. I'll write down what I learned as a way to review and practice.
Summary of Knowledge
I've learned about the detailed technical and practical information of Data Warehouses
- ETL process and components of the transformation process,
- Detailed technical background in Operational Data Store(ODS) and Metadata
- Metadata Architectures,
- Physical Storage Concepts (Relational Storage(ROLAP), Multidimensional Storage(MOLAP),Hybrid Storage(HOLAP)),
- OLAP Cubes,
- Historicization and Slowly Changing Dimension(SCD) types,
- Model Basis Analysis Systems
- Concept-oriented Systems
- Knowledge Management
- Content Management Systems(CMS) and Document Managemend Systems(DMS),
- Distribution of Knowledge
- Access to Information(Portal and Portlet)
Comments
Post a Comment