Methods and systems for providing a data access layer

A method for providing a re-usable data access framework, the method comprising:

• receiving a request from at least one of first and second application modules by a data access layer having an application program interface located in a first server;
• delegating the request to at least one of a plurality of service providers, located in the first server, to manage data associated with the request;
• maintaining, using at least one of the plurality of service providers in response to a determination that the request is an update shared data request for updating the shared data, data consistency for shared data held in a memory of the first server and a memory of a second server;
• sending information associated with the request to the second application module from a first message service provider located in the first server to a second message service provider located in the second server;
• caching results of a first database query, using at using at least one of the plurality of service providers, in response to a determination that the request is a database access request for updating;
• providing a portion of the results of the first database query to one of the first or second application module in response to receiving a second database query from one of the first or the second application module;
• causing at least one of the plurality of service providers to:
• perform a third database query in response to the first or the second application module predicting a user action,
• cache results of the third database query, and
• provide the results of the third database query to the application program interface when the user action is received by one of the first or the second application module;
• and
• determining a restriction on the request based upon a role of a user associated with the request if the request is received by a third service provider of the plurality of service providers.

A computer-readable storage medium on which is stored a set of instructions for providing a re-usable data access framework, which when executed, perform stages comprising:

• receiving a request from at least one of first and second application modules by a data access layer having an application program interface located in a first server;
• delegating the request to at least one of a plurality of service providers, located in the first server, to manage data associated with the request;
• maintaining, using at least one of the plurality of service providers in response to a determination that the request is an update shared data request for updating the shared data, data consistency for shared data held in a memory of the first server and a memory of a second server;
• sending information associated with the request to the second application module from a first message service provider located in the first server to a second message service provider located in the second server;
• caching results of a first database query, using at using at least one of the plurality of service providers, in response to a determination that the request is a database access request for updating;
• providing a portion of the results of the first database query to one of the first or second application module in response to receiving a second database query from one of the first or the second application module;
• causing at least one of the plurality of service providers to:
• perform a third database query in response to the first or the second application module predicting a user action,
• cache results of the third database query, and
• provide the results of the third database query to the application program interface when the user action is received by one of the first or the second application module;
• and
• determining a restriction on the request based upon a role of a user associated with the request if the request is received by a third service provider of the plurality of service providers.