A formal characterization of PIVOT/UNPIVOT

International Conference on Information and Knowledge Management, Proceedings

Volumn , Issue , 2005, Pages 602-608

  Wyss, Catharine M ^a   Robertson, Edward L ^a  

^a INDIANA UNIVERSITY   (United States)

Author keywords

Data Mapping; Data Modeling; exRA; Extended RA; Federated Interoperable RA; FIRA; OLAP; PIVOT; UNPIVOT

Indexed keywords

DATA MAPPING; DATA MODELING; EXRA; EXTENDED RA; FEDERATED INTEROPERABLE RA; FIRA; OLAP; PIVOT; UNPIVOT;

CHARACTERIZATION; DATA PROCESSING; INFORMATION ANALYSIS; KNOWLEDGE ACQUISITION; LARGE SCALE SYSTEMS; MATHEMATICAL MODELS;

DATABASE SYSTEMS;

EID: 33745767815     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1099554.1099709     Document Type: Conference Paper

References (9)

1. Fulya Erdinc and Catharine M. Wyss. Intrinsic, Rule-Baced Optimization of PIVOT and UNPIVOT Operations within RDBMS, Forthcoming.
2. Conor Cunningham, César A. Galindo-Legaria, and Goetz Graefe. PIVOT and UNPIVOT: Optimization and Execution Strategies in an RDBMS. VLDB 2004.
3. M. R. Garey and D. S. Johnson. Computers and Intractability: A Guide to the Theory of NP-Completeness. W. H. Freeman and Company, 1979.
4. L. V. S. Lakshmanan, F. Sadri, and I. N. Subramanian. SchemaSQL - A Language for Interoperability in Relational Multi-Database Systems. VLDB 1996.
5. L. V. S. Lakshmanan, F. Sadri, and I. N. Subramanian. SchemaSQL - An Extension to SQL for Multidatabase Interoperability. TODS, December 2001.
6. Raghu Ramakrishnan and Johannes Gehrke. Database Management Systems, 3rd Edition. McGraw-Hill, 2003.
7. Edward L. Robertson and Catharine M. Wyss. Optimal Tuple Merge is NP-complete. IUCS Technical Report TR599, August 2004.
8. Catharine M. Wyss and Edward L. Robertson. Relational Languages for Metadata Integration. TODS, June 2005.
9. Andrew Witkowski, Srikanth Bellamkonda, Tolga Bozkaya, Gregory Dorman, Nathan Folkert, Abhinav Gupta, Lei Shen, and Sankar Subramanian. Spreadsheets in RDBMS for OLAP. SIGMOD 2003.