• DocumentCode
    2580590
  • Title

    Bulk loading a data warehouse built upon a UB-Tree

  • Author

    Fenk, Robert ; Kawakami, Akihiko ; Markl, Volker ; Bayer, Rudolf ; Osaki, Shuichi

  • Author_Institution
    Bavarian Res. Center for Knowledge Based Syst., Munich, Germany
  • fYear
    2000
  • fDate
    2000
  • Firstpage
    179
  • Lastpage
    187
  • Abstract
    We consider the issue of bulk loading large data sets for the UB-Tree, a multidimensional index structure. Especially in data warehousing (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 techniques 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
  • Keywords
    data handling; data mining; data warehouses; database indexing; relational databases; tree data structures; CPU cost; OLAP; UB-Tree; bulk loading; data mining; data warehouse; input output cost; large data sets; multidimensional index structure; relational database; Costs; Data warehouses; Filling; Information systems; Knowledge based systems; Multidimensional systems; Performance analysis; Research and development; Robustness; Testing;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Database Engineering and Applications Symposium, 2000 International
  • Conference_Location
    Yokohama
  • Print_ISBN
    0-7695-0789-1
  • Type

    conf

  • DOI
    10.1109/IDEAS.2000.880576
  • Filename
    880576