Inter-business collaborative contexts prefigure a distributed scenario where companies organize and coordinate themselves to develop common and shared opportunities, respecting their own autonomy and heterogeneity. Traditional business intelligence systems, that were born to support stand-alone decision-making, do not provide support to this end. Peer Data Management Systems (PDMSs) have been proposed in the literature as architectures to support sharing of operational data across networks of peers while guaranteeing peers' autonomy, based on semantic mappings that mediate between the heterogeneous schemata exposed by peers. In line with the PDMS infrastructure, in this paper we envision a peer-to-peer data warehousing architecture based on a network of heterogeneous peers, each equipped with an independent data warehouse system, that expose query answering functionalities aimed at sharing business information. To enhance the decision making process, an OLAP query expressed on a peer needs be properly reformulated on the other peers. In this direction, we present a language for the definition of mappings between the multidimensional schemata of peers, and we introduce a query reformulation framework that relies on the translation of these mappings towards relational schemata. Finally, we sketch the query reformulation algorithm by outlining the reformulation steps of typical OLAP queries.
Towards OLAP Query Reformulation in Peer-to-Peer Data Warehousing / M., Golfarelli; Mandreoli, Federica; W., Penzo; S., Rizzi; E., Turricchia. - ELETTRONICO. - (2010), pp. 37-44. (Intervento presentato al convegno ACM International Workshop On Data Warehousing and OLAP (DOLAP) tenutosi a Toronto (Canada) nel 30 ottobre 2010) [10.1145/1871940.1871950].
Towards OLAP Query Reformulation in Peer-to-Peer Data Warehousing
MANDREOLI, Federica;
2010
Abstract
Inter-business collaborative contexts prefigure a distributed scenario where companies organize and coordinate themselves to develop common and shared opportunities, respecting their own autonomy and heterogeneity. Traditional business intelligence systems, that were born to support stand-alone decision-making, do not provide support to this end. Peer Data Management Systems (PDMSs) have been proposed in the literature as architectures to support sharing of operational data across networks of peers while guaranteeing peers' autonomy, based on semantic mappings that mediate between the heterogeneous schemata exposed by peers. In line with the PDMS infrastructure, in this paper we envision a peer-to-peer data warehousing architecture based on a network of heterogeneous peers, each equipped with an independent data warehouse system, that expose query answering functionalities aimed at sharing business information. To enhance the decision making process, an OLAP query expressed on a peer needs be properly reformulated on the other peers. In this direction, we present a language for the definition of mappings between the multidimensional schemata of peers, and we introduce a query reformulation framework that relies on the translation of these mappings towards relational schemata. Finally, we sketch the query reformulation algorithm by outlining the reformulation steps of typical OLAP queries.Pubblicazioni consigliate
I metadati presenti in IRIS UNIMORE sono rilasciati con licenza Creative Commons CC0 1.0 Universal, mentre i file delle pubblicazioni sono rilasciati con licenza Attribuzione 4.0 Internazionale (CC BY 4.0), salvo diversa indicazione.
In caso di violazione di copyright, contattare Supporto Iris