Sherif Ragab ELdemerdash

Dr. Sherif Ragab ELdemerdash

information system, Faculty of Computers and Artificial Intelligence, Helwan, Egypt
orcid

Research Focus & Metrics

Academic Career Length

2Years (2025-Present)

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

Representative Publications

View All Publications
12 December 2025 in Research Square
Verified
Preprint
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
WAWael Mohamed Abass
Wael Mohamed Abass
The importance of data warehouses (DWH) in all companies cannot be denied. Online analytical processing (OLAP) is a crucial component of a data warehouse (DWH). Business data serves as the input for creating valuable information essential for a business's sustainability. It comes from a variety of sources and takes many different forms, from traditional structured data to unstructured data. A vector database is a specific type of database that stores data in multidimensional vectors, representing traits or attributes. The process of transforming high-dimensional data, including unstructured text and images, into a representation with fewer dimensions is known as embedding in vector database usage. Vector embeddings are structured numerical representations generated from unstructured data, such as text and images, using modern techniques that preserve semantic notions of similarity and difference in the vector morphology. DWH systems are always designed with structured data in mind. However, as the volume of unstructured data grows exponentially, organizations need more complex methods to understand, represent, and analyze this material. In this case, vector databases offer a ground-breaking answer. To enable vector database technology in data warehouses and handle unstructured data, it is necessary to employ modern techniques, such as Retrieval Augmented Generation (RAG). The recently proposed approach offers a viable method for building an unstructured data warehouse.

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.