title: Web Application - Deleting parent also delete direct and indirect dependents
body: <p>What is the approach in handling big hierarchy of parent and children relationship?</p>
  
  <p>Let say I would like to delete a parent via a web application, deleting this parent should also delete all dependents. The issue here is due to performance and possibility on the database lock during the processing of the mass number of children</p>
  
  <p>How usually the solution of such scenario is handled and designed?</p>