• Title/Summary/Keyword: Relational Database Management System

Search Result 186, Processing Time 0.026 seconds

Development of a Patient Monitoring System Overall Architecture and Specifications (환자모니터링시스템의 개발 : 전체구조 및 기본사양)

  • 우응제;박승훈
    • Journal of Biomedical Engineering Research
    • /
    • v.18 no.1
    • /
    • pp.17-24
    • /
    • 1997
  • We have developed a patient monitoring system including module-based bedside monitors, interbed network, central stations, clinical workstations, and DB servers. A bedside monitor with a color LCD can accommodate up to 3 module cases and 21 different modules. Six different physiological parameters of ECG, respiration, invasive blood pressure, noninvasive blood pressure, body temperature, and arterial pulse oximetry with plethysmoyaph are provided as parameter modules. In a single bedside monitor, modules and a module controller communicate with IMbps data rate through an intrabed network based on RS-485 and HDU protocol. At the same time, it communicates with other bedside monitors and central stations through interbed network based on 1 OMbps Ethernet and TCP/IP protocol. Central stations using 20" color CRT monitors can be connected with many bedside monitors and they display 18 channels of waveforms simultaneously. Clinical workstations are used mainly for the review of patient datE In order to accommodate more advanced data management capabilities such as 24-hour full disclosure, we have developed a relational database server dedicated to the patient monitoring system. Software for bedside monitor, central station, and clinical workstation fully utilizes graphical user interface techniques and all functions are controlled by a rotate/push button on the bedside monitor arid a mouse on the central station and clinical workstation. The entire system satisfies the requirements of AAMI and ANSI standards in terms of electrical safety and performances.nces.

  • PDF

Efficient Management of Statistical Information of Keywords on E-Catalogs (전자 카탈로그에 대한 효율적인 색인어 통계 정보 관리 방법)

  • Lee, Dong-Joo;Hwang, In-Beom;Lee, Sang-Goo
    • The Journal of Society for e-Business Studies
    • /
    • v.14 no.4
    • /
    • pp.1-17
    • /
    • 2009
  • E-Catalogs which describe products or services are one of the most important data for the electronic commerce. E-Catalogs are created, updated, and removed in order to keep up-to-date information in e-Catalog database. However, when the number of catalogs increases, information integrity is violated by the several reasons like catalog duplication and abnormal classification. Catalog search, duplication checking, and automatic classification are important functions to utilize e-Catalogs and keep the integrity of e-Catalog database. To implement these functions, probabilistic models that use statistics of index words extracted from e-Catalogs had been suggested and the feasibility of the methods had been shown in several papers. However, even though these functions are used together in the e-Catalog management system, there has not been enough consideration about how to share common data used for each function and how to effectively manage statistics of index words. In this paper, we suggest a method to implement these three functions by using simple SQL supported by relational database management system. In addition, we use materialized views to reduce the load for implementing an application that manages statistics of index words. This brings the efficiency of managing statistics of index words by putting database management systems optimize statistics updating. We showed that our method is feasible to implement three functions and effective to manage statistics of index words with empirical evaluation.

  • PDF

NoSQL-based User Behavior Detection System in Cloud Computing Environment (NoSQL 기반 클라우드 사용자 행동 탐지 시스템 설계)

  • Ahn, Kwang-Min;Lee, Bong-Hwan
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2012.10a
    • /
    • pp.804-807
    • /
    • 2012
  • Cloud service provider has to protect client's information securely since all the resources are offered by the service provider, and a large number of users share the resources. In this paper, a NoSQL-based anomaly detection system is proposed in order to enhance the security of mobile cloud services. The existing integrated security management system that uses a relational database can not be used for real-time processing of data since security log from a variety of security equipment and data from cloud node have different data format with unstructured features. The proposed system can resolve the emerging security problem because it provides real time processing and scalability in distributed processing environment.

  • PDF

Block-wise Skipping for Embedded Database System (임베디드 데이터베이스 시스템을 위한 블록 단위 스키핑 기법)

  • Chong, Jae-Hyok;Park, Hyoung-Min;Hong, Seok-Jin;Shim, Kyu-Seok
    • The KIPS Transactions:PartD
    • /
    • v.16D no.6
    • /
    • pp.835-844
    • /
    • 2009
  • Today, most of all the query processors in the world generally use the 'Pipelining' method to acquire fast response time (first record latency) and less memory usage. Each of the operator nodes in the Query Execution Plan (QEP) provides Open(), Next(), and Close() functions for their interface to facilitate the iterator mechanism. However, the embedded database systems for the mobile devices, based on the FLASH memory, usually require a function like Previous(), which returns the previous records from current position. It is because that, in the embedded environment, the mobile devices cannot fully provide it main memory to store all the query results. So, whenever needed the previously read records the user (program) should re-fetch the previous records using the Previous() function: the BACKWARD data fetch. In this paper, I introduce the 'Direction Switching Problem' caused by the Previous() function and suggest 'Block-wise Skipping' method to fully utilize the benefits of the block-based data transfer mechanism, which is widely accepted by most of the today's relational database management systems.

Development of Storage Techniques for PDTnet XML Schema Data (PDTnet XML Schema 데이터를 위한 저장 기법 개발)

  • Lee, Kyoung-Hye;Yong, Hwan-Seung;Lee, Wol-Young
    • Journal of Korea Multimedia Society
    • /
    • v.9 no.8
    • /
    • pp.939-949
    • /
    • 2006
  • With the development of industry, product data management system is becoming more and more important. An expanded view of product definition function that include a bill of material and routing database, current and historical engineering data and specifications and engineering changes order history. PDM (Product Data Management) systems hold and manage such material as product specifications, plans, geometric models, CAD drawings and images. Furthermore, PDM enables companies producing complex products to spread product data in to the entire launch process. Especially, PDTnet XML Schema is an international standard for exchanging of PDM data. But PDTnet XML Schema differs from existing XML Schema in the way that its property of IDREF/IDREFS is irregular. Therefore it is important factor that. what do we use storage devices and storage techniques. We developed storage techniques and application supporting various query types and preserving PDTnet XML Schema using a relational database that guaranteeing the performance nowadays. In this paper, we will show that our storage techniques minimize repeated data and optimize query processing by using application comparison with storage techniques of existing XML Schema data.

  • PDF

A Graph Model of Heterogeneous IoT Data Representation : A Case Study from Smart Campus Management (이종 IoT 데이터 표현을 위한 그래프 모델: 스마트 캠퍼스 관리 사례 연구)

  • Nguyen, Van-Quyet;Nguyen, Huu-Duy;Nguyen, Giang-Truong;Kim, Kyungbaek
    • Proceedings of the Korea Information Processing Society Conference
    • /
    • 2018.10a
    • /
    • pp.984-987
    • /
    • 2018
  • In an Internet of Thing (IoT) environment, entities with different attributes and capacities are going to be connected in a highly connected fashion. Specifically, not only the mechanical and electronic devices but also other entities such as people, locations and applications are connected to each other. Understanding and managing these connections play an important role for businesses, which identify opportunities for new IoT services. Traditional approach for storing and querying IoT data is used of a relational database management system (RDMS) such as MySQL or MSSQL. However, using RDMS is not flexible and sufficient for handling heterogeneous IoT data because these data have deeply complex relationships which require nested queries and complex joins on multiple tables. In this paper, we propose a graph model for constructing a graph database of heterogeneous IoT data. Graph databases are purposely-built to store highly connected data with nodes representing entities and edges representing the relationships between these entities. Our model fuses social graph, spatial graph, and things graph, and incorporates the relationships among them. We then present a case study which applies our model for representing data from a Smart Campus using Neo4J platform. Through the results of querying to answer real questions in Smart Campus management, we show the viability of our model.

Design and Implementation of the Video Data Model Based on Temporal Relationship (시간 관계성을 기반으로 한 비디오 데이터 모델의 설계 및 구현)

  • 최지희;용환승
    • Journal of Korea Multimedia Society
    • /
    • v.2 no.3
    • /
    • pp.252-264
    • /
    • 1999
  • The key characteristic of video data is its spatial/temporal relationships. In this paper, we propose an content based video retrieval system based on hierarchical data structure for specifying the temporal semantics of video data. In this system, video data's hierarchical structure temporal relationship, inter video object temporal relationship, and moving video object temporal relationship can be represented. We also implemented these video data's temporal relationship into an object-relational database management system using inheritance, encapsulation function overloading, etc. So more extended and richer temporal functions can be used to support a broad range of temporal queries.

  • PDF

Fatigue Life Evaluation and Optimization for District Heating Pipes Considering Operating Temperature Transition Data (운전이력을 고려한 지역난방 열배관의 피로수명 평가 및 최적화)

  • Ahn M.Y.;Jung S.W.;Lee S.M.;Chang Y.S.;Choi J.B.;Kim Y.J.;Kim S.H.;Kim Y.H.
    • Proceedings of the Korean Society of Precision Engineering Conference
    • /
    • 2005.06a
    • /
    • pp.581-584
    • /
    • 2005
  • A district heating(DH) system supplies environmentally-friend heat and is appropriate for reduction of energy consumption and/or air pollutions. The objectives of this paper are to systematize data processing of transition temperature, investigate its effects on fatigue life of DH pipes and optimization for size of DH pipes. A relational database management system as well as reliable fatigue life evaluation procedures is established for Korean DH pipes. Also, since the prototypal evaluation results satisfied both cycle-based and stress-based fatigue criteria. Through the optimum design process, the cross section diminished 18.64% and the CUF diminished 23.35%. So, it can be used as useful information in the future for optimal design, operation and energy saving via setting of efficient condition and stabilization of water temperature.

  • PDF

Development of Geophysical Data Management System (물리탐사자료 데이터베이스 시스템 구축 연구)

  • Lee, Tai-Sup;Hwang, Hak-Soo;Sun, Hee-Duck;Koo, Sung-Bon;Song, Yaung-Soo
    • Geophysics and Geophysical Exploration
    • /
    • v.3 no.1
    • /
    • pp.25-32
    • /
    • 2000
  • The geophysical data management system was developed to meet both the increasing demands of geophysical data in the practical application of civil engineering, underground water survey, and environmental problems and needs for digital archive and quality control of geophysical data. The system for a data manager is developed under Client/Server (C/S) environment. This manager system is characterized by a relational geophysical database system using MS SQL-server, standardization of geophysical data format, the development of C/S interface program for Windows environment, and the development of transfer program module for the searched data. The system developed for a general user under the internet environment is characterized by Web service (URL:http//geophy.kigam.re.kr) and the development of plug-in module to visualize geophysical image data.

  • PDF

Construction of an Effective Web-based Change Management System (웹 기반의 효과적인 변경관리 시스템 구축)

  • Yoo Jae-Soo;Cho Chang-Hee;Lee Byoung-Yup
    • The Journal of the Korea Contents Association
    • /
    • v.5 no.4
    • /
    • pp.11-19
    • /
    • 2005
  • With the development of IT technologies, IT environment is making great change over life whole and is displacing business and business achievement systems of industry at the fast speed. The system which is proposed in this paper, supports environments to share codes, execution files and objects between project teams to maximize productivity and efficiency in web environments. Through impact assessment which is achieved at correction and development of existing programming codes by maintenance requirements, it minimizes obstacle occurrence factors and supports tracing obstacle sources. Through conversion the correction and development histories of existing sources and executable files between project teams to XML documents suitable to share in web, it stores them to relational database. In this paper, through impact assessment and change management for the correction and development of applications in the existing system development environments, we support efficient IT developments.

  • PDF