Indexing Voronoi cells using quadtree in spatial database

Nugroho, Eriza Tri Abdi; Adhinugraha, Kiki Maulana; Asror, Ibnu

doi:10.1109/icoict.2017.8074684

Cited by 2 publications

(1 citation statement)

References 14 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The advantages of utilizing indexes when searching are beyond doubt, even when data is used for local sorting operations in temporal tables [6,7]. However, dynamic or intelligent indexing offers many possibilities to improve the conventional indexing operations [3,8].…”

mentioning

confidence: 99%

Intelligent Indexing—Boosting Performance in Database Applications by Recognizing Index Patterns

2020

View full text Add to dashboard Cite

An issue that most databases face is the static and manual character of indexing operations. This old-fashioned way of indexing database objects is proven to affect the database performance to some degree, creating downtime and a possible impact in the performance that is usually solved by manually running index rebuild or defrag operations. Many data mining algorithms can speed up by using appropriate index structures. Choosing the proper index largely depends on the type of query that the algorithm performs against the database. The statistical analyzers embedded in the Database Management System are neither always accurate enough to automatically determine when to use an index nor to change its inner structure. This paper provides an algorithm that targets those indexes that are causing performance issues on the databases and then performs an automatic operation (defrag, recreation, or modification) that can boost the overall performance of the Database System. The effectiveness of proposed algorithm has been evaluated with several experiments developed and show that this approach consistently leads to a better resulting index configuration. The downtime of having a damaged, fragmented, or inefficient index is reduced by increasing the chances for the optimizer to be using the proper index structure.

show abstract

mentioning

confidence: 99%