Conceptual Data Model Research Articles

A framework for data-driven adaptive GUI generation based on DICOM.

Computer applications for diagnostic medical imaging provide generally a wide range of tools to support physicians in their daily diagnosis activities. Unfortunately, some functionalities are specialized for specific diseases or imaging modalities, while other ones are useless for the images under investigation. Nevertheless, the corresponding Graphical User Interface (GUI) widgets are still present on the screen reducing the image visualization area. As a consequence, the physician may be affected by cognitive overload and visual stress causing a degradation of performances, mainly due to unuseful widgets. In clinical environments, a GUI must represent a sequence of steps for image investigation following a well-defined workflow. This paper proposes a software framework aimed at addressing the issues outlined before. Specifically, we designed a DICOM based mechanism of data-driven GUI generation, referring to the examined body part and imaging modality as well as to the medical image analysis task to perform. In this way, the self-configuring GUI is generated on-the-fly, so that just specific functionalities are active according to the current clinical scenario. Such a solution provides also a tight integration with the DICOM standard, which considers various aspects of the technology in medicine but does not address GUI specification issues. The proposed workflow is designed for diagnostic workstations with a local file system on an interchange media acting inside or outside the hospital ward. Accordingly, the DICOMDIR conceptual data model, defined by a hierarchical structure, is exploited and extended to include the GUI information thanks to a new Information Object Module (IOM), which reuses the DICOM information model. The proposed framework exploits the DICOM standard representing an enabling technology for an auto-consistent solution in medical diagnostic applications. In this paper we present a detailed description of the framework, its software design, and a proof-of-concept implementation as a suitable plug-in of the OsiriX imaging software.

Conceptual model of executive information system data (A Case Study at The State Islamic University of Sunan Gunung Djati Bandung)

Information Technology (IT) is the key role to enhance the quality of Higher Education, by designing and implementing Executive Information System (EIS). EIS is one of the ways used to improve the competitive advantage of Higher Education. EIS can improve services to the internal information needs of Higher Education and can be used to predict / give input to business decisions that will be taken by the University. Information obtained by extraction and transformation of operational data of Higher Education and collected in data warehouse. The transformation is done by several stages, formulation, aggregation and validation so that the data obtained in accordance with the interest of business analysis of Higher Education. Because of this research will focus on how to design the appropriate categories, schemes and data models to design the EIS Higher Education.

Complexity of Work Families and Entity-Based Visualization Displays

Conceptual modeling of bibliographic data, including the FR models and the consolidated IFLA LRM, has provided an opportunity to shift focus to entities and relationships and to support hierarchical work-based exploration of bibliographic information. This paper reports on a study examining the complexity of a work's bibliographic family data and user interactions with data visualizations, compared to traditional displays. Findings suggest that the FRBR-based visual bibliographic information system supports work families of different complexities more equally than a traditional system. Differences between the two systems also show that the FRBR-based system was more effective especially for related-works and author-related tasks.

Research on Key Technologies of Equipment IETM

The development of equipment IETM is a complex project because of the difficulties in data and interaction technologies. The paper comprehensively applies computer technology to research data of equipment IETM. The conceptual data model was established. Data identification and storage were studied, and data programming was studied. Advanced human-computer interaction is applied to equipment IETM. The interactive interface of IETM is designed. Data interaction technology was studied, which provides effective basis for the development of the Equipment IETM.

Verification of fuzzy UML models with fuzzy Description Logic

The fuzzy UML model has been introduced to enable the conceptual modeling of imprecise data in many applications. How to prevent, detect, and correct errors as early as possible in the modeling process by verifying the correctness of fuzzy UML models is desirable. But it is difficult to manually verify the correctness of the models. Thanks to the effective reasoning service of fuzzy Description Logics (DLs), they are considered as natural candidates for supporting the verification of fuzzy UML models. In this paper we propose a complete and practical approach for verifying fuzzy UML models with fuzzy DLs. In detail, we first propose an approach for transforming a fuzzy UML model into a fuzzy DL knowledge base. Then we further reduce the verification tasks of the fuzzy UML model to reasoning problems of the transformed fuzzy DL knowledge base. Also, the correctness of the approach is proved, and a running example is provided to explain the approach in detail. Final we implemented a prototype that can transform fuzzy UML models into fuzzy DL knowledge bases. Case studies show that the proposed approach is feasible and the prototype translator actually works. By means of our approach and tool, the transformed fuzzy DL knowledge base and reasoning tasks can be input into the existing fuzzy DL reasoners, and the reasoning results reported by the reasoners can be passed back to the designer to improve the quality of the fuzzy UML model.

Design of business simulation game database for managerial learning

This research is aimed to produce a database design that can be used in business simulation game application to improve decision making ability of industrial engineering students. The method used in this design is SDLC method that begins with simulation modelling, conceptual data modelling, logical database design, physical database design, and database implementation. The results of this design are seven relations consisting of scenario, simulation, period simulation, company, supplier, advertisement, and modes. The design results will be used in the development of business simulation game applications that will be used in the learning process of students.

Science and Technology for Batik Craftsmen Society for Improving Economy of the Community in Surabaya Ex Prostitution Localization

The community development presents the creation of catalog to display products online that can help market widely as an effort to improve economy of the community in the area of exs-red district Bangunsari, Surabaya. Partners are an organization engaged in the development of affected communities in the area of Bangunsari localization. The partners are <em>Omah Batik Tulis Khas Surabaya Sari Ratu</em> and <em>Rumah Batik Canting Risma Ratu</em>. E-catalog application had three proceses, i.e. customer registration process, master data processing process, and ordering process. E-catalog application had through five stages are: 1) Identifies data needs performed by interview; 2) Designing the database, created using a Conceptual Data Model (CDM) that produces 8 entities and Physical Data Model (PDM) that generates 8 tables next design the i nput and output form; 3) Implements the system using a web-based programming language; 4) Testing system with black box method, testing sistem include all transactions on each user; and 5) Evaluation of system was done by using questionnaire to find accuracy of aplication. Questionnaires were distributed to 2 partners. Questionnaire was filled by chairman and two members for each partner. Number of questionnaire was 6 questionnaires. The evaluation results show that accuracy of e-catalog application that had been built was user friendly for 73.61%. It is clear that e-catalog aplication that had been built had good category for user friendly.

Implementation of multiple interpretation data model concepts in CIDOC CRM and compatible models

<p>Modelling cultural heritage is a research topic shared by a broad scientific community. Although this subject has been widely studied, it seems that some aspects still have to be tackled. This paper describes two CIDOC (ICOM’s International Committee for Documentation) Conceptual Reference Model (CRM) extension proposals (A & B) dedicated to structuring knowledge concerning historical objects and historical events. It focuses on multiple interpretations and sequential reality, this last being a concept which does not exist in CIDOC CRM but was originally developed in another conceptual model, the Multiple Interpretation Data Model (MIDM). To begin, an extensive description of MIDM concepts is given as well as a recall of its main peculiarities. It is followed by a mapping proposed to translate MIDM concepts into ontologies devoted to describing cultural heritage entities and activities, the CIDOC CRM and compatible models. Unfortunately, some MIDM concepts are not covered by this mapping because they do not match with existing CRM entities and properties, and this paper explains why an extension is necessary. It describes how the two versions of the extension proposal cover the missing MIDM concepts. One of these two versions, the proposal A, has been implemented as ontology in Protégé and has been tested through an instantiation phase using a real example. This instantiation phase is fully detailed. It shows that proposal A works coherently with CRM ontologies. On another hand, instantiation phase highlights improvements needs such as recording chronology in a structured way.</p><p><strong>Highlights:</strong></p><ul><li><p>Cultural Heritage modelling involves two different ontological concepts: reality and information held about it.</p></li><li><p>Historical Objects existence is a sequence made by events, stability periods and changes affecting it.</p></li><li><p>Multiple Interpretation Data Model mapping to CIDOC CRM and its extension proposal take into account difference between reality and information. They also manage sequence concept.</p></li></ul>

Conceptual metadata model for sensor data abstraction in IoT environments

Sensor data abstraction is necessary to provide users with context-aware services. Sensor data abstraction mechanism in context-aware system usually consists of collecting data, converting, and context reasoning. For this mechanism in IoT environments, sensor data is used that is described in the pairs of key-value set or digit value. However, environmental data cannot be sufficiently formed since these sensors data are provided with these values. For example, it may need metadata of contexts and things description. In this paper, we propose a new conceptual metadata model for sensor data abstraction in IoT environments. The proposed model provides sensor data and their metadata as low-level context, which is a part of basic context for presenting given environment, to context-aware system. In the experiments, we describe a procedure to generate low-level context for sensor data abstraction based on the proposed model and to provide this information to the context-aware system.

Developing an Intelligent PostGIS Database to Support Accessibility Tools for Urban Pedestrians

People with mobility impairment must travel through cities with extra care. An intelligent database of Maps for Easy Paths (MEP) project for storing and retrieving accessibility information about a particular path by using PostGIS may enable the public to enjoy the privilege of the technology that alleviates the problem of city accessibility through the Web or, more recently, through smartphones/tablet applications. The methods and techniques for intelligent database to storeand retrieve accessibility information by using a relational intelligent PostGIS database are described. The conceptual data model is designed for an intelligent database (PostGIS). Users will be able to actively participate in the process of taking pictures of obstacles, uploading them to the MEP server and giving some comments on the attributes of the picture of the barrier. The resulting data will help others to locate and evaluate paths. This paper presents the conceptual data model design as well as a review of features of the data of the existing systems. Therefore, the novelty of this approach lies in developing an intelligent database for the enrichment of geographical maps with information about the accessibility of urban pedestrian areas for people with mobility problems.

Design of Web-GIS of the Major Risks in Algeria and Implementation with Two Cartographic Servers

The objective of this work is to propose, at first, a conceptual data model of a Geodatabase dedicated to the disaster management in Algeria. This model highlights the two main components of disasters management: the risk prevention and the response to the disaster, while respecting the 04.20 law (an Algerian law on the prevention of major risks and disaster management in the context of sustainable development). The second part aims to create a WEB-GIS for publishing spatial data corresponding to major risks in Algeria. This solution has been implemented on two cartographic servers (GeoServer and MapServer), a Web server and a spatial database server, all from open source tools.

A EUROPEAN INTEROPERABLE DATABASE (EID) TO INCREASE RESILIENCE OF CULTURAL HERITAGE

Abstract. The set of laws, actions and organizations for Cultural Heritage (CH) protection is born in the different countries of the European Union from local cultural situations, so the ability to cope with the emergency is certainly different. In addition to the damages that can occur to cultural assets after a disaster, an inadequate emergency intervention can sometimes cause further losses to the CH. The effectiveness of response depends on the adequacy of advanced planning. Some countries have designed emergency plans but their databases (DBs) are fragmented, incomplete and not standardized. It is thus necessary to establish a DB for emergency assistance and maps of CH at risk to be compared with maps of natural hazards and risks, in order to take preventive and operational measures, as well as agree on a common terminology and international standards. The project aims to enhance the capability of Civil Protection to prevent disasters impacts on CH by implementing a European Interoperable Database (EID) as supporting decision tool to understand the risk of damage to cultural assets. The EID, starting from the international standards to represent the map objects (CityGML, INSPIRE), the classification of CH in Europe (UNESCO), in Italy (MiBACT), in Germany and in France and from risks and disasters analysis, will design, with its Conceptual Data Model, an extension of the INSPIRE UML model. This DB will also support 3D models to help finding and recognizing dispersed artworks and facilitate a post-emergency restoration, preserving thus a digital memory in case of destruction.

Medical Big Data Warehouse: Architecture and System Design, a Case Study: Improving Healthcare Resources Distribution.

The huge increases in medical devices and clinical applications which generate enormous data have raised a big issue in managing, processing, and mining this massive amount of data. Indeed, traditional data warehousing frameworks can not be effective when managing the volume, variety, and velocity of current medical applications. As a result, several data warehouses face many issues over medical data and many challenges need to be addressed. New solutions have emerged and Hadoop is one of the best examples, it can be used to process these streams of medical data. However, without an efficient system design and architecture, these performances will not be significant and valuable for medical managers. In this paper, we provide a short review of the literature about research issues of traditional data warehouses and we present some important Hadoop-based data warehouses. In addition, a Hadoop-based architecture and a conceptual data model for designing medical Big Data warehouse are given. In our case study, we provide implementation detail of big data warehouse based on the proposed architecture and data model in the Apache Hadoop platform to ensure an optimal allocation of health resources.

Generalized conceptual data model of electrophysiological studies of the gastrointestinal tract

Generalized conceptual data model of electrophysiological studies of the gastrointestinal tract

Modern approach for intelligent database to support urban city accessibility tools for the pedestrian

Travelling through cities is one of the things which people with mobility impairment always have to deal with. A designed dynamic database of Maps for Easy Paths (MEP) project for storing and retrieving accessibility information about a particular path by using PostGIS may enable the public to enjoy the privilege of the technology that alleviates the problem of city accessibility through the Web, or more recently, through smartphones/tablet applications. An application of methods and techniques for designing a dynamic database to store and retrieve accessibility information by using a relational PostGIS is described. The conceptual data model is designed for a database (PostGIS) which provides an optimal description of the user requirements. Users will be able to actively participate in the process of taking pictures of obstacles, uploading them to the MEP server and giving some comments on the attributes of the picture of the barrier. The resulting data will help others to locate and evaluate paths. This paper presents the conceptual data model design as well as a review of features of the data of the existing systems. The paper demonstrates that our data-driven approach can be used to facilitate the planning, design, and implementation of an appropriate application to achieve the MEP goal. Therefore, the novelty of this approach lies in developing the dynamic database for the enrichment of geographical maps with information about the accessibility of urban pedestrian areas for people with mobility problems.

НЕЛІНІЙНА РЕГРЕСІЙНА МОДЕЛЬ ДЛЯ ОЦІНЮВАННЯ РОЗМІРУ ПРОГРАМНОГО ЗАБЕЗПЕЧЕННЯ ІНФОРМАЦІЙНИХ СИСТЕМ НА БАЗІ VB

The non-linear regression model to estimate the software size of VB-based information systems is constructed on the basis of normalization of the four-dimensional non-Gaussian data set (actual software size in the thousand lines of code, the total number of classes, the total number of relationships and the average number of attributes per class in conceptual data model from 32 systems) by the Johnson multivariate transformation for SB family. Comparison of the constructed model with the linear regression model and non-linear regression models based on the decimal logarithm and the Johnson univariate transformation is performed. Thе constructed model, in comparison with other regression models (both linear and non-linear), has a larger multiple coefficient of determination, a smaller value of the mean magnitude of relative error and smaller widths of the confidence and prediction intervals of non-linear regression.

АЛГОРИТМ ПРАКТИЧНОЇ РОЗРОБКИ ІНТЕРАКТИВНОЇ ТЕМАТИЧНОЇ КАРТИ КРИТИЧНОЇ ІНФРАСТРУКТУРИ МІСТА КИЄВА

The article is devoted to the consideration of issues of development of the multifunctional interactive thematic map of the critical infrastructure of Kyiv city with the wording of the corresponding algorithm. Based on the analysis of existing technological solutions for the practical development of interactive maps – electronic mapping models with the two-way user dialogical interaction and technical support of their functioning – for the specific solution substantiated application geoinformation technological approach with visualization. The theoretical and methodological level of development of an algorithm for creating the interactive map of the critical infrastructure of Kyiv city with presentation on it of the conceptual model of the geographic data of the cartographical object, which includes: description and definition of geographical elements, which form it; select types of spatial objects to display critical infrastructure elements on the map; formulation of the solution of the question of how to represent their dimensionality and interrelationships with objects in reality; database contents; requirements for the obtained results. Methodological level of the algorithm for creating the interactive map of critical infrastructure according to the chosen technology provides for the development of the logical structure of the database elements in accordance with the management system of them, used in software, and also related with hardware and software tools for its physical realization. The main stages of the algorithm for creating an interactive map of critical infrastructure of Kyiv city, which form the sequence of its creation, is defined: selection of software products to provide cartographic visualization of the necessary thematic information in the form of mapping indicators (critical infrastructure objects) geographically based on the application of the principle of multi-level generalization by tile technology solution and server approach (first stage); representation of data in the relational database in accordance with the definition and content of spatial objects and their transformation into mapping indicators (second); the formation of a web page for displaying general geographic and thematic information in the dialogue session of the user with an interactive mapping model (third stage).

Experimental study on the effectiveness of a teaching approach using barker or Bachman notation for conceptual database design

Relational databases are one of the pillars of information systems and as a consequence conceptual and logical design can be seen as the foundation of almost every application regardless of the platform. Nevertheless, little research has been done so far on the effectiveness of teaching approaches to database basic concepts and design. This paper introduces a multi-level experimental study developed to examine the effectiveness of learning database fundamentals, depending on the notation used for conceptual design. The main experiment was carried out at a higher education institution. We developed different experimental instruments to evaluate the effectiveness of a teaching approach using Barker or Bachman notation for conceptual database design. In contrast to Barker notation, Bachman notation incorporates elements of logical design (i.e. foreign keys) in the conceptual design level. Students? achievements were examined with regard to influencing factors throughout the learning process. Introducing the Bachman notation and a manual transformation from a conceptual into a logical data model, could increase students? understanding of conceptual, logical and relational data model concepts. We found that the notation used during the learning process has an impact on students? achievements. Moreover, students achieved better results when solving tasks presented with a notation that incorporates elements of logical design into the conceptual level. Finally, we required the use of manual transformation from a conceptual into a logical data model and the results confirmed an increase in students? understanding.

Conceptual Data Model for IoT in a Chain-Integrated Greenhouse Production: Case of the Tomato Production in Almeria (Spain)

A new generation of Agricultural Information Systems is arriving, increasing the integration in Internet, as it supposes the use of Internet of the Things (IoT) technology with the agricultural products. Actual ICT Agricultural systems must evolve to this new generation of systems, in this work it is presented how we can integrate the data of the actual systems and pass them to an IoT platform, in our case FIWARE. We develop a data model that generalize the actual information systems (everyone would be a subset of the proposed model) that lets us to transfer the information to the IoT platform in the cloud.

An Interoperable Spatio-Temporal Model for Archaeological Data Based on ISO Standard 19100

Archaeological data are characterized by both spatial and temporal dimensions that are often related to each other and are of particular interest during the interpretation process. For this reason, several attempts have been performed in recent years to develop a geographical information system (GIS) tailored for archaeological data. However, despite the increasing use of information technologies in the archaeological domain, the actual situation is that any agency or research group independently develops its own local database and management application that is isolated from the others. Conversely, the sharing of information and the cooperation between different archaeological agencies or research groups can be particularly useful to support the interpretation process by using data discovered in similar situations with respect to spatio-temporal or thematic aspects. In the geographical domain, the INSPIRE initiative of the European Union tries to support the development of a spatial data infrastructure (SDI) through which several organizations, such as public bodies or private companies, with overlapping goals can share data, resources, tools, and competencies in an effective way. The aim of this article is to lay the basis for the development of an archaeological SDI starting from the experience acquired during the collaboration among several Italian organizations. In particular, the article proposes a spatio-temporal conceptual model for archaeological data based on the ISO Standards of the 19100 family and promotes the use of the GeoUML methodology to put into practice such interoperability. The GeoUML methodology and tools have been enhanced to suit the archaeological domain and to automatically produce several useful documents, configuration files, and code base starting from the conceptual specification. The applicability of the spatio-temporal conceptual model and the usefulness of the produced tools have been tested in three different Italian contexts: Rome, Verona, and Isola della Scala.