Matches in SemOpenAlex for { <https://semopenalex.org/work/W3094302256> ?p ?o ?g. }
Showing items 1 to 94 of
94
with 100 items per page.
- W3094302256 abstract "Despite continuous investments in data technologies, the latency of querying data still poses a significant challenge. Modern analytic solutions require near real-time responsiveness both to make them interactive and to support automated processing. Current technologies (Hadoop, Spark, Dataflow) scan the dataset to execute queries. They focus on providing a scalable data storage to maximize task execution speed. We argue that these solutions fail to offer an adequate level of interactivity since they depend on continual access to data. In this paper we present a method for query approximation, also known as approximate query processing (AQP), that reduce the need to scan data during inference (query calculation), thus enabling a rapid query processing tool. We use LSTM network to learn the relationship between queries and their results, and to provide a rapid inference layer for predicting query results. Our method (referred as ``Hunch``) produces a lightweight LSTM network which provides a high query throughput. We evaluated our method using twelve datasets and compared to state-of-the-art AQP engines (VerdictDB, BlinkDB) from query latency, model weight and accuracy perspectives. The results show that our method predicted queries' results with a normalized root mean squared error (NRMSE) ranging from approximately 1% to 4% which in the majority of our data sets was better then the compared benchmarks. Moreover, our method was able to predict up to 120,000 queries in a second (streamed together), and with a single query latency of no more than 2ms." @default.
- W3094302256 created "2020-10-29" @default.
- W3094302256 creator A5002391103 @default.
- W3094302256 creator A5012622155 @default.
- W3094302256 creator A5022295860 @default.
- W3094302256 date "2020-10-25" @default.
- W3094302256 modified "2023-09-27" @default.
- W3094302256 title "Approximating Aggregated SQL Queries With LSTM Networks" @default.
- W3094302256 cites W1598796236 @default.
- W3094302256 cites W1976821017 @default.
- W3094302256 cites W2002791618 @default.
- W3094302256 cites W2018030107 @default.
- W3094302256 cites W2043097023 @default.
- W3094302256 cites W2071989194 @default.
- W3094302256 cites W2082553115 @default.
- W3094302256 cites W2091341267 @default.
- W3094302256 cites W2152834477 @default.
- W3094302256 cites W2153914251 @default.
- W3094302256 cites W2244876453 @default.
- W3094302256 cites W2279919853 @default.
- W3094302256 cites W2436120840 @default.
- W3094302256 cites W2487200295 @default.
- W3094302256 cites W2613577383 @default.
- W3094302256 cites W2615303257 @default.
- W3094302256 cites W2734006851 @default.
- W3094302256 cites W2798630561 @default.
- W3094302256 cites W3011323947 @default.
- W3094302256 cites W3031176864 @default.
- W3094302256 cites W3100965700 @default.
- W3094302256 hasPublicationYear "2020" @default.
- W3094302256 type Work @default.
- W3094302256 sameAs 3094302256 @default.
- W3094302256 citedByCount "0" @default.
- W3094302256 crossrefType "posted-content" @default.
- W3094302256 hasAuthorship W3094302256A5002391103 @default.
- W3094302256 hasAuthorship W3094302256A5012622155 @default.
- W3094302256 hasAuthorship W3094302256A5022295860 @default.
- W3094302256 hasConcept C124101348 @default.
- W3094302256 hasConcept C154945302 @default.
- W3094302256 hasConcept C157692150 @default.
- W3094302256 hasConcept C173608175 @default.
- W3094302256 hasConcept C192028432 @default.
- W3094302256 hasConcept C199360897 @default.
- W3094302256 hasConcept C2776214188 @default.
- W3094302256 hasConcept C2781215313 @default.
- W3094302256 hasConcept C41008148 @default.
- W3094302256 hasConcept C48044578 @default.
- W3094302256 hasConcept C510870499 @default.
- W3094302256 hasConcept C76155785 @default.
- W3094302256 hasConcept C77088390 @default.
- W3094302256 hasConcept C82876162 @default.
- W3094302256 hasConcept C96324660 @default.
- W3094302256 hasConceptScore W3094302256C124101348 @default.
- W3094302256 hasConceptScore W3094302256C154945302 @default.
- W3094302256 hasConceptScore W3094302256C157692150 @default.
- W3094302256 hasConceptScore W3094302256C173608175 @default.
- W3094302256 hasConceptScore W3094302256C192028432 @default.
- W3094302256 hasConceptScore W3094302256C199360897 @default.
- W3094302256 hasConceptScore W3094302256C2776214188 @default.
- W3094302256 hasConceptScore W3094302256C2781215313 @default.
- W3094302256 hasConceptScore W3094302256C41008148 @default.
- W3094302256 hasConceptScore W3094302256C48044578 @default.
- W3094302256 hasConceptScore W3094302256C510870499 @default.
- W3094302256 hasConceptScore W3094302256C76155785 @default.
- W3094302256 hasConceptScore W3094302256C77088390 @default.
- W3094302256 hasConceptScore W3094302256C82876162 @default.
- W3094302256 hasConceptScore W3094302256C96324660 @default.
- W3094302256 hasLocation W30943022561 @default.
- W3094302256 hasOpenAccess W3094302256 @default.
- W3094302256 hasPrimaryLocation W30943022561 @default.
- W3094302256 hasRelatedWork W2017194553 @default.
- W3094302256 hasRelatedWork W2037946039 @default.
- W3094302256 hasRelatedWork W2087909221 @default.
- W3094302256 hasRelatedWork W2103702871 @default.
- W3094302256 hasRelatedWork W2117538598 @default.
- W3094302256 hasRelatedWork W2135807545 @default.
- W3094302256 hasRelatedWork W2228891258 @default.
- W3094302256 hasRelatedWork W2282104475 @default.
- W3094302256 hasRelatedWork W2339303436 @default.
- W3094302256 hasRelatedWork W2403537344 @default.
- W3094302256 hasRelatedWork W2514758784 @default.
- W3094302256 hasRelatedWork W2609283634 @default.
- W3094302256 hasRelatedWork W2616221821 @default.
- W3094302256 hasRelatedWork W2944695180 @default.
- W3094302256 hasRelatedWork W2944831983 @default.
- W3094302256 hasRelatedWork W2955755950 @default.
- W3094302256 hasRelatedWork W2969358756 @default.
- W3094302256 hasRelatedWork W2983968971 @default.
- W3094302256 hasRelatedWork W3024004445 @default.
- W3094302256 hasRelatedWork W3199520473 @default.
- W3094302256 isParatext "false" @default.
- W3094302256 isRetracted "false" @default.
- W3094302256 magId "3094302256" @default.
- W3094302256 workType "article" @default.