EP2788898A2 - Verfahren und system zur auswahl mindestens eines datensatzes aus einer relationalen datenbank - Google Patents

Verfahren und system zur auswahl mindestens eines datensatzes aus einer relationalen datenbank

Info

Publication number
EP2788898A2
EP2788898A2 EP12795449.3A EP12795449A EP2788898A2 EP 2788898 A2 EP2788898 A2 EP 2788898A2 EP 12795449 A EP12795449 A EP 12795449A EP 2788898 A2 EP2788898 A2 EP 2788898A2
Authority
EP
European Patent Office
Prior art keywords
attribute
subset
records
value
music
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Withdrawn
Application number
EP12795449.3A
Other languages
German (de)
English (en)
French (fr)
Inventor
Jens Walther
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Continental Automotive GmbH
Original Assignee
Continental Automotive GmbH
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Continental Automotive GmbH filed Critical Continental Automotive GmbH
Publication of EP2788898A2 publication Critical patent/EP2788898A2/de
Withdrawn legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24—Querying
    • G06F16/242—Query formulation
    • G06F16/2425—Iterative querying; Query formulation based on the results of a preceding query
    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/40—Information retrieval; Database structures therefor; File system structures therefor of multimedia data, e.g. slideshows comprising image and additional audio data
    • G06F16/43—Querying

Definitions

  • the invention relates to a method for selecting a data set from a relational database, in particular a database comprising music pieces.
  • the invention further relates to a system for selecting a data set from a relational database, in particular a database comprising music pieces.
  • voice control is used to control units of the motor vehicle.
  • voice control is used to control units of the motor vehicle.
  • a car phone or a navigation system for example, it is possible to use a car phone or a navigation system
  • US 2005/0177346 A1 shows a method for speech recognition in which recognition hypotheses can be excluded on the basis of previous rejections from a hit list.
  • the invention is characterized by a method and a corresponding system for selecting a data record from a relational database with a plurality of data records.
  • the data records each have at least two attributes.
  • the attributes each have a type and a value.
  • the type of attribute for songs is the genre type, and its value is Pop.
  • the type of attribute for songs is the album type, and its value is the value of The Art of religion.
  • a first subset of data sets from the relational database is selected in dependence on a default for the type of the first attribute and independent of the default for the value of the first attribute. Records are selected from the first subset based on a default for the second attribute. The selected records are provided in a second subset. Thereafter, records from the second subset are selected in dependence on the default for the value for the first attribute.
  • the specification for the first attribute is made by means of a first speech input with the specification for the first attribute of the data set.
  • the first preset is received.
  • the default for the second attribute by means of a second voice input with the default for the second attribute of the record.
  • the second preset is received.
  • the first specification takes place as a haptic input, for example by means of a graphical user interface.
  • the first input includes the default genre for the first attribute and pop for the value.
  • Other values for the genre type include rock, classical or audio book.
  • Another type for the first attribute includes, for example, year or another type.
  • the first subset is provided for the first attribute depending on the given type and includes for example, all genres.
  • the default for the desired genre, such as pop, is not taken into account.
  • the second input in particular in the form of a voice input, for example, as a default for the second attribute the album Sound of Silence.
  • the first subset which includes records with different assigned values for the genre, the records to which the album Sound of Silence is assigned are selected.
  • the records selected from the first subset that have the Sound of Silence album associated with them are placed in a second
  • the second subset comprises data sets with the predefined value Pop for the attribute genre and also also contains data records with a different value for the attribute genre, for example data records with the value Rock for the attribute genre.
  • the records are selected that correspond to the predetermined value for the first attribute, that is, for example, the records to which the genre Pop is assigned.
  • the relational database comprises a plurality of pieces of music which have so-called metadata as attributes.
  • the metadata include in particular title, artist, album, year and / or genre of the respective piece of music.
  • the metadata is divided into two groups depending on the frequency of their occurrence in the database. Metadata that occurs frequently in the database and therefore a large number of pieces of music in the data Bank are assigned as an attribute, such as year or genre, are also referred to as a general metadata. Metadata that are less frequently associated with pieces of music in the database, such as title, artist or album, are also referred to as specific metadata.
  • the user inputs a genre by means of the first voice input.
  • the first one For example, the first one
  • the user specifies, for example, a specific metadata, for example an album, through the second voice input.
  • the user specifies the second attribute.
  • the default for the first attribute takes place before the default for the second attribute.
  • the default for the general metadata will be made first, followed by the specification for the specific metadata.
  • the relational database that stores more than 15000 records, for example, there are 10000 records that have populated the genre as an attribute.
  • the database stores 11 records that have the Sound of Silence attribute as their album.
  • the data records are first selected from the database and provided as the first subset, independently of the respective assigned value for the first attribute. Then, from the first subset, the records corresponding to the second, more specific Sound of Silence attribute are selected. In this selection and deployment, the preference for the value for the first attribute is disregarded, and the records are provided independently of the default value for the first attribute.
  • those data sets are selected from the second subset, which also the default for the value for meet the first attribute, so for example have also assigned the genre pop as an attribute. Records that have a music genre other than Pop, such as Rock, associated with the first Genre attribute are removed from the second subset.
  • the second subset is provided as a function of the more specific specification or of the more specific attribute, and only when the specification for the value for the first attribute is taken into account, makes it possible to quickly and conveniently select the desired data records.
  • a selection from a large number of data records of, for example, more than 15,000 data records is easily possible.
  • inexpensive hardware for the system.
  • the system is in particular part of a motor vehicle.
  • the method or the system makes it possible for the user of the motor vehicle to reliably and conveniently select pieces of music from a database with several thousand music titles by voice control.
  • a system 100 includes a database 101.
  • the database 101 is a relational database and includes a plurality of records.
  • the database includes music tracks, for example in MP3 format.
  • the music titles are stored, for example, on a fixed memory of a motor vehicle.
  • the music titles are stored on a mobile terminal, for example a smartphone or a USB stick, which is with the motor vehicle can be coupled.
  • the music titles of the database 101 can be played back via an audio system of the motor vehicle.
  • the system 100 includes a user interface 102 coupled to a voice recognizer 103. Through the user interface 102 with the speech recognizer 103, a voice control for selecting one or more pieces of music from the database 101 is possible. In particular, a piece of music is selected for playback.
  • a complete list 104 of all data records from the database 101 is transmitted to the speech recognizer 103.
  • a plurality of lists 104 are transmitted, one list for each type of an attribute of the data records of the database 101.
  • one of the lists 104 contains all the titles of the pieces of music in the database 101.
  • Another of the lists 104 contains all the albums of the pieces of music in the database 101
  • Another list contains all the interpreters of the pieces of music in the database 101.
  • a further list contains, for example, all years of the pieces of music in the database 101.
  • a further list of the lists 104 contains, for example, all genres of the pieces of music in the database 101.
  • the list of genres comprises as values, for example the genre pop, rock and classical and / or more values.
  • the lists are in each case subsets of data records from the database 101.
  • the user specifies a desired genre.
  • Speech Recognizer 103 recognizes what type of attribute was specified by the user without taking into account the value of the attribute at that time. For example, it is determined by the speech recognizer that the user has specified a default for the genre of the desired pieces of music. Thus, from the lists 104, the list containing the music pieces of all genres of the database 101 is selected.
  • the second prescription by voice by the user includes, for example, a default for the title of the desired piece of music.
  • the speech recognizer 103 selects from the list containing the pieces of music of all genres a predetermined number of pieces of music which best match the given title. The selected pieces of music will be provided in another sub-list. This is done independently of the default value for the genre.
  • the speech recognizer 103 transmits to the user interface 102 the detected pieces of music. These are also called result hypotheses.
  • the speech recognizer 103 provides at least five, in particular more than ten, result hypotheses.
  • Speech recognizer 103 provides more than 20 records for user interface 102, in particular more than 30 records and at most 50 records, according to embodiments.
  • the user interface 102 selects from the pieces of music provided by the speech recognizer 103 those to which the given genre is assigned. For example, the pieces of music that have pop associated with the genre are selected and these are provided to the user as a result. Those pieces of music which have assigned a genre other than the predefined one, for example a genre other than pop, for example rock or classical, are removed by the user interface 102 from the subset provided by the speech recognizer 103.
  • a maximum number of data sets is predetermined, which is to be provided to the user as a result.
  • the user should be shown at least 5 and at most 7 pieces of music which best correspond to his selection and have the highest correlation with respect to the data records of the database 101 with the language specifications.
  • another value for the maximum value of result data sets is predetermined, for example a maximum of 10 music pieces.
  • no lower limit is specified, so that a number of 0 data sets is possible.
  • Step 201 symbolizes speech recognition.
  • Step 202 symbolizes the formation of hypotheses and step 203 symbolizes the provision of the records selected from the list 104 as a second subset.
  • Step 204 symbolizes the adjustment of the second subset with the specification for the value for the first attribute.
  • Step 205 symbolizes the filling of the lists 104 at system start.
  • step 206 the records selected after step 204 are retrieved from the database and displayed, for example, via the audio system of the motor vehicle.
  • the method makes it possible to select data sets from large subsets without creating long latencies.

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Mathematical Physics (AREA)
  • Computational Linguistics (AREA)
  • Multimedia (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
EP12795449.3A 2011-12-06 2012-12-05 Verfahren und system zur auswahl mindestens eines datensatzes aus einer relationalen datenbank Withdrawn EP2788898A2 (de)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
DE102011087843A DE102011087843B4 (de) 2011-12-06 2011-12-06 Verfahren und System zur Auswahl mindestens eines Datensatzes aus einer relationalen Datenbank
PCT/EP2012/074519 WO2013083639A2 (de) 2011-12-06 2012-12-05 Verfahren und system zur auswahl mindestens eines datensatzes aus einer relationalen datenbank

Publications (1)

Publication Number Publication Date
EP2788898A2 true EP2788898A2 (de) 2014-10-15

Family

ID=47290992

Family Applications (1)

Application Number Title Priority Date Filing Date
EP12795449.3A Withdrawn EP2788898A2 (de) 2011-12-06 2012-12-05 Verfahren und system zur auswahl mindestens eines datensatzes aus einer relationalen datenbank

Country Status (5)

Country Link
US (1) US9715523B2 (zh)
EP (1) EP2788898A2 (zh)
CN (1) CN103975326B (zh)
DE (1) DE102011087843B4 (zh)
WO (1) WO2013083639A2 (zh)

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105787619A (zh) * 2014-12-25 2016-07-20 阿里巴巴集团控股有限公司 一种数据处理方法、装置及系统
US12057114B2 (en) * 2018-11-02 2024-08-06 Spotify Ab Media content steering

Family Cites Families (24)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5548749A (en) * 1993-10-29 1996-08-20 Wall Data Incorporated Semantic orbject modeling system for creating relational database schemas
IL127790A (en) * 1998-04-21 2003-02-12 Ibm System and method for selecting, accessing and viewing portions of an information stream(s) using a television companion device
US6990453B2 (en) * 2000-07-31 2006-01-24 Landmark Digital Services Llc System and methods for recognizing sound and music signals in high noise and distortion
FI20002161A (fi) * 2000-09-29 2002-03-30 Nokia Mobile Phones Ltd Menetelmä ja järjestelmä melodian tunnistamiseksi
DE10058811A1 (de) * 2000-11-27 2002-06-13 Philips Corp Intellectual Pty Verfahren zur Identifizierung von Musikstücken
US6665642B2 (en) * 2000-11-29 2003-12-16 Ibm Corporation Transcoding system and method for improved access by users with special needs
US6973429B2 (en) * 2000-12-04 2005-12-06 A9.Com, Inc. Grammar generation for voice-based searches
DE10104831A1 (de) 2001-02-01 2002-08-08 Sap Ag Datenstruktur für Informationssysteme
DE10113515A1 (de) * 2001-03-20 2002-10-02 Bfm Building & Facility Man Gm Datenbanksystem
EP1472625A2 (en) * 2002-01-24 2004-11-03 Koninklijke Philips Electronics N.V. Music retrieval system for joining in with the retrieved piece of music
JP2004163590A (ja) * 2002-11-12 2004-06-10 Denso Corp 再生装置及びプログラム
US7437296B2 (en) * 2003-03-13 2008-10-14 Matsushita Electric Industrial Co., Ltd. Speech recognition dictionary creation apparatus and information search apparatus
DE10331817A1 (de) * 2003-07-14 2005-02-17 Eckert, Thomas Computergestütztes Verfahren zur automatischen Abfrage von Informationen aus als sematisches Netz strukturierten Datenbanken
US20050177346A1 (en) 2004-02-11 2005-08-11 Williams Matthew R. Process parameter monitoring system and method of use
DE102005056551A1 (de) * 2004-11-25 2006-06-01 Wittkötter, Erland, Dr. Video Daten Verzeichnis
JP4042743B2 (ja) 2004-12-27 2008-02-06 ブラザー工業株式会社 リクエスト装置及びプログラム
KR100643309B1 (ko) * 2005-08-19 2006-11-10 삼성전자주식회사 클러스터링을 이용하여 오디오 파일을 제공하는 장치 및 그방법
US7949529B2 (en) * 2005-08-29 2011-05-24 Voicebox Technologies, Inc. Mobile systems and methods of supporting natural language human-machine interactions
US8090374B2 (en) * 2005-12-01 2012-01-03 Quantenna Communications, Inc Wireless multimedia handset
US20070222734A1 (en) * 2006-03-25 2007-09-27 Tran Bao Q Mobile device capable of receiving music or video content from satellite radio providers
US20080153465A1 (en) * 2006-12-26 2008-06-26 Voice Signal Technologies, Inc. Voice search-enabled mobile device
CN101296365A (zh) 2008-06-03 2008-10-29 中国网络通信集团公司 鉴权认证方法及系统、用户识别卡和机顶盒
GB2465383B (en) 2008-11-14 2011-09-21 Toshiba Res Europ Ltd A speech recognition method and system
JP5697860B2 (ja) * 2009-09-09 2015-04-08 クラリオン株式会社 情報検索装置，情報検索方法及びナビゲーションシステム

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See references of WO2013083639A2 *

Also Published As

Publication number Publication date
DE102011087843A1 (de) 2013-06-06
WO2013083639A2 (de) 2013-06-13
CN103975326A (zh) 2014-08-06
CN103975326B (zh) 2018-01-12
US9715523B2 (en) 2017-07-25
DE102011087843B4 (de) 2013-07-11
US20140324901A1 (en) 2014-10-30
WO2013083639A3 (de) 2013-08-01

Similar Documents

Publication Publication Date Title
DE112007001774B4 (de) Verfahren und System zum Durchsuchen von Musik
DE102006023226B4 (de) Verfahren zum menügesteuerten Auswählen von Menüpunkten, denen Dateien zugeordnet sind, die Audio- und/oder Videodaten enthalten
DE112016006155T5 (de) Erstellen und verteilen von wiedergabelisten mit musik und geschichten mit verwandten stimmungen
DE102012220015A1 (de) System und Verfahren zum Zeigen eines Cover-Graphikdesigns an einer Anzeige
DE102014100412A1 (de) Verfahren und vorrichtung zur werbungsvorführung
DE112011106041T5 (de) Suchvorrichtung
DE112020002293T5 (de) Computerimplementiertes Verfahren und System zur Inhaltsempfehlung für einen Benutzer an Bord eines Fahrzeugs
DE102017126107A1 (de) Verfahren zum Betreiben einer Küchenmaschine, Küchenmaschine sowie Ambientesystem
DE102014218162A1 (de) Verfahren und vorrichtung zum empfangen und verarbeiten von medienempfehlungen
DE102007037567A1 (de) Verfahren zur multimodalen Bedienung mindestens eines Gerätes in einem Kraftfahrzeug
WO2013083639A2 (de) Verfahren und system zur auswahl mindestens eines datensatzes aus einer relationalen datenbank
DE102010017101A1 (de) Computerimplementiertes System für ein Monitoring einer multimodalen Zugänglichkeit zu einer Mehrzahl von Medienartikeln
DE102015005007A1 (de) Verfahren zur Verbesserung der Klangqualität einer Audiodatei
EP1939768A2 (de) Verfahren und Vorrichtung zur Auswahl von charakterisierbaren Datensätzen
DE102016226042B4 (de) Vorrichtung, Fortbewegungsmittel und Verfahren zur Gestaltung eines Übergangs zwischen zwei Audio-Dateien
DE112005000741T5 (de) Programmtabellen-Erzeugungsverfahren, Programmtabellen-Erzeugungsvorrichtung und Programmtabellen-Erzeugungssystem
WO2018015041A1 (de) Verfahren zum konfigurieren einer sprachgesteuerten bedienvorrichtung, bedienvorrichtung mit sprachsteuerung und kraftfahrzeug
DE102013000822B3 (de) Verfahren zum Bereitstellen von Medieninhalten mittels eines Unterhaltungselektroniksystems eines Kraftwagens
DE102019131886A1 (de) Verfahren zum Betreiben eines Kommunikationsassistenten
DE102009058151B4 (de) Verfahren zum Betreiben eines Sprachdialogsystems mit semantischer Bewertung und Sprachdialogsystem dazu
DE102013009569B4 (de) Verfahren zum Betreiben eines Infotainmentsystems zum Beschaffen einer Wiedergabeliste für eine Audiowiedergabe in einem Kraftfahrzeug, Infotainmentsystem sowie Kraftwagen umfassend ein Infotainmentsystem
DE102019201615A1 (de) Verfahren zur Anpassung der Klangcharakteristik bei der Wiedergabe aufeinander folgender Audiostücke
DE102011112887A1 (de) Verfahren zur kontextbezogenen Informationsabfrage
DE102017103533A1 (de) Verfahren und Vorrichtung zur textbezogenen Vorschau von Inhalten von Audiodateien
AT505828B1 (de) Automatische verbesserung des musikangebots

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

17P Request for examination filed

Effective date: 20140707

AK Designated contracting states

Kind code of ref document: A2

Designated state(s): AL AT BE BG CH CY CZ DE DK EE ES FI FR GB GR HR HU IE IS IT LI LT LU LV MC MK MT NL NO PL PT RO RS SE SI SK SM TR

DAX Request for extension of the european patent (deleted)
STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: THE APPLICATION IS DEEMED TO BE WITHDRAWN

18D Application deemed to be withdrawn

Effective date: 20150128