Discover published sets by community

A dimension table contains dimensions of a fact. They are used in a data warehouse to describe objects in a fact table and are generally normalized.

A type of database schema that is the simplest style of data mart schema and is organized into fact and dimension tables with a central fact table surrounded by dimension tables.

A metadata repository is where metadata is stored in a data warehouse. It defines the warehouse objects such as source, transformations, schema, space allocation, and database objects.

Dimensional modeling is a data modeling technique in data warehouse design, intended to support end-user queries in a data warehouse. It uses fact tables and dimension tables.

A data structure used to represent data along some measure of interest. It is used in OLAP databases to visualize and analyze data across multiple dimensions.

A fact table is a primary table in a dimensional model. A fact table stores quantitative information for analysis and is often denormalized.

In the context of data warehousing, aggregates are pre-calculated summary or total values that are stored in the data warehouse to enhance query performance.

OLAP is a category of software that allows users to analyze information from multiple database systems at the same time.

Data mining is the process of discovering patterns in large data sets involving methods at the intersection of machine learning, statistics, and database systems.

A data warehousing is a system used for reporting and data analysis, and is considered a core component of business intelligence.

Data warehouse architecture refers to the design of the database system that allows for the consolidation and integration of data from various sources, typically comprising of tiers such as data source layer, data staging layer, and presentation layer.

An extension of the star schema where the dimension tables are normalized, hence more complex, resulting in a structure that resembles a snowflake shape.

A data mart is a subset of a data warehouse that is often oriented to a specific business line or team.

ETL refers to a process in database usage and especially in data warehousing that involves extracting data from outside sources, transforming it to fit operational needs, and loading it into the end target.