Andres Andrade-Cabrera

Mr. Andres Andrade-Cabrera

orcid

Research Focus & Metrics

Academic Career Length

3Years (2024-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
Diana Martinez-MosqueraDiana Martinez-Mosquera
Diana Martinez-Mosquera
RNRosa Navarrete
Rosa Navarrete
Sergio Luján-MoraSergio Luján-Mora
Sergio Luján-Mora
LRLorena Recalde
Lorena Recalde
AAAndres Andrade-Cabrera
Andres Andrade-Cabrera
The growing importance of data analytics is leading to a shift in data management strategy at many companies, moving away from simple data storage towards adopting Online Analytical Processing (OLAP) query analysis. Concurrently, NoSQL databases are gaining ground as the preferred choice for storing and querying analytical data. This article presents a comprehensive, systematic mapping, aiming to consolidate research efforts related to the integration of OLAP with NoSQL databases in Big Data environments. After identifying 1646 initial research studies from scientific digital repositories, a thorough examination of their content resulted in the acceptance of 22 studies. Utilizing the snowballing technique, an additional three studies were selected, culminating in a final corpus of twenty-five relevant articles. This review addresses the growing importance of leveraging NoSQL databases for OLAP query analysis in response to increasing data analytics demands. By identifying the most commonly used NoSQL databases with OLAP, such as column-oriented and document-oriented, prevalent OLAP modeling methods, such as Relational Online Analytical Processing (ROLAP) and Multidimensional Online Analytical Processing (MOLAP), and suggested models for batch and real-time processing, among other results, this research provides a roadmap for organizations navigating the integration of OLAP with NoSQL. Additionally, exploring computational resource requirements and performance benchmarks facilitates informed decision making and promotes advancements in Big Data analytics. The main findings of this review provide valuable insights and updated information regarding the integration of OLAP cubes with NoSQL databases to benefit future research, industry practitioners, and academia alike. This consolidation of research efforts not only promotes innovative solutions but also promises reduced operational costs compared to traditional database systems.


20 October 2026 in Information
Verified
Journal Article
Open access
PDF file
MAMarco Esteban Aguirre
Marco Esteban Aguirre
Carlos Antonio Ayala-TipanCarlos Antonio Ayala-Tipan
Carlos Antonio Ayala-Tipan
AAAndres Andrade-Cabrera
Andres Andrade-Cabrera
Diana Martinez-MosqueraDiana Martinez-Mosquera
Diana Martinez-Mosquera
LRLorena Recalde
Lorena Recalde
GSGabriela Suntaxi
Gabriela Suntaxi
Systematic literature reviews are essential for synthesizing scientific evidence but remain complex and resource-intensive processes that demand significant time and human effort. To reduce bias, they are usually conducted collaboratively and according to established methodologies. However, the way in which the process is documented, including the steps taken and the tools used, often depends on the author’s preferences or basic guidelines of traditional methodologies. This variability makes it difficult to interpret the procedure and results and limits reproducibility for other researchers. This work introduces the Hexagonal Systematic Literature Review (X-SLR) architecture as a framework designed to standardize the reporting of procedures and results in systematic literature reviews. The X-SLR is based on the ports and adapters model from software engineering, which separates the core logic of a system from the tools and platforms used to implement it. Applied to reviews, the model conceptualizes the research goals as a central core connected to six functional components (ports): search strategy, selection criteria, data extraction, quality assessment, analysis and synthesis, and reporting. Each port can be linked to various tools through adapters. The proposed framework provides a structured mechanism for documenting review procedures, tool integration, and methodological decisions. By explicitly documenting port contracts, adapter choices, and traceability links, X-SLR is intended to help researchers assess whether tool substitutions preserve methodological coherence. A conceptual proposal, representative tool configurations, and a demonstration scenario are presented to illustrate the framework. The framework was retrospectively evaluated by applying a 25-item reporting checklist to a previously published SLR. Two independent coders achieved 88.0% agreement (Cohen’s κ=0.82), and the resulting Documentation Coverage score was 0.48. A separate internal formative assessment with two systematic review practitioners provided preliminary evidence regarding the clarity, traceability, complementarity, and usefulness of the X-SLR representation. These results provide preliminary evidence supporting X-SLR as a reporting and traceability artifact, while prospective studies are required to assess its effects on review execution, efficiency, and substantive reproducibility.

1 September 2025
Verified
Book Chapter
Closed access
PDF file
Diana Martinez-MosqueraDiana Martinez-Mosquera
Diana Martinez-Mosquera
RNRosa Navarrete
Rosa Navarrete
LRLorena Recalde
Lorena Recalde
AAAndres Andrade-Cabrera
Andres Andrade-Cabrera

27 August 2026 in Applied Sciences
Verified
Journal Article
Open access
PDF file
AAAndres Andrade-Cabrera
Andres Andrade-Cabrera
Diana Martinez-MosqueraDiana Martinez-Mosquera
Diana Martinez-Mosquera
ICIvan Carrera
Ivan Carrera
Modern applications rely on diverse database types to store information efficiently, but interacting with these systems requires developers to master multiple specialized query languages. This fragments development, as engineers must write complex custom code for each database just to retrieve routine data. While existing big-data tools offer a unified query language, they force all data requests through heavy processing engines, degrading the fast performance required for everyday tasks. To address this problem, we introduce PolyFuseQL, a smart routing layer acting as a universal SQL translator for five popular databases (PostgreSQL, Redis, Neo4j, MongoDB, and Cassandra). Our objective is to allow developers to communicate transparently with diverse systems using standard SQL, completely avoiding the need to write specific NoSQL logic. Methodologically, PolyFuseQL dynamically evaluates standard SQL queries to determine the optimal execution path. It translates and sends simple requests directly to the native databases to ensure high speed while seamlessly routing complex analytical queries to a powerful Apache Spark engine. We evaluated the system’s performance across varying workloads. Results indicate that PolyFuseQL adds almost no delay to simple queries, preserving sub-millisecond response times. Concurrently, it enables users to execute complex operations, such as eight-table joins, on NoSQL databases that lack native relational support. Although a fixed processing delay during initial data translation slightly limits absolute hardware scaling, the system scales reliably for medium-sized analytical tasks. Ultimately, PolyFuseQL provides a unified, easy-to-use SQL interface to diverse NoSQL databases without sacrificing operational speed.