A dimensional modeling manifesto
DBMS - Special issue on data warehousing
The Unified Modeling Language user guide
The Unified Modeling Language user guide
A methodological framework for data warehouse design
Proceedings of the 1st ACM international workshop on Data warehousing and OLAP
starER: a conceptual model for data warehouse design
Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
Efficient resumption of interrupted warehouse loads
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
AJAX: an extensible data cleaning tool
SIGMOD '00 Proceedings of the 2000 ACM SIGMOD international conference on Management of data
Arktos: towards the modeling, design, control and execution of ETL processes
Information Systems - Data extraction, cleaning and reconciliation
The Data Warehouse Lifecycle Toolkit: Expert Methods for Designing, Developing and Deploying Data Warehouses with CD Rom
Fundamentals of Data Warehouses
Fundamentals of Data Warehouses
Data warehouse process management
Information Systems - The 12th international conference on advanced information systems engineering (CAiSE 00)
Potter's Wheel: An Interactive Data Cleaning System
Proceedings of the 27th International Conference on Very Large Data Bases
Information Integration: Conceptual Modeling and Reasoning Support
COOPIS '98 Proceedings of the 3rd IFCIS International Conference on Cooperative Information Systems
Design and Analysis of Quality Information for Data Warehouses
ER '98 Proceedings of the 17th International Conference on Conceptual Modeling
Extending the E/R Model for the Multidimensional Paradigm
ER '98 Proceedings of the Workshops on Data Warehousing and Data Mining: Advances in Database Technologies
Using AutoMed metadata in data warehousing environments
DOLAP '03 Proceedings of the 6th ACM international workshop on Data warehousing and OLAP
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
Mapping conceptual to logical models for ETL processes
Proceedings of the 8th ACM international workshop on Data warehousing and OLAP
Research in data warehouse modeling and design: dead or alive?
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
Designing ETL processes using semantic web technologies
DOLAP '06 Proceedings of the 9th ACM international workshop on Data warehousing and OLAP
An adaptive approach to schema classification for data warehouse modeling
Journal of Computer Science and Technology
A method for the mapping of conceptual designs to logical blueprints for ETL processes
Decision Support Systems
An MDA approach for the development of data warehouses
Decision Support Systems
UML-Based Modeling for What-If Analysis
DaWaK '08 Proceedings of the 10th international conference on Data Warehousing and Knowledge Discovery
Towards generating ETL processes for incremental loading
IDEAS '08 Proceedings of the 2008 international symposium on Database engineering & applications
Natural language reporting for ETL processes
Proceedings of the ACM 11th international workshop on Data warehousing and OLAP
Domain Knowledge Integration and Semantical Quality Management ---A Biology Case Study---
ER '08 Proceedings of the ER 2008 Workshops (CMLSA, ECDM, FP-UML, M2AS, RIGiM, SeCoGIS, WISM) on Advances in Conceptual Modeling: Challenges and Opportunities
Data integration flows for business intelligence
Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Modeling of secure data extraction in ETL processes using UML 2.0
AsiaMS '07 Proceedings of the IASTED Asian Conference on Modelling and Simulation
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Automatic generation of ETL processes from conceptual models
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Defining ETL worfklows using BPMN and BPEL
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
Cardinality estimation in ETL processes
Proceedings of the ACM twelfth international workshop on Data warehousing and OLAP
A case study on model driven data integration for data centric software development
Proceedings of the ACM first international workshop on Data-intensive software management and mining
Measures for ETL processes models in data warehouses
Proceedings of the first international workshop on Model driven service engineering and data quality and security
Representation of conceptual ETL designs in natural language using Semantic Web technology
Data & Knowledge Engineering
A generic and customizable framework for the design of ETL scenarios
Information Systems - Special issue: The 15th international conference on advanced information systems engineering (CAiSE 2003)
State driven semantic modeling of operators in ETL workflow
Journal of Computing Sciences in Colleges
A framework for the design of ETL scenarios
CAiSE'03 Proceedings of the 15th international conference on Advanced information systems engineering
Callisto: mergers without pain
BIRTE'06 Proceedings of the 1st international conference on Business intelligence for the real-time enterprises
ETL workflows: from formal specification to optimization
ADBIS'07 Proceedings of the 11th East European conference on Advances in databases and information systems
Information and Software Technology
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
MapMerge: correlating independent schema mappings
Proceedings of the VLDB Endowment
Leveraging business process models for ETL design
ER'10 Proceedings of the 29th international conference on Conceptual modeling
XML based framework for ETL processes for relational databases
ACOS'06 Proceedings of the 5th WSEAS international conference on Applied computer science
Data warehouse development with EPC
DNCOCO'06 Proceedings of the 5th WSEAS international conference on Data networks, communications and computers
Data cracker: developing a visual game analytic tool for analyzing online gameplay
Proceedings of the SIGCHI Conference on Human Factors in Computing Systems
GEM: requirement-driven generation of ETL and multidimensional conceptual designs
DaWaK'11 Proceedings of the 13th international conference on Data warehousing and knowledge discovery
Provenance-based refresh in data-oriented workflows
Proceedings of the 20th ACM international conference on Information and knowledge management
A model-driven framework for ETL process development
Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
E-ETL: framework for managing evolving etl processes
Proceedings of the 4th workshop on Workshop for Ph.D. students in information & knowledge management
Improving the web usage analysis process: a UML model of the ETL process
WebKDD'04 Proceedings of the 6th international conference on Knowledge Discovery on the Web: advances in Web Mining and Web Usage Analysis
Towards multidimensional requirement design
DaWaK'06 Proceedings of the 8th international conference on Data Warehousing and Knowledge Discovery
Graph-based modeling of ETL activities with multi-level transformations and updates
DaWaK'05 Proceedings of the 7th international conference on Data Warehousing and Knowledge Discovery
Blueprints and measures for ETL workflows
ER'05 Proceedings of the 24th international conference on Conceptual Modeling
Ontology-Driven conceptual design of ETL processes using graph transformations
Journal on Data Semantics XIII
Geo-Enabling spatially relevant data for mobile information use and visualisation
W2GIS'05 Proceedings of the 5th international conference on Web and Wireless Geographical Information Systems
International Journal of Intelligent Information and Database Systems
ACM SIGSOFT Software Engineering Notes
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
Integrating ETL processes from information requirements
DaWaK'12 Proceedings of the 14th international conference on Data Warehousing and Knowledge Discovery
Exploring data integration strategies for public sector cloud solutions
EGOVIS'12/EDEM'12 Proceedings of the 2012 Joint international conference on Electronic Government and the Information Systems Perspective and Electronic Democracy, and Proceedings of the 2012 Joint international conference on Advancing Democracy, Government and Governance
Towards better cross-cloud data integration: using p2p and ETL together
WISM'12 Proceedings of the 2012 international conference on Web Information Systems and Mining
| Hi-index | 0.00 |
Extraction-Transformation-Loading (ETL) tools are pieces of software responsible for the extraction of data from several sources, their cleansing, customization and insertion into a data warehouse. In this paper, we focus on the problem of the definition of ETL activities and provide formal foundations for their conceptual representation. The proposed conceptual model is (a) customized for the tracing of inter-attribute relationships and the respective ETL activities in the early stages of a data warehouse project; (b) enriched with a 'palette' of a set of frequently used ETL activities, like the assignment of surrogate keys, the check for null values, etc; and (c) constructed in a customizable and extensible manner, so that the designer can enrich it with his own re-occurring patterns for ETL activities.