Analysis of Query Optimization Components in Distributed Database

Rana, Imran Ali; Aslam, Shafiq; Sarfraz, Muhammad Shahzad; Shoaib, Umar

doi:10.17485/ijst/2018/v11i18/122267

Cited by 3 publications

(6 citation statements)

References 15 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…As more and more big data-related application systems are developed, Database systems based on NoSQL are becoming increasingly popular but there are various drawbacks to NoSQL databases, like as SQL is not supported, which is an industry standard, and there are no reports or any extra capabilities, with the proposed model, the transactions of Key-Value NoSQL databases may be used in a lock-free and Multi-Version Concurrency Control free manner Li and Gu (2018). In distributed system, it is investigated that the improvement of employing cachebased query optimization to reduce response time is suitable option because it saves huge computational cost and time, especially introducing cache at each site instead of implementation of one network-based cache however, it is observed that currently cache is implemented only in homogeneous distributed databases Rana et al (2018). The rise in the number of processes performed on a shared platform many issues arose as a result of the database, which necessitated the development of strategies to address them such as competing operations and deadlocks.…”

Section: Literature Reviewmentioning

confidence: 99%

“…At the end, it is evaluated if improving response time by utilizing cache-based query optimization is a viable alternative because it saves significant computational cost and time. It also discovered that caching is now used in homogenous distributed databases Rana et al (2018).…”

Section: Distributed Database Management Systemmentioning

confidence: 99%

“…It has been discovered that caching is now used in homogenous distributed databases. In terms of future research, the presented approach may be used to implement heterogeneous distributed databases Rana et al (2018). In the comparison of Relational (MySQL) and NoSQL (MongoDB), MongoDB is a schema-less database with the ability to run in a distributed environment.…”

Section: Implication and Conclusionmentioning

confidence: 99%

“…This technology may be used in the future. implemented for a variety of database types Rana et al (2018). Future researchers also will be able to examine and improve the research's limitations in comparable investigations.…”

Section: Limitation and Future Researchmentioning

confidence: 99%

“…Globally in business environment, organizations are to process more data than ever before. All the crucial business decisions are made on the basis on that available data and only well-designed data management policy will make data more reliable to help make better decisions Rana et al (2018). Concurrency Control in a Database Management System is a method of controlling many actions at the same time without their interfering.…”

Section: Introductionmentioning

confidence: 99%

See 4 more Smart Citations

Evaluation of Database Management Systems and Techniques Applied in Distributed Systems

Samonte,

Samonte

2022

Proceedings of the International Conference on Industrial Engineering and Operations Management

View full text Add to dashboard Cite

The technical solution used to improve and manage the storage and retrieval of data from databases is known as a database management system (DBMS). A transaction signifies a change in the database's data. It is an activity or sequence of operations performed by a single user or application software to read or change the database's contents. A transaction can fail before all the actions in the set are completed, which is a concern. This might occur because of a power outage, a system crash, or other factors while Concurrency Control in a Database Management System is a method of controlling many actions at the same time without their interfering. To resolve these issues, the various techniques are presented in this study with discussion of techniques and algorithms used. Concurrency control methods like locking, timestamps, and Optimistic Concurrency Control can be used to handle concurrent transactions and avoid conflicts. Studying a distributed database for relational (MySQL) and NoSQL (MongoDB), as well as the implementation and performance of ACID transactions in NoSQL, is another proposal (MongoDB).

show abstract

Section: Literature Reviewmentioning

confidence: 99%

Section: Distributed Database Management Systemmentioning

confidence: 99%

Section: Implication and Conclusionmentioning

confidence: 99%

Section: Limitation and Future Researchmentioning

confidence: 99%

Section: Introductionmentioning

confidence: 99%

See 3 more Smart Citations

Evaluation of Database Management Systems and Techniques Applied in Distributed Systems

Samonte,

Samonte

2022

Proceedings of the International Conference on Industrial Engineering and Operations Management

View full text Add to dashboard Cite

show abstract

Query Optimization for Distributed Databases uses a Semi-join Based Approach (SBA) with the SDD-1 Algorithm

Zulfikar

Warnas

Gaol

et al. 2019

2019 International Conference on Information and Communications Technology (ICOIACT)

View full text Add to dashboard Cite

Optimization of Personalized Recommendation Strategy for E-commerce Platform Based on Artificial Intelligence

Fan

2023

IJCAI

View full text Add to dashboard Cite

This article addresses the problems of "resource overload" and "information confusion" in the current e-commerce platform. This paper proposes a personalized recommendation strategy for e-commerce platform based on artificial intelligence considering the collaborative filtering method as the basic algorithm. The article proposes an optimized strategy using artificial intelligence to obtain satisfactory results. Based on this proposed personalized recommendation model, users are clustered by using ontology context information, further considering the influence of user preference and user trust relationship on similarity calculation. This method can alleviate the problems of data sparsity and cold start to a certain extent, effectively improve the recommendation quality. It further increases the diversity of recommendation results, and meet the needs of users and enterprises. Through the change of parameter α under different data sets, when α ∈ (1.84,1.88), the accuracy and recall rate of recommendation results remain at a high level. The personalized recommendation method can be applied to various situations such as social network friend recommendation and e-commerce platform commodity recommendation. The proposed work has a wide range of applications, especially for enterprises that master the user's rich dimensional situation information. This method has a prominent recommendation effect with the help of detailed analysis of the user's complex situation.Povzetek: Članek obravnava težave preobremenitve z viri na obstoječih e-trgovinskih platformah. Predlaga se strategija personaliziranega priporočanja, ki temelji na umetni inteligenci in algoritmu kolaborativnega filtriranja.

show abstract

Analysis of Query Optimization Components in Distributed Database

Cited by 3 publications

References 15 publications

Evaluation of Database Management Systems and Techniques Applied in Distributed Systems

Evaluation of Database Management Systems and Techniques Applied in Distributed Systems

Query Optimization for Distributed Databases uses a Semi-join Based Approach (SBA) with the SDD-1 Algorithm

Optimization of Personalized Recommendation Strategy for E-commerce Platform Based on Artificial Intelligence

Contact Info

Product

Resources

About