• The Journal of Information Systems
• /
• v.18 no.3
• /
• pp.327-349
• /
• 2009

Traditional keyword-based searching methods suffer from low accuracy and high complexity due to the rapid growth in the amount of information. Accordingly, many researchers attempt to implement a so-called semantic search which is based on the semantics of the user's query. Semantic information can be described using a semantic modeling language, such as Topic Map. In this paper, we propose a new method to map a topic map to a traditional Relational Database (RDB) without any information loss. Although there have been a few attempts to map topic maps to RDB, they have paid scant attention to handling multi-role topics. In this paper, we propose a new storage structure to map multi-role topics to traditional RDB. The proposed structure consists of a mapping table, role tables, and content tables. Additionally, we devise a query translator to convert a user's query to one appropriate to the proposed structure.

• Journal of Internet Computing and Services
• /
• v.3 no.3
• /
• pp.75-85
• /
• 2002

Nowadays for reliable software and cost reduction there are many research works on software development based on component, One of the challenge in designing a component-based system is determining which components are required and where they fit in the overall system architecture. In this paper, we developed three EJB components, the first is for transforming XML DTD to relational database schema, the second is for storing XML document in relational database, and the third is for transforming XML document by retrieving relational database, By assembling these three components, we developed XML Repository system finally.

• The Transactions of the Korea Information Processing Society
• /
• v.4 no.1
• /
• pp.1-10
• /
• 1997

In this paper, for useful administration of the data which have ambiguities meaningfully and hard to treat, a new relation database model using an integrated fuzzy sets and rough sets relational database one. After proposing Fuzzy-rough relational database model on the base of integrated Fuzzy and Rough sets, Application of the examples of arithmetic is analyzed through the Access DBMS and the visual basic by composing and representing database based on fuzzy and rough sets which are characterized as fuzzy sets and rough sets on Pentium computer(166Mhz). This paper was induced to reduce the data incompleteness.

• Journal of KIISE:Databases
• /
• v.35 no.2
• /
• pp.155-168
• /
• 2008

This paper proposes a relational security model-based RDF Web ontology access control model. The Semantic Web is recognized as a next generation Web and RDF is a Web ontology description language to realize the Semantic Web. Much effort has been on the RDF and most research has been focused on the editor, storage, and inference engine. However, little attention has been given to the security issue, which is one of the most important requirements for information systems. Even though several researches on the RDF ontology security have been proposed, they have overhead to load all relevant data to memory and neglect the situation that most ontology storages are being developed based on relational database. This paper proposes a novel RDF Web ontology security model based on relational database to resolve the issues. The proposed security model provides high practicality and usability, and also we can easily make it stable owing to the stability of the relational database security model.

• Culinary science and hospitality research
• /
• v.21 no.4
• /
• pp.251-270
• /
• 2015

This study was, based on traditional know-how indigenous to Korea, to systemize the knowledge on how to improve health by dining, and to make the best of it statistically. For this purpose, the knowledge in the Sikryo-chanryo(食療纂要), in Korean pronunciation and Siglyochan-yo in Chinese characters, which is an old text referring to diet therapy peculiar to Korea, was compiled into a database and analyzed statistically. Data processing was used as a 'Relational data model'. In addition, we have used nine data table to express diet therapy peculiar to Korea in the Siglyochan-yo. The software used for data construction was Microsoft Access 2014. As a result, the Sikryo-chanryo database, which can provide information on both disease treatment by food, medicines, and gourmet ingredients applicable to every kind of symptom, as well as the names of disease, was set up at in a PC interface. By employing the 'Relational data model', we can replace researching in the conventional method by employing the database.

• The KIPS Transactions:PartD
• /
• v.10D no.2
• /
• pp.221-232
• /
• 2003

This paper addresses the query processing component of a wrapper system for a relational database model based on the XML view in integrating databases. The schema of a relational database is represented as XML Schema that is proposed by W3C. Users submit a query using the XML query language XQuery over the XML Schema. The wrapper system to be developed supports an user-defined XML view. XQuery is also used as the view definition language. In this environment, this paper suggests a new XML query processing model. We propose the composition algorithm of an XML view with an user query, the translation algorithm of XQuery into SQL, and the XML template construction algorithm for generating XML documents.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.6 no.3
• /
• pp.265-269
• /
• 2005

A fuzzy query language, called FSQL, in the relational databases is introduced in this paper. In general, database systems have query systems which are able to retrieve and manipulate precise data. However, such queries are hard to operate on the real world applications since their queries are often imprecise or incomplete. Recently, considerable attention has been given to research dealing with vagueness of the query in relational database systems. In this paper we have suggested an effective method of accepting vagueness of the query in data processing. The syntax of FSQL is formally defined with EBNF, and an interpreter of FSQL has been implemented as a prototype.

• Proceedings of the Korean Institute of Information and Commucation Sciences Conference
• /
• 2003.10a
• /
• pp.615-618
• /
• 2003

The design process of a relational database system consists of requirement analysis, conceptual design using ER diagram, logical design, and physical design. In logical design process, the conceptual schema is transformed to relational schema, and relational schema is normalized. This traditional design process is hard to applied in real database design process, since there is an ambiguity in conceptual design process. In this paper, we suggest a new design process, which provides more structural design steps by removing the conceptual design process. In new approach, we produce the data flow diagram by the structural methodology. From the attributes in the data store of data flow diagram, we construct relational table schema, and we normalize relational schema. Finally we produced table relationship diagram in order to figure out relationships between tables.

• KIISE Transactions on Computing Practices
• /
• v.24 no.3
• /
• pp.105-112
• /
• 2018

As data size increase, a single database is not enough to serve current volume of tasks. Since data is partitioned and stored into multiple databases, analysis should also support parallelism in order to increase efficiency. However, traditional analysis requires data to be transferred out of database into nodes where analytic service is performed and user is required to know both database and analytic framework. In this paper, we propose an efficient way to perform K-means clustering algorithm inside the distributed column-based database and relational database. We also suggest an efficient way to optimize K-means algorithm within relational database.

• The Journal of the Korea Contents Association
• /
• v.6 no.4
• /
• pp.19-28
• /
• 2006

XML instances for purpose of information exchange are normally stored in the legacy relational database. Therefore, integrations with relational database are required for effective XML applications. To support these requirements, virtual decomposition storage or decomposition storage methods which save separates structures of instances to relational database have researched. However, these storage methods contain different information of schema structure and layers which has caused difficulties to process query during search operation as well as increased overheads due to duplicate savings for separate storages. Therefore, in this research, additional field of 'Eltype' has introduced to previous database schema structure to instance and schema structure, provide consistent level information and propose storage structure to map each field to schema field of relational database. As results, XML instance and structures can be stored together to minimize overheads and required storage-space. Also, synchronized storage layer structure provides easier processing of search query.