{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,7]],"date-time":"2026-03-07T01:17:24Z","timestamp":1772846244825,"version":"3.50.1"},"reference-count":16,"publisher":"IEEE","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2008,4]]},"DOI":"10.1109\/icde.2008.4497528","type":"proceedings-article","created":{"date-parts":[[2008,4,29]],"date-time":"2008-04-29T15:04:39Z","timestamp":1209481479000},"page":"1190-1199","source":"Crossref","is-referenced-by-count":18,"title":["Optimizing Star Join Queries for Data Warehousing in Microsoft SQL Server"],"prefix":"10.1109","author":[{"given":"Cesar A.","family":"Galindo-Legaria","sequence":"first","affiliation":[]},{"given":"Torsten","family":"Grabs","sequence":"additional","affiliation":[]},{"given":"Sreenivas","family":"Gukal","sequence":"additional","affiliation":[]},{"given":"Steve","family":"Herbert","sequence":"additional","affiliation":[]},{"given":"Aleksandras","family":"Surna","sequence":"additional","affiliation":[]},{"given":"Shirley","family":"Wang","sequence":"additional","affiliation":[]},{"given":"Wei","family":"Yu","sequence":"additional","affiliation":[]},{"given":"Peter","family":"Zabback","sequence":"additional","affiliation":[]},{"given":"Shin","family":"Zhang","sequence":"additional","affiliation":[]}],"member":"263","reference":[{"key":"15","year":"0","journal-title":"Website"},{"key":"16","first-page":"86","article-title":"hash joins and hash teams in microsoft sql server, in proc","author":"graefe","year":"1998","journal-title":"VLDB"},{"key":"13","doi-asserted-by":"publisher","DOI":"10.1145\/1247480.1247566"},{"key":"14","doi-asserted-by":"publisher","DOI":"10.1145\/248603.248616"},{"key":"11","doi-asserted-by":"publisher","DOI":"10.1109\/ICDE.2003.1260803"},{"key":"12","doi-asserted-by":"publisher","DOI":"10.1016\/B978-155860869-6\/50070-6"},{"key":"3","first-page":"314","article-title":"measuring the complexity of join enumeration in query optimization, in proc","author":"ono","year":"1990","journal-title":"VLDB"},{"key":"2","doi-asserted-by":"publisher","DOI":"10.1145\/93597.98720"},{"key":"1","doi-asserted-by":"publisher","DOI":"10.1145\/152610.152611"},{"key":"10","doi-asserted-by":"publisher","DOI":"10.1145\/322234.322238"},{"key":"7","year":"0"},{"key":"6","author":"kimball","year":"2002","journal-title":"The Data Warehouse Toolkit The Complete Guide to Dimensional Modeling"},{"key":"5","doi-asserted-by":"publisher","DOI":"10.1145\/1270.1498"},{"key":"4","first-page":"54","article-title":"on the complexity of generating optimal left-deep processing trees with cross products","author":"cluet","year":"0","journal-title":"Proc ICDT1995"},{"key":"9","doi-asserted-by":"publisher","DOI":"10.1145\/564691.564754"},{"key":"8","year":"0","journal-title":"Oracle Data Warehousing Guide 10g R2"}],"event":{"name":"2008 IEEE 24th International Conference on Data Engineering (ICDE 2008)","location":"Cancun, Mexico","start":{"date-parts":[[2008,4,7]]},"end":{"date-parts":[[2008,4,12]]}},"container-title":["2008 IEEE 24th International Conference on Data Engineering"],"original-title":[],"link":[{"URL":"http:\/\/xplorestaging.ieee.org\/ielx5\/4492792\/4497384\/04497528.pdf?arnumber=4497528","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2017,3,16]],"date-time":"2017-03-16T18:57:22Z","timestamp":1489690642000},"score":1,"resource":{"primary":{"URL":"http:\/\/ieeexplore.ieee.org\/document\/4497528\/"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2008,4]]},"references-count":16,"URL":"https:\/\/doi.org\/10.1109\/icde.2008.4497528","relation":{},"subject":[],"published":{"date-parts":[[2008,4]]}}}