P2P OLAP: Data model, implementation and case study

It is a common situation nowadays that business groups own different companies that operate in an autonomous way. Nevertheless, these companies must be requested to provide the headquarters with summarized information for decision-making. An architecture for cooperative interchange of decision-makin...

Descripción completa

Guardado en:
Detalles Bibliográficos
Autores principales: Vaisman, A.A., Espil, M.M., Paradela, M.
Formato: JOUR
Materias:
Data warehousing
Dimensions
Hierarchies
OLAP
Peer-to-peer
Administrative data processing
Agglomeration
Client server computer systems
Computer systems
Data processing
Data storage equipment
Data structures
Problem solving
Data warehouses
Acceso en línea:http://hdl.handle.net/20.500.12110/paper_03064379_v34_n2_p231_Vaisman
Aporte de:
Biblioteca Digital - Facultad de Ciencias Exactas y Naturales (UBA) de Universidad de Buenos Aires
id todo:paper_03064379_v34_n2_p231_Vaisman
record_format dspace
spelling todo:paper_03064379_v34_n2_p231_Vaisman2023-10-03T15:22:17Z P2P OLAP: Data model, implementation and case study Vaisman, A.A. Espil, M.M. Paradela, M. Data warehousing Dimensions Hierarchies OLAP Peer-to-peer Administrative data processing Agglomeration Client server computer systems Computer systems Data processing Data storage equipment Data structures Problem solving Data warehousing Dimensions Hierarchies OLAP Peer-to-peer Data warehouses It is a common situation nowadays that business groups own different companies that operate in an autonomous way. Nevertheless, these companies must be requested to provide the headquarters with summarized information for decision-making. An architecture for cooperative interchange of decision-making information seems to be a natural solution for this problem. We propose the use of a peer-to-peer (P2P) architecture for addressing the problem of processing OLAP data in a distributed environment, in a way that all companies involved can maintain full autonomy over the use of its own data resources. In a scenario like this, data exchange between peers occurs when one of them, in the role of a local peer, receives a query and, for answering it, requests data available in other nodes, denoted acquaintances. No global schema is assumed to exist for any data under this computing paradigm. Henceforth, data provided by an acquaintance of a local peer must be adapted, in a manner that answers to queries posed by local peer users conform the view those users have of their data. Because multidimensional data normally consist of a collection of views of aggregated data, a careful translation process is needed in this case, in order to transform any summary concept that appears in a peer acquaintance into a summary concept meaningful to the requesting peer. We first present a model for multidimensional data distributed in a P2P network, and a query rewriting technique, that allows a local peer to propagate OLAP queries among its acquaintances, obtaining a meaningful and correct answer. Mappings are performed using a novel technique called revise and map, based on belief revision concepts. Revising a dimension instance allows to produce consistent aggregations when an OLAP query is answered at more than one node. We then describe an implementation of a P2P system for answering OLAP queries over a network of data warehouses. We apply our proposal to a real-world case study of an insurance group. Finally, we report the results of an experimental evaluation of our implementation, and discuss the issues that must be accounted for in this setting. © 2008 Elsevier B.V. All rights reserved. JOUR info:eu-repo/semantics/openAccess http://creativecommons.org/licenses/by/2.5/ar http://hdl.handle.net/20.500.12110/paper_03064379_v34_n2_p231_Vaisman
institution Universidad de Buenos Aires
institution_str I-28
repository_str R-134
collection Biblioteca Digital - Facultad de Ciencias Exactas y Naturales (UBA)
topic Data warehousing
Dimensions
Hierarchies
OLAP
Peer-to-peer
Administrative data processing
Agglomeration
Client server computer systems
Computer systems
Data processing
Data storage equipment
Data structures
Problem solving
Data warehousing
Dimensions
Hierarchies
OLAP
Peer-to-peer
Data warehouses
spellingShingle Data warehousing
Dimensions
Hierarchies
OLAP
Peer-to-peer
Administrative data processing
Agglomeration
Client server computer systems
Computer systems
Data processing
Data storage equipment
Data structures
Problem solving
Data warehousing
Dimensions
Hierarchies
OLAP
Peer-to-peer
Data warehouses
Vaisman, A.A.
Espil, M.M.
Paradela, M.
P2P OLAP: Data model, implementation and case study
topic_facet Data warehousing
Dimensions
Hierarchies
OLAP
Peer-to-peer
Administrative data processing
Agglomeration
Client server computer systems
Computer systems
Data processing
Data storage equipment
Data structures
Problem solving
Data warehousing
Dimensions
Hierarchies
OLAP
Peer-to-peer
Data warehouses
description It is a common situation nowadays that business groups own different companies that operate in an autonomous way. Nevertheless, these companies must be requested to provide the headquarters with summarized information for decision-making. An architecture for cooperative interchange of decision-making information seems to be a natural solution for this problem. We propose the use of a peer-to-peer (P2P) architecture for addressing the problem of processing OLAP data in a distributed environment, in a way that all companies involved can maintain full autonomy over the use of its own data resources. In a scenario like this, data exchange between peers occurs when one of them, in the role of a local peer, receives a query and, for answering it, requests data available in other nodes, denoted acquaintances. No global schema is assumed to exist for any data under this computing paradigm. Henceforth, data provided by an acquaintance of a local peer must be adapted, in a manner that answers to queries posed by local peer users conform the view those users have of their data. Because multidimensional data normally consist of a collection of views of aggregated data, a careful translation process is needed in this case, in order to transform any summary concept that appears in a peer acquaintance into a summary concept meaningful to the requesting peer. We first present a model for multidimensional data distributed in a P2P network, and a query rewriting technique, that allows a local peer to propagate OLAP queries among its acquaintances, obtaining a meaningful and correct answer. Mappings are performed using a novel technique called revise and map, based on belief revision concepts. Revising a dimension instance allows to produce consistent aggregations when an OLAP query is answered at more than one node. We then describe an implementation of a P2P system for answering OLAP queries over a network of data warehouses. We apply our proposal to a real-world case study of an insurance group. Finally, we report the results of an experimental evaluation of our implementation, and discuss the issues that must be accounted for in this setting. © 2008 Elsevier B.V. All rights reserved.
format JOUR
author Vaisman, A.A.
Espil, M.M.
Paradela, M.
author_facet Vaisman, A.A.
Espil, M.M.
Paradela, M.
author_sort Vaisman, A.A.
title P2P OLAP: Data model, implementation and case study
title_short P2P OLAP: Data model, implementation and case study
title_full P2P OLAP: Data model, implementation and case study
title_fullStr P2P OLAP: Data model, implementation and case study
title_full_unstemmed P2P OLAP: Data model, implementation and case study
title_sort p2p olap: data model, implementation and case study
url http://hdl.handle.net/20.500.12110/paper_03064379_v34_n2_p231_Vaisman
work_keys_str_mv AT vaismanaa p2polapdatamodelimplementationandcasestudy
AT espilmm p2polapdatamodelimplementationandcasestudy
AT paradelam p2polapdatamodelimplementationandcasestudy
_version_ 1807323177401974784

Ejemplares similares