title: architecture for data analysis
body: <p>We have a ERP system which uses PostgreSQL and has some data that my company want to analyse. I have to done what they asked for but I feel my solution is slow. I run SQL queries to fetch data and then beautifully present it on the page. But on every refresh it runs the same code and most of the historical data never changes. I feel their must be some way to make this fast. Like storing the final data in another DB and if the same request is encountered again produce the same result without even thinking(Like cache but more persistent).</p>
  
  <p>I have no experience in this and you guys might have done this things. can I get some pointers  to follow to make the process fast and non-redundant. 
  Thanks.</p>
  
  <p>P.S. Just learned about ETL and Data Warehouse. Would these two fit in ? should I go ahead with these or are they too big for this problem ?</p>