Matches in SemOpenAlex for { <https://semopenalex.org/work/W1998415522> ?p ?o ?g. }
Showing items 1 to 72 of
72
with 100 items per page.
- W1998415522 endingPage "44" @default.
- W1998415522 startingPage "23" @default.
- W1998415522 abstract "One of the most powerful and prominent technologies for knowledge discovery in decision support systems is online analytical processing (OLAP). Most of the traditional OLAP research, and most of the commercial systems, follow the static data cube approach proposed by Gray et.al. and materialize all or a subset of the cuboids of the data cube in order to ensure adequate query performance. Practitioners have called for some time for a real-time OLAP approach where the OLAP system gets updated instantaneously as new data arrives and always provides an up-to-date data warehouse for the decision support process. However, a major problem for real-time OLAP is the significant performance issues with large scale data warehouses. The aim of our research is to address these problems through the use of efficient parallel computing methods. In this paper, we present a parallel real-time OLAP system for multi-core processors. To our knowledge, this is the first real-time OLAP system that has been parallelized and optimized for contemporary multi-core architectures. Our system allows for multiple insert and multiple query transactions to be executed in parallel and in real-time. We evaluated our method for a multitude of scenarios (different ratios of insert and query transactions, query transactions with different amounts of data aggregation, different database sizes, etc.), using the TPCDS “Decision Support” benchmark data set. As multi-core test platforms, we used an Intel Sandy Bridge processor with 4 cores (8 hardware supported threads) and an Intel Xeon Westmere processor with 20 cores (40 hardware supported threads). The tests demonstrate that, with increasing number of processor cores, our parallel system achieves close to linear speedup in transaction response time and transaction throughput. On the 20 core architecture we achieved, for a 100 GB database, a better than 0.25 second query response time for real-time OLAP queries that aggregate 25% of the database. Since hardware performance improvements are currently, and in the foreseeable future, achieved not by faster processors but by increasing the number of processor cores, our new parallel real-time OLAP method has the potential to enable OLAP systems that operate in real-time on large databases." @default.
- W1998415522 created "2016-06-24" @default.
- W1998415522 creator A5028278856 @default.
- W1998415522 creator A5083015287 @default.
- W1998415522 date "2015-01-01" @default.
- W1998415522 modified "2023-10-16" @default.
- W1998415522 title "Parallel Real-Time OLAP on Multi-Core Processors" @default.
- W1998415522 cites W1504395540 @default.
- W1998415522 cites W1591663442 @default.
- W1998415522 cites W1991172728 @default.
- W1998415522 cites W2103201239 @default.
- W1998415522 cites W2126519328 @default.
- W1998415522 cites W2133443743 @default.
- W1998415522 cites W2134864705 @default.
- W1998415522 cites W2313063886 @default.
- W1998415522 cites W4245210711 @default.
- W1998415522 doi "https://doi.org/10.4018/ijdwm.2015010102" @default.
- W1998415522 hasPublicationYear "2015" @default.
- W1998415522 type Work @default.
- W1998415522 sameAs 1998415522 @default.
- W1998415522 citedByCount "3" @default.
- W1998415522 countsByYear W19984155222016 @default.
- W1998415522 countsByYear W19984155222017 @default.
- W1998415522 countsByYear W19984155222021 @default.
- W1998415522 crossrefType "journal-article" @default.
- W1998415522 hasAuthorship W1998415522A5028278856 @default.
- W1998415522 hasAuthorship W1998415522A5083015287 @default.
- W1998415522 hasConcept C107327155 @default.
- W1998415522 hasConcept C124101348 @default.
- W1998415522 hasConcept C13280743 @default.
- W1998415522 hasConcept C135572916 @default.
- W1998415522 hasConcept C173608175 @default.
- W1998415522 hasConcept C185798385 @default.
- W1998415522 hasConcept C201932085 @default.
- W1998415522 hasConcept C205649164 @default.
- W1998415522 hasConcept C41008148 @default.
- W1998415522 hasConcept C77088390 @default.
- W1998415522 hasConcept C78168278 @default.
- W1998415522 hasConcept C96972482 @default.
- W1998415522 hasConceptScore W1998415522C107327155 @default.
- W1998415522 hasConceptScore W1998415522C124101348 @default.
- W1998415522 hasConceptScore W1998415522C13280743 @default.
- W1998415522 hasConceptScore W1998415522C135572916 @default.
- W1998415522 hasConceptScore W1998415522C173608175 @default.
- W1998415522 hasConceptScore W1998415522C185798385 @default.
- W1998415522 hasConceptScore W1998415522C201932085 @default.
- W1998415522 hasConceptScore W1998415522C205649164 @default.
- W1998415522 hasConceptScore W1998415522C41008148 @default.
- W1998415522 hasConceptScore W1998415522C77088390 @default.
- W1998415522 hasConceptScore W1998415522C78168278 @default.
- W1998415522 hasConceptScore W1998415522C96972482 @default.
- W1998415522 hasIssue "1" @default.
- W1998415522 hasLocation W19984155221 @default.
- W1998415522 hasOpenAccess W1998415522 @default.
- W1998415522 hasPrimaryLocation W19984155221 @default.
- W1998415522 hasRelatedWork W1160301755 @default.
- W1998415522 hasRelatedWork W1595571190 @default.
- W1998415522 hasRelatedWork W2043568847 @default.
- W1998415522 hasRelatedWork W2084266952 @default.
- W1998415522 hasRelatedWork W2092428805 @default.
- W1998415522 hasRelatedWork W2359938236 @default.
- W1998415522 hasRelatedWork W2377387014 @default.
- W1998415522 hasRelatedWork W2390300537 @default.
- W1998415522 hasRelatedWork W2939420034 @default.
- W1998415522 hasRelatedWork W2966731274 @default.
- W1998415522 hasVolume "11" @default.
- W1998415522 isParatext "false" @default.
- W1998415522 isRetracted "false" @default.
- W1998415522 magId "1998415522" @default.
- W1998415522 workType "article" @default.