The rapid growth in the size of databases and the advances made in Query Languages has resulted in increased SQL query complexity submitted by users, which in turn slows down the speed of information retrieval from the database. The future of high performance database systems lies in parallelism. Commercial vendors’ database systems have introduced solutions but these have proved to be extremely expensive. This paper invistagete how networked resources such as workstations can be utilised by using Parallel Virtual Machine (PVM) to Optimise Database Query Execution. An investigation and experiments of the scalability of the PVM are conducted. PVM is used to implement parallelism in two separate ways: (i) Remove the work load for deriving and maintaining rules from the data server for Semantic Query Optimisation, therefore clears the way for more widespread use of SQO in databases [1,2]. (ii) Answer users queries by a proposed Parallel Query Algorithm PQA which works over a network of workstations, coupled with a sequential Database Management System DBMS called PostgreSql on the prototype called Expandable Server Architecture ESA [1,2,3,4]. Experiments have been conducted to tackle the problems of Parallel and Distributed systems such as task scheduling, load balance and fault tolerance.
목차
Abstract 1. Introduction 2. Environment and tools of the project 2.1. PVM scalability 3. Obstacle in Semantic Query Optimization approach 3.1. Sorting Data Subsets for Rulesset Derivation and Maintenance 3.2. Scan Bucket Algorithm to Derive Rules for SQO 3.3. Measuring the algorithms Performance 3.4. Consistency of the Rules 4. Network Resources for Answering Query 4.1. Expandable Server Architecture ESA 4.2. Parallel Query Algorithm PQA 4.3. Parallel Query Algorithm Components. 4.4. Dynamic Load Scheduling. 4.5. Data Placement. 5. Performance Evaluation for PQA on ESA: –on general purposeworkstation and on dedicated workstations 6. Conclusion References
저자
Mohammed Jaffer Alhaddad [ Department of Information Technology ]
보안공학연구지원센터(IJMUE) [Science & Engineering Research Support Center, Republic of Korea(IJMUE)]
설립연도
2006
분야
공학>컴퓨터학
소개
1. 보안공학에 대한 각종 조사 및 연구
2. 보안공학에 대한 응용기술 연구 및 발표
3. 보안공학에 관한 각종 학술 발표회 및 전시회 개최
4. 보안공학 기술의 상호 협조 및 정보교환
5. 보안공학에 관한 표준화 사업 및 규격의 제정
6. 보안공학에 관한 산학연 협동의 증진
7. 국제적 학술 교류 및 기술 협력
8. 보안공학에 관한 논문지 발간
9. 기타 본 회 목적 달성에 필요한 사업
간행물
간행물명
International Journal of Multimedia and Ubiquitous Engineering
간기
월간
pISSN
1975-0080
수록기간
2008~2016
등재여부
SCOPUS
십진분류
KDC 505DDC 605
이 권호 내 다른 논문 / International Journal of Multimedia and Ubiquitous Engineering Vol.4 No.2