• Title/Summary/Keyword: 데이터베이스 관리

Search Result 3,421, Processing Time 0.03 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.

RAUT: An end-to-end tool for automated parsing and uploading river cross-sectional survey in AutoCAD format to river information system for supporting HEC-RAS operation (하천정비기본계획 CAD 형식 단면 측량자료 자동 추출 및 하천공간 데이터베이스 업로딩과 HEC-RAS 지원을 위한 RAUT 툴 개발)

  • Kim, Kyungdong;Kim, Dongsu;You, Hojun
    • Journal of Korea Water Resources Association
    • /
    • v.54 no.12
    • /
    • pp.1339-1348
    • /
    • 2021
  • In accordance with the River Law, the basic river maintenance plan is established every 5-10 years with a considerable national budget for domestic rivers, and various river surveys such as the river section required for HEC-RAS simulation for flood level calculation are being conducted. However, river survey data are provided only in the form of a pdf report to the River Management Geographic Information System (RIMGIS), and the original data are distributedly owned by designers who performed the river maintenance plan in CAD format. It is a situation that the usability for other purposes is considerably lowered. In addition, when using surveyed CAD-type cross-sectional data for HEC-RAS, tools such as 'Dream' are used, but the reality is that time and cost are almost as close as manual work. In this study, RAUT (River Information Auto Upload Tool), a tool that can solve these problems, was developed. First, the RAUT tool attempted to automate the complicated steps of manually inputting CAD survey data and simulating the input data of the HEC-RAS one-dimensional model used in establishing the basic river plan in practice. Second, it is possible to directly read CAD survey data, which is river spatial information, and automatically upload it to the river spatial information DB based on the standard data model (ArcRiver), enabling the management of river survey data in the river maintenance plan at the national level. In other words, if RIMGIS uses a tool such as RAUT, it will be able to systematically manage national river survey data such as river section. The developed RAUT reads the river spatial information CAD data of the river maintenance master plan targeting the Jeju-do agar basin, builds it into a mySQL-based spatial DB, and automatically generates topographic data for HEC-RAS one-dimensional simulation from the built DB. A pilot process was implemented.

Data issue and Improvement Direction for Marine Spatial Planning (해양공간계획 지원을 위한 정보 현안 및 개선 방향 연구)

  • CHANG, Min-Chol;PARK, Byung-Moon;CHOI, Yun-Soo;CHOI, Hee-Jung;KIM, Tae-Hoon;LEE, Bang-Hee
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.21 no.4
    • /
    • pp.175-190
    • /
    • 2018
  • Recently, policy of the marine advanced countries were switched from the preemption using ocean to post-project development. In this study, we suggest improvement and the pending issues when are deducted to the database of the marine spatial information is constructed over the GIS system for the Korean Marine Spatial Planning (KMSP). More than 250 spatial information in the seas of Korea were processed in order of data collection, GIS transformation, data analysis and processing, data grouping, and space mapping. It's process had some problem occurred to error of coordinate system, digitizing process for lack of the spatial information, performed by overlapping for the original marine spatial information, and so on. Moreover, solution is needed to data processing methods excluding personal information which is necessary when produce the spatial data for analysis of the used marine status and minimized method for different between the spatial information based GIS system and the based real information. Therefore, collection and securing system of lacking marine spatial information is enhanced for marine spatial planning. it is necessary to link and expand marine fisheries survey system. It is needed to the marine spatial planning. The marine spatial planning is required to the evaluation index of marine spatial and detailed marine spatial map. In addition, Marine spatial planning is needed to standard guideline and system of quality management. This standard guideline generate to phase for production, processing, analysis, and utilization. Also, the quality management system improve for the information quality of marine spatial information. Finally, we suggest necessity need for the depths study which is considered as opening extension of the marine spatial information and deduction on application model.

A Study on a Basic Model for GIS Audit, Based on Various Types of GIS Projects (GIS 사업유형을 고려한 GIS 감리의 기반 모델 연구)

  • Koh, Kwang-Chul;Kim, Eun-Hyung
    • Journal of Korea Spatial Information System Society
    • /
    • v.2 no.2 s.4
    • /
    • pp.5-23
    • /
    • 2000
  • Since 1995, national and local governments have competitively initiated many and large GIS projects and audit for the projects becomes an important issue. So far, the audit in the Information Technology(IT) area has tried to deal with the issue but ineffectiveness has been found for the successful GIS project management. Effective auditing is a critical element for the project management. In order to establish a proper audit model for the GIS projects and to promote auditing activities in the projects, this study constructs two hypotheses and tries to prove them. The hypotheses are as follows : 1) For a good audits model for GIS, unique characteristics of a GIS project audit items and the scope of the audit need to be identified. 2) The scope of audit needs to be classified according to the requests from tasks in the projects. To prove the hypotheses, this study analyzes positive aspects of audit in IT and construction projects, clarifies the audit items in GIS projects by comparing with them, and classifies the scope of the GIS audit based on various types of GIS projects. As a results, 5 types of the GIS audit are identified : (1) audit for project management, (2) audit focused on IT, (3) audit characterized by GIS technologies, (4) GIS database audit and (5) consulting services for critical problems in the projects. In addition, 4 criteria in classifying the GIS projects are suggested for the GIS audit. The 4 criteria are domain, scope, duration, and GIS applications technologies. Especially, GIS technology considered in this study includes GIS software, methodologies for GIS development, GIS database and quality control of GIS data, which are not usually reflected in the existing studies about in GIS audit. Because the GIS audit depends on a type of GIS projects, scopes of the audit can be flexibly reconstructed in accordance with the types of GIS projects. This is a key to effective and realistic audit for the future GIS projects. Strategies for effective GIS audit are also proposed in terms of the following: GIS project management, goal establishment in each audit stage, documentation from GIS audit, timing strategies for intensive GIS audit, and designing team structure.

  • PDF

Construction of Database System on Amylose and Protein Contents Distribution in Rice Germplasm Based on NIRS Data (벼 유전자원의 아밀로스 및 단백질 성분 함량 분포에 관한 자원정보 구축)

  • Oh, Sejong;Choi, Yu Mi;Lee, Myung Chul;Lee, Sukyeung;Yoon, Hyemyeong;Rauf, Muhammad;Chae, Byungsoo
    • Korean Journal of Plant Resources
    • /
    • v.32 no.2
    • /
    • pp.124-143
    • /
    • 2019
  • This study was carried out to build a database system for amylose and protein contents of rice germplasm based on NIRS (Near-Infrared Reflectance Spectroscopy) analysis data. The average waxy type amylose contents was 8.7% in landrace, variety and weed type, whereas 10.3% in breeding line. In common rice, the average amylose contents was 22.3% for landrace, 22.7% for variety, 23.6% for weed type and 24.2% for breeding line. Waxy type resources comprised of 5% of the total germplasm collections, whereas low, intermediate and high amylose content resources share 5.5%, 20.5% and 69.0% of total germplasm collections, respectively. The average percent of protein contents was 8.2 for landrace, 8.0 for variety, and 7.9 for weed type and breeding line. The average Variability Index Value was 0.62 in waxy rice, 0.80 in common rice, and 0.51 in protein contents. The accession ratio in arbitrary ranges of landrace was 0.45 in amylose contents ranging from 6.4 to 8.7%, and 0.26 in protein ranging from 7.3 to 8.2%. In the variety, it was 0.32 in amylose ranging from 20.1 to 22.7%, and 0.51 in protein ranging from 6.1 to 8.3%. And also, weed type was 0.67 in amylose ranging from 6.6 to 9.7%, and 0.33 in protein ranging from 7.0 to 7.9%, whereas, in breeding line it was 0.47 in amylose ranging from 10.0 to 12.0%, and 0.26 in protein ranging from 7.0 to 7.9%. These results could be helpful to build database programming system for germplasm management.

Development of Plant BIM Library according to Object Geometry and Attribute Information Guidelines (객체 형상 및 속성정보 지침에 따른 수목 BIM 라이브러리 개발)

  • Kim, Bok-Young
    • Journal of the Korean Institute of Landscape Architecture
    • /
    • v.52 no.2
    • /
    • pp.51-63
    • /
    • 2024
  • While the government policy to fully adopt BIM in the construction sector is being implemented, the construction and utilization of landscape BIM models are facing challenges due to problems such as limitations in BIM authoring tools, difficulties in modeling natural materials, and a shortage in BIM content including libraries. In particular, plants, fundamental design elements in the field of landscape architecture, must be included in BIM models, yet they are often omitted during the modeling process, or necessary information is not included, which further compromises the quality of the BIM data. This study aimed to contribute to the construction and utilization of landscape BIM models by developing a plant library that complies with BIM standards and is applicable to the landscape industry. The plant library of trees and shrubs was developed in Revit by modeling 3D shapes and collecting attribute items. The geometric information is simplified to express the unique characteristics of each plant species at LOD200, LOD300, and LOD350 levels. The attribute information includes properties on plant species identification, such as species name, specifications, and quantity estimation, as well as ecological attributes and environmental performance information, totaling 24 items. The names of the files were given so that the hierarchy of an object in the landscape field could be revealed and the object name could classify the plant itself. Its usability was examined by building a landscape BIM model of an apartment complex. The result showed that the plant library facilitated the construction process of the landscape BIM model. It was also confirmed that the library was properly operated in the basic utilization of the BIM model, such as 2D documentation, quantity takeoff, and design review. However, the library lacked ground cover, and had limitations in those variables such as the environmental performance of plants because various databases for some materials have not yet been established. Further efforts are needed to develop BIM modeling tools, techniques, and various databases for natural materials. Moreover, entities and systems responsible for creating, managing, distributing, and disseminating BIM libraries must be established.

Manufacturing process and food safety analysis of sous-vide production for small and medium sized manufacturing companies: Focusing on the Korean HMR market (중소규모 생산업체의 수비드 제품 생산을 위한 공정 및 안전성 분석: 한국 HMR 시장 중심으로)

  • Choi, Eugene;Shin, Weon Sun
    • Korean Journal of Food Science and Technology
    • /
    • v.52 no.1
    • /
    • pp.1-10
    • /
    • 2020
  • The present study identified the restrictions on the use of sous-vide products in the Korean HMR market for small and medium-sized manufacturing companies. A detailed literature review revealed that the HMR market in Korea is close to saturation. Notably, the technologically advanced products produced using sous-vide seem to display significant potential to overcome market saturation. The sous-vide method differs from conventional cooking techniques and is characterized by maintenance of food texture along with flavor enhancement. However, due to the unfamiliarity of the manufacturers with this method and the unclear food safety regulations, mass food manufacturing companies do not agree on using this method; hence, sous-vide production is usually undertaken by small/medium sized companies catering primarily through online marketing portals. This study highlights the various restrictions to the implementation of sous-vide production, and discusses several practical implications of sous-vide production that would help users of this technique enter the HMR market.

A Study on Recent Research Trend in New Product Development Using Keyword Network Analysis (키워드 네트워크 분석을 이용한 NPD 연구의 진화 및 연구동향)

  • Pyun, JeBum;Jeong, EuiBeom
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.23 no.5
    • /
    • pp.119-134
    • /
    • 2018
  • Today, many firms face the environment of high uncertainty and severe competition due to the rapid technology development and the diverse needs of customers. In the business environment, one of the most important ways to gain sustainable competitive advantage and future growth engine is related to NPD (New Product Development), which is a very important issue for practice and academia. Thus, this study intends to provide new values to practitioners and researchers related to NPD by analyzing current research trends and future trends in NPD field. For this, we bibliometrically analyzed keyword networks which consist of keywords that were already published in the eminent journals from Scopus database to generate insights that have not been captured in the previous reviews on the topic. As a result, we could understand the extant research streams in NPD field, and suggest the changes of specific research topics based on the connected relationships among keywords over the time. In addition, we also foresaw the general future research trends in NPD field based on the keywords according to preferential attachment processes. Through this study, it was confirmed that NPD keyword network is a small world network that follows the distribution of power law and the growth of network is formed by link formation by keyword preferential attachment. In addition, through component analysis and centrality analysis, keywords such as Innovation, New product innovation, Risk management, Concurrent engineering, Research and development, and Product life cycle management are highly centralized in NPD keyword network. On the other hand, as a result of examining the change of preferential attachment of keywords over the time, we suggested the required new research direction including i) NPD collaboration with suppliers, ii) NPD considering market uncertainty, iii) NPD considering convergence with the other academic areas like technology management and knowledge management, iv) NPD from SME(Small and medium enterprises) perspective. The results of this study can be used to determine the research trends of NPD and the new research themes for interdisciplinary studies with other disciplines.

Development of Water Footprint Inventory Using Input-Output Analysis (산업연관분석을 활용한 물발자국 인벤토리 개발)

  • Kim, Young Deuk;Lee, Sang Hyun;Ono, Yuya;Lee, Sung Hee
    • Journal of Korea Water Resources Association
    • /
    • v.46 no.4
    • /
    • pp.401-412
    • /
    • 2013
  • Water footprint of a product and service is the volume of freshwater used to produce the product, measured in the life cycle or over the full supply chain. Since water footprint assessment helps us to understand how human activities and products relate to water scarcity and pollution, it can contribute to seek a sustainable way of water use in the consumption perspective. For the introduction of WFP scheme, it is indispensable to construct water inventory/accounting for the assessment, but there is no database in Korea to cover all industry sectors. Therefore, the aim of the study is to develop water footprint inventory within a nation at 403 industrial sectors using Input-Output Analysis. Water uses in the agricultural sector account for 79% of total water, and industrial sector have higher indirect water at most sectors, which is accounting for 82%. Most of the crop water is consumptive and direct water except rice. The greatest water use in the agricultural sectors is in rice paddy followed by aquaculture and fruit production, but the greatest water use intensity was not in the rice. The greatest water use intensity was 103,263 $m^3$/million KRW for other inedible crop production, which was attributed to the low economic value of the product with great water consumption in the cultivation. The next was timber tract followed by iron ores, raw timber, aquaculture, water supply and miscellaneous cereals like corn and other edible crops in terms of total water use intensity. In holistic view, water management considering indirect water in the industrial sector, i.e. supply chain management in the whole life cycle, is important to increase water use efficiency, since more than 56% of total water was indirect water by humanity. It is expected that the water use intensity data can be used for a water inventory to estimate water footprint of a product for the introduction of water footprint scheme in Korea.

Current status and future of insect smart factory farm using ICT technology (ICT기술을 활용한 곤충스마트팩토리팜의 현황과 미래)

  • Seok, Young-Seek
    • Food Science and Industry
    • /
    • v.55 no.2
    • /
    • pp.188-202
    • /
    • 2022
  • In the insect industry, as the scope of application of insects is expanded from pet insects and natural enemies to feed, edible and medicinal insects, the demand for quality control of insect raw materials is increasing, and interest in securing the safety of insect products is increasing. In the process of expanding the industrial scale, controlling the temperature and humidity and air quality in the insect breeding room and preventing the spread of pathogens and other pollutants are important success factors. It requires a controlled environment under the operating system. European commercial insect breeding facilities have attracted considerable investor interest, and insect companies are building large-scale production facilities, which became possible after the EU approved the use of insect protein as feedstock for fish farming in July 2017. Other fields, such as food and medicine, have also accelerated the application of cutting-edge technology. In the future, the global insect industry will purchase eggs or small larvae from suppliers and a system that focuses on the larval fattening, i.e., production raw material, until the insects mature, and a system that handles the entire production process from egg laying, harvesting, and initial pre-treatment of larvae., increasingly subdivided into large-scale production systems that cover all stages of insect larvae production and further processing steps such as milling, fat removal and protein or fat fractionation. In Korea, research and development of insect smart factory farms using artificial intelligence and ICT is accelerating, so insects can be used as carbon-free materials in secondary industries such as natural plastics or natural molding materials as well as existing feed and food. A Korean-style customized breeding system for shortening the breeding period or enhancing functionality is expected to be developed soon.