Matches in SemOpenAlex for { <https://semopenalex.org/work/W4226124328> ?p ?o ?g. }
- W4226124328 endingPage "1" @default.
- W4226124328 startingPage "1" @default.
- W4226124328 abstract "Materialized views (MVs) can significantly optimize the query processing in databases. However, it is hard to generate MVs for ordinary users because it relies on background knowledge, and existing methods rely on DBAs to generate and maintain MVs. However, DBAs cannot handle large-scale databases, especially cloud databases that have millions of database instances and support millions of users. Thus it calls for an autonomous MV management system. In this paper, we propose an autonomous materialized view management system. It analyzes query workloads, estimates the costs and benefits of materializing queries as views, and selects MVs to maximize the benefit within a space budget. We propose a serialization and encoding method that can encode the features of both queries and views into vectors. Then we design a sequence-to-sequence model, Encoder-Reducer, to estimate MVs' cost/benefit by taking the encoding vectors as input. Next, we propose a deep reinforcement learning model to select high-quality MVs, which enriches the state representation with Encoder-Reducer's output. Experimental results show that our method outperforms existing studies in terms of MV selection quality." @default.
- W4226124328 created "2022-05-05" @default.
- W4226124328 creator A5027824937 @default.
- W4226124328 creator A5056011841 @default.
- W4226124328 creator A5082331221 @default.
- W4226124328 creator A5083848380 @default.
- W4226124328 date "2022-01-01" @default.
- W4226124328 modified "2023-09-26" @default.
- W4226124328 title "AutoView: An Autonomous Materialized View Management System with Encoder-Reducer" @default.
- W4226124328 cites W1793365533 @default.
- W4226124328 cites W1989163741 @default.
- W4226124328 cites W2033078763 @default.
- W4226124328 cites W2090773975 @default.
- W4226124328 cites W2100109822 @default.
- W4226124328 cites W2147100375 @default.
- W4226124328 cites W2157331557 @default.
- W4226124328 cites W2160770337 @default.
- W4226124328 cites W2396309311 @default.
- W4226124328 cites W2535959639 @default.
- W4226124328 cites W2799060872 @default.
- W4226124328 cites W2799237774 @default.
- W4226124328 cites W2890919505 @default.
- W4226124328 cites W2923804366 @default.
- W4226124328 cites W2945459156 @default.
- W4226124328 cites W2963853546 @default.
- W4226124328 cites W2970148517 @default.
- W4226124328 cites W2970851599 @default.
- W4226124328 cites W2998249308 @default.
- W4226124328 cites W3002980296 @default.
- W4226124328 cites W3025775630 @default.
- W4226124328 cites W3029535034 @default.
- W4226124328 cites W3030387435 @default.
- W4226124328 cites W3081226543 @default.
- W4226124328 cites W3082792229 @default.
- W4226124328 cites W3085364173 @default.
- W4226124328 cites W3105457604 @default.
- W4226124328 cites W4232177466 @default.
- W4226124328 doi "https://doi.org/10.1109/tkde.2022.3163195" @default.
- W4226124328 hasPublicationYear "2022" @default.
- W4226124328 type Work @default.
- W4226124328 citedByCount "0" @default.
- W4226124328 crossrefType "journal-article" @default.
- W4226124328 hasAuthorship W4226124328A5027824937 @default.
- W4226124328 hasAuthorship W4226124328A5056011841 @default.
- W4226124328 hasAuthorship W4226124328A5082331221 @default.
- W4226124328 hasAuthorship W4226124328A5083848380 @default.
- W4226124328 hasConcept C104317684 @default.
- W4226124328 hasConcept C111472728 @default.
- W4226124328 hasConcept C111919701 @default.
- W4226124328 hasConcept C118505674 @default.
- W4226124328 hasConcept C124101348 @default.
- W4226124328 hasConcept C124304363 @default.
- W4226124328 hasConcept C125411270 @default.
- W4226124328 hasConcept C127413603 @default.
- W4226124328 hasConcept C138885662 @default.
- W4226124328 hasConcept C147176958 @default.
- W4226124328 hasConcept C148840519 @default.
- W4226124328 hasConcept C154945302 @default.
- W4226124328 hasConcept C185592680 @default.
- W4226124328 hasConcept C23123220 @default.
- W4226124328 hasConcept C2776985865 @default.
- W4226124328 hasConcept C2778112365 @default.
- W4226124328 hasConcept C41008148 @default.
- W4226124328 hasConcept C52723943 @default.
- W4226124328 hasConcept C54239708 @default.
- W4226124328 hasConcept C54355233 @default.
- W4226124328 hasConcept C55493867 @default.
- W4226124328 hasConcept C66746571 @default.
- W4226124328 hasConcept C77088390 @default.
- W4226124328 hasConcept C86803240 @default.
- W4226124328 hasConcept C98199447 @default.
- W4226124328 hasConceptScore W4226124328C104317684 @default.
- W4226124328 hasConceptScore W4226124328C111472728 @default.
- W4226124328 hasConceptScore W4226124328C111919701 @default.
- W4226124328 hasConceptScore W4226124328C118505674 @default.
- W4226124328 hasConceptScore W4226124328C124101348 @default.
- W4226124328 hasConceptScore W4226124328C124304363 @default.
- W4226124328 hasConceptScore W4226124328C125411270 @default.
- W4226124328 hasConceptScore W4226124328C127413603 @default.
- W4226124328 hasConceptScore W4226124328C138885662 @default.
- W4226124328 hasConceptScore W4226124328C147176958 @default.
- W4226124328 hasConceptScore W4226124328C148840519 @default.
- W4226124328 hasConceptScore W4226124328C154945302 @default.
- W4226124328 hasConceptScore W4226124328C185592680 @default.
- W4226124328 hasConceptScore W4226124328C23123220 @default.
- W4226124328 hasConceptScore W4226124328C2776985865 @default.
- W4226124328 hasConceptScore W4226124328C2778112365 @default.
- W4226124328 hasConceptScore W4226124328C41008148 @default.
- W4226124328 hasConceptScore W4226124328C52723943 @default.
- W4226124328 hasConceptScore W4226124328C54239708 @default.
- W4226124328 hasConceptScore W4226124328C54355233 @default.
- W4226124328 hasConceptScore W4226124328C55493867 @default.
- W4226124328 hasConceptScore W4226124328C66746571 @default.
- W4226124328 hasConceptScore W4226124328C77088390 @default.
- W4226124328 hasConceptScore W4226124328C86803240 @default.
- W4226124328 hasConceptScore W4226124328C98199447 @default.
- W4226124328 hasFunder F4320321001 @default.
- W4226124328 hasLocation W42261243281 @default.