Update Cache Query on Database Change

How can i cache a query and still have the benefit of it being updated only when a change occurs in the database? If i choose a single time query it will not refresh on updates...