Wael Mohamed

Dr. Wael Mohamed

Faculty of Computers and Artificial Intelligence, Helwan, Egypt
orcid

Research Focus & Metrics

Academic Career Length

6Years (2021-Present)

(Calculated once Scilit publication data is synced: current year − year of first publication + 1)

Representative Publications

View All Publications
Verified
Journal Article
Open access
PDF file
MAManal A. Abdel-Fattah
Manal A. Abdel-Fattah
WMWael Mohamed
Wael Mohamed
SASayed Abdelgaber
Sayed Abdelgaber
Currently, the continuous massive growth in the size, variety, and velocity of data is defined as big data. Relational databases have a limited ability to work with big data. Consequently, not only structured query language (NoSQL) databases were utilized to handle big data because NoSQL represents data in diverse models and uses a variety of query languages, unlike traditional relational databases. Therefore, using NoSQL has become essential, and many studies have attempted to propose different layers to convert relational databases to NoSQL; however, most of them targeted only one or two models of NoSQL, and evaluated their layers on a single node, not in a distributed environment. This study proposes a Spark-based layer for mapping relational databases to NoSQL models, focusing on the document, column, and key–value databases of NoSQL models. The proposed Spark-based layer comprises of two parts. The first part is concerned with converting relational databases to document, column, and key–value databases, and encompasses two phases: a metadata analyzer of relational databases and Spark-based transformation and migration. The second part focuses on executing a structured query language (SQL) on the NoSQL. The suggested layer was applied and compared with Unity, as it has similar components and features and supports sub-queries and join operations in a single-node environment. The experimental results show that the proposed layer outperformed Unity in terms of the query execution time by a factor of three. In addition, the proposed layer was applied to multi-node clusters using different scenarios, and the results show that the integration between the Spark cluster and NoSQL databases on multi-node clusters provided better performance in reading and writing while increasing the dataset size than using a single node.

Verified
Journal Article
Open access
PDF file
hossam hassanhossam hassan
hossam hassan
MAManal A. Abdel-Fattah
Manal A. Abdel-Fattah
WMWael Mohamed
Wael Mohamed
Over the past decade, many software enterprises have migrated from monolithic to microservice architectures to enhance scalability, maintainability, and performance. However, this transition presents significant challenges, requiring considerable development efforts, research, customization, and resource allocation over extended periods. Furthermore, the success of migration is not guaranteed, highlighting the complexities organizations face in modernizing their software systems. To address these challenges, this study introduces Mono2Micro, a comprehensive framework designed to automate the migration process while preserving structural integrity and optimizing service boundaries. The framework focuses on three core patterns: database patterns, service decomposition, and communication patterns. It leverages machine learning algorithms, including Random Forest and Louvain clustering, to analyze database query patterns along with static and dynamic database model analysis, which enables the identification of relationships between models, facilitating the systematic decomposition of microservices while ensuring efficient inter-service communication. To validate its effectiveness, Mono2Micro was applied to a student information system for faculty management, demonstrating its ability to streamline the migration process while maintaining functional integrity. The proposed framework offers a systematic and scalable solution for organizations and researchers seeking efficient migration from monolithic systems to microservices.

1 January 2022 in International Journal of Business Intelligence and Data Mining
Verified
Journal Article
Closed access
WMWael Mohamed
Wael Mohamed
MFManal A. Abdel Fattah
Manal A. Abdel Fattah
Frequent itemset mining is one of the most important data mining techniques applied to discover frequent itemset, interesting information, and correlation from data. Many algorithms such as Apriori...

16 October 2026 in Information
Verified
Journal Article
Open access
PDF file
Sherif Ragab ELdemerdashSherif Ragab ELdemerdash
Sherif Ragab ELdemerdash
OEOsama E. Emam
Osama E. Emam
MAManal A. Abdel-Fattah
Manal A. Abdel-Fattah
WMWael Mohamed
Wael Mohamed
Extract, Transform, and Load (ETL) and Online Analytical Processing (OLAP) provide robust mechanisms for integrating structured data and supporting multidimensional analysis. Still, they offer limited support for semantic access to unstructured textual content. This study proposes an integrated architecture that combines conventional ETL and data warehousing with semantic retrieval based on dense vector representations and similarity search. The architecture separates structured analytical processing from semantic document retrieval while preserving traceability among source documents, warehouse records, and vector representations. The architecture was examined through an implementation-oriented case study using a large document collection of up to 1.58 million PDF files. The study reports descriptive implementation observations on data ingestion, vector indexing, and query execution in the deployed environment. These observations characterize the operational behavior of the implemented system and are not presented as a controlled performance benchmark between OLAP and semantic retrieval, because the two mechanisms address different classes of information needs. The architecture also provides a query-time foundation for downstream Retrieval-Augmented Generation (RAG); however, this study does not assess generative response quality or LLM orchestration as case-study outcomes. Accordingly, this work contributes primarily through the architectural integration of structured analytical processing and semantic retrieval, preservation of document-to-warehouse-to-vector traceability, and practical implementation of the framework over a large enterprise document repository. The study also identifies limitations related to repeated timing measurements, stage-level profiling, independently annotated relevance judgments, and retrieval-effectiveness assessment. These limitations define future work involving Precision@k, Recall@k, MRR, nDCG, controlled workload benchmarking, and systematic evaluation of RAG-generated responses.

30 June 2021
Verified
Journal Article
Closed access
WMWael Mohamed
Wael Mohamed
MAM.A. Abdel-Fattah
M.A. Abdel-Fattah
SAS. Abdelgaber
S. Abdelgaber

11 February 2026 in Information
Verified
Journal Article
Open access
PDF file
SKSaad Moawad Khalifa
Saad Moawad Khalifa
MMMohamed Marie
Mohamed Marie
WMWael Mohamed
Wael Mohamed
The increasing scale and imbalance of modern network traffic pose significant challenges for multi-class intrusion detection systems (IDSs), particularly in identifying rare attack types. Traditional intrusion detection approaches based on supervised classification or unsupervised anomaly detection often suffer from limited generalization under severe class imbalance, high-dimensional feature spaces, and noisy traffic, resulting in poor detection of minority attack classes. To address these limitations, this study presents a hybrid intrusion detection framework that integrates unsupervised feature learning, anomaly scoring, and supervised classification within a unified pipeline. A denoising autoencoder trained exclusively on normal traffic is employed to learn compact and noise-resistant feature representations, while an isolation forest independently generates statistical anomaly scores. These complementary features are then fused and classified using a Light Gradient Boosting Machine (LightGBM). The main contribution of this work lies in the effective integration of these components, combined with a balanced training strategy based on the Synthetic Minority Over-sampling Technique with Edited Nearest Neighbors (SMOTE-ENN), as well as robust validation procedures. The framework is evaluated on the Network Security Laboratory Knowledge Discovery and Data Mining dataset (NSL-KDD) and the UNSW-NB15 intrusion detection dataset using stratified cross-validation and multiple independent runs. Experimental results demonstrate consistently high classification accuracy (~99%) and strong macro-F1 performance (>97%) across all attack categories on both NSL-KDD and UNSW-NB15 datasets. The framework achieves exceptional detection of rare classes (R2L: 99% F1, U2R: 100% F1), significantly outperforming prior approaches (AE-SAC: 83.97% F1, RL-NIDS: poor U2R recall), while maintaining low inference latency (~2–3 ms per sample, 415 samples/second) suitable for real-time network security deployment.