A near real time Data Warehouse using the MeshJoin Algorithm

Overview

MeshJoin-Data-Warehouse

A near real time Data Warehouse using the MeshJoin Algorithm

Steps to run the project:

Step 1:

Run the createDW.sql file -This will create a new schema with the name 'dwhproject'
and create the DWH Tables.

Step 2:

Run the Transaction_and_MasterData_Generator.sql file - This will create the transactions and 
masterdata tables in the same schema 'dwhproject'

Step 3:

Open Eclipse. And Click on Import Project from the File Settings

Step 4:

Select 'General' and then 'Existing Projects into Workspace'

Step 5:

Select the submitted folder 'meshJoin' as the root directory and click on Finish

Step 6:

If required the username and password of MySQL might have to be adjusted.
Navigate to the DBConnect.java file in the source folder.
On line 13, enter the Name of the host, and on line 14 enter the password

Step 7:

On the navigation bar, click on Run to Run the project

Step 8:

This step is not compulsory, however, if there is an error in running code, it is probably
because some other projects main file is still configured.
To configure the current projects file, click on the down arrow next to run, then run
configurations, then click on new launch configuration, if the project is not imported,
then click on browse and select your project folder. Then click on search and select the main class.
Then you can run/click apply. 

Step 9:

Run the queriesDW.sql file to get the DWH analysis

Note: The steps HAVE to be done in the specific order, for correct execution.

You might also like...

Just-In-Time Access is an AppEngine application that lets you manage just-in-time privileged access to Google Cloud projects.

Just-In-Time Access is an AppEngine application that lets you manage just-in-time privileged access to Google Cloud projects.

Just-In-Time Access Just-In-Time Access is an AppEngine application that lets you manage just-in-time privileged access to Google Cloud projects. Syno

Jan 3, 2023

Applied Spring Data JPA technologies including mapping, connecting real DB, Hibernate, Queries, Paging & Sorting, various Relationships, Transactions

Applied Spring Data JPA technologies including mapping, connecting real DB, Hibernate, Queries, Paging & Sorting, various Relationships, Transactions

University Management In this project, I practiced & applied Spring Data JPA technologies including mapping, connecting real DB, Hibernate, Queries, P

Sep 5, 2022

Ship React Native .jsbundles compressed by Brotli algorithm.

Ship compressed JS bundles Warning: not yet available for Android. Sometimes you need a very small .app, for example if you are building an App Clip.

Nov 15, 2022

Sequence Alignment - Aligns two strings optimally as to minimize the cost of alignment. This algorithm has applications in aligning DNA, RNA, or protein.

Sequence_Alignment Aligns two strings optimally as to minimize the cost of alignment. This algorithm has applications in aligning DNA, RNA, or protein

Jan 8, 2022

Hashids algorithm v1.0.0 implementation in Java

Hashids.java A small Java class to generate YouTube-like hashes from one or many numbers. Ported from javascript hashids.js by Ivan Akimov What is it?

Dec 29, 2022

A fast and reliable Java micro-library which chooses the sorting algorithm that best fits your needs and sorts the parameter.

A fast and reliable Java micro-library which chooses the sorting algorithm that best fits your needs and sorts the parameter.

Feb 19, 2022

We are proceeding Algorithm Study from January, 2022.

AlgorithmStudy2022 We are proceeding Algorithm Study from January, 2022. 2022년 1월 부터 스터디를 진행하고 있습니다. The 1st quarter: 우리는 첫 시즌을 마무리 하였습니다. 첫 시즌은 알고리즘

Jul 5, 2022

We are proceeding Algorithm Study from July, 2022.

Coding Test in Java 백준 고난이도 문제 👩🏻‍💻 7월 4주차 (07.25 - 07.31) 문제 레벨 URL 승희 코드 호진 코드 수진 코드 연의 코드 문제 가져온 사람 문제 승희 문제 호진 문제 수진 문제 연의 👩🏻‍💻 7월 3주차 (07.1

Jul 13, 2022

Mentoring: Abstracting real-world situations with Object Orientation

Mentoring: Abstracting real-world situations with Object Orientation

Mentoria: Abstraindo situações do mundo real com Orientação a Objetos O objetivo principal é colocar em prática umas das principais ferramentas da OO:

Feb 11, 2022
Owner
M. Adil Fayyaz
M. Adil Fayyaz
Warehouse management REST API with Java & Spring Boot

Spring Warehouse Spring Warehouse is a Java Spring Boot REST API that has the purpose of managing products and articles in your warehouse. This projec

Josep Bigorra 40 Dec 15, 2022
Presti 5 Nov 19, 2022
LOQUI - Real-time chat application built using Apache Kafka, Java, Spring Boot, SockJS and React

LOQUI is a simple real-time chat application that demonstrates how to use Apache Kafka as a message broker along with Java, Spring Boot and React on the front-end

Castanho Correia 2 Jun 5, 2022
A real-time ray tracer in Java, accelerated on heterogeneous hardware using TornadoVM

Java Ray Tracer for TornadoVM Description This project aims to build a real-time ray tracer in Java, accelerated on heterogeneous hardware using Torna

null 10 May 23, 2022
Search API with spelling correction using ngram-index algorithm: implementation using Java Spring-boot and MySQL ngram full text search index

Search API to handle Spelling-Corrections Based on N-gram index algorithm: using MySQL Ngram Full-Text Parser Sample Screen-Recording Screen.Recording

Hardik Singh Behl 5 Dec 4, 2021
Person Apri development in real time

Digital Innovation: Expert class - Desenvolvendo um sistema de gerenciamento de pessoas em API REST com Spring Boot Nesta live coding vamos desenvolve

Vitor Nunes 1 Nov 11, 2021
This app corrects your sitting posture and provides feedback in real time in conjunction with the app. A sensor of 31 cells detects your posture to get better life-wellness

Notichair 실시간 자세분석 및 교정 스마트체어 ?? 상명대학교 PRIME 경진대회 수상 ?? 요구사항 31-cell sensor (mdxs-16-5610) 목차 1. 소개 프로젝트 내용 소개 2. 개발 환경 사전 설정 및 환경 구축 3. 기능 Sensors Ap

Minuk_LEE 3 Jan 15, 2022
corrects your sitting posture and provides feedback in real time in conjunction with the app. A sensor of 31 cells detects your posture to get better life-wellness

Notichair 실시간 자세분석 및 교정 스마트체어 ?? 상명대학교 PRIME 경진대회 수상 ?? 요구사항 31-cell sensor (mdxs-16-5610) 목차 1. 소개 프로젝트 내용 소개 2. 개발 환경 사전 설정 및 환경 구축 3. 기능 Sensors Ap

Minuk_LEE 3 Jan 15, 2022
Source code of course - Building Real-Time REST APIs with Spring Boot

springboot-blog-rest-api Learn how to build real-time REST APIs with Spring Boot by building a complete Blog App. Source code of Popular Building Real

Ramesh Fadatare 123 Jan 6, 2023
Minecraft configurable plugin , which sends messages the first time a player logs into the server or the next time they log in.

JoinMessages Minecraft configurable plugin , which sends messages the first time a player logs into the server or the next time they log in or leave.

ᴠᴀʟᴇɴᴛɪɴ ᴢʜᴇʟᴇᴠ 6 Aug 30, 2022