One-to-many data transformation operations optimization and execution on an RDBMS

ICEIS 2007 - 9th International Conference on Enterprise Information Systems, Proceedings

Volumn DISI, Issue , 2007, Pages 21-27

  Carreira, Paulo ^a   Galhardas, Helena ^b   Pereira, João ^b   Wichert, Andrzej ^b  

^a UNIVERSITY OF LISBON   (Portugal)

^b INESC ID   (Portugal)

Author keywords

Data cleaning; Data integration; Data warehousing; ETL; Query optimization

Indexed keywords

DATA CLEANING; DATA INTEGRATION; DATA WAREHOUSING; ETL; QUERY OPTIMIZATION;

DATA HANDLING; OPTIMIZATION;

INFORMATION SYSTEMS;

EID: 67249099475     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: None     Document Type: Conference Paper

References (20)

1. Aho, A. V. and Ullman, J. D. (1979). Universality of data retrieval languages. In Proc. of the 6th ACM SIGACTSIGPLAN Symposium on Principles of Programming Lang., pages 110-119. ACM Press.
2. Amer-Yahia, S. and Cluet, S. (2004). A declarative approach to optimize bulk loading into databases. ACM Transactions of Database Systems, 29(2):233-281.
3. Apache (2005). Derby homepage. http://db.apache.org/derby.
4. Carreira, P., Galhardas, H., Lopes, A., and Pereira, J. (2005a). Extending the relational algebra with the Mapper operator. DI/FCUL TR 05-12, Department of Informatics, University of Lisbon. URL http://www.di.fc.ul.pt/ tech-reports.
5. Carreira, P., Galhardas, H., Lopes, A., and Pereira, J. (2006). One-to-many transformation through data mappers. Data and Knowledge Engineering Journal (DKE), Elsevier Science.
6. Carreira, P., Galhardas, H., Pereira, J., and Lopes, A. (2005b). Data mapper: An operator for expressiong one-to-many data transformations. In 7th Int'l Conf. on Data Warehousing and Knowledge Discovery, DaWaK '05, volume 3589 of LNCS. Springer-Verlag.
7. Chaudhuri, S. (1998). An overview of query optimization in relational systems. In PODS '98: Proc. of the ACM Symp. on Principles of Database Systems, pages 34-43. ACM Press.
8. Chaudhuri, S. and Shim, K. (1993). Query optimization in the presence of foreign functions. In Proc. of the Int'l Conf. on Very Large Data Bases (VLDB'93), pages 529-542.
9. Cui, Y. and Widom, J. (2001). Lineage tracing for general data warehouse transformations. In Proc. of the Int'l Conf. on Very Large Data Bases (VLDB'01).
10. Eisenberg, A., Melton, J., Michels, K. K. J.-E., and Zemke, F. (2004). SQL:2003 has been published. ACM SIGMOD Record, 33(1):119-126. (Pubitemid 40290250)
11. Galhardas, H., Florescu, D., Shasha, D., and Simon, E. (2000). Ajax: An extensible data cleaning tool. ACM SIGMOD Int'l Conf. on Management of Data, 2(29).
12. Garcia-Molina, H., Ullman, J. D., and Widom, J. (2002). Database Systems - The Complete Book. Prentice-Hall.
13. Haas, L. M., Miller, R. J., Niswonger, B., Roth, M. T., Schwarz, P. M., and Wimmers, E. L. (1999). Transforming heterogeneous data with database middleware: Beyond integration. IEEE Data Engineering Bulletin, 22(1):31-36.
14. Hellerstein, J. M. (1998). Optimization techniques for queries with expensive methods. ACM Transactions on Database Systems, 22(2): 113-157. (Pubitemid 128448477)
15. Lomet, D. and Rundensteiner, E. A., editors (1999). Special Issue on Data Transformations, volume 22. IEEE Data Engineering Bulletin.
16. Melton, J. and Simon, A. R. (2002). SQL: 1999 Understanding Relational Language Components. Morgan Kaufmann Publishers, Inc.
17. Rahm, E. and Do, H.-H. (2000). Data Cleaning: Problems and current approaches. IEEE Bulletin of the Technical Comittee on Data Engineering, 24(4).
18. Raman, V. and Hellerstein, J. M. (2001). Potter's Wheel: An Interactive Data Cleaning System. In Proc. of the Int'l Conf. on Very Large Data Bases (VLDB'01).
19. TPC (1999). Benchmark H standard specification. http://www.tpc.org.
20. van den Bercken, J., Dittrich, J. P., Kräamer, J., Schäafer, T., Schneider, M., and Seeger, B. (2001). XXL A library approach to supporting efficient implementations of advanced database queries. In Proc. of the Int'l Conf. on Very Large Data Bases (VLDB'01).