• The Journal of Information Systems
• /
• v.6 no.2
• /
• pp.147-163
• /
• 1997

The usages of the relational database systems have been increased nowadays. However there is a constraint that the standard query language for a database system requests users to know the exact condition for a query. In this paper a FSQL(Fuzzy SQL) systems is proposed and implemented for the imprecise queries which do not include the exact condition. Moreover this system can supply the obvious results for the queries effectively. We define a simple fuzzy query language and use a method using the metadatabase to implement the FSQL system. This FSQL system can be combined with a relational database system without any painful effort.

• The Journal of Information Technology and Database
• /
• v.1 no.1
• /
• pp.9-30
• /
• 1994

The objective of this paper is to give a brief review of relational design methodology, and show how a relational schema can be converted into an object-relational schema. We first introduce relational terminology and describe the relational design process along with its limitations. Next we show how the relational model can be extended to overcome these limitations : these extensions form the core of an object-relational data model ; we use the UniSQL/X data model as an example. We illustrate the process or converting a relational schema into an object-relational schema, and show the benefits of this conversion with respect to queries. The conversion process is then summarized as a set of guidelines. Finally, we make our conclusions.

• Journal of Information Technology Applications and Management
• /
• v.16 no.4
• /
• pp.245-261
• /
• 2009

Since XML emerged as a standard for data exchange on the web, it has been widely used for applications like e-Commerce, CRM, and BI. However, it is common that most of business data is stored in relational database systems, and it is expected that business data management would still be centered around the relational database systems. As such, the technique of viewing relational data as XML and processing XML queries against it is required. To meet such a need, in the SQL/XML standard, the functions to publish relational data as XML are provided. In this paper, we propose the techniques of providing an XML view of relational data defined by an SQL/XML statement in DTD(Document Type Definition), and of processing XPath queries against the XML view by translating them into SQL/XML statements, and describe the validation of such techniques through implementation and tests.

• Proceedings of the Korean Society of Agricultural Engineers Conference
• /
• 1998.10a
• /
• pp.395-400
• /
• 1998

This paper presents a geotechnical information system(HGIS) developed for Korea Highway Corporation. To make a database for boring information, characterization study of boring data is carried out. Based on tile study, the HGIS database is developed as a relational database. The HGIS database consists of 23 tables including 13 reference tables. For an effective database management, a boring log program called GEOLOG is developed. GEOLOG can print boring log and store those data to tile HGIS database.

• Journal of Information Technology Applications and Management
• /
• v.12 no.2
• /
• pp.29-43
• /
• 2005

The paper presents the EBORD (Extended Benchmark for Object-Relational Databases) benchmark, which is an extension of the BORD benchmark for object-relational databases. The EBORD benchmark is developed to evaluate the database common functions that should be supported in modern database systems. Besides the 36 test queries already defined in the BORD benchmark, totally 22 test queries in five categories are newly defined in order to measure the index-relevant performance issues and database import capabilities. The EBORD benchmark also features scalability, use of a synthesized database, and a query-oriented evaluation. In order to show the feasibility of the proposed benchmark, we implement it with two commercial database systems. The experimental results and analyses are also reported.

• Proceedings of the Korean Institute of Building Construction Conference
• /
• 2014.05a
• /
• pp.192-193
• /
• 2014

Due to the decreasing domestic construction market since 2007, Korean construction companies are expanding overseas market. As a result, the international market share by Korea has been continuously increased and achieved 65.2 billion dollars in 2013. Despite of such visible results, profitability concerns are constantly arising. It is pointed out that the low-priced bid competition between Korean construction companies and various unpredictable risks are the most crucial factors which aggravate the profitability in the overseas projects. From this point of view, predicting the risks in advance and controling them could be the most important tasks to improve the profitability. This research proposed 202 risk factors with a hierarchy and relational database schema for power plant construction, which is based on the 24 risk classifications in previous research (Kim & Jung 2013). Proposed risk classification and relational database schema could be utilized as the basic data in risk management system.

• Journal of information and communication convergence engineering
• /
• v.20 no.4
• /
• pp.265-272
• /
• 2022

The most effective method to improve information system capabilities is to enable instant access to several relational database sources and transform data with a logical structure into multiple target relational databases. There are numerous data transformation tools available; however, they typically contain fixed procedures that cannot be changed by the user, making it impossible to fulfill the near-real-time data transformation requirements. Furthermore, some tools cannot build object references or alter attribute constraints. There are various situations in which tool changes in data type cause conflicts and difficulties with data quality while transforming between the two systems. The R-programming language was extensively used throughout this study, and several different relational database structures were utilized to complete the proposed study. Experiments showed that the developed study can improve the performance of information systems by interacting with and exchanging data with various relational databases. The study addresses data quality issues, particularly the completeness and integrity dimensions of the data transformation processes.

• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1996.04a
• /
• pp.183-186
• /
• 1996

The relational database management systems sometimes require extremely long and complicated queries for a certain retreval. In this case, recursive retirevals are more efficient approach than the usual queries. Many researchers have tried to incorporate semantics in the traditional relational models using artificial intelligence techniques. This new concept becomes a deductive database and sometimes it is also called as a logic programming. However, the designer of a deductive database did not overcome the short of relational database. In this paper, we propose a new way of designing queries for the deductive database. We also provide relations for recursive retrieval in the deductive database. These approaches are applied for the material requirement planning.

• Journal of Korea Multimedia Society
• /
• v.5 no.2
• /
• pp.129-140
• /
• 2002

XML has become a standard for exchanging document data on the web. Currently, most of the commercial data are stored in the relational database system. It requires to converse the document into XML form to transfer the data to a relational database system. The purpose of this paper is to research on a query processing system which will make it easy and convenient to raise a query and derive results from the document data stored in a relational database. We have designed a XML view called R2X(Relational To XML). With this R2X view, users can view a relational database as XML documents. Using R2X views, we design and implement a Query processing system which will make it expedient to form a query with a XML query language called XQL.

• Journal of Information Technology Applications and Management
• /
• v.10 no.4
• /
• pp.103-118
• /
• 2003

This study presents a database quality evaluation framework. As a way to build a framework, this study expands data quality management to include data transformation processes as well as data. Further, an information structure graph is applied to represent data transformations processes. An information structure graph is absed on a relational database scheme. Thus, data transformation processes may be stored in a relational database. This kind of integration of data transformation metadata with technical metadata eases evaluation of database qualities and their causes.