Method and system for generating and sharing dataset segmentation schemes

• US 8,543,591 B2
• Filed: 10/07/2009
• Issued: 09/24/2013
• Est. Priority Date: 09/02/2009
• Status: Active Grant

• Current Assignee: Google LLC (Alphabet Inc.)
• Original Assignee: Google Inc. (Alphabet Inc.)
• Inventors: Nandy, Sagnik, Mui, Lik, Patton, Brian Jonathan, Jones, Matthew Reardon, Moon, Hui Sok, Choc, Theodore Nicholas, Vandermolen, Wayne Douglas, Seckar, Nicholas John
• Primary Examiner(s): Btit, Jacob F
• Assistant Examiner(s): LIN, CHRISTY Y
• Application Number:
  US12/575,437
• Publication Number:
  US 20110055250A1
• Time in Patent Office: 1,448 Days
• Field of Search: 707/769, 707/101, 725/112
• US Class Current: 707/769
• CPC Class Codes: G06F 16/248 Presentation of query results
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A computer-implemented method for generating and sharing dataset segment schemes of a multidimensional dataset at a client device is disclosed. The client device displays a first filter definition template and an attribute list. Upon detecting a user selection of a first attribute, the client device displays the first attribute and one or more candidate filter conditions in the first filter definition template. Upon detecting a user selection of a first filter condition in the first filter definition template, the client device submits a segment scheme generation request to the server system and receives from the server system a first segment identifier; and displays a first segment link at the client device, the first segment link including the first segment identifier.

Claims

1. A computer-implemented method for generating and sharing dataset segment schemes of a multidimensional dataset, wherein the multidimensional dataset is characterized by a set of dimension attributes and a set of metric attributes, comprising:

at a client device having one or more processors and memory storing programs executed by the one or more processors, wherein the client device is connected to a server system through a network;

concurrently displaying a first filter definition template including one or more user-interactive fields and an attribute list including at least one dimension attribute and at least one metric attribute in a web browser window, wherein the first filter definition template and the attribute list are displayed in two separate regions in the web browser window;

receiving a user instruction of selecting a first attribute in the attribute list and associating the first attribute with one of the one or more user-interactive fields to define a first data filter in the first filter definition template;

in response to the user instruction;

replacing the user-interactive field with first and second user-interactive sub-fields;

displaying the first attribute in the first user-interactive sub-field and one or more candidate filter conditions in the second user-interactive sub-field of the first filter definition template;

receiving a user selection of a first filter condition among the one or more candidate filter conditions in the first filter definition template;

in response to the user selection of the first filter condition;

submitting a segment scheme generation request to the server system, wherein the segment scheme generation request includes a first data filter including the first attribute and the first filter criterion;

receiving from the server system a first segment identifier that identifies a dataset segment scheme generated by the server system in response to the segment scheme generation request;

displaying a first segment link at the client device, the first segment link including the first segment identifier, wherein a user selection of the first segment link in association with any one of a plurality of sub-datasets of the multidimensional dataset, each sub-dataset being associated with a respective user, causes a display of a result of processing the sub-dataset in accordance with the dataset segment scheme identified by the first segment identifier;

receiving a request to share the first segment identifier with a second user;

generating a second segment link that includes the first segment identifier; and

sending the second segment link to the second user, wherein a second user selection of the second segment link at a respective client device generates another instance of the first filter definition template including the first data filter and the first filter condition, wherein the another instance of the first filter definition template is used for generating a second dataset segment scheme to be applied to a sub-dataset associated with the second user and the second dataset segment scheme has a second segment identifier different from the first segment identifier.

2. The method of claim 1, further comprising:

in response to a user selection of the first segment link, submitting a first segment request to the server system, the first segment request including the first segment identifier; and

receiving from the server system a first segment result for display to a first user at the client device, wherein the first segment result includes a first data record count of a first set of data records associated with the first user in the dataset that satisfies the first data filter.

3. The method of claim 1, wherein the second segment link is sent to the second user via email.

4. The method of claim 1, wherein a new segment request submitted by the second user is applied to a second set of data records associated with the second user in the dataset at least one of which is different from the first set of data records associated with the first user in the dataset.

5. The method of claim 1, wherein the first filter definition template includes a logic conjunctive link, further comprising:

receiving a user selection of the logic conjunctive link;

displaying a second filter definition template adjacent the first filter definition template;

receiving a user selection of a second attribute in the attribute list to define a second data filter in the second filter definition template;

displaying the second attribute and one or more candidate filter conditions in the second filter definition template;

receiving a user selection of a second filter condition among the one or more candidate filter conditions in the second filter definition template;

submitting a segment scheme test request to the server system, wherein the segment scheme test request includes the first data filter and a second data filter including the second attribute and the second filter condition; and

receiving from the server system a second segment result, wherein the second segment result includes the first data record count, a second data record count of the first set of data records that satisfies the second data filter, and a third data record count of the first set of data records that satisfies both the first data filter and the second data filter.

6. The method of claim 5, further comprising:

displaying the first data record count, the second data record count, and the third data record count simultaneously to the first user at the client device, wherein the first data record count and the second data record count are displayed adjacent the first data filter and the second data filter, respectively.

7. The method of claim 1, wherein the first filter definition template includes a logic disjunctive link, further comprising:

receiving a user selection of the logic disjunctive link;

displaying a second filter definition template adjacent the first filter definition template;

receiving a user selection of a second attribute in the attribute list to define a second data filter in the second filter definition template;

displaying the second attribute and one or more candidate filter conditions in the second filter definition template;

receiving a user selection of a second filter condition among the one or more candidate filter conditions in the second filter definition template;

submitting a segment scheme test request to the server system, wherein the segment scheme test request includes the first data filter and a second data filter including the second attribute and the second filter condition; and

receiving from the server system a second segment result, wherein the second segment result includes the first data record count, a second data record count of the first set of data records that satisfy the second data filter, and a third data record count of the first set of data records that satisfy at least one of the first data filter and the second data filter.

8. A client device for generating and sharing dataset segment schemes of a multidimensional dataset, wherein the client device is connected to a server system through a network, and the multidimensional dataset is characterized by a set of dimension attributes and a set of metric attributes and managed by the server system, comprising:

one or more processors for executing programs; and

memory to store data and to store one or more programs to be executed by the one or more processors, the one or more programs including instructions for;

concurrently displaying a first filter definition template including one or more user-interactive fields and an attribute list including at least one dimension attribute and at least one metric attribute in a web browser window, wherein the first filter definition template and the attribute list are displayed in two separate regions in the web browser window;

receiving a user instruction of selecting a first attribute in the attribute list and associating the first attribute with one of the one or more user-interactive fields to define a first data filter in the first filter definition template;

in response to the user instruction;

replacing the user-interactive field with first and second user-interactive sub-fields;

displaying the first attribute in the first user-interactive sub-field and one or more candidate filter conditions in the second user-interactive sub-field of the first filter definition template;

receiving a user selection of a first filter condition among the one or more candidate filter conditions in the first filter definition template;

in response to the user selection of the first filter condition;

submitting a segment scheme generation request to the server system, wherein the segment scheme generation request includes a first data filter including the first attribute and the first filter criterion;

receiving from the server system a first segment identifier that identifies a dataset segment scheme generated by the server system in response to the segment scheme generation request;

displaying a first segment link at the client device, the first segment link including the first segment identifier, wherein a user selection of the first segment link in association with any one of a plurality of sub-datasets of the multidimensional dataset, each sub-dataset being associated with a respective user, causes a display of a result of processing the sub-dataset in accordance with the dataset segment scheme identified by the first segment identifier;

receiving a request to share the first segment identifier with a second user;

generating a second segment link that includes the first segment identifier; and

sending the second segment link to the second user, wherein a second user selection of the second segment link at a respective client device generates another instance of the first filter definition template including the first data filter and the first filter condition, wherein the another instance of the first filter definition template is used for generating a second dataset segment scheme to be applied to a sub-dataset associated with the second user and the second dataset segment scheme has a second segment identifier different from the first segment identifier.

9. The client device of claim 8, wherein the one or more programs further include instructions for:

in response to a user selection of the first segment link,

submitting a first segment request to the server system, the first segment request including the first segment identifier; and

receiving from the server system a first segment result for display to a first user at the client device, wherein the first segment result includes a first data record count of a first set of data records associated with the first user in the dataset that satisfies the first data filter.

10. The client device of claim 8, wherein the second segment link is sent to the second user via email.

11. The client device of claim 8, wherein a new segment request submitted by the second user is applied to a second set of data records associated with the second user in the dataset at least one of which is different from the first set of data records associated with the first user in the dataset.

12. The client device of claim 8, wherein the first filter definition template includes a logic conjunctive link and the one or more instructions further include instructions for:

receiving a user selection of the logic conjunctive link;

displaying a second filter definition template adjacent the first filter definition template;

receiving a user selection of a second attribute in the attribute list to define a second data filter in the second filter definition template;

displaying the second attribute and one or more candidate filter conditions in the second filter definition template;

receiving a user selection of a second filter condition among the one or more candidate filter conditions in the second filter definition template;

submitting a segment scheme test request to the server system, wherein the segment scheme test request includes the first data filter and a second data filter including the second attribute and the second filter condition; and

receiving from the server system a second segment result, wherein the second segment result includes the first data record count, a second data record count of the first set of data records that satisfies the second data filter, and a third data record count of the first set of data records that satisfies both the first data filter and the second data filter.

13. The client device of claim 12, wherein the one or more instructions further include instructions for:

displaying the first data record count, the second data record count, and the third data record count simultaneously to the first user at the client device, wherein the first data record count and the second data record count are displayed adjacent the first data filter and the second data filter, respectively.

14. The client device of claim 8, wherein the first filter definition template includes a logic disjunctive link and the one or more instructions further include instructions for:

receiving a user selection of the logic disjunctive link;

displaying a second filter definition template adjacent the first filter definition template;

receiving a user selection of a second attribute in the attribute list to define a second data filter in the second filter definition template;

displaying the second attribute and one or more candidate filter conditions in the second filter definition template;

receiving a user selection of a second filter condition among the one or more candidate filter conditions in the second filter definition template;

submitting a segment scheme test request to the server system, wherein the segment scheme test request includes the first data filter and a second data filter including the second attribute and the second filter condition; and

receiving from the server system a second segment result, wherein the second segment result includes the first data record count, a second data record count of the first set of data records that satisfy the second data filter, and a third data record count of the first set of data records that satisfy at least one of the first data filter and the second data filter.

15. A non-transitory computer readable-storage medium storing one or more programs for execution by one or more processors of a client device for generating and sharing dataset segment schemes of a multidimensional dataset, wherein the client device is connected to a server system through a network, and the multidimensional dataset is characterized by a set of dimension attributes and a set of metric attributes and managed by the server system, the one or more programs comprising instructions for:

concurrently displaying a first filter definition template including one or more user-interactive fields and an attribute list including at least one dimension attribute and at least one metric attribute in a web browser window, wherein the first filter definition template and the attribute list are displayed in two separate regions in the web browser window;

receiving a user instruction of selecting a first attribute in the attribute list and associating the first attribute with one of the one or more user-interactive fields to define a first data filter in the first filter definition template;

in response to the user instruction;

replacing the user-interactive field with first and second user-interactive sub-fields;

displaying the first attribute in the first user-interactive sub-field and one or more candidate filter conditions in the second user-interactive sub-field of the first filter definition template;

receiving a user selection of a first filter condition among the one or more candidate filter conditions in the first filter definition template;

in response to the user selection of the first filter condition;

submitting a segment scheme generation request to the server system, wherein the segment scheme generation request includes a first data filter including the first attribute and the first filter criterion;

receiving from the server system a first segment identifier that identifies a dataset segment scheme generated by the server system in response to the segment scheme generation request;

displaying a first segment link at the client device, the first segment link including the first segment identifier, wherein a user selection of the first segment link in association with any one of a plurality of sub-datasets of the multidimensional dataset, each sub-dataset being associated with a respective user, causes a display of a result of processing the sub-dataset in accordance with the dataset segment scheme identified by the first segment identifier;

receiving a request to share the first segment identifier with a second user;

generating a second segment link that includes the first segment identifier; and

sending the second segment link to the second user, wherein a second user selection of the second segment link at a respective client device generates another instance of the first filter definition template including the first data filter and the first filter condition, wherein the another instance of the first filter definition template is used for generating a second dataset segment scheme to be applied to a sub-dataset associated with the second user and the second dataset segment scheme has a second segment identifier different from the first segment identifier.

16. The non-transitory computer readable-storage medium of claim 15, wherein the one or more programs further include instructions for:

in response to a user selection of the first segment link,

submitting a first segment request to the server system, the first segment request including the first segment identifier; and

receiving from the server system a first segment result for display to a first user at the client device, wherein the first segment result includes a first data record count of a first set of data records associated with the first user in the dataset that satisfies the first data filter.

17. The non-transitory computer readable-storage medium of claim 15, wherein the second segment link is sent to the second user via email.

18. The non-transitory computer readable-storage medium of claim 15, wherein a new segment request submitted by the second user is applied to a second set of data records associated with the second user in the dataset at least one of which is different from the first set of data records associated with the first user in the dataset.

19. The non-transitory computer readable-storage medium of claim 15, wherein the first filter definition template includes a logic conjunctive link and the one or more programs further include instructions for:

receiving a user selection of the logic conjunctive link;

displaying a second filter definition template adjacent the first filter definition template;

receiving a user selection of a second attribute in the attribute list to define a second data filter in the second filter definition template;

displaying the second attribute and one or more candidate filter conditions in the second filter definition template;

receiving a user selection of a second filter condition among the one or more candidate filter conditions in the second filter definition template;

submitting a segment scheme test request to the server system, wherein the segment scheme test request includes the first data filter and a second data filter including the second attribute and the second filter condition; and

receiving from the server system a second segment result, wherein the second segment result includes the first data record count, a second data record count of the first set of data records that satisfies the second data filter, and a third data record count of the first set of data records that satisfies both the first data filter and the second data filter.

20. The non-transitory computer readable-storage medium of claim 19, wherein the one or more programs further include instructions for:

displaying the first data record count, the second data record count, and the third data record count simultaneously to the first user at the client device, wherein the first data record count and the second data record count are displayed adjacent the first data filter and the second data filter, respectively.

21. The non-transitory computer readable-storage medium of claim 15, wherein the first filter definition template includes a logic disjunctive link and the one or more programs further include instructions for:

receiving a user selection of the logic disjunctive link;

displaying a second filter definition template adjacent the first filter definition template;

receiving a user selection of a second attribute in the attribute list to define a second data filter in the second filter definition template;

displaying the second attribute and one or more candidate filter conditions in the second filter definition template;

receiving a user selection of a second filter condition among the one or more candidate filter conditions in the second filter definition template;

submitting a segment scheme test request to the server system, wherein the segment scheme test request includes the first data filter and a second data filter including the second attribute and the second filter condition; and

receiving from the server system a second segment result, wherein the second segment result includes the first data record count, a second data record count of the first set of data records that satisfy the second data filter, and a third data record count of the first set of data records that satisfy at least one of the first data filter and the second data filter.