Matches in SemOpenAlex for { <https://semopenalex.org/work/W2617928282> ?p ?o ?g. }
Showing items 1 to 87 of
87
with 100 items per page.
- W2617928282 abstract "Objectives: Generated new single Hive Query (HiveQL) by finding the similar type of operation and common data source from two or more input query and compare the total execution time of both queries. Methods/Statistical Analysis: Map Reduce concept of Hadoop Hive is utilized in this paper, a new single query is generated from two or more input queries and 3 sample of data generated with size of 2, 5 and 10 GB using free database generation tool DBGEN. TPC-H queries are executed on this data and total execution time of both the queries is compared to see the performance. Findings: As Hive executes single query at a time, and in this research, multiple queries are provided to hive by converting them into single query. This approach results in reduction of operation while executing the query, which further reduce the execution time and improve the performance of Hive. Hive process the structured data of data warehouse system, so by using this approach, the structured data can be process and analyzed in easily and convenient manner. Structured data is used for processing OLAP (Online Analytical Processing) queries so Hive also helps to process OLAP queries. Hive works in conjunction with Hadoop and it process or execute query on data which is stored on Hadoop. So firstly, Hadoop should be running on the system to use Hive query. This research requires huge amount of data for testing, for this sample data is generated using free data generation tool provided by TPC (Transaction Performance Council), DBGEN. TPC also provide the different types of queries for testing the performance query execution tool, so in this research TPC-H queries are utilized. Application/Improvements: By using the concept which is shown in this research, the total execution time of Hive queries can be reduced drastically and performance of Hive can be increased." @default.
- W2617928282 created "2017-06-05" @default.
- W2617928282 creator A5010140306 @default.
- W2617928282 creator A5075061715 @default.
- W2617928282 creator A5080963156 @default.
- W2617928282 date "2017-05-01" @default.
- W2617928282 modified "2023-10-16" @default.
- W2617928282 title "Optimization of Multiple Correlated Queries by Detecting Similar Data Source with Hadoop/Hive" @default.
- W2617928282 cites W173554183 @default.
- W2617928282 cites W1971676257 @default.
- W2617928282 cites W2044490410 @default.
- W2617928282 cites W2058978608 @default.
- W2617928282 cites W2089347259 @default.
- W2617928282 cites W2098935637 @default.
- W2617928282 cites W2109913494 @default.
- W2617928282 cites W2172220707 @default.
- W2617928282 cites W2173213060 @default.
- W2617928282 cites W2325507490 @default.
- W2617928282 cites W2516436592 @default.
- W2617928282 doi "https://doi.org/10.17485/ijst/2017/v10i18/111370" @default.
- W2617928282 hasPublicationYear "2017" @default.
- W2617928282 type Work @default.
- W2617928282 sameAs 2617928282 @default.
- W2617928282 citedByCount "1" @default.
- W2617928282 countsByYear W26179282822022 @default.
- W2617928282 crossrefType "journal-article" @default.
- W2617928282 hasAuthorship W2617928282A5010140306 @default.
- W2617928282 hasAuthorship W2617928282A5075061715 @default.
- W2617928282 hasAuthorship W2617928282A5080963156 @default.
- W2617928282 hasBestOaLocation W26179282821 @default.
- W2617928282 hasConcept C111919701 @default.
- W2617928282 hasConcept C124101348 @default.
- W2617928282 hasConcept C135572916 @default.
- W2617928282 hasConcept C157692150 @default.
- W2617928282 hasConcept C164120249 @default.
- W2617928282 hasConcept C185592680 @default.
- W2617928282 hasConcept C192939062 @default.
- W2617928282 hasConcept C198531522 @default.
- W2617928282 hasConcept C201932085 @default.
- W2617928282 hasConcept C23123220 @default.
- W2617928282 hasConcept C41008148 @default.
- W2617928282 hasConcept C43617362 @default.
- W2617928282 hasConcept C77088390 @default.
- W2617928282 hasConcept C97854310 @default.
- W2617928282 hasConcept C98045186 @default.
- W2617928282 hasConceptScore W2617928282C111919701 @default.
- W2617928282 hasConceptScore W2617928282C124101348 @default.
- W2617928282 hasConceptScore W2617928282C135572916 @default.
- W2617928282 hasConceptScore W2617928282C157692150 @default.
- W2617928282 hasConceptScore W2617928282C164120249 @default.
- W2617928282 hasConceptScore W2617928282C185592680 @default.
- W2617928282 hasConceptScore W2617928282C192939062 @default.
- W2617928282 hasConceptScore W2617928282C198531522 @default.
- W2617928282 hasConceptScore W2617928282C201932085 @default.
- W2617928282 hasConceptScore W2617928282C23123220 @default.
- W2617928282 hasConceptScore W2617928282C41008148 @default.
- W2617928282 hasConceptScore W2617928282C43617362 @default.
- W2617928282 hasConceptScore W2617928282C77088390 @default.
- W2617928282 hasConceptScore W2617928282C97854310 @default.
- W2617928282 hasConceptScore W2617928282C98045186 @default.
- W2617928282 hasLocation W26179282821 @default.
- W2617928282 hasOpenAccess W2617928282 @default.
- W2617928282 hasPrimaryLocation W26179282821 @default.
- W2617928282 hasRelatedWork W1212988886 @default.
- W2617928282 hasRelatedWork W145170424 @default.
- W2617928282 hasRelatedWork W1534883672 @default.
- W2617928282 hasRelatedWork W1600525360 @default.
- W2617928282 hasRelatedWork W2017194553 @default.
- W2617928282 hasRelatedWork W2020789881 @default.
- W2617928282 hasRelatedWork W2026994352 @default.
- W2617928282 hasRelatedWork W2037168816 @default.
- W2617928282 hasRelatedWork W2045171385 @default.
- W2617928282 hasRelatedWork W2073055739 @default.
- W2617928282 hasRelatedWork W2100047131 @default.
- W2617928282 hasRelatedWork W2137259192 @default.
- W2617928282 hasRelatedWork W2153834200 @default.
- W2617928282 hasRelatedWork W2166546651 @default.
- W2617928282 hasRelatedWork W2281839741 @default.
- W2617928282 hasRelatedWork W2944695180 @default.
- W2617928282 hasRelatedWork W2950253163 @default.
- W2617928282 hasRelatedWork W2969358756 @default.
- W2617928282 hasRelatedWork W3173060941 @default.
- W2617928282 hasRelatedWork W196545957 @default.
- W2617928282 isParatext "false" @default.
- W2617928282 isRetracted "false" @default.
- W2617928282 magId "2617928282" @default.
- W2617928282 workType "article" @default.