This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
XX International Conference of the Chilean Computer Science Society (SCCC'00)
Evolving a Legacy Data Warehouse System to an Object-Oriented Architecture
Santiago, Chile
November 16-November 18
ISBN: 0-7695-0810-3
A.H. Filho, Inf. Inst., Fed. Univ. of Rio Grande do Sul, Porto Alegre, Brazil
H.A. Prado, Inf. Inst., Fed. Univ. of Rio Grande do Sul, Porto Alegre, Brazil
S.S. Toscani, Inf. Inst., Fed. Univ. of Rio Grande do Sul, Porto Alegre, Brazil
We introduce an object-oriented approach to transform a star-schema of a legacy data warehouse system into a Dimensional Object Model (DOM) (Firestone, 2000), in order to take advantage of the flexibility of the object paradigm. We have applied the Object-Oriented Software Engineering (OOSE) process, proposed by (Jacobson et al., 1992), to describe the life cycle of a data warehouse and to clarify the context of our intervention. By means of OOSE we also define the target architecture and the components that will ensure the development of reuse-supporting data warehouse systems. In a sense, a change tolerant architecture is proposed, as referred to by (Jacobson, 2000). The solution proposed applies the object paradigm for the star-schema decomposition in a three-layer architecture, separating the components in logical, interface and data management layers. This decomposition minimizes the dependence among the components and increases their reusability. The main contribution of this work is that, by transforming the star-schema into a DOM, we are preparing the system to evolve through any object-oriented data warehouse development methodology. In a context of many already existing data warehouse systems based on relational models, this transformation sounds especially interesting.
Index Terms:
data warehouses; object-oriented databases; object-oriented programming; software reusability; software architecture; legacy data warehouse evolution; object-oriented database; Dimensional Object Model; DOM; Object-Oriented Software Engineering; life cycle; change tolerant architecture; star-schema decomposition; three-layer architecture; data management; relational models
Citation:
A.H. Filho, H.A. Prado, S.S. Toscani, "Evolving a Legacy Data Warehouse System to an Object-Oriented Architecture," sccc, pp.32, XX International Conference of the Chilean Computer Science Society (SCCC'00), 2000
Usage of this product signifies your acceptance of the Terms of Use.