The present invention relates to a system and method for pre-processing the data and storing the pre-processed data based on its type at the time of storage. During the pre-processing time, the system extracts all the relevant information such as entities, events/time stamped data, domain specific associations from the received content and stores them separately in a different data store. The system also generates different views based on the correlation between the identified entities, events and domain specific associations using data folding techniques. The system also stores the created views in a separate data store such as a view store, wherein the view store is optimized to serve end user queries by traversing through the stored views.