completed the repositories odb functions