Patent ID: 8024380

Claim:
A method of processing a plurality of transaction requests received from a web based application, wherein said plurality of transaction requests process data containing a static portion and a varying portion, wherein data in said varying portion is likely to be updated substantially more frequently than data in said static portion due to processing of said plurality of transaction requests, said method comprising: storing said varying portion in a database server and said static portion in both said database server and a secondary storage, said varying portion containing a first plurality of data elements and said static portion containing a second plurality of data elements, wherein both of said first plurality of data elements and said second plurality of data elements are together organized in the form of a plurality of tables stored in said database server such that said database server provides access to any of said first plurality of data elements and said second plurality of elements using structured database queries, and said secondary storage does not provide access to said second plurality of data elements using structured database queries; maintaining a data structure indicating that said second plurality of data elements are stored in said secondary data storage, wherein said data structure is in addition to storing of said second plurality of data elements in said secondary storage; receiving from said web based application a transaction request requiring access to a data element, wherein said transaction request is contained in said plurality of transaction requests and said data element is contained in said first plurality of data elements or said second plurality of data elements; determining whether said data element is contained in said static data, wherein said determining comprises examining said data structure to identify whether said data element is contained in said static data without having to access the corresponding data element in either the said database server or the said secondary storage; sending a structured database query to said database server to access said data element if said data element is determined to be not contained in said static data; and accessing said data element based on said second plurality of data elements stored in said secondary storage if said data element is determined to be contained in said static data.