• 제목/요약/키워드: Database management systems

검색결과 1,025건 처리시간 0.028초

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.

The Design of the Selection and Alignment Queries Using Mobile Program (J2ME) for Database Query Optimization

  • 고완석;민천홍
    • 한국디지털정책학회:학술대회논문집
    • /
    • 한국디지털정책학회 2003년도 창립학술대회
    • /
    • pp.263-273
    • /
    • 2003
  • Recognizing the importance of the database query optimization design methods, we implemented mobile database with mobile program (J2ME) which is a useful database procedures. In doing so, we emphasize the logical query optimization which brings mobile database to performance improvement. The research implies that the suggested mobile program (J2ME) would contribute to the realization of the efficient mobile database as the related technology develops in the future.

  • PDF

병원 영양부서의 급식정보시스템 수행도 평가 (Operational Assessment of Foodservice Information Systems in Hospital Foodservice Operations)

  • 최성경;김정리;곽동경
    • 대한영양사협회학술지
    • /
    • 제8권4호
    • /
    • pp.387-397
    • /
    • 2002
  • Foodservice information systems management practices were assessed in hospital foodservice operations. A total of 46 dietetic departments were responded for the study and their practices of foodservice information systems were analyzed. The respondents were questioned about general characteristics of respondents as well as hospital foodservices implementation status of information systems. Statistical data analysis was completed using the SPSS package program for descriptive analysis, factor analysis, t-test and ANOVA test. 43.2% of total respondents gained informations by benchmarking of other hospital foodservice operations, but 7.8% gained through career education. They expected the enhanced efficiency of their tasks through implementing information systems. Based on factor analysis, information systems were divided into 6 management areas such as database management, meal management, nutrition management, purchasing management, production management and foodservice management. The average implementing scores were : database management 3.77, meal management 3.26, nutrition management 3.52, purchasing management 3.26, production management 2.73 and foodservice management 3.70 (score 1 indicates very poor and score 5 is very good). Among database management areas, standard recipe database and food item specifications database build-up scores(3.91) were relatively very high, but meal assessment and foodservice management reporting scores(2.43) were very low. The results suggest that it is necessary to build up automated foodservice management reporting system for the improvement of efficiency and productivity of operational tasks.

  • PDF

An XML Data Management System Using an Object-Relational Database

  • Nam, S.H.;Jung, T.S.;Kim, T.K.;Kim, K.R.;Zahng, H.K.;Yoo, J.S.;Cho, W.S.
    • 한국산업정보학회:학술대회논문집
    • /
    • 한국산업정보학회 2007년도 춘계학술대회
    • /
    • pp.163-167
    • /
    • 2007
  • We propose an XML document storage system, called XDMS (XML Document Management System), by using an object-relational DBMS. XDMS generates object database schema from XML Schema and stores the XML documents in an object-relational database. SAX parser is used for understanding the structure of the XML documents, and XDMS transforms the documents into objects in the database. Experiment shows that object-relational databases provide more efficient storage and query model compared with relational databases.

  • PDF

동적지식도와 데이터베이스관리시스템 기반의 전문가시스템 개발 (Development of Expert Systems based on Dynamic Knowledge Map and DBMS)

  • Jin Sung, Kim
    • 한국지능시스템학회:학술대회논문집
    • /
    • 한국퍼지및지능시스템학회 2004년도 추계학술대회 학술발표 논문집 제14권 제2호
    • /
    • pp.568-571
    • /
    • 2004
  • In this study, we propose an efficient expert system (ES) construction mechanism by using dynamic knowledge map (DKM) and database management systems (DBMS). Generally, traditional ES and ES developing tools has some limitations such as, 1) a lot of time to extend the knowledge base (KB), 2) too difficult to change the inference path, 3) inflexible use of inference functions and operators. First, to overcome these limitations, we use DKM in extracting the complex relationships and causal rules from human expert and other knowledge resources. Then, elation database (RDB) and its management systems will help to transform the relationships from diagram to relational table. Therefore, our mechanism can help the ES or KBS (Knowledge-Based Systems) developers in several ways efficiently. In the experiment section, we used medical data to show the efficiency of our mechanism. Experimental results with various disease show that the mechanism is superior in terms of extension ability and flexible inference.

  • PDF

차세대 고속전철 시스템 시험검증 체계 구축 및 적용

  • 최종민;유일상;김연태;박영원
    • 한국경영과학회:학술대회논문집
    • /
    • 대한산업공학회/한국경영과학회 2002년도 춘계공동학술대회
    • /
    • pp.1079-1084
    • /
    • 2002
  • Systems engineering technology development program for Korea next-generation high-speed railway(KNHR) system in progress is a national large-scale system development program that is not only a large-size and complex but also multi-disciplinary in nature. Using the RDD-IOO, a systems engineering tool, the KNHR program can establish requirements traceability and development process management in the course of development. This paper presents the results from a computer-aided systems engineering application to KNHR system technology development project over the three years of activities. The traceability among the system design database in the vertical direction of SE process, as the results of the first year and the second year research was accomplished. The database in both the requirement management domain and the project management domain was developed and set up the traceability between them in the horizontal direction of the SE process in the V model as the results of the third year research. Therefore, KNHR design database was built to support the life-cycle management of the system as well as to reuse the knowledge in future programs. In the following development phase, this database will be utilized to accomplish the test and integration activities providing a baseline database. The outcome of the study contributes to the establishment of the model-based systems engineering approach as a best practice in the accumulation and advancement of systems engineering technology for railway system development.

  • PDF

객체지향 데이터베이스를 이용한 지식베이스 모형(OOKS) 개발 (Development of OOKS : a Knowledge Base Model Using an Object-Oriented Database)

  • 허순영;김형민;양근우;최지윤
    • 지능정보연구
    • /
    • 제5권1호
    • /
    • pp.13-34
    • /
    • 1999
  • Building a knowledge base effectively has been an important research area in the expert systems field. A variety of approaches have been studied including rules, semantic networks, and frames to represent the knowledge base for expert systems. As the size and complexity of the knowledge base get larger and more complicated, the integration of knowledge based with database technology cecomes more important to process the large amount of data. However, relational database management systems show many limitations in handing the complicated human knowledge due to its simple two dimensional table structure. In this paper, we propose Object-Oriented Knowledge Store (OOKS), a knowledge base model on the basis of a frame sturcture using an object-oriented database. In the proposed model, managing rules for inferencing and facts about objects in one uniform structure, knowledge and data can be tightly coupled and the performance of reasoning can be improved. For building a knowledge base, a knowledge script file representing rules and facts is used and the script file is transferred into a frame structure in database systems. Specifically, designing a frame structure in the database model as it is, it can facilitate management and utilization of knowledge in expert systems. To test the appropriateness of the proposed knowledge base model, a prototype system has been developed using a commercial ODBMS called ObjectStore and C++ programming language.

  • PDF

중소기업을 위한 최종 사용자 컴퓨팅 PDM 시스템 개발 (Developing an End-User Computing PDM System for Small and Medium Business)

  • 도남철
    • 대한산업공학회지
    • /
    • 제41권2호
    • /
    • pp.162-172
    • /
    • 2015
  • This paper proposes a Product Data Management (PDM) system architecture that supports end-user computing for small and medium businesses (SMBs) in Korea to build and maintain efficient and sustainable information systems for their product development. Its open database with relational tables enables existing common application programs such as Microsoft office suites to access product data in PDM systems. In addition, the interactive query processor provided by database management systems helps design engineers to build ad hoc queries in standard SQL database language to response different data requirements during their product development. The PDM architecture with the open database allows design engineers or technical staffs in SMBs to build and maintain their application programs for product development by themselves. To show the feasibility of the proposed architecture, this study implemented a prototype PDM system based on the architecture and database, and represents real-world product data with the implemented PDM system.

객체지향 데이터베이스와 새로운 Unified Relation 객체지향 데이터베이스의 운용에 관한 연구 (A Study on Application Object-oriented Database and New Unified Relation Object-oriented Database)

  • 박창민
    • 경영과정보연구
    • /
    • 제3권
    • /
    • pp.133-150
    • /
    • 1999
  • This paper proposes to study on the interoperation between Relation Database(RDB) and Object-oriented database(OODB). It also describes some Characteristics of OODB and introduces the UniSQL system. This paper suggests a new systemcalled URODB (Unifide Relation & Object-oriented database) that will overcome the limits of OODB, improve the shortcomings of the present RDB, and increase the interchangeability in particular.

  • PDF

The Design of the Selection and Alignment Queries Using Mobile Program (J2ME) for Database Query Optimization

  • Min, Cheon-Hong;Kumar, Prasanna
    • 한국경영정보학회:학술대회논문집
    • /
    • 한국경영정보학회 2008년도 춘계학술대회
    • /
    • pp.620-627
    • /
    • 2008
  • In this paper, recognizing the importance of the database query optimization design methods, we implemented mobile database with mobile program (J2ME) which is a useful database procedures. In doing so, we emphasize the logical query optimization which brings mobile database to performance improvement. The research implies that the suggested mobile program (J2ME) would contribute to the realization of the efficient mobile database as the related technology develops in the future.

  • PDF