The DOI matches its Crossref record; 22 of the 22 references it cites were found in a registry or an index.
Conceptual modeling for ETL processes
Open accessAbstract
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.
Overview
The claims and statistics of this paper haven’t been checked yet.
Free: it reads the open-access text and checks the first 5 claims that cite a source we can check. Create a free account to check every claim.
Integrity signals
Registry
Cites
Statistics
Verification
Claims the paper makes
The claims and statistics of this paper haven’t been checked yet.
Free: it reads the open-access text and checks the first 5 claims that cite a source we can check. Create a free account to check every claim.
Self-check
Percentages, sums and reported differences re-computed from the paper’s own numbers.
The self-check needs the paper’s full text.
Citations
Cites
The Unified Modeling Language User Guide
Booch, G., Rumbaugh, J. E., & Jacobson, I. (1999) · University of Maribor digital library (University of Maribor) · Cited by 5,660
The unified Modeling Language User Guide
Glasson, G. (1999) · Linux journal · doi:10.5555/327966.328423 · Cited by 3,333
(2000) · Cited by 1,467
Schader, M., & Korthaus, A. (1998) · Physica-Verlag eBooks · doi:10.1007/978-3-642-48673-9 · Cited by 811
Potter's Wheel: An Interactive Data Cleaning System
Raman, V., & Hellerstein, J. L. (2001) · Cited by 492
THE DIMENSIONAL FACT MODEL: A CONCEPTUAL MODEL FOR DATA WAREHOUSES
Golfarelli, M., Maio, D., & Rizzi, S. (1998) · International Journal of Cooperative Information Systems · doi:10.1142/s0218843098000118 · Cited by 478
Fundamentals of Data Warehouses
Jarke, M., Lenzerini, M., Vassiliou, Y., & Vassiliadis, P. (2003) · Springer eBooks · doi:10.1007/978-3-662-05153-5 · Cited by 449
Self-citationKimball, R. (1998) · Cited by 341
Automatically Extracting Structure from Free Text Addresses.
Borkar, V., Deshmukh, K., & Sarawagi, S. (2000) · Cited by 313
starER: a conceptual model for data warehouse design
Tryfona, N., Busborg, F., & Borch Christiansen, J. G. (1999) · Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP · doi:10.1145/319757.319776 · Cited by 222
A methodological framework for data warehouse design
Golfarelli, M., & Rizzi, S. (1998) · ACM International Workshop on Data Warehousing and OLAP (DOLAP) · doi:10.1145/294260.294261 · Cited by 206
AJAX: an extensible data cleaning tool
Galhardas, H., Florescu, D., Shasha, D., & Simon, E. (2000) · ACM SIGMOD Record · doi:10.1145/335191.336568 · Cited by 174
Enterprise information portals
White, M. (2000) · The Electronic Library · doi:10.1108/02640470010354617 · Cited by 160
Information integration: conceptual modeling and reasoning support
Calvanese, D., Giacomo, G. D., Maurizio Lenzerini, B., Nardi, D., & Rosati, R. (1998) · Cooperative Information Systems · doi:10.1109/coopis.1998.706234 · Cited by 143
Design and Analysis of Quality Information for Data Warehouses
Jeusfeld, M. A., Quix, C., & Jarke, M. (1998) · Lecture notes in computer science · doi:10.1007/978-3-540-49524-6_28 · Cited by 120
Matching Algorithms within a Duplicate Detection System.
Monge, A. E. (2000) · IEEE Data(base) Engineering Bulletin · Cited by 101
Arktos: towards the modeling, design, control and execution of ETL processes
Vassiliadis, P., Vagena, Z., Skiadopoulos, S., Karayannidis, N., & Sellis, T. (2001) · Information Systems · doi:10.1016/s0306-4379(01)00039-4 · Cited by 90
Self-citationModeling the Data Warehouse Refreshment Process as a Workflow Application.
Bouzeghoub, M., Fabret, F., & Matulovic, M. (1999) · Cited by 73
Data warehouse process management
Vassiliadis, P., Quix, C., Vassiliou, Y., & Jarke, M. (2001) · Information Systems · doi:10.1016/s0306-4379(01)00018-7 · Cited by 67
Self-citationModeling ETL activities as graphs.
Vassiliadis, P., Simitsis, A., & Skiadopoulos, S. (2002) · Cited by 61
Self-citationEfficient resumption of interrupted warehouse loads
Labio, W. J., Wiener, J. L., García-Molina, H., & Gorelik, V. (2000) · ACM SIGMOD Record · doi:10.1145/335191.335379 · Cited by 59
A dimensional modeling manifesto
Kimball, R. (1997) · Cited by 56
Cited by
A Survey of Extract-Transform-Load Technology
Vassiliadis, P. (2009) · International Journal of Data Warehousing and Mining · doi:10.4018/jdwm.2009070101 · Cited by 323
Self-citationA UML Based Approach for Modeling ETL Processes in Data Warehouses
Trujillo, J., & Luján-Mora, S. (2003) · Lecture Notes in Computer Science · doi:10.1007/978-3-540-39648-2_25 · Cited by 217
Metadata
- Authors
- Vassiliadis, P., Simitsis, A., & Skiadopoulos, S.
- Venue
- Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP
- Publisher
- ACM
- Published
- 2002-11-08
- Pages
- 14-21
- OpenAlex
- W1971518725
- Cited by
- 380
- References
- 22
- FWCI
- 12.14
- Type
- conference paper
- Language
- en
- Open access
- green
About these checks
Registry, retraction, Cites and statistics results are computed, not judged, with one exception: a printed reference that no index lists is read once by a model before it counts as a citation error. Claims are extracted by a model and kept only when their quote appears verbatim in the text; each cited source is then checked, with a model’s help, for whether it says what the claim relies on. Those verdicts can be wrong — read the claim’s quote and the cited source before relying on one.
Statistics and arithmetic are recomputed, not judged.
Confidence bands are shown only for fields calibrated on our annotated test set. None is calibrated yet, so no band is shown.
What counts as a claim ›How we measure confidence ›How we check this ›
Are you an author, or do you see a problem with this page? Request a review
Data sources
Bibliographic data: Semantic Scholar, OpenAlex, Crossref.
Contains information from the Semantic Scholar Academic Graph Datasets, made available under the ODC Attribution License (ODC-BY 1.0).
Semantic Scholar’s data is described in: Kinney, R., et al. (2023). The Semantic Scholar Open Data Platform. arXiv:2301.10140.