• español
    • English
  • español 
    • español
    • English
  • Login
Ver ítem 
  •   Repositorio Tecnm Orizaba
  • Área Sistemas
  • Maestría en Sistemas Computacionales
  • Artículos (MSC)
  • Ver ítem
  •   Repositorio Tecnm Orizaba
  • Área Sistemas
  • Maestría en Sistemas Computacionales
  • Artículos (MSC)
  • Ver ítem
JavaScript is disabled for your browser. Some features of this site may not work without it.

Decision-Tree-Based Horizontal Fragmentation Method for Data Warehouses

Thumbnail
Ver/
Artículo JCR (5.506Mb)
Fecha
2022-10-28
Autor
Rodríguez-Mazahua, Nidia
Rodríguez-Mazahua, Lisbeth
López-Chau, Asdrúbal
Alor-Hernández, Giner
Machorro-Cano, Isaac
Metadatos
Mostrar el registro completo del ítem
Resumen
Data warehousing gives frameworks and means for enterprise administrators to methodically prepare, comprehend, and utilize the data to improve strategic decision-making skills. One of the principal challenges to data warehouse designers is fragmentation. Currently, several frag mentation approaches for data warehouses have been developed since this technique can decrease the OLAP (online analytical processing) query response time and it provides considerable benefits in table loading and maintenance tasks. In this paper, a horizontal fragmentation method, called FTree, that uses decision trees to fragment data warehouses is presented to take advantage of the effectiveness that this technique provides in classification. FTree determines the OLAP queries with major relevance, evaluates the predicates found in the workload, and according to this, builds the decision tree to select the horizontal fragmentation scheme. To verify that the design is correct, the SSB (star schema benchmark) was used in the first instance; later, a tourist data warehouse was built, and the fragmentation method was tested on it. The results of the experiments proved the efficacy of the method.
URI
http://repositorios.orizaba.tecnm.mx:8080/xmlui/handle/123456789/746
Temas
Horizontal fragmentation
Decision trees
Data Warehouse
Cost model
Tipo
Article
Colecciones
  • Artículos (MSC) [39]

Repositorio Tecnm Orizaba copyright © 2020 
Contacto | Sugerencias
 

 

Listar

Todo el RepositorioComunidades & ColeccionesPor fecha de publicaciónAutoresTítulosMateriasEsta colecciónPor fecha de publicaciónAutoresTítulosMaterias

Mi cuenta

AccederRegistro

Repositorio Tecnm Orizaba copyright © 2020 
Contacto | Sugerencias