access icon free CIM for data warehouse requirements using an UML profile

Different modelling approaches have been proposed to automate the process of design and development of data warehouse. Some of them use the model driven architecture, however they are more focused on designing platform independent model (PIM) and platform specific model (PSM) and reserved unfortunately few efforts for requirements modelling and design computational independent model (CIM). This situation can be explained essentially by the presence of mature technologies and methods used for the representation of PIM and PSM models. Moreover, there are no standards to build CIM. Within this context, data warehousing projects fail due to not much attention paid on the requirement analysis phase. To overcome this problem, this study provides an approach to build a CIM architecture for modelling data warehouse requirements using an unified modelling language (UML) profile that extends the use cases and business process models, and proposes requirements specifications using SBVR structured English.

Inspec keywords: formal specification; data warehouses; Unified Modeling Language; business data processing

Other keywords: SBVR; use cases; computational independent model; requirement analysis phase; business process models; Unified Modelling Language profile; platform specific model; platform independent model; UML profile; CIM architecture; PIM model; PSM model; data warehouse

Subjects: Other DBMS; Formal methods

References

    1. 1)
      • 17. Matéa, A., Trujillo, J., Franch, X.: ‘Adding semantic modules to improve goal-oriented analysis of data warehouses using I-star’, The J. Syst. Softw., 2014, 88, pp. 102111.
    2. 2)
      • 29. Caputo, E., Corallo, A., Damiani, E., et al: ‘KPI modeling in MDA perspective’. Proc. On the Move to Meaningful Internet Systems: OTM Workshops, 2010 (LNCS6428), pp. 384393.
    3. 3)
      • 30. Object Management Group (OMG): ‘Business Process Model and Notation Specifications (v2.0.2)’ (OMG, 2013).
    4. 4)
      • 2. Ramsin, R., Paige, R.F.: ‘Iterative criteria-based approach to engineering the requirements of software development methodologies’, IET Softw., 2010, 4, (2), pp. 91104.
    5. 5)
      • 12. De Castro, V., Marcos, E., Vara, J.M.: ‘Applying CIM-to-PIM model transformations for the service-oriented development of information systems’, Inf. Softw. Technol., 2011, 53, (1), pp. 87105.
    6. 6)
      • 21. Stefanov, V., List, B.: ‘Business metadata for the datawarehouse - weaving enterprise goals and multidimensional models’. Proc. 10th IEEE Int EDOC Workshops, Hong Kong, 2006, pp. 5361.
    7. 7)
      • 27. Browne, J., Devlin, J., Rolstadas, A., et al: ‘Performance measurement: the ENAPS approach’, Int. J. Bus. Transf., 1997, 1, pp. 7384..
    8. 8)
      • 25. Object Management Group (OMG): ‘UML profile for MARTE, modeling and analysis of real-time embedded systems (v1.1)’ (OMG, 2011).
    9. 9)
      • 16. Manaa, M., Akaichi, J.: ‘Unifying mobility data warehouse models using UML Profile’. Proc. 10th Int. Conf. BDAS, Ustroń, Poland, May 2014, pp. 8291.
    10. 10)
      • 31. Lunenburg, F.C.: ‘Goal-Setting Theory of Motivation’, Int. J. Manage. Bus. Admin., 2011, 15, (1), pp. 16.
    11. 11)
      • 33. Object Management Group (OMG): ‘Semantics of Business Vocabulary and Business Rules Specifications (v1.3)’ (OMG, 2015).
    12. 12)
      • 35. ITU-T. Recommendation Z.151 (10/12): User Requirements Notation (URN) - Language Definition’. Available at http://www.itu.int/rec/T-REC-Z.151-201210-I/en, accessed 09 January 2017.
    13. 13)
      • 4. Garrigós, I., Mazón, J.N., Koch, N., et al: ‘Editorial: web and requirements engineering’, IET Softw., 2012, 6, (2), pp. 8384.
    14. 14)
      • 1. Inmon, W.H.: ‘Building the data warehouse’ (John Wiley & Sons, 2005, 5th edn.), pp. 18.
    15. 15)
      • 11. Touzi, J., Benaben, F., Pingaud, H., et al: ‘A model-driven approach for collaborative service-oriented architecture design’, Int. J. Prod. Econ., 2010, 121, (1), pp. 520.
    16. 16)
      • 28. Serrano, M., Calero, C., Piattini, M.: ‘Validating metrics for data warehouses’, IET Softw., 2002, 149, (5), pp. 161166.
    17. 17)
      • 23. El Beggar, O., Bousetta, B., GADI, T.: ‘Automatic code generation by model transformation from sequence diagram of system's internal behavior’, Int. J. Comput. Inf. Technol.(IJCIT), 2012, 1, (2), pp. 130146.
    18. 18)
      • 24. Object Management Group (OMG): ‘Meta Object Facility (MOF) 2.0 Core, final adopted specification (v2.0)’ (OMG, 2006).
    19. 19)
      • 19. Zepeda, L., Celma, M., Zatarain, R.: ‘A mixed approach for data warehouse conceptual design with MDA’. Proc. ICCSA, Perugia, Italy, 2008, (LNCS), pp. 12041217.
    20. 20)
      • 14. Mazón, J.N., Trujillo, J.: ‘A hybrid model driven development framework for the multidimensional modeling of data warehouses’, ACM SIGMOD Rec., 2009, 38, (2), pp. 1217.
    21. 21)
      • 36. Amyot, D., Horkoff, J., Gross, D., et al: ‘A Lightweight GRL Profile for i* Modeling’. Proc. 3rd Int Workshop on Requirements, Intentions and Goals in Conceptual modeling’, 2009 (LNCS5833), pp. 254264.
    22. 22)
      • 3. Giorgini, P., Rizzi, S., Garzetti, M.: ‘GRAnD: A goal-oriented approach to requirement analysis in data warehouses’, Decis. Support Syst., 2008, 45, pp. 421.
    23. 23)
      • 10. Khouri, S., Boukhari, I., Bellatreche, L., et al: ‘Ontology-based structured web data warehouses for sustainable interoperability: requirement modeling, design methodology and tool’, Comput. Ind., 2012, 63, (8), pp. 799812.
    24. 24)
      • 7. Mazón, J.N., Trujillo, J., Serrano, M., et al: ‘Designing data warehouses: from business requirement analysis to multidimensional modeling’. Proc. Int. Workshop on Requirements Engineering for Business Need and IT Alignment, Paris, France, August 2005, pp. 4453.
    25. 25)
      • 15. Leal, A.C., Mazón, J.N., Trujillo, J.: ‘A business-oriented approach to data warehouse development’, Ingeniería e Investigación, 2013, 33, (1), pp. 5965.
    26. 26)
      • 18. Prakash, N., Gosain, A.: ‘An approach to engineering the requirements of data warehouses’, Requir. Eng., 2008, 13, (1), pp. 4972.
    27. 27)
      • 34. Amyot, D., Ghanavati, S., Horkoff, J., et al: ‘Evaluating goal models within the goal-oriented requirement language’, Int. Journal of Intelligent Systems, 2010, 25, (8), pp. 841877.
    28. 28)
      • 5. Yu, E.S.K.: ‘Towards modeling and reasoning support for early-phase requirements engineering’. Proc. 3rd Int. Symp. on Requirements Engineering, Annapolis, Maryland, USA, January 1997, pp. 226235.
    29. 29)
      • 32. Asmus, S., Karl, F., Mohnen, A., et al: ‘The impact of goal-setting on worker performance - empirical evidence from a real-effort production experiment’, Procedia CIRP, 2015, 26, pp. 127132.
    30. 30)
      • 8. Zonghua, L., Xiaofeng, Z., Aihua, G., et al: ‘A complete approach for CIM modelling and model formalising’, Inf. Softw. Technol., 2015, 65, (C), pp. 3955..
    31. 31)
      • 22. Debasish, K., Debasis, S., Rajib, M.: ‘Automatic code generation from unified modelling language sequence diagrams’, IET Softw., 2013, 7, (1), pp. 1228.
    32. 32)
      • 37. Pourshahid, A., Amyot, D., Peyton, L., et al: ‘Toward an integrated user requirements notation framework and tool for business process management’. Proc. Int. MCETECH Conf. on e-Technologies, IEEE, 2008, pp. 315.
    33. 33)
      • 26. Object Management Group (OMG): ‘Business Motivation Model Specifications (v1.3)’ (OMG, 2015).
    34. 34)
      • 20. Zepeda, L., Ceceña, E., Quintero, R., et al: ‘A MDA tool for data warehouse’. Proc. Int Conf. of Computational Science and Its Applications, Fukuoka, Japan, 2010, pp. 261265.
    35. 35)
      • 6. Object Management Group (OMG): ‘Decision model and notation specifications (v1.0)’ (OMG, 2015).
    36. 36)
      • 9. Bousetta, B., El Beggar, O., GADI, T.: ‘A methodology for CIM modelling and its transformation to PIM’, J. Inf. Eng. Appl., 2013, 3, (2), pp. 121.
    37. 37)
      • 13. Mazón, J.N., Trujillo, J.: ‘An MDA approach for the development of data warehouses’, Decis. Support Syst., 2008, 45, (1), pp. 4158.
http://iet.metastore.ingenta.com/content/journals/10.1049/iet-sen.2016.0245
Loading

Related content

content/journals/10.1049/iet-sen.2016.0245
pub_keyword,iet_inspecKeyword,pub_concept
6
6
Loading