Skip to main content

Advertisement

SpringerLink
Log in

A framework for medical and health care databases and data warehouses conceptual modeling support

  • Original Article
  • Published:
Network Modeling Analysis in Health Informatics and Bioinformatics Aims and scope Submit manuscript

Abstract

To improve their knowledge of diseases, physicians need to study and learn from their patients and from their related medical records. Physicians continue to initiate this learning process by taking into account the history of the patient’s medical problems and physical examination findings in the patient’s medical record, which illustrates the importance of medical and health care databases. In other side, the evolution of medical data volume needs to be modeled using data warehouses. A medical data warehouse is a particular database targeted toward decision support. It takes data from various medical databases and other data sources and transforms it into new structures that fit better for the task of performing the decision making. For this reason, the medical database and data warehouse models needed to produce a formal description, a conceptual schema of all the data generated in medical and health care institutions, and how all of the data were related. However, it is still difficult to find references models, since classical conceptual modeling does not incorporate the specificity of the medical field. The design phase is the most important activity in the successful building of a database and a data warehouse. To address these shortcomings, this paper proposes a new modeling framework based on an UML profile, called medical profile. This profile was proposed to standardize the task of medical data modeling, using the Unified Modeling Language (UML) extensibility mechanisms. Our proposal is aligned with model driven architecture (MDA), thus permitting to define and clarify all concepts and elements related to medical field including the medical image annotation process. To show the benefits of our profile, we develop an example related to the medical image annotation process. Finally, we also need to verify whether our framework is considered by the specialists as a potential aid. We evaluate our framework impact by inquiring the specialists about the degree of confidence in our framework. By analyzing the obtained results, we can argue that the proposed framework presented a high acceptance regarding the specialists’ interests.

This is a preview of subscription content, log in via an institution to check access.

Access this article

Log in via an institution

Price excludes VAT (USA)
Tax calculation will be finalised during checkout.

Instant access to the full article PDF.

Institutional subscriptions

Fig. 1
Fig. 2
Fig. 3
Fig. 4
Fig. 5
Fig. 6
Fig. 7
Fig. 8
Fig. 9

Similar content being viewed by others

Notes

  1. http://www.fsjegj.rnu.tn/.

  2. http://www.isg.rnu.tn/.

Abbreviations

MDA:

Model driven architecture

UML:

Unified modeling language

OMG:

Object management group

MOF:

Meta-object facility

CIM:

Computation independent model

PIM:

Platform independent model

PSM:

Platform specific Model

SDM:

System design model

MDD:

Model driven development

OCL:

Object constraint language

ADLs:

Architecture description language

SoCs:

Systems-on-chips

QoS:

Quality-of-service

MD:

Multidimensional

References

  • Abdullah MS, Paige R, Kimble C, Benest I (2007) A UML profile for knowledge-based systems modeling. In: 5th ACIS International Conference on Software Engineering Research, Management and Applications, pp 871–878

  • Abello RT (2006) Research in data warehouse modeling and design: dead or alive? DOLAP’06, Arlington, Virginia, USA. Copyright 2006 ACM 1-59593-530-4/06/0011

  • Abelló A, Samos J, Saltor F (2001) A framework for the classification and description of multidimensional data models. In: Proceedings of the 12th International Conference on Database and Expert Systems Applications (DEXA’01), pp 668–677

  • Abelló A, Samos J, Saltor F (2006) YAM2: a multidimensional conceptual model extending UML. Inform Syst 31(6):541–567

    Article  Google Scholar 

  • Aditya A, Francisco Z, Eric S (2012) UML profile and extensions for complex approval systems with complementary levels of abstraction. Procedia Comp Sci 12:75–80

    Article  Google Scholar 

  • Alaskar K, Shaikh A (2009) Object oriented data modeling for data warehousing (an extension of UML approach to study Hajj pilgrim’s private tour as a Case Study). Int Arab J e-Technol 1(2)

  • American Dental Education Association (2014). http://explorehealthcareers.org/en/homeLast updated: October 9

  • Amir R, Zeid A (2004) An UML profile for service oriented architectures. In: The 19th Annual ACM SIGPLAN Conference on Object-Oriented Programming, Systems, Languages, and Applications, pp 192–193

  • Anneke GK, Jos W, Wim B (2010) MDA explained: the model driven architecture: practice and promise, 1st edn. Addison-Wesley, Boston

    Google Scholar 

  • Blaschka M, Sapia C, Höfling G, Dinter B (1998) Finding your way through multidimensional data models. In: Proceedings of the 9th International Conference on Database and Expert Systems Applications DEXA’98, Lecture Notes in Computer science, Vienna, Austria, Springer–Verlag, pp 198–203

  • Cabibbo L, Torlone R (1998) A logical approach to multidimensional databases. In: Proceedings of 6th International Conference on Extending Database Technology EDBT 98, Volume 1337 of LNCS, Spain, Springer, pp 183–197

  • Completo J, Santos Cruz R, Coheur L, Delgado M (2012) Design and implementation of a data warehouse for benchmarking in clinical rehabilitation. In: HCIST 2012—International Conference on Health and Social Care Information Systems and Technologies, pp 885–894

  • Conallen J (2002) Building web applications with UML. Addison-Wesley

  • Elmasri R, Navathe SB (2010) Fundamentals of database systems. Addison Wesley Publishing Co., 6th edition

  • Eriksson HE, Penker M, Fado D (2004) UML 2 toolkit. Wiley, New York

    Google Scholar 

  • Fernandez M and al. (2010) Model driven development of secure XML data warehouses: a case study. EDBT 2010, Lausanne, Switzerland. Copyright ACM 978-1-60558-945-9/10/0003

  • Fernando H, Héctor P, Pablo P, Eugenio V, Francisco F, Raul V, Gianluca P (2014) The COMPLEX methodology for UML/MARTE Modeling and design space exploration of embedded systems. J Syst Architect 60:55–78

    Article  Google Scholar 

  • Filipe Ribeiro N, Lisboa-Filho J, Karla A, Borges V, José Luís B, Marcus V, Andrade A (2011) Applying the model driven architecture approach for geographic database design using a UML profile and ISO standards. J Inform Data Manag 2:171–180

    Google Scholar 

  • Fuentes L, Vallecillo A (2004) An introduction to UML profiles. Euro J Inform Prof 5(4):5–13

    Google Scholar 

  • Gosain A, Mann S (2010) Object oriented multidimensional model for a data warehouse with operators. Int J Database Theory Appl 3(4):35–40

    Google Scholar 

  • Hans S, Pieter VG, Dirk J (2005) Leveraging UML profiles to generate plugins from visual model transformations. Elect Notes Theor Comp Sci 127:5–16

    Google Scholar 

  • Heckel R, Kuster J, Thone S, Voigt H (2003) Towards a UML profile for service-oriented architectures. Workshop on Model Driven Architecture: Foundations and Applications (MDAFA’03). University of Twente, Enschede

  • I-Ching H (2012) Extending UML to model web 2.0-based context-aware applications. Softw Pract Exp 42(10):1211–1227

    Article  Google Scholar 

  • I-Ching H (2013) Visual modeling for web 2.0 applications using model driven architecture approach. Simul Model Pract Theory 31:63–76

    Article  Google Scholar 

  • I-Ching H, Der-Hong T, Nien-Lin H (2014) MDA-based visual modeling approach for resources link relationships using UML profile. Comp Stand Interfac 36(3):648–656

    Article  Google Scholar 

  • Imran RQ, Abdoulaye G, Pierre B, Samy M, Jean LD (2012) Expressing embedded systems configurations at high abstraction levels with UML MARTE profile: advantages, limitations and alternatives. J Syst Archit 58:178–194

    Article  Google Scholar 

  • ISO “ISO 9241-10:1996”. International Organization for Standardization

  • Jesus P, Cristina C (2010) Domain-specific language modeling with UML profiles by decoupling abstract and concrete syntaxes. J Syst Softw 83:2591–2606

    Article  Google Scholar 

  • Jindal R, Taneja S (2012) Comparative study of data warehouse design approaches: a survey. Int J Database Manage Syst 4(1) (ISSN 0975-5985)

  • Johnston S (2005) UML profile for software services. IBM Developer Works. Available from: http://www-128.ibm.com/developerworks/rational/library/05/419_soa/

  • Kimball R, Ross M (2002) Data Warehouse toolkit. Wiley and Songs (2002)

  • Krüger IH, Mathew R (2004) Systematic development and exploration of service-oriented software architectures. In: Proceedings of the Fourth Working IEEE/IFIP Conference on Software Architecture (WICSA’04), Oslo, Norway, pp 177–187

  • Lam-Son L, Alain W (2013) Hierarchy oriented modeling of enterprise architecture using reference model of open distributed processing. Comp Stand Interfac 35(3):277–293

    Article  Google Scholar 

  • Luján-Mora S, Trujillo J (2003) A comprehensive method for data warehouse design. In: Proceedings of 5th International Workshop on Design and Management of Data Warehose (DMDW’03), pp 111–114

  • Luján-Mora S, Trujillo J (2006) Physical modeling of data warehouses by using UML component and deployment diagrams: design and implementation issues. J Database Manag 17(1)

  • Luján-Mora S, Trujillo J, Song IY (2002) Extending the UML for multidimensional modeling. In: UML, pp. 290–304

  • Luján-Mora S, Vassiliadis P, Trujillo J (2004) Data mapping diagrams for data warehouse design with UML. In: Proceedings of 23 rd International Conference on Conceptual Modeling (ER 04), V 3288 of LNCS, China, Springer

  • Ma H, Yang Y, Zhang F (2009) The anti-standardized design research of data warehouse. In: IE&EM ‘09. 16th International Conference on Industrial Engineering and Engineering Management, pp 380–384

  • Marcos LS, Cesar JA, Carlos EC, Esperanza M (2008) Modeling of service-oriented architectures with UML. Elect Notes Theor Comp Sci 194:23–37

    Article  Google Scholar 

  • Medina E, Mora S L (2002) A web oriented approach to manage multidimensional models through XML schemas and XSLT. EDBT Workshops, LNCS 2490, pp 29–44

  • Mishra D, BeriA Y, Basaran P (2008) A case study of data models in data warehousing. In: ICADIWT 2008, First International Conference on the Applications of Digital Information and Web Technologies, pp 314–319

  • Myers RB, Herskovic JR (2011) Probabilistic techniques for obtaining accurate patient counts in clinical data warehouses. J Biomed Inform, pp 569–577

  • Object Management Group (2003) MDA Guide Version 1.0.1. In: Mukerji JJM (eds.), OMG, Available from: http://www.dcs.shef.ac.uk/people/A.Simons/remodel/papers/MDAGuide101Jun03.pdf

  • Object Management Group (2007) Unified modeling language: superstructure, v.2.1.2. OMG, Needham, MA, USA

  • Object Management Group (2010) Meta object facility core specification version 2.0. OMG, Available from: http://www.omg.org/technology/documents/formal/MOF_Core.htm

  • Object Management Group (2010) OMG’s meta object facility. OMG http://www.omg.org/mof/

  • Object Management Group (2010) Unified Modeling Language (UML), version 2.2. OMG, Available from: http://www.omg.org/technology/documents/formal/uml.htm

  • Object Management Group (2010) Unified Modeling Language™ (UML®). Resource Page, OMG Available from: http://www.uml.org/

  • OMG: Object Management Group (2010) UML Superstructure Specification, v2.0. http://www.omg.org/cgi-bin/doc?formal/05-07-04

  • OMG (2010a) Object Management Group. Available from: http://www.omg.org/

  • OMG (2010b) MDA® Specifications. Available from: http://www.omg.org/mda/specs.htm

  • OMG (2010c) Object constraint language specification (version 2.0). Available from: http://www.omg.org/technology/documents/formal/ocl.htm

  • OMG (2010d) UML Profile for CORBA, v 1.0. Available from: http://www.omgorg/technology/documents/formal/profile_corba.htm

  • OMG (2010e) UML Profile for enterprise distributed Object Computing (EDOC). http://www.omg.org/technology/documents/formal/edoc.htm

  • OMG (2010f) UML testing profile, v 1.0. Available from: http://www.omg.org/technology/documents/formal/test_profile.htm

  • Pahwa P, Taneja S (2011) Design of a Multidimensional model using Object Oriented Features in UML. IARS Int J 1(1)

  • Pardillo J, Jose-Norberto M (2011) Using ontologies for the design of data warehouses. Int J Database Manage Syst (IJDMS) 3(2)

  • Pinet F et al. (2011) The use of UML to design agricultural data warehouses. AgEng 2010, International Conference on Agricultural Engineering, France

  • Post A R, Kurc T, Cholleti S, Gao J, Lin X, Bornstein W, Cantrell D, Levine D, Hohmann S, Saltz JH (2013) The analytic information warehouse (AIW): a platform for analytics using electronic health record data. J Biomed Inform 410–424

  • Rennie MW, Misic VB (2004) Towards a service-based architecture description language. TR 04/08, Technical Report, University of Manitoba, Canada

  • Rizzi S, Golfarelli M (1998) A methodological framework for data warehouse design. DOLAP 98 Washington DC USA, Copyright ACM 1999l-581 13-120-8/98

  • Rizzi S, Golfarelli M (2001) WanD: A CASE tool for data warehouse design. In: Demo Proceedings 17th International Conference on Data Engineering (ICDE 2001), pp 7–9

  • Rizzi S, Golfarelli M, Maio D (1998) The dimensional fact model: a conceptual model for data warehouses. Int J Coop Inform Syst (IJCIS) 7(2–3):215–247

    Google Scholar 

  • Roelofs E, Persoon L, Nijsten S, Wiessler W, Dekker A, Lambin P (2013) Benefits of a clinical data warehouse with data mining tools to collect data for a radiotherapy trial. Radiotherapy and Oncology, pp. 174–179

  • Sergio LM, Juan T, Il-Yeol S (2006) A UML profile for multidimensional modeling in data warehouses. Data Knowl Eng 59:725–769

    Article  Google Scholar 

  • Sharma M, Rajpal N, Reddy B V R (2010) Physical data warehouse design using neural network. Int J Comp Appl 1(3):86–94 (Published By Foundation of Computer Science)

  • Steve D, Eve M, David O (2010) XML Linking Language (XLink) Version 1.0. Available from: http://www.w3.org/TR/xlink/

  • Torsten F, Manuel K, Karl P (2006) An MDA approach to access control specifications using MOF and UML profiles. Elect Notes Theor Comp Sci 142:161–179

    Article  Google Scholar 

  • Troya JM, Lidia F, Antonio V (2002) Using UML profiles for documenting web-based application frameworks. Ann Softw Eng 13:249–264

    Article  MATH  Google Scholar 

  • Trujillo J, Palomar M, Gómez J, Song I-Y (2001) Designing data warehouses with OO conceptual models. IEEE Comput 34(12):66–75

    Article  Google Scholar 

  • Trujillo J, Lujan Mora S, Song I (2002) Multidimensional modeling with UML package diagrams warehouses. In: Proceedings of 21 st International Conference on Conceptual Modeling, ER 02, Volume 2503 of LNCS, Finland, Springer, pp 199–213

  • Villarroel R, Soler E, Fernández ME, Trujillo J, Piattini M (2006) Using UML packages for designing secure data warehouses. ICCSA 2006. LNCS 3982:1024–1034

    Google Scholar 

  • Wada H, Suzuki J, Oba K (2006) Modeling non-functional aspects in service oriented architecture. In: Proceedings of the IEEE International Conference on Service Computing. Chicago, Illinois

  • World Health Organization (2006) World Health Report 2006: working together for health. WHO, Geneva

    Book  Google Scholar 

  • World Health Organization (2009) Women and health: today’s evidence, tomorrow’s agend. Geneva

  • World Health Organization (2010) Classifying health workers. Geneva Available from: http://www.who.int/hrh/statistics/Health_workers_classification.pdf

Download references

Author information

Authors and Affiliations

  1. Department of Computer Sciences, ISG, Tunis, Tunisia

    Mouhamed Gaith Ayadi, Riadh Bouslimi & Jalel Akaichi

Authors
  1. Mouhamed Gaith Ayadi
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Riadh Bouslimi
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Jalel Akaichi
    View author publications

    You can also search for this author in PubMed Google Scholar

Corresponding author

Correspondence to Mouhamed Gaith Ayadi.

Rights and permissions

Reprints and permissions

About this article

Check for updates. Verify currency and authenticity via CrossMark

Cite this article

Ayadi, M.G., Bouslimi, R. & Akaichi, J. A framework for medical and health care databases and data warehouses conceptual modeling support. Netw Model Anal Health Inform Bioinforma 5, 13 (2016). https://doi.org/10.1007/s13721-016-0121-x

Download citation

  • Received:

  • Revised:

  • Accepted:

  • Published:

  • DOI: https://doi.org/10.1007/s13721-016-0121-x

Keywords

Search

Navigation