• Title/Summary/Keyword: Database Quality Management

Search Result 459, Processing Time 0.026 seconds

A Study on Implementation and Design of Web-based Web-Cost Management System: Part 1; Design (웹 기반의 품질코스트 관리시스템 구축 : 제1부;시스템 설계)

  • Chung Young-Bae;Kim Yon-Soo;Kim Jun-Hong
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.27 no.3
    • /
    • pp.97-105
    • /
    • 2004
  • The purpose of this study is to design and implement web-based quality cost management system to measure the performance of quality improvement activities in the business firms. The designed web-based quality cost management system which is also known as WQCMS (Web-based Q-Cost Management System) utilized newly classified objective performance indicator items to measure quality related activities. Well-classified performance measurement Indicator item lists which are played key role in the system was researched and standardized according to size and business categories of enterprise. Its code standards are based from fundamental PAF Model. Developed WQCMS have ability to collect and analyze quality data generated from various different departments in the inside or outside of the enterprise without any limitations, if end-users are able to access wide area network. It provides the capability to integrate quality information from database and to generate various easy analysis reports to management's needs using built-in analysis tool modules with real-time. The proposed system was developed using Microsofi's .Net technology, ASP.NET and MS-SQL Server 2000. By web-enabling Q-cost management system, the effectiveness of the system management and utilization was realized by easiness of information Integration and economical efficiency.

Database for Patient Information Management in Radiation Oncology Department

  • Lim, Sangwook;Kim, Kyubo;Ahn, Sohyun;Lee, Sang Hoon;Lee, Rena;Cho, Samju
    • Progress in Medical Physics
    • /
    • v.29 no.1
    • /
    • pp.23-28
    • /
    • 2018
  • The purpose of this study is to build a database of patient information for efficient radiotherapy management. Microsoft Office Access was used to build the database owing to its convenience and compatibility. The most important aspect when building the patient database is to make the input and management of patient information efficient at every step of radiotherapy process. The information input starts from the patient's first visit to the radiation therapy department and ends upon completion of the radiotherapy. The forms for each step of radiotherapy process include the patient information form, the radiotherapy schedule form, the radiotherapy information form, the simulation order form, and the patient history form. Every form is centrically connected to the radiation oncology department's patient information form. A test revealed that the database was found to be efficient in managing patient information at each step. An important benefit of this database is improved efficiency in radiotherapy management. Information on patients who received radiotherapy is stored in a database. This means that this clinical data can be found easily and used in future, which will be helpful in research studies on the radiation oncology department. Benefits such as these will potentially contribute to improved radiotherapy quality.

Database and User Interface for Pollutant Source and Load Management of Yeungsan Estuarine Lake Watershed Using GIS (GIS를 활용한 영산호 수계 오염원 데이터베이스 구축과 오염원관리 사용자 인터페이스)

  • 양홍모
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.28 no.6
    • /
    • pp.114-126
    • /
    • 2001
  • The purpose of this study is to establish the databases of pollutant sources and water quality measurement data by utilizing GIS, and making the user interface for the management of pollutant sources. Yeongsan Estuarine Lake was formed of a huge levee of 4.35 km constructed by an agricultural reclamation project. Water quality of the reservoir has been degraded gradually, which mainly attributes to increase of point and non-point source pollutant loads from the lake's watershed of 33,374.3 $\textrm{km}^2$ into it. Application of GIS to establishment of the database was researched of pint source such as domestic sewage, industrial wastewater, farm wastes, and fishery wastes, and non-pont source such as residence, rice and upland field, and forest runoffs of the watershed of the lake. NT Acr/Info and ArcView were mainly utilized for the database formation. Land use of the watershed using LANDSAT image data was analyzed for non-point source pollutant load estimation. Pollutant loads from the watershed into the reservoir were calculated using the GIS database and BOD, TN, TP load units of point and non-point sources. Total BOD, TN, TP loads into it reached approximately to 141, 715, 2,094 and 4,743 kg/day respectively. The loads can be used as input parameters for water quality predicting model of it. A user-friendly interface program was developed using Dialog Designer and Avenue Script of AcrView, which can perform spatial analysis of point and non-point sources, calculate pollutant inputs from the sources, update attribute data of them, delete and add point sources, identify locations and volumes of water treatment facilities, and examine water quality data of water sampling points.

  • PDF

Establishment of Change Order Database for Reducing Change Order in Construction Phase

  • Shin, Hyun-Kyung;Cha, Yongwon;Han, Sangwon;Hyun, Chang-Taek
    • International conference on construction engineering and project management
    • /
    • 2015.10a
    • /
    • pp.622-624
    • /
    • 2015
  • As uncertain factors are latent in a construction project by nature, a change order occurs frequently. The occurrence of change orders in construction projects conducted during construction phase is known to cause unexpected negative impacts such as cost overrun, schedule delay, quality problem, and claims in the post-process. Thus, an efficient management method is necessary to prevent and minimize change orders during construction phase when they occur frequently. This paper analyzed the causes of change orders and the impact factors that occur during the construction phase of a construction project and suggested a direction for change order database building.

  • PDF

Development and Applications of Ecological Data Portal Service (EcoBank) for Sharing Ecological Information of Korea (생태정보의 공유를 위한 생태정보 포털서비스 (EcoBank) 구축 및 활용 방안)

  • Sung, Sunyong;Kwon, Yong Su;Kim, Ki Dong
    • Korean Journal of Ecology and Environment
    • /
    • v.51 no.3
    • /
    • pp.212-220
    • /
    • 2018
  • Ecological and ecosystem database is becoming very necessary to understand origins and relationship between human and nature and also to minimize disturbance caused by human activities. An ecological information portal can play important roles as a computing system to collect knowledge, distributed research findings and separated data from researchers. In this study, we designed and developed ecological information portal service (EcoBank 1.0) for collecting and providing ecological information for diverse classes of stakeholders. To reach the goal, we had reviewed related and comparable ecological database portals to design conceptual structure of EcoBank system including database management framework. Then, we developed some functions of ecosystem analysis for each stake-holders (researchers, general public and policy makers). As a result of this study, we successfully designed of EcoBank system covering the functions of Digital Object Identifier(DOI) publishing and data quality management process. Also, we (1) applied ecological indices for calculating biodiversity by administrative boundary for policy makers, (2) provided statistical information of econature map for general public and distribution characteristics of species for researchers. To make a successful establishment of EcoBank, we have to collect and build up related database and offer various and reliable ecological data consistently. We expect that the successful construction of EcoBank will help not only to accomplish sustainable development goals but also to raise the welfare of ecosystem in Korea.

Improving the Yield of Semiconductor Manufacturing Processes using Clustering Analysis and Response Surface Method (군집분석 및 반응표면분석법을 활용한 반도체 공정 수율향상에 관한 연구)

  • Koh, Kwan Ju;Kim, Na Yeon;Kim, Yong Soo
    • Journal of Korean Society for Quality Management
    • /
    • v.47 no.2
    • /
    • pp.381-395
    • /
    • 2019
  • Purpose: This study aims to conduct a systematic literature review to suitably identify wide and specific issues and topics on service quality in supply chain. Methods: This study is to investigate service quality in supply chain research using a systematic literature review methodology. In order to extract influential journals and papers, we used the SJR impact factor provided by the SCOPUS database. The collected 169 papers were analyzed using bibliometric analysis, citation analysis as well as keywords network. Results: We conducted a bibliometric analysis to identify top authors contributing to service quality in supply chain and their issues, and further examined important keywords and new emerging keywords. In addition, we extracted five influential papers by PageRank to clarify critical issues and divided into five clusters to identify topics of service quality in supply chain by using network-based approach. In order to examine comprehensive issues and topics of service quality in supply chain, we constructed a keyword network to observe difference in the classification of important keywords across network centrality measures. Conclusion: Our study reviewed literature on service quality in supply chain and explored the future directions and trends of service quality in supply chain.

Web-based Data Integration System Implementation for Reliability Improvement of a Product (제품의 신뢰성 향상를 위한 웹 기반 데이터 통합 시스템 구축에 관한 연구)

  • Kyung, Tae-Won;Kim, Sang-Kuk
    • Information Systems Review
    • /
    • v.7 no.2
    • /
    • pp.117-128
    • /
    • 2005
  • This study proposes an integrated monitoring system for data reliability improvement in a steel manufacturing industry. The data obtained from existing steel manufacturing process is not micro data which is gathered at the occurring point, but average value (macro data) which is gathered from the occurring point to ending point. This kind of macro data is not only difficult for a detailed analysis for an error causing factor, but it might cause a fatal influence as well on the quality of produced goods even if the error is within an error tolerance. And during the process of steel production, thousands of data is produced in a second, thus requiring database plan to manage abundant amount of data. Therefore, the following proposed system is capable of collecting as well as analyzing all the data generated from the process of product production. And the system was able to raise the efficiency of the database server by planning the database to handle large capacity data. Also, by applying web-based technology, inquiries and analysis of data with no limit on time and space was possible with PC connected to the intranet. Hence, the system was able to work on effective quality improvement of manufactured products, plus able to raise the reliability of the product. Also, accumulated data from long period of time was used for fundamental material for new controlling model, operation technology, and new product development.

A Water Quality Management System at Mokhyun Stream Watershed Using GIS and RS (GIS와 RS를 이용한 목현천 수질관리 정보체계)

  • Lee, In Soo;Lee, Kyoo Seock
    • Journal of Environmental Impact Assessment
    • /
    • v.8 no.4
    • /
    • pp.1-12
    • /
    • 1999
  • The purpose of this study is to develop a Water Quality Management System(WQMS), which calculates pollutant discharge and forecasts water quality with a water pollution model. Operational water quality management requires not only controlling pollutants but acquiring and managing exact information. A GIS software, ArcView 3.1 was used to enter or edit geographic data and attribute data, and Avenue Script was used to customize the user interface. PCI, a remote sensing software, was used to derive land cover classification from 20 m resolution SPOT data by image processing. WQMS has two subsystems, database subsystem and modelling subsystem. The database subsystem consisted of watershed data from digital maps, remote sensing data, government reports, census data and so on. The modelling subsystem consisted of NSPLM(NonStorm Pollutant Load Model) and SPLM(Storm Pollutant Load Model). It calculates the amount of pollutant and predicts water quality. These two subsystems were connected through a graphic display module. This system has been calibrated for and applied to Mokhyun Stream watershed.

  • PDF

Computerization of Quality Information System Using Personal Computers (PC를 이용한 품질정보시스템의 전산화)

  • Park, Chul-Joo;Oh, Yon Woo
    • Journal of Korean Society for Quality Management
    • /
    • v.24 no.2
    • /
    • pp.113-127
    • /
    • 1996
  • A various quality data are produced during nuclear fuel fabrication. In order to control quality data efficiently, Computerization of Quality Information System(QIS) using personal computer was established. Database control software and analysis software were developed for QIS. QIS was applied the fuel manufacturing and quality inspection. Quality trend analysis, process control, process capability and quality history docket for nuclear fuel manufacturing were performed by QIS. Through the Quality Information System, quality assurance, quality control, process control and manufacturing engineering were performed efficiently in nuclear fuel manufacturing.

  • PDF

Development of Web-based Process Management System for Spatial Data Construction (웹기반의 공간데이터 구축공정 관리시스템 개발)

  • Choi, Byoung-Gil;Kim, Sung-Soo;Cho, Kwang-Hee
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.14 no.3 s.37
    • /
    • pp.63-70
    • /
    • 2006
  • This study aims to development of web-based process management system for spatial data construction. For developing this system work classification of basic surveying was standardized and quality management method for spatial data was established. Production process and work classification system for basic surveying such as control point surveying using GPS, leveling, aerial photographing, digital mapping, topographic mapping, digital elevation modeling, aerial photographic DB construction and digital orthophotomap was standardized. The status of the output and quality inspection for basic surveying project were analyzed, and the elements of quality inspection and data format for the type of outputs were analyzed. Based on standardized and analyzed contents, web-based process management system was developed after database and process was designed. The process management system consisted of process management, quality control, metadata management, and system management.

  • PDF