Advanced Databases

📌 Course Overview

This repository contains materials, notes, and projects related to the Advanced Databases course as part of the Data Science degree at IPN. The course focuses on designing and implementing decision support systems using non-relational databases, OLAP technologies, and data warehouses.

📖 Topics Covered

1. Decision Support Systems (DSS) and Data Warehouses

   • Characteristics and taxonomies of DSS
   • Architectures for DSS
   • Data Warehouses and Data Lakes

2. Design of Data Warehouses and Databases

   • Data Warehouse architectures
   • ETL (Extract, Transform, Load) processes

3. OLAP Cube Design

   • OLAP vs. OLTP
   • Data modeling for OLAP
   • OLAP operations (Roll-up, Drill-down, Slice, Dice)

4. Non-Relational Databases

   • Object-oriented databases
   • Document-oriented databases
   • Key-value stores
   • Graph databases
   • Emerging database trends

🔧 Prerequisites

To follow along with the course materials and projects, ensure you have:

• Basic knowledge of relational databases
• Familiarity with SQL and NoSQL
• Python and relevant database libraries installed (e.g., pymongo, sqlalchemy)

📂 Repository Structure

📦 AdvancedDatabases
 ┣ 📂 datasets                          # Datasets, databases and resources
 ┣ 📂 period1                           # Homework and exercises from Period 1
 ┣ 📂 period2                           # Homework and exercises from Period 2
 ┣ 📂 period3                           # Homework and exercises from Period 3
 ┣ 📜 basesDatosAvanzadas_LCD2020       # Course overview
 ┣ 📂 projects                          # Final projects and case studies
 ┣ 📜 README.md                         # This file

📚 Recommended Books

• "Introducción a la Minería de Datos" – Hernández, Ramírez & Ferri
• "The Data Warehouse Lifecycle Toolkit" – Kimball & Ross
• "Seven NoSQL Databases in a Week" – Ploetz et al.
• "NoSQL for Mere Mortals" – Sullivan

💡 How to Contribute

Contributions are welcome! To collaborate:

1. Fork this repository
2. Clone it to your local machine
3. Create a new branch: git checkout -b feature-name
4. Commit your changes: git commit -m 'Added new content'
5. Push to your fork: git push origin feature-name
6. Submit a Pull Request

📬 Contact

If you have any questions or suggestions, feel free to reach out! Ig: @pinedah_11

---

🚀 Happy coding and database designing!