Operational records
Record harvest batches, multi-item sales, waste, and inventory movements with first-expiring-first-out stock allocation.
Research / App case study
A Java application connecting harvest intake, produce sales, FEFO inventory, waste, and audit-safe sale voiding to repeatable warehouse ETL, Apriori rules, and K-means buyer segmentation.
Local classroom prototype · synthetic data
01 / Overview
Connect harvest-to-market transactions to a repeatable analytical warehouse and explainable mining results.
Students studying transaction processing, data warehousing, and mining in one application.
02 / Features
Record harvest batches, multi-item sales, waste, and inventory movements with first-expiring-first-out stock allocation.
Void sales without deleting them and restore allocated stock through traceable movements.
Refresh reconciled warehouse facts, export CSV, and run Apriori rules and deterministic K-means buyer segmentation.
03 / Workflow
Record a harvest batch and its shelf life.
Complete a sale using eligible stock or record waste.
Inspect inventory and movement history; void mistaken sales when needed.
Refresh warehouse facts and inspect mining results and reports.
04 / Technical layers
A responsive browser interface uses bundled assets for local operation.
The loopback HTTP server validates transactions and rolls back incomplete sales.
Operational tables and warehouse dimensions/facts are logically separate inside one database file.
Repeatable loads and deterministic mining operate on synthetic teaching records.
05 / Limitations
06 / Evidence
These descriptions were reviewed against the linked source snapshot on October 12, 2026. Repository code and documentation may evolve after this review.