Audio Retrieval Based on Chinese Keyword Search in Relational Databases

Abstract:

In this paper, we propose a new method based on Chinese keyword search to select the WAV or MP3 files in audio post-production. First, we listen to each file and label it with Chinese characters, and then classify and store the files in a relational database system. Then, we use the techniques of Chinese keyword search to match query characters and the tuple characters quickly, and to compute similarities between the query and candidate tuples. For the characteristics of Chinese keyword search, we present a ranking strategy and an algorithm to refine the candidate tuples resulting from the first round matching, and finally get top-N results of audio files. The experimental results show that our method is efficient and effective.

• Periodical: Advanced Materials Research (Volumes 756-759)
• Pages: 3236-3240
• DOI: https://doi.org/10.4028/www.scientific.net/AMR.756-759.3236
• Online since: September 2013
• Authors: Bo Yan Zhu, Guang Liu, Liang Zhu
• Keywords: Audio Retrieval, Chinese Keyword Search, Post-Production, Ranking Strategy, Relational Database

References

[1] G. Lu, Indexing and Retrieval of Audio: A Survey, Multimedia Tools and Applications, Vol. 15, No. 3, 2001, p.269–290.

[2] D. Mitrovic, M. Zeppelzauer, and C. Breiteneder, Features for Content-Based Audio Retrieval, Advances in Computers, vol. 78, 2010, pp.71-150, doi: 10. 1016/S0065-2458(10)78003-7.

DOI: 10.1016/s0065-2458(10)78003-7

[3] S. Agrawal, S. Chaudhuri, and G. Das, DBXplorer: A System for Keyword-Based Search over Relational Database, Proceedings of the 18th International Conference on Data Engineering, San Jose, 26 February -1 March 2002, pp.5-16.

DOI: 10.1109/icde.2002.994693

[4] F. Liu, C. Yu, W. Meng, and A. Chowdhury, Effective Keyword Search in Relational Databases, 26th ACM SIGMOD/PODS International Conference on Management of Data/Principles of Database Systems, Chicago, 27-29 June 2006, pp.563-574.

DOI: 10.1145/1142473.1142536

[5] J. Yu, L. Qin and L. Chang, Keyword Search in Relational Databases: A Survey, IEEE Data Eng. Bull. Special Issue on Keyword Search, Vol. 33 No. 1, 2010, p.67–78.

DOI: 10.1007/978-3-031-79426-1_2

[6] L. Zhu, Y. Zhu, and Q. Ma, Chinese Keyword Search over Relational Databases, 2010 Second World Congress on Software Engineering (WCSE 10), Wuhan, 19-20 December 2010, pp.217-220, doi: 10. 1109/WCSE. 2010. 81.

DOI: 10.1109/wcse.2010.81