Data modeling Definitions

  • C

    conformed dimension

    In data warehousing, a conformed dimension is a dimension that has the same meaning to every fact with which it relates.

  • D

    data engineer

    A data engineer is a worker whose primary job responsibilities involve preparing data for analytical or operational uses.

  • data modeling

    A data model can be thought of as a diagram or flowchart that illustrates the relationships between data. Although capturing all the possible relationships in a data model can be very time-intensive, it's an important step that shouldn't be rushed.

  • dimension

    In data warehousing, a dimension is a collection of reference information about a measurable event (fact).

  • P

    predictive modeling

    Predictive modeling is a process that uses data mining and probability to forecast outcomes. Each model is made up of a number of predictors, which are variables that are likely to influence future results.

  • S

    snowflaking (snowflake schema)

    In data warehousing, snowflaking is a form of dimensional modeling where dimensions are stored in multiple related dimension tables. 

  • star schema

    In data warehousing, a star schema is the simplest form of dimensional model, with data organized into facts and dimensions. 

-ADS BY GOOGLE

SearchBusinessAnalytics

SearchAWS

SearchContentManagement

SearchOracle

SearchSAP

SearchSQLServer

Close