Data warehouse systems

A Vaisman, E Zimányi - Data-Centric Systems and Applications, 2014 - Springer
Since the late 1970s, relational database technology has been adopted by most
organizations to store their essential data. However, nowadays, the needs of these …

Comprehensive survey on data warehousing research

P Chandra, MK Gupta - International Journal of Information Technology, 2018 - Springer
Data, information and knowledge have important role in various human activities because
by processing data, information is extracted and by analyzing data and information the …

Data-Centric Systems and Applications

MJ Carey, S Ceri, P Bernstein, U Dayal, C Faloutsos… - 2008 - Springer
Data warehouses are databases of a specific kind that periodically collect information about
the activities being performed by an organization. This information is then accumulated over …

A UML based approach for modeling ETL processes in data warehouses

J Trujillo, S Luján-Mora - International Conference on Conceptual …, 2003 - Springer
Data warehouses (DWs) are complex computer systems whose main goal is to facilitate the
decision making process of knowledge workers. ETL (Extraction-Transformation-Loading) …

A UML profile for multidimensional modeling in data warehouses

S Luján-Mora, J Trujillo, IY Song - Data & knowledge engineering, 2006 - Elsevier
The multidimensional (MD) modeling, which is the foundation of data warehouses (DWs),
MD databases, and On-Line Analytical Processing (OLAP) applications, is based on several …

Metrics for data warehouse conceptual models understandability

M Serrano, J Trujillo, C Calero, M Piattini - Information and Software …, 2007 - Elsevier
Due to the principal role of Data warehouses (DW) in making strategy decisions, data
warehouse quality is crucial for organizations. Therefore, we should use methods, models …

[PDF][PDF] Designing data warehouses: from business requirement analysis to multidimensional modeling

JN Mazón, J Trujillo, M Serrano, M Piattini - Rebnita, 2005 - academia.edu
Most of the data warehouse projects still fail because the final data warehouse does not
properly meet business goals. Designers start a data warehouse project with the conceptual …

Access control and audit model for the multidimensional modeling of data warehouses

E Fernández-Medina, J Trujillo, R Villarroel… - Decision Support …, 2006 - Elsevier
Due to the sensitive data contained in Data Warehouses (DW), it is essential to specify
security measures from the early stages of the DW design and enforce them. Traditional …

Developing secure data warehouses with a UML extension

E Fernández-Medina, J Trujillo, R Villarroel… - Information Systems, 2007 - Elsevier
Data Warehouses (DWs), Multidimensional (MD) Databases, and On-Line Analytical
Processing Applications are used as a very powerful mechanism for discovering crucial …

Extending the UML for multidimensional modeling

S Luján-Mora, J Trujillo, IY Song - International Conference on the Unified …, 2002 - Springer
Multidimensional (MD) modeling is the foundation of data warehouses, MD databases, and
On-Line Analytical Processing (OLAP) applications. In the past few years, there have been …