MySQL Database Server Research Articles

MySQL과 JSP를 기반으로 한 관측자료의 데이터베이스화

As a core project of the Korean Astronomical Data Center (KADC) in Korea Astronomy Observatory (KAO), we have constructed a framework of astronomical database using MySQL and JSP. MySQL database server is a powerful open source database management system, and JSP technology provides a simplified, fast way to create dynamic web content. Combined together, MySQL and JSP enable us to develop server-independent web-based applications efficiently in a short amount of time. The MySQL tables and JSP programs embedded in our database are built/written in a way to benefit both users and managers. We plan to expand our database by supplementing additional data in the near future. Our newly constructed database is expected to be the prototype of the Korean Virtual Observatory (KVO).

The construction of web database server‐client system for functional food factors

In food, other than known nutrients, such as lipid, carbohydrate, protein, vitamins, and minerals, many substances with physiological function and medicinal action exist, and it is contributing to healthy improvement and/or prevention of illness. Although carotenoid, flavonoid and polyphenol, terpenoid, volatile substance and sulfur compounds, peptide, etc. have the function of illness prevention, and research of those non-nutrient functional food factors (FFF) became globally active, the research of this field is not yet done systematically. We evaluate function of FFF and reappraise known knowledge, and this knowledge is standardized and accumulated, aimed at building a web database server-client system which is easy to use for the people and nutritional research. We also collected related data such as chemical characters of FFF from literatures and other source, and formatted them into the database. We constructed the web database server-client system with MySQL database server and Apache web server based on Linux, and used Tomcat JSP engine for data connecting since they were reliable in stability and speed. We are opening the database at http://www.life-science.jp/FFF for test now.