Data Processing Modeling in Decision Support Systems

Concepción M. Gascueña, Rafael Guadalupe


Due to the advancement of both, information technology in general, and databases in particular; data storage devices are becoming cheaper and data processing speed is increasing. As result of this, organizations tend to store large volumes of data holding great potential information. Decision Support Systems, DSS try to use the stored data to obtain valuable information for organizations. In this paper, we use both data models and use cases to represent the functionality of data processing in DSS following Software Engineering processes. We propose a methodology to develop DSS in the Analysis phase, respective of data processing modeling. We have used, as a starting point, a data model adapted to the semantics involved in multidimensional databases or data warehouses, DW. Also, we have taken an algorithm that provides us with all the possible ways to automatically cross check multidimensional model data. Using the aforementioned, we propose diagrams and descriptions of use cases, which can be considered as patterns representing the DSS functionality, in regard to DW data processing, DW on which DSS are based. We highlight the reusability and automation benefits that this can be achieved, and we think this study can serve as a guide in the development of DSS.


  1. Bimonte S., Tchounikine A., Berloto M., 2008. Integration of Geographic Information into Multidimensional Models. ICCSA 2008: International, 2008.
  2. Gascueña C. M., Cuadra D., Martínez P., 2006. A Multidimensional Approach to the Representation of the Spatiotemporal Multigranularity. ICEIS 2006.
  3. Gascueña C. M., Guadalupe R., 2008a. Some Types of Spatio-Temporal Granularities in a Conceptual Multidimensional Model. 7th International Conference, APLIMAT Bratislava, Slovak.
  4. Gascueña C. 2008b. Propousal of a Conceptual Model for the Representation of Spatio Temporal Multigranularity in Multidimensional Databases. PhD Thesis. Polytechic University of Madrid, Spain.
  5. Gascueña C. M., Guadalupe R., 2008c. A Study of the Spatial Representation in Multidimensional Models, ICEIS 2008.
  6. Guttorm Sindre, E Andreas L. Opdahl, 2005. Eliciting security requirements with misuse cases, in the Journal of Requirements Eng, Issue 10, pp 34-44.
  7. Inmon, W. 2002. Building The Data Warehouse. Jhon Wiley & Sons.
  8. Kantorowitz E., Lyakas A., Myasqobsky A.. 2003. A Use Case-Oriented User Interface Framework. Software. SwSTE 7803. IEEE International Conference on.
  9. Kimball R. 1996. The Data Warehouse Toolkit. John Wiley&Sons Ed.
  10. Luján-Mora S., Trujillo J., Song Il- Yeol. 2006. A UML profile for multidimensional modeling in data warehouses. DKE, 59(3), p. 725-769.
  11. Malinowski, E. and Zimanyi, E., 2004. Representing Spatiality in a Conceptual Multidimensional Model. Proc. of the 12th annual ACM international workshop on GIS. Washington, DC, USA.
  12. Malinowski E., Zimanyi E., 2005. Spatial Hierarchies and Topological Relationships in the Spatial MultiDimER model. Lecture Notes in Computer Science, page 17, Volume 356.
  13. Mazón J. N., Pardillo J., Meliá S. y Trujillo J., 2006. Modelado Multidimensional de almacenes de datos con MDA. XI JISBD 2006.
  14. Parent C., Spaccapietra S., Zimanyi E., 2006. The MurMur project: Modeling and querying multirepresentation spatio-temporal databases. Information Systems, Volume 31, Issue 8, Pages 733-769.
  15. Torlone R., 2003. Conceptual Multidimensional Models. In Multidimensional databases: problems and solutions, pages 69-90, Idea Group Publishing, Hershey, PA, USA.
  16. Tryfona, N., Price, R., Jensen, C. S., 2003. Conceptual Models for Spatio-temporal Applications. In M. Koubarakis et al. (Eds.), Spatio-Temporal DB: The CHOROCHRONOS pg. 79-11. Berlin, Heidelberg.

Paper Citation

in Harvard Style

M. Gascueña C. and Guadalupe R. (2012). Data Processing Modeling in Decision Support Systems . In Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 978-989-8565-10-5, pages 133-138. DOI: 10.5220/0003982601330138

in Bibtex Style

author={Concepción M. Gascueña and Rafael Guadalupe},
title={Data Processing Modeling in Decision Support Systems},
booktitle={Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS,},

in EndNote Style

JO - Proceedings of the 14th International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - Data Processing Modeling in Decision Support Systems
SN - 978-989-8565-10-5
AU - M. Gascueña C.
AU - Guadalupe R.
PY - 2012
SP - 133
EP - 138
DO - 10.5220/0003982601330138