Matches in SemOpenAlex for { <https://semopenalex.org/work/W5792105> ?p ?o ?g. }
Showing items 1 to 100 of
100
with 100 items per page.
- W5792105 endingPage "130" @default.
- W5792105 startingPage "123" @default.
- W5792105 abstract "Building indexes on database is common, but it has an important impact on the query performance, especially in large databases such as a Data Warehouse where the queries are usually very complex and ad hoc. If a proper index structure is chosen, the query response time can be accelerated. Until now, there is no definite guideline for Data Warehouse analysts to choose the appropriate index. According to conventional wisdom, Bitmap index is a preferred indexing technique for cases where the indexed attributes have few distinct values (i.e., low cardinality). The query response time is expected to degrade as the cardinality of indexed columns increase due to a larger index size. On the other hand, B-tree index is good if the column values are of high cardinality due to its indexing and retrieving mechanisms. In this paper, we show that this may not be true under certain circumstances. Experimental results support the fact that even though the level of column cardinality determines the index file size, but the query processing time is not determined by the level of column cardinality. Moreover, our results indicate that the Bitmap index is faster than B-tree index on a large dataset with multi-billion records." @default.
- W5792105 created "2016-06-24" @default.
- W5792105 creator A5000022196 @default.
- W5792105 creator A5038324843 @default.
- W5792105 creator A5039852954 @default.
- W5792105 date "2008-11-21" @default.
- W5792105 modified "2023-09-23" @default.
- W5792105 title "Investigating design choices between Bitmap index and B-tree index for a large data warehouse system" @default.
- W5792105 cites W1495859460 @default.
- W5792105 cites W1501548698 @default.
- W5792105 cites W1586923923 @default.
- W5792105 cites W2003421875 @default.
- W5792105 cites W2047995884 @default.
- W5792105 cites W2053562648 @default.
- W5792105 cites W2072764742 @default.
- W5792105 cites W2108971776 @default.
- W5792105 cites W2111967617 @default.
- W5792105 cites W2140646908 @default.
- W5792105 cites W2142856765 @default.
- W5792105 cites W2146365100 @default.
- W5792105 cites W2155928473 @default.
- W5792105 cites W2161694911 @default.
- W5792105 cites W2171669671 @default.
- W5792105 cites W2502241578 @default.
- W5792105 cites W3201128724 @default.
- W5792105 hasPublicationYear "2008" @default.
- W5792105 type Work @default.
- W5792105 sameAs 5792105 @default.
- W5792105 citedByCount "0" @default.
- W5792105 crossrefType "journal-article" @default.
- W5792105 hasAuthorship W5792105A5000022196 @default.
- W5792105 hasAuthorship W5792105A5038324843 @default.
- W5792105 hasAuthorship W5792105A5039852954 @default.
- W5792105 hasConcept C113174947 @default.
- W5792105 hasConcept C124101348 @default.
- W5792105 hasConcept C126042441 @default.
- W5792105 hasConcept C134306372 @default.
- W5792105 hasConcept C135572916 @default.
- W5792105 hasConcept C136764020 @default.
- W5792105 hasConcept C23123220 @default.
- W5792105 hasConcept C2777382242 @default.
- W5792105 hasConcept C2780551164 @default.
- W5792105 hasConcept C3115412 @default.
- W5792105 hasConcept C31972630 @default.
- W5792105 hasConcept C33923547 @default.
- W5792105 hasConcept C41008148 @default.
- W5792105 hasConcept C59276292 @default.
- W5792105 hasConcept C75165309 @default.
- W5792105 hasConcept C76155785 @default.
- W5792105 hasConcept C77088390 @default.
- W5792105 hasConcept C78669399 @default.
- W5792105 hasConcept C87117476 @default.
- W5792105 hasConceptScore W5792105C113174947 @default.
- W5792105 hasConceptScore W5792105C124101348 @default.
- W5792105 hasConceptScore W5792105C126042441 @default.
- W5792105 hasConceptScore W5792105C134306372 @default.
- W5792105 hasConceptScore W5792105C135572916 @default.
- W5792105 hasConceptScore W5792105C136764020 @default.
- W5792105 hasConceptScore W5792105C23123220 @default.
- W5792105 hasConceptScore W5792105C2777382242 @default.
- W5792105 hasConceptScore W5792105C2780551164 @default.
- W5792105 hasConceptScore W5792105C3115412 @default.
- W5792105 hasConceptScore W5792105C31972630 @default.
- W5792105 hasConceptScore W5792105C33923547 @default.
- W5792105 hasConceptScore W5792105C41008148 @default.
- W5792105 hasConceptScore W5792105C59276292 @default.
- W5792105 hasConceptScore W5792105C75165309 @default.
- W5792105 hasConceptScore W5792105C76155785 @default.
- W5792105 hasConceptScore W5792105C77088390 @default.
- W5792105 hasConceptScore W5792105C78669399 @default.
- W5792105 hasConceptScore W5792105C87117476 @default.
- W5792105 hasLocation W57921051 @default.
- W5792105 hasOpenAccess W5792105 @default.
- W5792105 hasPrimaryLocation W57921051 @default.
- W5792105 hasRelatedWork W141397823 @default.
- W5792105 hasRelatedWork W1985410431 @default.
- W5792105 hasRelatedWork W1987255301 @default.
- W5792105 hasRelatedWork W1995197570 @default.
- W5792105 hasRelatedWork W2018596944 @default.
- W5792105 hasRelatedWork W2036613237 @default.
- W5792105 hasRelatedWork W2055732952 @default.
- W5792105 hasRelatedWork W2097715713 @default.
- W5792105 hasRelatedWork W2134514876 @default.
- W5792105 hasRelatedWork W2153960976 @default.
- W5792105 hasRelatedWork W2161840863 @default.
- W5792105 hasRelatedWork W2199640993 @default.
- W5792105 hasRelatedWork W2318348781 @default.
- W5792105 hasRelatedWork W2385961191 @default.
- W5792105 hasRelatedWork W2462668730 @default.
- W5792105 hasRelatedWork W2517928160 @default.
- W5792105 hasRelatedWork W276487760 @default.
- W5792105 hasRelatedWork W2927448459 @default.
- W5792105 hasRelatedWork W2567645377 @default.
- W5792105 hasRelatedWork W2875407121 @default.
- W5792105 isParatext "false" @default.
- W5792105 isRetracted "false" @default.
- W5792105 magId "5792105" @default.
- W5792105 workType "article" @default.