Querying Multimedia Data by Similarity in Relational DBMS
Maria Camila N. Barioni, Daniel S. Kaster, Humberto Razente, Agma J. M. Traina, Caetano Traina · Advances in data mining and database management book series · 2011
Multimedia objects – such as images, audio, and video – do not present the total ordering relationship, so the relational operators (‘’) are not suitable to compare them. Therefore, similarity queries are the most useful, and often the only types of queries adequate to search multimedia objects stored in a database. Unfortunately, the ubiquitous query language SQL – the most widely employed language in Database Management Systems (DBMS) – does not provide effective support for similarity queries. This chapter presents an already validated strategy that adds similarity queries to SQL, supporting a powerful set of similarity operators. The chapter also describes techniques to store and retrieve multimedia objects in an efficient way and shows existing DBMS alternatives to execute similarity queries over multimedia data.