{"title":"Structured query language query join optimization by using rademacher averages and mapreduce algorithms","authors":"Yathish Aradhya Bandur Chandrashekariah, D. H. A.","doi":"10.11591/eei.v13i3.6837","DOIUrl":"https://doi.org/10.11591/eei.v13i3.6837","url":null,"abstract":"Query optimization involves identifying and implementing the most effective and efficient methods and strategies to enhance the performance of queries. This is achieved by intelligently utilizing system resources and considering various performance metrics. Table joining optimization involves optimizing the process of combining two or more tables within a database. Structured query language (SQL) optimization is the progress of utilizing SQL queries in the possible way to achieve fast and accurate database results. SQL optimization is critical to decreasing the no of queries in research description framework (RDF) and the time for processing a huge number of relatable data. In this paper, four new algorithms are proposed such as hash-join, sort-merge, rademacher averages and mapreduce for the progress of SQL query join optimization. The proposed model is evaluated and tested using waterloo sparql diversity test suite (WatDiv) and lehigh university benchmark (LUBM) benchmark datasets in terms of time execution. The results represented that the proposed method achieved an enhanced performance of less execution time for various queries such as Q3 of 5362, Q8 of 5921, Q9 of 5854 and Q10 of 5691 milliseconds. The proposed gives better performance than other existing methods like hybrid database-map reduction system (AQUA+) and join query processing (JQPro).","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"11 3","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141235604","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
D. Kannan, Amutha Balakrishnan, K. M. Devi, Nagendra Singh, P. A. Kiruba, R. Ramkumar, D. Karthikeyan
{"title":"Hybrid rater to quantify and measure the severity of infection and spread of infection in muskmelon","authors":"D. Kannan, Amutha Balakrishnan, K. M. Devi, Nagendra Singh, P. A. Kiruba, R. Ramkumar, D. Karthikeyan","doi":"10.11591/eei.v13i3.5432","DOIUrl":"https://doi.org/10.11591/eei.v13i3.5432","url":null,"abstract":"Disease severity index (DIS) is a way of calculating the percentage of infection spread across the field. The percentage of infection in each leaf has been considered at a time stamp is being calculated and based on that disease, severity of disease spread is analyzed. With the advancement in machine learning and deep learning algorithms in the field of computer vision, identification and classification of diseases is effortless. Percentage of infection in a particular leaf, disease index (DI) is calculated using image processing techniques like Otsu threshold method. With this DI and scales, grading the severity of the infection across the field can be achieved. In this paper various scales used for grading severity of infection namely Horsfall-Barratt (H-B scale) quantitative ordinal scale, Amended 20% ordinal scale, and nearest percent estimates (NPEs) in muskmelon is explored, and based on the empirical results Amended 20% ordinal scale is most efficient method of estimating the DIS is to use the midpoint of the severity scope for each class with twenty percent adjusted to ordinal scale. The results show that the density of leaves is directly proportional to spread of diseases in muskmelon plant.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"58 12","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141231622","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Dissecting of the two-stages object detection models architecture and performance","authors":"Sara Bouraya, A. Belangour","doi":"10.11591/eei.v13i3.6424","DOIUrl":"https://doi.org/10.11591/eei.v13i3.6424","url":null,"abstract":"Artificial intelligence (AI) is the discipline focused on enabling computers to operate autonomously without explicit programming. Within AI, computer vision is an emerging field tasked with endowing machines with the ability to interpret visual data from images and videos. Over recent decades, computer vision has found applications in diverse fields such as autonomous vehicles, information retrieval, surveillance, and understanding human behavior. Object detection, a key aspect of computer vision, employs deep neural networks to continually advance detection accuracy and speed. Its goal is to precisely identify objects within images or videos and assign them to specific classes. Object detection models typically consist of three components: a backbone network for feature extraction, a neck model for feature aggregation, and a head for prediction. The focus of this study lies on two stage detectors. This study aims to provide a comprehensive review of two stage detectors in object detection, followed by benchmarking to offer insights for researchers and scientists. By analyzing and understanding the efficacy of these models, this research seeks to guide future developments in the field of object detection within computer vision.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"4 7","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141230125","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
K. Rahouma, Shahenda Mahmoud Mabrouk, Mohamed Aouf
{"title":"Automated 3D convolutional neural network architecture design using genetic algorithm for pulmonary nodule classification","authors":"K. Rahouma, Shahenda Mahmoud Mabrouk, Mohamed Aouf","doi":"10.11591/eei.v13i3.6828","DOIUrl":"https://doi.org/10.11591/eei.v13i3.6828","url":null,"abstract":"Cancer of the lungs is considered one of the primary causes of death among patients globally. Early detection contributes significantly to the success of pulmonary cancer treatment. To aid the pulmonary nodule classification, many models for the analysis of medical image utilizing deep learning have been developed. Convolutional neural network (CNN) recently, has attained remarkable results in various image classification tasks. Nevertheless, the CNNs performance is heavily dependent on their architectures which still heavily reliant on human domain knowledge. This study introduces a cutting-edge approach that leverages genetic algorithms (GAs) to automatically design 3D CNN architectures for differentiation between benign and malignant pulmonary nodules. The suggested algorithm utilizes the dataset of lung nodule analysis 2016 (LUNA16) for evaluation. Notably, our approach achieved exceptional model accuracy, with evaluations on the testing dataset yielding up to 95.977%. Furthermore, the algorithm exhibited high sensitivity, showcasing its robust performance in distinguishing between benign and malignant nodules. Our findings demonstrate the outstanding capabilities of the proposed algorithm and show an outstanding performance and attain a state of art solution in lung nodule classification.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"48 26","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141232235","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"A cost-effective ECG monitoring in rural areas: leveraging artificial neural networks for efficient healthcare solutions","authors":"Md. Obaidur Rahaman, M. A. Kashem","doi":"10.11591/eei.v13i3.6866","DOIUrl":"https://doi.org/10.11591/eei.v13i3.6866","url":null,"abstract":"Cardiovascular diseases engender serious public health concerns in developing nations since access to specialized medical equipment is often limited and standard treatment expenses can be prohibitive. This study proposes an efficient and relatively affordable electrocardiogram (ECG) monitoring system that reads and analyzes a person's electrocardiogram data to provide affordable and quality healthcare solutions. The device initially extracts features from electrocardiogram records by reading electrical signals in the heart. Extracted data are then analyzed by a trained deep learning model to determine precisely if the heart is in a healthy state or undergoing complexities. Experimental results showed that the fine-tuned ANN architecture outperformed the state-of-the-art architectures in this field with an accuracy of 98.95%. The data can also be sent to specialists through an MQTT server if necessary, allowing for remote diagnosis and treatment. The system is intended to be deployed in countries where rural regions lack access to specialized healthcare equipment and professionals. Additionally, the device is inexpensive and, hence can be made accessible to people with limited affordability.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"38 48","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141232595","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
Tawfiq Alrawashdeh, Ibrahim Alkore Alshalabi, Moha'med Al-Jaafreh, M. Alksasbeh
{"title":"Smart indoor gardening: elevating growth, health, and automation","authors":"Tawfiq Alrawashdeh, Ibrahim Alkore Alshalabi, Moha'med Al-Jaafreh, M. Alksasbeh","doi":"10.11591/eei.v13i3.7101","DOIUrl":"https://doi.org/10.11591/eei.v13i3.7101","url":null,"abstract":"Recently, indoor systems for growing plants have emerged as a promising approach to address the problems related to extreme weather conditions outdoors. However, such systems must manage the plants surrounding environments to satisfy the environmental and the economical requirements. In this line, any proposed solution must address challenging factors such as plants diseases and unordinary climate situations. In this paper, propose an internet of things (IoT) indoor system that can be used to facilitate the plant growing process. The proposed system is designed to provide alternatives for outdoor climate dependency such as the vitamins provided through sunlight. Moreover, renewable energy sources (sunlight) are employed to reduce the impact on the environment. With the help of several types of sensors, the system continuously monitors the plants through their growing journey. Whereas actuator devices are employed to control the plant-feeding process based on the sensors’ reported values. All the collected data will be uploaded to the cloud for analysis, utilizing a website. Additionally, the architecture of the provided system eliminates the need for human involvement, which has a degrading effect on the plant growing process.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"39 25","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141232697","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Load frequency control of interconnected power system using cuckoo search algorithm","authors":"Soumya Mishra, Pujari Harish Kumar, Rajarajan Ramasamy, Renjini Edayillam Nambiar, Praveena Puvvada","doi":"10.11591/eei.v13i3.6714","DOIUrl":"https://doi.org/10.11591/eei.v13i3.6714","url":null,"abstract":"This paper presents a new time-domain multi-objective function approach for solving load frequency control issue in an interconnected power system. The performance of interconnected power system in each area is validated for overshoot and settling time values of frequency change and tie-line power exchange. An objective function is created with the goal of enhancing proportional integral derivative (PID) controller settings by reducing overshoot and achieving faster time-domain settling times. The efficiency of the proposed time-domain multi-objective function is evaluated in a two-area thermal power plant using a nature-inspired cuckoo search optimization (CSA) technique. By comparing the time-domain simulation results of the test system with the existing integral error-based objective functions IAE, ISE, ITAE, and ITSE, the proposed objective function is validated. Further, a sensitivity analysis were carried out to analyze the robustness of the proposed multi-objective function under various uncertain conditions.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"11 6","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141229624","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Speed synchronization of two DC motors with independent loads based on the higher load torque","authors":"Ali Saqer Akayleh, Addasi Emad Said","doi":"10.11591/eei.v13i3.6188","DOIUrl":"https://doi.org/10.11591/eei.v13i3.6188","url":null,"abstract":"Dual-motor and multi-motor electric drive systems have been used in many industrial applications, and speed synchronization of the motors can always get worse by system parameter uncertainties and load torque perturbations. This work focuses on the application of adjustable speed double-direct current (DC) motor drive control systems. In this paper, a system of two DC motors with armature control at different load conditions has been built. The synchronization of these motors was set basing on the higher torque of the two motor shafts. When two DC motors operate at different shafts a challenge appears in synchronization of their speeds, particularly with the existence of load difference allocated on their shafts. This work paid special attention to this problem. It presents a dynamic simulation of speed control and synchronization of dual DC motor drive. The results show the advantages of the used technique in terms of steady-state and transient performance.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"7 10","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141230545","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"User authentication using gait and enhanced attribute-based encryption: a case of smart home","authors":"Lim Wei Pin, Manmeet Mahinderjit Singh","doi":"10.11591/eei.v13i3.5347","DOIUrl":"https://doi.org/10.11591/eei.v13i3.5347","url":null,"abstract":"With the increasing popularity of the internet of things (IoT) application such as smart home, more data is being collected, and subsequently, concerns about preserving the privacy and confidentiality of these data are growing. When intruders attack and get control of smart home devices, privacy is compromised. Attribute-based encryption (ABE) is a new technique proposed to solve the data privacy issue in smart homes. However, ABE involves high computational cost, and the length of its ciphertext/private key increases linearly with the number of attributes, thus limiting the usage of ABE. This study proposes an enhanced ABE that utilises gait profile. By combining lesser number of attributes and generating a profiling attribute that utilises gait, the proposed technique solves two issues: computational cost and one-to-one encryption. Based on experiment conducted, computational time has been reduced by 55.27% with nine static attributes and one profile attribute. Thus, enhanced ABE is better in terms of computational time.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"29 5","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141234217","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}
{"title":"Early prediction of COVID-19 infection using data mining and multi machine learning algorithms","authors":"Ahmed Jaddoa Enad, Mustafa Aksu","doi":"10.11591/eei.v13i3.6912","DOIUrl":"https://doi.org/10.11591/eei.v13i3.6912","url":null,"abstract":"The fields of artificial intelligence (AI) and machine learning (ML) have attracted significant interest and investment from a diverse range of industries, especially during the last several years. Despite the fact that AI methods have been used extensively and put through extensive testing in the healthcare industry, the recently discovered coronavirus disease (COVID-19) necessitates the use of these methods in order to prevent the emergence of the disease. The proposed system is based on six ML algorithms to predict COVID-19 infection as random forest (RF) algorithm, naive bayes (NB) algorithm, support vector machine (SVM) algorithm, decision tree (DT) algorithm, multi-layer perceptron (MLP), and k-nearest neighbor (KNN). It is based on two steps: first, we uploaded the dataset to train the model. Then, we test our model on those cases to work directly after making a trained classifier so it can directly discover with automatic COVID-19 prediction state of a patient suspected or not. The proposed system results showed the high accuracy of NB, DT, and SVM as 98.646%. Besides the better time to build the model and early predict the state of patients is 31 ms of the NB algorithm.","PeriodicalId":502860,"journal":{"name":"Bulletin of Electrical Engineering and Informatics","volume":"8 12","pages":""},"PeriodicalIF":0.0,"publicationDate":"2024-06-01","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":null,"resultStr":null,"platform":"Semanticscholar","paperid":"141229470","PeriodicalName":null,"FirstCategoryId":null,"ListUrlMain":null,"RegionNum":0,"RegionCategory":"","ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":"","EPubDate":null,"PubModel":null,"JCR":null,"JCRName":null,"Score":null,"Total":0}