{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2024,9,4]],"date-time":"2024-09-04T19:17:48Z","timestamp":1725477468856},"reference-count":6,"publisher":"IEEE","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[1997]]},"DOI":"10.1109\/icde.1997.583381","type":"proceedings-article","created":{"date-parts":[[2002,11,22]],"date-time":"2002-11-22T15:21:11Z","timestamp":1037978471000},"page":"321","source":"Crossref","is-referenced-by-count":1,"title":["Subquery elimination: a complete unnesting algorithm for an extended relational algebra"],"prefix":"10.1109","author":[{"given":"P.","family":"Celis","sequence":"first","affiliation":[]},{"given":"H.","family":"Zeller","sequence":"additional","affiliation":[]}],"member":"263","reference":[{"key":"ref4","doi-asserted-by":"publisher","DOI":"10.1145\/319732.319745"},{"journal-title":"SQL-like and QUEL-like correlation queries with aggregates revisited","year":"0","author":"kiessling","key":"ref3"},{"key":"ref6","first-page":"91","article-title":"Improved unnesting algorithms for join aggregate SQL queries","author":"muralikrishna","year":"1992","journal-title":"Proc of 16th VLDB"},{"key":"ref5","first-page":"77","article-title":"Optimization and dataflow algorithms for nested tree queries","author":"muralikrishna","year":"1989","journal-title":"Proc of 16th VLDB"},{"key":"ref2","doi-asserted-by":"publisher","DOI":"10.1145\/38714.38723"},{"key":"ref1","first-page":"197","article-title":"Of nests and trees: a unified approach to processing queries that contain nested subqueries. Aggregates, and Quantifiers","author":"dayal","year":"1987","journal-title":"Proc 11th VLDB Conf"}],"event":{"name":"Proceedings 13th International Conference on Data Engineering","start":{"date-parts":[[1997,4,7]]},"location":"Birmingham, UK","end":{"date-parts":[[1997,4,11]]}},"container-title":["Proceedings 13th International Conference on Data Engineering"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx3\/4453\/12626\/00583381.pdf?arnumber=583381","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2019,9,30]],"date-time":"2019-09-30T23:40:35Z","timestamp":1569886835000},"score":1,"resource":{"primary":{"URL":"https:\/\/ieeexplore.ieee.org\/document\/583381\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[1997]]},"references-count":6,"URL":"https:\/\/doi.org\/10.1109\/icde.1997.583381","relation":{},"subject":[],"published":{"date-parts":[[1997]]}}}