clean up and translate new database view