{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,3,19]],"date-time":"2025-03-19T17:09:28Z","timestamp":1742404168300},"reference-count":8,"publisher":"Elsevier","isbn-type":[{"value":"9780120884698","type":"print"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2004]]},"DOI":"10.1016\/b978-012088469-8.50087-5","type":"book-chapter","created":{"date-parts":[[2009,11,6]],"date-time":"2009-11-06T09:12:29Z","timestamp":1257498749000},"page":"998-1009","source":"Crossref","is-referenced-by-count":30,"title":["PIVOT and UNPIVOT"],"prefix":"10.1016","author":[{"given":"Conor","family":"Cunningham","sequence":"first","affiliation":[]},{"given":"C\u00e9sar A.","family":"Galindo-Legaria","sequence":"additional","affiliation":[]},{"given":"Goetz","family":"Graefe","sequence":"additional","affiliation":[]}],"member":"78","reference":[{"key":"10.1016\/B978-012088469-8.50087-5_bib1","series-title":"ACM SIGMOD 2001","first-page":"571","article-title":"Orthogonal Optimization of Subqueries and Aggregation","author":"Galindo-Legaria","year":"2001"},{"key":"10.1016\/B978-012088469-8.50087-5_bib2","series-title":"Proceedings of The Fourth International Conference on Knowledge Discovery and Data Mining","first-page":"204","article-title":"On the Efficient Gathering of Sufficient Statistics for Classification from Large SQL Databases","author":"Graefe","year":"1998"},{"issue":"3","key":"10.1016\/B978-012088469-8.50087-5_bib3","first-page":"19","article-title":"The Cascades Framework for Querty Optimization","volume":"18","author":"Graefe","year":"1995","journal-title":"Data Engineering Bulletin"},{"issue":"no. 1","key":"10.1016\/B978-012088469-8.50087-5_bib4","doi-asserted-by":"crossref","DOI":"10.1023\/A:1009726021843","article-title":"Data Cube: A Relational Aggregation Operator Generalizing Group-By, Cross-Tab, and Sub-Totals","volume":"vol. 1","author":"Gray","year":"1997","journal-title":"Data Mining and Knowledge Discovery"},{"key":"10.1016\/B978-012088469-8.50087-5_bib5","series-title":"Proceedings of 25th International Conference on Very Large Data Bases","first-page":"471","article-title":"On Efficiently Implementing SchemaSQL on a SQL Database System","author":"Lakshmanan","year":"1999"},{"key":"10.1016\/B978-012088469-8.50087-5_bib6","series-title":"Proceedings of 27th International Conference on Very Large Data Bases","first-page":"149","article-title":"Storage and Querying of E-Commerce Data","author":"Agrawal","year":"2001"},{"key":"10.1016\/B978-012088469-8.50087-5_bib7","series-title":"Proceedings of the ACM SIGMOD International Conference on Management of Data","first-page":"379","article-title":"On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS","author":"Jaedicke","year":"1998"},{"key":"10.1016\/B978-012088469-8.50087-5_bib8","series-title":"Proceedings of the ACM SIGMOD International Conference on Management of Data","first-page":"52","article-title":"Spreadsheets in RDBMS for OLAP","author":"Witkowski","year":"2003"}],"container-title":["Proceedings 2004 VLDB Conference"],"original-title":[],"language":"en","deposited":{"date-parts":[[2018,12,15]],"date-time":"2018-12-15T14:26:54Z","timestamp":1544884014000},"score":1,"resource":{"primary":{"URL":"https:\/\/linkinghub.elsevier.com\/retrieve\/pii\/B9780120884698500875"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2004]]},"ISBN":["9780120884698"],"references-count":8,"URL":"https:\/\/doi.org\/10.1016\/b978-012088469-8.50087-5","relation":{},"subject":[],"published":{"date-parts":[[2004]]}}}