Data Search Using Hash Join Query and Nested Join Query
-
Published:2019-11-01
Issue:1
Volume:1361
Page:012079
-
ISSN:1742-6588
-
Container-title:Journal of Physics: Conference Series
-
language:
-
Short-container-title:J. Phys.: Conf. Ser.
Author:
Sinuraya Junus,Rezky Syarifah Fadillah,Tarigan Makmur
Abstract
Abstract
In accessing or searching data by using Query or Join on applications that are connected to a database, the usefulness of the implementation of the data and the process time is important to note. There are many ways that a system management database can do in processing and generating answers to a query. All methods will eventually produce the same answer (output) but they would still have different values, such as the time to respond to data. Some queries that are often used for processing data are Hash Join and Nested Join, both queries have different algorithms but produce the same output. A client-based or network-based application was employed to test both algorithms or queries with running time parameters or the time to respond to data. The test was conducted by connecting the number of tables and the number of rows/records. The result of the study is that the query hash join’s speed in response to small amounts of data is better than the large data in the nested join.
Subject
General Physics and Astronomy
Reference21 articles.
1. Dataflow Query Processing Using Multiprocessor Hash-Partitioned Algorithms;A. Gerber,1986
Cited by
1 articles.
订阅此论文施引文献
订阅此论文施引文献,注册后可以免费订阅5篇论文的施引文献,订阅后可以查看论文全部施引文献
1. Enhancement of NoSQL Database Performance Using Parallel Processing;Journal of Information Systems Engineering and Management;2024-04-22