The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Conceptual modeling for ETL processes
Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
Naive Semantics to Support Automated Database Design
IEEE Transactions on Knowledge and Data Engineering
Aggregation in Natural Language Generation
EWNLG '93 Selected papers from the Fourth European Workshop on Trends in Natural Language Generation, An Artificial Intelligence Perspective
Transformation of Requirement Specifications Expressed in Natural Language into an EER Model
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
ER '93 Proceedings of the 12th International Conference on the Entity-Relationship Approach: Entity-Relationship Approach
A survey of approaches to automatic schema matching
The VLDB Journal — The International Journal on Very Large Data Bases
Applying MDA to the development of data warehouses
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Mapping conceptual to logical models for ETL processes
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Real versus Template-Based Natural Language Generation: A False Opposition?
Computational Linguistics
Designing ETL processes using semantic web technologies
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Automating multidimensional design from ontologies
Proceedings of the ACM tenth international workshop on Data warehousing and OLAP
Synthesizing structured text from logical database subsets
EDBT '08 Proceedings of the 11th international conference on Extending database technology: Advances in database technology
Discovering topical structures of databases
Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Natural language processing: mature enough for requirements documents analysis?
NLDB'05 Proceedings of the 10th international conference on Natural Language Processing and Information Systems
Generating tailored textual summaries from ontologies
ESWC'05 Proceedings of the Second European conference on The Semantic Web: research and Applications
Flexible and customizable NL representation of requirements for ETL processes
NLDB'07 Proceedings of the 12th international conference on Applications of Natural Language to Information Systems
Automating the loading of business process data warehouses
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Representation of conceptual ETL designs in natural language using Semantic Web technology
Data & Knowledge Engineering
Model driven data warehouse using MDA and 2TUP
Journal of Computational Methods in Sciences and Engineering - Special Supplement Issue in Section A and B: Selected Papers from the ISCA International Conference on Software Engineering and Data Engineering, 2009
E-ETL: framework for managing evolving etl processes
Proceedings of the 4th workshop on Workshop for Ph.D. students in information & knowledge management
Multidimensional integrated ontologies: a framework for designing semantic data warehouses
Journal on Data Semantics XIII
Ontology-Driven conceptual design of ETL processes using graph transformations
Journal on Data Semantics XIII
International Journal of Intelligent Information and Database Systems
Effective data warehouse for information delivery: a literature survey and classification
International Journal of Networking and Virtual Organisations
Hi-index | 0.00 |
The conceptual design of the Extract -- Transform -- Load (ETL) processes is a crucial, burdensome, and challenging procedure that takes places at the early phases of a Data Warehouse project. Several models have been proposed for the conceptual design and representation of ETL processes, but all share two inconveniences: they require intensive human effort from the designers to create them, as well as technical knowledge from the business people to understand them. In a previous work, we have relaxed the former difficulty by working on the automation of the conceptual design leveraging Semantic Web technology. In this paper, we built upon our previous results and we tackle the second issue by investigating the application of natural language generation techniques to the ETL environment. In particular, we provide a method for the representation of a conceptual ETL design as a narrative, which is the most natural means of communication and does not require knowledge of any specific model. We discuss how linguistic techniques can be used for the establishment of a common application vocabulary. Finally, we present a flexible and customizable template-based mechanism for generating natural language representations for the ETL process requirements and operations.