StarRocks is a next-gen sub-second MPP database for full analytics scenarios, including multi-dimensional analytics, real-time analytics and ad-hoc query.
Data Warehousing (DW) Project Building and Analysing a DW for NatureFresh Stores in NZ, built using a high-performance Oracle database 12c, and Index-Nested Loops Join-Oracle.
A project to design a fact and dimension star schema for optimizing queries on a flight booking database using PostgreSQL, a relational database management system. This schema is well-suited for a flight booking database, as it allows for efficient querying of data such as booking dates, flight routes, and passenger information.
A full data analysis report using SQL queries from a data warehouse with a star schema. The report answers why server downtime happens and how it can be fixed.
This repository is about designing a database model for Global Super Store. This project is the final project of the 7th course "Advanced Data Modeling" of Meta Database Engineer Professional Certificate on Coursera.