Video in TIB AV-Portal: The denormalized query engine design pattern