Matches in SemOpenAlex for { <https://semopenalex.org/work/W86191609> ?p ?o ?g. }
- W86191609 startingPage "1" @default.
- W86191609 abstract "Multidimensional access methods like the UBTree can be used to accelerate almost any query processing operation, if proper query processing algorithms are used: Relational queries or SQL queries consist of restrictions, projections, ordering, grouping and aggregation, and join operations. In the presence of multidimensional restrictions or sorting, multidimensional range query or Tetris algorithms efficiently process these operations. In addition, these algorithms also efficiently support queries that generate some hierarchical restrictions (for instance by following 1:n foreign key relationships). In this paper we investigate the impacts on query processing in RDBMS when using UB-Trees and multidimensional hierarchical clustering for physical data organization. We illustrate the benefits by performance measurements of queries for a star schema from a real world application of a SAP business information warehouse. The performance results reported in this paper were measured with our prototype implementation of UB-Trees on top of Oracle 8. We compare the performance of UB-Trees to native query processing techniques of Oracle, namely access via an index organized table, which essentially stores a relation in a clustered B*-Tree, and access via a full table scan of an entire relation. In addition we measure the performance of the intersection of multiple bitmap indexes to answer multidimensional range queries." @default.
- W86191609 created "2016-06-24" @default.
- W86191609 creator A5002413906 @default.
- W86191609 creator A5070784354 @default.
- W86191609 date "2000-01-01" @default.
- W86191609 modified "2023-09-27" @default.
- W86191609 title "Processing Relational OLAP Queries with UB-Trees and Multidimensional Hierarchical Clustering" @default.
- W86191609 cites W1494049834 @default.
- W86191609 cites W1507719695 @default.
- W86191609 cites W151059316 @default.
- W86191609 cites W1515932031 @default.
- W86191609 cites W1522055873 @default.
- W86191609 cites W1578663408 @default.
- W86191609 cites W1581805425 @default.
- W86191609 cites W188023883 @default.
- W86191609 cites W1894732633 @default.
- W86191609 cites W1952220400 @default.
- W86191609 cites W1981561414 @default.
- W86191609 cites W1982945449 @default.
- W86191609 cites W2071425575 @default.
- W86191609 cites W2072764742 @default.
- W86191609 cites W2074429597 @default.
- W86191609 cites W2106642566 @default.
- W86191609 cites W2108908993 @default.
- W86191609 cites W2111967617 @default.
- W86191609 cites W2113888164 @default.
- W86191609 cites W2114712170 @default.
- W86191609 cites W2117716920 @default.
- W86191609 cites W2118269922 @default.
- W86191609 cites W2149173084 @default.
- W86191609 cites W2158237121 @default.
- W86191609 cites W38346608 @default.
- W86191609 hasPublicationYear "2000" @default.
- W86191609 type Work @default.
- W86191609 sameAs 86191609 @default.
- W86191609 citedByCount "5" @default.
- W86191609 countsByYear W861916092012 @default.
- W86191609 countsByYear W861916092013 @default.
- W86191609 crossrefType "journal-article" @default.
- W86191609 hasAuthorship W86191609A5002413906 @default.
- W86191609 hasAuthorship W86191609A5070784354 @default.
- W86191609 hasConcept C113174947 @default.
- W86191609 hasConcept C115903868 @default.
- W86191609 hasConcept C124101348 @default.
- W86191609 hasConcept C134306372 @default.
- W86191609 hasConcept C135572916 @default.
- W86191609 hasConcept C136736807 @default.
- W86191609 hasConcept C148840519 @default.
- W86191609 hasConcept C154945302 @default.
- W86191609 hasConcept C157692150 @default.
- W86191609 hasConcept C164120249 @default.
- W86191609 hasConcept C190703929 @default.
- W86191609 hasConcept C194222762 @default.
- W86191609 hasConcept C201932085 @default.
- W86191609 hasConcept C23123220 @default.
- W86191609 hasConcept C24394798 @default.
- W86191609 hasConcept C25343380 @default.
- W86191609 hasConcept C30775581 @default.
- W86191609 hasConcept C33923547 @default.
- W86191609 hasConcept C41008148 @default.
- W86191609 hasConcept C510870499 @default.
- W86191609 hasConcept C54239708 @default.
- W86191609 hasConcept C55166926 @default.
- W86191609 hasConcept C5655090 @default.
- W86191609 hasConcept C73555534 @default.
- W86191609 hasConcept C77088390 @default.
- W86191609 hasConcept C92835128 @default.
- W86191609 hasConcept C97854310 @default.
- W86191609 hasConcept C98199447 @default.
- W86191609 hasConceptScore W86191609C113174947 @default.
- W86191609 hasConceptScore W86191609C115903868 @default.
- W86191609 hasConceptScore W86191609C124101348 @default.
- W86191609 hasConceptScore W86191609C134306372 @default.
- W86191609 hasConceptScore W86191609C135572916 @default.
- W86191609 hasConceptScore W86191609C136736807 @default.
- W86191609 hasConceptScore W86191609C148840519 @default.
- W86191609 hasConceptScore W86191609C154945302 @default.
- W86191609 hasConceptScore W86191609C157692150 @default.
- W86191609 hasConceptScore W86191609C164120249 @default.
- W86191609 hasConceptScore W86191609C190703929 @default.
- W86191609 hasConceptScore W86191609C194222762 @default.
- W86191609 hasConceptScore W86191609C201932085 @default.
- W86191609 hasConceptScore W86191609C23123220 @default.
- W86191609 hasConceptScore W86191609C24394798 @default.
- W86191609 hasConceptScore W86191609C25343380 @default.
- W86191609 hasConceptScore W86191609C30775581 @default.
- W86191609 hasConceptScore W86191609C33923547 @default.
- W86191609 hasConceptScore W86191609C41008148 @default.
- W86191609 hasConceptScore W86191609C510870499 @default.
- W86191609 hasConceptScore W86191609C54239708 @default.
- W86191609 hasConceptScore W86191609C55166926 @default.
- W86191609 hasConceptScore W86191609C5655090 @default.
- W86191609 hasConceptScore W86191609C73555534 @default.
- W86191609 hasConceptScore W86191609C77088390 @default.
- W86191609 hasConceptScore W86191609C92835128 @default.
- W86191609 hasConceptScore W86191609C97854310 @default.
- W86191609 hasConceptScore W86191609C98199447 @default.
- W86191609 hasLocation W861916091 @default.
- W86191609 hasOpenAccess W86191609 @default.