added analysis and shiny parts; db is in a errorless state