• Title/Summary/Keyword: DB construction

Search Result 607, Processing Time 0.027 seconds

Study on the Development of Process and Data Models for the Maintenance of Rental Apartments (임대아파트 유지관리 시스템 개발을 위한 프로세스 및 데이터 모델 구축에 관한 연구)

  • Jung, Young-Han;Jung, Jae-Young;Lee, Jae-Sung;Cho, Bong-Ho
    • Journal of the Korea Institute of Building Construction
    • /
    • v.10 no.5
    • /
    • pp.55-67
    • /
    • 2010
  • The main purpose of this study is to develop a system and data model extracted from the TO-BE process model of rental apartments to promote information exchange based on knowledge obtained through maintenance status analysis. Currently, it is difficult to find examples suggesting a data model through a process analysis of maintenance in rental apartments. Thus, this study intends to suggest a process as well as a data model to promote the development of a maintenance system for rental apartments by using building management knowledge, utilization of standardized tools, and existing FM (Facility Management) techniques to break through limitations in actual application. Ultimately, this study aims to show examples of document-oriented analysis and information technology for middle managers in charge of the maintenance of rental apartments, as well as work analysts developing the maintenance system. In further research beyond this study, complex issues on the maintenance of rental apartments, legal restrictions on customary practices of maintenance activities, effects of the scales of maintenance practices, requirements to perform maintenance activities, evaluation on the status of maintenance, life cycle cost and risks will be investigated.

Prediction of the Fractures at Inexcavation Spaces Based on the Existing Data (터널의 굴착면 전반부에 분포하는 절리의 예측)

  • Hwang, Sang-Gi
    • The Journal of Engineering Geology
    • /
    • v.24 no.4
    • /
    • pp.643-648
    • /
    • 2014
  • Understanding of fracture networks and rock mass properties during tunnel construction is extremely important for the prediction of dangers during excavation, and for deciding on appropriate excavation techniques and support. However, rapid construction process do not allow sufficient time for surveys and interpretations for spatial distributions of fractures and rock mass properties. This study introduces a new statistical approach for predicting joint distributions at foreside of current excavation face during the excavation process. The proposed methodology is based on a cumulative space diagram for joint sets. The diagram displays the cumulative spacing between adjacent joints on the vertical axis and the sequential position of each joint plotted at equally spaced intervals on the horizontal axis. According to the diagram, the degree of linearity of points representing the regularity of joint spacing; a linear trend of the points indicates that the joints are evenly spaced, with the slope of the line being directly related to the spacing. The linear points which are stepped indicates that the fracture set show clustered distribution. A clustered pattern within the linear group of points indicates a clustered joint distribution. Fractures surveyed from an excavated space can be plotted on this diagram, and the diagram can then be extended further according to the plotted diagram pattern. The extension of the diagram allows predictions about joint spacing in areas that have not yet been excavated. To test the model, we collected and analyzed data during excavation of a 10-m-long tunnel. Fractures in a 3-m zone behind the excavation face were predicted during the excavation, and the predictions were compared with observations. The methodology yielded reasonably good predictions of joint locations.

The Influence Analysis of Value Engineering for the Public Empoyer's Decision Marking - Focused on the Project Life Cycle - (공공발주자 의사결정에 미치는 가치공학(VE)의 영향력 분석 - 프로젝트 생애주기를 중심으로 -)

  • Park, Jongsoon;Chun, Jaeyoul
    • Korean Journal of Construction Engineering and Management
    • /
    • v.16 no.2
    • /
    • pp.12-20
    • /
    • 2015
  • The public employers are faced the mounting importance of decision process to settle the optimum VE delivery system of such public facilities buildings and etc. The elements of decision process of the public employer are formed in the various relationships of the concerned and when the projects are coming into effect, the decision process in the VE delivery method and the selection of contractor will be the name of the game. The decision process in the VE delivery method and the selection of contractor are created a case to be one and the same as well as initiates a consistency for the performance. However, the function and role of the public employer are projective accordingly to the organization of employer and the employer especially no system is equal to the capability of perfect evaluation and verification of the ability of the employer. Especially the lowest bidder policy that started with justification to increase the competitiveness and technical capability of the contractors through the completion in between contractors has been providing the hotbed for insolvency, irregularity and irrationality as a result. From this point of view it is declared that the buildup the edifice of supporting system in the process of decision to recover the mutual trust and respect of the concerned in the VE delivery system with the technostress and the systematization based on drawing the elements which affect the decision process of public employer.

Using Logistic Regression for Determining the Factors Affecting Bidding Success in World Bank's International Consulting Projects in Indonesia (로그 회귀분석을 이용한 해외 엔지니어링 사업의 낙찰 성공 요인 분석 - 세계은행의 인도네시아 사업을 중심으로-)

  • Yu, Youngsu;Shin, Byungjin;Koo, Bonsang;Han, Seungheon
    • Korean Journal of Construction Engineering and Management
    • /
    • v.19 no.1
    • /
    • pp.80-89
    • /
    • 2018
  • World Bank projects enable Korean engineering firms to enter new markets and diversify their portfolio. These firms need to understand the critical factors for bidding success in such projects. The World Bank publishes as open records all their bidding history data in their open database. This provides an opportunity to identify empirically the factors that determine which firms on chosen. This research collected relevant bid data, focusing on Indonesia, to perform a logistic regression with the goal of statistically identifying significant factors that result in bidding success. Results showed that work experience, being included in a consortium, and having a local partner positively affected winning a bid. On the other hand, having a local competitor of the recipient country negatively impacts the chances of attaining a bid. Commensurately, Korean engineering firms need to increase their work experience in internationally recognized projects, and include a local partner as a joint venture partner to increase their chances, while refrain from conventional projects that can be performed by local engineering firms.

A Study on the Construction of Moving Route Information Sharing System of COVID-19 Confirmed Cases

  • Kim, Byungkyu;You, Beom-Jong;Shim, Hyoung-Seop
    • Journal of the Korea Society of Computer and Information
    • /
    • v.25 no.12
    • /
    • pp.155-163
    • /
    • 2020
  • This study developed a system that can collect, manage, and utilize the travel routes of individuals who tested positive for coronavirus disease 2019 (COVID-19) based on the data standardization and quality management principles and presented the analysis data collected from the existing system. Unlike many other countries in the world, Korea demonstrated a rapid response by conducting epidemiological investigations. Further, the local governments have actively shared the travel routes of individuals who tested positive for COVID-19 to facilitate proactive prevention of the infectious disease per the Infectious Disease Control and Prevention Law. However, currently, there is no standard protocol for the local governments to share the information, thus complicating the process of sharing, managing, and utilizing the collected data. Therefore, this study developed a system that can facilitate sharing of the travel routes of individuals who tested positive for COVID-19 by establishing database construction procedures and using the travel route of COVID-19 patients as per the Disaster & Safety Information Sharing Platform and developing a data processing guideline, a data entry system with default templates, and Open API. Although this sharing system was designed to communicate the travel routes of COVID-19 patients, it can also be utilized in case of other infectious diseases. Therefore, it can be used as a response strategy for future outbreaks of infectious diseases.

Development of IFC Standard for Securing Interoperability of BIM Data for Port Facilities (항만 BIM 데이터의 상호운용성 확보를 위한 IFC 표준 개발)

  • Moon, Hyoun-Seok;Won, Ji-Sun;Shin, Jae-Young
    • Journal of KIBIM
    • /
    • v.10 no.1
    • /
    • pp.9-22
    • /
    • 2020
  • Recently, BIM has been extended to infrastructures such as roads and bridges, and the demand for BIM standard development for ports is increasing internationally. Due to the low level of utilization of classification system and drawing standards compared to other infrastructures, and the closed nature of national security facilities, ports have insufficient level of connection and sharing environment among external systems or users. In addition, since the standardization of data for port facilities is not made, it is still necessary to establish an independent DB for each system and to ensure interoperability of data between these systems since it does not have a shared environment among similar data. Therefore, the purpose of this study is to develop and verify IFC, the international standard for BIM, in order to cope with the BIM environment and to be commonly used in the design, construction, and maintenance of port facilities. To this end, we build a standard schema with port-specific Express Notation according to buildingSMART International's standard development methodology. First, domestic and international reference model standards were analyzed to derive components such as space and facilities of port facilities. Based on this, the components of the port facility were derived through the codification, categorization, and normalization process developed by the research team. This was extended based on the port BIM object classification system developed by the research team. Normalization results were verified by designers and associations. Then, IFC schema construction was based on Express-G data modeling based on IFC 4 * 2 Candidate, which is a bridge candidate standard based on IFC4 (ISO16739), and IFC 4 * 3 Draft, which is developed by buildingSMART International. The final schema was validated using the commercialized validation tool. In addition, in order to verify the structural verification of the port IFC schema, the transformation process was verified by converting the caisson model into a Part21 file. In the future, this result will not only be used as a delivery standard for port BIM products, but will also be applied as a linkage standard between systems and a common data format for port BIM platforms when BIM is used in the maintenance phase. In particular, it is expected to be used as a core standard for data exchange in the port maintenance stage.

A Study on System of Feasibility Study and Issues of Economic Analysis in Cultural Facility Construction: Focused on the National Museum of Contemporary Art(MMCA), Seoul (문화시설 건립 타당성조사의 체계와 경제성 분석에서의 쟁점 - 국립현대미술관 서울관 건립사업을 중심으로 -)

  • Jung, Sang-chul
    • Korean Association of Arts Management
    • /
    • no.53
    • /
    • pp.101-125
    • /
    • 2020
  • This paper presents the problems and improvement methods in estimating demand and benefit, which have been controversial in the feasibility study of building cultural facilities. Although there are justifications for supplying cultural facilities by expanding leisure time and increasing income, the economic burden from the insolvent operation after construction is high. Feasibility studies can prevent these problems in advance. In order to estimate the demand for cultural facilities, similar facilities were selected and the gravity model was used to estimate the demand. In the future, it is necessary to prepare the criteria for setting the reference facility to increase the accuracy of the demand estimation. In addition, in the case of cultural facilities constructed through feasibility study, it is necessary to induce and enforce the disclosure of operational data and information, and to establish a database so that it can be used as a reference facility for demand estimation in future feasibility study on cultural facility. Accurate benefit estimation requires multiple CVM surveys. In addition to the current CVM survey, this paper suggest that supplementary online non-face-to-face surveys is considered. Furthermore, this research suggests that the use of video media for explanation of alternative materials for cultural facilities to be constructed because the WTP may be excessive due to lack of alternatives for survey respondents in the current CVM survey.

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.

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.

International and domestic research trends in longitudinal connectivity evaluations of aquatic ecosystems, and the applicability analysis of fish-based models (수생태계 종적 연결성 평가를 위한 국내외 연구 현황 및 어류기반 종적 연속성 평가모델 적용성 분석)

  • Kim, Ji Yoon;Kim, Jai-Gu;Bae, Dae-Yeul;Kim, Hye-Jin;Kim, Jeong-Eun;Lee, Ho-Seong;Lim, Jun-Young;An, Kwang-Guk
    • Korean Journal of Environmental Biology
    • /
    • v.38 no.4
    • /
    • pp.634-649
    • /
    • 2020
  • Recently, stream longitudinal connectivity has been a topic of investigation due to the frequent disconnections and the impact of aquatic ecosystems caused by the construction of small and medium-sized weirs and various artificial structures (fishways) directly influencing the stream ecosystem health. In this study, the international and domestic research trends of the longitudinal connectivity in aquatic ecosystems were evaluated and the applicability of fish-based longitudinal connectivity models used in developed countries was analyzed. For these purposes, we analyzed the current status of research on longitudinal connectivity and structural problems, fish monitoring methodology, monitoring approaches, longitudinal disconnectivity of fish movement, and biodiversity. In addition, we analyzed the current status and some technical limitations of physical habitat suitability evaluation, ecology-based water flow, eco-hydrological modeling for fish habitat connectivity, and the s/w program development for agent-based model. Numerous references, data, and various reports were examined to identify worldwide longitudinal stream connectivity evaluation models in European and non-European countries. The international approaches to longitudinal connectivity evaluations were categorized into five phases including 1) an approach integrating fish community and artificial structure surveys (two types input variables), 2) field monitoring approaches, 3) a stream geomorphological approach, 4) an artificial structure-based DB analytical approach, and 5) other approaches. the overall evaluation of survey methodologies and applicability for longitudinal stream connectivity suggested that the ICE model (Information sur la Continuite Ecologique) and the ICF model (Index de Connectivitat Fluvial), widely used in European countries, were appropriate for the application of longitudinal connectivity evaluations in Korean streams.