Matches in SemOpenAlex for { <https://semopenalex.org/work/W1521464082> ?p ?o ?g. }
Showing items 1 to 61 of
61
with 100 items per page.
- W1521464082 endingPage "1181" @default.
- W1521464082 startingPage "1170" @default.
- W1521464082 abstract "The ability to physically cluster a database table on multiple dimensions is a powerful technique that offers significant performance benefits in many online analytical processing (OLAP), warehousing, and decision support systems. An industrial implementation of this technique for the DB2® Universal Database™ (DB2 UDB) product, called multidimensional clustering (MDC) that co-exists with other classical forms of data storage and indexing methods, was described in VLDB 2003. This chapter describes the first published model for automating the selection of clustering keys in single-dimensional and multidimensional relational databases that use a cell/block storage structure for MDC. The automated MDC design model is based on what-if query cost modeling, data sampling, and a search algorithm for evaluating a large constellation of possible combinations. The model is effective at trading the benefits of potential combinations of clustering keys against data sparsity and performance. It also effectively selects the granularity at which dimensions should be used for clustering. The chapter presents the results from experiments indicating that the model provides design recommendations of comparable quality to those made by human experts. The model has been implemented in the IBM® DB2 UDB for Linux®, UNIX®, and Windows® Version 8.2 release." @default.
- W1521464082 created "2016-06-24" @default.
- W1521464082 creator A5030480168 @default.
- W1521464082 creator A5069125151 @default.
- W1521464082 date "2004-01-01" @default.
- W1521464082 modified "2023-09-26" @default.
- W1521464082 title "Automated design of multidimensional clustering tables for relational databases" @default.
- W1521464082 cites W2027507804 @default.
- W1521464082 doi "https://doi.org/10.1016/b978-012088469-8.50102-9" @default.
- W1521464082 hasPublicationYear "2004" @default.
- W1521464082 type Work @default.
- W1521464082 sameAs 1521464082 @default.
- W1521464082 citedByCount "14" @default.
- W1521464082 countsByYear W15214640822013 @default.
- W1521464082 countsByYear W15214640822016 @default.
- W1521464082 countsByYear W15214640822018 @default.
- W1521464082 countsByYear W15214640822019 @default.
- W1521464082 countsByYear W15214640822020 @default.
- W1521464082 countsByYear W15214640822021 @default.
- W1521464082 crossrefType "book-chapter" @default.
- W1521464082 hasAuthorship W1521464082A5030480168 @default.
- W1521464082 hasAuthorship W1521464082A5069125151 @default.
- W1521464082 hasBestOaLocation W15214640822 @default.
- W1521464082 hasConcept C119857082 @default.
- W1521464082 hasConcept C124101348 @default.
- W1521464082 hasConcept C135572916 @default.
- W1521464082 hasConcept C201932085 @default.
- W1521464082 hasConcept C23123220 @default.
- W1521464082 hasConcept C41008148 @default.
- W1521464082 hasConcept C5655090 @default.
- W1521464082 hasConcept C73555534 @default.
- W1521464082 hasConcept C77088390 @default.
- W1521464082 hasConceptScore W1521464082C119857082 @default.
- W1521464082 hasConceptScore W1521464082C124101348 @default.
- W1521464082 hasConceptScore W1521464082C135572916 @default.
- W1521464082 hasConceptScore W1521464082C201932085 @default.
- W1521464082 hasConceptScore W1521464082C23123220 @default.
- W1521464082 hasConceptScore W1521464082C41008148 @default.
- W1521464082 hasConceptScore W1521464082C5655090 @default.
- W1521464082 hasConceptScore W1521464082C73555534 @default.
- W1521464082 hasConceptScore W1521464082C77088390 @default.
- W1521464082 hasLocation W15214640821 @default.
- W1521464082 hasLocation W15214640822 @default.
- W1521464082 hasOpenAccess W1521464082 @default.
- W1521464082 hasPrimaryLocation W15214640821 @default.
- W1521464082 hasRelatedWork W1498033538 @default.
- W1521464082 hasRelatedWork W1598984680 @default.
- W1521464082 hasRelatedWork W2092428805 @default.
- W1521464082 hasRelatedWork W2184469894 @default.
- W1521464082 hasRelatedWork W2340335381 @default.
- W1521464082 hasRelatedWork W2352293812 @default.
- W1521464082 hasRelatedWork W2624992841 @default.
- W1521464082 hasRelatedWork W2946976120 @default.
- W1521464082 hasRelatedWork W2966731274 @default.
- W1521464082 hasRelatedWork W641577382 @default.
- W1521464082 isParatext "false" @default.
- W1521464082 isRetracted "false" @default.
- W1521464082 magId "1521464082" @default.
- W1521464082 workType "book-chapter" @default.