Skip to content

faiyaz106/Query-performance-comparison-in-PostgreSQL

Repository files navigation

Compare the performance of different queries in PostgreSQL against the IMDb dataset with and without indexing.

1. About the data set:

1.1 Real database of IMDb movies.It contains 7 tables. It contains details of several relation between movies, directors, genre, actors and roles.

1.2 Source Link: https://relational.fit.cvut.cz/dataset/IMDb
1.3 Drive link for Preprocessed file: https://drive.google.com/drive/folders/15w7b6ar95Ilu1CY50FdT_DxlxV0Uq11X?usp=sharing

2. Objective of this project:

2.1 To design an ER Model for a real-world dataset and translate into SQL schema.
2.2 To populate data into database using DML statements.
2.3. To write SQL queries.
2.4. To deploy indexing into database.
2.5. To measure the performance of SQL queries with and without indexing

For more details, please refer to the attached project report.

Results: Query Performance Comparison

image

image

Releases

No releases published

Packages

No packages published

Languages