Abstract
A music structured query language, called MuSQL, is presented in this paper. MuSQL consists of a schema definition sub-language and a data manipulation sub-language. The former is composed of schema-setup statements, schema-alter statements, and schema-drop statements. The latter is composed of selection, retrieval, extraction, insertion, update, deletion, commission, rollback, and other statements. MuSQL can be used to cut, delete and merge content of music, insert, delete and extract features of music, and exactly or approximately search music pieces, especially in the processing of music based on content. Also, it makes some music processing operations easier due to its built-in semantics. MuSQL has been implemented in a music data management system.
This work was supported by the NSF of China under Grant No. 60473077 and Program for New Century Excellent Talents in University.
This is a preview of subscription content, log in via an institution.
Buying options
Tax calculation will be finalised at checkout
Purchases are for personal use only
Learn about institutional subscriptionsPreview
Unable to display preview. Download preview PDF.
References
Wang, C., Li, J., Shi, S.: The Design and Implementation of a Digital Music Library. International Journal on Digital Libraries 6(1), 82–97 (2006)
Good, M.: MusicXML in Practice: Issues in Translation and Analysis. In: Proceedings of the First International Conference MAX 2002: Musical Application Using XML, Milan, Italy, pp. 47–54 (2002)
Li, J.Z., Özsu, M.T., Szafron, D., Oria, V.: MOQL: A Multimedia Object Query Language. In: Proceedings of the Third International Workshop on Multimedia Information Systems, Como, Italy, pp. 19–28 (1997)
Henrich, A., Robbert, G.: POQLMM: A Query Language for Structured Multimedia Documents. In: Proceedings of the First International Workshop on Multimedia Data and Document Engineering, Lyon, Frankreich, pp. 17–26 (2001)
Amato, G., Mainetto, G., Savino, P.: A Query Language for Similarity-Based Retrieval of Multimedia Data. In: Proceedings of the First East-European Symposium on Advances in Databases and Information Systems, St. Petersburg, pp. 196–203 (1997)
Chang, Y.I., Jair, S.H., Chen, H.N.: Design and Implementation of the QBOE Query Language for Multimedia Database Systems. Proceedings of the NSC – Part A: Physical Science and Engineering 21(3), 205–221 (1997)
Hirzalla, N., Karmouch, A.: A Data Model and a Query Language for Multimedia Documents Databases. Multimedia Systems 7(4), 338–348 (1999)
Zhang, C., Meng, W., Zhang, Z., Wu, Z.: WebSSQL — A Query Language for Multimedia Web Documents. In: Proceedings of the IEEE Advances in Digital Libraries, Washington, DC, USA, pp. 58–67. IEEE Computer Society, Los Alamitos (2000)
Dionisio, J.D.N., Cárdenas, A.F.: MQuery: A Visual Query Language for Multimedia, Timeline and Simulation Data. Journal of Visual Languages and Computing 7(4), 377–401 (1996)
Arnold-Moore, T., Fuller, M., Lowe, B., Thom, J., Wilkinson, R.: The ELF data model and SGQL query language for structured document databases. In: Proceedings of the Australasian Database Conference, Adelaide, Australia, pp. 17–26 (1995)
Abiteboul, S., Quass, D., McHugh, J., Widom, J., Wiener, J.: The Lorel Query Language for Semistructured Data. International Journal on Digital Libraries 1(1), 68–88 (1997)
Town, C., Sinclair, D.: Ontological Query Language for Content Based Image Retrieval. In: Proceedings of IEEE Workshop on Content-based Access of Image and Video Libraries, pp. 75–81 (2001)
Kuo, T.C., Chen, A.L.: A Content-Based Query Language for Video Databases. In: Proceedings of IEEE International Conference on Multimedia Computing and Systems, pp. 209–214 (1996)
Wang, C., Li, J., Shi, S.: A Music Data Model and its Application. In: Proceedings of the 10th International Conference on MultiMedia Modeling, Brisbane, Australia, pp. 79–84. IEEE Computer Society Press, Los Alamitos (2004)
Naur, P. (ed.).: Revised Report on the Algorithmic Language ALGOL 60. Communications of the ACM 3(5), 299–314 (1960)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2006 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Wang, C., Wang, J., Li, J., Sun, JG., Shi, S. (2006). MuSQL: A Music Structured Query Language. In: Cham, TJ., Cai, J., Dorai, C., Rajan, D., Chua, TS., Chia, LT. (eds) Advances in Multimedia Modeling. MMM 2007. Lecture Notes in Computer Science, vol 4352. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-69429-8_22
Download citation
DOI: https://doi.org/10.1007/978-3-540-69429-8_22
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-69428-1
Online ISBN: 978-3-540-69429-8
eBook Packages: Computer ScienceComputer Science (R0)