Staging, to get near real time data

Currently, I am working on a project where I fetch data from database views.By views, I mean subsets of a tables which are residing in the database. These views are required to store fresh data ie…, stale data should not be allowed to be fetched, data should be near real time data. So, I was thinking about staging the data, in order to fetch the recent data without any stale elements. Is it a feasible solution to implement staging through snaplogic? Is there any other alternative solution?