Matches in SemOpenAlex for { <https://semopenalex.org/work/W172504425> ?p ?o ?g. }
- W172504425 endingPage "10" @default.
- W172504425 startingPage "3" @default.
- W172504425 abstract "Tuning database system configuration parameters to proper values according to the expected query workload plays a very important role in determining DBMS performance. However, the number of configuration parameters in a DBMS is very large. Furthermore, typical query workloads have a large number of constituent queries, which makes tuning very time and effort intensive. To reduce tuning time and effort, database administrators rely on their experience and some rules of thumb to select a set of important configuration parameters for tuning. Nonetheless, as a statistically rigorous methodology is not used, time and effort may be wasted by tuning those parameters which may have no or marginal effects on the DBMS performance for the given query workload. Database administrators also use compressed query workloads to reduce tuning time. If not carefully selected, the compressed query workload may fail to include a query which may reveal important performance bottleneck parameters. In this article, we provide a systematic approach to help the database administrators in tuning activities. We achieve our goals through two phases. First, we estimate the effects of the configuration parameters for each workload query. The effects are estimated through a design of experiments-based PLACKETT & BURMAN design methodology where the number of experiments required is linearly proportional to the number of input parameters. Second, we exploit the estimated effects to: 1) rank DBMS configuration parameters for a given query workload based on their impact on the DBMS performance, and 2) select a compressed query workload that preserves the fidelity of the original workload. Experimental results using PostgreSQL and TPC-H query workload show that our methodologies are working correctly." @default.
- W172504425 created "2016-06-24" @default.
- W172504425 creator A5007454642 @default.
- W172504425 creator A5046274165 @default.
- W172504425 creator A5090091276 @default.
- W172504425 date "2008-01-01" @default.
- W172504425 modified "2023-09-26" @default.
- W172504425 title "Exploiting the Impact of Database System Configuration Parameters: A Design of Experiments Approach." @default.
- W172504425 cites W1516570087 @default.
- W172504425 cites W1553825122 @default.
- W172504425 cites W1576035775 @default.
- W172504425 cites W1589154916 @default.
- W172504425 cites W1603054734 @default.
- W172504425 cites W1890845846 @default.
- W172504425 cites W2006901874 @default.
- W172504425 cites W2083658889 @default.
- W172504425 cites W2097055266 @default.
- W172504425 cites W2097175800 @default.
- W172504425 cites W2115258141 @default.
- W172504425 cites W74024549 @default.
- W172504425 cites W85402190 @default.
- W172504425 hasPublicationYear "2008" @default.
- W172504425 type Work @default.
- W172504425 sameAs 172504425 @default.
- W172504425 citedByCount "2" @default.
- W172504425 countsByYear W1725044252013 @default.
- W172504425 countsByYear W1725044252014 @default.
- W172504425 crossrefType "journal-article" @default.
- W172504425 hasAuthorship W172504425A5007454642 @default.
- W172504425 hasAuthorship W172504425A5046274165 @default.
- W172504425 hasAuthorship W172504425A5090091276 @default.
- W172504425 hasConcept C107535962 @default.
- W172504425 hasConcept C111919701 @default.
- W172504425 hasConcept C124101348 @default.
- W172504425 hasConcept C148840519 @default.
- W172504425 hasConcept C149635348 @default.
- W172504425 hasConcept C157692150 @default.
- W172504425 hasConcept C164120249 @default.
- W172504425 hasConcept C177264268 @default.
- W172504425 hasConcept C192939062 @default.
- W172504425 hasConcept C199360897 @default.
- W172504425 hasConcept C23123220 @default.
- W172504425 hasConcept C24028149 @default.
- W172504425 hasConcept C2778476105 @default.
- W172504425 hasConcept C2779729312 @default.
- W172504425 hasConcept C2780513914 @default.
- W172504425 hasConcept C41008148 @default.
- W172504425 hasConcept C54239708 @default.
- W172504425 hasConcept C70236469 @default.
- W172504425 hasConcept C77088390 @default.
- W172504425 hasConcept C97854310 @default.
- W172504425 hasConceptScore W172504425C107535962 @default.
- W172504425 hasConceptScore W172504425C111919701 @default.
- W172504425 hasConceptScore W172504425C124101348 @default.
- W172504425 hasConceptScore W172504425C148840519 @default.
- W172504425 hasConceptScore W172504425C149635348 @default.
- W172504425 hasConceptScore W172504425C157692150 @default.
- W172504425 hasConceptScore W172504425C164120249 @default.
- W172504425 hasConceptScore W172504425C177264268 @default.
- W172504425 hasConceptScore W172504425C192939062 @default.
- W172504425 hasConceptScore W172504425C199360897 @default.
- W172504425 hasConceptScore W172504425C23123220 @default.
- W172504425 hasConceptScore W172504425C24028149 @default.
- W172504425 hasConceptScore W172504425C2778476105 @default.
- W172504425 hasConceptScore W172504425C2779729312 @default.
- W172504425 hasConceptScore W172504425C2780513914 @default.
- W172504425 hasConceptScore W172504425C41008148 @default.
- W172504425 hasConceptScore W172504425C54239708 @default.
- W172504425 hasConceptScore W172504425C70236469 @default.
- W172504425 hasConceptScore W172504425C77088390 @default.
- W172504425 hasConceptScore W172504425C97854310 @default.
- W172504425 hasLocation W1725044251 @default.
- W172504425 hasOpenAccess W172504425 @default.
- W172504425 hasPrimaryLocation W1725044251 @default.
- W172504425 hasRelatedWork W1499773427 @default.
- W172504425 hasRelatedWork W2030958743 @default.
- W172504425 hasRelatedWork W2036656486 @default.
- W172504425 hasRelatedWork W2060845888 @default.
- W172504425 hasRelatedWork W2067365486 @default.
- W172504425 hasRelatedWork W2087030416 @default.
- W172504425 hasRelatedWork W2103600125 @default.
- W172504425 hasRelatedWork W2125628054 @default.
- W172504425 hasRelatedWork W2129337219 @default.
- W172504425 hasRelatedWork W2198746743 @default.
- W172504425 hasRelatedWork W2240476899 @default.
- W172504425 hasRelatedWork W2340045634 @default.
- W172504425 hasRelatedWork W2390643453 @default.
- W172504425 hasRelatedWork W2391673826 @default.
- W172504425 hasRelatedWork W2393237349 @default.
- W172504425 hasRelatedWork W2402485720 @default.
- W172504425 hasRelatedWork W3156866 @default.
- W172504425 hasRelatedWork W3192393081 @default.
- W172504425 hasRelatedWork W2124540493 @default.
- W172504425 hasRelatedWork W343046011 @default.
- W172504425 hasVolume "31" @default.
- W172504425 isParatext "false" @default.
- W172504425 isRetracted "false" @default.
- W172504425 magId "172504425" @default.