Live briefing
Everything about Dimensional modeling
Data modeling concept
Dimensional modeling is part of the Business Dimensional Lifecycle methodology developed by Ralph Kimball which includes a set of methods, techniques and concepts for use in data warehouse design. The approach focuses on identifying the key business processes within a business and modelling and implementing these first before adding additional business processes, as a bottom-up approach. An alternative approach from Inmon advocates a top down design of the model of all the enterprise data using tools such as entity-relationship modeling (ER). Wikipedia →
🧭 Start here: a 6-step reading path
- Read the overview: Dimensional modelingA 5-minute orientation
- Skim a recent paper: Three-Dimensional Modeling of Heart Soft Tissue MotionInfluential work since 2022
- Pick up a classic book: Henry MooreThe most-reprinted book on the subject
- Read the landmark paper: High-dimensional additive modelingCited 292 times
- Go sideways: Star schemaA closely related topic
- Go sideways: Dimension (data warehouse)A closely related topic
📖 Definitions
No dictionary entry for this exact phrase.
🏆 Landmark papers (most cited)
High-dimensional additive modeling
Modeling of two‐dimensional overland flow
One-dimensional automotive catalyst modeling
Three-dimensional seismic modeling
Multiscale modeling of two-dimensional contacts
Modeling of Conjunctive Two-Dimensional Surface-Three-Dimensional Subsurface Flows
Two‐dimensional modeling of electroremediation
Low dimensional modeling of flow reactors
🆕 Influential since 2022
Three-Dimensional Modeling of Heart Soft Tissue Motion
Three-dimensional modeling of Venus photochemistry and clouds
A unifying modeling abstraction for infinite-dimensional optimization
Three-Dimensional Geological Modeling with Multisource Data Fusion
Three-dimensional hydraulic fracturing modeling based on peridynamics
📚 Books worth reading
Henry MooreDavid Sylvester, Henry Moore · 1934- 📕A three-dimensional linearized unsteady Euler analysis for turbomachinery blade rowsMatthew D. Montgomery · 1996
Geometry and physics of branesU. Bruzzo · 2002- 📕3D Origami ArtJun Mitani · 2016
- 📕Introduction to protein structure predictionHuzefa Rangwala · 2010
- 📕Metody podobii͡a︡ i razmernosti v mekhanikeSedov, L. I. · 1957
GrasshopperDavid Bachman · 2017
Essential skills for 3D modeling, rendering, and animationNicholas Bernhardt Zeman · 2014
Ranked by number of editions on Open Library, a rough measure of how lasting a book is.
🔗 Related topics
- Star schema In computing, the star schema or star model is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and…
- Dimension (data warehouse) A dimension is a structure that categorizes facts and measures in order to enable users to answer business questions. Commonly used dimensions are people…
- Snowflake schema In computing, a snowflake schema or snowflake model is a logical arrangement of tables in a multidimensional database such that the entity relationship…
- Aggregate (data warehouse) An aggregate is a type of summary used in dimensional models of data warehouses to shorten the time it takes to provide answers to typical queries on large…
- Data warehouse In computing, a data warehouse (DW or DWH), also known as an enterprise data warehouse (EDW), is a system used for reporting and data analysis and is a…
- Degenerate dimension According to Ralph Kimball, in a data warehouse, a degenerate dimension is a dimension key (primary key for a dimension table) in the fact table that does…
- Fact table In data warehousing, a fact table consists of the measurements, metrics or facts of a business process. It is located at the center of a star schema or…
- Slowly changing dimension In data management and data warehousing, a slowly changing dimension (SCD) is a dimension that stores data which, while generally stable, may change over…