The DOI matches its Crossref record; 1 of the 1 references it cites were found in a registry or an index.
starER: a conceptual model for data warehouse design
Abstract
Modeling data warehouses is a complex task focusing, very often, into internal structures and implementation issues. In this paper we argue that, in order to accurately reflect the users requirements into an error-free, understandable, and easily extendable data warehouse schema, special attention should be paid at the conceptual modeling phase. Based on a real mortgage business warehouse environment, we present a set of user modeling requirements and we discuss the involved concepts. Understanding the semantics of these concepts, allow us to build a conceptual model—namely, the starER model—for their efficient handling. More specifically, the starER model combines the star structure, which is dominant in data warehouses, with the semantically rich constructs of the ER model; special types of relationships have been further added to support hierarchies. We present an evaluation of the starER model as well as a comparison of the proposed model with other existing models, pointing out differences and similarities. Examples from a mortgage data warehouse environment, in which starER is tested, reveal the ease of understanding of the model, as well as the efficiency in representing complex information at the semantic level.
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 entity-relationship model—toward a unified view of data
Chen, P. P.-S. (1976) · ACM Transactions on Database Systems · doi:10.1145/320434.320440 · Cited by 4,708
Cited by
Conceptual modeling for ETL processes
Vassiliadis, P., Simitsis, A., & Skiadopoulos, S. (2002) · Proceedings of the 5th ACM international workshop on Data Warehousing and OLAP · doi:10.1145/583890.583893 · Cited by 380
Designing data warehouses with OO conceptual models
Trujillo, J., Palomar, M., Gomez, J., & Song, I.-Y. (2001) · Computer · doi:10.1109/2.970579 · Cited by 279
A 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
- Tryfona, N., Busborg, F., & Borch Christiansen, J. G.
- Venue
- Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP
- Publisher
- ACM
- Published
- 1999-11-06
- Pages
- 3-8
- OpenAlex
- W2093154290
- Cited by
- 222
- References
- 1
- FWCI
- 14.86
- Type
- conference paper
- Language
- en
- Open access
- closed
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
How to cite
Cite CoChat for the checks on this page, and the paper for its own findings.
- This page
- CoChat. (2026). Citation check: starER: a conceptual model for data warehouse design. https://app.cochat.ai/papers/10.1145/319757.319776
- The paper
- Tryfona, N., Busborg, F., & Borch Christiansen, J. G. (1999). starER: a conceptual model for data warehouse design. Proceedings of the 2nd ACM international workshop on Data warehousing and OLAP. https://doi.org/10.1145/319757.319776
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.