• Title/Summary/Keyword: DB Structure

Search Result 306, Processing Time 0.024 seconds

Requirements Analysis of Manufacturing Industry for the Development of Support System based on Cognitive and Affective Information (인지 및 감성 정보 지원 시스템 개발을 위한 제조업체 요구사항 분석)

  • Huh, Jung;Yoo, Hoon Sik;Ju, Da Young
    • Asia-pacific Journal of Multimedia Services Convergent with Art, Humanities, and Sociology
    • /
    • v.6 no.10
    • /
    • pp.549-564
    • /
    • 2016
  • Due to high cost of domestic production structure, steep growth of China's manufacturing business, and increase in oversea's production, building integrated system to support user-centered product design system based on cognitive and affective information is required to restore development of domestic manufacturing business. This paper put purpose on analysing requirements of end users, especially on information equipment business which works as a major industry in manufacturing businesses, and planning system design direction, prior to constructing user-centered product design support system based on cognitive and affective information. Research was conducted to identify current manufacturing process, application data on manufacturing, availability of cognitive and affective information data and its method of use, and necessity of user-centered product design support system based on cognitive and affective information, by carrying out in-depth interview with 6 related manufacturing companies. Need for user's character information was deducted from the interview, especially cognitive and affective information which is demanding for small to medium manufacturing business to research on its own.

Visualizing the Results of Opinion Mining from Social Media Contents: Case Study of a Noodle Company (소셜미디어 콘텐츠의 오피니언 마이닝결과 시각화: N라면 사례 분석 연구)

  • Kim, Yoosin;Kwon, Do Young;Jeong, Seung Ryul
    • Journal of Intelligence and Information Systems
    • /
    • v.20 no.4
    • /
    • pp.89-105
    • /
    • 2014
  • After emergence of Internet, social media with highly interactive Web 2.0 applications has provided very user friendly means for consumers and companies to communicate with each other. Users have routinely published contents involving their opinions and interests in social media such as blogs, forums, chatting rooms, and discussion boards, and the contents are released real-time in the Internet. For that reason, many researchers and marketers regard social media contents as the source of information for business analytics to develop business insights, and many studies have reported results on mining business intelligence from Social media content. In particular, opinion mining and sentiment analysis, as a technique to extract, classify, understand, and assess the opinions implicit in text contents, are frequently applied into social media content analysis because it emphasizes determining sentiment polarity and extracting authors' opinions. A number of frameworks, methods, techniques and tools have been presented by these researchers. However, we have found some weaknesses from their methods which are often technically complicated and are not sufficiently user-friendly for helping business decisions and planning. In this study, we attempted to formulate a more comprehensive and practical approach to conduct opinion mining with visual deliverables. First, we described the entire cycle of practical opinion mining using Social media content from the initial data gathering stage to the final presentation session. Our proposed approach to opinion mining consists of four phases: collecting, qualifying, analyzing, and visualizing. In the first phase, analysts have to choose target social media. Each target media requires different ways for analysts to gain access. There are open-API, searching tools, DB2DB interface, purchasing contents, and so son. Second phase is pre-processing to generate useful materials for meaningful analysis. If we do not remove garbage data, results of social media analysis will not provide meaningful and useful business insights. To clean social media data, natural language processing techniques should be applied. The next step is the opinion mining phase where the cleansed social media content set is to be analyzed. The qualified data set includes not only user-generated contents but also content identification information such as creation date, author name, user id, content id, hit counts, review or reply, favorite, etc. Depending on the purpose of the analysis, researchers or data analysts can select a suitable mining tool. Topic extraction and buzz analysis are usually related to market trends analysis, while sentiment analysis is utilized to conduct reputation analysis. There are also various applications, such as stock prediction, product recommendation, sales forecasting, and so on. The last phase is visualization and presentation of analysis results. The major focus and purpose of this phase are to explain results of analysis and help users to comprehend its meaning. Therefore, to the extent possible, deliverables from this phase should be made simple, clear and easy to understand, rather than complex and flashy. To illustrate our approach, we conducted a case study on a leading Korean instant noodle company. We targeted the leading company, NS Food, with 66.5% of market share; the firm has kept No. 1 position in the Korean "Ramen" business for several decades. We collected a total of 11,869 pieces of contents including blogs, forum contents and news articles. After collecting social media content data, we generated instant noodle business specific language resources for data manipulation and analysis using natural language processing. In addition, we tried to classify contents in more detail categories such as marketing features, environment, reputation, etc. In those phase, we used free ware software programs such as TM, KoNLP, ggplot2 and plyr packages in R project. As the result, we presented several useful visualization outputs like domain specific lexicons, volume and sentiment graphs, topic word cloud, heat maps, valence tree map, and other visualized images to provide vivid, full-colored examples using open library software packages of the R project. Business actors can quickly detect areas by a swift glance that are weak, strong, positive, negative, quiet or loud. Heat map is able to explain movement of sentiment or volume in categories and time matrix which shows density of color on time periods. Valence tree map, one of the most comprehensive and holistic visualization models, should be very helpful for analysts and decision makers to quickly understand the "big picture" business situation with a hierarchical structure since tree-map can present buzz volume and sentiment with a visualized result in a certain period. This case study offers real-world business insights from market sensing which would demonstrate to practical-minded business users how they can use these types of results for timely decision making in response to on-going changes in the market. We believe our approach can provide practical and reliable guide to opinion mining with visualized results that are immediately useful, not just in food industry but in other industries as well.

A Study on Design Education Re-engineering by Multi-disciplinary Approach (다학제적 접근을 통한 대학디자인 교육혁신 프로그램 연구)

  • Lee, Soon-Jong;Kim, Jong-Won;Chu, Wu-Jin;Chae, Sung-Zin;Yoon, Su-Hyun
    • Archives of design research
    • /
    • v.20 no.3 s.71
    • /
    • pp.299-314
    • /
    • 2007
  • For the past 20 years, the growth and development of university-design-educational institutes contributed to the industrial development of our country. Due to the technological fluctuation and changes in the industrial structure in the latter half of the 20th century, the enterprise is demanding professionally-oriented design manpower. The principle which appears from instances of the advanced nations is to accommodate the demands in social changes and apply them to educational design programs. In order to respond promptly to the industrial demand especially, the advanced nations adopted "multidisciplinary design education programs" to lead innovation in the area of design globally. The objective of the research consequently is to suggest an educational system and a program through which the designer can be educated to obtain complex knowledge and the technique demanded by the industry and enterprise. Nowadays in order to adapt to a new business environment, designers specially should have both the knowledge and techniques in engineering and business administration. We suggest that the IPDI, a multidisciplinary design educational system and program is made up of the coordinated operation of major classes, on-the-job training connection, educational system for research base creation, renovation design development program for the application and the synthesis of alternative proposals about the training facility joint ownership by connecting with the education of design, business administration and engineering.

  • PDF

A Proposal for Promotion of Research Activities by Analysis of KOSEF's Basic Research Supports in Agricultural Sciences (한국과학재단의 농수산분야 기초연구지원 추이분석을 통한 연구활동지원 활성화 제언)

  • Min, Tae-Sun;Choi, Hyung-Kyoon;Kim, Seong-Yong;Bai, Sung-Chul;Kim, Yoo-Yong;Yang, Moon-Sik;Chung, Bong-Hyun;Hwang, Joon-Young;Han, In-Kyu
    • Applied Biological Chemistry
    • /
    • v.48 no.1
    • /
    • pp.23-33
    • /
    • 2005
  • Agricultural sciences field in South Korea has many strong points such as numerous researchers, establishment of research infra-structure, excellence in research competitiveness and high technological level. However, there are also many weaknesses including insufficient leadership at related societies and institutes, deficiency of the next generation research group, and insufficiency in research productivity. There are many opportunities including increasing the importance of the biotechnological industry, activating international cooperation researches, and exploring the multitude of possible research areas to be studied. However, some threats still exist, such as pressure from the government of developed countries to open the agricultural market, the decrease of specialized farms, and intensification for researches to gratify economic and social demands. To encourage research activities in the agricultural sciences field in Korea, the following actions and systems are required: 1) formulation of a mid- and a long-term research master plan, 2) development of a database on the man power in related fields, 3) activation of top-down research topics, and associated increase of individual research grants, 4) development of special national programs for basic researches in agricultural sciences, 5) organization of a committee for policy and planning within the related societies, and 6) system development for the fair evaluation of the research results.

A Study on a Type of Regeneration Project on Old Industrial Complex (노후산업단지 재생사업 추진 유형에 관한 연구)

  • Kim, Joo-hoon;Byun, Byung-seol
    • Journal of the Economic Geographical Society of Korea
    • /
    • v.21 no.2
    • /
    • pp.192-211
    • /
    • 2018
  • With significant influences of old industrial complex in September 2009, Ministry of Land, Infrastructure and Transport chose the 4 districts for the first pilot project. In December 2014, the second pilot project districts were established. In addition, there were 10 districts in April 2016 and 5 districts in April 2016 as the third pilot project and 5 districts in March 2017 as the fourth pilot project. In order to promote smooth business operation of the recycling business, we introduced the effective area designation and special system as stipulated in Article 39.12-13 of the Industrial Location and Development Act revised in May 2015. The effective area, It is a method that can promote propagation and diffusion of the rehabilitation business through visualization by making effective the promotion of the rehabilitation business and by promoting the business in consideration of the geographical feature of the region and industry group, The setting of the unreasonable effective area is based on the criteria and classification of the plan and the objective promotion method according to the individual characteristics of the aged industrial park because the delay of the rehabilitation business and the possibility of the increase of many problems are presented Be sure to Data Envelopment Analysis (DEA) and the old industrial complex database were constructed and utilized to classify the types of recycling projects. Therefore, in this study, it is necessary to strengthen the competitiveness of aged industrial complex by examining the correlation between the diagnosis of 83 aged industrial complex sites and the rehabilitation projects supported by the Ministry of Land, and the types of business promotion for aged industrial parks. It can be used as a guideline for the feasibility of the project.

Investigation of fish community structure and species diversity in two river estuary ecosystems, the Taehwa River and Changwon Stream, based on conventional survey and eDNA metabarcoding (어구조사 및 환경 DNA 메타바코딩을 이용한 태화강, 창원천 하구 생태계의 어류 군집 구조 및 종 다양성 평가)

  • Hee-kyu Choi;Yu Rim Kim;Soon Young Hwang;Yeounsu Chu;Pyoungbeom Kim;Hyuk Je Lee
    • Korean Journal of Environmental Biology
    • /
    • v.41 no.4
    • /
    • pp.637-656
    • /
    • 2023
  • River estuaries are dynamic and productive ecosystems with high regional biodiversity. Environmental DNA (eDNA) has become a useful approach to assessing biodiversity in aquatic ecosystems. This study was conducted to investigate fish community characteristics and species diversity in two river estuary ecosystems, the Taehwa River and Changwon Stream. We further compared conventional and eDNA metabarcoding analyses of the fish communities. The conventional survey was performed in May, July, and October 2022, while the eDNA analysis was conducted only in May. We observed various fish species with different life histories, including carp, goby, and marine fish. We also found that migratory fish, such as dace Tribolodon hakonensis, sweetfish Plecoglossus altivelis, and eel Auguilla japonica, occurred in the Taehwa River, suggesting high river connectivity. Marine fish species were predominant in the Changwon Stream, as this river is located close to the sea. The diversity indices showed that the Taehwa River generally had higher species richness, evenness, and diversity values than the Changwon Stream. A total of 9-19 species were detected in the conventional survey for the three sites, whereas 11-18 species were found from eDNA analysis. The findings indicate that the sensitivity of eDNA was similar to or higher than that of the conventional method. Our study findings suggest the efficiency and efficacy of eDNA-based fish community monitoring, although with some shortcomings in applying the genetic marker to Korean fish, including no clear-cut distinction for Korean endemic species and/or genetically closely related species groups.