• Journal of the Korea Society of Computer and Information
• /
• v.23 no.3
• /
• pp.49-54
• /
• 2018

A data warehouse is a system that collectively manages and integrates data of a company. And provides the basis for decision making for management strategy. Nowadays, analysis data volumes are reaching critical size challenging traditional data ware housing approaches. Current implemented solutions are mainly based on relational database that are no longer adapted to these data volume. NoSQL solutions allow us to consider new approaches for data warehousing, especially from the multidimensional data management point of view. In this paper, we extend the data warehouse design methodology based on relational database using star schema, and have developed a consistent design methodology from information requirement analysis to data warehouse construction for large scale data warehouse construction based on MongoDB, one of NoSQL.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2021.11a
• /
• pp.548-550
• /
• 2021

각 정보시스템에서 생산되는 주택과 관련된 통계 데이터는 정교한 예측과 판단이 요구되는 주택시장에서 매우 중요한 역할을 한다. 현재 정보시스템의 데이터를 기반으로 주택통합DB와 주택통합 플랫폼을 개발하고 있으며, 추후 주택시장의 합리적이고 과학적인 정책을 수립할 수 있는 기반이 될 것이다. 따라서 본 연구에서는 건축행정시스템(세움터)와 주택공급통계정보시스템(HIS)를 대상으로 정보시스템 고도화 현황을 알아보고 개선방안을 제시한 예시를 소개하고자 한다.

• Journal of the Korea Institute of Building Construction
• /
• v.22 no.1
• /
• pp.115-123
• /
• 2022

Statistics on the occurrence of fires in residential facilities over the past 10 years, show that approximately 40% are fires in apartment buildings. To prevent the spread of fire and support evacuation in apartment housing, the fire resistance performance and performance design of fire doors are becoming more important. This study established a database using 395 quality inspection reports from 2016 to 2020, which passed the fire performance test, and derived the fire door performance-influencing factors through an analysis of the structure (12 elements) of the fire door. As a result, the effect of core material, adhesive, hinge type, blowing agent, etc. was confirmed in 287 pass cases. On the other hand, it was confirmed that the occurrence of flames and crevices in the 108 cases of failure were the major failure factors in the fire door fire resistance test. Fire doors are composed of composite materials to prevent failure of fire resistance performance, and efficient design and quality control are required through standardization of components.

• Land and Housing Review
• /
• v.2 no.3
• /
• pp.249-258
• /
• 2011

In order to achieve an efficient urban regeneration of the nation, it is required to determine the extent of decline nation-wide and the declined areas for each district and also to evaluate the potentials of the concerned areas. For this task to be accomplished, a construction of a comprehensive diagnostic system based on spatial information considering diversity and complexity is required. In this study, a total information system architecture for urban regeneration is designed as part of the construction of such a diagnostic system. In order to develop the system, a city and district level unit decline diagnostic indicators has been constructed and a decline diagnostic system has been developed. Also, a scheme to promote the advancement of the system is proposed. The DB construction is based on the city and district level nation-wide and metadata for the concerned level is constructed as well. The system is based on the Open API and designed to be flexible for extension. Also, an RIA-based intuitive UI has been implemented. Main features of the system consist of the management of the indicators, diagnostic analysis (city and district level decline diagnosis), related information, etc. As for methods for the advancement, an information model in consideration of the spation relations of the urban regeneration DB has been designed and application methods of semantic webs. Also, for improvement methods for district unit analytical model, district level analysis models, GIS based spatial analysis platforms and linked utiliation of KOPSS analysis modules are suggested. A use of a total information system for urban regeneration is anticipated to facilitate concerned policy making through the identification of the status of city declines to identify and the understanding of the demands for regeneration.

• Land and Housing Review
• /
• v.7 no.1
• /
• pp.19-29
• /
• 2016

This study proposes the big data policy and case studies in Korea and the application of land and housing of spatial big data to excavate the future business and to propose the spatial big data based application for the government policy in advance. As a result, at first, the policy and cases of big data in Korea were evaluated. Centered on the Government 3.0 Committee, the information from each department of government is being established with the big-data-based system, and the Ministry of Land, Infrastructure, and Transport is establishing the spatial big data system from 2013 to support application of big data through the platform of national spatial information and job creation. Second, based on the information system established and administrated by LH, the status of national territory information and the application of land and housing were evaluated. First of all, the information system is categorized mainly into the support of public ministration, statistical view, real estate information, on-line petition, and national policy support, and as a basic direction of major application, the national territory information (DB), demand of application (scope of work), and profit creation (business model) were regarded. After the settings of such basic direction, as a result of evaluating an approach in terms of work scope and work procedure, the four application fields were extracted: selection of candidate land for regional development business, administration and operation of rental house, settings of priority for land preservation, and settings of priority for urban generation. Third, to implement the application system of spatial big data in the four fields extracted, the required data and application and analytic procedures for each application field were proposed, and to implement the application solution of spatial big data, the improvement and future direction of evaluation required from LH were proposed.

• The Journal of the Korea institute of electronic communication sciences
• /
• v.9 no.1
• /
• pp.105-110
• /
• 2014

Korea, old buildings do not currently have earth-resistant facilities, and disaster prevention facilities have some limitation in responding properly to damage arising from natural disaster as they do not reflect recently occurring climatic changes. Accordingly, it is necessary to select vulnerable districts by taking into consideration the possibility of disaster occurrence and the current situation of infrastructures for disaster prevention in order to responding efficiently to future unexpected disasters. For this purpose, national government has recently formed the DB linkage council for disaster prevention under the participation of related agencies and constructed integrated database. But local governments have not properly provided it with basic data necessary to construct database, resulting in the delay of the project. Therefore, it is thought that national government needs to provide them with manpower and financial support.

• KIEAE Journal
• /
• v.16 no.5
• /
• pp.73-79
• /
• 2016

Purpose: In order to improve the energy performance of existing buildings, so actively promoted green remodeling business. Also, improvement of the performance of envelope system of apartment housing is an absolute. The purpose of implementation of the data base and application plan of the envelope system for green remodeling of apartment housing. Method: For this study, It proposed a classification system of green remodeling envelope system constructed actual to select the applicable representative method and input material of apartment housing for green remodeling. In this study, divided into construction waste processing stage and production phase of the material for the boundary of the system, and implementation the classification system of the envelope system for applicable green remodeling. For this, established 6 environmental impact categories database. Result: As a result of various suggestions were available for case study research, alternative combinations of existing combinations than six kinds of environmental impact insulation system with superior input materials combining 96 kinds, window system, 12 kinds for determining the applicability of the established database. Depending on the account for a large proportion if compared to the detailed analysis of the environmental impact resulting from the production phase and disposal phase was analyzed that the operating management of the necessary input materials. Is considered that the economic performance and integrated energy performance required by the applicable public housing green remodeling evaluation techniques considered for future improvements insulation sheath.

• Explosives and Blasting
• /
• v.8 no.2
• /
• pp.3-17
• /
• 1990

The Caustious blasting have often increased Complaints of ground Vibration and Sound when the Wire-Tunnel Constructed in Pusan. In order to prevent the influence to housing structure, it was necessary to predict blasting-Induced Vibration and Sound. The Suveyer determined the Burden and spacing of Drill holes, minimum delay charges within a allowable Vibration and Sound Level. Tunnel drilling and Ignition patterns are made as follows; No. 1 Tunel (Stable rock, hard rock) No.2 Tunnel (Instable plastic rock; wethered rock) and other Tunnels (Instable rock). The result of 1st testing blasting of No. 1 Tunnel was recorded Under allowable Vibration Level but sound was over 75 Db of allowable value. So Tunnel drilling pattern was amended with 52 Non-charg holes to reduce the blast-sound. The other pattern had no need to amend.

• Journal of the Korean housing association
• /
• v.12 no.4
• /
• pp.115-122
• /
• 2001

The purpose of this research is to analyze the survey of the residential and commercial user consciousness of 4 cases(DB, YM, TP, HG) to propose directions of development of the mixed-use apartments in Daegu. The results of the survey are as follows; 1) The residential users of DG, YM, TP and the commercial users of DG, TP, HG were not satisfied with generally present situation. 2) It showed that the development factors of the satisfaction, the reason of the move, the difficulty to operate the business, the possible use of Mixed-Use Development, the using system of the main entrance, and the reasonable residential size were the statistical significance level(p<0.05). Finally, this study proposes that 4 Cases with the diverse physical and social environment must be different with the approach, and that the reasonable residential space program, size planning for commercial unit, and choices of what kind of business should be discussed before Mixed-Use Development regarding needs of region.

• Proceedings of the Korea Society of Design Studies Conference
• /
• 2000.11a
• /
• pp.114-115
• /
• 2000

IMF 한파와 더불어 건설 시장 역시 침체되어 있는 되도 불구하고 사회 및 문화의 변화속도는 빨라지고 있으며 소비자들의 주택 선호도 역시 다양해지고 있다. 과거 정부주도의 주택 확대정책에 따른 획일화된 아파트의 양적 팽창은 이러한 빠른 변화와 다양화에 적응할 수 없는게 현실이며 또한 많은 문제점을 남기게 되었다. (중략)