A Brief Review of Vertical Fragmentation Methods Considering Multimedia Databases and Content-Based Queries

Ortiz-Ballona, Aldo Osmar; Rodríguez-Mazahua, Lisbeth; López-Chau, Asdrúbal; Abud-Figueroa, María Antonieta; Romero-Torres, Celia; Castro-Medina, Felipe

doi:10.1007/978-3-030-89909-7_5

Search citation statements

Order By: Relevance

Paper Sections

Select...

Citation Types

Supporting

Mentioning

Contrasting

Year Published

2023

Publication Types

Select...

Other1

Article1

Relationship

Self Cite0

Independent2

Authors

Journals

Cited by 2 publications

References 39 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

Optimizing Multi-Media Database Performance: A Comprehensive Review of Fragmentation Methods and Dynamic Access Patterns

Mahmoud,

Abdelraouf,

Badr

et al. 2023

2023 Eleventh International Conference on Intelligent Computing and Information Systems (ICICIS)

View full text Add to dashboard Cite

Optimizing Multi-Media Database Performance: A Comprehensive Review of Fragmentation Methods and Dynamic Access Patterns

Mahmoud,

Abdelraouf,

Badr

et al. 2023

2023 Eleventh International Conference on Intelligent Computing and Information Systems (ICICIS)

View full text Add to dashboard Cite

On hierarchical clustering-based approach for RDDBS design

Abdalla,

Amer,

Ravana

2023

J Big Data

View full text Add to dashboard Cite

Distributed database system (DDBS) design is still an open challenge even after decades of research, especially in a dynamic network setting. Hence, to meet the demands of high-speed data gathering and for the management and preservation of huge systems, it is important to construct a distributed database for real-time data storage. Incidentally, some fragmentation schemes, such as horizontal, vertical, and hybrid, are widely used for DDBS design. At the same time, data allocation could not be done without first physically fragmenting the data because the fragmentation process is the foundation of the DDBS design. Extensive research have been conducted to develop effective solutions for DDBS design problems. But the great majority of them barely consider the RDDBS's initial design. Therefore, this work aims at proposing a clustering-based horizontal fragmentation and allocation technique to handle both the early and late stages of the DDBS design. To ensure that each operation flows into the next without any increase in complexity, fragmentation and allocation are done simultaneously. With this approach, the main goals are to minimize communication expenses, response time, and irrelevant data access. Most importantly, it has been observed that the proposed approach may effectively expand RDDBS performance by simultaneously fragmenting and assigning various relations. Through simulations and experiments on synthetic and real databases, we demonstrate the viability of our strategy and how it considerably lowers communication costs for typical access patterns at both the early and late stages of design.

show abstract

A Brief Review of Vertical Fragmentation Methods Considering Multimedia Databases and Content-Based Queries

Cited by 2 publications

References 39 publications

Optimizing Multi-Media Database Performance: A Comprehensive Review of Fragmentation Methods and Dynamic Access Patterns

Optimizing Multi-Media Database Performance: A Comprehensive Review of Fragmentation Methods and Dynamic Access Patterns

On hierarchical clustering-based approach for RDDBS design

Contact Info

Product

Resources

About