• Proceedings of the Korean Institute of Intelligent Systems Conference
• /
• 2003.09b
• /
• pp.49-52
• /
• 2003

In this research, we propose a mechanism to develop an inference engine and expert systems based on relational database and SQL (structured query language). Generally, former researchers had tried to develop an expert systems based on text-oriented knowledge base and backward/forward (chaining) inference engine. In these researches, however, the speed of inference was remained as a tackling point in the development of agile expert systems. Especially, the forward inference needs more times than backward inference. In addition, the size of knowledge base, complicate knowledge expression method, expansibility of knowledge base, and hierarchies among rules are the critical limitations to develop an expert systems. To overcome the limitations in speed of inference and expansibility of knowledge base, we proposed a relational database-oriented knowledge base and forward inference engine. Therefore, our proposed mechanism could manipulate the huge size of knowledge base efficiently, and inference with the large scaled knowledge base in a short time. To this purpose, we designed and developed an SQL-based forward inference engine using relational database. In the implementation process, we also developed a prototype expert system and presented a real-world validation data set collected from medical diagnosis field.

• Proceedings of the Korean Institute of Intelligent Systems Conference
• /
• 2005.11a
• /
• pp.452-455
• /
• 2005

In order to reproduce the traffic accident, It must save the data automatically which traffic accident 30 seconds before using black box. The Black Box can detect traffic crash accidents automatically, and record the vehicle's motion and driver's maneuvers during a pre-defined time Belied before and after the accident. But it is not easy for the police to catch running away criminal. Because, criminal can remove proof if it is 2 hours or 3 hours at least. Therefore, in this paper, in order to catch a hit and run driver in the traffic accident road, it developed an structured Query Language Server and made parts database algorithm.

• Journal of the Korean Operations Research and Management Science Society
• /
• v.21 no.3
• /
• pp.197-214
• /
• 1996

Financial analysis of stock data usually involves extensive computation of large amount of time series data sets. To handle the large size of the data sets and complexity of the analyses, database management systems have been increasingly adaopted for efficient management of stock data. Specially, relational database management system is employed more widely due to its simplistic data management approach. However, the normalized two-dimensional tables and the structured query language of the relational system turn out to be less effective than expected in accommodating time series stock data as well as the various computational operations. This paper explores a new data management approach to stock data management on the basis of an object-oriented database management system (ODBMS), and proposes a data model supporting times series data storage and incorporating a set of financial analysis functions. In terms of functional stock data analysis, it specially focuses on a primitive set of operations such as variance of stock data. In accomplishing this, we first point out the problems of a relational approach to the management of stock data and show the strength of the ODBMS. We secondly propose an object model delineating the structural relationships among objects used in the stock data management and behavioral operations involved in the financial analysis. A prototype system is developed using a commercial ODBMS.

• Journal of the Korea Computer Industry Society
• /
• v.5 no.1
• /
• pp.87-100
• /
• 2004

XML has recently considered as a new standard for data presentation and exchange on the web, many researches are on going to develop applications and index mechanism to store and retrieve XML documents efficiently. In this paper, design a Main-Memory based XML storage system for efficient management of XML document. And propose structured retrieval of XML document tree which reduce the traverse of XML document tree using element type information included user queries. Proposed indexing mechanism has flexibilities for dynamic data update. Finally, for query processing of XML document include Link information, design a index structure of table type link information on observing XLink standards.

• IEIE Transactions on Smart Processing and Computing
• /
• v.5 no.2
• /
• pp.94-99
• /
• 2016

Application layer attacks have for years posed an ever-serious threat to network security, since they always come after a technically legitimate connection has been established. In recent years, cyber criminals have turned to fully exploiting the web as a medium of communication to launch a variety of forbidden or illicit activities by spreading malicious automated software (auto-ware) such as adware, spyware, or bots. When this malicious auto-ware infects a network, it will act like a robot, mimic normal behavior of web access, and bypass the network firewall or intrusion detection system. Besides that, in a private and large network, with huge Hypertext Transfer Protocol (HTTP) traffic generated each day, communication behavior identification and classification of auto-ware is a challenge. In this paper, based on a previous study, analysis of auto-ware communication behavior, and with the addition of new features, a method for classification of HTTP auto-ware communication is proposed. For that, a Not Only Structured Query Language (NoSQL) database is applied to handle large volumes of unstructured HTTP requests captured every day. The method is tested with real HTTP traffic data collected through a proxy server of a private network, providing good results in the classification and detection of suspicious auto-ware web access.

• Journal of the Korean Institute of Intelligent Systems
• /
• v.13 no.6
• /
• pp.743-748
• /
• 2003

In this research, we propose a mechanism to develop an inference engine and expert systems based on relational database (RDB) and SQL (structured query language). Generally, former researchers had tried to develop an expert systems based on text-oriented knowledge base and backward/forward (chaining) inference engine. In these researches, however, the speed of inference was remained as a tackling point in the development of agile expert systems. Especially, the forward inference needs more times than backward inference. In addition, the size of knowledge base, complicate knowledge expression method, expansibility of knowledge base, and hierarchies among rules are the critical limitations to develop an expert system. To overcome the limitations in speed of inference and expansibility of knowledge base, we proposed a relational database-oriented knowledge base and forward inference engine. Therefore, our proposed mechanism could manipulate the huge size of knowledge base efficiently. and inference with the large scaled knowledge base in a short time. To this purpose, we designed and developed an SQL-based forward inference engine using relational database. In the implementation process, we also developed a prototype expert system and presented a real-world validation data set collected from medical diagnosis field.

• Journal of the Korean Institute of Intelligent Systems
• /
• v.18 no.2
• /
• pp.278-283
• /
• 2008

As the usefulness of internet is kept changing more productively with web 1.0, web 2.0 usage of XML is also increasing very rapidly. In XML environment the most critical function is the ability of effective retrieval of useful information from XML repository. That makes the W3C XQuery more popular XQuery has very complicated structure as a query language due to the semi_structured nature of XML. FLOWOR, which stand for, let. where, order by, return, is the most commonly used expression in XQuery. In this paper we suggest the methods to handle XQuery FLWOR on relational environments. We also analyze and evaluate our approach to prove its correctness.

• Journal of the Korean Society for Aeronautical & Space Sciences
• /
• v.34 no.2
• /
• pp.82-89
• /
• 2006

The flutter/vibroacoustic characteristics can be acquired by conducting flight tests with various conditions for a long period of test. Accordingly it is indispensable to build a specially designed database system to efficiently accumulate the enormous data obtained from flight tests. Hence, T-50 Flight Test Database System(FTDS) based on MS-Access is developed to handle the flutter/vibroacoustic environment data obtained from flight tests. The developed system is structured with the items related to aircraft flight test, the tables composed of the relevant items and a relational database logically connecting the tables. The T-50 FTDS is implemented with data searching GUI(Graphic User Interface) programed with Visual Basic and Structured Query Language to make intuitive searches over the stored data. The developed system has been used for accumulating the flutter/vibroacoustic data and verifying vibroacoustic Specifications.

• Journal of Society of Preventive Korean Medicine
• /
• v.20 no.1
• /
• pp.111-124
• /
• 2016

Objectives : Treatment method using drugs has already been used in Korean medicine for a long time. Moreover, database has been developed and utilized for more efficient management of the treatments that use drugs. Most of such database related to knowledge on drugs is composed of origin, efficacy, temperament, ingredients and examples of application of the standardized drugs. Communication with knowledge information in other specialized areas is also accomplished by using the efficacies and ingredients with the drugs. In this study, we aimed to make data structure of the terminologies that represent the manufacturing process of herbs. However, in spite of the fact that the manufacturing process of the drugs imparts effect on their efficacies and ingredients, details of the manufacturing processes are quite limited to simple text sentences, thereby resulting in substantially lower level of utilization and difficulties in systematic researches on various factors included in the manufacturing processes in comparison to other knowledge on drugs. Methods : This Study extracted the factors necessary in the development of database by executing morphological analysis of the manufacturing process of herbs. Results : The factors are 'Order', 'Act', 'Raw material', 'Tools', 'Supporting materials', 'Intensity', 'Duration Time', 'Interval', 'Focus', 'Repetition Number', 'Untill'. We were able to tell the difference of the manufacturing process with a simple structured query language and the factors. Conclusions : Morphological analysis of medicinal herbs manufacturing Process contributes to standardization with information of the manufacturing process. And it helps to creates a quality management system through the Database.

• Journal of Korea Spatial Information System Society
• /
• v.7 no.1 s.13
• /
• pp.39-52
• /
• 2005

GML (Geography Markup Language) has become the widely adopted standard for transport and storage of geographic information. So, various researches such as modeling, storage, query, and etc have been studied to provide the interoperability of geographic information in web environments. Especially, there are increased needs to store semi-structured data such as GML documents efficiently. Therefore, in this paper, we design and implement a GML repository to store GML documents on the basis of GML schema using spatial database system. GML Schema is converted into directed GML schema graph and the schema mapping technique from directed schema graph to spatial schema is presented. Also, we define the conversion rules on spatial schema to preserve the constraints of GML schema. GML repository using spatial database system is useful to provide the interoperability of geographic information and to store and manage enormous GML documents.