Welcome!
To use the personalized features of this site, please log in or register.
If you have forgotten your username or password, we can help.
My Menu
Saved Items

Applying Vertical Fragmentation Techniques in Logical Design of Multidimensional Databases

Matteo GolfarelliContact Information, Dario MaioContact Information and Stefano RizziContact Information

(7)  DEIS - University of Bologna, Viale Risorgimento 2, 40136 Bologna, Italy
Abstract
In the context of multidimensional databases implemented on relational DBMSs through star schemes, the most effective technique to enhance performances consists of materializing redundant aggregates called views. In this paper we investigate the problem of vertical fragmentation of views aimed at minimizing the workload response time. Each view includes several measures which not necessarily are always requested together; thus, the system performance may be increased by partitioning the views into smaller tables. On the other hand, drill-across queries involve measures taken from two or more views; in this case the access costs may be decreased by unifying these views into larger tables. After formalizing the fragmentation problem as a 0–1 integer linear programming problem, we define a cost function and outline a branch-and-bound algorithm to minimize it. Finally, we demonstrate the usefulness of our approach by presenting a set of experimental results based on the TPC-D benchmark.
This research was partially supported by MURST - Interdata Project.

Contact Information Matteo Golfarelli
Email: mgolfarelli@deis.unibo.it

Contact Information Dario Maio
Email: dmaio@deis.unibo.it

Contact Information Stefano Rizzi
Email: srizzi@deis.unibo.it
Fulltext Preview (Small, Large)
Image of the first page of the fulltext

References secured to subscribers.



Export this chapter
Export this chapter as RIS | Text
 
Remote Address: 38.107.191.106 • Server: mpweb04
HTTP User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)