Data mapper: An operator for expressing one-to-many data transformations

Lecture Notes in Computer Science

Volumn 3589, Issue , 2005, Pages 136-145

  Carreira, Paulo ^a   Galhardas, Helena ^b   Pereira, João ^b   Lopes, Antónia ^a  

^a UNIVERSITY OF LISBON   (Portugal)

^b INSTITUTO SUPERIOR TÉCNICO   (Portugal)

Author keywords

[No Author keywords available]

Indexed keywords

ALGEBRA; DATA WAREHOUSES; OPTIMIZATION; QUERY LANGUAGES; RELATIONAL DATABASE SYSTEMS;

DATA MAPPER; DATA MIGRATION; DATA TRANSFORMATIONS; RELATIONAL QUERIES;

DATA REDUCTION;

EID: 26844556548     PISSN: 03029743     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1007/11546849_14     Document Type: Conference Paper

References (19)

1. A. V. Aho and J. D. Ullman. Universality of data retrieval languages. In Proc. of the 6th ACM SIGACT-SIGPLAN Symposium on Principles of Programming Languages, pages 110-119. ACM Press, 1979.
2. P. A. Bernstein and E. Rahm. Data wharehouse scenarios for model management. In Int'l Conf. on Conceptual Modeling / the Entity Relationship Approach, 2000.
3. P. Carreira and H. Galhardas. Efficient development of data migration transformations. In ACM SIGMOD Int'l Conf. on the Managment of Data, June 2004.
4. P. Carreira and H. Galhardas. Execution of Data Mappers. In Int'l Workshop on Information Quality in Information Systems. ACM, June 2004.
5. P. Carreira, H. Galhardas, A. Lopes, and J. Pereira. Extending the relational algebra with the Mapper operator. DI/FCUL TR 05-2, Department of Informatics, University of Lisbon, January 2005. Available at the url http://www.di.fc.ul.pt/tech-reports.
6. S. Chaudhuri and K. Shim. Query optimization in the presence of foreign functions. In Proc. of the Int'l Conf. on Very Large Data Bases (VLDB'93), 1993.
7. H. Galhardas, D. Florescu, D. Shasha, and E. Simon. Ajax: An extensible data cleaning tool. ACM SIGMOD Int'l Conf. on Management of Data, 2(29), 2000.
8. H. Galhardas, D. Florescu, D. Shasha, E. Simon, and C.-A. Saita. Declarative Data Cleaning: Language, Model, and Algorithms. In Proc. of the Int'l Conf. on Very Large Data Bases (VLDB'01), Rome, Italy, September 2001.
9. L. Haas, R. Miller, B. Niswonger, M. T. Roth, P.M. Scwarz, and E. L. Wimmers. Transforming heterogeneous data with database middleware: Beyond integration. Special Issue on Data Transformations. IEEE Data Eng. Bulletin, 22(1), 1999.
10. J. M. Hellerstein. Optimization techniques for queries with expensive methods. ACM Transactions on Database Systems, 22(2): 113-157, June 1998.
11. W. Kim, B.-J. Choi, E.-K. Hong, S.-K. Kim, and D. Lee. A taxonomy of dirty data. Data Mining and Knowledge Discovery, 7(1):81-99, January 2003.
12. L. V. S. Lakshmanan, F. Sadri, and I. N. Subramanian. SchemaSQL - A Language for Querying and Restructuring Database Systems. In Proc. Int'l Conf. on Very Large Databases (VLDB'96), pages 239-250, Bombay, India, September 1996.
13. R. J. Miller. Using Schematically Heterogeneous Structures. Proc. of ACM SIGMOD Int'l Conf. on the Managment of Data, 2(22): 189-200, June 1998.
14. E. Rahm and H.-H. Do. Data Cleaning: Problems and current approaches. IEEE Bulletin of the Technical Comittee on Data Engineering, 24(4), 2000.
15. V. Raman and J. M. Hellerstein. Potter's Wheel: An Interactive Data Cleaning System. In Proc. of the Int'l Conf. on Very Large Data Bases (VLDB'01), 2001.
16. P. G. Selinger, M. M. Astrahan, D. D. Chamberlin, R. A. Lorie, and T. G. Price. Access path selection in a relational database management system. In ACM SIGMOD Int'l Conf. on the Managment of Data, 1979.
17. N. C. Shu, B. C. Housel, and V. Y. Lum. CONVERT: A High Level Translation Definition Language for Data Conversion. Communications of the ACM, 18(10):557-567, October 1975.
18. N. C. Shu, B. C. Housel, R. W. Taylor, S. P. Ghosh, and V. Y. Lum. EXPRESS: A Data Extraction, Processing and REStructuring System. ACM Transactions on Database Systems, 2(2):134-174, June 1977.
19. A. Simitsis, P. Vassiliadis, and T. K. Sellis. Optimizing ETL processes in data warehouses. In Proc. of the 21st Int'l Conf. on Data Engineering (ICDE), 2005.