http://iet.metastore.ingenta.com
1887

CIM for data warehouse requirements using an UML profile

CIM for data warehouse requirements using an UML profile

For access to this article, please select a purchase option:

Buy article PDF
$19.95
(plus tax if applicable)
Buy Knowledge Pack
10 articles for $120.00
(plus taxes if applicable)

IET members benefit from discounts to all IET publications and free access to E&T Magazine. If you are an IET member, log in to your account and the discounts will automatically be applied.

Learn more about IET membership 

Recommend Title Publication to library

You must fill out fields marked with: *

Librarian details
Name:*
Email:*
Your details
Name:*
Email:*
Department:*
Why are you recommending this title?
Select reason:
 
 
 
 
 
IET Software — Recommend this title to your library

Thank you

Your recommendation has been sent to your librarian.

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.

References

    1. 1)
      • 1. Inmon, W.H.: ‘Building the data warehouse’ (John Wiley & Sons, 2005, 5th edn.), pp. 18.
    2. 2)
      • 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.
    3. 3)
      • 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.
    4. 4)
      • 4. Garrigós, I., Mazón, J.N., Koch, N., et al: ‘Editorial: web and requirements engineering’, IET Softw., 2012, 6, (2), pp. 8384.
    5. 5)
      • 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.
    6. 6)
      • 6. Object Management Group (OMG): ‘Decision model and notation specifications (v1.0)’ (OMG, 2015).
    7. 7)
      • 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.
    8. 8)
      • 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..
    9. 9)
      • 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.
    10. 10)
      • 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.
    11. 11)
      • 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.
    12. 12)
      • 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.
    13. 13)
      • 13. Mazón, J.N., Trujillo, J.: ‘An MDA approach for the development of data warehouses’, Decis. Support Syst., 2008, 45, (1), pp. 4158.
    14. 14)
      • 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.
    15. 15)
      • 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.
    16. 16)
      • 16. Manaa, M., Akaichi, J.: ‘Unifying mobility data warehouse models using UML Profile’. Proc. 10th Int. Conf. BDAS, Ustroń, Poland, May 2014, pp. 8291.
    17. 17)
      • 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.
    18. 18)
      • 18. Prakash, N., Gosain, A.: ‘An approach to engineering the requirements of data warehouses’, Requir. Eng., 2008, 13, (1), pp. 4972.
    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)
      • 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.
    21. 21)
      • 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.
    22. 22)
      • 22. Debasish, K., Debasis, S., Rajib, M.: ‘Automatic code generation from unified modelling language sequence diagrams’, IET Softw., 2013, 7, (1), pp. 1228.
    23. 23)
      • 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.
    24. 24)
      • 24. Object Management Group (OMG): ‘Meta Object Facility (MOF) 2.0 Core, final adopted specification (v2.0)’ (OMG, 2006).
    25. 25)
      • 25. Object Management Group (OMG): ‘UML profile for MARTE, modeling and analysis of real-time embedded systems (v1.1)’ (OMG, 2011).
    26. 26)
      • 26. Object Management Group (OMG): ‘Business Motivation Model Specifications (v1.3)’ (OMG, 2015).
    27. 27)
      • 27. Browne, J., Devlin, J., Rolstadas, A., et al: ‘Performance measurement: the ENAPS approach’, Int. J. Bus. Transf., 1997, 1, pp. 7384..
    28. 28)
      • 28. Serrano, M., Calero, C., Piattini, M.: ‘Validating metrics for data warehouses’, IET Softw., 2002, 149, (5), pp. 161166.
    29. 29)
      • 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.
    30. 30)
      • 30. Object Management Group (OMG): ‘Business Process Model and Notation Specifications (v2.0.2)’ (OMG, 2013).
    31. 31)
      • 31. Lunenburg, F.C.: ‘Goal-Setting Theory of Motivation’, Int. J. Manage. Bus. Admin., 2011, 15, (1), pp. 16.
    32. 32)
      • 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.
    33. 33)
      • 33. Object Management Group (OMG): ‘Semantics of Business Vocabulary and Business Rules Specifications (v1.3)’ (OMG, 2015).
    34. 34)
      • 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.
    35. 35)
      • 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.
    36. 36)
      • 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.
    37. 37)
      • 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.
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
This is a required field
Please enter a valid email address