Information retrieval from a database system

• US 9,665,618 B2
• Filed: 04/17/2014
• Issued: 05/30/2017
• Est. Priority Date: 06/03/2013
• Status: Expired due to Fees

• Current Assignee: International Business Machines Corporation
• Original Assignee: International Business Machines Corporation
• Inventors: Pisters, Ramon L. H., Steijvers, Antonius G. P., Van Ham, Franciscus J. J., Grosset, Robin N.
• Primary Examiner(s): Nguyen, Merilyn
• Application Number:
  US14/255,602
• Publication Number:
  US 20140358963A1
• Time in Patent Office: 1,139 Days
• CPC Class Codes: G06F 16/244 Grouping and aggregation
• CPC Class Codes: G06F 16/245 Query processing
• CPC Class Codes: G06F 16/24553 of query operations
• CPC Class Codes: G06F 16/24556 Aggregation; Duplicate elimination
• CPC Class Codes: G06F 16/9535 Search customisation based on user profiles and personalisation

Abstract

A processor-implemented method retrieves information from a database system. A data query, which includes a specification of information to be retrieved from the database system, is generated. A first parameter specifying a condition to be met by the retrieved information is defined. A second parameter specifying one or more data reduction operations to be executed if the condition defined by the first parameter is not met is defined. The generated data query and the first and second parameters are then transmitted to the database system.

Claims

1. A method for retrieving information from a database system, the method comprising:

generating, by one or more processors, a data query comprising a specification of information to be retrieved from the database system;

defining, by one or more processors, a first parameter specifying a condition to be met by the retrieved information;

defining, by one or more processors, a second parameter specifying one or more data reduction operations to be executed in response to the condition defined by the first parameter not being met, wherein said one or more data reduction operations summarize data using multiple data summarizing operations in a logical order that is defined by a data reduction strategy, wherein the one or more data reduction operations comprise;

a data aggregation operation,

a data clustering operation,

a grouping of value ranges operation,

a top/bottom display operation in which only a top section and a bottom section of the data is displayed,

a rest threshold display operation in which only a predefined percentage of the data is displayed and a remainder of the data is aggregated under a new category entitled “

rest”

,

a sampling operation that returns a random subset of the data, and

a context filtering operation that presents only records from the data that fit a user'"'"'s profile in accordance with a predefined matching limit; and

transmitting, by one or more processors, the generated data query and the first and second parameters to the database system.

2. The method of claim 1, further comprising:

defining, by one or more processors, a replacement parameter specifying at least one of;

a revised condition to be met by retrieved information, and

one or more revised data reduction operations to be executed in response to a condition defined by the first parameter or the replacement parameter not being met; and

transmitting, by one or more processors, the replacement parameter to the database system.

3. A method of providing information from a database system to a client system, the method comprising:

receiving, by one or more processors, a data query defining a specification of information to be retrieved from the database system;

receiving, by one or more processors, a first parameter specifying a condition to be met by retrieved information;

receiving, by one or more processors, a second parameter specifying one or more data reduction operations to be executed in response to the condition defined by the first parameter not being met, wherein said one or more data reduction operations summarize data using multiple data summarizing operations in a logical order that is defined by a data reduction strategy, wherein the one or more data reduction operations comprise;

a data aggregation operation,

a data clustering operation,

a grouping of value ranges operation,

a top/bottom display operation in which only a top section and a bottom section of the data is displayed,

a rest threshold display operation in which only a predefined percentage of the data is displayed and a remainder of the data is aggregated under a new category entitled “

rest”

,

a sampling operation that returns a random subset of the data, and

a context filtering operation that presents only records from the data that fit a user'"'"'s profile in accordance with a predefined matching limit;

identifying, by one or more processors, information from the database system based on one or more characteristics defined by the received data query;

determining, by one or more processors, whether the identified information meets the condition specified by the first parameter; and

in response to determining that the identified information does not meet the condition specified by the first parameter, executing, by one or more processors, a data reduction operation specified by the second parameter, wherein the data reduction operation summarizes the information to be retrieved from the database system using the multiple data summarizing operations in the logical order that is defined by the data reduction strategy.

4. The method according to claim 3, wherein at least one of the first and second parameters is integrated as part of the data query.

5. The method according to claim 3, wherein at least one of the data query, the first parameter, and the second parameter is represented in a database query language.

6. The method according to claim 3, wherein the condition places a limitation on:

an amount of information to be retrieved,

a total data size of information to be retrieved,

a quantity of distinct items to be retrieved,

a quantity of cells to be returned in a multidimensional query, and

a quantity of tuples on an edge of a multidimensional query.

7. The method according to claim 3, further comprising:

determining, by one or more processors, that the data query is transmitted from a mobile device, wherein the mobile device has a display screen than has less than a predefined display area; and

in response to determining that the data query is transmitted from the mobile device having the display screen that has less than the predefined display area, reducing a level of detail of the information to be retrieved from the database system for transmission to and display on the display screen.

8. The method according to claim 3, further comprising:

in response to determining, after executing all of the one or more data reduction operations defined by a first aggregation parameter, that the identified information does still not meet the specified condition, executing, by one or more processors, a default data reduction operation.

9. The method according to claim 3, further comprising:

receiving, by one or more processors, a replacement parameter specifying a revised condition to be met by retrieved information;

identifying, by one or more processors, information from the database system based on the one or more characteristics defined by the received data query;

determining, by one or more processors, whether the identified information meets the revised condition specified by the replacement parameter; and

in response to determining that the identified information does not meet the condition specified by the replacement parameter, executing, by one or more processors, a data reduction operation specified by the second parameter.

10. The method according to claim 3, wherein the database system is provided on a non-transitory computer readable medium.

11. The method according to claim 3, wherein the database system is provided on a network-accessible data repository.

16. The method of claim 3, further comprising:

repeatedly performing, by one or more processors, the data reduction operation specified by the second parameter until the condition specified by the first parameter is met, wherein the condition specified by the first parameter is to return all information for a particular type of data, wherein the data reduction operation reduces said all information for the particular type of data into a reduced format that a first display on a first system that transmitted the data query is capable of displaying upon receipt.

18. The method of claim 16, further comprising:

determining, by one or more processors, that the information is to be transmitted to a second system that has a second display that is smaller than the first display of the first system that transmitted the data query; and

repeatedly performing, by one or more processors, the data reduction operation specified by the second parameter until the second display is capable of displaying the information in a new reduced format.

12. A system for providing information from a database system to a client system, the system comprising:

a processor, a computer readable memory, and a non-transitory computer readable storage medium;

first program instructions to receive a data query defining a specification of information to be retrieved from the database system;

second program instructions to receive a first parameter specifying a condition to be met by retrieved information;

third program instructions to receive a second parameter specifying one or more data reduction operations to be executed in response to the condition defined by the first parameter not being met, wherein said one or more data reduction operations summarize data using multiple data summarizing operations in a logical order that is defined by a data reduction strategy, wherein the one or more data reduction operations comprise;

a data aggregation operation,

a data clustering operation,

a grouping of value ranges operation,

a top/bottom display operation in which only a top section and a bottom section of the data is displayed,

a rest threshold display operation in which only a predefined percentage of the data is displayed and a remainder of the data is aggregated under a new category entitled “

rest”

,

a sampling operation that returns a random subset of the data, and

a context filtering operation that presents only records from the data that fit a user'"'"'s profile in accordance with a predefined matching limit;

fourth program instructions to identify information from the database system based on one or more characteristics defined by the received data query;

fifth program instructions to determine whether the identified information meets the condition specified by the first parameter; and

sixth program instructions to, in response to determining that the identified information does not meet the condition specified by the first parameter, execute a data reduction operation specified by the second parameter, wherein the data reduction operation summarizes the information to be retrieved from the database system using the multiple data summarizing operations in the logical order that is defined by the data reduction strategy; and

wherein the first, second, third, fourth, fifth, and sixth program instructions are stored on the non-transitory computer readable storage medium and executed by the processor via the computer readable memory.

13. The system according to claim 12, wherein at least one of the first and second parameters is integrated as part of the data query.

14. The system according to claim 12, wherein at least one of the data query, the first parameter, and the second parameter is represented in a database query language.

15. The system according to claim 12, wherein the condition places a limitation on at least one of:

an amount of information to be retrieved,

a total data size of information to be retrieved,

a quantity of distinct items to be retrieved;

a quantity of cells to be returned in a multidimensional query, and

a quantity of tuples on an edge of a multidimensional query.

17. The system according to claim 12, further comprising

seventh program instructions to, after executing all of the one or more data reduction operations defined by the first aggregation parameter, determine that the identified information still does not meet the specified condition;

and

eighth program instructions to, in response to determining that the identified information still does not meet the specified condition, execute a default data reduction operation; and

wherein the seventh and eighth program instructions are stored on the non-transitory computer readable storage medium and executed by the processor via the computer readable memory.