Formalized Approach in Relational Database Design

Osipova, V V; Chudinov, Igor L.; Seidova, Aysel S.

doi:10.4028/www.scientific.net/kem.685.930

Cited by 3 publications

(2 citation statements)

References 1 publication

Supporting

Mentioning

Contrasting

Order By: Relevance

“…Composite attributes consist of several sub-attributes that together specify the data required for each entity. Relationships between entities are represented by cardinality, such as one-to-one or one-to-many [48]. The internal validity of ER diagrams consists of theoretically grounded variables and the logical reasoning of their relevance to practice [49,50].…”

Section: Establish An Entity-relationship Modelmentioning

confidence: 99%

A Decision Support System for Hospital Configurations in Construction Projects

2022

View full text Add to dashboard Cite

Hospitals are complex buildings and their functionality is essential for patient healthcare. Definition, verification and implementation of accurate configuration information during construction projects are therefore essential. The purpose of this study was to develop a decision support system by establishing a value chain of configuration information with an end-to-end perspective. The approach of this study was explorative, investigating how building data can support construction projects in making hospital configuration decisions. A literature review provided a knowledge base about the configuration decision process flow, which determined the prerequisites for the proposed data and model management. Exchange and relationships of required building data were ensured by using Industry Foundation Classes (IFC) and a database model, respectively. The results show that using building model data for configuration decision support is feasible. A case study compared data exchanged in three construction projects of Magnetic Resonance Imaging rooms to those identified in the decision support system. Operational gaps regarding data exchange in the studied cases indicate what changes are required in current data collection and management. The contribution of this study is filling a research gap regarding end-to-end information management to support hospital configuration decisions in construction projects.

show abstract

Section: Establish An Entity-relationship Modelmentioning

confidence: 99%

A Decision Support System for Hospital Configurations in Construction Projects

2022

View full text Add to dashboard Cite

show abstract

“…It is considered that creating a database is primarily preferred for complex domains if design involves a lot of domain experts and a group of analystdesigners [14], but as a result, a unified irredundant database scheme should be obtained. In addition, the database design is a continuous process: client needs, a detailed description of domain entities, their attributes and how those entities relate to each other.…”

Section: Design Of Databases As a Storage Technologymentioning

confidence: 99%

Use of Storage Technologies to select Knowledge Management Tools and Strategies for M-SMEs

Talamante-Lugo

Felix-Moreno

Feuchter-Leyva

et al. 2019

Ingeniare. Rev. chil. ing.

View full text Add to dashboard Cite

The Storage Technologies allow to have an effective and planned management of the resources a company contains (materials or information). When they contain information, there is a need to possess an information storage system, to retrieve relevant aspects from a data reservoir. Regarding Knowledge Management (KM) on Micro, Small and Medium Enterprises (M-SMEs) usually has short presence on the literature, which is why this project can help to collect information on the subject. This work will be considered to those people who support the recently open M-SMEs, which present difficulties on their intellectual capital, innovation and development, generating a high rate of failure. With the objective of effectively apply KM on those companies using data storages, this article consists on presenting the current situation on the studied elements in the introduction, following a theoretical analysis and the process designed to achieve the objective. The process was to develop a database, with a design based on Storage Technologies which was used, and its utility will be determined on the conclusions. As result, the objective was achieved because, with an amount of case studies, data of interest was available and formed a new criterion that allows a practical and integral selection of tools and strategies of KM on those companies. RESUMENLas tecnologías de almacenes permiten tener una gestión efectiva y planificada de los recursos que una empresa tiene (materiales e información). Cuando contienen información, existe una necesidad de poseer un sistema de almacenamiento de información, para recibir aspectos relevantes por parte de un almacén de datos. En el caso de la Gestión del Conocimiento (GC) en Micro, Pequeñas y Medianas Empresas (MiPyMEs) suele tener poca presencia en la literatura, por lo que este proyecto puede ayudar a recolectar información del tema. Este trabajo está dirigido a aquellas personas que apoyan a las MiPyMEs de nueva creación, las cuales presentan dificultades en su capital intelectual, innovación y desarrollo, generando un alto grado de fracaso. Con el objetivo de aplicar efectivamente la GC en dichas empresas mediante el uso de almacenes de datos, este artículo consiste en presentar la situación actual de los

show abstract