Matches in SemOpenAlex for { <https://semopenalex.org/work/W180697668> ?p ?o ?g. }
Showing items 1 to 73 of
73
with 100 items per page.
- W180697668 abstract "Multiple concurrent queries occur in many database settings. This dissertation explores two such settings, one in which the system being examined generates the queries and one in which the system processes multiple incoming queries. In the former case, we originally set out to explore the performance of a particular algorithm for incremental maintenance of a materialized view in a data warehouse. In the process, we discovered that at a realistic database size, unexpected issues with the query and update processing had to be understood and dealt with before the results would be meaningful. The development of this understanding is as much to the point as the particular experimental results because they illuminate the significance of the experimental environment for research. The experiment proper validates that incremental maintenance is feasible over a wide range of update sizes (granularities ), and that in all cases a cursor-based version of the algorithm performs the best. For the second part, we explore using middleware as an optimization tool for multiple concurrent queries. Observing that common subexpressions derive from common data, and that the amount of data is usually greatest at the source, we propose an optimization technique that exploits the presence of sharable access patterns to underlying data, especially scans of large portions of tables or indexes, in environments where query queuing or batching is an acceptable approach. We show that simultaneous queries with such sharable accesses have a tendency to form synchronous groups (teams) which benefit each other through the operation of the disk cache, in effect using it as an implicit pipeline. We propose exploiting this tendency by scheduling the queries to enhance this tendency, and show that this can be accomplished in some systems even from outside the database engine with application server middleware. We present an algorithm for scheduling from a queue of similar queries, designed to promote such teamwork. This is implemented as middleware for use with a commercial database engine. Finally, we present tests using the query mix from the TPC-R benchmark, achieving a speedup of 2.34 over the default scheduling provided by one database, but also show that the success depends on the details of the computing environment." @default.
- W180697668 created "2016-06-24" @default.
- W180697668 creator A5006471754 @default.
- W180697668 creator A5039292004 @default.
- W180697668 date "2002-01-01" @default.
- W180697668 modified "2023-10-17" @default.
- W180697668 title "On tuning and optimization for multiple queries in databases" @default.
- W180697668 hasPublicationYear "2002" @default.
- W180697668 type Work @default.
- W180697668 sameAs 180697668 @default.
- W180697668 citedByCount "0" @default.
- W180697668 crossrefType "journal-article" @default.
- W180697668 hasAuthorship W180697668A5006471754 @default.
- W180697668 hasAuthorship W180697668A5039292004 @default.
- W180697668 hasConcept C115537543 @default.
- W180697668 hasConcept C124101348 @default.
- W180697668 hasConcept C135572916 @default.
- W180697668 hasConcept C148840519 @default.
- W180697668 hasConcept C157692150 @default.
- W180697668 hasConcept C165696696 @default.
- W180697668 hasConcept C173608175 @default.
- W180697668 hasConcept C177264268 @default.
- W180697668 hasConcept C199360897 @default.
- W180697668 hasConcept C2776990265 @default.
- W180697668 hasConcept C38652104 @default.
- W180697668 hasConcept C41008148 @default.
- W180697668 hasConcept C54239708 @default.
- W180697668 hasConcept C77088390 @default.
- W180697668 hasConcept C98045186 @default.
- W180697668 hasConcept C98199447 @default.
- W180697668 hasConceptScore W180697668C115537543 @default.
- W180697668 hasConceptScore W180697668C124101348 @default.
- W180697668 hasConceptScore W180697668C135572916 @default.
- W180697668 hasConceptScore W180697668C148840519 @default.
- W180697668 hasConceptScore W180697668C157692150 @default.
- W180697668 hasConceptScore W180697668C165696696 @default.
- W180697668 hasConceptScore W180697668C173608175 @default.
- W180697668 hasConceptScore W180697668C177264268 @default.
- W180697668 hasConceptScore W180697668C199360897 @default.
- W180697668 hasConceptScore W180697668C2776990265 @default.
- W180697668 hasConceptScore W180697668C38652104 @default.
- W180697668 hasConceptScore W180697668C41008148 @default.
- W180697668 hasConceptScore W180697668C54239708 @default.
- W180697668 hasConceptScore W180697668C77088390 @default.
- W180697668 hasConceptScore W180697668C98045186 @default.
- W180697668 hasConceptScore W180697668C98199447 @default.
- W180697668 hasLocation W1806976681 @default.
- W180697668 hasOpenAccess W180697668 @default.
- W180697668 hasPrimaryLocation W1806976681 @default.
- W180697668 hasRelatedWork W1536175790 @default.
- W180697668 hasRelatedWork W1995709578 @default.
- W180697668 hasRelatedWork W1997031082 @default.
- W180697668 hasRelatedWork W2100485384 @default.
- W180697668 hasRelatedWork W2160770337 @default.
- W180697668 hasRelatedWork W2313759748 @default.
- W180697668 hasRelatedWork W2317524302 @default.
- W180697668 hasRelatedWork W2324553357 @default.
- W180697668 hasRelatedWork W2613362222 @default.
- W180697668 hasRelatedWork W2774442918 @default.
- W180697668 hasRelatedWork W3011535584 @default.
- W180697668 hasRelatedWork W3080912532 @default.
- W180697668 hasRelatedWork W3160252689 @default.
- W180697668 hasRelatedWork W3172924990 @default.
- W180697668 hasRelatedWork W46389115 @default.
- W180697668 hasRelatedWork W1604701457 @default.
- W180697668 hasRelatedWork W2203841546 @default.
- W180697668 hasRelatedWork W2210572452 @default.
- W180697668 hasRelatedWork W2556786504 @default.
- W180697668 hasRelatedWork W2861001945 @default.
- W180697668 isParatext "false" @default.
- W180697668 isRetracted "false" @default.
- W180697668 magId "180697668" @default.
- W180697668 workType "article" @default.