Canada Spends Logo

Explorez notre analyse du budget 2026

Grant: Collaborative Research and Development Grants

University of Toronto

$89,917.00

Dynamic resource allocation for database servers

EF 2008-09

Résumé
The proposed project will investigate autonomic system adaptations to reduce the need for human-directed management of large-scale Internet server systems. Autonomic systems monitor and dynamically adapt their behavior to meet preset goals or behavioral requirements. Large-scale cluster systems are often present in organizations that provide dynamic content services such as e-commerce, on-line banking, stock trading and gaming. Such services generate content on-the-fly based on persistent state stored in databases. Database systems have traditionally been used to run a single application at a given time on a stand-alone database engine. Typically, in this configuration, an expert administrator could determine the optimal database settings for that application. This is not the case with large data centers, where multiple applications, such as, e-commerce, auctions and news, are commonly hosted concurrently on the same hardware, in order to reduce costs. The diverse nature of applications that may share the same infrastructure makes configuration and performance tuning difficult and time consuming. Furthermore, the increasing size of the large-scale cluster systems serving dynamic content makes them prone to failures. Recovering from failures, as well as activities aimed at reducing the probability of failures, such as, system backup take up a significant portion of personnel time and introduce the potential for human operator errors. We propose to develop autonomic database system mechanisms that will continually monitor and optimize performance and will automate failure recovery in dynamic content servers, thus, reducing or eliminating the human effort currently required. Specifically, we will investigate dynamic allocation of resources to applications in response to either performance bottlenecks or faults at the level of: i) database server nodes and ii) resources inside a database server node. Our proposed work is expected to lower the total cost of system management, while at the same time provide improved quality of service, thus benefit information technology companies and their customers.
Programme
Collaborative Research and Development Grants
Bénéficiaire
Emplacement
Ontario, Canada
Type de bénéficiaire
Academia
Type
Grant
Source
NSERC's Awards Data

Tel que publié

Application id
349008-2006
Name nom
Amza, Cristiana
Department département
Electrical and Computer Engineering, Edward S. Rogers Sr. Department of
Organization id
31
Institution établissement
University of Toronto
Province en
Ontario
Province fr
Ontario
Country en
CANADA
Country fr
CANADA
Fiscal year exercice financier
2008
Competition year année de concours
2006
Award amount
89917
Program id
CRDPJ
Program nane en
Collaborative Research and Development Grants
Program name fr
Subventions de recherche et développement coopérative
Group en
Research partnerships programs
Group fr
Programmes de partenariat
Committee code
96
Committee name en
RPP Internal Decision Cttee
Committee name fr
Cté de décision interne - PPR
Area of application code
802
Area of application group en
Information and communication services
Area of application group fr
Services d'information et de télécommunications
Area of application en
Information systems and technology
Area of application fr
Systèmes d'information et technologie de l'information
Research subject code
2710
Research subject group en
Information technology
Research subject group fr
Technologie de l'information
Research subject en
Information systems design
Research subject fr
Conception de systèmes d'information
Partie
2
Nb partie
2
Application title
Dynamic resource allocation for database servers
Keyword
NA
Application summary
The proposed project will investigate autonomic system adaptations to reduce the need for human-directed management of large-scale Internet server systems. Autonomic systems monitor and dynamically adapt their behavior to meet preset goals or behavioral requirements. Large-scale cluster systems are often present in organizations that provide dynamic content services such as e-commerce, on-line banking, stock trading and gaming. Such services generate content on-the-fly based on persistent state stored in databases. Database systems have traditionally been used to run a single application at a given time on a stand-alone database engine. Typically, in this configuration, an expert administrator could determine the optimal database settings for that application. This is not the case with large data centers, where multiple applications, such as, e-commerce, auctions and news, are commonly hosted concurrently on the same hardware, in order to reduce costs. The diverse nature of applications that may share the same infrastructure makes configuration and performance tuning difficult and time consuming. Furthermore, the increasing size of the large-scale cluster systems serving dynamic content makes them prone to failures. Recovering from failures, as well as activities aimed at reducing the probability of failures, such as, system backup take up a significant portion of personnel time and introduce the potential for human operator errors. We propose to develop autonomic database system mechanisms that will continually monitor and optimize performance and will automate failure recovery in dynamic content servers, thus, reducing or eliminating the human effort currently required. Specifically, we will investigate dynamic allocation of resources to applications in response to either performance bottlenecks or faults at the level of: i) database server nodes and ii) resources inside a database server node. Our proposed work is expected to lower the total cost of system management, while at the same time provide improved quality of service, thus benefit information technology companies and their customers.