Database Index Balancing Strategy

Proceedings of the XXth Conference of Open Innovations Association FRUCT

卷:29

Michal Kvet¹ 

[1] Zilinska univerzita / Fakulta riadenia a informatiky, Slovakia;

关键词: null management;    database index;    balancing;    migrated row;    performance;   

DOI  :  10.23919/FRUCT52173.2021.9435452

来源: DOAJ

【 摘 要 】

Database index is a specific object, by which the data can be accessed effectively. Default relational database index is B+tree, which is balanced to ensure consistent and fast access traverse path. By using index, data retrieval process can benefit. Vice versa, other manipulation operations, must apply all changes to the structure causing the performance drop. This paper deals with the data indexing techniques. It extends the already defined Notice list layer and segregates the balancing strategy into the separate process, by which the original transaction can be approved sooner. Thanks to that, Insert, Update and Delete operations are influenced only in minimal manner, but the robustness of the indexing strategy is always ensured limiting the whole data block set scanning necessity.

【 授权许可】

Unknown