Indexing techniques and structured queries for relational databases management systems

Indexing has long been used to improve the speed of relational database systems, and choosing an adequate index at design time is critical to the database's efficiency. In this study, it was demonstrated empirically that data access time and data insertion time for moderately large datasets ar...

Full description

Bibliographic Details
Published in:	Journal of Nigerian Society of Physical Sciences
Main Authors:	Isah Charles Saidu, Musa Yusuf, Florence Chukwuemeka Nemariyi, Ayenopwa Comfort George
Format:	Article
Language:	English
Published:	Nigerian Society of Physical Sciences 2024-09-01
Subjects:	Relational database systems Btree index Hash index Structured Query Language
Online Access:	https://journal.nsps.org.ng/index.php/jnsps/article/view/2155

Similar Items

INDEXING STRATEGIES FOR OPTIMIZING QUERIES ON MYSQL
by: ANCA MEHEDINŢU, et al.
Published: (2010-01-01)

Tuning Database Pada Sistem Penerimaan Mahasiswa Baru Menggunakan Optimasi Query dan Indexing
by: Amat Deska, et al.
Published: (2023-02-01)

Optimizing Blockchain Querying: A Comprehensive Review of Techniques, Challenges, and Future Directions
by: Emmanuel Acheampong Asiamah, et al.
Published: (2024-01-01)

Improved Centralized XML Query Processing Using Distributed Query Workload
by: Samini Subramaniam, et al.
Published: (2021-01-01)

HI-Sky: Hash Index-Based Skyline Query Processing
by: Jong-Hyeok Choi, et al.
Published: (2020-03-01)

Query Dictionary for Frequent Non-Indexed Queries in HTAP Databases
by: Sucharitha Shetty, et al.
Published: (2022-01-01)

Learned-Index-Based Semantic Keyword Query on Blockchain
by: Zhongming Yao, et al.
Published: (2023-04-01)

An Approach to Database Preference Queries Based on an Outranking Relation
by: Patrick Bosc, et al.
Published: (2012-08-01)

Overlay Indexes: Efficiently Supporting Aggregate Range Queries and Authenticated Data Structures in Off-the-Shelf Databases
by: Diego Pennino, et al.
Published: (2019-01-01)

Query Acceleration of Graph Databases by ID Caching Technologyb
by: Wei Jiang, et al.
Published: (2019-03-01)

A systematic review of deep learning applications in database query execution
by: Bogdan Milicevic, et al.
Published: (2024-12-01)

Protecting Private Information for Two Classes of Aggregated Database Queries
by: Xuechao Yang, et al.
Published: (2022-09-01)

A Database Query Processing Model in Peer-To-Peer Network
by: E E Ndueso, et al.
Published: (2014-07-01)

Evaluating ERD Models and RAID-Based Storage for Query Performance Optimization in Relational Databases
by: Juanda Hakim Lubis, et al.
Published: (2025-06-01)

QOTUM: The Query Optimizer for Distributed Database in Cloud Environment
by: Archana Bachhav, et al.
Published: (2024-01-01)

SQL queries over encrypted databases: a survey
by: Bo Sun, et al.
Published: (2024-12-01)

Search Condition-Hiding Query Evaluation on Encrypted Databases
by: Myungsun Kim, et al.
Published: (2019-01-01)

Functional querying in graph databases
by: Jaroslav Pokorný
Published: (2017-11-01)

OPTIMIZATION OF LOCATION BASED QUERIES USING SPATIAL INDEXING
by: S. Geetha, et al.
Published: (2014-04-01)

Resource Indexing and Querying in Large Connected Environments
by: Fouad Achkouty, et al.
Published: (2023-12-01)

INDEXES SELECTION FOR BLOCKS OF RELATED SQL QUERIES
by: Radosław BOROŃSKI
Published: (2012-06-01)

Data Query Mechanism Based on Hash Computing Power of Blockchain in Internet of Things
by: Yongjun Ren, et al.
Published: (2019-12-01)

An Indexing Method of Continuous Spatiotemporal Queries for Stream Data Processing Rules of Detected Target Objects
by: Muhammad Habibur Rahman, et al.
Published: (2021-11-01)

Analysing River Systems with Time Series Data Using Path Queries in Graph Databases
by: Erik Bollen, et al.
Published: (2023-02-01)

Query Optimization Techniques in Microsoft SQL Server
by: Costel Gabriel CORLATAN, et al.
Published: (2014-09-01)

Graph Query Processing Technology Based on Data Warehouse
by: Jiading GUO, Peng WANG
Published: (2023-09-01)

A structure to support queries in object-oriented database using fuzzy XML tags
by: Bahareh Fahimian, et al.
Published: (2014-11-01)

Performance of Graph and Relational Databases in Complex Queries
by: Petri Kotiranta, et al.
Published: (2022-06-01)

FurMoLi: A Future Query Technique for Moving Objects Based on a Learned Index
by: Jiwei Yang, et al.
Published: (2024-06-01)

LK-Index: A Learned Index for KNN Queries
by: Yongxin Peng
Published: (2024-01-01)

Query optimization in relational database systems and cloud computing technology
by: A. V. Bogdanov, et al.
Published: (2015-06-01)

QRB-tree Indexing: Optimized Spatial Index Expanding upon the QR-tree Index
by: Jieqing Yu, et al.
Published: (2021-10-01)

Creating Collections with Embedded Documents for Document Databases Taking into Account the Queries
by: Yulia Shichkina, et al.
Published: (2020-05-01)

Secure and Efficient Nearest Neighbor Query for an Outsourced Database
by: Jingjing Guo, et al.
Published: (2020-01-01)

Optimization of Dominance Testing in Skyline Queries Using Decision Trees
by: Jong-Hyeok Choi, et al.
Published: (2021-01-01)

Genetic Algorithm for Relational Database Optimization in Reducing Query Execution Time
by: Kukuh Triyuliarno Hidayat, et al.
Published: (2018-05-01)

Data Block and Tuple Identification Using Master Index
by: Michal Kvet, et al.
Published: (2020-03-01)

A personalized query method for spatial keywords in indoor environments
by: Liping Zhang, et al.
Published: (2024-11-01)

CPRQ: Cost Prediction for Range Queries in Moving Object Databases
by: Shengnan Guo, et al.
Published: (2021-07-01)

One Size Does Not Fit All: Querying Web Polystores
by: Yasar Khan, et al.
Published: (2019-01-01)