Inventory data warehouse system with lineage tracing for small retail chain