• Title/Summary/Keyword: DB design

Search Result 842, Processing Time 0.027 seconds

Dashboard Design for Evidence-based Policymaking of Sejong City Government (세종시 데이터 증거기반 정책수립을 위한 대시보드 디자인에 관한 연구)

  • Park, Jin-A;An, Se-Yun
    • The Journal of the Korea Contents Association
    • /
    • v.19 no.12
    • /
    • pp.173-183
    • /
    • 2019
  • Sejong, Korea's special multifunctional administrative city, was created as a national project to relocated government ministries, the aim being to pursue more balanced regional economic development and boost national competitiveness. During the second phase development will focus on mitigating the challenges raised due to the increasing population and urbanization development. All of infrastructure, apartments, houses, private buildings, commercial structures, public buildings, citizens are producing more and more complex data. To face these challenges, Sejong city governments and policy maker recognizes the opportunity to ensure more enriched lives for citizen with data-driven city management, and effectively exploring how to use existing data to improve policy services and a more sustainable economic policy to enhance sustainable city management. As a city government is a complex decision making system, the analysis of astounding increase in city dada is valuable to gain insight in the affecting traffic flow. To support the requirement specification and management of government policy making, the graphic representation of information and data should be provide a different approach in the intuitive way. With in context, this paper outlines the design of interactive, web-based dashboard which provides data visualization regarding better policy making and risk management.

The Design of Manufacturing Simulation Modeling Based on Digital Twin Concept (Digital Twin 개념을 적용한 제조환경 시뮬레이션 모형 설계)

  • Hwang, Sung-Bum;Jeong, Suk-Jae;Yoon, Sung-Wook
    • Journal of the Korea Society for Simulation
    • /
    • v.29 no.2
    • /
    • pp.11-20
    • /
    • 2020
  • As the manufacturing environment becomes more complex, traditional simulation models alone are having a lot of difficulties in reflecting real-time manufacturing situations. Although the Digital Twin concept is actively discussed as an alternative to overcome theses issues, many studies are being carried out only in the product design phase. This research presents a Digital Twin-based manufacturing environment framework for applying the Digital Twin concept to the manufacturing process. Twin model that is operated in virtual space, physical system and databases describing the actual manufacturing environment, are proposed as detailed components that make up the framework. To check the applicability of proposed framework, a simple Digital Twin-based manufacturing system was simulated in a conveyor system using Arena software and Excel VBA. Experiment results have shown that the twin model is transmitted real time data from the physical system via DB and were operating in the same time unit. The Excel VBA fitted parameters defined by cycle time based on historical data that real-time and training data are being accumulated together. This study proposes operating method of digital twin model through the simple experiment examples. The results lead to the applicability of Digital twin model.

A Study on the Evaluation and Analysis of Convenient Facilities in Social Welfare Hall through Consideration of the Disabled Person Use (장애인 이용을 고려한 사회복지관 편의시설 평가 및 분석에 관한 연구)

  • Jung, Rye-Hwa;Lee, Wan-Geon
    • Korean Institute of Interior Design Journal
    • /
    • v.18 no.3
    • /
    • pp.114-121
    • /
    • 2009
  • The number of the disabled is increasing every year. Growing interest in social welfare, but still the disabled person in places is restricted on the activities are due to obstacles. This study proposes an improvement direction through an research and analysis of installation status of convenient facilities in social welfare halls was planned after that the law of increase of convenience for the disabled person is enforced in 1998. This study analyzed nine social welfare halls of seoul including Yongsan-gu(GW), Guro-gu(GD, HW), Yeongdeungpo-gu(SG), Seodaemun-gu(SD), Dobong-gu(DB), Nowon-gu(NS), Seongbuk-gu(WG) and Dongdaemun-gu(JG). The evaluation criteria for the installation of convenient facilities for the disabled person in each social welfare hall based on the law of increase of convenience for the disabled person, and referred to other data. Also, review the criteria for the installation of convenient facilities, and grasp the present situation through the survey of convenient facilities in social welfare halls, and provides the installation standards of convenient facilities. The result are as followings. There were many problems to be improved in approach of the intermediate space, parking lot, entrance of the inside space and corridor that must be installed for the convenience of the disabled. In the intermediate space, the slope of the ramp, curb, induction handle etc. for a safety must be installed. Parking spaces for the disabled must be located closest to the main entrance, an induction marker or the handle, and the attachment of a directional sign etc. must be improved. In the inside space, it is convenient for the disabled person use to install an automatic door and swing door simultaneously at the main entrance. And, the height of the door handle, an induction block, a braille display panels of the appropriate height in the entrance, a braille display in start and end of the stairs handle, the handle of the side wall, the stairs to prevent slippage etc. must be improved in the corridors. The case of the sanitation which is a recommendation item is equipped formally with disabled toilets are difficult to use. Information and other convenience facilities for the disabled person in all the social welfare halls were not considered.

Effect of Multyparty Contract in IPD Project Case study of USA and Korean Projects (IPD 계약은 IPD 프로젝트의 필수조건인가 - 국내외 사례조사를 통하여 -)

  • Yoo, Seungeun;Kim, Taewan;Yu, Jungho
    • Korean Journal of Construction Engineering and Management
    • /
    • v.18 no.1
    • /
    • pp.3-16
    • /
    • 2017
  • Integrated project delivery (IPD) is suggested as an alternative to traditional delivery methods such as design-build (DB), design-bid-build (DBB), and construction management at risk (CMR). Many foreign research studies have approached IPD not only in the contractual aspect but also the work implementation method aspect. However, most research projects in Korea have focused on the contractual aspect of IPD for asserting that the characteristics are the critical matter. The Korean institutional and legal system does not permit the multi-party agreement; therefore, it is difficult to adopt IPD in Korea's construction industry. The researchers do not wait the system to be changed, but we do identify the possibility of adopting IPD in Korea in the perspective of work implementation method, except the contractual characteristics. Thus, the goal of this research is to identify one project that does not include IPD agreement but utilizes other IPD characteristics whose contractual results have similar performance to those that utilize all characteristics of IPD including agreement. This research is expected to enhance performance of the construction project in a Korean construction environment by embracing IPD characteristics as overcoming limits and bounds of the traditional delivery method.

A Study on OLE/COM-based GIS Data Provider Component Development Toward Application System Development (응용시스템 구축을 위한 OLE/COM 기반의 GIS 데이터 제공자 컴포넌트 시스템에 관한 연구)

  • 김민수;김광수;오병우;이기원
    • Spatial Information Research
    • /
    • v.7 no.2
    • /
    • pp.175-190
    • /
    • 1999
  • Recently , as GIS technology is rapidly improved and stabilized, there are some needs to reuse pre-developed and powerful GIS technology. GIS standardization based on components and open interfaces becomes a way to solve those reusability of previous GIS technology. This GIS standardization currently focuses on building the GIS Data Infrastructure that is being deployed globally. Especially, OpenGIS consortium which is mainly made up of international GIS leading vendors is announcing some GIS abstract specifications and implementation specifications. This study focuses on how could we design and implement the OLE/COM-based data provider component based on various DBMS or file systems, how could these data provider components be used for enterprise UIS(Urban Information Systems) and how could various formatted GIS data be shared in one system. Also some problems practically caused by an implementation process of data provider component are listed up and some solutions are given. Furthermore, design and analysis of UML(Unified Modeling Language) was reformed through the data provider component development task and this UML methodology is able to indicate a standardized model for newly developed data provider component.

  • PDF

A Study on Design of Annotation Database for Visible Human (인체영상 어노테이션 DB 설계에 관한 연구)

  • Ahn, bu-young;Lee, seung-bock;Han, Geon;Lee, sang-ho
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2008.05a
    • /
    • pp.819-822
    • /
    • 2008
  • As the IT and computer network technology is developed very rapidly, the quantity of digital contents is increased and disseminated more widely. The digital contents is generally expressed in 2 or 3 dimensional multimedia format and the visible human image that is taken from human body is very important because of its variety of usefulness. The KISTI(Korea Institute of Science and Technology Information) is now constructing various Korean human informations such as visible Korean, digital Korean, human bone property and human models. These informations are accessable through the internet. However, these human images are not easily understandable for general users because they are specialized in medical image field and there is no detailed explanation data. In this study, we designed the annotation database and searching interface for KISTI's visible Korean database. This annotation database involved the detailed explanation and special note of visible Korean data and it can connect the image and text data of visible Korean with each other. By studying this database and interface design, the KISTI's visible Korean database is more easily accessable and understandable to general users and it can promote the usage of visible Korean data more widely.

  • PDF

A Design and Implementation of Chick Incubation System Based on IoT

  • Sejong Lee;Sol Lee
    • Journal of the Korea Society of Computer and Information
    • /
    • v.29 no.9
    • /
    • pp.179-186
    • /
    • 2024
  • In this paper, we design and implement an Internet of Things (IoT)-based chick incubation system. The system consists of three key components: the IoT incubator, the IoT server system, and the smartphone application. The IoT incubator is composed of an Arduino board, temperature and humidity sensors, a temperature and humidity controller, a ventilation controller, and an egg turning controller. The temperature and humidity sensors measure the temperature and humidity inside the IoT incubator and send the data to the temperature and humidity controller on the Arduino board. Additionally, it provides the function of transmitting temperature, humidity, and control history data to the IoT server via WiFi. It also offers automatic control of ventilation, egg turning, and temperature and humidity on a daily basis. The IoT server system receives data from the incubator, stores it in a database, and provides query data upon request from the smartphone. The smartphone application retrieves historical data through the server and monitors the temperature and humidity data of the IoT incubator in real-time, controlling the IoT incubator to ensure that the set temperature and humidity ranges are maintained. If the temperature and humidity data deviate from the set ranges, it sends alarms and emergency messages to the user. The IoT-based chick incubation system developed in this paper is a low-cost model due to its reduced manufacturing cost, making it highly beneficial for self-sustaining poultry farms.

Comparison of the Awareness of Garden Functions (정원 기능에 대한 인식 비교)

  • Park, Mi-Ok;Choi, Ja-Ho;Koo, Bon-Hak
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.48 no.2
    • /
    • pp.34-44
    • /
    • 2020
  • The purpose of this study was to investigate the difference in perceptions between gardens and park functions as recognized by two groups, Group A and Group B, in order to confirm the distinction between concepts and functions and then establish the importance of individual functions. The AHP was used to analyze the importance of each group's perceptions by dividing them into garden and park, Group A and non-Group A, respectively. In Group A, the importance of garden functions were considered in descending order of importance to be cultural function, ecological function, and social function. In the general group, ecological function, cultural function, and social function also appeared, but in a different order of importance. As for the park functions, Group A recognized the importance of functions in a similar order of importance to the gardens: cultural function, ecological function, and social function. Group B thought that social function, ecological function, and cultural function have the same significance. At the major classification level, Group A and Group B emphasized the social function of the parks. Group A recognized the importance of the garden's cultural function as the most important, whereas the general group emphasized the importance of the garden's ecological function. As for the mid-class level, Group A recognized the aesthetic beauty, health, ecological environment protection, and water circulation as important functions of the garden. For Group B, the ecological environment protection, aesthetic beauty, water cycle, and health were important. The concepts and functions of gardens and parks are still largely mixed but are gradually becoming differentiated. As a follow-up study, it is important to systematically manage the functions of gardens by establishing design, construction, and monitoring DB techniques for the garden type and examine the hierarchy of various other gardens.

Establishment of A WebGIS-based Information System for Continuous Observation during Ocean Research Vessel Operation (WebGIS 기반 해양 연구선 상시관측 정보 체계 구축)

  • HAN, Hyeon-Gyeong;LEE, Cholyoung;KIM, Tae-Hoon;HAN, Jae-Rim;CHOI, Hyun-Woo
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.24 no.1
    • /
    • pp.40-53
    • /
    • 2021
  • Research vessels(R/Vs) used for ocean research move to the planned research area and perform ocean observations suitable for the research purpose. The five research vessels of the Korea Institute of Ocean Science & Technology(KIOST) are equipped with global positioning system(GPS), water depth, weather, sea surface layer temperature and salinity measurement equipment that can be observed at all times during cruise. An information platform is required to systematically manage and utilize the data produced through such continuous observation equipment. Therefore, the data flow was defined through a series of business analysis ranging from the research vessel operation plan to observation during the operation of the research vessel, data collection, data processing, data storage, display and service. After creating a functional design for each stage of the business process, KIOST Underway Meteorological & Oceanographic Information System(KUMOS), a Web-Geographic information system (Web-GIS) based information platform, was built. Since the data produced during the cruise of the R/Vs have characteristics of temporal and spatial variability, a quality management system was developed that considered these variabilities. For the systematic management and service of data, the KUMOS integrated Database(DB) was established, and functions such as R/V tracking, data display, search and provision were implemented. The dataset provided by KUMOS consists of cruise report, raw data, Quality Control(QC) flagged data, filtered data, cruise track line data, and data report for each cruise of the R/V. The business processing procedure and system of KUMOS for each function developed through this study are expected to serve as a benchmark for domestic ocean-related institutions and universities that have research vessels capable of continuous observations during cruise.

Exhibition Hall Lighting Design that Fulfill High CRI Based on Natural Light Characteristics - Focusing on CRI Ra, R9, R12 (자연광 특성 기반 고연색성 실현 전시관 조명 설계 - CRI Ra, R9, R12를 중심으로)

  • Ji-Young Lee;Seung-Teak Oh;Jae-Hyun Lim
    • Journal of Internet Computing and Services
    • /
    • v.25 no.4
    • /
    • pp.65-72
    • /
    • 2024
  • To faithfully represent the intention of the work in the exhibition space, lighting that provides high color reproduction like natural light is required. Thus, many lighting technologies have been introduced to improve CRI, but most of them only evaluated the general color rendering index (CRI Ra), which considers eight pastel colors. Natural light provides excellent color rendering performance for all colors, including red and blue, expressed by color rendering index of R9 and R12, but most artificial lighting has the problem that color rendering performance such as R9 and R12 is significantly lower than that of natural light. Recently, lighting technology that provides CRI at the level of natural light is required to realistically express the colors of works including primary colors but related research is very insufficient. Therefore this paper proposes exhibition hall lighting that fulfills CRI with a focus on CRI Ra, R9, and R12 based on the characteristics of natural light. First reinforcement wavelength bands for improving R9 and R12 are selected through analysis of the actual measurement SPD of natural and artificial lighting. Afterward virtual SPDs with a peak wavelength within the reinforcement wavelength band are created and then SPD combination conditions that satisfy CRI Ra≥95, R9, and R12≥90 are derived through combination simulation with a commercial LED light source. Through this, after specifying two types of light sources with 405,630nm peak wavelength that had the greatest impact on the improvement of R9 and R12, the exhibition hall lighting applied with two W/C White LEDs is designed and a control Index DB of the lighting is constructed. Afterward experiments with the proposed method showed that it was possible to achieve high CRI at the level of natural light with average CRI Ra 96.5, R9 96.2, and R12 94.0 under the conditions of illuminance (300-1,000 Lux) and color temperature (3,000-5,000K).