Abstract
Vertical partitioning is a design technique widely employed in relational databases to reduce the number of irrelevant attributes accessed by the queries. Currently, due to the popularity of multimedia applications on the Internet, the need of using partitioning techniques in multimedia databases has arisen in order to use their potential advantages with regard to query optimization. In multimedia databases, the attributes tend to be of very large multimedia objects. Therefore, the reduction in the number of accesses to irrelevant objects would imply a considerable cost saving in the query execution. Nevertheless, the use of vertical partitioning techniques in multimedia databases implies two problems: 1) most vertical partitioning algorithms only take into account alphanumeric data, and 2) the partitioning process is carried out in a static way. In order to address these problems, we propose an active system called DYMOND, which performs a dynamic vertical partitioning in multimedia databases to improve query performance. Experimental results on benchmark multimedia databases clarify the validness of our system.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Navathe, S., Ceri, S., Wiederhold, G., Dou, J.: Vertical Partitioning Algorithms for Database Design. ACM TODS 4, 680–710 (1984)
Guinepain, S., Gruenwald, L.: Automatic Database Clustering Using Data Mining. In: DEXA 2006 (2006)
Fung, C., Karlapalem, K., Li, Q.: An Evaluation of Vertical Class Partitioning for Query Processing in Object-Oriented Databases. IEEE Transactions on Knowledge and Data Engineering 14, 1095–1118 (2002)
Fung, C., Karlapalem, K., Li, Q.: Cost-driven Vertical Class Partitioning for Methods in Object Oriented Databases. The VLDB Journal 12(3), 187–210 (2003)
Fung, C., Leung, E.W., Li, Q.: Efficient Query Execution Techniques in a 4DIS Video Database System for eLearning. Multimedia Tools and Applications 20, 25–49 (2003)
Rodriguez, L., Li, X.: A Vertical Partitioning Algorithm for Distributed Multimedia Databases. In: Hameurlain, A., Liddle, S.W., Schewe, K.-D., Zhou, X. (eds.) DEXA 2011, Part II. LNCS, vol. 6861, pp. 544–558. Springer, Heidelberg (2011)
Van Doorn, M.G.L.M., De Vries, A.P.: The Psychology of Multimedia Databases. In: Proc. of the Fifth ACM Conf. on Digital Libraries, pp. 1–9. ACM (2000)
Guinepain, S., Gruenwald, L.: Research Issues in Automatic Database Clustering. SIGMOD Record 34, 33–38 (2005)
Chaudhuri, S., Konig, A.C., Narasayya, V.: SQLCM: a Continuous Monitoring Framework for Relational Database Engines. In: Proc. 20th Int. Data Engineering Conf., pp. 473–484 (2004)
Paton, N.W., DÃaz, O.: Active Database Systems. ACM Comput. Surv. 31, 63–103 (1999)
Agrawal, S., Narasayya, V., Yang, B.: Integrating Vertical and Horizontal Partitioning into Automated Physical Database Design. In: Proc. of ACM SIGMOD, pp. 359–370 (2004)
Zhenjie, L.: Adaptive Reorganization of Database Structures Through Dynamic Vertical Partitioning of Relational Tables, MCompSc Thesis, University of Wollongong (2007)
Papadomanolakis, S., Ailamaki, A.: AutoPart: automating schema design for large scientific databases using data partitioning. In: Proc. 16th Int. Scientific and Statistical Database Management Conf., pp. 383–392 (2004)
Ezeife, C., Zheng, J.: Measuring the Performance of Database Object Horizontal Fragmentation Schemes. In: Int. Symposium Database Engineering and Applications, pp. 408–414 (1999)
Chbeir, R., Laurent, D.: Towards a Novel Approach to Multimedia Data Mixed Fragmentation. In: Proc. of the Int. Conf. on Manage. of Emergent Digital EcoSyst., MEDES (2009)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2012 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
RodrÃguez, L., Li, X. (2012). Dynamic Vertical Partitioning of Multimedia Databases Using Active Rules. In: Liddle, S.W., Schewe, KD., Tjoa, A.M., Zhou, X. (eds) Database and Expert Systems Applications. DEXA 2012. Lecture Notes in Computer Science, vol 7447. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-32597-7_17
Download citation
DOI: https://doi.org/10.1007/978-3-642-32597-7_17
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-642-32596-0
Online ISBN: 978-3-642-32597-7
eBook Packages: Computer ScienceComputer Science (R0)