QoX-driven ETL design: Reducing the cost of ETL consulting engagements

SIGMOD-PODS'09 - Proceedings of the International Conference on Management of Data and 28th Symposium on Principles of Database Systems

Volumn , Issue , 2009, Pages 953-960

  Simitsis, Alkis ^a   Wilkinson, Kevin ^a   Castellanos, Malu ^a   Dayal, Umeshwar ^a  

^a HEWLETT PACKARD LABORATORIES   (United States)

Author keywords

Data warehouses; ETL; Metrics; Modeling; QoX; Quality

Indexed keywords

ALTERNATIVE DESIGNS; BUSINESS INTELLIGENCE; CURRENT PRACTICES; DESIGN PROCESS; DESIGN QUALITY; DESIGN TASKS; ETL PROCESS; EXTRACT TRANSFORM LOADS; LABOR INTENSIVE; MODELING LANGUAGES; OPTIMAL DESIGN; QUALITY METRICS; QUALITY REQUIREMENTS;

ARCHITECTURAL DESIGN; COST REDUCTION; PRODUCT DESIGN;

DATA WAREHOUSES;

EID: 70849104518     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1559845.1559954     Document Type: Conference Paper

References (16)

1. L. Chung, B.A. Nixon, E. Yu, J. Mylopoulos. Non-Functional equirements in Software Engineering. Kluwer Academic Publishing, 999.
2. N.N. Dalvi, S.K. Sanghai, P. Roy, S. Sudarshan. Pipelining in ulti-Query Optimization. In PODS, 2001.
3. U. Dayal, M. Castellanos, A. Simitsis, K. Wilkinson. Data Integration lows for Business Intelligence. In EDBT, 2009.
4. L. Golab, T. Johnson, V. Shkapenyuk. Scheduling Updates in a Real-Time Stream Warehouse. In ICDE, 2009.
5. Informatica. How to Achieve Flexible, Cost-effective Scalability nd Performance through Pushdown Processing. White aper, November 2007.
6. W.H. Inmon. Building the Data Warehouse. John Wiley, 1993.
7. Kimball, R., et al.: The Data Warehouse Lifecycle Toolkit. John Wiley &Sons1998.
8. G. Papastefanatos, P. Vassiliadis, A. Simitsis, Y. Vassiliou. Policy-Regulated Management of ETL Evolution. In Springer JoDS, Vol. XIII, pp. 146-176, 2009.
9. N. Polyzotis, S. Skiadopoulos, P. Vassiliadis, A. Simitsis, N.-E. rantzell. Supporting Streaming Updates in an Active Data Warehouse. In ICDE, pp. 476-485, 2007.
10. P. Roy, S. Seshadri, S. Sudarshan, S. Bhobe. Efficient and Extensible Algorithms for Multi Query Optimization. In SIGMOD, p. 249-260, 2000.
11. T.K. Sellis. Multiple-Query Optimization. In ACM Trans. Database Syst. 13(1), pp. 23-52, 1988.
12. A. Simitsis, P. Vassiliadis, T.K. Sellis. Optimizing ETL Processes n Data Warehouses. In ICDE, pp. 564-575, 2005.
13. C. Thomsen, T.B. Pedersen, W. Lehner. RiTE: Providing On-Demand Data for Right-Time Data Warehousing. In ICDE, pp. 456-465, 2008.
14. V. Tziovara, P. Vassiliadis, A. Simitsis. Deciding the Phys-ical Implementation of ETL Workflows. In DOLAP, pp. 49-56, 2007.
15. P. Vassiliadis, A. Simitsis. Near Real Time ETL. In Springer Annals of Information Systems, Vol. 3, pp. 19-29, 2008.
16. P. Vassiliadis, A. Simitsis, M. Terrovitis, S. Skiadopoulos. Blueprints and Measures for ETL Workflows. In ER, pp. 385-400, 2005.