• Title/Summary/Keyword: Database Management System (DBMS)

Search Result 154, Processing Time 0.033 seconds

Design of Sensor Middleware Architecture on Multi Level Spatial DBMS with Snapshot (스냅샷을 가지는 다중 레벨 공간 DBMS를 기반으로 하는 센서 미들웨어 구조 설계)

  • Oh, Eun-Seog;Kim, Ho-Seok;Kim, Jae-Hong;Bae, Hae-Young
    • Journal of Korea Spatial Information System Society
    • /
    • v.8 no.1 s.16
    • /
    • pp.1-16
    • /
    • 2006
  • Recently, human based computing environment for supporting users to concentrate only user task without sensing other changes from users is being progressively researched and developed. But middleware deletes steream data processed for reducing process load of massive information from RFID sensor in this computing. So, this kind of middleware have problems when user demands probability or statistics needed for data warehousing or data mining and when user demands very important stream data repeatedly but already discarded in the middleware every former time. In this paper, we designs Sensor Middleware Architecture on Multi Level Spatial DBMS with Snapshot and manage repeatedly required stream datas to solve reusing problems of historical stream data in current middleware. This system uses disk databse that manages historical stream datas filtered in middleware for requiring services using historical stream information as data mining or data warehousing from user, and uses memory database that mamages highly reuseable data as a snapshot when stream data storaged in disk database has high reuse frequency from user. For the more, this system processes memory database management policy in a cycle to maintain high reusement and rapid service for users. Our paper system solves problems of repeated requirement of stream datas, or a policy decision service using historical stream data of current middleware. Also offers variant and rapid data services maintaining high data reusement of main memory snapshot datas.

  • PDF

A Study of Structural Analysis for Space Frame on the World Wide Web (인터넷을 통한 스페이스 프레임 구조 해석에 관한 연구)

  • Suk, Chang-Mok;Nam, Sang-Kwan;Park, Sang-Hoon;Jung, Hwan-Mok;Kwon, Young-Hwan
    • Journal of Korean Association for Spatial Structures
    • /
    • v.1 no.1 s.1
    • /
    • pp.135-142
    • /
    • 2001
  • This paper proposes structural analysis on the World Wide Web to form a part of the architectural design project. It purposes modeling space frames and a structural analysis program on the internet only by inputting basic data for forming a shape in the whole phase of space frame analysis. The analysis data is conducted by Oracle DBMS(DataBase Management System), GUI(Graphic User Internet) by Java Applet and connection with server and database by Java Servlet respectively. The result from modeling and analysis is provided as graphic and text file forms by web browsers. Programs can be executed irrespective of user's OS by using internet and highly-secured system is constructed taking advantage of Java. Of great efficiency is maintaining and recycling data as the whole is dealt by database from the beginning to the end of program.

  • PDF

Web-based Agricultural Machinery Rental Business Management System

  • Shin, Seung-Yeoub;Kang, Chang-Ho;Yu, Seok-Cheol;Kim, Byounggap;Kim, Yu-Yong;Kim, Jin-Oh;Lee, Kyou-Seung
    • Journal of Biosystems Engineering
    • /
    • v.39 no.4
    • /
    • pp.267-273
    • /
    • 2014
  • Purpose: This study was conducted to develop a web-based business management system to ensure the efficient operation and transparent management of government-subsidized agricultural machinery rental businesses. Methods: An MS_SQL2000 database management system (DBMS) solution was utilized in the system for high system compatibility and integrated management. This system was targeted to be compatible with Internet Explorer 6.0 or later and to ensure security and seamless web operations. The system administrator is able to manage a fleet of agricultural machinery, including various inventory codes, release and return, fleet registry, and business performance. Users (farmers) may search the database of rental machinery and reserve them. Results: With respect to rental reservations, the system administrator can manage the fleet by setting the rental status to Approved, Released, or Returned. Through the web, the administrator can also create a database that includes machinery specifications, features, and rental rates. In addition, business performance data can be analyzed using a diverse array of tools to streamline the rental business. Without having to go to the rental office, users can save time and money by searching for and renting agricultural machinery through the information available on the website, including availability, specifications, and rental fees. After deploying the system, the time required to analyze monthly performance and create reports was dramatically reduced from 20 days per person to one day per person. Conclusions: Since 2014, AMRB has been installed and is operating in agricultural machinery rental businesses in 31 cities and counties in South Korea. This study recommends continued expansion and dissemination of AMRB for the systematic and efficient management of agricultural machinery rental businesses.

The Study on Real-time LDAP Interface in used Main Memory Resident Database System (주기억장치 상주형 DBMS을 위한 실시간 LDAP Interface에 관한 연구)

  • Lee Jeong-Bae;Cha Sang-Gyun;Kim Hwan-Chul;Park Byung-Kwan
    • The KIPS Transactions:PartA
    • /
    • v.11A no.7 s.91
    • /
    • pp.475-482
    • /
    • 2004
  • We live in the flood of information due to advancement of information communication and increase of E-mail. Managing users huge in-formation systematically and speedy searching are needed in these social advancement. In this thesis, in order to satisfy these requirement, We suggested Real-time LDAP Interface using Main Memory Resident Database Management System which can manage a lot of information fast systematically. It is expected that system can provide advantage of performance improvement through replacing Main Memory Resident Database Management System without change of application which is required high speed process.

A Study on the Database Design in the MDO Environment (다분야 통합환경에서의 데이터베이스 설계 연구)

  • Hwang, Jin Yong;Jeong, Ju Yeong;Lee, Jae U;Byeon, Yeong Hwan
    • Journal of the Korean Society for Aeronautical & Space Sciences
    • /
    • v.31 no.5
    • /
    • pp.25-36
    • /
    • 2003
  • Aircraft design pursues integrated design efforts by considering all design elements together. In the integrated design environment, it is crucial for the design data to be consistent, free of errorm, and most recent. Database design process consists of the analysis of the data which shall be stored and managed, the construction of the E-R Diagram, and the mapping of the database table. As a DBMS (DataBase Management System), Oracle 8i is employed to design and construct the database. The database design methodology is devised to apply for the several MDO(Multidisciplinary Design Optimization) techniques like MDF(MultiDisplinary Feasible), IDF(Individual Discipline Feasible), and CO(Collaborative Optimization). The defined process is demonstrated through a couple of design examples, including a simple numerical example and a UCAV(Unmanned Combat Aerial Vehicle) design optimization.

Data Acquisition and Control System for a Large-scale Superconducting Test Facility (대형 초전도자석 테스트설비의 Data Acquisition&Control시스템)

  • Y. Chu;S. Baek;S. Baang;M. Kim;S. Lee;B. Lim;W. Chung;H. Park;K. Park
    • Proceedings of the Korea Institute of Applied Superconductivity and Cryogenics Conference
    • /
    • 2002.02a
    • /
    • pp.303-305
    • /
    • 2002
  • SSTF(Samsung Superconducting Test Facility) has been constructed at Samsung Advanced Institute of Technology to test the KSTAR(Korea Superconducting Tokamak Advanced Research) superconducting magnets and conductors. The SSTF DAC(Data Acquisition and Control) system basically consists of VME I/O modules, host PCs, and Ethernet links. VxWorks is used for the real-time OS of the VME IOC(Input/output Controller). EPICS (Experimental Physics and Industrial Control System) provides a software architecture for the communication between IOCs and host PCs. For the efficient management of measured data, the database management programs through NFS(Network File System) have been developed and successfully operated. In this paper, the current status of the SSTF DAC system, DBMS(DataBase Management System), recent test results, and future plans are presented.

  • PDF

Design and Implementation of Query Classification Component in Multi-Level DBMS for Location Based Service (위치기반 서비스를 위한 다중레벨 DBMS에 질의 분류 컴포넌트의 설계 및 구현)

  • Jang Seok-Kyu;Eo Sang Hun;Kim Myung-Heun;Bae Hae-Young
    • The KIPS Transactions:PartD
    • /
    • v.12D no.5 s.101
    • /
    • pp.689-698
    • /
    • 2005
  • Various systems are used to provide the location based services. But, the existing systems have some problems which have difficulties in dealing with faster services for above million people. In order to solve it, a multi-level DBMS which supports both fast data processing and large data management support should be used. The multi-level DBMS with snapshots has all the data existing in disk database and the data which are required to be processed for fast processing are managed in main memory database as snapshots. To optimize performance of this system for location based services, the query classification component which classifies the queries for efficient snapshot usage is needed. In this paper, the query classification component in multi-level DBMS for location based services is designed and implemented. The proposed component classifies queries into three types: (1) memory query, (2) disk query, (3) hybrid query, and increases the rate of snapshot usage. In addition, it applies division mechanisms which divide aspatial and spatial filter condition for partial snapshot usage. Hence, the proposed component enhances system performance by maximizing the usage of snapshot as a result of the efficient query classification.

Development of Open Land Management Information System(LMIS) Middleware (개방형 토지관리정보체계 미들웨어 개발에 관한 연구)

  • 서창완;백재현;홍성학
    • Spatial Information Research
    • /
    • v.9 no.2
    • /
    • pp.353-368
    • /
    • 2001
  • Recently central and local governments developed a huge spatial database and system using full-scale Geographic Information System (GIS). But Inconsistent spatial data through duplicated database management drops off in efficiency and confidence of administration. It is difficult to share data because of their unique system and data type. Under these circumstances Ministry of Construction and Transportation (MOCT) has been carrying out Land Management Information System (LMIS) to computerize land administration and policy affairs and to implement land database such as law, spatial, attribute data. A prerequisite mission of LMIS is to develop open system for solving the problem of duplicated data management and data sharing and for supporting various computer environments such as hardware, software, network etc. The purpose of LMIS is to reuse the existing investment resources and to expand the existing system resources. Therefore the purpose of this study is to investigate a method of LMIS operation under the existing circumstances and expansion of the system in the future. To do this, Supporting various DBMS, GIS server, Distributing Computing Platform(Unix, NT Server) is needed. Especially LMIS need to be developed as open system with interoperability to get independence of application from various GIS servers.

  • PDF

A Preliminary Study of Prototype for Improving VE Workshop Phase based on BIM (BIM 기반 VE 워크샵 단계의 업무 향상을 위한 프로토타입 개발에 관한 기초연구)

  • Kim, Hojun;Park, Heetaek;Park, Chansik
    • Korean Journal of Construction Engineering and Management
    • /
    • v.16 no.3
    • /
    • pp.113-122
    • /
    • 2015
  • VE workshop is performed based on VE expert' experiences without retrieving VE data of similar previous projects. Moreover, it usually omitted or applied for the sake of formality due to insufficiently understanding VE function, limited time, space and budget. Even though many studies have established VE databases for retrieving and reusing VE data, VE workshop is still inefficient and ineffective to improve projects' values. With this regard, this study proposes a preliminary prototype for improving VE workshop, which utilizes the state-of-the-art information communication technologies(ICTs) including Building Information Modeling(BIM), Mobile Computing(MC), Network Service System(NSS), and Database Management System(DBMS) for better managing, storing and reusing VE data. The prototype was developed to evaluate advantages and limitations. The results show that the proposed prototype can support visual VE data retrieval from similar previous projects, enhance communication among VE team and save much time and cost comparing to traditional VE. Through this, the productivity of VE workshop can improve efficiently and effectively.

An Efficient Logging Scheme based on Dynamic Block Allocation for Flash Memory-based DBMS (플래시 메모리 기반의 DBMS를 위한 동적 블록 할당에 기반한 효율적인 로깅 방법)

  • Ha, Ji-Hoon;Lee, Ki-Yong;Kim, Myoung-Ho
    • Journal of KIISE:Databases
    • /
    • v.36 no.5
    • /
    • pp.374-385
    • /
    • 2009
  • Flash memory becomes increasingly popular as data storage for various devices because of its versatile features such as non-volatility, light weight, low power consumption, and shock resistance. Flash memory, however, has some distinct characteristics that make today's disk-based database technology unsuitable, such as no in-place update and the asymmetric speed of read and write operations. As a result, most traditional disk-based database systems may not provide the best attainable performance on flash memory. To maximize the database performance on flash memory, some approaches have been proposed where only the changes made to the database, i.e., logs, are written to another empty place that has born erased in advance. In this paper, we propose an efficient log management scheme for flash-based database systems. Unlike the previous approaches, the proposed approach stores logs in specially allocated blocks, called log blocks. By evenly distributing logs across log blocks, the proposed approach can significantly reduce the number of write and erase operations. Our performance evaluation shows that the proposed approaches can improve the overall system performance by reducing the number of write and erase operation compared to the previous ones.