{"id":"https://openalex.org/W4386137790","doi":"https://doi.org/10.3390/s23177364","title":"A Cardinality Estimator in Complex Database Systems Based on TreeLSTM","display_name":"A Cardinality Estimator in Complex Database Systems Based on TreeLSTM","publication_year":2023,"publication_date":"2023-08-23","ids":{"openalex":"https://openalex.org/W4386137790","doi":"https://doi.org/10.3390/s23177364","pmid":"https://pubmed.ncbi.nlm.nih.gov/37687820"},"language":"en","primary_location":{"id":"doi:10.3390/s23177364","is_oa":true,"landing_page_url":"https://doi.org/10.3390/s23177364","pdf_url":"https://www.mdpi.com/1424-8220/23/17/7364/pdf?version=1692860416","source":{"id":"https://openalex.org/S101949793","display_name":"Sensors","issn_l":"1424-8220","issn":["1424-8220"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Sensors","raw_type":"journal-article"},"type":"article","indexed_in":["crossref","doaj","pubmed"],"open_access":{"is_oa":true,"oa_status":"gold","oa_url":"https://www.mdpi.com/1424-8220/23/17/7364/pdf?version=1692860416","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5101237311","display_name":"Kaiyang Qi","orcid":null},"institutions":[{"id":"https://openalex.org/I96908189","display_name":"Xinjiang University","ror":"https://ror.org/059gw8r13","country_code":"CN","type":"education","lineage":["https://openalex.org/I96908189"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Kaiyang Qi","raw_affiliation_strings":["School of Software, Xinjiang University, Urumqi 830091, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"School of Software, Xinjiang University, Urumqi 830091, China","institution_ids":["https://openalex.org/I96908189"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5020873493","display_name":"Jiong Yu","orcid":"https://orcid.org/0000-0002-9181-6720"},"institutions":[{"id":"https://openalex.org/I96908189","display_name":"Xinjiang University","ror":"https://ror.org/059gw8r13","country_code":"CN","type":"education","lineage":["https://openalex.org/I96908189"]}],"countries":["CN"],"is_corresponding":true,"raw_author_name":"Jiong Yu","raw_affiliation_strings":["College of Information Science and Engineering, Xinjiang University, Urumqi 830046, China","School of Software, Xinjiang University, Urumqi 830091, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Information Science and Engineering, Xinjiang University, Urumqi 830046, China","institution_ids":["https://openalex.org/I96908189"]},{"raw_affiliation_string":"School of Software, Xinjiang University, Urumqi 830091, China","institution_ids":["https://openalex.org/I96908189"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5103197048","display_name":"Zhenzhen He","orcid":"https://orcid.org/0000-0002-7388-2038"},"institutions":[{"id":"https://openalex.org/I96908189","display_name":"Xinjiang University","ror":"https://ror.org/059gw8r13","country_code":"CN","type":"education","lineage":["https://openalex.org/I96908189"]}],"countries":["CN"],"is_corresponding":false,"raw_author_name":"Zhenzhen He","raw_affiliation_strings":["College of Information Science and Engineering, Xinjiang University, Urumqi 830046, China"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"College of Information Science and Engineering, Xinjiang University, Urumqi 830046, China","institution_ids":["https://openalex.org/I96908189"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5020873493"],"corresponding_institution_ids":["https://openalex.org/I96908189"],"apc_list":{"value":2400,"currency":"CHF","value_usd":2598},"apc_paid":{"value":2400,"currency":"CHF","value_usd":2598},"fwci":0.3807,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.61047477,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":95,"max":96},"biblio":{"volume":"23","issue":"17","first_page":"7364","last_page":"7364"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10317","display_name":"Advanced Database Systems and Queries","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1705","display_name":"Computer Networks and Communications"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11106","display_name":"Data Management and Algorithms","score":0.9994000196456909,"subfield":{"id":"https://openalex.org/subfields/1711","display_name":"Signal Processing"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11719","display_name":"Data Quality and Management","score":0.9972000122070312,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/cardinality","display_name":"Cardinality (data modeling)","score":0.8375127911567688},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.7824937105178833},{"id":"https://openalex.org/keywords/tuple","display_name":"Tuple","score":0.6319676637649536},{"id":"https://openalex.org/keywords/data-mining","display_name":"Data mining","score":0.5591842532157898},{"id":"https://openalex.org/keywords/estimator","display_name":"Estimator","score":0.5362827777862549},{"id":"https://openalex.org/keywords/construct","display_name":"Construct (python library)","score":0.48758500814437866},{"id":"https://openalex.org/keywords/query-optimization","display_name":"Query optimization","score":0.46500667929649353},{"id":"https://openalex.org/keywords/theoretical-computer-science","display_name":"Theoretical computer science","score":0.3657524287700653},{"id":"https://openalex.org/keywords/algorithm","display_name":"Algorithm","score":0.36006462574005127},{"id":"https://openalex.org/keywords/mathematics","display_name":"Mathematics","score":0.13635987043380737},{"id":"https://openalex.org/keywords/statistics","display_name":"Statistics","score":0.10082739591598511}],"concepts":[{"id":"https://openalex.org/C87117476","wikidata":"https://www.wikidata.org/wiki/Q362383","display_name":"Cardinality (data modeling)","level":2,"score":0.8375127911567688},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.7824937105178833},{"id":"https://openalex.org/C118930307","wikidata":"https://www.wikidata.org/wiki/Q600590","display_name":"Tuple","level":2,"score":0.6319676637649536},{"id":"https://openalex.org/C124101348","wikidata":"https://www.wikidata.org/wiki/Q172491","display_name":"Data mining","level":1,"score":0.5591842532157898},{"id":"https://openalex.org/C185429906","wikidata":"https://www.wikidata.org/wiki/Q1130160","display_name":"Estimator","level":2,"score":0.5362827777862549},{"id":"https://openalex.org/C2780801425","wikidata":"https://www.wikidata.org/wiki/Q5164392","display_name":"Construct (python library)","level":2,"score":0.48758500814437866},{"id":"https://openalex.org/C157692150","wikidata":"https://www.wikidata.org/wiki/Q2919848","display_name":"Query optimization","level":2,"score":0.46500667929649353},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.3657524287700653},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.36006462574005127},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.13635987043380737},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.10082739591598511},{"id":"https://openalex.org/C118615104","wikidata":"https://www.wikidata.org/wiki/Q121416","display_name":"Discrete mathematics","level":1,"score":0.0},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0}],"mesh":[],"locations_count":5,"locations":[{"id":"doi:10.3390/s23177364","is_oa":true,"landing_page_url":"https://doi.org/10.3390/s23177364","pdf_url":"https://www.mdpi.com/1424-8220/23/17/7364/pdf?version=1692860416","source":{"id":"https://openalex.org/S101949793","display_name":"Sensors","issn_l":"1424-8220","issn":["1424-8220"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Sensors","raw_type":"journal-article"},{"id":"pmid:37687820","is_oa":false,"landing_page_url":"https://pubmed.ncbi.nlm.nih.gov/37687820","pdf_url":null,"source":{"id":"https://openalex.org/S4306525036","display_name":"PubMed","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Sensors (Basel, Switzerland)","raw_type":null},{"id":"pmh:oai:pubmedcentral.nih.gov:10490213","is_oa":true,"landing_page_url":"https://www.ncbi.nlm.nih.gov/pmc/articles/10490213","pdf_url":"https://pmc.ncbi.nlm.nih.gov/articles/PMC10490213/pdf/sensors-23-07364.pdf","source":{"id":"https://openalex.org/S2764455111","display_name":"PubMed Central","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I1299303238","host_organization_name":"National Institutes of Health","host_organization_lineage":["https://openalex.org/I1299303238"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Sensors (Basel)","raw_type":"Text"},{"id":"pmh:oai:doaj.org/article:959eb9734b0e4589be98a35dd35337d4","is_oa":true,"landing_page_url":"https://doaj.org/article/959eb9734b0e4589be98a35dd35337d4","pdf_url":null,"source":{"id":"https://openalex.org/S4306401280","display_name":"DOAJ (DOAJ: Directory of Open Access Journals)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"host_organization":null,"host_organization_name":null,"host_organization_lineage":[],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by-sa","license_id":"https://openalex.org/licenses/cc-by-sa","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Sensors, Vol 23, Iss 17, p 7364 (2023)","raw_type":"article"},{"id":"pmh:oai:mdpi.com:/1424-8220/23/17/7364/","is_oa":true,"landing_page_url":"https://dx.doi.org/10.3390/s23177364","pdf_url":null,"source":{"id":"https://openalex.org/S4306400947","display_name":"MDPI (MDPI AG)","issn_l":null,"issn":null,"is_oa":true,"is_in_doaj":false,"is_core":false,"host_organization":"https://openalex.org/I4210097602","host_organization_name":"Multidisciplinary Digital Publishing Institute (Switzerland)","host_organization_lineage":["https://openalex.org/I4210097602"],"host_organization_lineage_names":[],"type":"repository"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"Sensors; Volume 23; Issue 17; Pages: 7364","raw_type":"Text"}],"best_oa_location":{"id":"doi:10.3390/s23177364","is_oa":true,"landing_page_url":"https://doi.org/10.3390/s23177364","pdf_url":"https://www.mdpi.com/1424-8220/23/17/7364/pdf?version=1692860416","source":{"id":"https://openalex.org/S101949793","display_name":"Sensors","issn_l":"1424-8220","issn":["1424-8220"],"is_oa":true,"is_in_doaj":true,"is_core":true,"host_organization":"https://openalex.org/P4310310987","host_organization_name":"Multidisciplinary Digital Publishing Institute","host_organization_lineage":["https://openalex.org/P4310310987"],"host_organization_lineage_names":["Multidisciplinary Digital Publishing Institute"],"type":"journal"},"license":"cc-by","license_id":"https://openalex.org/licenses/cc-by","version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Sensors","raw_type":"journal-article"},"sustainable_development_goals":[],"awards":[{"id":"https://openalex.org/G147047731","display_name":null,"funder_award_id":"62266043","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5692325391","display_name":null,"funder_award_id":"XJEDU2016S106","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G5819373079","display_name":"\u57fa\u4e8e\u65f6-\u7a7a-\u8c31\u7279\u5f81\u6df1\u5ea6\u5b66\u4e60\u7684\u9065\u611f\u56fe\u50cf\u8d85\u5206\u8fa8\u7387\u91cd\u5efa\u7814\u7a76","funder_award_id":"61966035","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"},{"id":"https://openalex.org/G8624906418","display_name":null,"funder_award_id":"62262064","funder_id":"https://openalex.org/F4320321001","funder_display_name":"National Natural Science Foundation of China"}],"funders":[{"id":"https://openalex.org/F4320321001","display_name":"National Natural Science Foundation of China","ror":"https://ror.org/01h0zpd94"},{"id":"https://openalex.org/F4320328898","display_name":"Natural Science Foundation of Xinjiang","ror":null}],"has_content":{"grobid_xml":false,"pdf":true},"content_urls":{"pdf":"https://content.openalex.org/works/W4386137790.pdf"},"referenced_works_count":42,"referenced_works":["https://openalex.org/W2029619274","https://openalex.org/W2075712468","https://openalex.org/W2132823934","https://openalex.org/W2396309311","https://openalex.org/W2424452828","https://openalex.org/W2585664214","https://openalex.org/W2755385361","https://openalex.org/W2766026698","https://openalex.org/W2790625403","https://openalex.org/W2907102438","https://openalex.org/W2913615927","https://openalex.org/W2922302645","https://openalex.org/W2939293933","https://openalex.org/W2946026089","https://openalex.org/W2955798121","https://openalex.org/W2963355447","https://openalex.org/W2970148517","https://openalex.org/W2991530444","https://openalex.org/W2998249308","https://openalex.org/W3013555795","https://openalex.org/W3024738030","https://openalex.org/W3030994385","https://openalex.org/W3031692719","https://openalex.org/W3048205019","https://openalex.org/W3097225903","https://openalex.org/W3099158806","https://openalex.org/W3099273181","https://openalex.org/W3119448165","https://openalex.org/W3124277639","https://openalex.org/W3148969777","https://openalex.org/W3173622057","https://openalex.org/W3183953540","https://openalex.org/W4206830372","https://openalex.org/W4242142158","https://openalex.org/W4281724148","https://openalex.org/W4378389707","https://openalex.org/W6657422069","https://openalex.org/W6680802344","https://openalex.org/W6713228396","https://openalex.org/W6759056852","https://openalex.org/W6781406007","https://openalex.org/W6795140394"],"related_works":["https://openalex.org/W4253980102","https://openalex.org/W1506422377","https://openalex.org/W2769216135","https://openalex.org/W2549535751","https://openalex.org/W2097710895","https://openalex.org/W2073547112","https://openalex.org/W2788172935","https://openalex.org/W1533823869","https://openalex.org/W2054338562","https://openalex.org/W3120765283"],"abstract_inverted_index":{"Cardinality":[0],"estimation":[1,29,53,71,156,204,210],"is":[2,85],"critical":[3],"for":[4],"database":[5],"management":[6],"systems":[7],"(DBMSs)":[8],"to":[9,103,178],"execute":[10],"query":[11,18,80],"optimization":[12],"tasks,":[13],"which":[14],"can":[15,55],"guide":[16],"the":[17,22,40,57,68,110,120,124,131,150,159,165,180,203,213],"optimizer":[19],"in":[20,219],"choosing":[21],"best":[23],"execution":[24],"plan.":[25],"However,":[26,67],"traditional":[27,60,113,208],"cardinality":[28,52,70,155,209],"methods":[30,54,61,72,114,211,218],"cannot":[31,37,184],"provide":[32,63],"accurate":[33,65],"estimates":[34],"because":[35],"they":[36],"accurately":[38],"capture":[39],"correlation":[41],"between":[42,127,136,146,162,168,186],"multiple":[43,82,128],"tables.":[44],"Several":[45],"recent":[46],"studies":[47],"have":[48,74],"revealed":[49],"that":[50,182,198],"learning-based":[51,69],"address":[56,89],"shortcomings":[58],"of":[59,112,154],"and":[62,122,130,133,148,152,164,188,206,212,225],"more":[64],"estimates.":[66],"still":[73],"large":[75,187],"errors":[76],"when":[77,115],"an":[78],"SQL":[79],"involves":[81],"tables":[83,129,163],"or":[84],"very":[86],"complex.":[87],"To":[88],"this":[90],"problem,":[91],"we":[92,172],"propose":[93],"a":[94,174],"sampling-based":[95],"tree":[96],"long":[97],"short-term":[98],"memory":[99],"(TreeLSTM)":[100],"neural":[101],"network":[102],"model":[104,108,201],"queries.":[105],"The":[106],"proposed":[107,200],"addresses":[109],"weakness":[111],"no":[116],"sampled":[117],"tuples":[118],"match":[119],"predicates":[121,147],"considers":[123],"join":[125],"relationship":[126],"conjunction":[132],"disjunction":[134],"operations":[135],"predicates.":[137,169],"We":[138],"construct":[139,173],"subexpressions":[140],"as":[141],"trees":[142],"using":[143],"operator":[144],"types":[145],"improve":[149],"performance":[151],"accuracy":[153],"by":[157],"capturing":[158],"join-crossing":[160],"correlations":[161],"order":[166],"dependencies":[167],"In":[170],"addition,":[171],"new":[175],"loss":[176],"function":[177],"overcome":[179],"drawback":[181],"Q-error":[183],"distinguish":[185],"small":[189],"cardinalities.":[190],"Extensive":[191],"experimental":[192],"results":[193],"from":[194],"real-world":[195],"datasets":[196],"show":[197],"our":[199],"improves":[202],"quality":[205],"outperforms":[207],"other":[214],"compared":[215],"deep":[216],"learning":[217],"three":[220],"evaluation":[221],"metrics:":[222],"Q-error,":[223],"MAE,":[224],"SMAPE.":[226]},"counts_by_year":[{"year":2025,"cited_by_count":2}],"updated_date":"2026-06-06T09:05:17.133730","created_date":"2025-10-10T00:00:00"}