PPG Database Design

This repository contains the first draft of the database design for a distributed cardiovascular monitoring system based on photoplethysmography (PPG) signals.

The objective of this project is to design, implement, assess a data architecture capable of supporting the storage, consistency, and scalability of time-series physiological data generated by wearable devices.

---

Repository Structure

ppg-database-design/
├── README.md
├── sql/
│ ├── 1. db_creation_script.sql
│ ├── 2. enable_TimescaleDB.sql
│ └── 3. test_inserts.sql
└── models/
├── logical/
└── physical/

sql/: Contains scripts for database setup, schema creation, and sample data insertion.

models/: Includes the logical and physical data models.

Technologies

• PostgreSQL
• TimescaleDB
• PowerDesigner
• DBeaver

Setup and Execution

To initialize the database, execute the scripts in the following order:

1. db_creation_script.sql
2. enable_TimescaleDB.sql
3. test_inserts.sql

⚠️ Note: TimescaleDB must be properly installed and configured in your PostgreSQL instance before running the scripts.

📦TimescaleDB Installation

This project requires TimescaleDB as a PostgreSQL extension for handling time-series data.

You can download and install TimescaleDB from the official website:

👉 https://www.timescale.com/

Official installation guide: 👉 https://www.tigerdata.com/docs/get-started/choose-your-path/install-timescaledb

Basic Steps

1. Install PostgreSQL (if not already installed)
2. Install TimescaleDB following the official guide for your OS
3. Enable the extension in your database by running: