A collection of database engineering projects covering SQL query optimization, graph databases, and data modeling — from relational algebra to real-world performance tuning.
This portfolio showcases hands-on experience with database systems, from conceptual design to production-level optimization. Each project tackles real-world data challenges using industry-standard tools and techniques.
Conceptual modeling and schema design for complex applications.
- ER modeling with Chen and UML/Crow's Foot notation
- Normalization and schema analysis for production databases
- Relational schema design from requirements to implementation
- Real-world use cases: art collections, sports analytics, transportation systems
Advanced SQL querying on a global geographic database extended with pandemic data.
- Relational algebra formulations with LaTeX notation
- Complex SQL queries on SQLite (joins, subqueries, aggregations)
- Data integration between geographic and health statistics
- 16 production-ready SQL queries + theoretical foundations
Performance tuning for high-volume transactional databases.
- Indexing strategies for multi-million row datasets
- Materialized views and pre-computed aggregations
- Time-series optimization with batch processing
- Real performance benchmarks and optimization techniques
Graph database modeling for geopolitical relationships.
- Cypher queries for pathfinding and topology analysis
- Graph modeling from relational data (countries, borders, continents)
- Complex traversals with variable-length paths
- Robust queries handling edge cases and alternate world maps
Each project is self-contained with its own data and documentation:
# SQL queries on Mondial databasecd mondial-covid-queries && sqlite3 mondial.db < sql-queries.sql
# Optimized queries with performance analysiscd query-optimization && sqlite3 purchases.db < optimized-queries.sql
# Neo4J graph queriescd neo4j-graph-analysis
# Start Neo4J: JAVA_HOME=/path/to/jdk ./neo4j start# Run: cypher-shell < cypher-queries.sql| SQL (SQLite) | Relational queries and optimization |
| Neo4J + Cypher | Graph database modeling and traversals |
| Relational Algebra | Formal query theory with LaTeX |
| ER Modeling | Conceptual design with Dia, Diagrams.net |
| Python | Data analysis and benchmarking scripts |
QueryLab/
├── database-design/ # ER models, normalization, schema design
├── mondial-covid-queries/ # SQL + relational algebra on Mondial DB
├── query-optimization/ # Performance tuning and indexing
├── neo4j-graph-analysis/ # Graph DB with Cypher queries
└── README.md # This file
Each folder contains:
- Complete implementations with sample data
- Detailed README with setup instructions
- Technical reports (PDF) with design decisions
- Guidelines and problem statements
 | Mathis DELSART |
This project is developed for academic purposes as part of university coursework.
Built for LINFO2172 - Databases @ UCLouvain (Universite catholique de Louvain).