Query Optimization of A Distributed Database System Using Fuzzy Logic
Journal Title: International Journal of Engineering and Science Invention - Year 2018, Vol 7, Issue 1
Abstract
Query optimization of a system is the process of modifying or enhancing that system, so that some aspect of the system works more efficiently and makes use of fewer resources. Generally, a query is optimized so that it can execute more rapidly, operate with less memory or resources. The objectives of this paper are to design a distributed system that optimizes queries and processors, and to develop effective query execution plans for mining distributed database with the use of fuzzy logic. The system was implemented by developing a suitable framework for query processing in a distributed system that is time dependent, and a fuzzy logic approach was employed based on linguistic terminology for flexible user query. The result obtained shows fuzzy queries will always take less response time as compared to normal SQL queries. As observed, this is due to the fact that query evaluation engine does not have to search all the records in a database, it searches the records within the fuzzy range value alone.
Authors and Affiliations
O. T. Timi- Johnsonand, P. O. Asagba.
Keywords
Related Articles
- EP ID EP396005
- DOI -
- Views 60
- Downloads 0
A highly fault tolerant Multimedia Cloud Streaming approach for private cloud
Traditional multimedia services include the various services such as Streaming, Video conferencing, content sharing, real-time monitoring and broadcasting. If the multimedia services rely on the client systems for their...
CeO2 activated ZnO-TiO2 thick film for CO2 gas sensor
Nanocrystalline ZnO-TiO2 (molar ratio 9:1, 7:3, 1:1, 3:7 and 1:9) synthesized by hydrothermal method. The synthesized materials were used to prepare the thick films and gas sensing characteristics of prepared thick films...
Water Supply and Waterbornes Diseases in the Population of ZaKpota Commune (Benin, West Africa)
The population of the common Za-kpota is subjected to several difficulties bound at the access to the drinking water. This survey aims to identify and to analyze the problems of provision in drinking water and the risks...
High-Dimensional Information Filtering Using Query Reorganization Algorithms
The information filtering system used to publish information needs of clients and relevant information to a server with repeated queries. Indexing schemes holding quick meet of incoming information with query database ar...
Performance of Hollow Sections with and Without Infill under Compression and Flexure
Composite column are structural members, which are mainly subjected to forces and end moments. The steel tube serves as a formwork for casting the concrete, which reduces the construction cost. No other reinforcement is...