Autonomous Temporal Time Zone Management

Kvet, Michal

doi:10.1109/iecon48115.2021.9589547

Cited by 1 publication

(1 citation statement)

References 11 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…In that case, the index is made visible, but the optimizer creates a SQL plan baseline to prevent existing queries from being degraded [36,54]. Thanks to that, there is no performance regression done by the automatic tasksanalyzers and advisors.…”

Section: Algorithm Select Index_name Visibilitymentioning

confidence: 99%

The Complexity of the Data Retrieval Process Using the Proposed Index Extension

Kvet

Papán²

2022

IEEE Access

View full text Add to dashboard Cite

Data retrieval, access, and tuple identification are inevitable in database processing, ensuring performance. The entities and relationships form a relational database. Data themselves are not specifically formatted, requiring sequential data block scanning if the particular index is unavailable. This paper summarizes existing indexing principles focusing on the B+tree, which forms the default structure for data access based on the index key. Such design is reliable and prone to an increase in the amount of data. However, it cannot manage undefined values properly, whereas they cannot be mathematically compared. Secondly, migrated rows can be present due to the size demand extension after the update operation. Thirdly, the index is always balanced, resulting in additional demands of the transaction. All these factors are covered by the proposed paper, discussing the limitations, opportunities, and own solutions to improve the performance. Several architectures are discussed, maintained, and computationally studied, focusing on the size demands, processing time, and costs. By using proposed techniques, significant improvements can be reached. A pointer list is introduced for migrated row management to reference the index set from the data block and store reference path or using a data reflector. When dealing with transaction support, index management and rebalancing are shifted to the separate autonomous transaction. Thanks to that, the main transaction can be approved sooner with no reliability issues. Finally, the proposed paper introduces the NULL value management structure in the instance memory for the index node reference.

show abstract

Section: Algorithm Select Index_name Visibilitymentioning

confidence: 99%