Workload Management Systems for the Cloud Environment

2017 ◽  
pp. 94-113
Author(s):  
Eman A. Maghawry ◽  
Rasha M. Ismail ◽  
Nagwa. L. Badr ◽  
Mohamed F. Tolba
Keyword(s):  
Response Time ◽  
Performance Management ◽  
Management System ◽  
Database Management System ◽  
Cloud Environment ◽  
Workload Management ◽  
The Core ◽  
Query Response Time ◽  
Virtual Resources ◽  
Core Problem

Workload Management is a performance management process in which an autonomic database management system on a cloud environment efficiently makes use of its virtual resources. Workload management for concurrent queries is one of the challenging aspects of executing queries over the cloud. The core problem is to manage any unpredictable overload with respect to varying resource capabilities and performances. This chapter proposes an efficient workload management system for controlling the queries execution over a cloud. The chapter presents architecture to improve the query response time. It handles the user's queries then selecting the suitable resources for executing these queries. Furthermore, managing the life cycle of virtual resources through responding to any load that occurs on the resources. This is done by dynamically rebalancing the queries distribution load across the resources in the cloud. The results show that applying this Workload Management System improves the query response time by 68%.

The Frame Study of Translation System Design Based on Database Management

2014 ◽  
Vol 644-650 ◽  
pp. 3185-3188
Author(s):  
Li Hong Liu ◽  
Fan Jun Meng ◽  
Ying Lei ◽  
Yang Sun ◽  
Jia Qing Mu ◽  
...  
Keyword(s):  
System Design ◽  
Information Integration ◽  
Management System ◽  
Database Management ◽  
Industrial Development ◽  
Database Management System ◽  
Management Theory ◽  
Translation System ◽  
Management Level ◽  
The Core

In this paper, a database management system as the core, to study the system design framework for the translation industry database of information integration and database management theory proposes that the translation of translation technology industrial development and improving management level.

The Brief as Information System

2014 ◽  
pp. 20-90
Keyword(s):  
Information System ◽  
Management System ◽  
Database Management ◽  
Database Management System ◽  
The Core ◽  
Core Module ◽  
Security Levels ◽  
General Explanation

In this chapter, the author focuses on how a brief can be stored and processed with a database management system. This is an important step in brief computerization that precedes designing and connection to CAD or BIM programs. The chapter starts with a general explanation of what a database is and then consider a simple, single-table database of activities specified in a brief. This table then forms the core module of a multitable database that can accommodate more aspects, from users and security levels to fixtures and facilities. One sees how the design of such databases can help organize brief information in a structured and transparent manner and how queries of various types facilitate presentation of the content of the brief as well as analyses of completeness, consistency, and coherence.

Dynamic Workload for Schema Evolution in Data Warehouses

2010 ◽  
pp. 28-46
Author(s):  
Fadila Bentayeb ◽  
Cécile Favre ◽  
Omar Boussaid
Keyword(s):  
Data Warehouse ◽  
Management System ◽  
Heterogeneous Data ◽  
Database Management System ◽  
Main Issue ◽  
Data Sources ◽  
Schema Evolution ◽  
Data Warehouses ◽  
Workload Management ◽  
On Line

A data warehouse allows the integration of heterogeneous data sources for identified analysis purposes. The data warehouse schema is designed according to the available data sources and the users’ analysis requirements. In order to provide an answer to new individual analysis needs, the authors previously proposed, in recent work, a solution for on-line analysis personalization. They based their solution on a user-driven approach for data warehouse schema evolution which consists in creating new hierarchy levels in OLAP (on-line analytical processing) dimensions. One of the main objectives of OLAP, as the meaning of the acronym refers, is the performance during the analysis process. Since data warehouses contain a large volume of data, answering decision queries efficiently requires particular access methods. The main issue is to use redundant optimization structures such as views and indices. This implies to select an appropriate set of materialized views and indices, which minimizes total query response time, given a limited storage space. A judicious choice in this selection must be cost-driven and based on a workload which represents a set of users’ queries on the data warehouse. In this chapter, the authors address the issues related to the workload’s evolution and maintenance in data warehouse systems in response to new requirements modeling resulting from users’ personalized analysis needs. The main issue is to avoid the workload generation from scratch. Hence, they propose a workload management system which helps the administrator to maintain and adapt dynamically the workload according to changes arising on the data warehouse schema. To achieve this maintenance, the authors propose two types of workload updates: (1) maintaining existing queries consistent with respect to the new data warehouse schema and (2) creating new queries based on the new dimension hierarchy levels. Their system helps the administrator in adopting a pro-active behaviour in the management of the data warehouse performance. In order to validate their workload management system, the authors address the implementation issues of their proposed prototype. This latter has been developed within client/server architecture with a Web client interfaced with the Oracle 10g DataBase Management System.

scholarly journals Re-optimization for Multi-objective Cloud Database Query Processing using Machine Learning

2021 ◽  
Vol 13 (1) ◽  
pp. 21-40
Author(s):  
Chenxiao Wang ◽  
Zach Arani ◽  
Le Gruenwald ◽  
Laurent d'Orazio ◽  
Eleazar Leal
Keyword(s):  
Machine Learning ◽  
Response Time ◽  
Cost Estimation ◽  
Service Providers ◽  
Database Management System ◽  
Query Execution ◽  
Execution Plan ◽  
Query Optimizer ◽  
Query Response Time ◽  
Cloud Database

In cloud environments, hardware configurations, data usage, and workload allocations are continuously changing. These changes make it difficult for the query optimizer of a cloud database management system (DBMS) to select an optimal query execution plan (QEP). In order to optimize a query with a more accurate cost estimation, performing query re-optimizations during the query execution has been proposed in the literature. However, some of there-optimizations may not provide any performance gain in terms of query response time or monetary costs, which are the two optimization objectives for cloud databases, and may also have negative impacts on the performance due to their overheads. This raises the question of how to determine when are-optimization is beneficial. In this paper, we present a technique called ReOptML that uses machine learning to enable effective re-optimizations. This technique executes a query in stages, employs a machine learning model to predict whether a query re-optimization is beneficial after a stage is executed, and invokes the query optimizer to perform the re-optimization automatically. The experiments comparing ReOptML with existing query re-optimization algorithms show that ReOptML improves query response time from 13% to 35% for skew data and from 13% to 21% for uniform data, and improves monetary cost paid to cloud service providers from 17% to 35% on skewdata.

Research on Framework Structure for Scientific Research Management System

2013 ◽  
Vol 385-386 ◽  
pp. 1776-1779 ◽  
Author(s):  
Kai He You ◽  
Li Jun Li ◽  
Mei Zhi Zhao
Keyword(s):  
Relational Database ◽  
Management System ◽  
Database Design ◽  
Database Management System ◽  
Research Management ◽  
Security Requirements ◽  
Functional Requirements ◽  
Modern Information Technology ◽  
The Core ◽  
Diagram Logic

Archive management system based on modern information technology as the support, the archives information as management object, the archives work as the core and implement management information system, database design is the core work of the development of archives management system work, this article launches the research from four aspects according to the database design process. First, from the business requirements, functional requirements, performance requirements, such as security requirements for demand analysis; Second, according to the result of requirement analysis, conceptual design using E-R diagram; Third, converting E-R diagram logic structure supported by the database management system; Fourth, for the logic model to determine the storage structure and access method. In this paper, it based on the relational database design, a relational database with full-text database is the development direction of the future.

Database Design for Archives Management System

2013 ◽  
Vol 385-386 ◽  
pp. 1734-1737
Author(s):  
Kai He You ◽  
Hong Yan Li ◽  
Sheng Zhao
Keyword(s):  
Relational Database ◽  
Management System ◽  
Database Design ◽  
Database Management System ◽  
Security Requirements ◽  
Functional Requirements ◽  
Modern Information Technology ◽  
The Core ◽  
Diagram Logic ◽  
Business Requirements

Archive management system based on modern information technology as the support, the archives information as management object, the archives work as the core and implement management information system, database design is the core work of the development of archives management system work, this article launches the research from four aspects according to the database design process. First, from the business requirements, functional requirements, performance requirements, such as security requirements for demand analysis; Second, according to the result of requirement analysis, conceptual design using E-R diagram; Third, converting E-R diagram logic structure supported by the database management system; Fourth, for the logic model to determine the storage structure and access method. In this paper, it based on the relational database design, a relational database with full-text database is the development direction of the future.

Sign in / Sign up

Export Citation Format

Share Document