• Title/Summary/Keyword: Linked Database

Search Result 198, Processing Time 0.023 seconds

Comparison of Database Models for Developing a Pavement Performance Analysis System

  • Choi Jae-ho
    • Korean Journal of Construction Engineering and Management
    • /
    • v.5 no.4 s.20
    • /
    • pp.79-86
    • /
    • 2004
  • One of the most difficult tasks in pavement management information systems is establishing the links between performance measures of a structure and the design and construction inputs. In-situ pavement performance can be considered a response variable to many project input variables, such as design, construction, and traffic loading effects. If we are to fully understand the component of pavement performance and specify the inputs through design and construction specifications to achieve that performance we must develop quantitative relationship between input and response variables through a scientific, fully integrated Pavement Performance Analysis System (PPAS). Hence, the objective of this study is to design a database model required for developing an effective database template that will allow analysis of pavement performance measures based on design and construction information linked by location. In order to select the most appropriate database model, a conceptual database model (Entity Relationship Model) and dimensional model, which is believed to be the most effective modeling technique for data warehouse project, are designed and compared. It is believed that other state highway agencies could adopt the proposed design strategy for implementing a PPAS at the discretion of the state highway agencies.

Development of the Nursing Database for Gastric Cancer Patients (위암환자를 위한 간호 데이터베이스 개발)

  • Jung, Kwuy-Im;Lee, Byung-Sook
    • Journal of Korean Academy of Nursing Administration
    • /
    • v.7 no.3
    • /
    • pp.571-588
    • /
    • 2001
  • Purpose : This study was to develop the nursing database for gastric cancer patients for clinical application. Method : Nursing data that development of this data base is comprehensive connected with gastric cancer patient nursing process frame to foundation as classification. Result : Each stage was processed based on the System Development Life Cycle. At the Strategy Planning stage, gastric cancer patient nursing process were analyzed. At the system Analysis Stage, database flowchart was drawn up based on frame of nursing process was drawn up. At the system Design Stage, a system was developed based on the flowchart and named the Nursing Database. The Nursing Database consisted of the patient's Basic Information, Patient's Nursing History, Discharge summary, Nursing Assessment, Nursing Diagnosis, Nursing Intervention/activity, Nursing Evaluation, Statics, Code Registration. Each element in flowchart was coded and made into a database. Nursing Assessment classified according to Gorden's Health Pattern Typology, and nursing diagnosis draws the standard 27 name of Hanguls and connected with nursing assessment. Nursing intervention and nursing activity draw 192 of thing that present in NIC, connected this with nursing assessment. Nursing evaluation is linked with nursing assessment, diagnosis and intervention by achievement availability of nursing goals. Conclusion : The biggest advantage of this database nursing process that can manage nursing information exactly and rapidly to foundation be.

  • PDF

Cohort Profile: Korean Tuberculosis and Post-Tuberculosis Cohort Constructed by Linking the Korean National Tuberculosis Surveillance System and National Health Information Database

  • Jeong, Dawoon;Kang, Hee-Yeon;Kim, Jinsun;Lee, Hyewon;Yoo, Bit-Na;Kim, Hee-Sun;Choi, Hongjo
    • Journal of Preventive Medicine and Public Health
    • /
    • v.55 no.3
    • /
    • pp.253-262
    • /
    • 2022
  • We aimed to review the current data composition of the Korean Tuberculosis and Post-Tuberculosis Cohort, which was constructed by linking the Korean Tuberculosis Surveillance System (KNTSS; established and operated by the Korean Disease Control and Prevention Agency since 2000) and the National Health Information Database (NHID; established by the National Health Insurance Service in 2012). The following data were linked: KNTSS data pertaining to patients diagnosed with tuberculosis between 2011 and 2018, NHID data of patients with a history of tuberculosis and related diseases between 2006 and 2018, and data (obtained from the Statistics Korea database) on causes of death. Data from 300 117 tuberculosis patients (177 206 men and 122 911 women) were linked. The rate of treatment success for new cases was highest in 2015 (86.7%), with a gradual decrease thereafter. The treatment success rate for previously treated cases showed an increasing trend until 2014 (79.0%) and decreased thereafter. In total, 53 906 deaths were confirmed among tuberculosis patients included in the cohort. The Korean Tuberculosis and Post-Tuberculosis Cohort can be used to analyze different measurement variables in an integrated manner depending on the data source. Therefore, these cohort data can be used in future epidemiological studies and research on policy-effect analysis, treatment outcome analysis, and health-related behaviors such as treatment discontinuation.

Determination of Substrate Specificities Against β-Glucosidase A (BglA) from Thermotoga maritime: A Molecular Docking Approach

  • Rajoka, Muhammad Ibrahim;Idrees, Sobia;Ashfaq, Usman Ali;Ehsan, Beenish;Haq, Asma
    • Journal of Microbiology and Biotechnology
    • /
    • v.25 no.1
    • /
    • pp.44-49
    • /
    • 2015
  • Thermostable enzymes derived from Thermotoga maritima have attracted worldwide interest for their potential industrial applications. Structural analysis and docking studies were preformed on T. maritima β-glucosidase enzyme with cellobiose and pNP-linked substrates. The 3D structure of the thermostable β-glucosidase was downloaded from the Protein Data Bank database. Substrates were downloaded from the PubCehm database and were minimized using MOE software. Docking of BglA and substrates was carried out using MOE software. After analyzing docked enzyme/substrate complexes, it was found that Glu residues were mainly involved in the reaction, and other important residues such as Asn, Ser, Tyr, Trp, and His were involved in hydrogen bonding with pNP-linked substrates. By determining the substrate recognition pattern, a more suitable β-glucosidase enzyme could be developed, enhancing its industrial potential.

The Activation Plan of Chain Information Network And Efficent NDB Design (효율적인 NDB 설계 및 유통 정보 NETWORK 활성화 방안)

  • 남태희
    • KSCI Review
    • /
    • v.1 no.2
    • /
    • pp.73-94
    • /
    • 1995
  • In this paper, design of efficient NDB(Network Data Base) for the activation plan of chain information network. The DB structure build up, logical structure, store structure, physical structure, the data express for one's record, and the express using linked in the releation of data. Also express as hierarchical model on the DSD(Data Structure Diagram) from the database with logical structure. Each node has express on record type, the linked in course of connective this type, the infuence have efficent of access or search of data, in the design for connection mutually a device of physical, design for database, and construction a form of store for logical. Also activation of chain information network of efficent, using POS(Point Of Sale) system in OSI(Open Systems Interconnection) environment for network standardization, and build up network a design for system.

  • PDF

Privacy Disclosure and Preservation in Learning with Multi-Relational Databases

  • Guo, Hongyu;Viktor, Herna L.;Paquet, Eric
    • Journal of Computing Science and Engineering
    • /
    • v.5 no.3
    • /
    • pp.183-196
    • /
    • 2011
  • There has recently been a surge of interest in relational database mining that aims to discover useful patterns across multiple interlinked database relations. It is crucial for a learning algorithm to explore the multiple inter-connected relations so that important attributes are not excluded when mining such relational repositories. However, from a data privacy perspective, it becomes difficult to identify all possible relationships between attributes from the different relations, considering a complex database schema. That is, seemingly harmless attributes may be linked to confidential information, leading to data leaks when building a model. Thus, we are at risk of disclosing unwanted knowledge when publishing the results of a data mining exercise. For instance, consider a financial database classification task to determine whether a loan is considered high risk. Suppose that we are aware that the database contains another confidential attribute, such as income level, that should not be divulged. One may thus choose to eliminate, or distort, the income level from the database to prevent potential privacy leakage. However, even after distortion, a learning model against the modified database may accurately determine the income level values. It follows that the database is still unsafe and may be compromised. This paper demonstrates this potential for privacy leakage in multi-relational classification and illustrates how such potential leaks may be detected. We propose a method to generate a ranked list of subschemas that maintains the predictive performance on the class attribute, while limiting the disclosure risk, and predictive accuracy, of confidential attributes. We illustrate and demonstrate the effectiveness of our method against a financial database and an insurance database.

Design of a Plant Life Cycle Data Management System for Plant Operation and Maintenance (플랜트 설계 및 운영 데이터 통합관리 시스템 설계)

  • Lee, Jae Hyun;Suh, Hyo Won
    • Journal of Korean Institute of Industrial Engineers
    • /
    • v.42 no.3
    • /
    • pp.241-248
    • /
    • 2016
  • Plant life cycle consists of design, construction, certification, operation, and maintenance phases, and various and enormous plant life cycle data is involved in each phase. Plant life cycle data should be linked with each other based on its proper relationships, so that plant operators can access necessary plant data during their regular operations and maintenance works. Currently, the relationships of plant life cycle data may not be defined explicitly, or they are scattered over several plant information systems. This paper proposes high level design of a plant life cycle data management system based on pre-defined plant life cycle database design. ISO-15926 standard is adapted for the database design. User-interface designs of the plant life cycle data management system are explained based on analysis of plant owners' requirements. A conceptual design of the database is also described with the entity-relationship diagram.

Integrated Water Distribution Network System using the Mathematical Analysis Model and GIS (수리해석 모형과 GIS를 이용한 통합 용수배분 시스템)

  • Kwon, Jae-Seop;Jo, Myung-Hee
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.4 no.4
    • /
    • pp.21-28
    • /
    • 2001
  • In this study, GNLP(GIS linked non-linear network analysis program) for pipeline system analysis has been developed. This GNLP gets the input data for pipeline analysis from existing GIS(geographic information system) data automatically, and has GUI(graphic user interface) for user. Non-Linear Method was used for hydraulic analysis of pipe network based on Hazen-Williams equation, and Microsoft Access of relational database management system(RDBMS) was used for the framework of database applied program. GNLP system environment program was improved so that a pipe network designer can input information data for hydraulic analysis of pipeline system more easily than that of existing models. Furthermore this model generate output such as pressure and water quantities in the form of a table and a chart, and also produces output data in Excel file. This model is also able to display data effectively for analysed data confirmation and query function which is the core of GIS program.

  • PDF

A Study on the Improvement of Specification in connection with Construction Lessons Learned Database (건설공사 지식데이터베이스 연계를 통한 시방서 개선방안)

  • Song Jae-Young;Lee Tai-Sik;Choi Jae-Ho
    • Proceedings of the Korean Institute Of Construction Engineering and Management
    • /
    • autumn
    • /
    • pp.511-514
    • /
    • 2002
  • Nowadays, domestic construction companies make an effort to share knowledge and experience accumulated while conducting a project. One way of improving knowledge sharing is to develop specifications which are linked to the expert's knowledge and experience based on the specification classification. Therefore, the purpose of this paper is to review the current domestic specification system and develop the specification linked to the construction lessons learned database. It is expected that the proposed specification system will support the decision making process by effectively providing the knowledge and solution.

  • PDF