Discovering Functional Dependencies for Multidimensional Design

Provided by: Association for Computing Machinery
Topic: Big Data
Format: PDF
Now-a-days, it is widely accepted that the data warehouse design task should be largely automated. Furthermore, the data warehouse conceptual schema must be structured according to the multidimensional model and as a consequence, the most common way to automatically look for subjects and dimensions of analysis is by discovering functional dependencies (as dimensions functionally depend of the fact) over the data sources. Most advanced methods for automating the design of the data warehouse carry out this process from relational OLTP systems, assuming that a RDBMS is the most common kind of data source the authors may find, and taking as starting point a relational schema.

Find By Topic