• Title/Summary/Keyword: DB design

Search Result 839, Processing Time 0.033 seconds

Design of Agricultural Drought Impact Assessment Platform Based on WEF(Water-Energy-Food) Nexus (WEF(물-에너지-식량) 넥서스 기반 농업 가뭄 영향 평가를 위한 플랫폼 설계)

  • Na, Ra;Joo, Donghyuk;Kim, Hayoung;Yoo, Seung-Hwan;Choi, Gyuhoon;Oh, Bu-Yeong;Hur, Seung-oh
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2022.05a
    • /
    • pp.292-292
    • /
    • 2022
  • 가뭄은 사회기반시설, 인적 자본 등과 같은 자산에 직접적인 영향을 미치지 않으나 물을 중요한 투입재로 사용하는 농업부문에 피해가 집중된다. 가뭄 재해는 준비와 대응에 따라 피해에 큰 차이가 크기 때문에 다른 재해와는 달리 강도뿐만 아니라 지속기간을 고려해야 한다. 효과적인 가뭄 위험 관리를 위해서는 가뭄의 특징과 가뭄 준비 및 대응 수단에 따른 환경 및 경제적 영향을 평가할 수 있는 모형 구축과 다양한 농업자원을 동시적으로 연계 평가하여 지속가능성을 판단할 수 있는 기술 개발이 필요하다. 이에 본 연구에서는 기후변화 등의 외부요인을 반영한 물-에너지-식량 (Water-Energy-Food, WEF) 넥서스 기반 농업 가뭄 평가 플랫폼 설계를 제안하고자 한다. 이를 위해 물-에너지-식량 넥서스 연계 해석 고도화 기술을 개발하고, 생물-물리학적 모델 및 경제학적 모델 연계형 기후-토양-물-에너지-식량 넥서스 (CS-WEF NEXUS) 플랫폼을 구축하여, 최종적으로 기후변화 및 농업부문 가뭄 준비 및 대응 수단의 영향 평가를 바탕으로 한 의사결정 지원 도구를 제시하는 것이 최종 목표이다. 본 연구에서 구축된 플랫폼은 넥서스 연계 해석을 통해 농업 가뭄 대응을 위한 식량 및 에너지 안보 정책에도 미칠 수 있는 영향을 분석할 수 있으며, 다양한 식량-물-에너지 정책들이 타 요소들에 미치는 영향을 쉽게 평가할 수 있다는 점에서 정책적 의사결정 지원 시스템으로서 활용도가 높을 것으로 예상한다.

  • PDF

Development of River Zone Automatic Determination Technique by Grid-based Design Flood Level Influence Area (계획홍수위 영향범위 자동결정을 통한 정밀 하천구역 설정기법 개발)

  • Lim, Dong Hwa;Lee, Choon Ho;Shin, Hee Jae;Sim, Gyoo Seong
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2022.05a
    • /
    • pp.312-312
    • /
    • 2022
  • 우리나라는 하천법 및 소하천정비법에 의거하여 하천기본계획 수립 또는 하천의 지정 및 변경고시 시 하천구역을 지정하고 있다. 하천구역은 일반적으로 제방부지 및 제방하심측 토지경계를 기준으로 지정하나, 제방이 존재하지 않는 무제부 구간의 경우 명확한 제방경계가 없는관계로 하천법 제 10조 3항에서 5항까지 별도의 기준을 통해 하천구역 지정을 권장하고 있는 실정이다. 하천구역 설정 시 기준으로 삼는 횡단측점 자료의 경우 그 특성상 하천의 종단방향으로 불연속적인 특징을 갖고 있어 평면상 정확한 경계의 파악이 어려우며, 도로·철도 등 선형시설경계를 하천구역으로 설정 시 편입용지의 보상기준이 모호하여 다량의 민원이 발생하고 있다. 본 연구에서는 하천정비 시 기본계획이 수립되어 각 횡단측점별 결정된 계획홍수위를 기반으로 인접 지형의 홍수위 영향범위를 자동으로 추출하여 하천구역을 정밀하게 결정할 수 있는 방법론을 정립하고자 한다. 첫째로, 하천중심선의 각 측점의 위치정보와 하천의 지형을 위상정보체계로 구성하여 DB를 구축하였다. 둘째로, 측선과 측선사이 절점에 계획홍수위를 선형보간하여 부여하고 이를 지형도의 최단거리에 위치한 지형의 격자표고와 비교해 침수여부를 판단한다. 셋째, 최단거리 지형격자가 침수로 판단될 시 인접한 8개 지형격자의 지형표고와 홍수위를 비교하여 반복적으로 위 과정 수행을 통해 계획홍수위 기반 침수범위를 추출한다. 마지막으로, 이를 수치지형도에 중첩시켜 최종 정밀 하천구역을 결정할 수 있다. 이를 이용하여 산정된 정밀한 하천구역 경계설정을 통해 하천 내사유지 편입을 최소화함과 동시에 명확한 하천구역 구획기준을 정립하여 토지소유주와 담당부처 간 논의 시 기반자료로 활용될 수 있고, 하천구역의 신속하고 정확한 구역설정을 통해 하천인근의 토지이용 고도화 및 효율적인 이용이 가능할 것으로 기대된다.

  • PDF

Indoor Positioning Technology Integrating Pedestrian Dead Reckoning and WiFi Fingerprinting Based on EKF with Adaptive Error Covariance

  • Eui Yeon Cho;Jae Uk Kwon;Myeong Seok Chae;Seong Yun Cho;JaeJun Yoo;SeongHun Seo
    • Journal of Positioning, Navigation, and Timing
    • /
    • v.12 no.3
    • /
    • pp.271-280
    • /
    • 2023
  • Pedestrian Dead Reckoning (PDR) methods using initial sensors are being studied to provide the location information of smart device users in indoor environments where satellite signals are not available. PDR can continuously estimate the location of a pedestrian regardless of the walking environment, but has the disadvantage of accumulating errors over time. Unlike this, WiFi signal-based wireless positioning technology does not accumulate errors over time, but can provide positioning information only where infrastructure is installed. It also shows different positioning performance depending on the environment. In this paper, an integrated positioning technology integrating two positioning techniques with different error characteristics is proposed. A technique for correcting the error of PDR was designed by using the location information obtained through WiFi Measurement-based fingerprinting as the measurement of Extended Kalman Filte (EKF). Here, a technique is used to variably calculate the error covariance of the filter measurements using the WiFi Fingerprinting DB and apply it to the filter. The performance of the proposed positioning technology is verified through an experiment. The error characteristics of the PDR and WiFi Fingerprinting techniques are analyzed through the experimental results. In addition, it is confirmed that the PDR error is effectively compensated by adaptively utilizing the WiFi signal to the environment through the EKF to which the adaptive error covariance proposed in this paper is applied.

A Study on the Structure and Characteristics of Presidential Records (대통령기록의 구조와 특징에 관한 연구 e지원시스템 생산기록(기록관리비서관실)을 중심으로)

  • Yang, Inho
    • The Korean Journal of Archival Studies
    • /
    • no.79
    • /
    • pp.231-270
    • /
    • 2024
  • The purpose of this study is to propose a record service based on the characteristics and production context of presidential records. To this end, we first looked at the design direction and characteristics of the e-jiwon system and then analyzed the structure and characteristics of records produced by the e-jiwon system. There are six types of records to be analyzed: e-jiwon document card, memo, schedule, diary, instruction card, and individual business system_speech DB. Next, through analysis of the Presidential Records Portal's records service, it was pointed out that the current records service does not fully reveal the production context and characteristics of records. Accordingly, as a service strategy based on the characteristics and context of presidential records, a service centered on each record card (e-jiwon document card, etc.) and a service that focuses on structural understanding of records and linkage between records were proposed.

GIS-based Market Analysis and Sales Management System : The Case of a Telecommunication Company (시장분석 및 영업관리 역량 강화를 위한 통신사의 GIS 적용 사례)

  • Chang, Nam-Sik
    • Journal of Intelligence and Information Systems
    • /
    • v.17 no.2
    • /
    • pp.61-75
    • /
    • 2011
  • A Geographic Information System(GIS) is a system that captures, stores, analyzes, manages and presents data with reference to geographic location data. In the later 1990s and earlier 2000s it was limitedly used in government sectors such as public utility management, urban planning, landscape architecture, and environmental contamination control. However, a growing number of open-source packages running on a range of operating systems enabled many private enterprises to explore the concept of viewing GIS-based sales and customer data over their own computer monitors. K telecommunication company has dominated the Korean telecommunication market by providing diverse services, such as high-speed internet, PSTN(Public Switched Telephone Network), VOLP (Voice Over Internet Protocol), and IPTV(Internet Protocol Television). Even though the telecommunication market in Korea is huge, the competition between major services providers is growing more fierce than ever before. Service providers struggled to acquire as many new customers as possible, attempted to cross sell more products to their regular customers, and made more efforts on retaining the best customers by offering unprecedented benefits. Most service providers including K telecommunication company tried to adopt the concept of customer relationship management(CRM), and analyze customer's demographic and transactional data statistically in order to understand their customer's behavior. However, managing customer information has still remained at the basic level, and the quality and the quantity of customer data were not enough not only to understand the customers but also to design a strategy for marketing and sales. For example, the currently used 3,074 legal regional divisions, which are originally defined by the government, were too broad to calculate sub-regional customer's service subscription and cancellation ratio. Additional external data such as house size, house price, and household demographics are also needed to measure sales potential. Furthermore, making tables and reports were time consuming and they were insufficient to make a clear judgment about the market situation. In 2009, this company needed a dramatic shift in the way marketing and sales activities, and finally developed a dedicated GIS_based market analysis and sales management system. This system made huge improvement in the efficiency with which the company was able to manage and organize all customer and sales related information, and access to those information easily and visually. After the GIS information system was developed, and applied to marketing and sales activities at the corporate level, the company was reported to increase sales and market share substantially. This was due to the fact that by analyzing past market and sales initiatives, creating sales potential, and targeting key markets, the system could make suggestions and enable the company to focus its resources on the demographics most likely to respond to the promotion. This paper reviews subjective and unclear marketing and sales activities that K telecommunication company operated, and introduces the whole process of developing the GIS information system. The process consists of the following 5 modules : (1) Customer profile cleansing and standardization, (2) Internal/External DB enrichment, (3) Segmentation of 3,074 legal regions into 46,590 sub_regions called blocks, (4) GIS data mart design, and (5) GIS system construction. The objective of this case study is to emphasize the need of GIS system and how it works in the private enterprises by reviewing the development process of the K company's market analysis and sales management system. We hope that this paper suggest valuable guideline to companies that consider introducing or constructing a GIS information system.

A Study on the Forest Vegetation of Deogyusan National Park (덕유산 국립공원 삼림식생에 관한 연구)

  • Kim, Chang-Hwan;Oh, Jang-Geun;Lee, Nam-Sook
    • Korean Journal of Ecology and Environment
    • /
    • v.46 no.1
    • /
    • pp.33-40
    • /
    • 2013
  • From March 2012 to January 2013, this study was conducted as a part of the project for making a precise electronic ecological zoning map of vegetation on a highly reduced scale of 1 to 5,000 with a view to improving management efficiency of national parks and enlarging the availability of the data produced from the basic research monitoring the resources of national parks. For the research accuracy and rapidity, a vegetation map was specially created for the on-the-site-vegetation research. To make the map more meticulous, we categorized the vegetation database into five groups: broadleaved forest, coniferous forest, mixed forest, rock vegetation and miscellaneous one. After comparing the results of the data built for the vegetation research and the actual research findings, it was made clear that vegetation of both categories was almost the same in case of broad-leaved forest with 72.20% and 78.45% respectively, and also equivalent in other groups like, for example, coniferous forest (16.70%, 13.41%), mixed forest (9.50%, 7.49%) and rock vegetation (0.60%, 0.15%). According to the precise vegetation map produced from the research, the deciduous broad-leaved forest was the most widely prevalent type in the correlated hierarchical classification of vegetation, occupying 65.78% of the overall vegetation. It was followed by mountain valley forest (15.17%), coniferous forest (10.90%), and plantation forest (7.00%) in order. It is particularly noteworthy that Mt. Deogyusan national park has retained a very stable and versatile forest vegetation in the outstanding state since approximately 20% of the mountain turns out to belong to the I grade vegetation conservation classification which contains climax forests, unique vegetation, subalpine vegetation, matured stands which are older than 50 years and etc.

Design and Implementation of Integrated GIS-T System for Transportation Database (교통DB구축을 위한 GIS-T 통합시스템의 설계와 구현)

  • Joo Yong-Jin;Choi Jung-Min;Park Soo-Hong
    • Spatial Information Research
    • /
    • v.13 no.3 s.34
    • /
    • pp.309-321
    • /
    • 2005
  • To analyze travel demand fur transportation policy and transportation planning, it is important to construct realistic and reliable traffic data. And it needs a user friendly system to demonstrate transportation problems in the transportation planning and transportation management aspect. Generally, to construct network for analysis and collection about social and economical data is a core of transportation planning model. However, it takes a lot of time and effect. To overcome this problem GIS is more effective and efficient in data processing, such as selecting, editing and visualizing, etc. However, it is an early stage to use CIS in the transportation problems. This paper shows a new GIS-T system. The system can give traffic information and plan transportation planning using GIS which has ability as spatial representation and spatial analysis. To build this system, we design interfaces that are able to communicate transportation package for analysis with GIS and manage network efficiently, such as editing and examination. And we also develop a module for traffic information processing to handle spatial data and add it on the system. The proposed system shows more realistic transportation network modeling because the system presents more effective conditions to analyze network. And it can be a tool that can analyze various transportation problems.

  • PDF

A Study on Knowledge.Information Service with Electronic Culture Maps (전자문화지도를 활용한 지식정보서비스 연구 -조선족문화지도 중심으로-)

  • Kim, Dong-Hun;Kim, Sang-Hyeon;Moon, Hyun-Joo
    • 한국HCI학회:학술대회논문집
    • /
    • 2009.02a
    • /
    • pp.1316-1320
    • /
    • 2009
  • Since most information is readily available these days, the shear volume of the information simply overwhelms people, rather than helping them as a form of useful knowledge. Thus, the quantity of information someone owns doesn't possess much significance. The possibility to well-utilize the quality information is much more important these days. Electronic culture map service is being provided these days to introduce various cultural information to people around the world. But its service is limited to 'visualization, collection, and integration of the data.' Which means, electronic culture maps are no more than a simple data collector. The main purpose of this thesis is to develop a new kind of knowledge/information service method which overcomes these shortcomings. To achieve this goal, at first, the thesis will take a close look at the characteristics and functions of Chosunjock culture maps, and then, it will clarify the definition of data, information, knowledge of cultural resources. And secondly, nd thirdly, the thesis will look up the Wayfinding contents, User Experience Design, User Context, and Organic design for knowledge/information service. And lastly, the thesis will develop the knowledge/information service, specifically based on Chosunjock cultural resources.

  • PDF

A Study on the Digital Content Development of Korean Kimchi Culture (한국 김치문화의 디지털 콘텐츠 개발에 관한 연구)

  • Kim, Je-Joong
    • Archives of design research
    • /
    • v.18 no.1 s.59
    • /
    • pp.105-114
    • /
    • 2005
  • With the upcoming Digital age, it is time to develop digitalized contents based on cultural basis. in this respect, Kimchi is one of the most primal cultural content signifying Korean culture. It's no doubt the time to initiate the movement to digitalize the contents concerning Kimchi by gathering materials on the origin of Kimchi culturally and a great value to revive digital contents regarding Kimchi. Therefore, in this research, it is regarded that Kimchi is one of the most prominent cultural value that is possible to inherit from generations and should be stratified on the database. A method explaning Korean Kimchi culture is sought in this paper. And It is focused on the culture of Korean Kimchi profoundly and focus on detailed context and varied styles of he digital contents. It is organized on the basis of various aged volumes regarding Kimchi classified by seasons, ingredients, Jonga Kimchi (Kimchi inherited from the oldest family by generations), 24 seasonal divisions of the year, and 8 regional divisions of the nation. It is planned to set up digitally-focused library regarding cultural origin of contents and to present solidity and a feeling of being dynamic The results could be used in a variety of Industries in tourism, education, Kimchi and building basic infrastructure in entertainment industry. It is also applied to specialized industry by providing cultural contents and it could contribute to activation of Kimchi industry with e-Market and portal site regarding Kimchi. Moreover, it may re-establish the cultural value of Kimchi and provide the infrastructure in Kimchi-related industry such as Kimchi cyber museum, Kimchi Expo, Kimchi town by using educational materials in Education industry fields (regular curriculum and experience tour).

  • PDF

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.