implemented odb functions