Matches in SemOpenAlex for { <https://semopenalex.org/work/W2118557642> ?p ?o ?g. }
Showing items 1 to 85 of
85
with 100 items per page.
- W2118557642 abstract "Multidimensional databases and online analytical processing (OLAP) tools provide new ways for decisionmakers to access data and retrieve information. This paper examines the differences between the optimization techniques that database designers need to consider when developing relational versus multidimensional data warehouses. The multidimensional data storage model allows for large numbers of aggregates to be stored in a very efficient and accessible manner. These aggregates make it possible to not only access information faster, but also at a lower cost in terms of CPU, I/O, and disk space utilization. This research-in-progress demonstrates those speed and cost savings using the TPC-H decision support benchmark. This publicly available dataset is used to contrast the use of indices in its relational implementation with the use of aggregates in its dimensional implementation. These contrasts show why database designers must shift from the index paradigm for relational databases to the aggregate paradigm for dimensional databases." @default.
- W2118557642 created "2016-06-24" @default.
- W2118557642 creator A5005872280 @default.
- W2118557642 creator A5046287902 @default.
- W2118557642 creator A5058164134 @default.
- W2118557642 date "2002-01-01" @default.
- W2118557642 modified "2023-09-27" @default.
- W2118557642 title "A PARADIGM SHIFT IN DATABASE OPTIMIZATION: FROM INDICES TO AGGREGATES" @default.
- W2118557642 cites W109127539 @default.
- W2118557642 cites W1985876015 @default.
- W2118557642 cites W1997264738 @default.
- W2118557642 cites W2108971776 @default.
- W2118557642 cites W2133066182 @default.
- W2118557642 cites W2753533763 @default.
- W2118557642 cites W2945526390 @default.
- W2118557642 cites W2983183399 @default.
- W2118557642 cites W2988119170 @default.
- W2118557642 hasPublicationYear "2002" @default.
- W2118557642 type Work @default.
- W2118557642 sameAs 2118557642 @default.
- W2118557642 citedByCount "2" @default.
- W2118557642 countsByYear W21185576422013 @default.
- W2118557642 crossrefType "journal-article" @default.
- W2118557642 hasAuthorship W2118557642A5005872280 @default.
- W2118557642 hasAuthorship W2118557642A5046287902 @default.
- W2118557642 hasAuthorship W2118557642A5058164134 @default.
- W2118557642 hasConcept C124101348 @default.
- W2118557642 hasConcept C13280743 @default.
- W2118557642 hasConcept C135572916 @default.
- W2118557642 hasConcept C154945302 @default.
- W2118557642 hasConcept C159985019 @default.
- W2118557642 hasConcept C185798385 @default.
- W2118557642 hasConcept C192562407 @default.
- W2118557642 hasConcept C201932085 @default.
- W2118557642 hasConcept C205649164 @default.
- W2118557642 hasConcept C24394798 @default.
- W2118557642 hasConcept C2776502983 @default.
- W2118557642 hasConcept C40207289 @default.
- W2118557642 hasConcept C41008148 @default.
- W2118557642 hasConcept C4679612 @default.
- W2118557642 hasConcept C5655090 @default.
- W2118557642 hasConcept C77088390 @default.
- W2118557642 hasConceptScore W2118557642C124101348 @default.
- W2118557642 hasConceptScore W2118557642C13280743 @default.
- W2118557642 hasConceptScore W2118557642C135572916 @default.
- W2118557642 hasConceptScore W2118557642C154945302 @default.
- W2118557642 hasConceptScore W2118557642C159985019 @default.
- W2118557642 hasConceptScore W2118557642C185798385 @default.
- W2118557642 hasConceptScore W2118557642C192562407 @default.
- W2118557642 hasConceptScore W2118557642C201932085 @default.
- W2118557642 hasConceptScore W2118557642C205649164 @default.
- W2118557642 hasConceptScore W2118557642C24394798 @default.
- W2118557642 hasConceptScore W2118557642C2776502983 @default.
- W2118557642 hasConceptScore W2118557642C40207289 @default.
- W2118557642 hasConceptScore W2118557642C41008148 @default.
- W2118557642 hasConceptScore W2118557642C4679612 @default.
- W2118557642 hasConceptScore W2118557642C5655090 @default.
- W2118557642 hasConceptScore W2118557642C77088390 @default.
- W2118557642 hasLocation W21185576421 @default.
- W2118557642 hasOpenAccess W2118557642 @default.
- W2118557642 hasPrimaryLocation W21185576421 @default.
- W2118557642 hasRelatedWork W1505307961 @default.
- W2118557642 hasRelatedWork W1522784375 @default.
- W2118557642 hasRelatedWork W1528326260 @default.
- W2118557642 hasRelatedWork W1540704498 @default.
- W2118557642 hasRelatedWork W1553616943 @default.
- W2118557642 hasRelatedWork W1984768336 @default.
- W2118557642 hasRelatedWork W2018246558 @default.
- W2118557642 hasRelatedWork W2043568847 @default.
- W2118557642 hasRelatedWork W2071314222 @default.
- W2118557642 hasRelatedWork W2104813727 @default.
- W2118557642 hasRelatedWork W2111006635 @default.
- W2118557642 hasRelatedWork W2133054368 @default.
- W2118557642 hasRelatedWork W2146081990 @default.
- W2118557642 hasRelatedWork W2157474328 @default.
- W2118557642 hasRelatedWork W2289830864 @default.
- W2118557642 hasRelatedWork W2317706107 @default.
- W2118557642 hasRelatedWork W2370347230 @default.
- W2118557642 hasRelatedWork W2395298664 @default.
- W2118557642 hasRelatedWork W2767174014 @default.
- W2118557642 hasRelatedWork W2808039231 @default.
- W2118557642 isParatext "false" @default.
- W2118557642 isRetracted "false" @default.
- W2118557642 magId "2118557642" @default.
- W2118557642 workType "article" @default.