Progressive Methods in Data Warehousing and Business Intelligence: Concepts and Competitive Analytics

Progressive Methods in Data Warehousing and Business Intelligence: Concepts and Competitive Analytics

David Taniar (Monash University, Australia)
Indexed In: SCOPUS View 1 More Indices
Release Date: February, 2009|Copyright: © 2009 |Pages: 390
ISBN13: 9781605662329|ISBN10: 1605662321|EISBN13: 9781605662336|DOI: 10.4018/978-1-60566-232-9

Description

Recent technological advancements in data warehousing have been contributing to the emergence of business intelligence useful for managerial decision making.

Progressive Methods in Data Warehousing and Business Intelligence: Concepts and Competitive Analytics presents the latest trends, studies, and developments in business intelligence and data warehousing contributed by experts from around the globe. Consisting of four main sections, this book covers crucial topics within the field such as OLAP and patterns, spatio-temporal data warehousing, and benchmarking of the subject.

Topics Covered

The many academic areas covered in this publication include, but are not limited to:

  • Business Intelligence
  • Data consistency maintenance in data warehouse systems
  • Data warehouse benchmarking
  • Data warehouse conceptual models
  • Distributed approach to continuous queries
  • Integrated business and production process data warehousing
  • Interactive quality-oriented data warehouse development
  • Multi-node OLAP systems
  • Spatial telemetric data warehouse
  • Spatio-temporal data warehousing
  • Spatio-temporal multigranularity
  • XML document contents with OLAP dimensions

Reviews and Testimonials

This publication covers important foundations to researches and applications in data warehousing, covering modeling, OLAP and patterns, as well as new directions in benchmarking and evaluating data warehousing. Issues and applications, particularly in spatio-temporal, show a full spectrum of the coverage of important and emerging topics in data warehousing.

– David Taniar, Monash University, Australia

Consisting of 16 chapters in four sections, this third volume in the series focuses on research and applications in data warehousing, covering conceptual modeling and development, OLAP and patterns, spatio-temporal data warehousing, and new directions in benchmarking and evaluating data warehousing.

– Book News (May 2009)

Table of Contents and List of Contributors

Search this Book:
Reset

Preface

This is the third volume of the Advances in Data Warehousing and Mining (ADWM) book series. ADWM publishes books in the areas of data warehousing and mining. The topic of this volume is data warehousing and OLAP. This volume consists of sixteen chapters in four parts, contributed by researchers in data warehousing.

Part I on “CONCEPTUAL MODEL AND DEVELOPMENT” consists of five chapters covering various conceptual modeling, data cleaning, production process and development.

Chapter 1, “Development of Data Warehouse Conceptual Models - Method Engineering Approach” by Laila Niedrite, Maris Treimanis, Darja Solodovnikova, and Liga Grundmane, from University of Latvia, discusses the usage of method engineering approach for the development of conceptual models of data warehouses. They describe three methods, including (i) user-driven, (ii) data-driven, and (iii) goal-driven methods.

Chapter 2, “Conceptual Modeling Solutions for the Data Warehouse” by Stefano Rizzi (University of Bologna) is a reprint from Data Warehouses and OLAP: Concepts, Architectures and Solutions, edited by R. Wrembel and C. Koncilia (2007), in which the copyright is held by the publisher: IGI Global. The paper thoroughly discusses dimensional fact modeling. Several approaches to conceptual design, such as data-driven, requirement-driven, and mixed approaches, are described.

Chapter 3, “A Machine Learning Approach to Data Cleaning in Databases and Data Warehouses” by Hamid Haidarian Shahri (University of Maryland) is also a reprint. It is initially published in Handbook of Research on Fuzzy Information Processing in Databases, edited by J. Galindo (2008), in which the copyright is also held by the IGI Global publisher. This chapter introduces entity resolution (or duplicate elimination) in data cleaning process. It also exploit neuto-fuzzy modeling in the context of entity resolution.

Chapter 4, “Interactive Quality-Oriented Data Warehouse Development” by Maurizio Pighin and Lucio Ieronutti, both from University of Udine (Italy) proposes quantitative phase and qualitative phase in data warehousing design and evaluation. They also present a tool that they have developed, called ELDA (EvaLuation DAta warehouse quality) to support data warehouse design and evaluation.

Chapter 5, “Integrated Business and Production Process Data Warehousing” by Dirk Draheim (Software Competence Center Hagenberg, Linz, Austria) and Oscar Mangisengi (BWIN Interactive Entertainment and SMS Data System, Austria) is a chapter contributed by practitioners in industry. They focus on production process data based on business activity monitoring requirements.

Part II on “OLAP AND PATTERN” consists of four chapters covering multi-node OLAP systems, multi-dimensional patterns, and XML OLAP.

Chapter 6, “Selecting and Allocating Cubes in Multi-Node OLAP Systems: An Evolutionary Approach” by Jorge Loureiro (Instituto Politécnico de Viseu, Portugal) and Orlando Belo (Universidade do Minho, Portugal), focuses on multi-node distributed OLAP systems. They propose three algorithms: M-OLAP Greedy, M-OLAP Genetic, and M-OLAP Co-Evol-GA; the last two are based on genetic algorithm and evolutionary approach.

Chapter 7, “Swarm Quant’ Intelligence for Optimizing Multi-Node OLAP Systems”, also by Jorge Loureiro and Orlando Belo, also discusses multi-node OLAP systems. But in this chapter, they propose distributed cube selection algorithms based on discrete particle swarm optimizers to solve the distributed OLAP selection problem. They propose M-OLAP Discrete Particle Swarm Optimization (M-OLAP Di-PSO), M-OLAP Discrete Cooperative Particle Swarm Optimization (M-OLAP Di-CPSO), and M-OLAP Discrete Multi-Phase Particle Swarm Optimization (M-OLAP Di-MPSO)

Chapter 8, “Multidimensional Analysis of XML Document Contents with OLAP Dimensions” by Franck Ravat (Université Toulouse 1), and Olivier Teste, Ronan Tournier (from both Université Toulouse 3), focuses on XML documents, where they present a framework for multidimensional OLAP analysis of textual data. They describe this using the conceptual and logical model.

Chapter 9, “A Multidimensional Pattern based Approach for the Design of Data Marts” by Hanene Ben-Abdallah, Jamel Feki, and Mounira Ben Abdallah, from University of Sfax, Tunisia, concentrates on multi-dimensional patterns. In particular they, describe multi-dimensional pattern from the logical and physical levels.

Part III on “SPATIO-TEMPORAL DATA WAREHOUSING” consists of five chapters covering various issues of spatial and spatio-temporal data warehousing.

Chapter 10, “A Multidimensional Methodology with Support for Spatio-Temporal Multigranularity in the Conceptual and Logical Phases” by Concepción M. Gascueña (Polytechnic of Madrid) and Rafael Guadalupe (Politécnica de Madrid University) presents a methodology to design multi-dimensional database to support spatio-temporal granularities. This includes conceptual and logical phases which allow multiple representations of the same spatial data interacting with other spatial and thematic data.

Chapter 11, “Methodology for improving Data Warehouse design using data sources temporal metadata” by Francisco Araque, Alberto Salguero, and Cecilia Delgado, all from University of Granada, focuses on temporal data. They also discuss properties of temporal integration and data integration process.

Chapter 12, “Using Active Rules to Maintain Data Consistency in Data Warehouse Systems” by Shi-Ming Huang (National Chung Cheng University, Taiwan), John Tait, (Sunderland University, UK), Chun-Hao Su (National Chung Cheng University, Taiwan), and Chih-Fong Tsai (National Chung Cheng University, Taiwan), focuses on data consistency, particularly from the temporal data aspects.

Chapter 13, “Distributed Approach to Continuous Queries with kNN Join Processing in Spatial Telemetric Data Warehouse” by Marcin Gorawski and Wojciech Gebczyk, from Silesian Technical University, Poland, concentrates on continuous kNN join query processing, the context of spatial telemetric data warehouse, which is relevant to geospatial and mobile information systems. They also discuss spatial location and telemetric data warehouse and distributed systems.

Chapter 14, “Spatial Data Warehouse Modelling” by Maria Luisa Damiani (Università di Milano) and Stefano Spaccapietra (Ecole Polytechnique Fédérale de Lausanne) is a reprint from Processing and Managing Complex Data for Decision Support, edited by Jérôme Darmont and Omar Boussaid (2006), in which the copyright is held by the IGI publisher. The chapter presents multi-dimensional data models for spatial data warehouses. This includes a model for multi-granular spatial data warehouse and spatial OLAP.

The final part of this volume, Part IV on “BENCHMARKING AND EVALUATION”, consists of two chapters, one on benchmarking data warehouses and the other on evaluation of slowly changing dimensions.

Chapter 15, “Data Warehouse Benchmarking with DWEB” by Jérôme Darmont (University of Lyon), focuses on the performance evaluation of data warehouses, in which it presents a data warehouse engineering benchmark, called DWEB. The benchmark also generates synthetic data and workloads.

Finally, Chapter 16, “Analyses and Evaluation of Responses to Slowly Changing Dimensions in Data Warehouses” by Lars Frank and Christian Frank, from the Copenhagen Business School, focuses on dynamic data warehouses, where the dimensions are changing slowly. They particularly discuss different types of dynamicity, and responses to slowly changing dimensions.

Overall, this volume covers important foundations to researches and applications in data warehousing, covering modeling, OLAP and patterns, as well as new directions in benchmarking and evaluating data warehousing. Issues and applications, particularly in spatio-temporal, show a full spectrum of the coverage of important and emerging topics in data warehousing.

Author(s)/Editor(s) Biography

David Taniar received his PhD in Databases from Victoria University (Australia, 1997) and is now a Senior Lecturer at Monash University (Australia). He has published more than 100 research articles and edited a number of books in the Web technology series. He is on the editorial board of a number of international journals, including Data Warehousing and Mining, Business Intelligence and Data Mining, Mobile Information Systems, Mobile Multimedia, Web Information Systems, and Web and Grid Services. He has been elected as a Fellow of the Institute for Management of Information Systems (UK).

Indices

Editorial Board

Associate Editors
  • IXiaohua Hu, Drexel University, USA
  • Wenny Rahayu, La Trobe University, Australia

    International Editorial Advisory Board

  • Hussein Abbass, University of New South Wales, Australia
  • Mafruz Zaman Ashrafi, Institute for Infocomm Research, Singapore
  • Jérôme Darmont, University of Lyon 2, France
  • Lixin Fu, University of North Carolina at Greensboro, USA
  • Lance Chun Che Fung, Murdoch University, Australia
  • Stephan Kudyba, New Jersey Institute of Technology, USA
  • Zongmin Ma, Northeastern University, China
  • Anthony Scime, State University of New York College at Brockport, USA
  • Robert Wrembel, Poznan University of Technology, Poland
  • Xingquan Zhu, Florida Atlantic University, USA