Method and system for selecting at least one data record from a relational database
View Patent ↗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.
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.
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.
7. The method as claimed in claim 5 , wherein the second subset comprises more than 30 data records.