Session table framework

• US 8,812,630 B2
• Filed: 08/11/2011
• Issued: 08/19/2014
• Est. Priority Date: 01/24/2011
• Status: Active Grant

• Current Assignee: Salesforce.com, Inc.
• Original Assignee: Salesforce.com, Inc.
• Inventors: Duff, John, Gurudatha, Manu, Uzzaman, Ashik
• Primary Examiner(s): Nawaz, Asad
• Assistant Examiner(s): BELETE, BERHANU D
• Application Number:
  US13/208,201
• Publication Number:
  US 20120191865A1
• Time in Patent Office: 1,104 Days
• Field of Search: 709227-229, 705/756, 705769-770, 705791-793, 705/802
• US Class Current: 709/220
• CPC Class Codes: G06F 16/211 Schema design and management
• CPC Class Codes: G06F 16/215 Improving data quality; Data cleansing, e.g. de-duplication, removing invalid entries or correcting typographical errors
• CPC Class Codes: H04L 67/01 Protocols
• CPC Class Codes: H04L 67/14 Session management for real-time applications in data packet communications networks H04L65/1066
• CPC Class Codes: H04L 67/141 Setup of application sessions admission control or resource allocation in data switching networks H04L47/70
• CPC Class Codes: H04L 67/60 Scheduling or organising the servicing of application requests, e.g. requests for application data transmissions using the analysis and optimisation of the required network resources admission control or resource allocation H04L47/70

Abstract

In accordance with embodiments disclosed herein, there are provided methods, systems, and apparatuses for implementing a session table framework including, for example, receiving a configuration request at a host organization from a client device; generating, via a configurator engine of the host organization, a configuration model having metadata therein; generating a user session unique to the client device in a memory of the host organization; creating a user session data table within the user session of the memory based on the metadata of the configuration model; populating data into the user session data table based on the metadata of the configuration model; generating a renderable User Interface (UI) based on the metadata of the configuration model and based further on the data in the user session data table; and transmitting the renderable UI to the client device for display, responsive to receiving the configuration request.

Claims

1. A method in a host organization having at least a processor and a memory therein, wherein the method comprises:

receiving a configuration request at the host organization from a client device;

generating, via a stateless configurator engine of the host organization, a configuration model having metadata therein, wherein the stateless configurator engine does not maintain state specific information regarding the client device between a plurality of interactions with the client device;

generating a user session unique to the client device in the memory of the host organization;

creating a user session data table within the user session of the memory based on the metadata of the configuration model, wherein the metadata defines (i) a location mapping between locations within the user session data table and data to be populated into the user session data table, and wherein the metadata further defines (ii) a data persistence mapping for the data to be populated into the user session data table and one or more locations in a database where the data is to be persisted between plurality of interactions with the client device;

populating the data into the user session data table based on the location mapping and the data persistence mapping as defined by the metadata;

generating a renderable User Interface (UI) based on the metadata and based further on the data populated into the user session data table; and

transmitting the renderable UI to the client device for display, responsive to receiving the configuration request.

2. The method of claim 1:

wherein the metadata defines a structure for the user session data table; and

wherein creating the user session data table within the user session of the memory comprises creating the user session table based on the structure defined within the metadata of the configuration model.

3. The method of claim 2, wherein a table creation program extension programmatically interfaced with the stateless configurator engine operates to create the user session data table within the user session of the memory responsive to the generation of the configuration model by the stateless configurator engine.

4. The method of claim 2:

wherein the metadata defines the mapping between a plurality of data elements and a plurality of corresponding target locations within the structure defined by the metadata; and

wherein populating data into the user session data table comprises storing each of the plurality of data elements into one or more rows of the user session data table based on the data mapping defined by the metadata.

5. The method of claim 4:

wherein each of the plurality of data elements are provided within the configuration model or are retrievable from a source location separate from the configuration model as specified by the metadata;

wherein populating the data into the user session data table further comprises retrieving each of the plurality of data elements from the configuration model or from the source location specified by the metadata and storing each of the plurality of data elements retrieved into the one or more rows of the user session data table.

6. The method of claim 4, wherein the mapping further defines data persistence between one or more cells in the user session data table and a corresponding one or more data persistence locations in a database of the host organization;

and

wherein the method further comprises synchronizing data within the one or more cells in the user session data table with the corresponding one or more data persistence locations in the database system of the host organization based on the mapping to persist the data in the one or more cells beyond the existence of the generated user session unique to the client device in the memory of the host organization on behalf of the client device.

7. The method of claim 6, wherein a data persistence program extension programmatically interfaced with the stateless configurator engine operates to synchronize the data within the one or more cells in the user session data table with the corresponding one or more data persistence locations and wherein the data persistence program extension further operates to synchronize updated data within the one or more cells in the user session data table with the corresponding one or more data persistence locations when the one or more cells in the user session data table are updated responsive to update data received within a configuration submission received from the client device.

8. The method of claim 4, wherein a table population program extension programmatically interfaced with the stateless configurator engine operates to populate the data into the user session data table by storing each of the plurality of data elements into the one or more rows of the user session data table based on the mapping defined by the metadata.

9. The method of claim 1:

wherein the metadata further defines a plurality of controls, each control specifying display logic for one or more of the plurality of data elements as specified by the mapping defined within the metadata of the configuration model; and

wherein generating the renderable UI based on the metadata of the configuration model and based further on the data in the user session data table comprises;

incorporating each of the plurality of controls defined by the metadata into the renderable UI,

incorporating, for each of the plurality of controls, the display logic specified by each control into the renderable UI, and

incorporating each of the plurality of data elements into the renderable UI based on the display logic specified by each control, wherein each of the plurality of data elements are retrieved from the user session data table.

10. The method of claim 9, wherein a UI rendering program extension programmatically interfaced with the stateless configurator engine operates to generate the renderable UI.

11. The method of claim 9, further comprising the client device displaying the renderable UI via a display device communicatively interfaced with the client device, wherein displaying the renderable UI comprises rendering display elements at the client device corresponding to the plurality of controls incorporated into the renderable UI transmitted to the client device by the host organization and each of the plurality of data elements incorporated into the renderable UI in accordance with the plurality of controls.

12. The method of claim 9, wherein each of the plurality of controls incorporated into the renderable UI define at least one event selected from the group of events comprising:

a read event specifying a source location from which to read data to be displayed via the renderable UI;

a display only event specifying that data displayed is not updateable by the client device via the renderable UI; and

an input text event designating input received from a rendered field at the client device as update data for a UI entry field and further designating a target location in the user session data table in which to store the update data.

13. The method of claim 9, wherein transmitting the renderable UI to the client device for display comprises transmitting a single web page having dynamic presentation logic therein to the client device for rendering via a web browser, wherein the single web page comprises presentation logic to render the plurality of controls and logic to receive update data from the client device, via the single web page, for submission to the host organization from the client device within a configuration submission.

14. The method of claim 13, wherein the dynamic presentation logic of the single web page updates a rendering of the plurality of controls at the client device responsive to receiving the update data from the client device, when the update data received affects one or more dynamically calculable fields rendered by the presentation logic of the single web page.

15. The method of claim 13, wherein the dynamic presentation logic of the single web page implements a plurality of tabs for individual display at the client device, each of the plurality of tabs to display a first subset of the plurality of controls, and to further hide from display, a remaining subset of the plurality of controls.

16. The method of claim 1:

wherein the metadata defines a plurality of business rules for the configuration model and further defines one or more data elements necessary to support each of the plurality of business rules; and

wherein creating the user session data table within the user session of the memory comprises creating the user session table based on the one or more data elements necessary to support each of the plurality of business rules defined by the metadata of the configuration model.

17. The method of claim 16:

wherein the metadata defines a mapping between the one or more data elements necessary to support each of the plurality of business rules defined by the metadata of the configuration model and a plurality of corresponding locations within the structure defined by the metadata; and

wherein populating data into the user session data table comprises storing each of the one or more data elements necessary to support each of the plurality of business rules defined by the metadata of the configuration model into one or more rows of the user session data table based on the mapping defined by the metadata.

18. The method of claim 1, further comprising:

receiving a configuration submission from the client device responsive to the renderable UI transmitted to the client device, wherein the configuration submission includes update data from the client device;

validating the update data against one or more cells within the user session data table which are updateable by the client device; and

updating the one or more cells within the user session data table with the update data from the client device based on the validation.

19. The method of claim 1, wherein generating the renderable UI further comprises designating one or more cells within the renderable UI as UI entry fields, each UI entry field corresponding to a cell within the user session data table which is updatable based on input from the client device;

and

wherein the method further comprises;

receiving a configuration submission from the client device having update data therein; and

updating one or more cells within the user session data table based on the update data from the client device when the one or more cells are designated as UI entry fields.

20. The method of claim 1, wherein the stateless configurator engine is provided by a third-party entity, distinct from the host organization, and further wherein the host organization executes and operates the stateless configurator engine but cannot modify underlying source code of the stateless configurator engine.

21. The method of claim 1:

wherein receiving the configuration request comprises receiving the configuration request at the host organization having a multi-tenant database system operating therein; and

wherein the configuration request is one of a plurality of requests received from a plurality of customer organizations, wherein each customer organization is an entity selected from the group consisting of;

a separate and distinct remote organization, an organizational group within the host organization, a business partner of the host organization, or a customer organization that subscribes to cloud computing services provided by the host organization.

22. The method of claim 21, wherein the multi-tenant database system comprises elements of hardware and software that are shared by a plurality of separate and distinct customer organizations, each of the separate and distinct customer organizations being remotely located from the host organization having the multi-tenant database system operating therein.

23. The method of claim 1, further comprising:

including a UI entry field to receive update data from the client device at the renderable UI; and

designating a target location in the user session data table in which to store the update data received.

24. Non-transitory computer readable storage media having instructions stored thereupon that, when executed by a processor of a host organization, the processor causes the host organization to perform operations comprising:

receiving a configuration request at the host organization from a client device;

generating, via a stateless configurator engine of the host organization, a configuration model having metadata therein, wherein the stateless configurator engine does not maintain state specific information regarding the client device between a plurality of interactions with the client device;

generating a user session unique to the client device in the memory of the host organization;

creating a user session data table within the user session of the memory based on the metadata of the configuration model, wherein the metadata defines (i) a location mapping between locations within the user session data table and data to be populated into the user session data table, and wherein the metadata further defines (ii) a data persistence mapping for the data to be populated into the user session data table and one or more locations in a database where the data is to be persisted between plurality of interactions with the client device;

populating the data into the user session data table based on the location mapping and the data persistence mapping as defined by the metadata;

generating a renderable User Interface (UI) based on the metadata and based further on the data populated into the user session data table; and

transmitting the renderable UI to the client device for display, responsive to receiving the configuration request.

25. The non-transitory computer readable storage media of claim 24, wherein one or more cells within the user session data table are updateable by the client device;

and

wherein the operations further comprise;

receiving a configuration submission from the client device having update data therein;

validating the update data against the one or more cells within the user session data table which are updateable by the client device; and

updating the one or more cells within the user session data table with the update data from the client device based on the validation.

26. A system comprising:

a processor to execute instructions;

a request interface to receive a configuration request from a client device;

a stateless configurator engine to generate a configuration model having metadata therein, wherein the stateless configurator engine does not maintain state specific information regarding the client device between a plurality of interactions with the client device;

a memory to store a user session unique to the client device on behalf of the client device;

a table creation program extension programmatically interfaced with the stateless configurator engine to create a user session data table within the user session of the memory based on the metadata of the configuration model, wherein the metadata defines (i) a location mapping between locations within the user session data table and data to be populated into the user session data table, and wherein the metadata further defines (ii) a data persistence mapping for the data to be populated into the user session data table and one or more locations in a database where the data is to be persisted between plurality of interactions with the client device;

a table population program extension programmatically interfaced with the stateless configurator engine to populate data into the user session data table based on a mapping defined by the metadata; and

a UI rendering program extension programmatically interfaced with the stateless configurator engine to generate a renderable User Interface (UI) based on the metadata and based further on the data populated into the user session data table.

27. The system of claim 26, further comprising a web-server;

wherein the web-server is to implement the request interface to receive the configuration request from the client device; and

wherein the web-server to further transmit the renderable UI to the client device for display, responsive to the configuration request having been received at the request interface of the web-server.

28. The system of claim 26, further comprising a data persistence program extension programmatically interfaced with the stateless configurator engine to synchronize the data within the locations within the user session data table with the one or more locations in the database where the data is to be persisted;

and

wherein the data persistence program extension further is to synchronize updated data within the locations within the user session data table with the corresponding one or more locations in the database where the data is to be persisted when the locations within the user session data table are updated responsive to update data received within a configuration submission received from the client device.