• 대한영양사협회학술지
• /
• 제9권2호
• /
• pp.159-171
• /
• 2003

The food composition tables are frequently used to health and nutrition practices. But it is difficult to find out food exchange lists with food exchange groups in the food composition table. Over 2500 items and many kinds of nutrients are in the food composition table. But now food exchange lists are used a few foods. The internet demands the users needs for obtaining more food exchange lists and nutrient information from food composition. This basic study is to solve the users need and the supply more efficient and effective manipulation system for e-food exchange database construction and search system:ENECC/e-food exchnage(E-Nutrition Education and Couseling Center/e-food exchange). This paper introduces the food exchange database construction and search system(ENECC/e-food exchange) using the formula which calculates the food exchange quantity of 6 food exchange groups and added one extra groups(alcohol) based on the internet. The ENECC/e-food exchange database is basically based on the 6th food composition table(2001) of the National Rural Living Science Institution in Rural Development Administration, Korea. The e-food exchange database are consisted of 2,261 foods in 6 basic food groups and one extra groups by using ENECC calculating formula. Also, the e-food exchange database has the proximate composition, mineral and vitamin content such as energy, moisture, protein, fat, carbohydrate, ash, calcium, phosphorus, iron, sodium, potassium, retinol equivalent, retinol, â-carotene, thiamin, riboflavin, niacin, ascorbic acid, refuse per 100g of each food.

• 정보관리연구
• /
• 제29권2호
• /
• pp.18-36
• /
• 1998

이용자 관점의 데이터베이스 이용 실태를 조사 분석하여 그 문제점과 개선 사항을 도출하고 데이터베이스 제작시 기초자료로 활용하여 데이터베이스 이용의 활성화를 도모하며, 국내 데이터베이스의 발전 방향을 정립하기 위해 PC통신 이용자를 대상으로 정보 수요, PC통신 이용과 데이터베이스 이용 실태 및 인터넷 이용에 관한 조사 분석에 관한 내용을 정리하였다.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• 제3권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).

• 한국문헌정보학회지
• /
• 제32권3호
• /
• pp.143-156
• /
• 1998

이 논문은 미국 초중고교 교사들을 이용 대상자로 인터넷 상에 산재해 있는 강의안 및 교육자료의 메타데이터 DB를 구축한 GEM 프로젝트에 대한 보고이다. GEM 프로젝트에서는 현재 거의 표준으로 간주되는 더블린 코어의 15개 요소(Elements)를 채택하였고, 여기에 8개 요소를 첨가하여 검색을 원활히 하고자 하였다. GEM 메타데이터 DB의 구축에는 메타데이터 요소들간의 관계를 좀 더 명확히 표현할 수 있는 개념적 데이터 마들링을 사용하였고 메타데이터는 Sybase라는 관계형 데이터베이스에 저장했으며, 이 DB에 웹 인터페이스를 장착하는데에는 Microsoft 액티브 서버 페이지 (ASP) 기술을 이용하였다. GEM 메타데이터의 실제목록은 미국 전역에서 참가하고있는 컨소시엄 회원들에 의해서 이뤄지고 있으며, 그 결과는 인터넷을 통해 Sybase 관계형 데이터베이스에 자동적으로 입력된다. 이 논문에서는 더블린코어, GEM의 개념 및 논리 스키마들을 제시하는 한편, 메타데이터 DB의 구축에 개념적 데이터 마들링을 사용함으로써 얻어지는 장점들을 논하였다. GEM 프로토타입 시스템이 가동되고 있는 URL은 다음과 같다: http://lis.skku.ac.kr/gem/.

• 한국잠사곤충학회지
• /
• 제43권1호
• /
• pp.29-32
• /
• 2001

At present, more than 300 races of the Silkworm are conserved and used as valuable genetic resources. But because of the uneffectiveness of manual data management, faster and systematic data base construction is needed. So, development of silkworm genetic resources management program has been begun and the result can be practically used. When developing the program, Visual basic was used for data input system construction, and MS Access for database. IIS(Internet Information System) and ASP(Active Server Page) was also used for searching data and information with Internet Web Server and Web Browser which is comfortable for constructing database and providing information. Data input item consists of 46 practical characteristics such as race name, moltinism, larval period and pupation percentage etc.. And these characteristics are classified with qualitative and quantitative character. Photographs of silkworm, cocoon and other related items were scanned and the image data was recorded on the database.

• 인터넷정보학회논문지
• /
• 제18권5호
• /
• pp.55-60
• /
• 2017

The pulmonary function test (PFT) is an essential data source for evaluating the effect of drugs on the lungs or the status of lung function. However, the numeric values of PFT cannot be easily used for clinical studies without labor-intensive manual efforts, because PFTs are usually recorded as image files. This study was aimed at constructing a de-identified, open-access PFT database with various clinical information. For constructing the PFT database, optical character recognition (OCR), regular expression, and the parsing technique were used to extract alphanumeric data from the PFT images in a Korean tertiary teaching hospital. This longitudinal observational database contains 413,000 measurements of PFT from 183,000 patients.

• International Journal of Internet, Broadcasting and Communication
• /
• 제10권3호
• /
• pp.51-58
• /
• 2018

In order to utilize various data provided by Korea public open data portal, data should be systematically managed using a database. Since the range of open data is enormous, and the amount of data continues to increase, it is preferable to use a database capable of processing big data in order to analyze and utilize the data. This paper proposes data modeling and implementation method suitable for public data. The target data is subway related data provided by the public open data portal. Schema of the public data related to Seoul metro stations are analyzed and problems of the schema are presented. To solve these problems, this paper proposes a method to normalize and structure the subway data and model it in NoSQL database. In addition, the implementation result is shown by using MongDB which is a document-based database capable of processing big data.

• 경영정보학연구
• /
• 제1권2호
• /
• pp.55-71
• /
• 1999

• 제어로봇시스템학회:학술대회논문집
• /
• 제어로봇시스템학회 2003년도 ICCAS
• /
• pp.260-263
• /
• 2003

This paper has developed the computer integration manufacturing system and Internet based tele-operations. The functions of CIMS include production planing, material requirement planning, work order generation, process control, quality control, shipping planning, warehouse and inventory management and material cost accounting.[1] In this paper focuses on the automatic warehouse control and inventory management by developing the information system as well as the Internet-based integration. The system overview is divided into three parts, the mechanical system, the computer and developed software to control and manage the information and the communication system. The mechanical system consists of the warehouse machine and forklift mobile robot controlled by programmable logic controller (PLC). The computer works on many functions such as control station interfaces with PLC, managing database and inventory, and Internet server to broadcast the inventory database to users via World Wide Web and monitoring the operation on web camera. Our scheme the inventory database can be checked easily anywhere and anytime when the users connect to the Internet. In this article, the lead-time and inventory level can be reduced therefore the holding cost and operating time is also decreased.

• The Journal of Korean Physical Therapy
• /
• 제11권1호
• /
• pp.157-165
• /
• 1999

The Internet is an important tool in contemporary society. This study was carried out to investigate current use of internet and to suggest effective development of it in the field of physical therapy. A sample of physical therapy members in the internet responded to the questionare by means of e-mail from 26, April to 14. May. 1999. Of the 98 subjects, 26 completed the questionnaire, a response rate of $26.53\%$. The results were as follows. The most important problem to use internet in the field of physical therapy was poor information and abscence of database. The exchange of information among members, search database, virtual lecture system and distance treatment counseling in the future were expected. All members, professors of university and college, physical therapists in clinic and students must cooperate to construct database and useful information.