• Title/Summary/Keyword: Database Management Systems

Search Result 1,027, Processing Time 0.033 seconds

Design and Performance Analysis of Welfare Management System based on WSN (WSN 기반 복지 관리 시스템 설계 및 성능분석)

  • Kim, Ji-Seong;Kim, Kang-Hee;Hwang, Ho-Young;Suh, Hyo-Joong
    • Journal of Internet Computing and Services
    • /
    • v.9 no.6
    • /
    • pp.99-107
    • /
    • 2008
  • Wireless sensor networks (WSN) based on low-power technologies become important portion of ubiquitous systems. In this paper, we introduce a WSN-based welfare management system as one of the WSN applications. Especially, we implement S-MAC (Sensor Medium Access control) protocol on our system that saves both cost and power consumption, and we evaluate system performances using the TOSSIM simulator. Sensors and a small database server are placed in the house of participant, which collects and stores some environment conditions of the house. The small servers are connected to each others by wireless ad-hoc network.

  • PDF

Development of the Performance Benchmark Tool for Data Stream Management Systems Combined with DBMS (DBMS와 결합된 데이터스트림관리시스템을 위한 성능 평가 도구 개발)

  • Kim, Gyoung-Bae
    • Journal of the Korea Society of Computer and Information
    • /
    • v.15 no.8
    • /
    • pp.1-11
    • /
    • 2010
  • Many applications of DSMS(Data Stream Management System) require not only to process real-time stream data efficiently but also to provide high quality services such as data mining and data warehouse combining with DBMS(Database Management System) to users. In this paper we execute the performance benchmark of the combined system of DSMS and DBMS that is developed for high quality services. We use the stream data of network monitoring application system and combine the traditional representative DSMSs and DBMSs in a single system for the performance testing. We develop the total performance benchmark tool implementing JAVA language for the our testing. For our performance testing, we combine DSMS such as STREAM and Coral8 and DBMS such MySQL and Oracle10g respectively.

Development of Section Load Estimation Program for Smart Distribution Management System (스마트배전 운영시스템용 구간부하 추정 프로그램 개발)

  • Yun, Sang-Yun;Chu, Chul-Min;Kwan, Seung-Chul;Song, Il-Keun;Lim, Sung-Il
    • The Transactions of The Korean Institute of Electrical Engineers
    • /
    • v.61 no.8
    • /
    • pp.1083-1090
    • /
    • 2012
  • In this paper, we present the section load estimation program of distribution system for smart distribution management system. The proposed program is composed with three parts. One is the consistency check part for switch measurements which consist a section. The consistency check is divided into the current and angle test. For the current test, we examine the input and output power flow for the switch group. For the angle test, the result of power flow calculation at previous step is used. Another is the voltage estimation part for the measured switches. We use the weighted least square (WLS) method for the voltage estimation. The third is the part of final section load calculation. The database structure for accomplishing the developed estimation program is also proposed. To verify the accuracy of the experimental results, case studies are performed using a actual data of Jeju island. The developed program can be effectively applied to the distribution operation systems.

Management Information System of the Nanji Islands National Marine Reserve, China

  • Qingmei, XIAO;Huaguo, ZHANG;Changbao, ZHOU;Weigen, HUANG;Dongling, LI;Junhua, Ten
    • Proceedings of the KSRS Conference
    • /
    • 2003.11a
    • /
    • pp.298-300
    • /
    • 2003
  • A management information system of the Nanji Islands National Marine Reserve is designed and constructed based on method of integration of remote sensing and geographic information system (GIS). The system consists of two sub-systems, dynamic monitoring information system and general database system. The former is used for storage and manage fundamental geographical data (topographical and bathymetric map), satellite remote sensing data (IKONOS, SPOT, IRS, NOAA and SeaWiFS etc.) and multimedia data. The latter is used for storage and manage resource data (shellfish and alga etc.), environmental data (meteorological and hydrologic) and in situ data. As part of electronic government, this system will be submitted to local government for monitoring, management and decision.

  • PDF

Development of Access Management System based on Face Recognition using ResNet (ResNet을 이용한 얼굴 인식 기반 출입관리시스템 개발)

  • Rhyou, Se-Yeol;Kim, Hye-Jin;Cha, Kyung-Ae
    • Journal of Korea Multimedia Society
    • /
    • v.22 no.8
    • /
    • pp.823-831
    • /
    • 2019
  • In recent years, there has been developed systems such as a surveillance system and access control using a face recognition function instead of a password or an RFID chip, thereby reducing the risk of falsification. Moreover, deep learning technology has been applied to real-time face recognition technology in video, so it makes possible the development of access control system that improves the accuracy of recognition and efficiency of management. In this paper, we propose a real-time access management system based on face recognition using ResNet. The system is based on web server, which make it possible to manage the access by recognizing the person of the image through the camera and access information stored in the database. It can be accessed by a user application to receive various information. The implemented system identifies a person in real time and allows access control by accurately distinguishing whether they are members or not, and the test results can recognize in 0.2 seconds. The accuracy of recognition rate is up to about 97% depending on the experiment environment. With this system, access can be managed quickly and effectively, even many people rush to it.

A Design of Feature-based Data Model Using Digital Map 2.0 (수치지도 2.0을 이용한 객체기반 데이터 모델 설계)

  • Lim, Kwang-Hyeon;Jin, Cheng Hao;Kim, Hyeong-Soo;Li, Xun;Ryu, Keun-Ho
    • Journal of the Korea Society of Computer and Information
    • /
    • v.17 no.7
    • /
    • pp.33-43
    • /
    • 2012
  • In With increase of a demand on the spatial data, the need of spatial data model which can effectively store and manege spatial objects becomes more important in many GIS applications. There are many researches on the spatial data model. Several data models were proposed for some special functions, however, there are still many problems in the management and applications. Digital Map is one of spatial data model which is being used in Korea. The existing Digital Map is based on the Tiles. This approach needs more cost in its construction and management. Therefore, in this paper, we propose a feature-based seamless data model with Digital map 2.0 which is based on Tiles. This model can be easily constructed and managed in the large databases so that it is able to apply to any systems. The proposed model uses the relationships between features to correct updated data and the Unique Feature IDentifier(UFID) also makes system to search and manage the feature data more easily and efficiently.

Evaluation of the Input Status of Exposure-related Information of Working Environment Monitoring Database and Special Health Examination Database for the Construction of a National Exposure Surveillance System (국가노출감시체계 구축을 위한 작업환경측정과 특수건강진단 자료의 노출 정보 입력 실태 평가)

  • Choi, Sangjun;Koh, Dong-Hee;Park, Ju-Hyun;Park, Donguk;Kim, Hwan-Cheol;Lim, Dae Sung;Sung, Yeji;Ko, Kyoung Yoon;Lim, Ji Seon;Seo, Hoekyeong
    • Journal of Korean Society of Occupational and Environmental Hygiene
    • /
    • v.32 no.3
    • /
    • pp.231-241
    • /
    • 2022
  • Objectives: The purpose of this study is to evaluate the input status of exposure-related information in the working environment monitoring database (WEMD) and special health examination database (SHED) for the construction of a national exposure surveillance system. Methods: The industrial and process code input status of WEMD and SHED for 21 carcinogens from 2014 to 2016 was compared. Data from workers who performed both work environment monitoring and special health examinations in 2019 and 2020 were extracted and the actual status of input of industrial and process codes was analyzed. We also investigated the cause of input errors through a focus group interview with 12 data input specialists. Results: As a result of analyzing WMED and SHED for 21 carcinogens, the five-digit industrial code matching rate was low at 53.5% and the process code matching rate was 19% or less. Among the data that simultaneously conducted work environment monitoring and special health examination in 2019 and 2020, the process code matching rate was very low at 18.1% and 5.2%, respectively. The main causes of exposure-related data input errors were the difference between the WEMD and SHED process code input systems from 2020, the number of standard process and job codes being too large, and the inefficiency of the standard code search system. Conclusions: In order to use WEMD and SHED as a national surveillance system, it is necessary to simplify the number of standard code input codes and improve the search system efficiency.

Real-time Monitoring Systems for Malodor Compounds Sources using Ubiquitous Sensor Networks (유비쿼터스 센서 네트워크를 이용한 실시간 악취유발물질 배출원의 모니터링 시스템)

  • Lee, Hyung-Don;Lim, Hae-Jin
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.13 no.2
    • /
    • pp.856-865
    • /
    • 2012
  • Maintenance systems are demanded to manage malodor-information and deal effectively with the odor-related civil complaints by constructing the database for sources of malodor compounds in real time. In this paper, to carry out these tasks, a real-time monitering system for malodor based on ubiquitous sensor networks(USN) is presented. The constructed monitering system stores the malodor data collected periodically from industrial complex into the database and shows in real time the circumstances of the odor sources being emitted around the industrial complex by indicating on the map where it is taking place. Besides, by clicking an icon indicating the sensor node on the map, we can figure out what firms are located near the malodor source and possible material related with those firms. The proposed system is considered to enhance the efficiency of management of malodor-emitting firms based on the malodor-related information.

Association-Based Conceptual Modeling for Smart Database Design (스마트 데이터베이스 설계를 위한 연관성 기반 개념적 모형화)

  • Lee, Sang-Won
    • Journal of Intelligence and Information Systems
    • /
    • v.17 no.3
    • /
    • pp.169-185
    • /
    • 2011
  • Data redundancy is problematic in that it not only induces heavy storage management cost but also could bring critical degradation of information systems. Unfortunately, to our knowledge, only few enterprises willingly afford time and efforts for the faithful conceptual design to prevent the degree of inappropriate data as much as they could, while most of enterprises pay rare attention to the notion of that sort of data quality. Wondering if there would be any other way to design the enterprise.wide data design without prior knowledge about business works is our major motivation for this study. In this paper, we present our data modeling methodology in which associations among objects in each sentences of a business job descriptions are treated as the focal point in database design. A proposed agent for automated design tool simply takes a business job description written in natural language as an input, and then designs an entity relationship diagram with some smart rules. We introduce the scope of the proposed agent and its detailed logics with several examples. And then, we verify the appropriateness of the resulted associations among objects. Lastly, we perform case studies to evaluate the devised agent's applicability to a business field.

Identifying Hotspots on Freeways Using the Continuous Risk Profile With Hierarchical Clustering Analysis (계층적 군집분석 기반의 Continuous Risk Profile을 이용한 고속도로 사고취약구간 선정)

  • Lee, Seoyoung;Kim, Cheolsun;Kim, Dong-Kyu;Lee, Chungwon
    • Journal of Korean Society of Transportation
    • /
    • v.31 no.4
    • /
    • pp.85-94
    • /
    • 2013
  • The Continuous Risk Profile (CRP) has been well known to be the most accurate and efficient among existing network screening methods. However, the classical CRP uses safety performance functions (SPFs) which require a huge investment to construct a database system. This study aims to suggest a new CRP method using average crash frequencies of homogeneous groups, instead of SPFs, as rescaling factors. Hierarchical clustering analysis is performed to classify freeway segments into homogeneous groups based on the data of AADT and number of lanes. Using the data from I-880 in California, the proposed method is compared to other several network screening methods. The results show that the proposed method decrease false positive rates while it does not produce any false negatives. The method developed in this study can be easily applied to screen freeway networks without any additional complex database systems, and contribute to the improvement of freeway safety management systems.