Bulk loading a data warehouse built upon a UB-Tree

R. Fenk, A. Kawakami, V. Markl, R. Bayer, S. Osaki
Proceedings 2000 International Database Engineering and Applications Symposium (Cat. No.PR00789)  
This paper considers the issue of bulk loading large data sets for the UB-Tree, a multidimensional index structure. Especially in dataware housing (DW), data mining and OLAP it is necessary to have efficient bulk loading techniques, because loading occurs not continuously, but only from time to time with usually large data sets. We propose two techniques, one for initial loading, which creates a new UB-Tree, and one for incremental loading, which adds data to an existing UB-Tree. Both
more » ... try to minimize I/O and CPU cost. Measurements with artificial data and data of a commercial data warehouse demonstrate that our algorithms are efficient and able to handle large data sets. As well as the UB-Tree, they are easily integrated into a RDBMS.
doi:10.1109/ideas.2000.880576 dblp:conf/ideas/FenkKMBO00 fatcat:72w2ybykazah5orj5j6r3ttewy