• Title/Summary/Keyword: GIS DB Design

Search Result 58, Processing Time 0.025 seconds

SDW and Spatial OLAP Data Cube Design for Enterprise Activities Support (기업 활동 지원을 위한 SDW 및 Spatial OLAP 데이터 큐브 설계)

  • Kim, Seung-Yong;Yom, Jae-Hong;Kyung, Min-Ju
    • Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
    • /
    • 2010.04a
    • /
    • pp.133-136
    • /
    • 2010
  • A lot of GIS DB in Korea is distributed and integration for decision making is difficult. Therefore, the SDW is needed to improve the problems and enhance efficiency. The SDW is used for making decisions about various problems by integrating scattered spatial information. This study analyzes business activity of a local government and plan the data cube to implement spatial OLAP for an efficient decision making.

  • PDF

3-Dimensional Terrain Model of Ruins Distribution Using GIS (GIS를 이용한 유적분포 3차원 지형모델)

  • 곽영주;장용구;강영신;강인준
    • Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
    • /
    • 2004.04a
    • /
    • pp.455-460
    • /
    • 2004
  • Recently, As a part of NGIS project, cultural-assets digital map is produced by cultural properties administration and local autonomous entities. Cultural-assets unified GIS(Geographical Information System) is essential to cultural properties managers and other organizations which is executing land related business for appling it at planning stage. With explosive national land developments, it has been obligated to implement surface survey by the cultural properties protection Art(clause 2, Atr 74). In this paper, the author used the district of Sachon city and made 3D terrain model using digital map which is made of It5000 scale. moreover, the author improved to RDBMS(Relational Database Management System) structure and remodeled the existing DB design in detail. The author suggest to realize shape and kind of remains which have 3D information of accuracy and actualization from surface survey to excavation.

  • PDF

Development of Harvest Mobile System using GIS and GPS based on Design Pattern (디자인패턴 기반 GIS와 GPS틀 이용한 농작물 작황 모바일 시스템 구축)

  • Mun, Young-Chae;Baek, Jeong-Hyun;Baek, Jeong-Ho;Lee, Hong-Ro
    • Proceedings of the Korean Society of Computer Information Conference
    • /
    • 2009.01a
    • /
    • pp.117-120
    • /
    • 2009
  • 본 연구는 디자인패턴 설계유형에 따라 Mobile 장치를 이용하여 현장의 농작물 중 벼의 생육 정보 및 생산 정보와 GPS를 이용하여 농작물의 위치정보를 서버에 있는 DB에 사용자의 권한별로 삽입/삭제/수정/검색을 할 수 있고, GIS를 이용하여 사용자의 위치 및 벼의 위치 정보를 수치지도 상에 보여 주는 시스템을 구축한다.

  • PDF

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.

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

Pliot Building of the Management System for River Thematic Maps (하천주제도 관리시스템 시범구축)

  • Park, Jin-Hyeog;Lee, Geun-Sang;Koh, Deuk-Koo;Kim, Kye-Hyun;Kim, Seong-Joon
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.8 no.2
    • /
    • pp.95-102
    • /
    • 2005
  • Currently, the government has been established GIS DB related to river as a part of the river map digitization projects such as RIMGIS and flood map. This study was aimed to demonstrate the generation of thematic maps related to river space and their management system, the one of the major river thematic maps proposed from the precedent study "Establishment of River Thematic Map Project" in an effort to maximize the utilization of river related database, the major product of the project for digitization of river maps. This study includes amending database model for building river thematic maps. Also, metadata were amended and built for efficient management and distribution of the river related data based on the national standard metadata proposed from "Establishing Standard Metadata" sponsored by National Geography Institute in 2003 for more effective management of river thematic maps. In addition, this study analyzed the method for utilizing existing data from RIMGIS and WAMIS as well as digital topographic maps to produce 25 river thematic maps in accordance of defined building procedure. Management system of the river thematic maps for Kyungan watershed has been generated for effective managing river thematic maps based on the design and pilot generation of river thematic maps, and metadata management function has been added into the management system.

  • PDF

Study on the Standard for 1:25,000 Scale Digital Forest Type Map Production in Korea (1:25,000 수치임상도 제작체계 표준화 연구)

  • Kim, Kyoung-Min;Kim, Cheol-Min;Jun, Eun-Jin
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.12 no.3
    • /
    • pp.143-151
    • /
    • 2009
  • Forest type map is a main forest thematic map which shows forest type, age class, diameter class and density. This map has been used as a base data in various fields such as forest policy decision-making, land suitability assessment and eco map production etc. But the existing map had many kinds of errors and no metadata because there was no standard for digital map production. On this study, we developed standard for digital forest type map production consisting of 33 unit processes including DB schema design, mapping process, quality control and metadata input process. Based on this standard, country-wide digital forest type map can be produced with consistent quality and standard metadata.

  • PDF

A Study on the Design of SUS Module for SITES Development (부지환경종합관리시스뎀 개발용 SEMS모듈 설계에 관한 연구)

  • Ko Do-Young;Park Se-Moon;Kim Chang-Lak
    • Journal of Nuclear Fuel Cycle and Waste Technology(JNFCWT)
    • /
    • v.2 no.4
    • /
    • pp.263-269
    • /
    • 2004
  • During the last two years, Site Information and Total Environmental database management System (SITES) ver. 1.0 has been developed for the systematic SITES Database Module (SDM), which includes site information, facility information and environmental information. The SITES includes the module for site environmental monitoring system and safety assessment (M&A) system for the nuclear facility. SITES is expected to be an effective system for the radioactive waste disposal management facility. Currently, SITES ver.2.0 is under development after the SITES ver.1.0 that is focused on the M&A system. The main purpose of this paper is to introduce and try to account for the major development in the concept of SEMS sub-module of the M&A module. The SEMS is purposed of development of the program for real time environmental monitoring, prediction, and automatic alarm system using SITES Database and related information.

  • PDF

Examination of Factors Influencing Urban Higher Temperature using E-GIS DB (E-GIS DB를 활용한 도시 고온화 영향인자 검토)

  • Kim, Keum-Ji;Yoko, Kamata;Lee, Jung-Jae;Yoon, Seong-Hwan
    • 한국태양에너지학회:학술대회논문집
    • /
    • 2009.11a
    • /
    • pp.44-49
    • /
    • 2009
  • In this study, we performed urrban climate simulation how both the factor of environmental land and artificial factors influence on the formation of urban temperature. With deducing quantitative data, this study could get more accurate results of the urban temperature using urban climate simulation system. In the case of natural land cover, it appeared that there are effects on the lowering temperature and the lower temperature rate appeared in the water land cover on the whole. This is considered as temperature in water land was low because of the characteristics of water land having evaporation latent heat was high and convective sensible heat was low. In case of building which has building coverage ratio, 5% with 10 floors and building coverage ratio, 15 % with 6 floors, it appears that the temperature in the water land is $33.6^{\circ}C$. In case of building coverage ratio 5%, temperature dropped when buildings has more than 4 stories. This is regarded as the size of building is bigger, the temperature dropped in relatively because of the fluctuation of the rate of solar heat from the land. At the present time, the urban temperature are higher because of various artificial factors in the city. With these results, this study supposed to be a basies of the future studies for considering both the composition of building coverate ratio and floor plan.

  • PDF

A Study on Traditional Darangyi-Rice Terrace as Design Factors of Agricultural Landscape (농업경관의 디자인적 요소인 전통다랑논 조사연구)

  • Son, Ho-Gi;Kim, Sang-Bum;Kim, Eun-Ja;Rhee, Sang-Young
    • Journal of the Korean Institute of Traditional Landscape Architecture
    • /
    • v.29 no.1
    • /
    • pp.157-165
    • /
    • 2011
  • This study is to be used as a fundamental material of rural amenity resources researches, such as excavating, establishing and modifying national agricultural landscape resources, so as to efficiently manage them. It is carried out with targeting traditional Darangyi-Rice terrace which has design factors of agricultural landscape resources. We have set up the standard range with practicable similar standard(Marginal Farmland and Less Favored Areas and etc), those of Japan, and the results of analyzing the characteristics of Darangyi-Rice terrace already known. As a result of the field investigation, it has been revealed that a great deal of Darangyi-Rice terrace are being used for not corresponding purposes, or damaged and disappeared. For preserving and well-managing Darangyi-Rice terrace as a rural landscape resource which has rural design factors, it should be advanced detailed and accurate studies on present conditions and changes of Darangyi-Rice terrace, with researches on significances, values, utilities and economical efficiency of Darangyi-Rice terrace by regions. In addition, we utilized various spatial imagery data in the researching process. Consequently, it is concluded that if high resolution imagery data is used, it can establish rather minute and accurate large-scale DB, and monitor elaborate changes as well. It is therefore thought that its application can be higher as actualizing DB hereafter.