v1.0.0

🚀 Quick Start (Recommended)

Complete deployment package:

1. Download db-complete-deployment.zip from Assets below
2. Extract and run start.bat (Windows) or start.sh (Linux/Mac)

Access:

• 🌐 Web App: http://localhost:5000
• 🗄️ Oracle Enterprise Manager: http://localhost:5500/em

🐳 Docker (all-in-one image, no external DB needed)

From GitHub Packages:

docker pull ghcr.io/icekern/db:latest
docker run -p 5000:5000 ghcr.io/icekern/db:latest

Load from asset:

docker load < db-docker-image.tar.gz
docker run -p 5000:5000 ghcr.io/icekern/db:latest

From source (docker-compose, separate Oracle container):

git clone https://github.com/icekern/DB.git
cd DB
docker compose up --build

📋 Features

• Oracle 21c XE database with ConferenceHub schema
• 9 business rule triggers (BR1-BR13) for data integrity
• 4 stored procedures for conference and review management
• Sample data: 100 conferences, 1200 articles, 3600 reviews
• Web interface: article submission, reviewer assignment, review management

🏗️ Architecture

• Backend: Python Flask + Gunicorn + python-oracledb
• Frontend: Jinja2 templates + Tailwind CSS
• Database: Oracle 21c XE with complete triggers and procedures
• Deployment: Docker Compose (app + db containers)

Full Changelog: https://github.com/icekern/DB/commits/v1.0.0