• Journal of Information Processing Systems
• /
• v.11 no.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.

• 한국디지털정책학회:학술대회논문집
• /
• 2003.12a
• /
• 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.

• Journal of the Korean Dietetic Association
• /
• v.8 no.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.

• Proceedings of the Korea Society for Industrial Systems Conference
• /
• 2007.02a
• /
• 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.

• Proceedings of the Korean Institute of Intelligent Systems Conference
• /
• 2004.10a
• /
• 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.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 2002.05a
• /
• 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.

• Journal of Intelligence and Information Systems
• /
• v.5 no.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.

• Journal of Korean Institute of Industrial Engineers
• /
• v.41 no.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.

• Management & Information Systems Review
• /
• v.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.

• 한국경영정보학회:학술대회논문집
• /
• 2008.06a
• /
• 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.