• Title/Summary/Keyword: Integrated DB Management System

Search Result 114, Processing Time 0.023 seconds

Developing dirty data cleansing service between SOA-based services (SOA 기반 서비스 사이의 오류 데이터 정제 서비스 개발)

  • Ji, Eun-Mi;Choi, Byoung-Ju;Lee, Jung-Won
    • The KIPS Transactions:PartD
    • /
    • v.14D no.7
    • /
    • pp.829-840
    • /
    • 2007
  • Dirty Data Cleansing technique so far have aimed to integrate large amount of data from various sources and manage data quality resided in DB so that it enables to extract meaningful information. Prompt response to varying environment is required in order to persistently survive in rapidly changing business environment and the age of limitless competition. As system requirement is recently getting complexed, Service Oriented Architecture is proliferated for the purpose of integration and implementation of massive distributed system. Therefore, SOA necessarily needs Data Exchange among services through Data Cleansing Technique. In this paper, we executed quality management of XML data which is transmitted through events between services while they are integrated as a sole system. As a result, we developed Dirty Data Cleansing Service based on SOA as focusing on data cleansing between interactive services rather than cleansing based on detection of data error in DB already integrated.

Research of Quality Improvement by Factors Analysis Data Quality Problem:Focus on National R&D Information Linking Structure (품질문제 요인분석을 통한 데이터 품질 개선방안 연구:국가R&D정보연계 방식 중심)

  • Shon, Kang-Ryul;Lim, Jong-Tae
    • The Journal of the Korea Contents Association
    • /
    • v.9 no.1
    • /
    • pp.1-14
    • /
    • 2009
  • A currently domestic governmental R&D business is early to 100. And this is each managed individually in 15 professional organizations of research and management by characteristics of a business. For this Reason, A redundant investment issue regarding national R&D occurs, and an issue regarding efficiency of R&D investment by insufficiency of systematic R&D research project and result management is continuously raised. Ministry of Education Science and Technology establishing National Science & Technology Information Service(NTIS) in order to solve these issues. NTIS is the national R&D Portal System which can support efficiency of research and development to result utilization in planning of national research and development. In this paper We consider integrated DB constructions and Information Linking of R&D Participants/Projects/Results information in a NTIS system for data quality Improvement. and then We analyze the cause of the data quality problem, and we propose the improvement plan for data quality elevation of NTIS system.

Design of Standard Submission Format for Underground Structures : An Automated Update of the UnderSpace Integrated Map (지하공간통합지도 자동갱신을 위한 지하구조물 제출 표준 설계)

  • Park, Dong Hyun;Jang, Yong Gu;Ryu, Ji Song
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.39 no.6
    • /
    • pp.469-476
    • /
    • 2021
  • The framework plan for the development of an integrated underground space map was established of preventing ground subsidence. The mapping process is expected to be completed to the level of nationwide municipal government standards by end of this year. To facilitate the utilization of the integrated underground space map, paper-based drawings for specialized organizations in underground safety impact assessment have been provided since September 2018, and services for local government officials have been provided in the underground information utilization system since May 2019. However, the map is utilized based on the information at the time of the initial development of the map, without any updates, thereby resulting in a lack of accuracy and latest information. This has led to a decrease in the utilization and reliability of the information. Therefore, in this study, for the underground structures(subway, underground shopping mall, underground passage, underground roadway, underground parking lot, utility tunnel), which are the key components of the integrated underground space map, a standard format for the submission of completed drawings is designed in accordance with Article 42 (2) of the Special Act on Underground Safety Management, which aims at laying the foundation for establishing the updated system of the integrated underground space map. In addition, through the verification of the automatically updated underground structure data based on the standard format, the reliability of the data can be assured. This format is expected to contribute to the improved utilization of the integrated underground space map in the future.

Establishment Construction Enterprise Resource Planning(ERP) & Construction Information Sttategy (건설정보화 전략과 ERP구축)

  • Lee Min-Nam;Oh Dong-Hwan
    • Proceedings of the Korean Institute Of Construction Engineering and Management
    • /
    • autumn
    • /
    • pp.164-170
    • /
    • 2003
  • This paper is to evaluate the informational direction, current situations and ERP establishment concerning constructing industry, to present the right directions, implemented cases for implementing constructional ERP, also to suggest the effect, influence, problems and shootings in constructional ERP arena. The constructing industries in korea are facing great turning point because of the huge corruptions currently happened and forcing to open the market in 1997. Attempting to establish Computer Integrated construction system (ERP) by breaking down constructing cost, improving quality, operating rapid and effective construction to enhance productivity, it is hard to achieve the goal with only inter-contractor's establishment. Constructing industries are integrated ones, consisted of many organizations for instance ordering agencies, contractors, subcontractors, material vendors, etc. and use various information formats such as texts, graphics, drawings. I dare suggest that implementation of constructional CALS including EDI/EC, GIS is tile only solution to control the information systematically generated in whole stages from planing, designing, constructing through maintenance, and to supply or switch the information.

  • PDF

Development of VR Monitoring System for Gas Plant (가상현실을 이용한 가스플랜트의 VR Monitoring System 개발)

  • Suh, Myung-Won;Cho, Ki-Yang;Park, Dae-You
    • Proceedings of the KSME Conference
    • /
    • 2001.06c
    • /
    • pp.213-218
    • /
    • 2001
  • VR (Virtual reality) technologies have given engineers the ability to design, test, and evaluate engineering systems in a virtual environment. The virtual plant is the highlight of the application of the VR technology to plant engineering. Plant design, maintenance, control, management, operation are integrated in the virtual plant. The VR monitoring system including the concept of the virtual plant is developed to replace a current control room that has number of gages and warning lamps in two-dimensional panels which shows the operating status of a plant. The operating status of the plant is displayed in the VR monitoring system through the realistic computer graphics. Sophisticated, realistic and prompt control becomes possible. The VR monitoring system consists of advanced visualization, walk-through simulation and navigation. In the virtual environment, a user can navigate and interact with each component of a plant. In addition, the user can access the information by just clicking interesting component. The VR monitoring system is operated with various modules, such as (1) virtual plant constructed with Graphic Management System (GMS), (2) Touch & Tell System, and (3) Equipment DB System of Part. In order to confirm the usefulness of the VR monitoring system, a pilot gas plant which is currently being used for plant operator training is taken as application. The end of the paper gives an outlook on the future work and a brief conclusion.

  • PDF

A Study on Designing the Metadata for Integrated Management of Individually Managed Presidential Records (개별관리 대통령기록물의 연계관리를 위한 통합 메타데이터 설계 방안 연구)

  • Cho, Hyun-Yang;Jang, Bo-Seong
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.47 no.1
    • /
    • pp.105-124
    • /
    • 2013
  • Metadata standardization of resources, having a heterogeneous metadata structure for each presidential archive and presidential library and museum is preferentially required for utilizing and sharing presidential records. An integrated operation model of metadata to manage various types of presidential records is then needed. The purpose of this study is to create a design principle of integrated metadata, and to suggest relationships and attributes of metadata, needed for developing integrated metadata operation system on presidential records. The design principle includes "creation of relationship among presidential records", "design of each entity, applicable multiple entity data model", "design to describe various types of presidential records", "design to reflect lifelong management on records of holding institutes", and "designing hybrid metadata for long term preservation". Metadata element set consists of elements for common attributes with all types of presidential records for a unique attribute for a specific presidential record and for reference information among different records related to the production of presidential records.

Runoff Characteristics using RRFS on Geum River Basin (RRFS에 의한 금강유역의 유출특성)

  • Maeng, Seung-Jin;Lee, Hyeon-Gyu;Hwang, Man-Ha;Koh, Ick-Hwan
    • Proceedings of the Korea Contents Association Conference
    • /
    • 2006.11a
    • /
    • pp.408-412
    • /
    • 2006
  • Growing needs for efficient management of water resources urge integrated management of whole basin. As one of the tools for supporting above tasks, this study aims to indicate a hydrologic model that can simulate the streamflow discharges at some control points located both upper and down stream of dams. For the development and utilization of non analysis model, relevant basin information including historical precipitation and river water stage data, geophysical basin characteristics, and water intake and consumptions needs to be collected and stored into the hydrologic database of Integrated Real-Time Water Information System. The well-known SSARR model was selected for basis of continuous daily runoff model for forecasting short and long-term national river flows in this paper.

  • PDF

Build on Integrated Operation·Management System of Disaster Management Regulations (방재심의제도 통합 운영·관리 체계 구축)

  • Jung, Do Joon;Joo, Jae Seung
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2015.05a
    • /
    • pp.644-644
    • /
    • 2015
  • 최근 국가적 차원에서 자연재해대책법에 근거한 여러 방재심의제도를 운영하고 있다. 그 중 최상위 계획인 풍수해저감종합계획을 통하여 저감대책을 마련하고, 위험지구에 대한 대책과 사업을 시행중에 있다. 그러나 방재업무를 진행하는 중앙부처와 지자체, 방재대행업체자 등에서는 심의보고서간의 자료공유와 접근성이 미약하고 잦은 담당자 변경으로 인한 심의보고서 보관과 관리가 힘든 실정이다. 또한 제도간의 연계와 환류기능이 미흡하여 제도별로 산재되어 있는 부분이 많으므로 통합적으로 관리할 수 있는 운영체계가 필요하다. 따라서 본 연구에서는 풍수해 방재심의제도를 통합적으로 운영하고 관리하기 위한 시스템을 구축하는 것이 최종 목표이며, 이를 위해 우선적으로 풍수해저감종합계획 수립제도를 시범적으로 적용하여 운영 관리할 수 있는 시스템 기반을 마련하였다. 또한, 향후에 있을 방재심의제도별 통합적인 운영을 위해 선제적으로 재해위험지구 정비사업과 구성항목의 데이터 연계성을 분석하였으며, 이를 바탕으로 제도별 연계 시스템을 설계하여 제시하였다.

  • PDF

A Study on Construction of Management System for Efficient Management and Application of Regional Development Project (지역개발사업의 효율적 관리 및 활용을 위한 관리체계 구축에 관한 연구)

  • Kim, Nam-Jung
    • Land and Housing Review
    • /
    • v.7 no.1
    • /
    • pp.1-8
    • /
    • 2016
  • This research has its objective in searching for a management plan that is stronger than existing plan for the regional development project in time for the execution of "Regulations on Regional Development and Support". Accordingly, the following plans for improvement are suggested to make improvements in lack of regional development projects management awareness; absence of integrated management system; and lack of reliability in project management information. Firstly, the management of regional development project needs to be operated as a system for project evaluation management based on related legislations. Secondly, various information of regional development project should construct a database, which becomes an information system that can be utilized by the central government and regional governing organizations. Third, to promote efficiency in regional development project management and expertise, it is necessary to prepare a project management system utilizing professional outsourcing organizations and such. Lastly, it is necessary to improve the work environment to enhance the expertise and the responsibilities of those government officials in charge of the project.

A Strategy on Integrated Data Base Construction and Management of Global Water Resource Information System (글로벌 수자원 정보 시스템 통합 DB 구축 및 관리방안 연구)

  • Gwon, Yong Hyeon;Lee, Kyoung Do;Lee, Byong Ju
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2018.05a
    • /
    • pp.375-375
    • /
    • 2018
  • 세계 수자원 시장은 연평균 6.5%씩 증가하고 있으며, 2025년 기준 1,038조원까지 급성장할 것으로 전문가들은 예상하고 있으나, 기후변화의 가속화로 인해 가뭄 및 홍수피해가 증가하여 수자원 관리가 더욱 어려워져지고 있다. 급속도로 변화는 환경에 대비하기 위해 국내에서는 수자원 및 기후변화에 대한 다양한 연구가 진행되고 있으나, 해외사업 진출 시에는 수자원 기초자료 수집에 대한 어려움을 겪고 있다. 이를 해결하기 위해 글로벌 수문기상자료 제공과 함께 GIS정보, 댐 및 저수지 관련 자료, 인문사회 자료, 물관련 통계자료, 물관련 재해자료 등을 웹으로 제공하는 글로벌 수자원 정보 시스템(GWB, Global World Bank)을 개발하고자 한다. 본 연구에서는 시스템의 통합 DB를 구축하고 관리방안을 도출하기 위해 수집된 메타데이터 속성 및 데이터구조를 파악하고, 세부항목별 자료 포맷을 분석 후 GIS기반 관측소 정보와 자료를 매칭하여 최종적으로 시스템 컨텐츠별로 DB를 맵핑하였다. 강수량과 기상자료는 33개국의 관측소 6,531개소의 일/월/연단위 관측자료와 10,977격자의 격자분석자료를 구축하였다. 수문자료는 33개국의 수문관측소 2,242개의 월/연단위 유량관측자료와 10,977격자의 월/연단위 직접유출, 기저유출, 잠재증발산의 격자분석자료를 구축하였다. 그리고, 수집된 강우와 기상자료는 기계 오작동, 자료 전송 오류 등으로 인한 결측치 및 이상치에 대해 자료품질분석을 통해 오자료에 대한 보정을 진행하였다. 해당자료는 MySQL를 활용하여 DB를 구축하였으며, GIS정보는 GeoServer를 활용하여 운영서버에 구축된 정보를 최종적으로 사용자에게 Web Browser로 표출하였다. 해당 시스템은 추후 전지구 수자원관련 정보를 제공하여 해외사업지역의 댐이나 보 등의 구조물 설계, 수자원산업의 해외 진출시 데이터 수집의 한계점 및 시간단축을 해결할 수 있어 수자원 분야에 기여 할 수 있을 것으로 판단된다.

  • PDF