Skip to content

youngfalcon/dbs_final_project

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

dbs_final_project

Author: Caglar Dogan cd2647 N18970424

For your information: The 'data' and 'models' files directly under the root in this repository are folders in which files downloaded from the azure blob (pre-trained ML models to be read or data to re-train ML models) are stored, as well as newly trained ML models.

This program is designed to be run with python3.

Moreover, the 'ODBC Driver 18 for SQL Server' is required for the connections to Azure SQL Server. Please see the following website on the directions to run this:

https://docs.microsoft.com/en-us/sql/connect/odbc/download-odbc-driver-for-sql-server?view=sql-server-ver16

The crucial Django/Azure specific dependencies for this program are:

Django==4.0.7 django-mssql-backend==2.8.1 django-storages==1.13.1 mssql-django==1.1.3 azure-core==1.25.0 azure-storage-blob==12.13.1

Moreover, the following libraries should also be present for the ML models: numpy pandas statistics pickle sklearn matplotlib

In the requirements.txt, a much bigger set of dependencies is presented representing the environemnt in which I ran my tests. In case of any problem, please use an environment which satisfies the environment presented in requirements.txt to be sure that everything is stable.

In any event, you can reach out to me via the following e-mail address: [email protected]

The provided file sql_script.txt is the last version of the forward-engineered SQL code for our database schema, and it includes specified physical design elements like indexes. It is very similar to the one presented for part 3, but I am presenting it again here for your observation. Please note that it is designed for Azure SQL Server.

About

Final Project Code for Caglar Dogan

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published