Query Optimization In MySQL Database Using Index

Maesaroh, Siti; Gunawan, Heru; Lestari, Agung; Tsaurie, Muhammad Sufyan Ats; Fauji, Mohamad

doi:10.34306/ijcitsm.v2i2.84

Cited by 12 publications

(7 citation statements)

References 18 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Query Optimization In MySQL Database Using Index [10] The findings of this study revealed that the quality of the database design has a substantial influence on the quality of the information system. Even after a system has been in use for some time, a programmer could forget to optimize a MySQL query, even if optimization is crucial owing to the enormous amount of data.…”

Section: Literature Reviewmentioning

confidence: 92%

MySQL Select Query Optimization Using Self-Join

Madavi,

Patel,

Jain

et al. 2023

Int. J. Res. Publ. Rev.

View full text Add to dashboard Cite

The challenge of query execution in MySQL involves the efficient and accurate processing of SQL queries to retrieve, manipulate, and store data in a database. It requires optimizing the query execution plan, identifying and resolving performance issues, and ensuring data integrity and security. The challenge lies in balancing the trade-offs between query complexity, database size, system resources, and user requirements. Choosing the right approach depends on the specific characteristics of the data and workload. Therefore, in this paper, we have applied various techniques to get optimized results.

show abstract

Section: Literature Reviewmentioning

confidence: 92%

MySQL Select Query Optimization Using Self-Join

Madavi,

Patel,

Jain

et al. 2023

Int. J. Res. Publ. Rev.

View full text Add to dashboard Cite

show abstract

“…For example, the data query performance can be greatly improved through vertical segmentation and horizontal segmentation. Literature [5] states that using an index can help speed up database searches. In addition, it is necessary to reconsider the rules and conduct a thorough examination.…”

Section: Related Workmentioning

confidence: 99%

Electricity safety inspection data model optimization method based on concurrent access constraints

Zhang

Yuan²,

Xue

et al. 2023

3rd International Conference on Artificial Intelligence, Automation, and High-Performance Computing (AIAHPC 2023)

View full text Add to dashboard Cite

In the field of electricity safety inspection, with the increase of the scale and complexity of the business process, the business process has dynamic changes. But the data model is not adapted to the dynamic changes in the business process. Therefore, in the business process of concurrent access to the database, it is easy to lead to data access conflict, reduce database concurrent access efficiency, and lead to increased business development costs. At present, there are many research results in business processes and database optimization, but there are still some mature and perfect optimization of the theory of databases, which can consider the optimization of business processes and business process data models. The data model optimization algorithm proposed in this article can be used to reduce database access conflicts of concurrent business processes, so that the data model can adapt to the dynamic changes in the business process, thereby improving the efficiency of concurrent access to the database.

show abstract

“…This scheme helps to transform data that is represented in high-level into structures of database management systems. Data query, data manipulation, data identity, and data access control are some of the key operations associated with MySQL [14]. This system's database is made up of various tables responsible for storing records that correspond to all authorised users accessing the system.…”

Section: Databasementioning

confidence: 99%

A Parent Authentication System for the Security of Pre-basic School Pupils

et al. 2023

IJFMR

View full text Add to dashboard Cite

The safety of pupils is of uttermost concern to school authorities and especially parents in this age of rampant kidnappings and other malicious activities by unscrupulous people within the human ecosystem. In this paper, a robust security system, referred to as a Parent Authentication System (PAS) is designed and implemented using bi-modal authentication and/or verification mechanisms for the safety of Pre-Basic School pupils. The primary module for authentication and verification is Fingerprint (i.e. biometrics) with an alternative module of a Password which, can only be used if the primary module fails or rejects the biometrics of a particular user. The Agile System Development Life Cycle Prototyping model was leveraged to design the system; all key components responsible for the functioning of the system have been appropriately implemented and integrated resulting in a very successful and robust system. The developed system was deployed and tested at Garu Senior High School in the Upper East Region of Ghana. During the test implementation, It was affirmed that students with issues such as scratches and dirt on their fingers were denied access and were not able to be authenticated and verified. However, after three attempts via this primary authentication module, they were able to use the alternative module, which gave them the opportunity to be authenticated and verified. As a result, a full implementation of this system will make sure only rightful parents pick up their wards from school. This system can also be deployed in other areas for attendance monitoring or personality tracking.

show abstract

Query Optimization In MySQL Database Using Index

Cited by 12 publications

References 18 publications

MySQL Select Query Optimization Using Self-Join

MySQL Select Query Optimization Using Self-Join

Electricity safety inspection data model optimization method based on concurrent access constraints

A Parent Authentication System for the Security of Pre-basic School Pupils

Contact Info

Product

Resources

About