• The Journal of Information Technology and Database
• /
• v.3 no.1
• /
• pp.3-24
• /
• 1996

Databases are critical to business information systems, and RDBMS is most widely used for the database system. Normalization has been designed to control various anomalies(insert, update, and delete anomalies). However, normalized database design does not account for the tradeoffs necessary for the performance. In this research, we develop a model for database design by denormalization of duplicating attributes in order to reduce frequent join processes. In this mood, we consider insert, update, delete, and query costs. The anomaly and data inconsistency are removed by additional disk I/O which is necessary for each update and insert transaction. We propose a branch and bound method for this model, and show considerable cost reduction.

• Journal of Industrial Technology
• /
• v.15
• /
• pp.51-62
• /
• 1995

Databases can crash due to various failures in computer systems. Recovery is a mechanism for restoring consistent data from damages caused by the by the failures and is an essential feature in database systems. This paper surveys recovery techniques for memory resident database systems. We first describe the basic architecture for memory resident database systems, and point out the main factors affecting their performance enhancement. Next, we explain the write-ahead logging(WAL), a recovery technique widely-used in most disk resident database systems, for easy understanding of basic recovery mechanisms. And then, we discuss some new concepts employed in memory resident database systems recovery. Finally, we present a representative memory resident database recovery technique, which is based on a special purpose hardware called HALO, as a case study.

• The Journal of the Korea Contents Association
• /
• v.2 no.4
• /
• pp.76-84
• /
• 2002

The conventional database evaluation method is carried out by the way in which the person in charge of each specialty database(DB manager) composes the evaluation sheets for corretionㆍrevision on the already-constructed database in a manual method and carries out the measurement and re-education of DB workers based upon it. As a result, that way consumes much time on career information and measurement works about DB workers, causing low time and cost efficiency and lack of systematic management of DB workers, resulting in becoming the hindrance factor of databases quality improvement. This research provides on-line, red-time results of measurements about the efficiency of DB production and DB workers by combining the static measurement with dynamic measurement by DB manager, both of which utilize the System. Therefore, the DB manager can contribute to the improvement of DB quality by determining the continuation of DB production by DB workers or carrying out the re-education of DB workers without being affected by time or spacial constraints.

• Journal of Information Management
• /
• v.29 no.2
• /
• pp.18-36
• /
• 1998

This project surveys and analyzes the utilization of domestic database from user's point of view to find out the problems and factors for improvements of that, and makes efficient use of the result of this project as basic data in producing databases. Also it surveys and analyzes information demand for PC telecommunication users and utilization of PC telecommunication, database, and internet to establish directions of the development for the domestic database industry.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.3 no.3
• /
• pp.235-250
• /
• 2009

An understanding of performance of database driven network applications is critical in combating slow performance of e-commerce web sites, besides efficient web page design, and high quality and well-maintained web server equipment. This paper describes a method of measuring performance from the user viewpoint, which can help enormously in making realistic assessment of true performance of database driven applications. The performance measurements were taken at user locations by using several specially designed JavaScript functions along with ASP scripts. A performance study is presented in this paper, comparing performance of data access using stored procedures with the traditional way of querying a database. It is generally believed that stored procedures have performance benefits as they are pre-compiled. However, our study shows that the data access approach using stored procedures provides significant benefits(by about 30%) over the traditional approach for querying a commercial MySQL database, only when retrieving a substantial amount of data(at least 10,000 rows of data).

• The Journal of Information Technology and Database
• /
• v.4 no.2
• /
• pp.33-45
• /
• 1998

Database summarization is the procedure to obtain generalized and representative descriptions expressing the content of a large amount of database at a glance. We present a top-down summary refinement procedure to discover database summaries. The procedure exploits attribute concept hierarchies that represent ISA relationships among domain concepts. It begins with the most generalized summary and proceeds to find more specialized ones by stepwise refinements. This top-down paradigm reveals at least two important advantages compared to the previous bottom-up methods. Firstly, it provides a natural way of reflecting the user's own discovery preference interactively. Secondly, it does not produce too large intermediate result that makes it hard for the bottom-up approach to be applied in practical environment. The proposed procedure can also be easily extended for distributed databases. Information content measure of a database summary is derived in order to identify more informative summaries among the discovered results.

• Proceedings of the KIEE Conference
• /
• 1997.07c
• /
• pp.754-757
• /
• 1997

Effective design of a database is essential for operating application systems efficiently. This Paper discusses database design for the automatic distribution system. Database design is a complex Process for specifying the structure of information and is decomposed in three Phases: conceptual, logical, and Physical design. In this paper, we first collect and analyze the requirements for the automatic distribution system, our target application. We also perform database design for these requirements through three design Phases. We believe that our results would contribute to the effective construction of a database for the automatic distribution system.

• The Transactions of The Korean Institute of Electrical Engineers
• /
• v.67 no.8
• /
• pp.987-993
• /
• 2018

In the existing distribution automation system, the database is managed by each distribution office. But there is a high possibility to happened a problem during a fault processing because the representation of the connection switches between distribution offices are complicated. In addition, if a distribution office will be going to collapse due to disaster, for example, a big fire or earthquake, its own database may be lost. In order to solve this problem, it is necessary to have a structure of an integrated database management from an integration center to under the distribution office. To do this, the integration center must store and manage it as the database using the own office code.

• Journal of Digital Contents Society
• /
• v.5 no.3
• /
• pp.180-186
• /
• 2004

XML has an essential funtion of dealing with standardized document to be used in all academic areas and industrial areas as well as e-commerce. The transformation of XML data into Relation Database table is also necessary for data search using SQL language. Mapping relation between XMLand Table in Relation Database is required for transformation of XML. This arti치e studies the mapping relation between XML and Relation Database using DTD which enables to check the unity automatically whenever document is read so that it studied mapping design for the transformation of XML data info Relation Database table.

• Journal of the Korea Society for Simulation
• /
• v.9 no.3
• /
• pp.27-41
• /
• 2000

As the application domains of rule-based systems become larger and more complicated, the integration of rule-based systems within the database systems has become the topic of many research works. This paper suggests a simulation modeling using expert system and database. The integration methods employed in this research are as follows. First, we defined new states and state transition functions to interrelate simulation model and expert system. Second, we designed and implemented FCL(Fact Class Library) as a interface of expert system and database. FCL has facilities of filtering data from database, and assigning a meaning to the filtered data. Also, FCL detects the violation of the integrity rules in database, as the result of inference is reflected. Some implementation problems are pointed out and the methods to solve these problems are discussed in this paper, We developed a simulation model of the grating production line and executed it to validate the functions of the proposed method.