A Data Warehouse Assistant Design System Based on Clover Model

TL;DR

This paper introduces a novel data warehouse design assistant system utilizing the Clover model to guide users in schema selection and leverage past successful designs, simplifying the complex DW design process.

Contribution

It presents a new approach based on the Clover model to assist users in data warehouse design, combining schema guidance and experience reuse.

Findings

The system effectively guides users in schema selection.

It incorporates past successful design experiences.

It simplifies the DW design process for users.

Abstract

Nowadays, Data Warehouse (DW) plays a crucial role in the process of decision making. However, their design remains a very delicate and difficult task either for expert or users. The goal of this paper is to propose a new approach based on the clover model, destined to assist users to design a DW. The proposed approach is based on two main steps. The first one aims to guide users in their choice of DW schema model. The second one aims to finalize the chosen model by offering to the designer views related to former successful DW design experiences.