Web技術を統合したカロリー計算データベースの設計と構築(経営情報科学部:情報科学科経営情報システム専攻・コンピュータシステム専攻)

概要

論文の詳細を見る
This paper proposes a design and construction for calorie calculating database integrated with some Web technologies. The database server is implemented by MySQL, Web server is by Apache, and Web scripting language is by PHP. PHP is known as well-suited with both MySQL and Apache servers. The database consists of five tables such as a dish table, a cooking recipe table, a food table, a cooking-category table, and a personal-user's table. All of tables are derived from the entity-relationship (ER) model regarding to cooking recipes. The behavior of system could be started with selecting a menu among Japanese, Western, and Chinese foods or entering food amount for the recipe. The values of food compositions per 100g are automatically calculated, then the system show the total calorie and Protein-Fat-Carbohydrate (PFC) balance on user's web browser. The former is formed as a table, and the later as a radar chart. The chart could be dynamically drawn by the combination with a Flash ActionScript and a XML script. Here, PHPDOM rewrites the values of contents in the XML file. The number of foods contained in "The Standard Tables of Food Composition in Japan Fifth Revised Edition" is up to 1882 items.
愛知工業大学の論文
2005-03-31