{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,5,4]],"date-time":"2025-05-04T00:02:26Z","timestamp":1746316946085},"reference-count":7,"publisher":"IEEE","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2009,12]]},"DOI":"10.1109\/csa.2009.5404288","type":"proceedings-article","created":{"date-parts":[[2010,2,16]],"date-time":"2010-02-16T16:11:08Z","timestamp":1266336668000},"source":"Crossref","is-referenced-by-count":1,"title":["Improved Query Plans for Unnesting Nested SQL Queries"],"prefix":"10.1109","author":[{"given":"Pranav","family":"Khaitan","sequence":"first","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Satish Kumar","family":"M","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Korra Sathya","family":"Babu","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Sanjay Kumar","family":"Jena","sequence":"additional","affiliation":[],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"263","reference":[{"key":"ref4","doi-asserted-by":"publisher","DOI":"10.1145\/38713.38723"},{"key":"ref3","article-title":"SQL-like and Quel-like correlation queries with aggregates revisited","author":"kiessling","year":"1984","journal-title":"UCB\/ERL Memo 84\/75"},{"key":"ref6","first-page":"77","article-title":"Optimization and Dataflow Algorithms for Nested Tree Queries","author":"muralikrishna","year":"1989","journal-title":"Proc VLDB Conf"},{"key":"ref5","first-page":"197","article-title":"Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Sub queries, Aggregates, and Quantifiers","author":"dayal","year":"1987","journal-title":"Proc VLDB Conf"},{"key":"ref7","first-page":"91","article-title":"Improved unnesting algorithms for join aggregate SQL queries","author":"muralikrishna","year":"1992","journal-title":"Proceedings of the 18th International Conference on Very Large Data Bases"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1145\/319732.319745"},{"key":"ref1","article-title":"Techniques for processing of aggregates in relational database systems","author":"epstein","year":"1979","journal-title":"ERL\/UCB Memo M79\/8"}],"event":{"name":"2009 2nd International Conference on Computer Science and its Applications (CSA)","location":"Jeju, Korea (South)","start":{"date-parts":[[2009,12,10]]},"end":{"date-parts":[[2009,12,12]]}},"container-title":["2009 2nd International Conference on Computer Science and its Applications"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx5\/5403362\/5404169\/05404288.pdf?arnumber=5404288","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2017,3,18]],"date-time":"2017-03-18T22:00:54Z","timestamp":1489874454000},"score":1,"resource":{"primary":{"URL":"http:\/\/ieeexplore.ieee.org\/document\/5404288\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2009,12]]},"references-count":7,"URL":"https:\/\/doi.org\/10.1109\/csa.2009.5404288","relation":{},"subject":[],"published":{"date-parts":[[2009,12]]}}}