多媒体关系型数据库性能:案例研究

Proceedings of the 19th International Conference on Content-based Multimedia Indexing Pub Date : 2022-09-14 DOI:10.1145/3549555.3549558

Björn þór Jónsson, Aaron Duane, Nikolaj Mertz

{"title":"多媒体关系型数据库性能:案例研究","authors":"Björn þór Jónsson, Aaron Duane, Nikolaj Mertz","doi":"10.1145/3549555.3549558","DOIUrl":null,"url":null,"abstract":"This paper describes the performance optimisation of a state-of-the-art relational database to more efficiently serve data for multimedia visualisations in the ViRMA prototype. We describe the baseline database and queries, along with two major optimisation steps that improve query efficiency, at the cost of slowing down dynamic updates. We evaluate the optimisations with a case study of a lifelog collection of 182K images, showing that the time to produce complex visualisations is reduced by orders of magnitude.","PeriodicalId":191591,"journal":{"name":"Proceedings of the 19th International Conference on Content-based Multimedia Indexing","volume":"85 2","pages":"0"},"PeriodicalIF":0.0000,"publicationDate":"2022-09-14","publicationTypes":"Journal Article","fieldsOfStudy":null,"isOpenAccess":false,"openAccessPdf":"","citationCount":"1","resultStr":"{\"title\":\"Relational Database Performance for Multimedia: A Case Study\",\"authors\":\"Björn þór Jónsson, Aaron Duane, Nikolaj Mertz\",\"doi\":\"10.1145/3549555.3549558\",\"DOIUrl\":null,\"url\":null,\"abstract\":\"This paper describes the performance optimisation of a state-of-the-art relational database to more efficiently serve data for multimedia visualisations in the ViRMA prototype. We describe the baseline database and queries, along with two major optimisation steps that improve query efficiency, at the cost of slowing down dynamic updates. We evaluate the optimisations with a case study of a lifelog collection of 182K images, showing that the time to produce complex visualisations is reduced by orders of magnitude.\",\"PeriodicalId\":191591,\"journal\":{\"name\":\"Proceedings of the 19th International Conference on Content-based Multimedia Indexing\",\"volume\":\"85 2\",\"pages\":\"0\"},\"PeriodicalIF\":0.0000,\"publicationDate\":\"2022-09-14\",\"publicationTypes\":\"Journal Article\",\"fieldsOfStudy\":null,\"isOpenAccess\":false,\"openAccessPdf\":\"\",\"citationCount\":\"1\",\"resultStr\":null,\"platform\":\"Semanticscholar\",\"paperid\":null,\"PeriodicalName\":\"Proceedings of the 19th International Conference on Content-based Multimedia Indexing\",\"FirstCategoryId\":\"1085\",\"ListUrlMain\":\"https://doi.org/10.1145/3549555.3549558\",\"RegionNum\":0,\"RegionCategory\":null,\"ArticlePicture\":[],\"TitleCN\":null,\"AbstractTextCN\":null,\"PMCID\":null,\"EPubDate\":\"\",\"PubModel\":\"\",\"JCR\":\"\",\"JCRName\":\"\",\"Score\":null,\"Total\":0}","platform":"Semanticscholar","paperid":null,"PeriodicalName":"Proceedings of the 19th International Conference on Content-based Multimedia Indexing","FirstCategoryId":"1085","ListUrlMain":"https://doi.org/10.1145/3549555.3549558","RegionNum":0,"RegionCategory":null,"ArticlePicture":[],"TitleCN":null,"AbstractTextCN":null,"PMCID":null,"EPubDate":"","PubModel":"","JCR":"","JCRName":"","Score":null,"Total":0}

引用次数: 1

摘要

本文描述了一个最先进的关系数据库的性能优化，以更有效地为ViRMA原型中的多媒体可视化提供数据。我们描述了基线数据库和查询，以及两个主要的优化步骤，以降低动态更新的速度为代价，提高查询效率。我们用一个182K图像的生活日志集合的案例研究来评估优化，表明生成复杂可视化的时间减少了几个数量级。

本文章由计算机程序翻译，如有差异，请以英文原文为准。

查看原文本刊更多论文

Relational Database Performance for Multimedia: A Case Study

This paper describes the performance optimisation of a state-of-the-art relational database to more efficiently serve data for multimedia visualisations in the ViRMA prototype. We describe the baseline database and queries, along with two major optimisation steps that improve query efficiency, at the cost of slowing down dynamic updates. We evaluate the optimisations with a case study of a lifelog collection of 182K images, showing that the time to produce complex visualisations is reduced by orders of magnitude.

求助全文

通过发布文献求助，成功后即可免费获取论文全文。去求助

来源期刊

Proceedings of the 19th International Conference on Content-based Multimedia Indexing

自引率

0.00%

发文量