DOI QR코드

DOI QR Code

Analysis of Environment Improving Budget of School Facilities by Using Data Warehouse Technology - Focused on Elementary, Middle, High School of OO Office of Education -

데이터 웨어하우스 기술을 활용한 학교시설물의 환경개선예산 분석 - OO교육청 초·중·고등학교를 중심으로 -

  • 박민규 (창원대학교 일반대학원 건축공학과) ;
  • 손창백 (세명대학교 건축공학과) ;
  • 류한국 (창원대학교 건축공학과)
  • Received : 2014.02.20
  • Accepted : 2014.03.28
  • Published : 2014.04.30

Abstract

With introduction of amended educational curriculum in 2007, optimizing project of educational environment to accomplish its purposes and goals includes expanding educational facilities and supplying eco-friendly school facilities. However, while the focus of optimizing project of educational environment is quality improvement of educational facilities, aging of these facilities built at th times of quantitative expansion and its management become serious problems. Higher concerns on studies and jobs on management of building caused by serious aging of facilities, management cost of building becomes a very crucial issue. Therefore, this study aims to analyze environment improvement budget of school facilities through building and using data warehouse, by investigating and analyzing the current status of environment improvement budget of school facilities and its cost through questionnaire and interview surveys on officers who are in charge of environment improvement budget of school facilities in educational administrations. This study thus analyzed environment improving budget of school facilities by using data warehouse technology collecting related data to the topic and setting levels by region, school class, establishment year, school facility types and others.

Keywords

References

  1. 권오주, BI 구축을 위한 SQL Server 2008 Analysis Services 포켓가이드, 한국마이크로소프트(유), 2008.
  2. 대전광역시 서부교육청 학교시설물의 관리에 대한 효율화 방안, 2007.
  3. 류한국, 건설공사 자재관리를 위한 데이터 웨어하우스 개발, 한국건축시공학회 논문, 11권 3호, 2011.06.
  4. 류한국, 공가기간 영향요인에 따른 생산성의 OLAP 분석과 의사결정트리 분석, 한국건축시공학회 논문, 11권 2호, 2011.04.
  5. 민창기, 학교시설의 효율적인 유지관리를 위한 연구, 학교교육시설학회 춘계학술발표대회 논문집, 1997.
  6. 송유진, 데이터 모델링을 통한 데이터 웨어하우스 구축, 연세대학교 산업대학원 논문, 2000.
  7. 이춘경 외, 건축물 유지관리 효율화를 위한 지원 체계구축 방안 연구, 대학건축학회 논문집(구조계), 2007.
  8. 임진홍, 정보체계변혁을 위한 Data warehouse의 도입과 향후 발전 모습, 삼성 SDS 논문, 2000.
  9. 조재희 외, 데이터 웨어하우징과 OLAP, 대청, 1996.
  10. Oracle Korea, DW연구 책자, 2003.
  11. William Inmon, Data Warehouse Performance. Second edition, New York: John Wiley & Sons, 1999.