Database Reference
In-Depth Information
al. 2004), embracing the supply-driven philoso-
phy, propose two approaches for automatically
deriving the conceptual multidimensional schema
from the relational data sources. On the contrary
the CASE tool proposed in (Trujillo, 2002) fol-
lows the demand-driven approach and allows
the multidimensional conceptual schemata to be
drawn from scratch and to be semi-automatically
translated into the target cubes.
Agrawal, R., Gupta, A., & Sarawagi, S. (1997).
Modeling multidimensional databases. In
Pro-
ceedings of the International Conference on Data
Engineering
, Birmingham U.K. (pp. 232-243).
Basili, V. R., Caldiera, G., & Rombaci, H. D.
(1994). The goal question metric approach. In
Encyclopedia of software engineering
(pp. 528-
532). New York: John Wiley & Sons, Inc.
Boehnlein, M., & Ulbrich vom Ende, A. (2000).
Business process oriented development of data
warehouse structures. In
Proceedings of Data
Warehousing 2000
. Heidelberg, Germany: Physica
Verlag.
CONCLUSION
In this paper we have surveyed the state of the art
of the literature related to the first steps of data
mart design, namely user requirement analysis and
conceptual design. The approaches to requirement
analysis have been surveyed and their strengths and
weaknesses have been discussed in order to enable
the designer to choose the more appropriates for
a given project. Similarly, the main conceptual
models for DWs have been reported and their
basic concepts have been discussed using DFM
as a representative.
From our analysis it emerges that although it
is evident that the two design steps are strictly
related, no comprehensive approach has been
devised yet. On the other hand, the research com-
munity seems to share some common ideas: the
core expressivity of the conceptual models for
DW is shared by most of the models discussed
regardless of the formalism adopted; furthermore,
as for user requirement analysis, several authors
chose a mixed method coupling a goal-driven step
with a supply-driven one.
Bonifati, A., Cattaneo, F., Ceri, S., Fuggetta, A.,
& Paraboschi, S. (2001). Designing data marts for
data warehouses.
ACM Transactions on Software
Engineering and Methodology
,
10
(4), 452-483.
doi:10.1145/384189.384190
Bresciani, P., Giorgini, P., Giunchiglia, F., My-
lopoulos, J., & Perini, A. (2004). Tropos: An
agent-oriented software development methodol-
ogy.
Journal of Autonomous Agents and Multi-
Agent Systems
,
8
(3), 203-236. doi:10.1023/
B:AGNT.0000018806.20944.ef
Cabibbo, L., & Torlone, R. (1998). A logical
approach to multidimensional databases. In
Proceedings of the International Conference on
Extending Database Technology
, Valencia, Spain
(pp. 183-197).
Chung, L., Nixon, B. A., Yu, E., & Mylopoulos, J.
(1999).
Non-functional requirements in software
.
Berlin, Germany: Springer.
Cohen, P., & Levesque, H. (1990). Intention
is choice with commitment.
Artificial Intel-
ligence
,
42
(2-3), 213-261. doi:10.1016/0004-
3702(90)90055-5
REFERENCES
Abello, A., Samos, J., & Saltor, F. (2006). YAM
2
:
A multidimensional conceptual model extending
UML.
Information Systems
,
31
(6), 541-567.
doi:10.1016/j.is.2004.12.002
Search WWH ::
Custom Search