Concept based design of data warehouses

Jarke, Matthias; Quix, Christoph; Calvanese, Diego; Lenzerini, Maurizio; Franconi, Enrico; Ligoudistianos, Spyros; Vassiliadis, Panos; Vassiliou, Yannis

doi:10.1145/335191.336570

Cited by 6 publications

(4 citation statements)

References 2 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…But overall the topic is not widely pursued. For instance, if one checks the last 10 years of the "major"database conferences (SIGMOD, VLDB, ICDE), the number of papers in database design is low: leaving aside physical design (that is, the fine tuning of storage structures for better performance), we found less than ten talks mainly about database design [4,9,26,34,41,42,58,62] and most of them examine design issues within the confines of a restricted context (sensor databases [41,42], XML schema evolution [9], user interaction [62], scientific databases [58], data warehousing [34]). 7 There 7 We do not claim any statistical validity for this observation.…”

Section: What Now?mentioning

confidence: 99%

A Call to Arms: Revisiting Database Design

Badia,

Lemire

2011

Preprint

View full text Add to dashboard Cite

Section: What Now?mentioning

confidence: 99%

A Call to Arms: Revisiting Database Design

Badia,

Lemire

2011

Preprint

View full text Add to dashboard Cite

“…TAMBIS [1] is an example of a system that supplies access to distributed information sources on the net (giving its yaxis position), using a description logic model. The DWQ (Data Warehousing Quality) project [25] has also used a description logic to approach the problems of improving database schema integration. The Distributed Link Service (DLS) uses keywords as anchors when adding links to documents.…”

Section: A Space Of Metadata Approachesmentioning

confidence: 99%

Conceptual linking

Carr

Hall

Bechhofer

et al. 2001

Proceedings of the 10th International Conference on World Wide Web

View full text Add to dashboard Cite

This paper describes the attempts of the COHSE project to define and deploy a Conceptual Open Hypermedia Service. Consisting of• an ontological reasoning service which is used to represent a sophisticated conceptual model of document terms and their relationships; • a Web-based open hypermedia link service that can offer a range of different link-providing facilities in a scalable and non-intrusive fashion;and integrated to form a conceptual hypermedia system to enable documents to be linked via metadata describing their contents and hence to improve the consistency and breadth of linking of WWW documents at retrieval time (as readers browse the documents) and authoring time (as authors create the documents).

show abstract

“…28 In our approach we introduce an explicit logical layer, which allows analysts to view and manipulate multidimensional data independently of the data warehouse organization and structure. The addition of a logical level to achieve data independence has been advocated also within the DWQ project, 19,20 where a conceptual level is also introduced, and by other authors. 14,29 The MD data model illustrated in this paper has been used in other works as a basis to the investigation of several issues related to multidimensional database analysis.…”

Section: Related Workmentioning

confidence: 99%

An Architecture for Data Warehousing Supporting Data Independence and Interoperability

Cabibbo

Torlone

2001

Int. J. Coop. Info. Syst.

View full text Add to dashboard Cite

We report on the design of a novel architecture for data warehousing based on the introduction of an explicit "logical" layer to the traditional data warehousing framework. This layer serves to guarantee a complete independence of OLAP applications from the physical storage structure of the data warehouse and thus allows users and applications to manipulate multidimensional data ignoring implementation details. For example, it makes possible the modification of the data warehouse organization (e.g. MOLAP or ROLAP implementation, star scheme or snowflake scheme structure) without influencing the high level description of multidimensional data and programs that use the data. Also, it supports the integration of multidimensional data stored in heterogeneous OLAP servers. We propose [Formula: see text], a simple data model for multidimensional databases, as the reference for the logical layer. [Formula: see text] provides an abstract formalism to describe the basic concepts that can be found in any OLAP system (fact, dimension, level of aggregation, and measure). We show that [Formula: see text] databases can be implemented in both relational and multidimensional storage systems. We also show that [Formula: see text] can be profitably used in OLAP applications as front-end. We finally describe the design of a practical system that supports the above logical architecture; this system is used to show in practice how the architecture we propose can hide implementation details and provides a support for interoperability between different and possibly heterogeneous data warehouse applications.

show abstract

Concept based design of data warehouses

Cited by 6 publications

References 2 publications

A Call to Arms: Revisiting Database Design

A Call to Arms: Revisiting Database Design

Conceptual linking

An Architecture for Data Warehousing Supporting Data Independence and Interoperability

Contact Info

Product

Resources

About