DW - Data Warehousing & Modeling

Role-based security

A role-based security is a user-level security feature that allows you to restrict access to a certain feature in the system based on the user role.

In a reporting system, a role-based security layer will enable you to assign roles for each user by allowing or restricting them from performing certain tasks.


Ranking is the process of positioning items such as individuals, groups or items on an ordinal scale in relation to others.

A ranking can be obtained by evaluating each item in the collection in such a way that any two items can then be compared to see which should come higher in the ranking. Obviously, two different objects can have the same ranking.


The state of a database when all repeated values within the database have been removed by creating more tables. Relational OLTP systems are usually highly normalized. Data warehouses typically are not highly normalized.

Normalizing data is a process defined by E.F. Codd and boils down to structuring the data into separate and multiple tables to avoid redundancy in the data.

Information discovery

Information discovery denotes the middle section of enterprise Performance Management and Data Services. It allows decision-makers to access, navigate, analyze, format and share information within the organization. It primarily comprises the Business Intelligence platform, the components of query and analysis, as well as reporting and dashboarding functionalities.

Dimensional hierarchy

A dimensional hierarchy denotes how data is organized at various levels of aggregation. An analyst uses a dimensional hierarchy to identify various trends at one level, drill down to lower levels to detect causes for these trends, and roll up to higher levels to see the effects the trends have on the whole business.


This is the process of converting normalized tables again into a de-normalized form. Here, a table may contain redundant information. This is a common technique within data warehousing where star schemas are used to optimize performance. Denormalizing a database consumes more space and slows OLTP performance but improves query performance in a BI environment.

Data Quality

Data quality pertains to aspects such as availability, completeness, accuracy, consistency, relevance and timeliness of data. High data quality is essential to business intelligence’s role as a means of decisional support.

Poor data quality examples: missing fields, old or inaccurate information, data conflicts, inaccessible data in legacy systems.

Data Mapping

Data mapping is a process of defining a link between two distinct data models. It is used in software engineering to describe ideal ways to represent and access any form of information. It is used in data warehousing by linking source data models to target data models and additional for describing any transformations between these two models.

Change data capture (CDC)

Change data capture (CDC) is the process of capturing changes made at the data source and applying them throughout the enterprise. CDC minimizes the resources required for ETL (extract, transform, load) processes because it only deals with data changes. The goal of CDC is to ensure data synchronicity.


Scheduling takes into account different tasks, the time, and the resources to be deployed in order to complete these tasks.

It is the ability to determine when a particular process will take place in the future, with special consideration on resource availability, activities, and time constraints.


S'abonner à RSS - DW - Data Warehousing & Modeling