Matches in SemOpenAlex for { <https://semopenalex.org/work/W2110171642> ?p ?o ?g. }
Showing items 1 to 84 of
84
with 100 items per page.
- W2110171642 endingPage "338" @default.
- W2110171642 startingPage "333" @default.
- W2110171642 abstract "Database administration (tuning) is the process of adjusting database configurations in order to accomplish desirable performance goals. This job is performed by human operators called database administrators (DBAs) who are generally well-paid, and are becoming more and more expensive with the increasing complexity and scale of modern databases. There has been considerable effort dedicated to reducing such cost (which often dominates the total ownership cost of missioncritical databases) by making database tuning more automated and transparent to users (Chaudhuri et al, 2004; Chaudhuri and Weikum, 2006). Research in this area seeks ways to automate the hardware deployment, physical database design, parameter configuration, and resource management in such systems. The goal is to achieve acceptable performance on the whole system level without (or with limited) human intervention. According to Weikum et al. (2002), problems in this category can be stated as: workload × configuration (?) ? performance which means that, given the features of the incoming workload to the database, we are to find the right settings for all system knobs such that the performance goals are satisfied The following two are representatives of a series of such tuning problems in different databases: • Problem 1: Maintenance of multi-class servicelevel agreements (SLA) in relational databases. Database service providers usually offer various levels of performance guarantees to requests from different groups of customers. Fulfillment of such guarantees (SLAs) is accomplished by allocating different amounts of system resources to different queries. For example, query response time is negatively related to the amount of memory buffer assigned to that query. We need to dynamically allocate memory to individual queries such that the absolute or relative response times of queries from different users are satisfied. • Problem 2: Load shedding in stream databases. Stream databases are used for processing data generated continuously from sources such as a sensor network. In streaming databases, data processing delay, i.e., the time consumed to process a data point, is the most critical performance metric (Tatbul et al., 2003). The ability to remain within a desired level of delay is significantly hampered under situations of overloading (caused by bursty data arrivals and time-varying unit data processing cost). When overloaded, some data is discarded (i.e., load shedding) in order to keep pace with the incoming load. The system needs to continuously adjust the amount of data to be discarded such that 1) delay is maintained under a desirable level; 2) data is not discarded unnecessarily." @default.
- W2110171642 created "2016-06-24" @default.
- W2110171642 creator A5032673243 @default.
- W2110171642 creator A5049372794 @default.
- W2110171642 date "2011-05-24" @default.
- W2110171642 modified "2023-09-23" @default.
- W2110171642 title "Control-Based Database Tuning Under Dynamic Workloads" @default.
- W2110171642 cites W1510252230 @default.
- W2110171642 cites W1581905079 @default.
- W2110171642 cites W2015244008 @default.
- W2110171642 cites W2099023682 @default.
- W2110171642 cites W2105301439 @default.
- W2110171642 cites W2117133207 @default.
- W2110171642 cites W2127789375 @default.
- W2110171642 cites W2128581929 @default.
- W2110171642 cites W2148275477 @default.
- W2110171642 doi "https://doi.org/10.4018/978-1-60566-010-3.ch053" @default.
- W2110171642 hasPublicationYear "2011" @default.
- W2110171642 type Work @default.
- W2110171642 sameAs 2110171642 @default.
- W2110171642 citedByCount "1" @default.
- W2110171642 countsByYear W21101716422012 @default.
- W2110171642 crossrefType "book-chapter" @default.
- W2110171642 hasAuthorship W2110171642A5032673243 @default.
- W2110171642 hasAuthorship W2110171642A5049372794 @default.
- W2110171642 hasConcept C105339364 @default.
- W2110171642 hasConcept C107535962 @default.
- W2110171642 hasConcept C111919701 @default.
- W2110171642 hasConcept C115842085 @default.
- W2110171642 hasConcept C115903868 @default.
- W2110171642 hasConcept C148840519 @default.
- W2110171642 hasConcept C206345919 @default.
- W2110171642 hasConcept C31258907 @default.
- W2110171642 hasConcept C41008148 @default.
- W2110171642 hasConcept C54239708 @default.
- W2110171642 hasConcept C5968703 @default.
- W2110171642 hasConcept C70236469 @default.
- W2110171642 hasConcept C77088390 @default.
- W2110171642 hasConcept C78161392 @default.
- W2110171642 hasConcept C98045186 @default.
- W2110171642 hasConceptScore W2110171642C105339364 @default.
- W2110171642 hasConceptScore W2110171642C107535962 @default.
- W2110171642 hasConceptScore W2110171642C111919701 @default.
- W2110171642 hasConceptScore W2110171642C115842085 @default.
- W2110171642 hasConceptScore W2110171642C115903868 @default.
- W2110171642 hasConceptScore W2110171642C148840519 @default.
- W2110171642 hasConceptScore W2110171642C206345919 @default.
- W2110171642 hasConceptScore W2110171642C31258907 @default.
- W2110171642 hasConceptScore W2110171642C41008148 @default.
- W2110171642 hasConceptScore W2110171642C54239708 @default.
- W2110171642 hasConceptScore W2110171642C5968703 @default.
- W2110171642 hasConceptScore W2110171642C70236469 @default.
- W2110171642 hasConceptScore W2110171642C77088390 @default.
- W2110171642 hasConceptScore W2110171642C78161392 @default.
- W2110171642 hasConceptScore W2110171642C98045186 @default.
- W2110171642 hasLocation W21101716421 @default.
- W2110171642 hasOpenAccess W2110171642 @default.
- W2110171642 hasPrimaryLocation W21101716421 @default.
- W2110171642 hasRelatedWork W2018124398 @default.
- W2110171642 hasRelatedWork W2032973114 @default.
- W2110171642 hasRelatedWork W2292573290 @default.
- W2110171642 hasRelatedWork W2588668873 @default.
- W2110171642 hasRelatedWork W2626577989 @default.
- W2110171642 hasRelatedWork W2768116780 @default.
- W2110171642 hasRelatedWork W2900365206 @default.
- W2110171642 hasRelatedWork W2919595180 @default.
- W2110171642 hasRelatedWork W2966230969 @default.
- W2110171642 hasRelatedWork W2988833907 @default.
- W2110171642 hasRelatedWork W2997657375 @default.
- W2110171642 hasRelatedWork W3006238248 @default.
- W2110171642 hasRelatedWork W3008227672 @default.
- W2110171642 hasRelatedWork W3012041020 @default.
- W2110171642 hasRelatedWork W3031176702 @default.
- W2110171642 hasRelatedWork W3092052573 @default.
- W2110171642 hasRelatedWork W3096576649 @default.
- W2110171642 hasRelatedWork W3157860380 @default.
- W2110171642 hasRelatedWork W3206344511 @default.
- W2110171642 hasRelatedWork W85762181 @default.
- W2110171642 isParatext "false" @default.
- W2110171642 isRetracted "false" @default.
- W2110171642 magId "2110171642" @default.
- W2110171642 workType "book-chapter" @default.