In the last post we looked over a cloud solution design to ingest small CSV files uploaded by users. This files were crunched by the system that would generate static reports based on the content. Nothing fancy or complex. The NFR requirements are light, because the real business value stays in the generated reports: Under 200 users worldwide Concurrency level is 10% (20 users online simultan) Less than 15 CSV uploaded in total per day Basic reporting functionality Current DB size 150MB (2M reporting entries) DB forecast for next 3 years is 1GB (20-25M reporting entries) CSV has up to 1000 entries (maximum 10 columns) The system that was design for this application was a state of the art system - salable, robust, containing all the current technology trends. But of course was over engineering, to powerful and to expensive. Now, the biggest concern was how we can reduce the running cost of the system with a minimal impact (development co...
DREAMER, CRAFTER, TECHNOLOGY ENTHUSIAST, SPEAKER, TRAINER, AZURE MVP, SOLVING HARD BUSINESS PROBLEMS WITH CUTTING-EDGE TECHNOLOGY