• 제목/요약/키워드: Construction of DB

Search Result 612, Processing Time 0.025 seconds

A Study on Database System for Hostorical Booking of Korean Railroad (한국철도의 예약실적 데이터베이스 시스템에 관한 연구)

  • Oh, Seog-Moon;Hwang, Jong-Gyu;Hyeon, Seung-Ho;Kim, Yong-Gyu;Lee, Jong-Woo;Kim, Young-Hoon;Hong, Soon-Heum;Park, Jong-Bin
    • Proceedings of the KIEE Conference
    • /
    • 1998.07a
    • /
    • pp.371-374
    • /
    • 1998
  • The construction of the transportation history database system is to serve the scheduling and seat inventory controling. Recently, lots of countries have been faced with the advance era because of the new railway transportation system, like the high speed railway and/or magnetic levitation vehicle system. This can be reasonably translated as those of operators are willing to provide the more various and high quality schedule to the customer. Those operators these ideas make possible to forecast that scheduling process is going to be complicated more and more. The seat inventory control, so to speak Yield Management System(YMS), goes a long way to improve the total passenger revenue at the railway business. The YMS forecasts the number of the last reservation value(DCP# END) and recommends the optimal values on the seat sales. The history database system contains infra-data(ie, train, seat, sales) that will be the foundation of scheduling and seat inventory control application programs. The development of the application programs are reserved to the next step. The database system is installed on the pc platform (IBM compatible), using the DB2(RDBMS). And at next step, the platform and DBMS will be considered whether they can meet the users' requirement or not.

  • PDF

Implementation and Design of WISD(Web Interface System based DICOM) for Efficient Sharing of Medical Information between Clinics (의료기관간 효과적인 의료정보 공유를 위한 WISD의 설계 및 구현)

  • Cho, Ik-Sung;Kwon, Hyeog-Soong
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.12 no.3
    • /
    • pp.500-508
    • /
    • 2008
  • For efficient compatible system between medical clinics, the medical information has to be built on a standardized protocol such as a HL7 for text data and a DICOM for image data. But it is difficult to exchange information between medical clinics because the systems and softwares are different and also a structure of data and a type of code. Therefore we analyze a structure of DICOM file and design an integrated database for effective information sharing and exchange. The WISD system suggested in this paper separate the DICOM file transmitted by medical clinics to text data and image data and store it in the integrated DB(database) by standardized protocol respectively. It is very efficient that each medical clinic can search and exchange information by web browser using the suggested system. The WISD system can not only search and control of image data and patient information through integrated database and internet, but share medical information without extra charge like construction of new system.

Analysis of Slope Hazard-Triggering Rainfall Characteristics in Gangwon Province by Database Construction (DB구축을 통한 강원지역 사면재해 유발강우특성 분석)

  • Yune, Chan-Young;Jun, Kyoung-Jea;Kim, Kyung-Suk;Kim, Gi-Hong;Lee, Seung-Woo
    • Journal of the Korean Geotechnical Society
    • /
    • v.26 no.10
    • /
    • pp.27-38
    • /
    • 2010
  • In every summer season, most of the slope failures and debris flows occurr due to seasonal rain, typhoon, and localized extreme rainfall in Gangwon Province where 83% of the area is of mountain region. To investigate the slope-hazard triggering rainfall characteristics in Gangwon Province, slope hazard data, precipitation records, and forest fire data were collected and the DATABASE was constructed. Analysis results based on the DATABASE showed that many slope hazards occurred when there was little rainfall and the preceding rainfall had more effect on the slope hazard than the rainfall intensity at the day of hazard. It also showed that the burned area by forest fire was highly susceptible to slope hazard with low rainfall intensity, and the slope hazard in burned area showed highest frequency, especially, under the rainfall below 2-year return period.

Modeling Metaverse Avatars and K-Fashion Apparel 3D Production -Focus on Developing Styling Work with K-Designer Items- (메타버스 아바타 및 K-패션의류 3D 제작 모델링-K 디자이너 아이템을 활용한 스타일링 작업물 개발을 중심으로-)

  • Sojin Kim;Boyoung Kang
    • Journal of Fashion Business
    • /
    • v.27 no.5
    • /
    • pp.60-77
    • /
    • 2023
  • The scale of the industry utilizing the Metaverse platform is gradually growing around the world. Fashion brands are also starting to utilize the Metaverse platform as a new market to replace the next e-commerce platform by targeting new consumers, MZ generation, and even Alpha generation. In this study, a real K-fashion designer's outfit was made into a 3D outfit using CLO 3D program to express it in a new market, the Metaverse 3D platform. It was then compared with a real outfit. An avatar prototype was completed using Max program to simulate the 3D digital fashion outfit and produce an avatar through an optimization process. The 3D outfits showed the same level of results as the actual outfits in terms of fabric surface, material texture, drapability, overall outfit, details, and trimmings. In addition, we proposed a 2D work on total styling suggestion and modeling to secure data sets for future AI-based styling services. In conclusion, this study revealed that actual outfits and 3D outfits had the same results. It is significant that it can be a sample work to build a styling data set through styling suggestion and content production as a significant amount of styling DB construction will be required before AI styling automation services.

Constructing Spatial Data Warehouse for Forest Information Standardization Service of Municipal Governments (지자체 산림정보 표준화 서비스를 위한 공간 데이터웨어하우스 구축)

  • Jo, Yun-Won
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.12 no.2
    • /
    • pp.11-22
    • /
    • 2009
  • Recently the integration and development of ST(Spatial Technology) and forest geographic information have been used very efficiently for the forest administration. However, even though many application system related to forest information have been developed and improved, there are still paper based inventories management and hand work for data construction and upgrade. In this study the forest information warehouse, which is mapped and managed at work-site operations, was constructed based GIS technology so that the standardization and consistency of current data could be acquired in real time. In addition, these thematic maps were conducted on high resolution satellite images and managed in web based forest information data warehouse form and finally shared through Internet for the very first-line administration officials. This study shows that the forest information standardization service of municipal governments very first time in the Korea and provides the unified decision making support and enterprise formed forest database so that is expected to be the very successful sample to suggest the prototype of national forest spatial data infrastructure.

  • PDF

A Study on Detection and Resolving of Occlusion Area by Street Tree Object using ResNet Algorithm (ResNet 알고리즘을 이용한 가로수 객체의 폐색영역 검출 및 해결)

  • Park, Hong-Gi;Bae, Kyoung-Ho
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.21 no.10
    • /
    • pp.77-83
    • /
    • 2020
  • The technologies of 3D spatial information, such as Smart City and Digital Twins, are developing rapidly for managing land and solving urban problems scientifically. In this construction of 3D spatial information, an object using aerial photo images is built as a digital DB. Realistically, the task of extracting a texturing image, which is an actual image of the object wall, and attaching an image to the object wall are important. On the other hand, occluded areas occur in the texturing image. In this study, the ResNet algorithm in deep learning technologies was tested to solve these problems. A dataset was constructed, and the street tree was detected using the ResNet algorithm. The ability of the ResNet algorithm to detect the street tree was dependent on the brightness of the image. The ResNet algorithm can detect the street tree in an image with side and inclination angles.

A Statistical Study on Sikryo-chanryo by Applying Database (데이터베이스를 이용한 식료찬요(食療纂要)의 통계적 연구)

  • Lee, Byung Wook;Kim, Ki Wook;Hwang, Su-Jung
    • Culinary science and hospitality research
    • /
    • v.21 no.4
    • /
    • pp.251-270
    • /
    • 2015
  • This study was, based on traditional know-how indigenous to Korea, to systemize the knowledge on how to improve health by dining, and to make the best of it statistically. For this purpose, the knowledge in the Sikryo-chanryo(食療纂要), in Korean pronunciation and Siglyochan-yo in Chinese characters, which is an old text referring to diet therapy peculiar to Korea, was compiled into a database and analyzed statistically. Data processing was used as a 'Relational data model'. In addition, we have used nine data table to express diet therapy peculiar to Korea in the Siglyochan-yo. The software used for data construction was Microsoft Access 2014. As a result, the Sikryo-chanryo database, which can provide information on both disease treatment by food, medicines, and gourmet ingredients applicable to every kind of symptom, as well as the names of disease, was set up at in a PC interface. By employing the 'Relational data model', we can replace researching in the conventional method by employing the database.

GCP Chip Automatic Extraction of Satellite Imagery Using Interest Point in North Korea (특징점 추출기법을 이용한 접근불능지역의 위성영상 GCP 칩 자동추출)

  • Lee, Kye Dong;Yoon, Jong Seong
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.37 no.4
    • /
    • pp.211-218
    • /
    • 2019
  • The Ministry of Land, Infrastructure and Transport is planning to launch CAS-500 (Compact Advanced Satellite 500) 1 and 2 in 2019 and 2020. Satellite image information collected through CAS-500 can be used in various fields such as global environmental monitoring, topographic map production, analysis for disaster prevention. In order to utilize in various fields like this, it is important to get the location accuracy of the satellite image. In order to establish the precise geometry of the satellite image, it is necessary to establish a precise sensor model using the GCP (Ground Control Point). In order to utilize various fields, step - by - step automation for orthoimage construction is required. To do this, a database of satellite image GCP chip should be structured systematically. Therefore, in this study, we will analyze various techniques for automatic GCP extraction for precise geometry of satellite images.

A Study on the Quality Control Method for Geotechnical Information Using AI (AI를 이용한 지반정보 품질관리 방안에 관한 연구)

  • Park, Ka-Hyun;Kim, Jongkwan;Lee, Seokhyung;Kim, Min-Ki;Lee, Kyung-Ryoon;Han, Jin-Tae
    • Journal of the Korean Geotechnical Society
    • /
    • v.38 no.11
    • /
    • pp.87-95
    • /
    • 2022
  • The geotechnical information constructed in the National Geotechnical Information DB System has been extensively used in design, construction, underground safety management, and disaster assessment. However, it is necessary to refine the geotechnical information because it has nearly 300,000 established cases containing a lot of missing or incorrect information. This research proposes a method for automatic quality control of geotechnical information using a fully connected neural network. Significantly, the anomalies in geotechnical information were detected using a database combining the standard penetration test results and strata information of Seoul. Consequently, the misclassification rate for the verification data is confirmed as 5.4%. Overall, the studied algorithm is expected to detect outliers of geotechnical information effectively.

Development of Urban Object Identification System Based on Network for Intelligent Urban Facility Management (지능형 도시시설물 관리를 위한 네트워크 기반 도시공간객체식별자(UOID) 시스템 개발)

  • Kim, Tae-Hoon
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.14 no.4
    • /
    • pp.172-181
    • /
    • 2011
  • Recently, Urban has been innovated through u-City and Smart City. Urban facility management system is developing using the latest IT technology for real-time monitoring and prevention. In this paper, we propose an UOID(Unique Object IDentification), a standard location-based ID system for urban facility object and develop the UOID service system based on network for innovation of urban facility management system. The system has been tested through Test-bed for connectivity and stability. We wish that the proposed UOID and network service system manages u-City facilities effectively and also provides various ubiquitous services to the citizen, one of the integrate service of u-City platform.