Matches in SemOpenAlex for { <https://semopenalex.org/work/W2295218607> ?p ?o ?g. }
- W2295218607 endingPage "568" @default.
- W2295218607 startingPage "557" @default.
- W2295218607 abstract "The introduction of columnar in-memory databases, along with hardware evolution, has made the execution of transactional and analytical workloads on a single system both feasible and viable. Yet, doing analytics directly on the transactional data introduces an increasing amount of resourceintensive aggregate queries which can slow down the overall system performance in a multi-user environment. To increase the scalability of a system in the presence of multiple such queries, we propose an aggregate cache in the general delta-main architecture that provides an ecient means to handle costly aggregate queries by applying incremental materialized view maintenance and query compensation techniques. Handling aggregate queries based on joins of multiple tables however is still a challenge as query compensation can be very expensive in the delta-main architecture of columnar in-memory databases. Our analysis of enterprise applications has revealed several data schema and workload patterns that can be leveraged for addressing performance of query processing using the aggregate cache. We contribute by presenting an approach to transport the application object semantics into the database system, becoming object-aware, and optimize the query processing using the aggregate cache by applying partition pruning and predicate pushdown in such general delta-main architecture. Our experimental validation using customer data and workloads confirms that this type of optimizations enables ecient usage of the aggregate cache for an even higher share of aggregate queries as one mean to scale the system." @default.
- W2295218607 created "2016-06-24" @default.
- W2295218607 creator A5035480309 @default.
- W2295218607 creator A5051434400 @default.
- W2295218607 creator A5073243444 @default.
- W2295218607 creator A5076938453 @default.
- W2295218607 creator A5091899147 @default.
- W2295218607 date "2015-01-01" @default.
- W2295218607 modified "2023-09-23" @default.
- W2295218607 title "Using Object-Awareness to Optimize Join Processing in the SAP HANA Aggregate Cache" @default.
- W2295218607 cites W1019310909 @default.
- W2295218607 cites W1502629466 @default.
- W2295218607 cites W1527733826 @default.
- W2295218607 cites W1908185546 @default.
- W2295218607 cites W1943411325 @default.
- W2295218607 cites W1969877208 @default.
- W2295218607 cites W1977330283 @default.
- W2295218607 cites W1981420413 @default.
- W2295218607 cites W2019270771 @default.
- W2295218607 cites W2039910065 @default.
- W2295218607 cites W2040428289 @default.
- W2295218607 cites W2059009730 @default.
- W2295218607 cites W2068901259 @default.
- W2295218607 cites W2072764742 @default.
- W2295218607 cites W2073824505 @default.
- W2295218607 cites W2075451706 @default.
- W2295218607 cites W2091459966 @default.
- W2295218607 cites W2092954093 @default.
- W2295218607 cites W2102729946 @default.
- W2295218607 cites W2104945737 @default.
- W2295218607 cites W2108991785 @default.
- W2295218607 cites W2116476518 @default.
- W2295218607 cites W2118260817 @default.
- W2295218607 cites W2118385974 @default.
- W2295218607 cites W2126321570 @default.
- W2295218607 cites W2131165411 @default.
- W2295218607 cites W2153704625 @default.
- W2295218607 cites W2185787741 @default.
- W2295218607 cites W2189182482 @default.
- W2295218607 cites W2248652221 @default.
- W2295218607 cites W2251728956 @default.
- W2295218607 cites W2764491622 @default.
- W2295218607 hasPublicationYear "2015" @default.
- W2295218607 type Work @default.
- W2295218607 sameAs 2295218607 @default.
- W2295218607 citedByCount "0" @default.
- W2295218607 crossrefType "proceedings-article" @default.
- W2295218607 hasAuthorship W2295218607A5035480309 @default.
- W2295218607 hasAuthorship W2295218607A5051434400 @default.
- W2295218607 hasAuthorship W2295218607A5073243444 @default.
- W2295218607 hasAuthorship W2295218607A5076938453 @default.
- W2295218607 hasAuthorship W2295218607A5091899147 @default.
- W2295218607 hasConcept C115537543 @default.
- W2295218607 hasConcept C120314980 @default.
- W2295218607 hasConcept C135572916 @default.
- W2295218607 hasConcept C148840519 @default.
- W2295218607 hasConcept C173608175 @default.
- W2295218607 hasConcept C199360897 @default.
- W2295218607 hasConcept C201932085 @default.
- W2295218607 hasConcept C2778692605 @default.
- W2295218607 hasConcept C41008148 @default.
- W2295218607 hasConcept C48044578 @default.
- W2295218607 hasConcept C54239708 @default.
- W2295218607 hasConcept C77088390 @default.
- W2295218607 hasConcept C98199447 @default.
- W2295218607 hasConceptScore W2295218607C115537543 @default.
- W2295218607 hasConceptScore W2295218607C120314980 @default.
- W2295218607 hasConceptScore W2295218607C135572916 @default.
- W2295218607 hasConceptScore W2295218607C148840519 @default.
- W2295218607 hasConceptScore W2295218607C173608175 @default.
- W2295218607 hasConceptScore W2295218607C199360897 @default.
- W2295218607 hasConceptScore W2295218607C201932085 @default.
- W2295218607 hasConceptScore W2295218607C2778692605 @default.
- W2295218607 hasConceptScore W2295218607C41008148 @default.
- W2295218607 hasConceptScore W2295218607C48044578 @default.
- W2295218607 hasConceptScore W2295218607C54239708 @default.
- W2295218607 hasConceptScore W2295218607C77088390 @default.
- W2295218607 hasConceptScore W2295218607C98199447 @default.
- W2295218607 hasOpenAccess W2295218607 @default.
- W2295218607 hasRelatedWork W1540805497 @default.
- W2295218607 hasRelatedWork W185219737 @default.
- W2295218607 hasRelatedWork W1978259029 @default.
- W2295218607 hasRelatedWork W2011300314 @default.
- W2295218607 hasRelatedWork W2016231742 @default.
- W2295218607 hasRelatedWork W2051852836 @default.
- W2295218607 hasRelatedWork W2064082451 @default.
- W2295218607 hasRelatedWork W2117538598 @default.
- W2295218607 hasRelatedWork W2138096440 @default.
- W2295218607 hasRelatedWork W2228891258 @default.
- W2295218607 hasRelatedWork W2244434443 @default.
- W2295218607 hasRelatedWork W2250332863 @default.
- W2295218607 hasRelatedWork W2281839741 @default.
- W2295218607 hasRelatedWork W2514758784 @default.
- W2295218607 hasRelatedWork W2564770017 @default.
- W2295218607 hasRelatedWork W3105820654 @default.
- W2295218607 hasRelatedWork W1747431430 @default.
- W2295218607 hasRelatedWork W196545957 @default.
- W2295218607 hasRelatedWork W2182186088 @default.