• Title/Summary/Keyword: 데이터베이스 구축

Search Result 3,231, Processing Time 0.038 seconds

A Dynamic Management Method for FOAF Using RSS and OLAP cube (RSS와 OLAP 큐브를 이용한 FOAF의 동적 관리 기법)

  • Sohn, Jong-Soo;Chung, In-Jeong
    • Journal of Intelligence and Information Systems
    • /
    • v.17 no.2
    • /
    • pp.39-60
    • /
    • 2011
  • Since the introduction of web 2.0 technology, social network service has been recognized as the foundation of an important future information technology. The advent of web 2.0 has led to the change of content creators. In the existing web, content creators are service providers, whereas they have changed into service users in the recent web. Users share experiences with other users improving contents quality, thereby it has increased the importance of social network. As a result, diverse forms of social network service have been emerged from relations and experiences of users. Social network is a network to construct and express social relations among people who share interests and activities. Today's social network service has not merely confined itself to showing user interactions, but it has also developed into a level in which content generation and evaluation are interacting with each other. As the volume of contents generated from social network service and the number of connections between users have drastically increased, the social network extraction method becomes more complicated. Consequently the following problems for the social network extraction arise. First problem lies in insufficiency of representational power of object in the social network. Second problem is incapability of expressional power in the diverse connections among users. Third problem is the difficulty of creating dynamic change in the social network due to change in user interests. And lastly, lack of method capable of integrating and processing data efficiently in the heterogeneous distributed computing environment. The first and last problems can be solved by using FOAF, a tool for describing ontology-based user profiles for construction of social network. However, solving second and third problems require a novel technology to reflect dynamic change of user interests and relations. In this paper, we propose a novel method to overcome the above problems of existing social network extraction method by applying FOAF (a tool for describing user profiles) and RSS (a literary web work publishing mechanism) to OLAP system in order to dynamically innovate and manage FOAF. We employed data interoperability which is an important characteristic of FOAF in this paper. Next we used RSS to reflect such changes as time flow and user interests. RSS, a tool for literary web work, provides standard vocabulary for distribution at web sites and contents in the form of RDF/XML. In this paper, we collect personal information and relations of users by utilizing FOAF. We also collect user contents by utilizing RSS. Finally, collected data is inserted into the database by star schema. The system we proposed in this paper generates OLAP cube using data in the database. 'Dynamic FOAF Management Algorithm' processes generated OLAP cube. Dynamic FOAF Management Algorithm consists of two functions: one is find_id_interest() and the other is find_relation (). Find_id_interest() is used to extract user interests during the input period, and find-relation() extracts users matching user interests. Finally, the proposed system reconstructs FOAF by reflecting extracted relationships and interests of users. For the justification of the suggested idea, we showed the implemented result together with its analysis. We used C# language and MS-SQL database, and input FOAF and RSS as data collected from livejournal.com. The implemented result shows that foaf : interest of users has reached an average of 19 percent increase for four weeks. In proportion to the increased foaf : interest change, the number of foaf : knows of users has grown an average of 9 percent for four weeks. As we use FOAF and RSS as basic data which have a wide support in web 2.0 and social network service, we have a definite advantage in utilizing user data distributed in the diverse web sites and services regardless of language and types of computer. By using suggested method in this paper, we can provide better services coping with the rapid change of user interests with the automatic application of FOAF.

Analysis of Research on Non-Timber Forest Plants - Based on the Articles Published in the Journal of Korean Forest Society from 1962 to 2013 - (산림과학분야의 산림특용자원식물의 연구 - 한국임학회지에 게재된 논문을 중심으로 -)

  • Lee, Hyunseok;Yi, Jaeseon;An, Chanhoon;Lee, Jeonghoon
    • Journal of Korean Society of Forest Science
    • /
    • v.104 no.3
    • /
    • pp.337-351
    • /
    • 2015
  • The articles, published in the Journal of Korean Forest Society from Volume 1 (1962) to Volume 102 (2013), were investigated for the research trend analysis about forest plants for special purposes, i.e., edible plants, medicinal plants, feed resources, landscape plants, fiber plants, industrial usage, bee plants, bioenergy/phytoremediation uses, dye materials, and rare/endangered/endemic plants. These research articles were classified again based on the contents of research into following categories - habitat environment, ecology, physiology, propagation, silviculture (including planting and tending), genetics and breeding, identification, pest and disease control, animal-related research, components analysis and extracts, vegetation survey, biotechnology, management, recreation and forest healing, and research review. Among the total 2,433 articles published, 611 (25.1%) were related to plants for special usage or purposes. The highest frequency (14.9%) in publications was found in the field of silviculture followed by physiology, propagation, identification, and genetics and breeding, respectively. On the bases of usage, edible plants showed higher frequency (26.5%) than others, followed by industrial purpose, bioenergy/phytoremediation usage, landscape plants, medicinal plants, and rare/endangered/endemic plants. Populus plant species was the most popular in research, showing 62 articles; and Castanea crenata 36; Pinus koraiensis 35; Robinia pseudoacacia 20; Ginko biloba 17, etc. Based on the survey and analysis, the following points are suggested: 1) improved evaluation of forest plants as non-wood resources, 2) expanding research topics on the basis of production, management, and utilization of non-wood forest resources, 3) management of database of forest plant information and encouragement needed to strengthen cooperative researches satisfying the needs of other industrial and scientific areas, and 4) encouraging to promote traditional knowledge based research on forest plants.

Auxiliary Reinforcement Method for the Safety of Tunnelling Face (터널 막장안정성에 따른 보강공법 적용)

  • Kim, Chang-Yong;Park, Chi-Hyun;Bae, Gyu-Jin;Hong, Sung-Wan;Oh, Myung-Ryul
    • Journal of Korean Tunnelling and Underground Space Association
    • /
    • v.2 no.2
    • /
    • pp.11-21
    • /
    • 2000
  • Tunnelling has been created as a great extent in view of less land space available because the growth of population in metropolitan has been accelerated at a faster pace than the development of the cities. In tunnelling, it is often faced that measures are obliged to be taken without confirmation for such abnormality as diverged movement of surrounding rock mass, growing crack of shotcrete and yielding of rockbolts. In this case, it is usually said that the judgments of experienced engineers for the selection of measure are importance and allowed us to get over the situations in many construction sites. But decrease of such experienced engineers need us to develop the new system to assist the selection of measures for the abnormality without any experiences of similar tunnelling sites. In this study, After a lot of tunnelling reinforcement methods were surveyed and the detail application were studied, an expert system was developed to predict the safety of tunnel and choose proper tunnel reinforcement system using fuzzy quantification theory and fuzzy inference rule based on tunnel information database. The expert system developed in this study have two main parts named pre-module and post-module. Pre-module decides tunnel information imput items based on the tunnel face mapping information which can be easily obtained in-situ site. Then, using fuzzy quantification theory II, fuzzy membership function is composed and tunnel safety level is inferred through this membership function. The comparison result between the predicted reinforcement system level and measured ones was very similar. In-situ data were obtained in three tunnel sites including subway tunnel under Han river. This system will be very helpful to make the most of in-situ data and suggest proper applicability of tunnel reinforcement system developing more resonable tunnel support method from dependance of some experienced experts for the absent of guide.

  • PDF

Estimation of Amount and Frequency of Consumption of 50 Domestic Livestock and Processed Livestock Products (국내 50가지 축산물 및 축산가공 식품의 섭취량 및 섭취빈도 조사)

  • Park, Jin Hwa;Cho, Joon Il;Joo, In Sun;Heo, Jin Jae;Yoon, Ki Sun
    • Journal of the Korean Society of Food Science and Nutrition
    • /
    • v.45 no.8
    • /
    • pp.1177-1191
    • /
    • 2016
  • Estimation of food consumption details, such as portion size and frequency of consumption, is needed for exposure assessment step in microbiological risk assessment. This study investigated the amounts and frequencies of 50 kinds of consumed livestock products. A quantitative survey was performed by trained interviewers in face-to-face interviews with 1,500 adults aged over 19, who were randomly selected from seven major provinces in Korea. Respondents received a picture of one serving size for each of the 50 livestock products, including meats, processed meat products, milk and dairy products, and eggs and processed egg products. A t-test and general linear model were carried out using SPSS statistics. The most important factor affecting consumption of livestock products was residence area. The most frequently consumed food was milk (2.6 times/week), followed by pork (1.4 times/week), liquid yogurt (1.3 times/week), rolled omelet (1.2 times/week), semisolid yogurt (1.0 times/week), steamed egg (1.0 times/week), ice cream (0.9 times/week), chicken (0.8 times/week), low fat milk (0.7 times/week), and beef (0.6 times/week). In the case of consumption amount, people living in a city consumed meat (beef, pork, chicken, and duck) 1.5 times more than those living in a village, whereas milk and dairy products and eggs and processed egg products were consumed more frequently by people living in a town. When people eat meat, they consume twice the amount of one serving size. Students consumed livestock and processed livestock products more frequently with greater portions all at once. People living in Seoul, Incheon/Gyeonggi, and Busan/Ulsan/Gyeongnam consumed livestock products more frequently in large amounts. Data from this study can be used for risk assessment of livestock and processed livestock products as well as education for safe consumption of livestock products.

Impact Evaluation of Water Footprint on Stages of Drainage Works (배수공 각 작업 단계별 물발자국 영향평가)

  • Chen, Di;Kim, Joon-Soo;Batagalle, Vinuri;Kim, Byung-Soo
    • KSCE Journal of Civil and Environmental Engineering Research
    • /
    • v.40 no.2
    • /
    • pp.225-231
    • /
    • 2020
  • Fresh water that can be used by a person of the total amount of water on the planet is increased because it is less than 0.01 % except underground water, ice and snow, etc. water management response need. In order to protect and efficiently utilize water resources, major countries are conducting water footprint studies that can quantitatively estimate the amount of water put into the operating phase of the resource harvesting phase, mainly agriculture. Korea has also recently developed a number of policies in order to cope with water shortages, and in the construction industry, as well as the need for basic research to support it has been emphasized. This study was constructed DB up to the raw material harvesting step, the transport step, the production stage in order to estimate the water consumption of resources to be put into the work process to target the drainage of the road. Water usage estimation method was utilized the method presented in the Water Footprint Manual and the environmental score card certification guide, unit water usage each drainage main method was calculated after estimating the water footprint considering the water character factor, indirect water and the direct water, the water consumption factor of material input to each process. Brown asphalt, rebar, remicon of the drainage material as a result of the water footprint calculation accounted for 97 % of the total. Drainage method is a culvert, a side channel, a culvert wing wall, reinforced concrete open channel accounted for 92.2 % of the total. Drainage total step-by-step calculated water consumption and water footprint was found in order of raw material harvesting step, transport stage, production stage. Water footprint each drainage method or total drainage material calculated in this study can be used as a base data in the agricultural and construction sectors. In order to increase the reliability of the analysis, it is believed that further overseas databases will be needed for continuous review and research.

Effects of four substances requiring preparation for accidents on the survival and reproduction of Paronychiurus kimi (Collembola: Onychiuridae) (사고대비물질 4종이 김어리톡토기의 사망 및 번식에 미치는 영향)

  • Wee, June;Lee, Yun-Sik;Son, Jino;Ko, Euna;Cho, Kijong
    • Korean Journal of Environmental Biology
    • /
    • v.37 no.4
    • /
    • pp.749-758
    • /
    • 2019
  • The aim of this study is to provide a scientific basis for decision making regarding environmental damage in case of future chemical accidents by evaluating the ecotoxicity of 4 substances requiring preparation for accidents. For this purpose, acute and chronic toxicities of nitric acid, sulfuric acid, hydrogen peroxide, and ammonia solution, which can change the physical and chemical properties of soil to Paronychiurus kimi(Collembola) were investigated. The pH of artificial soil spiked with a series of test chemical concentrations was also measured. The pH of soil spiked with 10,000 mg kg-1 of soil nitric acid, sulfuric acid, hydrogen peroxide, and ammonia solution were 2.86, 2.72, 7.18 and 9.69, respectively. The 28-d LC50 of nitric acid, sulfuric acid, hydrogen peroxide and ammonia solution were 2,703, 5,414, 3,158 and 859 mg kg-1 soil dry wt., respectively and 28-d EC50 were 587, 2,148, 1,300 and 216 mg kg-1 soil dry wt., respectively. These results indicated that the mortality and juvenile production of P. kimi were influenced by not only the soil pH but also by the reduced organic content and products produced by the reaction of soil with the tested chemicals. Given the fact that most substances requiring preparation for accidents can change soil characteristics, assessment and restoration methods that take into account changes in soil properties are needed for accurate decision making after chemical accidents.

The Production of Sex Determined Cattle by Embryonic Sexing Using Fluorescence In Situ Hybridization Technique (FISH 기법을 이용한 소 수정란의 성감별과 산자 생산)

  • Sohn, S.H.;Park, H.
    • Proceedings of the Korean Society of Embryo Transfer Conference
    • /
    • 2007.05a
    • /
    • pp.39-50
    • /
    • 2007
  • Sexing from bovine embryos fertilized in vitro implicates a possibility of the sex controlled cattle production. This study was carried out to produce the sex determined cattle through the embryonic sexing by fluorescence in situ hybridization (FISH) technique. FISH was achieved in in vitro fertilized bovine embryos using a bovine Y-specific DNA probe constructed from the btDYZ-1 sequence. Using this probe, a male-specific signal was detected on 100% of Y-chromosome bearing metaphase specimens. The analyzable rate of embryonic sexing by FISH technique was about 93% (365/393) regardless of embryonic stages. As tested single blastomere by FISH and then karyotype with their biopsied embryos, the accuracy of sex determination with FISH was 97.6%. We tried the embryo transfer with sex determined embryos on 15 cattle. Among them, the 5 cattle delivered calf with expected sex last year.

  • PDF

Development of JPEG2000 Viewer for Mobile Image System (이동형 의료영상 장치를 위한 JPEG2000 영상 뷰어 개발)

  • 김새롬;정해조;강원석;이재훈;이상호;신성범;유선국;김희중
    • Progress in Medical Physics
    • /
    • v.14 no.2
    • /
    • pp.124-130
    • /
    • 2003
  • Currently, as a consequence of PACS (Picture Archiving Communication System) implementation many hospitals are replacing conventional film-type interpretations of diagnostic medical images with new digital-format interpretations that can also be saved, and retrieve However, the big limitation in PACS is considered to be the lack of mobility. The purpose of this study is to determine the optimal communication packet size. This was done by considering the terms occurred in the wireless communication. After encoding medical image using JPGE2000 image compression method, This method embodied auto-error correction technique preventing the loss of packets occurred during wireless communication. A PC class server, with capabilities to load, collect data, save images, and connect with other network, was installed. Image data were compressed using JPEG2000 algorithm which supports the capability of high energy density and compression ratio, to communicate through a wireless network. Image data were also transmitted in block units coeded by JPEG2000 to prevent the loss of the packets in a wireless network. When JPGE2000 image data were decoded in a PUA (Personal Digital Assistant), it was instantaneous for a MR (Magnetic Resonance) head image of 256${\times}$256 pixels, while it took approximately 5 seconds to decode a CR (Computed Radiography) chest image of 800${\times}$790 pixels. In the transmission of the image data using a CDMA 1X module (Code-Division Multiple Access 1st Generation), 256 byte/sec was considered a stable transmission rate, but packets were lost in the intervals at the transmission rate of 1Kbyte/sec. However, even with a transmission rate above 1 Kbyte/sec, packets were not lost in wireless LAN. Current PACS are not compatible with wireless networks. because it does not have an interface between wired and wireless. Thus, the mobile JPEG2000 image viewing system was developed in order to complement mobility-a limitation in PACS. Moreover, the weak-connections of the wireless network was enhanced by re-transmitting image data within a limitations The results of this study are expected to play an interface role between the current wired-networks PACS and the mobile devices.

  • PDF

Dynamic Traffic Assignment Using Genetic Algorithm (유전자 알고리즘을 이용한 동적통행배정에 관한 연구)

  • Park, Kyung-Chul;Park, Chang-Ho;Chon, Kyung-Soo;Rhee, Sung-Mo
    • Journal of Korean Society for Geospatial Information Science
    • /
    • v.8 no.1 s.15
    • /
    • pp.51-63
    • /
    • 2000
  • Dynamic traffic assignment(DTA) has been a topic of substantial research during the past decade. While DTA is gradually maturing, many aspects of DTA still need improvement, especially regarding its formulation and solution algerian Recently, with its promise for In(Intelligent Transportation System) and GIS(Geographic Information System) applications, DTA have received increasing attention. This potential also implies higher requirement for DTA modeling, especially regarding its solution efficiency for real-time implementation. But DTA have many mathematical difficulties in searching process due to the complexity of spatial and temporal variables. Although many solution algorithms have been studied, conventional methods cannot iud the solution in case that objective function or constraints is not convex. In this paper, the genetic algorithm to find the solution of DTA is applied and the Merchant-Nemhauser model is used as DTA model because it has a nonconvex constraint set. To handle the nonconvex constraint set the GENOCOP III system which is a kind of the genetic algorithm is used in this study. Results for the sample network have been compared with the results of conventional method.

  • PDF

The Strategy of Characterizing Space that uses Anti-House as a Metaphor for Character's Self-Defense Mechanism - Focusing on the TV Series and the Theater version of - (캐릭터의 자아방어기제를 은유하는 '안티돔' 공간의 성격화 전략 - <에반게리온>의 TV 시리즈와 극장판 를 중심으로 -)

  • Yang, Se-Hyeok;Ryu, Beom-Yeol
    • Cartoon and Animation Studies
    • /
    • s.41
    • /
    • pp.75-106
    • /
    • 2015
  • Animations characterize space as a strategy to effectively show the inner conflicts of characters and to highlight the theme. During the process of inner conflict, characters unconsciously use defense mechanism to protect their egos from the fear that came from deficiency, and because of the self-deceptive quality of self-defense mechanism, the reality is distorted and conflicts get intensified. This study focuses on the concept of anti-house, the space where conflicts get intensified, analyzes animations to find out the aspect of inner conflict, and interprets the characteristic of space that is used for metaphoric structure frame. Also, it aims to reveal how the defense mechanism, which intensifies the inner conflict of characters, is characterized as anti-house. The analysis in this study was mainly done with the TV series, , and the theater version of . It is because the characters have serious deficiency from broken home and have a psychological quality of closed boundary that is symbolized as 'A.T. field'. Especially, the core character, 'Shinji Ikari', shows how a character uses compulsive self-defense mechanism to deal with inner conflict and as a result, goes through ego-collapse and then introspection. This process of the character's experience is the core of the whole plot. Through analysis, the relationship between the character's self-defense mechanism and the space, anti-house(which expands to Anti-city), was inferred. The space is made up of three axes, x-axis of horizontal space, y-axis of vertical space, and in the sense that all the space has no exit, z-axis of deeper contradictory space. This thesis started with the decision that is the most suitable work in analyzing the metaphorical relationship between self-defense mechanism and anti-house. There was limitation, however, as the typical characteristics of Japanese animations, pedantic composition and the possibility of broad interpretation, hindered clear verification. Hopefully, this limitation will be overcome by following studies and this study is expected to show the importance of space in interpreting the text of animations, and to serve as database for other creative works.