{"id":"https://openalex.org/W7161502626","doi":"https://doi.org/10.1007/978-3-032-19865-5_13","title":"Speeding up\u00a0SQL Subqueries via\u00a0Decoupling of\u00a0Non-correlated Predicate","display_name":"Speeding up\u00a0SQL Subqueries via\u00a0Decoupling of\u00a0Non-correlated Predicate","publication_year":2026,"publication_date":"2026-01-01","ids":{"openalex":"https://openalex.org/W7161502626","doi":"https://doi.org/10.1007/978-3-032-19865-5_13"},"language":"en","primary_location":{"id":"doi:10.1007/978-3-032-19865-5_13","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-032-19865-5_13","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"},"type":"book-chapter","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5119915136","display_name":"Dmitrii Radivonchik","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dmitrii Radivonchik","raw_affiliation_strings":["Amsterdam, Netherlands"],"raw_orcid":"https://orcid.org/0009-0005-9885-6257","affiliations":[{"raw_affiliation_string":"Amsterdam, Netherlands","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5098675073","display_name":"Yakov Kuzin","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Yakov Kuzin","raw_affiliation_strings":["Saint-Petersburg University, Saint Petersburg, Russia"],"raw_orcid":"https://orcid.org/0009-0009-2961-6021","affiliations":[{"raw_affiliation_string":"Saint-Petersburg University, Saint Petersburg, Russia","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136331925","display_name":"Anton Chizhov","orcid":"https://orcid.org/0009-0007-3042-345X"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Anton Chizhov","raw_affiliation_strings":["Saint-Petersburg University, Saint Petersburg, Russia"],"raw_orcid":"https://orcid.org/0009-0007-3042-345X","affiliations":[{"raw_affiliation_string":"Saint-Petersburg University, Saint Petersburg, Russia","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5036412698","display_name":"Dmitriy Shcheka","orcid":null},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Dmitriy Shcheka","raw_affiliation_strings":["Saint-Petersburg University, Saint Petersburg, Russia"],"raw_orcid":"https://orcid.org/0009-0000-1519-8740","affiliations":[{"raw_affiliation_string":"Saint-Petersburg University, Saint Petersburg, Russia","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5093550040","display_name":"Mikhail Firsov","orcid":"https://orcid.org/0000-0001-6739-7303"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Mikhail Firsov","raw_affiliation_strings":["Saint-Petersburg University, Saint Petersburg, Russia"],"raw_orcid":"https://orcid.org/0000-0001-6739-7303","affiliations":[{"raw_affiliation_string":"Saint-Petersburg University, Saint Petersburg, Russia","institution_ids":[]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5136325156","display_name":"Kirill Smirnov","orcid":"https://orcid.org/0000-0003-4727-3455"},"institutions":[],"countries":[],"is_corresponding":false,"raw_author_name":"Kirill Smirnov","raw_affiliation_strings":["Saint-Petersburg University, Saint Petersburg, Russia"],"raw_orcid":"https://orcid.org/0000-0003-4727-3455","affiliations":[{"raw_affiliation_string":"Saint-Petersburg University, Saint Petersburg, Russia","institution_ids":[]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5135880181","display_name":"George Chernishev","orcid":null},"institutions":[],"countries":[],"is_corresponding":true,"raw_author_name":"George Chernishev","raw_affiliation_strings":["Saint-Petersburg University, Saint Petersburg, Russia"],"raw_orcid":"https://orcid.org/0000-0002-4265-9642","affiliations":[{"raw_affiliation_string":"Saint-Petersburg University, Saint Petersburg, Russia","institution_ids":[]}]}],"institutions":[],"countries_distinct_count":0,"institutions_distinct_count":7,"corresponding_author_ids":["https://openalex.org/A5135880181"],"corresponding_institution_ids":[],"apc_list":{"value":5000,"currency":"EUR","value_usd":5392},"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.95004897,"is_in_top_1_percent":false,"is_in_top_10_percent":true},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"160","last_page":"167"},"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.4717999994754791,"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.4717999994754791,"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/T11719","display_name":"Data Quality and Management","score":0.12690000236034393,"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"}},{"id":"https://openalex.org/T10181","display_name":"Natural Language Processing Techniques","score":0.05209999904036522,"subfield":{"id":"https://openalex.org/subfields/1702","display_name":"Artificial Intelligence"},"field":{"id":"https://openalex.org/fields/17","display_name":"Computer Science"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/sql","display_name":"SQL","score":0.6083999872207642},{"id":"https://openalex.org/keywords/decoupling","display_name":"Decoupling (probability)","score":0.5680999755859375},{"id":"https://openalex.org/keywords/predicate","display_name":"Predicate (mathematical logic)","score":0.5644999742507935},{"id":"https://openalex.org/keywords/relational-database","display_name":"Relational database","score":0.3986000120639801},{"id":"https://openalex.org/keywords/first-order-logic","display_name":"First-order logic","score":0.30559998750686646},{"id":"https://openalex.org/keywords/algebra-over-a-field","display_name":"Algebra over a field","score":0.27549999952316284}],"concepts":[{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.8651000261306763},{"id":"https://openalex.org/C510870499","wikidata":"https://www.wikidata.org/wiki/Q47607","display_name":"SQL","level":2,"score":0.6083999872207642},{"id":"https://openalex.org/C205606062","wikidata":"https://www.wikidata.org/wiki/Q5249645","display_name":"Decoupling (probability)","level":2,"score":0.5680999755859375},{"id":"https://openalex.org/C140146324","wikidata":"https://www.wikidata.org/wiki/Q1144319","display_name":"Predicate (mathematical logic)","level":2,"score":0.5644999742507935},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.5329999923706055},{"id":"https://openalex.org/C11413529","wikidata":"https://www.wikidata.org/wiki/Q8366","display_name":"Algorithm","level":1,"score":0.44179999828338623},{"id":"https://openalex.org/C80444323","wikidata":"https://www.wikidata.org/wiki/Q2878974","display_name":"Theoretical computer science","level":1,"score":0.43790000677108765},{"id":"https://openalex.org/C5655090","wikidata":"https://www.wikidata.org/wiki/Q192588","display_name":"Relational database","level":2,"score":0.3986000120639801},{"id":"https://openalex.org/C100481476","wikidata":"https://www.wikidata.org/wiki/Q4055684","display_name":"First-order logic","level":2,"score":0.30559998750686646},{"id":"https://openalex.org/C136119220","wikidata":"https://www.wikidata.org/wiki/Q1000660","display_name":"Algebra over a field","level":2,"score":0.27549999952316284},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.25769999623298645},{"id":"https://openalex.org/C206729178","wikidata":"https://www.wikidata.org/wiki/Q2271896","display_name":"Scheduling (production processes)","level":2,"score":0.257099986076355},{"id":"https://openalex.org/C2778361913","wikidata":"https://www.wikidata.org/wiki/Q7248437","display_name":"Program transformation","level":2,"score":0.2551000118255615},{"id":"https://openalex.org/C2780654840","wikidata":"https://www.wikidata.org/wiki/Q333341","display_name":"Abstract interpretation","level":2,"score":0.2547000050544739},{"id":"https://openalex.org/C154945302","wikidata":"https://www.wikidata.org/wiki/Q11660","display_name":"Artificial intelligence","level":1,"score":0.2508000135421753}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1007/978-3-032-19865-5_13","is_oa":false,"landing_page_url":"https://doi.org/10.1007/978-3-032-19865-5_13","pdf_url":null,"source":{"id":"https://openalex.org/S106296714","display_name":"Lecture notes in computer science","issn_l":"0302-9743","issn":["0302-9743","1611-3349"],"is_oa":false,"is_in_doaj":false,"is_core":true,"host_organization":"https://openalex.org/P4310319900","host_organization_name":"Springer Science+Business Media","host_organization_lineage":["https://openalex.org/P4310319900","https://openalex.org/P4310319965"],"host_organization_lineage_names":["Springer Science+Business Media","Springer Nature"],"type":"book series"},"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Lecture Notes in Computer Science","raw_type":"book-chapter"}],"best_oa_location":null,"sustainable_development_goals":[],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":10,"referenced_works":["https://openalex.org/W2066679214","https://openalex.org/W2079112936","https://openalex.org/W2158237121","https://openalex.org/W2295596515","https://openalex.org/W4233550397","https://openalex.org/W4375956844","https://openalex.org/W4390051954","https://openalex.org/W4390532280","https://openalex.org/W4394867763","https://openalex.org/W4411374488"],"related_works":[],"abstract_inverted_index":null,"counts_by_year":[],"updated_date":"2026-05-19T06:13:58.757530","created_date":"2026-05-18T00:00:00"}