• 제목/요약/키워드: database management

검색결과 3,883건 처리시간 0.034초

A Column-Aware Index Management Using Flash Memory for Read-Intensive Databases

  • Byun, Si-Woo;Jang, Seok-Woo
    • Journal of Information Processing Systems
    • /
    • 제11권3호
    • /
    • pp.389-405
    • /
    • 2015
  • Most traditional database systems exploit a record-oriented model where the attributes of a record are placed contiguously in a hard disk to achieve high performance writes. However, for read-mostly data warehouse systems, the column-oriented database has become a proper model because of its superior read performance. Today, flash memory is largely recognized as the preferred storage media for high-speed database systems. In this paper, we introduce a column-oriented database model based on flash memory and then propose a new column-aware flash indexing scheme for the high-speed column-oriented data warehouse systems. Our index management scheme, which uses an enhanced $B^+$-Tree, achieves superior search performance by indexing an embedded segment and packing an unused space in internal and leaf nodes. Based on the performance results of two test databases, we concluded that the column-aware flash index management outperforms the traditional scheme in the respect of the mixed operation throughput and its response time.

Design of the Database Learning System based on Learner Management Techniques

  • Ahn, Jeong-Yong
    • Journal of the Korean Data and Information Science Society
    • /
    • 제15권4호
    • /
    • pp.707-716
    • /
    • 2004
  • Recently, many areas of application such as statistics and industrial engineering are interested in the effective education of databases. In this article we design and implement a database learning system based on learner management techniques. The system supports a personalized/ team-centered learning environment, monitoring the learning attitude of learners, and a method for the assessment.

  • PDF

네비게이션을 이용한 절토사면 데이터 관리 시스템 (Slope-Navi) 구현 (Application of Navigation System on the Cut Slope Management)

  • 배상우;;구호본;이윤래
    • 한국지반공학회:학술대회논문집
    • /
    • 한국지반공학회 2010년도 추계 학술발표회
    • /
    • pp.1274-1281
    • /
    • 2010
  • Cut Slope Management System(CSMS) is a systematic maintenance and management system designed to prevent the collapse of cut slopes located along national roads and to minimize damages caused by slope collapse related accidents. In order to implement a maintenance and management system that will ensure safe road operation, the Korean government has started the inventory of cut slopes and developed a cut slope database since 2006. The study on the application of cut slope database is on-going and part of this study is the development of cut slope database management system (Slope-navi) using GIS technology and navigation system for the effective and efficient cut slope management using Information Technology. Using the Navigation Cut Slope Data Management System the previously developed database was checked and verified. The converted cut slope inventory data and field investigation reports of about 20,000 cut slopes were loaded in the navigation map. Through the development of the navigation's cut slope data search system, a systematic and efficient cut slope database management and operation in the prevention of slope collapse and remedial measure selection was established.

  • PDF

도로시설물 관리를 위한 Photo Database 설계에 관한 연구 (A Study on the design of Database for photograph of Road Facilities)

  • 엄우학;정동훈;김정현;김병국
    • Spatial Information Research
    • /
    • 제11권1호
    • /
    • pp.33-40
    • /
    • 2003
  • 본 논문에서는 도로 및 도로시설물의 신설과 보완에 관련된 정보의 효과적인 관리를 위해 CCD(Charge-Coupled Device) 카메라, GPS(Global Positioning Systems), INS(Inertial Navigation Systems)와 같은 3개의 위치관측센서를 통합한 차량을 이용하여 시범지역을 측량하고 이를 통해 획득된 자료를 구조적으로 Photo Database에 저장할 수 있는 방안을 제시하였다. 저장된 Database를 이용한 도로시설물관리시스템의 프로토타입(Prototype)은 해당지점에 대한 실제사진을 이용해서 사용자의 대상물에 대한 인식성을 높이고 속성정보와의 연계를 통해서 해당 시설물에 대한 정성적인 정보추출과 관리가 가능함을 보여주었다.

  • PDF

사출 금형 설계를 위한 엔지니어링 데이터베이스의 개발 (Development of Engineering Database for Injection Mold Design)

  • 김성근;허영무;변철웅
    • 한국정밀공학회지
    • /
    • 제17권10호
    • /
    • pp.89-94
    • /
    • 2000
  • Engineering database for CIM of injection mold production has been developed to manage design information and parameters of injection mold. The database has direct connection with product data management system and management database. Design specifications are generated in initial stage of mold design with integration of management information. Design parameters and bill of materials for mold base parts are generated during the CAD process and transferred to the manufacturing database and procurement system. Standard modules for parts and mold base are constructed using national standard and legacy data of industries. The engineering database provides important information route for CIM of injection mold design and production.

  • PDF

객체지향 데이터베이스를 이용한 전력계통 해석 (Power System Analysis using OODB)

  • 박지호;백용식
    • 대한전기학회논문지:전력기술부문A
    • /
    • 제53권5호
    • /
    • pp.257-265
    • /
    • 2004
  • The complex documentation involved in power system analysis software require a well-defined and friendly database system. We have developed an object-oriented database management system for power system analysis, and have described load flow analysis and transient stability analysis using object-oriented database(OODB). Database management systems are widely used and achieve high reliability of data management in the engineering fields. However relational database system have shortcomings in application to power system analysis. ill relational database, the data model is too simple for modeling complex data and database languages are very different from programming languages. Object-oriented techniques are sufficiently powerful to support data-modeling requirements of GUI applications. The GUI is implemented using C++ on a MS windows platform. The OODB supports data modeling requirements of GUI applications and the performance is well acceptable for Gill applications.

연약지반 계측관리를 위한 지능형 데이터베이스 시스템 개발 (Development of Intelligent Database system for softground instrumentation management)

  • 우철웅;장병욱
    • 한국농공학회:학술대회논문집
    • /
    • 한국농공학회 1999년도 Proceedings of the 1999 Annual Conference The Korean Society of Agricutural Engineers
    • /
    • pp.618-624
    • /
    • 1999
  • For many soft ground embankment projects , instrumentation programs for stability and settlement management is being essential . This usually leads to generate large volume of data, which can be used for further research. Database technique is most effective method for data management . Data produced by soft ground embankment instrumentation can not be used by itself but must be reproduced using geotechnical analysis technique. In this study, a intelligent database system for softground called IDSIM was developed to examine applicability intellgent database. . The IDSIM analysis instrumentation data automatically and present results by Web/DB interface successfully.

  • PDF

최소 권한 계정 분리 모델을 이용한 데이터베이스 엑세스 제어 연구 (A Study on Database Access Control using Least-Privilege Account Separation Model)

  • 장영수
    • 디지털산업정보학회논문지
    • /
    • 제15권3호
    • /
    • pp.101-109
    • /
    • 2019
  • In addition to enabling access, database accounts play a protective role by defending the database from external attacks. However, because only a single account is used in the database, the account becomes the subject of vulnerability attacks. This common practice is due to the lack of database support, large numbers of users, and row-based database permissions. Therefore if the logic of the application is wrong or vulnerable, there is a risk of exposing the entire database. In this paper, we propose a Least-Privilege Account Separation Model (LPASM) that serves as an information guardian to protect the database from attacks. We separate database accounts depending on the role of application services. This model can protect the database from malicious attacks and prevent damage caused by privilege escalation by an attacker. We classify the account control policies into four categories and propose detailed roles and operating plans for each account.

배전운영시스템용 응용 프로그램을 위한 공통 데이터베이스 구축 (Development of Common Database for the Application Programs of Distribution Management System)

  • 윤상윤;추철민;권성철;이학주
    • 전기학회논문지
    • /
    • 제62권9호
    • /
    • pp.1199-1208
    • /
    • 2013
  • In recent years, the development of application programs for distribution system analysis and control has been essential part for distribution management system (DMS). In this paper, we propose the common database for application programs of distribution management system. The proposed database model has several characteristics as followings. First, the proposed database model is designed for the common use of almost the whole distribution application software. The static equipment model and dynamic type tables are mixed and the parallel table structure is applied. Second, the linked list structure of database are used for the fast processing of applications. The database model includes the hierarchy and non-hierarchy distribution system structure. Third, the reduction method of distribution database is applied. For this, we present the network reduction rules. The basic concept of reduction rules are the electrical unification of successive line section which has not lateral branches and the removal of simple lateral branches which has no devices and other laterals. Proposed database model is tested for the Jeju system of Korea Electric Power Corporation (KEPCO). Through the test, we verified that the proposed database structure can be effectively used to accomplish the distribution system operation.

데이터베이스 품질 평가에 관한 사례 연구 (A Case Study on Database Quality and Quality Factors)

  • 이춘열;박현지
    • Journal of Information Technology Applications and Management
    • /
    • 제11권4호
    • /
    • pp.209-225
    • /
    • 2004
  • This paper presents case studies on database Quality uSing an extended database Quality model developed by Korea Database Promotion Center, which shall be called KDPC2003. The model is applied to evaluate two kinds of databases ; one is an operational database, the other is an information service database. The purpose of this research is two-folded. One is to evaluate database quality and assess current status of database quality management; the other is to assess usefulness of KDPC2003 and to propose ideas for its augmentation. The findings in this study will provide basic facts to test database quality evaluation models.

  • PDF