My problem with this approach is that my system basically handles a complex inventory and allows complex orders out if it, orders you can modify/update/cancel o

My problem with this approach is that my system basically handles a complex inventory and allows complex orders out if it, orders you can modify/update/cancel over a very long (months) period. So we do have data warehouse for strategic analysis and planning, but we need to also manage complex data which has to be consistent and available 24/7.