database-architecture

Guia de arquitetura e trade-offs de PostgreSQL em produção — não é sobre sintaxe, é sobre decisões.

Oracle SQL exercices from institute of technological studies of charguia DSI201 2023/2024

A containerized distributed data processing system that demonstrates core cloud database concepts through hands-on implementation using Java, Apache Arrow, Iceberg, and Calcite

End-to-end process for building an SQL Azure database, performing data analysis with SQL and Python, and visualizing data with Tableau.

A secure, ACID-compliant banking database system featuring stored procedures for safe money transfers and automated triggers for fraud detection.

A collection of refactored MySQL scripts focused on advanced revenue growth analysis, supply chain data hygiene, and complex joins.

A 3-tier enterprise backend managing the pharmaceutical manufacturing lifecycle. Built with Java 21, Spring Boot 3, and React, it enforces strict FDA compliance via PostgreSQL triggers and features an embedded Spring AI compliance copilot. It includes secure JWT workflows for all operations, full batch traceability, and real-time stock dashboards.

Enterprise-grade database isolation tool. Dynamically generates sandboxed Postgres schemas and automated RLS policies for ERPs. Built by Arjumand Labs.

Database Analysis and Design for Train Reservation System. Analysis of User Requirments Phase, Design of ERD, Schema, Implementation of Physical Tables, Populating Data, and Queries to Analyze the Data. Views for the security of data and helping analyze the rest of the tables.

Scalable Spring Boot multi-tenant architecture implementation featuring dynamic database routing, tenant-based schema isolation, and custom filtering.

📚 RDBMS Glossary is a comprehensive, interactive reference for relational database management systems — covering 147+ terms across SQL syntax, RDBMS concepts, data modeling, database architecture, and tools. Each entry includes a clear definition, importance rating, code example with syntax highlighting, related terms with clickable navigation.

Specialized LLM agent skills for database architecture, schema design, auditing, performance optimization, and selecting the right SQL/NoSQL technologies

Enterprise HA/DR MongoDB replica set on OCI VCN with Tier III multi-site network topology. Corosync & Pacemaker orchestration pending.

This case study not only underscores the strategic and innovative approach that has become Myntra's hallmark but also underscores its unwavering dedication to delivering a personalized, convenient, and comprehensive online shopping experience.

Tokhy DBMS is a small, hands-on database management system built in Python as a learning project. The goal was to understand the core ideas behind how a database server works, not just to write SQL code, but to see how data is stored, parsed, executed, and accessed through a client/server model.

This project sets up a PostgreSQL-based data warehouse following the Medallion Architecture (Bronze → Silver → Gold). It includes scripts to create the main database and structured schemas for organizing raw, cleaned, and business-ready data. Ideal for analytics and ETL workflows.

Enterprise PostgreSQL 15+ Omnichannel Retail & Supply Chain Performance Engine. High-performance relational analytics, ghost stockout eradication, supplier SLA penalty audit, and customer lifecycle cohort retention.

A "Zero Trust" SQL Server architecture that moves security logic from the API layer directly into the database schema using Stored Procedures, RBAC, and Physical Isolation.

Análisis ACID vs BASE y selección RDBMS/NoSQL para multinacional alimenticia latinoamericana. Ciclo de vida de ingeniería de datos. Módulo ESC420, Maestría Arquitectura de Software, Politécnico Grancolombiano.

Comprehensive AWS multi-database architecture implementing enterprise-grade RDS Multi-AZ, cross-region read replicas, real-time data processing with Kinesis & DynamoDB, and intelligent caching solutions. Demonstrates high-availability database design, automated backup strategies, and performance optimization for nationwide branch operations.