• Proceedings of the KSR Conference
• /
• 1998.05a
• /
• pp.23-30
• /
• 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.

• Journal of the Korea Society of Computer and Information
• /
• v.12 no.2 s.46
• /
• pp.9-19
• /
• 2007

In recent, development of wireless internet technology gradually has increased multimedia application in mobile device. Specially, application of grand capacity multimedia contents has increased in mobile environment gradually. MPEG-7 can search multimedia data using various type. But in restricted grand capacity of multimedia, MPEG-7 is used to be limited in desktop computer system mostly. Therefore, management of grand capacity multimedia data has become very important researching topic in mobile environment, and so embedded DBMS based on MPEG-7 for multimedia data management in client-server environment is needed. The system supports restricted hardware resource for multimedia application in mobile device. In this paper, we propose a method for MPEG-7 data clustering that included MPEG-7 data property. On the base of the clustering result, we also develop the embedded multimedia database management system based on MPEG-7 scheme(EMDS:MPEG-7 Scheme Based Embedded Multimedia Database Management System) in mobile device such as PDA.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1998.10a
• /
• pp.259-262
• /
• 1998

DNC(Distributed Numerical controller)는 제품을 생산하기 위해 현장용 컴퓨터를 이용하여 공작기계 및 주변장치를 제어하고 감시한다. 본 논문에서는 SFC/OP(Shop Floor Control/point of Production) 시스템과 연계시키기 위한 DNC 시스템의 구조를 제시한다. 본 시스템은 도면 정보를 유기적으로 연결하여 작업절차서를 조회하고, 작업절차서 및 NC 프로그램/공구 보정 데이타를 인덱스 데이터베이스화하고, 소재·지그·공구를 연계한다. 또한 생산정보를 빠르고 능동적으로 현장 작업자에게 전달하고, 기계의 상태정보를 기계로부터 직접 수집함으로써 실시간 모니터링이 가능하다. 분석 및 설계단계에서는 실시간으로 발생하는 이벤트를 처리하기 위해 상태전이도(State Transition Diagram)를 사용한다. 서버 DBMS(Database Management System)로 관계형 데이터베이스를 채택한 Oracle을 사용하였고, 프로그램 개발도구로는 Developer 2000, Microsoft Visual C++ 5.0을 사용하여 구현한다.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.10 no.11
• /
• pp.3207-3212
• /
• 2009

Automatic semiconductor manufacturing systems are demanded to improve the efficiency of the semiconductor production process. These systems include the functionalities such as the analysis and management schemes for very large real-time data in order to enhance the productivities. So, it requires the efficient storage management system to store very large real-time data. Traditional database management systems(e.g. Oracle, MY-SQL, MS-SQL) are based on disk. However, previous DBMS's have the limitation on the low storing performance. In this paper, we propose a compress-merge storing method of very large real-time data using insert transaction of a block unit. The proposed method shows better processing performances compare to conventional DBMS's. Also compress-merge method makes it possible that it can store large real-time data on low storage cost. Therefore, the proposed method can be applied to an efficient storage management system in the semiconductor production process.

• The Journal of the Korea Contents Association
• /
• v.13 no.2
• /
• pp.32-43
• /
• 2013

These days, there are more and more IT research institutions which foresee cloud services as the predominant IT service in the near future and there, in fact, are actual cloud services provided by some IT leading vendors. Regardless of physical location of the service and environment of the system, cloud service can provide users with storage services, usage of data and software. On the other hand, cloud service has challenges as well. Even though cloud service has its edge in terms of the extent to which the IT resource can be freely utilized regardless of the confinement of hardware, the availability is another problem to be solved. Hence, this paper is dedicated to tackle the aforementioned issues; prerequisites of cloud computing for distributed file system, open source based Hadoop distributed file system, in-memory database technology and high availability database system. Also the author tries to body out the high availability mass distributed data management architecture in cloud service's perspective using currently used distributed file system in cloud computing market.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2016.05a
• /
• pp.674-675
• /
• 2016

In this paper, we propose a manufacturing process model of Internet of Things devices using a Printed Circuit Board (PCB)-mounted RFID tag chip for reducing electronic wastes. Electrical and electronic products require a PCB surface mount and many examination. Also, conventional barcode systems cannot provide traceability management in PCB manufacturing before finishing Surface Mount Technology (SMT) process. The proposed process model does not require workers' attaching and detaching process unlike barcode systems. Also, RFID tag chip can record all the data in manufacturing steps. Thus, the number of connections to a database management system (DBMS) can be reduced.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.11 no.3
• /
• pp.1557-1569
• /
• 2017

In recent times, the Internet of Things (IoT) has rapidly emerged as one of the most influential information and communication technologies (ICT). The various constituents of the IoT together offer novel technological opportunities by facilitating the so-called "hyper-connected world." The fundamental tasks that need to be performed to provide such a function involve the transceiving, storing, and analyzing of digital data. However, it is challenging to handle voluminous data with IoT devices because such devices generally lack sufficient computational capability. In this study, we examine the IoT from the perspective of security and digital forensics. SQLite is a light-weight database management system (DBMS) used in many IoT applications that stores private information. This information can be used in digital forensics as evidence. However, it is difficult to obtain critical evidence from IoT devices because the digital data stored in these devices is frequently deleted or updated. To address this issue, we propose Schema Pattern-based Recovery (SPaRe), an SQLite recovery scheme that leverages the pattern of a database schema. In particular, SPaRe exhaustively explores an SQLite database file and identifies all schematic patterns of a database record. We implemented SPaRe on an iPhone 6 running iOS 7 in order to test its performance. The results confirmed that SPaRe recovers an SQLite record at a high recovery rate.

• Review of KIISC
• /
• v.4 no.1
• /
• pp.44-52
• /
• 1994

정보화 사회에서는 가계, 기업, 정보 등의 정보 활동의 주체들이 가진 정보자산은 데이타 베이스(이하DB)와 소프트웨어(S/W)로 대변할 수 있으며, 이중 DB는 정보화 사회의 기반시설의 하나라고 볼 수 있다. 특별히 통계DB는 각 주체들에게는 필수적인 정보를 갖고 있다. 금융자산의 정보, 국방에 관련된 병력, 장비, 군수물자등의 정보, 회계정보 뿐 아니라 인구센서스, 경제계획수립 등등의 다양한 분야에 이 통계 DB는 사용되고 있다. 이러한 통계DB는 기존의DB에서의 데이타의 저장, 관리, 추출 기능외에 통계적인 데이타의 분석기능이 요구되고 있다. 통계 처리를 위한 데이타베이스관리 시스템(DBMS, database management system)은 주로 기존의 DBMS 에 통계처리를 위한 기능을 추가하거나 통계를 위한 DB를 따로 구축하는 방법을 사용하고 있다. 따라서 일반적인 DB 보호 기술과 더불어 통계 의 환경을 이해하는 보호 기술이 요구되고 있다. 일반적으로 DB 를 보호하는 방법으로는 물리적인 보안(physical security)과 운영체계 보안(operating system security) 이 있으며, 이들과 함께 데이타 암호화(data encryption)의 방법을 사용하고 있다. DB 의 보안 방법에 관한 연구 중 George I. Davida 등에 의한 방법은 중국인의 나머지 정리(chinese remainder thorem)를 사용하는 암호화 알고리즘을 이용하여 레코드(record) 단위의 암호화를 하며, Khamis A. Omar등에 의한 방법은 읽기, 쓰기, 갱신의 3단계의 사용자 등급을 부여하여 DB 접근의 제약을 가하는 기능을 갖고 있다. 본고에서는 특히 그 중요성이 더해가고 있는 통계 의 일반적인 개념을 살펴보며, 특성 지향형 질의 모델(characteristic-specified query model)의 보호기술을 살펴본다. 특별히 본고는 통계 DB의 보호에 대한 일반적인 조사 연구로서 잘 알려진 사실들을 많은 참고 문헌과 더불어 소개하는 내용으로 통계 DB의 보호에 관한 새로운 연구 결과는 아니다.

• Spatial Information Research
• /
• v.19 no.3
• /
• pp.43-52
• /
• 2011

Recently, interest in location-based service (LBS) which utilizes a DBMS in mobile system environment has been increasing, and it is expected to overcome the existing file-based system's limitation in advanced in-vehicle system by utilizing DBMS's advantages such as efficient storage, transaction management, modelling and spatial queries etc. In particular, the road network data corresponds to the most essential domain in a route planning system, which needs efficient management and maintenance. Accordingly, this study aims to develop an efficient graph-based geodata model for topological network data and to support dynamic path computation algorithm based on heuristic approach in mobile LBS system. To achieve this goal, we design a data model for supporting the hierarchy of network, and implement a path planning system to evaluate its performance in mobile LBS system. Last but not least, we find out that the designed path computation algorithm with hierarchical graph model reduced the number of nodes used for finding and improved the efficiency of memory.

• Magazine of the Korean Society of Agricultural Engineers
• /
• v.35 no.2
• /
• pp.65-72
• /
• 1993

When a drought occurs in an area irrigated by multi-reservoirs, onerating a single reservoir separately to control the reservoir' storage is not a desirable solution. In order to reduce damages effectively for the areal drought, the storage of the reservoirs within the areal boundary should be managed as a group. Storage management procedures are as follows : 1. Collecting and checking the present storages of all reservoirs 2. Computing the drought frequency and depth; and finally, establishing a suitable storage saving strategy based on the estimated drought depth. For the purpose of this storage management, the RESTOMS(Reservoirs Storage Management System) was developed and the system was composed of the PRIME computer and the ORACLE as a distributed database management system, which was the host computer of Rural Development Corporation and would be on-lined with the regional offices throughout the country. Reservoirs operated by Farm Land Improvment Association were comprised in the DB system. Using the RESTOMS, the drought frequencies and drought depths were calculated with respect to the reservoir storage records(1967 to 1992). It was obvious that the results were closely corresponding to the real drought records.