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

• US 9,715,523 B2
• Filed: 12/05/2012
• Issued: 07/25/2017
• 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
• Primary Examiner(s): HASAN, SYED HAROON
• Application Number:
  US14/362,821
• Publication Number:
  US 20140324901A1
• Time in Patent Office: 1,693 Days
• Field of Search: None
• 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. A method for selecting and playing back on an audio system of a motor vehicle at least one data record from a relational database (101) having a plurality of data records each data record being a piece of music having associated therewith at least first and second attributes each attribute having an attribute type and an attribute value, the method comprising:

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

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

providing a first subset (104) of data records from the relational database (101) on the basis of the received stipulation for the attribute type of a first attribute, the first subset (104) being provided without regard to the received attribute value of the first attribute;

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

providing the selected data records in a second subset;

then

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

then

playing back, on the audio system of the motor vehicle, the selected at least one data record.

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

3. The method as claimed in claim 1, wherein:

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

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

4. The method as claimed in claim 3, further comprising:

selecting a plurality of data records from the second subset on the basis of the stipulation for the attribute 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.

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

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

6. A system for selecting and playing back on an audio system of a motor vehicle a data record from a relational database having a plurality of data records each data record being a piece of music having associated therewith at least first and second attributes each attribute having an attribute type and an attribute value, the system being configured to:

receive a first input as a voice input with a stipulation for the attribute type of the first attribute of the at least one data record to be selected and a stipulation of the attribute value of the first attribute;

receive a second input as a voice input with a stipulation for the attribute value of the second attribute of the at least one data record to be selected;

provide a first subset (104) of data records from the relational database (101) on the basis of the received stipulation for the attribute type of a first attribute, the first subset (104) being provided without regard to the received attribute value of the first attribute;

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

provide the selected data records in a second subset;

then

select the at least one data record from the second subset on the basis of the stipulation for the attribute value for the first attribute; and

then

play back, on the audio system of the motor vehicle, the selected at least one data record.