Matches in SemOpenAlex for { <https://semopenalex.org/work/W4386137790> ?p ?o ?g. }
Showing items 1 to 94 of
94
with 100 items per page.
- W4386137790 endingPage "7364" @default.
- W4386137790 startingPage "7364" @default.
- W4386137790 abstract "Cardinality estimation is critical for database management systems (DBMSs) to execute query optimization tasks, which can guide the query optimizer in choosing the best execution plan. However, traditional cardinality estimation methods cannot provide accurate estimates because they cannot accurately capture the correlation between multiple tables. Several recent studies have revealed that learning-based cardinality estimation methods can address the shortcomings of traditional methods and provide more accurate estimates. However, the learning-based cardinality estimation methods still have large errors when an SQL query involves multiple tables or is very complex. To address this problem, we propose a sampling-based tree long short-term memory (TreeLSTM) neural network to model queries. The proposed model addresses the weakness of traditional methods when no sampled tuples match the predicates and considers the join relationship between multiple tables and the conjunction and disjunction operations between predicates. We construct subexpressions as trees using operator types between predicates and improve the performance and accuracy of cardinality estimation by capturing the join-crossing correlations between tables and the order dependencies between predicates. In addition, we construct a new loss function to overcome the drawback that Q-error cannot distinguish between large and small cardinalities. Extensive experimental results from real-world datasets show that our proposed model improves the estimation quality and outperforms traditional cardinality estimation methods and the other compared deep learning methods in three evaluation metrics: Q-error, MAE, and SMAPE." @default.
- W4386137790 created "2023-08-25" @default.
- W4386137790 creator A5015424991 @default.
- W4386137790 creator A5020873493 @default.
- W4386137790 creator A5077904439 @default.
- W4386137790 date "2023-08-23" @default.
- W4386137790 modified "2023-09-27" @default.
- W4386137790 title "A Cardinality Estimator in Complex Database Systems Based on TreeLSTM" @default.
- W4386137790 cites W2029619274 @default.
- W4386137790 cites W2075712468 @default.
- W4386137790 cites W2132823934 @default.
- W4386137790 cites W2396309311 @default.
- W4386137790 cites W2424452828 @default.
- W4386137790 cites W2755385361 @default.
- W4386137790 cites W2766026698 @default.
- W4386137790 cites W2790625403 @default.
- W4386137790 cites W2907102438 @default.
- W4386137790 cites W2922302645 @default.
- W4386137790 cites W2939293933 @default.
- W4386137790 cites W2946026089 @default.
- W4386137790 cites W2955798121 @default.
- W4386137790 cites W2963355447 @default.
- W4386137790 cites W2970148517 @default.
- W4386137790 cites W2991530444 @default.
- W4386137790 cites W2998249308 @default.
- W4386137790 cites W3013555795 @default.
- W4386137790 cites W3024738030 @default.
- W4386137790 cites W3030994385 @default.
- W4386137790 cites W3031692719 @default.
- W4386137790 cites W3097225903 @default.
- W4386137790 cites W3120765283 @default.
- W4386137790 cites W3148969777 @default.
- W4386137790 cites W3183953540 @default.
- W4386137790 cites W4206830372 @default.
- W4386137790 cites W4242142158 @default.
- W4386137790 cites W4281724148 @default.
- W4386137790 cites W4378389707 @default.
- W4386137790 doi "https://doi.org/10.3390/s23177364" @default.
- W4386137790 hasPubMedId "https://pubmed.ncbi.nlm.nih.gov/37687820" @default.
- W4386137790 hasPublicationYear "2023" @default.
- W4386137790 type Work @default.
- W4386137790 citedByCount "0" @default.
- W4386137790 crossrefType "journal-article" @default.
- W4386137790 hasAuthorship W4386137790A5015424991 @default.
- W4386137790 hasAuthorship W4386137790A5020873493 @default.
- W4386137790 hasAuthorship W4386137790A5077904439 @default.
- W4386137790 hasBestOaLocation W43861377901 @default.
- W4386137790 hasConcept C105795698 @default.
- W4386137790 hasConcept C11413529 @default.
- W4386137790 hasConcept C118615104 @default.
- W4386137790 hasConcept C118930307 @default.
- W4386137790 hasConcept C124101348 @default.
- W4386137790 hasConcept C157692150 @default.
- W4386137790 hasConcept C185429906 @default.
- W4386137790 hasConcept C199360897 @default.
- W4386137790 hasConcept C2780801425 @default.
- W4386137790 hasConcept C33923547 @default.
- W4386137790 hasConcept C41008148 @default.
- W4386137790 hasConcept C80444323 @default.
- W4386137790 hasConcept C87117476 @default.
- W4386137790 hasConceptScore W4386137790C105795698 @default.
- W4386137790 hasConceptScore W4386137790C11413529 @default.
- W4386137790 hasConceptScore W4386137790C118615104 @default.
- W4386137790 hasConceptScore W4386137790C118930307 @default.
- W4386137790 hasConceptScore W4386137790C124101348 @default.
- W4386137790 hasConceptScore W4386137790C157692150 @default.
- W4386137790 hasConceptScore W4386137790C185429906 @default.
- W4386137790 hasConceptScore W4386137790C199360897 @default.
- W4386137790 hasConceptScore W4386137790C2780801425 @default.
- W4386137790 hasConceptScore W4386137790C33923547 @default.
- W4386137790 hasConceptScore W4386137790C41008148 @default.
- W4386137790 hasConceptScore W4386137790C80444323 @default.
- W4386137790 hasConceptScore W4386137790C87117476 @default.
- W4386137790 hasIssue "17" @default.
- W4386137790 hasLocation W43861377901 @default.
- W4386137790 hasLocation W43861377902 @default.
- W4386137790 hasOpenAccess W4386137790 @default.
- W4386137790 hasPrimaryLocation W43861377901 @default.
- W4386137790 hasRelatedWork W1506422377 @default.
- W4386137790 hasRelatedWork W1533823869 @default.
- W4386137790 hasRelatedWork W2054338562 @default.
- W4386137790 hasRelatedWork W2073547112 @default.
- W4386137790 hasRelatedWork W2097710895 @default.
- W4386137790 hasRelatedWork W2549535751 @default.
- W4386137790 hasRelatedWork W2769216135 @default.
- W4386137790 hasRelatedWork W3120765283 @default.
- W4386137790 hasRelatedWork W4253980102 @default.
- W4386137790 hasRelatedWork W2788172935 @default.
- W4386137790 hasVolume "23" @default.
- W4386137790 isParatext "false" @default.
- W4386137790 isRetracted "false" @default.
- W4386137790 workType "article" @default.