Back

AWS Point-of-Sale (POS) System

Note: This project is part of an academic course at Texas A&M University. I do not have permission to share my implementation without an explicit approval from the professor. To view the project files, please contact me

Impact

Through comprehensive development of a Point-of-Sale (POS) system using MariaDB and MongoDB, this project demonstrated end-to-end database management capabilities from infrastructure setup to data migration, enabling efficient transaction processing and scalable data management

Problem Statement

A retail business needed a robust Point-of-Sale system that could handle customer transactions, inventory management, and business analytics. The system needed to be scalable, maintain data integrity, and eventually support fast read operations for growing business needs

Approach

The development strategy focused on a phased implementation:

Set up AWS EC2 infrastructure for hosting the database
Design and implement relational schema in MariaDB
Create business logic using stored procedures and triggers
Implement data replication for scalability
Migrate to MongoDB for improved read performance

Methodology

Infrastructure Setup

The implementation began with configuring an AWS EC2 instance and installing MariaDB. Shell scripts were used to automate the installation process and configure necessary dependencies.

Database Development

The system was built progressively:

Created normalized database schema
Implemented data validation using triggers
Developed stored procedures for business logic
Set up primary-secondary replication for scalability
Configured peer-to-peer replication across multiple nodes

NoSQL Migration

The final phase involved migrating data to MongoDB:

Transformed relational data into JSON format
Designed document structures for MongoDB
Implemented MongoDB queries for business analytics

Result

The project delivered a fully functional POS system with:

Robust data integrity through triggers and stored procedures
Improved read performance through replication
Scalable architecture supporting multiple nodes
Flexible NoSQL implementation for fast queries

The system successfully demonstrated the practical application of both relational and NoSQL databases in a real-world business context, showcasing the benefits of polyglot persistence in modern database architecture

This project is a part of an academic course at Texas A&M University. I do not have permission to share my implementation without an explicit approval from the professor.

Request Project Files Back to homepage