Hi Dmitry,
Thank you for the response.
I was thinking the same. custom table "subscription" with EmailID, NodeID/Aliasepath, Datetime.
And a global event handler for particular content updates, a service to check if that updated page NodeID is subscribed by anyone. If so, grab all the email IDs and send an email to them using a template.