Stav dette: Deadlock detection and resolution in database management systems: A comprehensive approach