A method and system for data retrieval in an enterprise portal application. The method and system include receiving, in a data access layer, a request for object data from a business logic layer. The method and system further includes validating, by a schema layer in communication with the data access layer, that cache data of a cache and data of one or more databases of the enterprise portal application are synchronized. The cache data may include table data and index data of the one or more databases of the enterprise portal application. The method and system further include retrieving, if the cache is validated, table data from the cache, and returning the object data to the business logic layer, the object data corresponding to the retrieved table data.