• Journal of the East Asian Society of Dietary Life
• /
• v.10 no.3
• /
• pp.245-251
• /
• 2000

This study was conducted to investigate the influence of different nutrient databases in estimating nutrient intake. A nutrient survey with Food Frequency Questionnaire containing 65 food items was conducted with 2,426 subjects over 30 years of age living in Yeonchon-gun, Kyungki province. The nutrient intakes were first estimated by using one (A) nutrient database which was based on the Korean Food Composition Table, 4th edition. With the other (B) nutrient database which was based on the Korean RDA(Recommended Dietary Allowances) 6th edition, it was reestimated and two resu1ts were compared. For most nutrients except carbohydrate, calcium, vitamin C and $eta$-carotene, mean nutrient intake level estimated from database B was significantly higher than that from database A(p<0.05). Mean intake level of most nutrients from two databases were significantly correlated by Pearson's correlation coefficients(p<0.001). Results from the ranking of nutrient intake levels of the subjects by two databases were highly correlated ( P >0.9, p<0.001). Weighted kappa values representing measures of agreement ranged from 0.55 databases ranged from 45% for vitamin C to 96% for carbohydrate. This result implies that different nutrient database may produce substantial differences in estimating the absolute nutrient intake but may not be crucial in ranking or classifying individuals with regard to specific nutrient intake.

• Proceedings of the KSRS Conference
• /
• v.2
• /
• pp.695-697
• /
• 2006

Elshayal $Smart{\copyright}$ software is an almost First Arabian GIS $software{\copyright}$ which completely developed by Arabian developers team and independent of any commercial software package. The software current Features are View and Edit shape files, build new layers, add existing layers, remove layers, swap layers, save layers, set layer data sources, layer properties, zoom in & zoom out, pan, identify, selecting features, invert selection, show data table, data query builder, location query builder, build network, find shortest path, print map, save map image, copy map image to clipboard, save project map, edit move vertex, edit move features, snap vertexes, set vertex XY, move settings, converting coordinate system, applying VB script, copy selected features to another layer, move selected features to another layer, delete selected features, edit data table, modify table structure, edit map features, drawing new features, GPS tracking, 3D view, etc... The software expected Features are: Viewing raster image and image geo-referencing, read other map formats such as DXF Format and Tiger Line Format.

• Journal of the Korea Society of Computer and Information
• /
• v.5 no.4
• /
• pp.69-75
• /
• 2000

This paper proposes a network intrusion detection model which can detect the insertion and evasion attacks. These attacks can be prevented when some kind of information are available in the network intrusion detection system. We classified these information with three categories and used each category at setup phase and executing Phase. Within the proposed model, all necessary information which are related with networks and operating systems are maintained in the database and created as a table. This table is used during intrusion detection. The overheads of database and table may be simple in this model.

• KSBB Journal
• /
• v.19 no.2
• /
• pp.125-131
• /
• 2004

Various medicinal plants were examined as resources for antidiabetic biomaterials, using an oriental medicinal database. The prescription frequency and dosage of medicinal plants in 131 antidiabetic prescriptions were analyzed. Total prescription score of each medical plant was summed up from prescription table and score table. High-scored medicinal plants have been widely studied in the previous research on the diabetic treatment. Consequently, dangui, hwangryun, maekmoondong, ginseng, chick, saengjihwang, omija, bokryung, Jimo and cheonhwaboon were assumed to have high antidiabetic activities.

• Nutritional Sciences
• /
• v.7 no.1
• /
• pp.47-52
• /
• 2004

The food composition database is used to evaluate the nutritional value of foods in Korea. It is used as a source for basic data in many fields, not only for the establishment of the National Food Supply Plan but also for nutritional research, to aid in the drafting of the National Food Policy, and in clinical and epidemiological research. The database is also used by institutional and commercial food services and by the food processing industry among others. In 1970, the Rural Development Administration(RDA) published the "Korean Food Composition Table" for the first time and it has since become the established authority on food composition for the entire nation. The latest published food composition table (the 6th edition, published by the National Rural Living Science Institute, KDA) covers 2,337 kinds of foods and consists of two volumes. The National Rural Living Science Institute, the Korea Food and Drug Administration, and the National Fisheries Research and Development Institute have continuously improved production of food composition data in Korea. As consumers have grown more interested in the quality and safety of foods and raw agricultural products, we can expect even further development of food composition data through improvements in quality and increases in quantity. We need to develop more comprehensive food composition data by diversifying the kinds of foods that are included, unifying analytical methods, and increasing the number of nutrients covered. Moreover, food composition data must be modified in other ways to make for a better food composition database for the convenience of users. of users.

• CRM연구
• /
• v.2 no.2
• /
• pp.53-70
• /
• 2009

Understanding consumer behavior based on the analysis of the customer data is one essential part of analytic CRM. To do this, the analytic skills for data extraction and data processing are required to users. As a user has various kinds of questions for the consumer data analysis, the user should use database language such as SQL. However, for the firm's user, to generate SQL statements is not easy because the accuracy of the query result is hugely influenced by the knowledge of work-site operation and the firm's database. This paper proposes a natural language based database search framework finding relevant database elements. Specifically, we describe how our TableRank method can understand the user's natural query language and provide proper relations and attributes of data records to the user. Through several experiments, it is supported that the TableRank provides accurate database elements related to the user's natural query. We also show that the close distance among relations in the database represents the high data connectivity which guarantees matching with a search query from a user.

• Proceedings of the Korea Information Assurance Society Conference
• /
• 2004.05a
• /
• pp.103-108
• /
• 2004

A Home Location Register(HLR) database system manages each subscriber's location information, which continuously changes in a cellular network. For this purpose, the HLR database system provides table management, index management, and backup management facilities. In this thesis, I propose using a two-level index method for the mobile directory number(MDN) as a suitable method and a chained bucket hashing method for the electronic serial number(ESN). Both the MDN and the ESN are used as keys in the HLR database system. I also propose an efficient backup method that takes into account the characteristics of HLR database transactions. The retrieval speed and the memory usage of the two-level index method are better than those of the T-tree index method. The insertion and deletion overhead of the chained bucket hashing method is less than that of the modified linear hashing method. In the proposed backup method, I use two kinds of dirty flags in order to solvethe performance degradation problem caused by frequent registration-location operations. I also propose using additional attributes in the HLR database scheme for location information secrecy as a suitable security method.

• Journal of Computing Science and Engineering
• /
• v.6 no.3
• /
• pp.193-206
• /
• 2012

Keys play a fundamental role in all data models. They allow database systems to uniquely identify data items, and therefore, promote efficient data processing in many applications. Due to this, support is required to discover keys. These include keys that are semantically meaningful for the application domain, or are satisfied by a given database. We study the discovery of keys from SQL tables. We investigate the structural and computational properties of Armstrong tables for sets of SQL keys. Inspections of Armstrong tables enable data engineers to consolidate their understanding of semantically meaningful keys, and to communicate this understanding to other stake-holders. The stake-holders may want to make changes to the tables or provide entirely different tables to communicate their views to the data engineers. For such a purpose, we propose data mining algorithms that discover keys from a given SQL table. We combine the key mining algorithms with Armstrong table computations to generate informative Armstrong tables, that is, key-preserving semantic samples of existing SQL tables. Finally, we define formal measures to assess the distance between sets of SQL keys. The measures can be applied to validate the usefulness of Armstrong tables, and to automate the marking and feedback of non-multiple choice questions in database courses.

• Journal of Information Management
• /
• v.27 no.4
• /
• pp.35-56
• /
• 1996

SGML(Standard Generalized Markup Language) and its application to full-text database including a table, a figure and a picture are explained. A structure of SGML based full-text database Is defined by DTD(document type definition) written in SGML, and full-text itself is described with generalized markup depending on DTD. This article explains how to represent a document structure : a hierarchical structure like a chapter, a section, or a paragraph, or non-hierarchical(referencial) structure like a note, a table, a figure or a picture. Merits of SGML, electronic publishing, a retrieval system or hypertext and SGML tools are also described.

• Magazine of the Korean Society of Agricultural Engineers
• /
• v.39 no.2
• /
• pp.86-94
• /
• 1997

For the efficient operation and maintenance( 0 & M), irrigation facilities were graded on the basis of their indices related to the 0 & M condition and the characteristics of reservoirs managed by Farmland Improvement Association(FIA) were examined. The results obtained are summarized as follows : 1. Characteristics of reservoirs include effective storage capacity, irrigation area, basin area, height and length of bank. Each characteristic is scored by the principle component analysis method. Variables which compose one index are categorized on the basis of their unit and each variable is scored so that the score of each unit sums to 100 for each index. 2. The Optimum MAnagement System of Irrigation Facilities(OMASIF) for Pyoungtaek area was developed by connecting general data of the irrigation facilities to image data. The database system is divided into three tables; LookUp Table, Facility Table, and Image Table. Image Table is again divided into five sub-tables, Image Table, Construction Cost Table, Acreage Table, 0 & M Cost Table, and Specification Table. 3. The evaluating criteria for the 0 & M of irrigation facilities can be established using the OMASIF. Irrigation facilities evaluated as poor state by the criteria should be repaired.