• Title/Summary/Keyword: SQL-database

Search Result 433, Processing Time 0.023 seconds

A Study on the Maintenance of Communication Facilities using the Standardized Database (표준화된 데이터베이스 구축을 통한 지하철 통신설비의 효율적 관리방안 연구)

  • Kim, Gil-Dong;Shin, Jeong-Ryol;Lee, Woo-Dong;Kang, Seung-Wook
    • Proceedings of the KIEE Conference
    • /
    • 2004.07e
    • /
    • pp.99-102
    • /
    • 2004
  • 21세기 정보화시대에 맞추어, 도시철도운영기관의 전략적 발전과 도시철도의 정보화 기술 축적 및 표준화된 정보 인프라 구축의 일환으로 도시철도 시설물 유지보수체계를 표준화하고 정보화시스템을 구축중에 있다. 이중, 도시철도 통신 설비의 효율적인 유지보수를 위해서 유지보수체계의 표준화 및 정보화시스템 구축을 통한 실시간 정보의 구축 및 기존 유지보수작업 이력정보의 관리가 매우 중요하다. 본 연구에서는 도시철도 통신 설비의 효율적인 유지관리를 위한 데이터베이스 설계 및 구축방안에 대하여 제시하였다. 통신 설비의 데이터베이스 구축을 위하여 표준분류체계를 수립하였고, 관리항목 및 유지보수작업항목을 표준화하였으며, 유지 보수업무절차를 표준화하고 도면 및 각종 문서양식을 표준화하였다. 통신 설비의 데이터베이스는 개체관계모델(ERB)을 사용하여 설계하였고 특히, 통신 설비는 위치정보와 밀접한 관계를 가지고 있으므로 일반 데이터 외에 GIS용 공간 데이터베이스를 구축하여 서로 연관된 Key를 가지고 상호조회가 가능하도록 설계하였다. 그리고, 통신 설비에 대한 기초 데이터를 구축하기 위한 방안으로 엑셀조사 양식을 통하여 방대한 기초 자료를 작성하고, $SQL^*$Loader 등의 데이터 변환프로그램을 활용하여 데이터베이스에 일괄 등록되도록 하는 방안을 제시하였다 또한. 도면반입절차서 및 표준도면작성지침서, 그리고 GIS DB 구축지침서를 통하여 표준화된 데이터베이스 구축이 이루어지도록 하였다.

  • PDF

A Study on the Maintenance of Signal Facilities using the Standardized Database (표준화된 데이터베이스 구축을 통한 지하철 신호장치의 효율적 관리방안 연구)

  • Kim, Gil-Dong;Shin, Jeong-Ryol;Lee, Woo-Dong;Kang, Seung-Wook
    • Proceedings of the KIEE Conference
    • /
    • 2004.07e
    • /
    • pp.130-133
    • /
    • 2004
  • 21세기 정보화시대에 맞추어, 도시철도운영기관의 전략적 발전과 도시철도의 정보화 기술 축적및 표준화된 정보 인프라 구축의 일환으로 도시철도 시설물 유지보수체계를 표준화하고 정보화시스템을 구축중에 있다. 이중, 도시철도 신호 장치의 효율적인 유지보수를 위해서 유지보수체계의 표준화 및 정보화시스템 구축을 통한 실시간 정보의 구축 및 기존 유지보수작업 이력정보의 관리가 매우 중요하다. 본 연구에서는 도시철도 신호 장치의 효율적인 유지관리를 위한 데이터베이스설계 및 구축방안에 대하여 제시하였다. 신호 장치의 데이터베이스 구축을 위하여 표준분류체계를 수립하였고, 관리항목 및 유지보수작업항목을 표준화하였으며, 유지보수업무절차를 표준화하고 도면 및 각종 문서양식을 표준화하였다. 신호 장치의 데이터베이스는 개체관계모델(ERD)을 사용하여 설계하였고 특히, 신호 장치는 위치 정보와 밀접한 관계를 가지고 있으므로 일반 데이터 외에 GIS용 공간 데이터베이스를 구축하여 서로 연관된 Key를 가지고 상호조회가 가능하도록 설계하였다. 그리고, 신호 장치에 대한 기초 데이터를 구축하기 위한 방안으로 엑셀조사 양식을 통하여 방대한 기초 자료를 작성하고, SQL*Loader 등의 데이터 변환프로그램을 활용하여 데이터베이스에 일괄 등록되도록 하는 방안을 제시하였다 또한, 도면반입절차서 및 표준도면작성지침서, 그리고 GIS DB 구축지침서를 통하여 표준화된 데이터베이스 구축이 이루어지도록 하였다.

  • PDF

A Study on the Ontology Query Module based on Natural Language (자연어 기반 온톨로지 질의 모듈 연구)

  • Kim, Won-Pil;Kong, Hyun-Jang
    • Journal of the Institute of Electronics Engineers of Korea CI
    • /
    • v.47 no.1
    • /
    • pp.146-151
    • /
    • 2010
  • For an application of ontology, query processing is mandatory field for efficient information search in the ontology. Other query processing systems tend to analyze only facts and to simply provide structural information for users. In fact, the systems do not have big difference with database systems or text based information processing systems. Therefore, in this research, the method which can provide the inferred information based on axioms is suggested in order to maximize reusability of ontology.

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.

A Study on the DB-IR Integration: Per-Document Basis Online Index Maintenance

  • Jin, Du-Seok;Jung, Hoe-Kyung
    • Journal of information and communication convergence engineering
    • /
    • v.7 no.3
    • /
    • pp.275-280
    • /
    • 2009
  • While database(DB) and information retrieval(IR) have been developed independently, there have been emerging requirements that both data management and efficient text retrieval should be supported simultaneously in an information system such as health care, customer support, XML data management, and digital libraries. The great divide between DB and IR has caused different manners in index maintenance for newly arriving documents. While DB has extended its SQL layer to cope with text fields due to lack of intact mechanism to build IR-like index, IR usually treats a block of new documents as a logical unit of index maintenance since it has no concept of integrity constraint. However, In the DB-IR integrations, a transaction on adding or updating a document should include maintenance of the posting lists accompanied by the document. Although DB-IR integration has been budded in the research filed, the issue will remain difficult and rewarding areas for a while. One of the primary reasons is lack of efficient online transactional index maintenance. In this paper, performance of a few strategies for per-document basis transactional index maintenance - direct index update, pulsing auxiliary index and posting segmentation index - will be evaluated. The result shows that the pulsing auxiliary strategy and posting segmentation indexing scheme, can be a challenging candidates for text field indexing in DB-IR integration.

Development of Gamsung Index Database for Web (웹 기반 감성지표 DB 구축에 관한 연구)

  • 곽현민;조해성;이상태
    • Proceedings of the Korean Society for Emotion and Sensibility Conference
    • /
    • 2002.05a
    • /
    • pp.79-85
    • /
    • 2002
  • 감성 연구의 생리, 심리, 동작 분석 등의 과정에서 발생하는 문서, 데이터, 화상, 그림, 그래픽 등의 자료 공유에 인터넷을 적용하는 것은 매우 유망하다. 본 연구에서는 현재의 인터넷 (또는 인트라넷) 환경을 고려하여 Ultra 2 DB 서버, Sun Solaris (UNIX) OS, UniSql DBMS, Apache Web 서버로 시스템을 구축하였다. 이 시스템을 이용하여 웹기반 감성데이터 베이스 시제품을 구축하여 각종 감성자료를 보급하는 체계를 1차 완료하였으며, 도메인(www.gamsung.or.kr)을 등록하여 서비스를 실시하고 있다. 이 시스템에는 1단계 감성공학기술개발 사업의 35개 연구보고서, 1단계 연구결과로서 생산한 262개 감성지표, 2단계 연구사업의 130개 감성지표, 일본의 인간감각계측 및 응용기술개발 중심으로 생산한 125개 감성지표, 음성데이터, 음향데이터, 인체측정데이터, 얼굴표정데이터와 설문데이터 등의 감성데이터와 감성공학 연구자 인력, 국내제조업체 정보, 참고문헌, 감성 정보물 등을 DB화하여 인터넷을 통하여 조회, 검색할 수 있도록 하였다. 뿐만 아니라 현재 진행되고 있는 감성 공학기술개발에 대한 각종 정보를 제공하고 있으며 감성공학의 기술 동향에 대해서도 소개하고 있다. 이는 한국인의 감성 연구에 적합한 감성공학 데이터 베이스 시스템 구축의 발판을 마련하였으며, 향후 소비자의 감성을 예측하고, 이를 시스템 설계에 반영할 수 있으므로 인간중심의 제품개발에 큰 기여를 할 것으로 기대된다.

  • PDF

Methods of DICOM and Non-DICOM Interfacing for various Radiological Equipments with PACS (방사선 검사 관련 의료장비와 PACS 간의 연동을 위한 DICOM 및 Non-DICOM 인터페이스 방안)

  • Kim, H.C.
    • Korean Journal of Digital Imaging in Medicine
    • /
    • v.6 no.1
    • /
    • pp.51-64
    • /
    • 2003
  • This thesis describes the effective interfacing methods of PACS Modality based on the system installation andoperating experiences. PACS(Picture Archiving and Communication Systems) is a system for medical image archiving and communication using large storage device and high-speed network. The standard communication protocol of PACS is DICOM(Digital Imaging and Communication in Medicine) based on TCP/IP and point-to-point protocol. However, there are many Non-DICOM Modalities and DICOM Modalities having problems. First, we had interfaced almost modalities. Fuji CR, GE CT, MRI, Angio, Fluoro, Phillips Angio, Shimadzu Fluoro. Ultrasound PACS, with the main PACS in the Seoul S Hospital as large scale hospital. And we manipulated the intelligent image distribution and the CT. MRI Interfaces never experienced beforein the Anyang J Hospital and the Chungju C Hospital as mid or small scale hospital. Technically, we developed both the DICOM Interface and the Non-DICOM Interface. At the last, the DICOM Worklist and the DICOM Print Interface were implemented in the Seoul B Hospital, the Bucheon SJ Hospital and the Seoul K Hospital independently with PACS. The Oracle, Sybase and MS-SQL are used as database, and UNIX, Macintosh, MS Windows as operating systems. And the Visual C++ and UNIX C are the main programming tools. We have used UTP, coaxial and fiber optic cable under 10/100 mbps LAN for networking.

  • PDF

A Case Study on Mobile Web-service Implementation for a VMI System of Small.medium sized the Auto-parts Manufacturer in Supply Chain (공급사슬관계에서 중.소 자동차부품제조업체의 VMI시스템에 관한 웹서비스구현)

  • Na, Sang-Gyun;Oh, Myung-Hyun;Jeong, Byung-Ho;Lee, Jun-Su
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.30 no.2
    • /
    • pp.29-36
    • /
    • 2007
  • This study was concerned about mobile web-service of a VMI in the SCM system. The VMI would be a main module part of the SCM and regarded as very important thing on supply chain. Therefore, it was essential to react in real time of materials production and situation of used auto-part in procurement company. We could find an affordable method to realize the VMI in a web service. The web service has made inter relevant enterprise easy to collaborate because of supporting most operating system and frame-work. Moreover, the use of a mobile tools was guaranteed a product recording and requirement of materials to real time in a rapid changing of production environments. The result of this research was very useful to apply the VMI system in medium and small sized auto parts company. This web service package has programmed the Visual Studio Dot Net 2003 and the MS SQL 2000 as database.

Methods of DICOM and Non-DICOM Interfacing for various Radiological Equipments with PACS (방사선 검사 관련 의료장비와 PACS 간의 연동을 위한 DICOM 및 Non-DICOM 인터페이스 방안)

  • Kim, Hyeon-Cheol
    • Korean Journal of Digital Imaging in Medicine
    • /
    • v.5 no.1
    • /
    • pp.46-63
    • /
    • 2002
  • This thesis describes the effective interfacing methods of PACS Modality based on the system installation and operating experiences. PACS(Picture Archiving and Communication Systems) is a system for medical image archiving and communication using large storage device and high-speed network. The standard communication protocol of PACS is DICOM(Digital Imaging and Communication in Medicine) based on TCP/IP and point-to-point protocol. However, there are many Non-DICOM Modalities and DICOM Modalities having problems. First, we had interfaced almost modalities, Fuji CR, GE CT, MRI, Angio, Fluoro, Phillips Angio, Shimadzu Fluoro, Ultrasound PACS, with the main PACS in the Seoul S Hospital as large scale hospital. And we manipulated the intelligent image distribution and the CT, MRI Interfaces never experienced before in the Anyang J Hospital and the Chungju C Hospital as mid or small scale hospital. Technically, we developed both the DICOM Interface and the Non-DICOM Interface. At the last, the DICOM Worklist and the DICOM Print Interface were implemented in the Seoul B Hospital, the Bucheon SJ Hospital and the Seoul K Hospital independently with PACS. The Oracle, Sybase and MS-SQL are used as database, and UNIX, Macintosh, MS Windows as operating systems. And the Visual C++ and UNIX C are the main programming tools. We have used UTP, coaxial and fiber optic Gable under 10/100 mbps LAN for networking.

  • PDF

Development of Wed-Based Courseware in Oral Health Education for Elementary School Children (초등학교 구강보건교육을 위한 코스웨어 개발)

  • 최빈아;장창곡
    • Korean Journal of Health Education and Promotion
    • /
    • v.20 no.2
    • /
    • pp.1-18
    • /
    • 2003
  • The purpose of this study was to develop game style courseware in oral health instruction for elementary school children. The manufacturing equipment and languages which were used to develop the courseware were: Photoshop version 7.0, Illustrator version 10.0, HTML, Dream Weaver MX, Editplus, CSS and Java - script. The data base was built up by using PHP and mySQL over Internet Explorer version 4.0. The contents of courseware for oral health education were based on the list of oral health affaires of the Department of Health and Welfare, 2002. The story of the game ‘Saving Hayani locked down in a castle of a cavity man’ was developed for the learners to learn oral health by inducing learning motivation. A character named ‘Chan i’ was introduced to the learners to be more friendly with the program while they were learning. As the game was made of three step education levels, the learner most pass the prepared test given at each step to advance to a higher level. A database connected to web was constructed to store the scores the learners earned at each step. In conclusion, the courseware will help the elementary school children learn oral health care efficiently through the internet regardless of time and space.