AlesRuzicka.eu

#B2b

#B2B #DotNet #SQL

Data collection and analytics

Problem To collect data from many different systems Data can by of any kind Data for single point may come from many sources over time It should be simple search and to make reports from data (it must be indexed and in proper data types) Data must never leave client’s servers Solution I overtook system after 3 months of development by other developer First version was done in 2 weeks Scope has been reduce to just what is necessary to do and reporting was left to 3rd party applications System collects all data in key-value manner in single SQL table System schedules data consolidation, transformation and insertion SQL tables that are specific per report System generates it’s onw SQL create those tables and insert in them Single data point can end in many data tables Consolidation can be extended using plugins Advantages I decided not to care about reports as there are already many good reporting tools, just data collection and transformation I decided use capabilities of SQL server rather than try to bend it to what it was not designed for This simplified whole development significantly, system is running for many years now without any intention

read more …
#B2B #DotNet

Production planning

Problem To efficiently plan print center production To have proper estimation about amount of work To track available resources Solution I overtook system after 6 months of development by other developer System had some UI, but there was no planning part Complete planning system was developed which allowed to use these data Available resources (human and infrastructure) Shifts, overtimes and unavailability of resources Separation of planning jobs to steps, each requiring resources Calculation based on speed of selected resources Ability to start next step parallel to previous of first result of previous Ability to split work Ability to merge multiple jobs to one for efficiency UI to display this all Planning is good enough to handle whole print center processing automatically by it Advantages Planning engine is completely separate from rest of system It’s reusable It’s simple to test

read more …