GitHub

The NBA Data Mart project transforms an OLTP database into an OLAP data mart using ETL processes, enabling efficient analysis and reporting of basketball data for informed ...

Extraction, transformation, and loading (ETL) of basketball-related transactional data Conversion from OLTP to OLAP schema optimized for analytics Support for multidimensional queries and reporting ...
GitHub

A modern Azure-based data lakehouse pipeline implementing the Medallion Architecture (Bronze, Silver, Gold layers) with automated ETL, OLTP-to-OLAP transformation, dynamic ...

Logs each step for traceability and debugging. OLTP Ingestion: Use src/oltp_ingest.py to extract transactional data from an operational database (e.g., SQL Server, PostgreSQL) and load it into the ...
IEEE

Specifying OLAP cubes on XML data

Abstract: On-Line Analytical Processing (OLAP) enables analysts to gain insight into data through fast and interactive access to a variety of possible views on information, organized in a dimensional ...
IEEE

K-means clustering visualization of web-based OLAP operations for hotspot data

Abstract: In the previous work we developed the web-based OLAP (On-line Analytical Processing) integrated with the data warehouse for hotspot data in Indonesia. This work aims to develop a ...