Matches in SemOpenAlex for { <https://semopenalex.org/work/W283997035> ?p ?o ?g. }
Showing items 1 to 83 of
83
with 100 items per page.
- W283997035 endingPage "292" @default.
- W283997035 startingPage "279" @default.
- W283997035 abstract "System performance for data warehouses is crucially dependent on its physical design in which one of the most challenging tasks is the selection of an appropriate set of indexes for a representative workload under storage constraint. The problem becomes even more complex for multi-tables indexes such as bitmap join indexes, since it involves searching a vast space of possible configurations. Queries references to attributes and their frequencies play an important role in determining the efficiency of the selected indexes. In this paper, we consider the index selection as a typical frequent itemsets mining problem. The indexes are built with combinations of attributes, viewed as items. The queries in the workload, viewed as transactions, are described by the attributes they involve. The foundation of our approach is the concept of maximal frequent itemsets. This data mining technique helps to discover strong correlations among attributes such that the presence of some attributes in a query will imply the presence of some other attributes. Moreover, by avoiding the generation of redundent indexes, the proposed approach leads to a solution that expresses the set of relevant indexes in a more succinct way. Consequently, it guarantees the reduction of the storage space requirements. Unlike previous approaches that focus on the configuration leading to the minimum workload cost, we suggest to consider a set of optimized solutions and we propose a metric for measuring profit-effectiveness that helps to pick up the most promising one. Through a set of experiments on the ABP-1 benchmark, we show that our approach achieves better performance compared to similar methods, with significant savings in index storage." @default.
- W283997035 created "2016-06-24" @default.
- W283997035 creator A5073785860 @default.
- W283997035 creator A5085494766 @default.
- W283997035 date "2013-09-29" @default.
- W283997035 modified "2023-10-17" @default.
- W283997035 title "An improved approach for automatic selection of multi-tables indexes in ralational data warehouses using maximal frequent itemsets" @default.
- W283997035 cites W109127539 @default.
- W283997035 cites W1495859460 @default.
- W283997035 cites W1556530724 @default.
- W283997035 cites W1558235631 @default.
- W283997035 cites W1562318351 @default.
- W283997035 cites W1576757369 @default.
- W283997035 cites W1585646276 @default.
- W283997035 cites W1841391047 @default.
- W283997035 cites W1851390469 @default.
- W283997035 cites W188023883 @default.
- W283997035 cites W1982945449 @default.
- W283997035 cites W2033283439 @default.
- W283997035 cites W2086028392 @default.
- W283997035 cites W2108883953 @default.
- W283997035 cites W2108971776 @default.
- W283997035 cites W2110893883 @default.
- W283997035 cites W2111967617 @default.
- W283997035 cites W2117716920 @default.
- W283997035 cites W2122128399 @default.
- W283997035 cites W2122816893 @default.
- W283997035 cites W2130072301 @default.
- W283997035 cites W2135475686 @default.
- W283997035 cites W2140646908 @default.
- W283997035 cites W2143100570 @default.
- W283997035 cites W2161694911 @default.
- W283997035 cites W2165481122 @default.
- W283997035 cites W2166559705 @default.
- W283997035 cites W2168503413 @default.
- W283997035 cites W2296408038 @default.
- W283997035 cites W2400883540 @default.
- W283997035 cites W371957946 @default.
- W283997035 cites W43458232 @default.
- W283997035 doi "https://doi.org/10.3233/idt-130169" @default.
- W283997035 hasPublicationYear "2013" @default.
- W283997035 type Work @default.
- W283997035 sameAs 283997035 @default.
- W283997035 citedByCount "1" @default.
- W283997035 countsByYear W2839970352022 @default.
- W283997035 crossrefType "journal-article" @default.
- W283997035 hasAuthorship W283997035A5073785860 @default.
- W283997035 hasAuthorship W283997035A5085494766 @default.
- W283997035 hasConcept C124101348 @default.
- W283997035 hasConcept C135572916 @default.
- W283997035 hasConcept C154945302 @default.
- W283997035 hasConcept C23123220 @default.
- W283997035 hasConcept C41008148 @default.
- W283997035 hasConcept C77088390 @default.
- W283997035 hasConcept C81917197 @default.
- W283997035 hasConceptScore W283997035C124101348 @default.
- W283997035 hasConceptScore W283997035C135572916 @default.
- W283997035 hasConceptScore W283997035C154945302 @default.
- W283997035 hasConceptScore W283997035C23123220 @default.
- W283997035 hasConceptScore W283997035C41008148 @default.
- W283997035 hasConceptScore W283997035C77088390 @default.
- W283997035 hasConceptScore W283997035C81917197 @default.
- W283997035 hasIssue "4" @default.
- W283997035 hasLocation W2839970351 @default.
- W283997035 hasOpenAccess W283997035 @default.
- W283997035 hasPrimaryLocation W2839970351 @default.
- W283997035 hasRelatedWork W1683636825 @default.
- W283997035 hasRelatedWork W2067134532 @default.
- W283997035 hasRelatedWork W2144190808 @default.
- W283997035 hasRelatedWork W2282586151 @default.
- W283997035 hasRelatedWork W2301096354 @default.
- W283997035 hasRelatedWork W2357241418 @default.
- W283997035 hasRelatedWork W2366644548 @default.
- W283997035 hasRelatedWork W2376314740 @default.
- W283997035 hasRelatedWork W2384888906 @default.
- W283997035 hasRelatedWork W2751504412 @default.
- W283997035 hasVolume "7" @default.
- W283997035 isParatext "false" @default.
- W283997035 isRetracted "false" @default.
- W283997035 magId "283997035" @default.
- W283997035 workType "article" @default.