A novel three-level architecture for large data warehouses

Classical architectures proposed so far for data warehouses show some drawbacks when adopted to work over large numbers of heterogeneous operational sources. In this paper we propose a variant of a three-level architecture for data warehouses that overcomes these drawbacks. However, in the applicati...

Full description

Saved in:
Bibliographic Details
Published in:Journal of systems architecture 2002-05, Vol.47 (11), p.937-958
Main Authors: Palopoli, L., Pontieri, L., Terracina, G., Ursino, D.
Format: Article
Language:English
Subjects:
Applied sciences
Computer architecture
Computer science
control theory
systems
Computer systems
Data processing. List processing. Character string processing
Data warehouses
Electronics
Exact sciences and technology
Hardware
Interscheme property derivation
Memory organisation. Data processing
Methods
Scheme abstraction
Scheme integration
Semantics
Semi-automatic and semantic methodologies
Software
Studies
Systems integration
Citations: Items that this one cites
Items that cite this one
Online Access:Get full text
Tags: Add Tag
No Tags, Be the first to tag this record!
Description
Summary:Classical architectures proposed so far for data warehouses show some drawbacks when adopted to work over large numbers of heterogeneous operational sources. In this paper we propose a variant of a three-level architecture for data warehouses that overcomes these drawbacks. However, in the application context under consideration, having a suitable architecture may be not enough for the design purposes. Indeed, data warehouse design in very large operational environments can be a quite hard problem to attack with traditional manual methodologies. In this paper, automatic techniques are also illustrated that are capable to produce the data warehouse design according to the proposed architecture, with a limited human intervention.
ISSN:1383-7621
1873-6165
DOI:10.1016/S1383-7621(02)00056-5