• Title/Summary/Keyword: Database Construction

Search Result 1,439, Processing Time 0.03 seconds

Automated Training Database Development through Image Web Crawling for Construction Site Monitoring (건설현장 영상 분석을 위한 웹 크롤링 기반 학습 데이터베이스 구축 자동화)

  • Hwang, Jeongbin;Kim, Jinwoo;Chi, Seokho;Seo, JoonOh
    • KSCE Journal of Civil and Environmental Engineering Research
    • /
    • v.39 no.6
    • /
    • pp.887-892
    • /
    • 2019
  • Many researchers have developed a series of vision-based technologies to monitor construction sites automatically. To achieve high performance of vision-based technologies, it is essential to build a large amount and high quality of training image database (DB). To do that, researchers usually visit construction sites, install cameras at the jobsites, and collect images for training DB. However, such human and site-dependent approach requires a huge amount of time and costs, and it would be difficult to represent a range of characteristics of different construction sites and resources. To address these problems, this paper proposes a framework that automatically constructs a training image DB using web crawling techniques. For the validation, the authors conducted two different experiments with the automatically generated DB: construction work type classification and equipment classification. The results showed that the method could successfully build the training image DB for the two classification problems, and the findings of this study can be used to reduce the time and efforts for developing a vision-based technology on construction sites.

EMI database analysis focusing on relationship between density and mechanical properties of sedimentary rocks

  • Burkhardt, Michael;Kim, Eunhye;Nelson, Priscilla P.
    • Geomechanics and Engineering
    • /
    • v.14 no.5
    • /
    • pp.491-498
    • /
    • 2018
  • The Earth Mechanics Institute (EMI) was established at the Colorado School of Mines (CSM) in 1974 to develop innovations in rock mechanics research and education. During the last four decades, extensive rock mechanics research has been conducted at the EMI. Results from uniaxial compressive strength (UCS), Brazilian tensile strength (BTS), point load index (PLI), punch penetration (PP), and many other types of tests have been recorded in a database that has been unexamined for research purposes. The EMI database includes over 20,000 tests from over 1,000 different projects including mining and underground construction, and analysis of this database to identify relationships has been started with preliminary results reported here. Overall, statistically significant correlations are identified between bulk density and mechanical strength properties through UCS, BTS, PLI, and PP testing of sedimentary, igneous, and metamorphic rocks. In this paper, bulk density is considered as a surrogate metric that reflects both mineralogy and porosity. From this analysis, sedimentary rocks show the strongest correlation between the UCS and bulk density, whereas metamorphic rocks exhibit the strongest correlation between UCS and PP. Data trends in the EMI database also reveal a linear relationship between UCS and BTS tests. For the singular case of rock coral, the database permits correlations between bulk density of the core versus the deposition depth and porosity. The EMI database will continue under analysis, and will provide additional insightful and comprehensive understanding of the variation and predictability of rock mechanical strength properties and density. This knowledge will contribute significantly toward the increasingly safe and cost-effective geostructures and construction.

EVMS Database System Implementation for interworking of WBS & CBS based management in Construction Works (건설공사의 활동·내역 연동관리를 위한 기성관리운영시스템(EVMS) 데이터 모델링 및 구현)

  • Park, Hong-Tae;Lee, Bu-Hyung
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.12 no.6
    • /
    • pp.2851-2858
    • /
    • 2011
  • The schedule management in construction project have been performed independently by two method, WBS base management and CBS based management, However, the integrated management model is needed according to efficiency of construction project management and introduction of new EVMS system of KOREA government. For this purpose, interworking database system is designed through efficient modeling of WBS based management data and CBS based management data and relation establishment between entities in this paper. WBS based management DB consists of 4 entities and CBS based management DB consists of 3 entity and one of the 4 WBS DB entities is used to play interworking role between WBS and CBS, Also, attributes of all entities are well defined so that data consistency, integrity and newest are guaranteed. The designed interworking database model was realized using Nex-Pert Pro and the efficiency of data interworking was proved.

Process Standardization for the Construction of Job-Exposure Matrix Using the Work Environment Measurement Database (작업환경측정 결과 데이터베이스를 활용한 직무노출매트릭스 구축을 위한 공정 표준화)

  • Sangjun Choi;Ju-Hyun Park;Dong-Hee Koh;Donguk Park;Hwan-Cheol Kim;Dae Sung Lim;Yeji Sung;Kyoung Yoon Ko;Ji Seon Lim;Hoekyeong Seo
    • Journal of Korean Society of Occupational and Environmental Hygiene
    • /
    • v.33 no.1
    • /
    • pp.78-90
    • /
    • 2023
  • Objectives: The purpose of this study is to standardize the process code of the work environment measurement database (WEMD) for the construction of a job-exposure matrix (JEM). Methods: The standard process code (SPC) was reclassified based on process similarity and drawing upon the code used in the existing K2B. It was supplemented through review by industrial hygiene experts. In addition, an index word database related to SPC was created and used for SPC search. A pilot evaluation project was conducted by experts to evaluate the validity of the newly reclassified standard process code. Results: A total of 70 final SPCs were developed, including 31 processes related to the construction industry. Using the Shiny program, we developed a standard code finder that can be used on the web (https://kscf.shinyapps.io/scf_app/). As a result of the pilot evaluation, it was determined that it was easier to search for standard codes than previous codes, so it was highly utilized. Conclusions: It is expected that JEM construction using industry-process information drawing on WEMD data will be possible using the 70 newly standardized process codes.

Development of a Web-based Geospatial Information System for Analyzing and Assessing Geotechnical Information (지반정보 분석 및 평가를 위한 웹기반 지리공간정보 시스템 개발)

  • Lee, Sang-Hoon;Jang, Yong-Gu
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.10 no.4
    • /
    • pp.142-152
    • /
    • 2007
  • Geotechnical information database, foundation of underground geographic information system in 2nd NGIS plan, had been developing by Ministry of Construction and Transportation since 2000. This database contains not only soil condition, such as depth, type and color of layer, and ground water level, but also engineering properties used for foundation design and construction, for instance, standard penetration test, compression test. But, it is difficult to apply this database for analyzing and designing geotechnical works, because report document is only offered. In this paper, we have developed web-based geospatial information system for the effective uses. First, underground cross-section model is generated by location, layer, and engineering properties of geotechnical information database at the realtime process. Second, earth volume, bearing capacity, and settlement is calculated and potentials of soft ground, liquefaction are evaluated through pre-defined empirical formula. This process is operated by web-based client. We wish to strengthen the application capacity through this system in construction planning and design works.

  • PDF

The Analysis of the Important Problems on Designing and Constructing Earth Retaining Structures (지반굴착 흙막이 구조물 설계 및 시공시 중요문제점 분석)

  • Lee, Song;Kim, Ju-Hyun
    • Journal of the Korea institute for structural maintenance and inspection
    • /
    • v.6 no.2
    • /
    • pp.167-174
    • /
    • 2002
  • Earth retaining structure is constructed structure in order to construct a multistoried building, the subway, a subterranean downtown for effective use and obtainments of the limited ground. Recently, many kinds of research have been actively developed for a standardization and a database on designing and constructing of bridge, tunnel, road. With the works of database construction of that, many kinds of data with respect to statistics is cumulated. However, Database work of designed and constructed earth retaining structure in the construction field is wholly lacking and lagged behind in the works of database construction. This paper suggested classification system on indication data in connection with designing and constructing earth retaining structures a hundred fields. On the basis of that, code work with classification system was practised and DB program of indication data in connection with designing and constructing earth retaining structures was developed.

Development of an Object-Relational IFC Server

  • Hoon-sig Kang;Ghang Lee
    • International conference on construction engineering and project management
    • /
    • 2009.05a
    • /
    • pp.1346-1351
    • /
    • 2009
  • In this paper we propose a framework for an Object Relational IFC Server (OR-IFC Server). Enormous amounts of information are generated in each project. Today, many BIM systems are developed by various CAD software vendors. Industry Foundation Classes (IFC) developed by International Alliance for Interoperability (IAI) is an open standard data model for exchanging data between the various BIM tools. The IFC provides a foundation for exchanging and sharing of information directly between software applications and define a shared building project model. The IFC model server is a database management system that can keep track of transactions, modifications, and deletions. It plays a role as an information hub for storing and sharing information between various parties involved in construction projects. Users can communicate with each other via the internet and utilize functions implemented in the model server such as partial data import/export, file merge, version control, etc. IFC model servers using relational database systems have been developed. However, they suffered from slow performance and long transaction time due to a complex mapping process between the IFC structure and a relational-database structure because the IFC model schema is defined in the EXPRESS language which is object-favored language. In order to simplify the mapping process, we developed a set of rules to map the IFC model to an object-relational database (ORDB). Once the database has been configured, only those pieces of information that are required for a specific information-exchange scenario are extracted using the pre-defined information delivery manual (IDM). Therefore, file sizes will be reduced when exchanging data, meaning that files can now be effectively exchanged and shared. In this study, the framework of the IFC server using ORDB and IDM and the method to develop it will be examined.

  • PDF

Development of Integrated Management System Based on GIS on Soft Ground (GIS 기법을 이용한 연약 지반 시공 관리 시스템의 개발)

  • Chun, Sung-Ho;Woo, Sang-Inn;Chung, Choong-Ki;Choi, In-Gul
    • Journal of the Korean Geotechnical Society
    • /
    • v.23 no.7
    • /
    • pp.37-46
    • /
    • 2007
  • In the practice of preloading method for soft ground improvement, field engineers need information of ground properties, construction works and field monitoring on ground behaviors of the site. So, integrating all these informations into one database can provide more efficient way for managing and utilizing the data for construction management. In this study, integrated system for construction management of ground improvement sites under preloading is developed. The developed system consists of database (DB) and application program. The database contains all collected data in a construction site and processed data in the system with their geographic information. All informations in the database are standardized from the result of data characterization. Application program performs various functions on managing and utilizing information in the database; pre- and post- data processing with graphic visualization of output, spatial data interpolation, and prediction of ground behavior using field measuring data. And by providing integrating informations and predictions over entire project area with comprehensible visual displays, the applicability and effectiveness of the developed system for construction management were confirmed.

Landsilde Analysis of Yongin Area Using Spatial Database (공간 데이터베이스를 이용한 1991년 용인지역 산사태 분석)

  • 이사로;민경덕
    • Economic and Environmental Geology
    • /
    • v.33 no.4
    • /
    • pp.321-332
    • /
    • 2000
  • The purpose of this study is to analyze landslide that occurred in Yongin area in 1991 using spatial database. For this, landslide locations are detected from aerial photographs interpretation and field survey. The locations of landslide, topography, soil, forest and geology were constructed to spatial database using Geographic Information System (GIS). To establish occurrence factors of landslide, slope, aspect and curvature of topography were calculated from the topographic database. Texture, material, drainage and effective thickness of soil were extracted from the soil database, and type, age, diameter and density of wood were extracted from the forest database. Lithology was extracted from the geological database, and land use was classified from the TM satellite image. Landslide was analyzed using spatial correlation between the landslide and the landslide occurrence factors by bivariate probability methods. GIS was used to analyze vast data efficiently and statistical programs were used to maintain specialty and accuracy. The result can be used to prevention of hazard, land use planning and construction planning as basic data.

  • PDF

A Study on the Web Database Construction for Modern House Plans (현대주택평면의 웹 데이터베이스 구축에 관한 연구)

  • 이현수;정승연
    • Journal of the Korean housing association
    • /
    • v.11 no.1
    • /
    • pp.151-158
    • /
    • 2000
  • The purpose of this study is to analyze systematically the characteristics and types of contemporary houses and to offer information concerning houses based on web database. This study deals with single-unit Korean houses designed by modern architects, which appeared in architectural periodicals and books published since 1990. This study sets three analysis criteria : general characteristics, morphological characteristics and functional characteristics of houses. Also, the web database including analysis contents is constructed to attain various information of the houses and results. The process of constructing the web database and the search method for house information retrieval are described. It is concluded that contemporary houses show various aspects of their plans in certain specific types. By using web database we obtained various analysis on house plan. This study investigated practicality of web database in architecture, interior design and house studies, and the types of contemporary house plans are revealed as well.

  • PDF