Natural language reporting for ETL processes

DOLAP: Proceedings of the ACM International Workshop on Data Warehousing and OLAP

Volumn , Issue , 2008, Pages 65-72

  Simitsis, Alkis ^a   Skoutas, Dimitrios ^b   Castellanos, Malü ^a  

^a HEWLETT PACKARD LABORATORIES   (United States)

^b NATIONAL TECHNICAL UNIVERSITY OF ATHENS   (Greece)

Author keywords

Conceptual model; Data warehouses; ETL; Metadata; Natural language; Ontologies; Semantic web

Indexed keywords

CONCEPTUAL MODEL; CUSTOMIZABLE; ETL; ETL PROCESS; EXTRACT TRANSFORM LOADS; LINGUISTIC TECHNIQUES; NATURAL LANGUAGE; NATURAL LANGUAGE GENERATION TECHNIQUES; NATURAL LANGUAGE REPRESENTATION; NATURAL LANGUAGES; SEMANTIC WEB TECHNOLOGY; TEMPLATE-BASED;

CONCEPTUAL DESIGN; KNOWLEDGE MANAGEMENT; KNOWLEDGE REPRESENTATION; LINGUISTICS; METADATA; MULTI AGENT SYSTEMS; ONTOLOGY; SEMANTIC WEB; SEMANTICS;

DATA WAREHOUSES;

EID: 70349428840     PISSN: None     EISSN: None     Source Type: Conference Proceeding    
DOI: 10.1145/1458432.1458444     Document Type: Conference Paper

References (33)

1. Bontcheva, K.: Generating Tailored Textual Summaries from Ontologies. In ESWC, 2005.
2. Bontcheva, K., Wilks, Y.: Automatic Report Generation from Ontologies: The MIAKT Approach. In NLDB, 2004.
3. Dalianis, H., Hovy, E.H.: Aggregation in Natural Language Generation. In EWNLG, 1993.
4. van Deemter, K, Theune, M., Krahmer, E.: Real versus Template-Based Natural Language Generation: A False Opposition? Computational Linguistics 31(1), 2005.
5. IBM. IBM WebSphere DataStage. URL: http://www-306.ibm.com/software/data/ integration/datastage/
6. Informatica. PowerCenter. URL: http://www.informatica.com/powercenter/
7. Kedad, Z., Métais, E.: Ontology-Based Data Cleaning. In NLDB, 2002.
8. Kimball, R., Caserta, J.: The Data Warehouse ETL Toolkit (chapter 11). Wiley Publishing, Inc., 2004.
9. Kimball, R., et al.: The Data Warehouse Lifecycle Toolkit. John Wiley & Sons, 1998.
10. Kiyavitskaya, N., Zeni, N., Mich, L., Mylopoulos, J.: Experimenting with Linguistic Tools for Conceptual Modelling: Quality of the Models and Critical Features. In NLDB, 2004.
11. Kof, L.: Natural Language Processing: Mature Enough for Requirements Documents Analysis? In NLDB, 2005.
12. Luján-Mora, S., Vassiliadis, P., Trujillo, J.: Data Mapping Diagrams for Data Warehouse Design with UML. In ER, 2004.
13. Mazon, J-N., Trujillo, J., Serrano, M., Piattini, M.: Applying MDA to the Development of Data Warehouses. In DOLAP, 2005.
14. Metais, E., Meunier, J., Levreau, G.: Database Schema Design: A Perspective from Natural Language Techniques to Validation and View Integration. In ER, 1993.
15. Microsoft. Data Transformation Services. URL: http://www.microsoft.com/ sql/prodinfo/features/
16. Oracle. Oracle Warehouse Builder Product Page. URL: http://otn.oracle. com/products/warehouse/content.html
17. Rahm, E., Bernstein, P. A.: A survey of approaches to automatic schema matching. In VLDB J. 10(4), 2001.
18. Reape, M., Mellish, C.: Just What is Aggregation Anyway? In ENLG, 1999.
19. Reiter, E., Mellish, C., Levine, J.: Automatic generation of technical documentation. In Applied Artificial Intelligence 9(3), 1995.
20. Rolland, C., Proix, C.: A Natural Language Approach for Requirements Engineering. In CAiSE, 1992.
21. Romero, O., Abelló, A.: Automating Multidimensional Design from Ontologies. In DOLAP, 2007.
22. Simitsis, A.: Mapping Conceptual to Logical Models for ETL Processes. In DOLAP, 2005.
23. Simitsis, A., Koutrika, G., Alexandrakis, Y., Ioannidis, Y.: Synthesizing Structured Text from Logical Database Subsets. In EDBT, 2008.
24. Skoutas, D., Simitsis, A.: Designing ETL Processes Using Semantic Web Technologies. In DOLAP, 2006.
25. Skoutas, D., Simitsis, A.: Flexible and Customizable NL Representation of Requirements for ETL processes. In NLDB, 2007.
26. Smith, M. K., Welty, C., McGuinness, D. L. OWL Web Ontology Language Guide. W3C Rec. 2004 (http://www.w3.org/TR/owl-guide)
27. Storey, V. C., Goldstein, R. C., Ullrich, H.: Naive Semantics to Support Automated Database Design. In TKDE 14(1), 2002.
28. Min Tjoa, A., Berger, L.: Transformation of Requirement Specifications Expressed in Natural Language into an EER Model. In ER, 1993.
29. Trujillo, J., Lujan-Mora, S.: A UML Based Approach for Modeling ETL Processes in Data Warehouses. In ER, 2003.
30. Vassiliadis, P., Simitsis, A., Skiadopoulos, S.: Conceptual Modeling for ETL Processes. In DOLAP, 2002.
31. Wilcock, G.: Talking OWLs: Towards an Ontology Verbalizer. In ISWC, 2003.
32. Wilcock, G., Jokinen, K.: Generating Responses and Explanations from RDF/XML and DAML+OIL. In IJCAI, 2003.
33. Wu, W., Reinwald, R., Sismanis, Y., Manjrekar, R.: Discovering Topical Structures of Databases. In SIGMOD, 2008.