{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,9,19]],"date-time":"2025-09-19T08:18:33Z","timestamp":1758269913018,"version":"3.41.0"},"publisher-location":"New York, NY, USA","reference-count":8,"publisher":"ACM","license":[{"start":{"date-parts":[[2005,10,31]],"date-time":"2005-10-31T00:00:00Z","timestamp":1130716800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/www.acm.org\/publications\/policies\/copyright_policy#Background"}],"content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":[],"published-print":{"date-parts":[[2005,10,31]]},"DOI":"10.1145\/1099554.1099709","type":"proceedings-article","created":{"date-parts":[[2006,2,6]],"date-time":"2006-02-06T15:52:40Z","timestamp":1139241160000},"page":"602-608","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":12,"title":["A formal characterization of PIVOT\/UNPIVOT"],"prefix":"10.1145","author":[{"given":"Catharine M.","family":"Wyss","sequence":"first","affiliation":[{"name":"Indiana University, Bloomington, IN"}],"role":[{"role":"author","vocabulary":"crossref"}]},{"given":"Edward L.","family":"Robertson","sequence":"additional","affiliation":[{"name":"Indiana University, Bloomington, IN"}],"role":[{"role":"author","vocabulary":"crossref"}]}],"member":"320","published-online":{"date-parts":[[2005,10,31]]},"reference":[{"key":"e_1_3_2_1_1_1","unstructured":"Fulya Erdinc and Catharine M. Wyss. Intrinsic Rule-Based Optimization of PIVOT and UNPIVOT Operations within RDBMS. Forthcoming.  Fulya Erdinc and Catharine M. Wyss. Intrinsic Rule-Based Optimization of PIVOT and UNPIVOT Operations within RDBMS. Forthcoming."},{"key":"e_1_3_2_1_2_1","volume-title":"VLDB","author":"Cunningham Conor","year":"2004","unstructured":"Conor Cunningham , C\u00e9sar A. Galindo-Legaria , and Goetz Graefe . PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS . VLDB 2004 . Conor Cunningham, C\u00e9sar A. Galindo-Legaria, and Goetz Graefe. PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS. VLDB 2004."},{"key":"e_1_3_2_1_3_1","volume-title":"Computers and Intractability: A Guide to the Theory of NP-Completeness","author":"Garey M. R.","year":"1979","unstructured":"M. R. Garey and D. S. Johnson . Computers and Intractability: A Guide to the Theory of NP-Completeness . W. H. Freeman and Company , 1979 . M. R. Garey and D. S. Johnson. Computers and Intractability: A Guide to the Theory of NP-Completeness. W. H. Freeman and Company, 1979."},{"key":"e_1_3_2_1_4_1","volume-title":"SchemaSQL - A Language for Interoperability in Relational Multi-Database Systems. VLDB","author":"Lakshmanan L. V. S.","year":"1996","unstructured":"L. V. S. Lakshmanan , F. Sadri , and I. N. Subramanian . SchemaSQL - A Language for Interoperability in Relational Multi-Database Systems. VLDB 1996 . L. V. S. Lakshmanan, F. Sadri, and I. N. Subramanian. SchemaSQL - A Language for Interoperability in Relational Multi-Database Systems. VLDB 1996."},{"key":"e_1_3_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/503099.503102"},{"key":"e_1_3_2_1_6_1","volume-title":"Database Management Systems","author":"Ramakrishnan Raghu","year":"2003","unstructured":"Raghu Ramakrishnan and Johannes Gehrke . Database Management Systems , 3 rd Edition. McGraw-Hill , 2003 . Raghu Ramakrishnan and Johannes Gehrke. Database Management Systems, 3rd Edition. McGraw-Hill, 2003.","edition":"3"},{"key":"e_1_3_2_1_8_1","doi-asserted-by":"publisher","DOI":"10.1145\/1071610.1071618"},{"key":"e_1_3_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/872757.872767"}],"event":{"name":"CIKM05: Conference on Information and Knowledge Management","sponsor":["ACM Association for Computing Machinery","SIGIR ACM Special Interest Group on Information Retrieval"],"location":"Bremen Germany","acronym":"CIKM05"},"container-title":["Proceedings of the 14th ACM international conference on Information and knowledge management"],"original-title":[],"link":[{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1099554.1099709","content-type":"unspecified","content-version":"vor","intended-application":"text-mining"},{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.1145\/1099554.1099709","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,6,18]],"date-time":"2025-06-18T16:18:44Z","timestamp":1750263524000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.1145\/1099554.1099709"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2005,10,31]]},"references-count":8,"alternative-id":["10.1145\/1099554.1099709","10.1145\/1099554"],"URL":"https:\/\/doi.org\/10.1145\/1099554.1099709","relation":{},"subject":[],"published":{"date-parts":[[2005,10,31]]},"assertion":[{"value":"2005-10-31","order":2,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}