Method and system for selecting at least one data record from a relational database

• US 20140324901A1
• Filed: 12/05/2012
• Published: 10/30/2014
• Est. Priority Date: 12/06/2011
• Status: Active Grant

• Current Assignee: Continental Automotive GmbH (Continental AG)
• Original Assignee: Continental Automotive GmbH (Continental AG)
• Inventors: Walther, Jens
• Granted Patent: US 9,715,523 B2
• Time in Patent Office: Days
• US Class Current: 707/758
• CPC Class Codes: G06F 16/24 Querying
• CPC Class Codes: G06F 16/2425 Iterative querying; Query formulation based on the results of a preceding query
• CPC Class Codes: G06F 16/43 Querying

Abstract

A method for selecting at least one data record from a relational database having a plurality of data records each having at least two attributes each with a type of the attribute and a value of the attribute includes: providing a first subset of data records from the relational database on the basis of a stipulation for the type of a first attribute and independently of a stipulation for the value of the first attribute; selecting data records from the first subset on the basis of a stipulation for a second attribute; providing the selected data records in a second subset; and then selecting the at least one data record from the second subset on the basis of the stipulation for the value for the first attribute.

Claims

1-9. -9. (canceled)

10. A method for selecting at least one data record from a relational database (101) having a plurality of data records each having at least two attributes each with a type of the attribute and a value of the attribute, the method comprising:

providing a first subset (104) of data records from the relational database (101) on the basis of a stipulation for the type of a first attribute and independently of a stipulation for the value of the first attribute;

selecting data records from the first subset (104) on the basis of a stipulation for a second attribute;

providing the selected data records in a second subset; and

then

selecting the at least one data record from the second subset on the basis of the stipulation for the value for the first attribute.

11. The method as claimed in claim 10, further comprising:

receiving a first input as a voice input with a stipulation for the first attribute of the at least one data record to be selected.

12. The method as claimed in claim 11, further comprising:

receiving a second input as a voice input with a stipulation for the second attribute of the at least one data record to be selected.

13. The method as claimed in claim 12, wherein the first input is received before receiving the second input.

14. The method as claimed in claim 13, wherein receiving the first and second voice inputs respectively comprise:

receiving a stipulation for the type of the attribute; and

then

receiving a stipulation for the value of the attribute.

15. The method as claimed in claim 14, further comprising:

receiving a general metadata item for pieces of music as a stipulation for the first attribute by the first voice input from the group consisting of a year and a genre for a piece of music; and

receiving a specific metadata item for pieces of music as a stipulation for the second attribute by the second voice input from the group consisting of a title, an artist and an album for a piece of music.

16. The method as claimed in claim 15, further comprising:

selecting a plurality of data records from the second subset on the basis of the stipulation for the value for the first attribute, a maximum value being stipulated for the number of data records to be selected; and

providing the second subset on the basis of the stipulated maximum value.

17. The method as claimed in claim 16, wherein the second subset comprises at least 20 data records.

19. The method as claimed in claim 17, wherein the second subset comprises more than 30 data records.

18. A system for selecting a data record from a relational database having a plurality of data records each having at least two attributes with a type and a value, the system being configured to:

provide a first subset (104) of data records from the relational database (101) on the basis of a stipulation for the type of a first attribute and independently of a stipulation for the value of the first attribute;

select data records from the first subset (104) on the basis of a stipulation for a second attribute;

provide the selected data records in a second subset, and then select the at least one data record from the second subset on the basis of the stipulation for the value for the first attribute.