• International conference on construction engineering and project management
• /
• 2009.05a
• /
• pp.1491-1496
• /
• 2009

Because of the development of advanced construction technology, the inner environments of building become more and more complicated, which may result in many problems. The administer may forget where they put up the certain picture, and search for it all over the building, or they underestimate the number of the visitors, and find the situation is out of control, while the pedestrian may get lost, and after making their efforts, they found they turned back to the origin point again. So it is very necessary to establish an indoor spatial database. On one hand, it is able to assist administrator to manage the property and human flow inside the building, on the other hand it could help the pedestrian find the way easily especially when they are not familiar with the building or there is an emergency. This paper focused on how to create the indoor spatial database including both static database and moving objects database. The static database is built on the basis of 3D building models, and the moving objects database gets information from many kinds of cameras and sensors installed in the building. And at the same time the paper discussed the practical use of indoor spatial database mainly in three aspects including consistency management, building restructure, and pedestrian navigation.

• 대한공업교육학회지
• /
• v.32 no.2
• /
• pp.132-154
• /
• 2007

The purpose of this study is to present the importance of systematic database education in elementary and secondary schools in Korea. The authors compared the curriculum for database education in elementary and secondary schools of Gyeongsangbuk-do province in Korea with that of Arcola schools in the state of Illinois, US. The database industries of both countries were also compared to suggest the significance of database education in Korea. We have shown that it is urgent to include database education in IT curriculum for elementary and secondary schools in Korea considering importance of database itself as well as the magnitude and growth rate of database industries in 21st century. Contrary to our research results, however, it is shown the IT curriculums of elementary and secondary schools in Korea is hardly adequate to provide systematic database education required in information society. Based on these results, we conclude that IT curriculums should be revised to accommodate systematic database education for elementary and secondary schools in Korea.

• The Transactions of the Korea Information Processing Society
• /
• v.3 no.1
• /
• pp.77-86
• /
• 1996

In managing a certain database, the integrity of data is very important. The important. The integrity constrains thus should be considered carefully when a database is designed and, after the database is created, it is required for a database manager to check continuously if some data contained in the database violate the integrity constraints considered. It is however not easy to check the violateion of integrity constraints when the size and the complexity of database are increased. This paper suggests a rule-based database verification system to relax the difficulty of checking the integrity violation, in which a database is coupled with a rule-based system including the knowledge about the integrity constraints. The rule-database verification system suggested accepts the model descriptions of an application domain, generates the knowledge base consisting of rules and facts by analyzing the model description and proceeds the verification process to check the integrity of the database.

• Journal of Computing Science and Engineering
• /
• v.5 no.3
• /
• pp.183-196
• /
• 2011

There has recently been a surge of interest in relational database mining that aims to discover useful patterns across multiple interlinked database relations. It is crucial for a learning algorithm to explore the multiple inter-connected relations so that important attributes are not excluded when mining such relational repositories. However, from a data privacy perspective, it becomes difficult to identify all possible relationships between attributes from the different relations, considering a complex database schema. That is, seemingly harmless attributes may be linked to confidential information, leading to data leaks when building a model. Thus, we are at risk of disclosing unwanted knowledge when publishing the results of a data mining exercise. For instance, consider a financial database classification task to determine whether a loan is considered high risk. Suppose that we are aware that the database contains another confidential attribute, such as income level, that should not be divulged. One may thus choose to eliminate, or distort, the income level from the database to prevent potential privacy leakage. However, even after distortion, a learning model against the modified database may accurately determine the income level values. It follows that the database is still unsafe and may be compromised. This paper demonstrates this potential for privacy leakage in multi-relational classification and illustrates how such potential leaks may be detected. We propose a method to generate a ranked list of subschemas that maintains the predictive performance on the class attribute, while limiting the disclosure risk, and predictive accuracy, of confidential attributes. We illustrate and demonstrate the effectiveness of our method against a financial database and an insurance database.

• Korean Journal of Oriental Medicine
• /
• v.18 no.3
• /
• pp.141-146
• /
• 2012

Objectives : KIOM(Korean Institute of Oriental Medicine) built up korean medical paper database and services it through information portal OASIS. The database are updated about 1,600 papers and 48,000 references annually. Because lots of manpower and time are needed to update database, it is very important to raise up efficiency and quality of it. Methods : In this paper, we implemented web based database building system utilizing pre-built OASIS' database to improve the working process, data quality and ease of management. Results : First we designed and implemented web based system to input bibliography of the paper efficiently. It raised efficiency using OASIS' paper and reference database. Second we improved the refining process using web based system to raise up data quality. And third we developed the manager functions of web based system to control and check the working process. Conclusions : If we add korean medical dictionary and link outside paper database in the future, we hope that work efficiency and data quality will be raised more. And because the database schema of OASIS system and developed system are different, we are implementing the data transformation system.

• Journal of Nutrition and Health
• /
• v.38 no.7
• /
• pp.586-604
• /
• 2005

A reliable nutrient database is a prerequisite for accurate calculation of dietary intakes. The folate database currently available in Korea, however, is not reliable because the values were obtained from published data in other countries using ineffective methods to extract folates from the food matrix. The purpose of this study was to complement the folate database by analyzing folate content in foods using a more effective method to extract food folates (trienzyme treatment). Folate content per unit weight was highest in laver, fermented soybeans, soybean, spinach, black soybeans, crown daisy, mung beans, and quail's egg in descending order. Legumes, leafy greens, eggs, and seaweeds were rich in folate, and meats, chicken, fish, and some fruits contained less folate. Some of the analyzed values were 10 times higher than those in the currently available database. Folate values of 423 foodcodes out of 2,932 foodcodes ($14.4\%$) in the database in the 7th revision in the Recommended Dietary Allowances for Koreans can be replaced by those analyzed in this study. Since folate values of rice and Kimchi, which are core dishes of Koreans, in the newly established database are higher than those in the current database, folate intake assessed using our data will be higher than that using the current available database. Folate content in more foods commonly consumed in Korea are needed to update the folate database. Meanwhile, folate values presented here can be used to assess dietary folate intake of the Korean population.

• Journal of Korean Society of Rural Planning
• /
• v.11 no.2 s.27
• /
• pp.43-49
• /
• 2005

As information has been brought to public attention, information storage as well as information usability has been important. Rural information is produced in many areas and institutions. However, it is difficult to use rural information comprehensively. Since formats for management are various, it is difficult to have unified frame. In this research, a schema of database fer integrating rural data is designed to improve usability using dimensional modeling. First of all, rural data are analyzed for designing integrated rural database schema. Rural data used are 'National Agricultural Statistics' and 'Gun annual statistical report'. Analysis shows that there are three considerations; administrative district, time-dependency and classification of data. Considering these three requisite, we designed database schema using dimensional modeling. The reason of using dimensional modeling is to improve usability and effectiveness. If the database was designed using ER modeling, many tables have to be joined every searching time. Separately from integrated rural database schema, user's database schema is designed considering usability. Through user's database, users can modify data or generate new data and save these processes. These make it possible to use generated data repeatedly. We evaluate usability, contribution, and effectiveness of data manipulation on the integrated rural database. We propose an integrated rural database structure improving the accessibility and usability of rural data and information and verified the data model based on a practical example.

• KIPS Transactions on Software and Data Engineering
• /
• v.9 no.4
• /
• pp.123-128
• /
• 2020

As the use of digital devices is becoming more commonplace, digital forensics techniques recover data to collect physical evidence during the investigation. Among them, the file forensics technique recovers deleted files, therefore, it can recover the database by recovering all files which compose the database itself. However, if the record is deleted from the database, the modified record contents will not be restored even if the file is recovered. For this reason, the database forensics technique is required to recover deleted records. Database forensics obtains metadata from database configuration files and recovers deleted records from data files. However, record recovery is difficult if database metadata such as block size cannot be obtained from the database. In this paper, we propose three methods for obtaining block size, which is database metadata. The first method uses the maximum size of free space in the block, and the second method uses the location where the block appears. The third method improves the second method to find the block size faster. The experimental results show that three methods can correctly find the block size of three DBMSes.

• Journal of Internet Computing and Services
• /
• v.12 no.6
• /
• pp.149-159
• /
• 2011

The current applications can be characterized as consisting of complex objects related by complex relationship. Therefore the relational database has been extended to object-relational database because of the complex objects. Accordingly, we need database design methodology for object-relational database. In this pager, we develop an integrated design methodology based on a extended UML class diagram for object-relational database. We make the extend UML class diagram by adding new stereotypes for object-relational database. Also we propose a guideline for transforming the extended UML class diagram to object-relational database schema. We use SQL:1999 as a object-relational data model and Oracle11g as a target object-relational database. We can build more easily and efficiently object-relational database for Oracle11g by using our methodology. Finally we applied our methodology on a computer classroom reservation system for evaluation the methodology.

• The Journal of Korean Association of Computer Education
• /
• v.9 no.2
• /
• pp.47-55
• /
• 2006

To determine efficient methods of database teaching, this paper applied the situated learning theory to the teaching and learning method and analyzed the effects. Previous related studies were also examined, with the essential contents in database analyzed based on Bloom's taxonomy of educational objectives. Moreover, this paper presented a strategy wherein the contents of database learning are classified into two categories: basic knowledge and technical and extended knowledge. Experimental and control groups were selected based on related studies, and the effects of database teaching and learning method, determined by technique and attitude area as well as knowledge area. After preparing and applying to the teaching and learning method the actual educational curriculum, the following results were drawn: (1) the experimental group showed better performance in terms of understanding the concept of database, operating database, and constructing a database table when the situated learning theory was applied to the teaching method, and; (2) the experimental group was also more receptive compared to the control group, which opted to take technique-oriented database courses. Therefore, various teaching and learning methods aside from the situated learning theory should be applied and analyzed in database and computer science fields for maximum effects.