• Title/Summary/Keyword: database management system

Search Result 2,456, Processing Time 0.033 seconds

Development of Operating S/W and DBMS for Deep-sea Manganese Nodule Miner (심해저 망간단괴 집광기의 운영 소프트웨어 및 데이터베이스 관리시스템 개발)

  • Park, Soung-Jae;Yeu, Tae-Kyeong;Yoon, Suk-Min;Hong, Sup;Kim, Hyung-Woo;Choi, Jong-Su;Kim, Sang-Bong
    • The Sea:JOURNAL OF THE KOREAN SOCIETY OF OCEANOGRAPHY
    • /
    • v.13 no.3
    • /
    • pp.229-236
    • /
    • 2008
  • The deep-sea miner is the tracked vehicle system which drives on the deep-seabed and gathers a manganese nodules. The miner is operated by remote control in real-time by the station of surface vessel. So operating S/W is a important part of miner remote operating. At present, the test miner has been designed and manufactured for near-shore sea-test. The test miner consists of mechanical parts, and electric-electronic parts. Because those parts should be controled and monitored remotely, operating S/W for control and monitoring is necessary by all means. In this paper, real-time operating S/W for a control and monitoring of the test miner was designed and developed using PXI, embedded controller and LabVIEW. This real-time operating S/W was developed for an efficient test of test miner in a near seabed area. Moreover, database management system(DBMS) was developed too for the data management of test miner monitoring using MS SQL and LabVIEW.

XML View Indexing Using an RDBMS based XML Storage System (관계 DBMS 기반 XML 저장시스템 상에서의 XML 뷰 인덱싱)

  • Park Dae-Sung;Kim Young-Sung;Kang Hyunchul
    • Journal of Internet Computing and Services
    • /
    • v.6 no.4
    • /
    • pp.59-73
    • /
    • 2005
  • Caching query results and reusing them in processing of subsequent queries is an important query optimization technique. Materialized view and view indexing are the representative examples of such a technique. The two schemes had received much attention for relational databases, and have been investigated for XML data since XML emerged as the standard for data exchange on the Web. In XML view indexing, XML view xv which is the result of an XML query is represented as an XML view index(XVI), a structure containing the identifiers of xv's underlying XML elements as well as the information on xv. Since XVI for xv stores just the identifiers of the XML elements not the elements themselves, when xv is requested, its XVI should be materialized against xv's underlying XML documents. In this paper, we address the problem of integrating an XML view index management system with an RDBMS based XML storage system. The proposed system was implemented in Java on Windows 2000 Server with each of two different commercial RDBMSs, and used in evaluating performance improvement through XML view indexing as well as its overheads. The experimental results revealed that XML view indexing was very effective with an RDBMS based XML storage system while its overhead was negligible.

  • PDF

Real-Time Monitoring and Buffering Strategy of Moving Object Databases on Cluster-based Distributed Computing Architecture (클러스터 기반 분산 컴퓨팅 구조에서의 이동 객체 데이타베이스의 실시간 모니터링과 버퍼링 기법)

  • Kim, Sang-Woo;Jeon, Se-Gil;Park, Seung-Yong;Lee, Chung-Woo;Hwang, Jae-Il;Nah, Yun-Mook
    • Journal of Korea Spatial Information System Society
    • /
    • v.8 no.2 s.17
    • /
    • pp.75-89
    • /
    • 2006
  • LBS (Location-Based Service) systems have become a serious subject for research and development since recent rapid advances in wireless communication technologies and position measurement technologies such as global positioning system. The architecture named the GALIS (Gracefully Aging Location Information System) has been suggested which is a cluster-based distributed computing system architecture to overcome performance losses and to efficiently handle a large volume of data, at least millions. The GALIS consists of SLDS and LLDS. The SLDS manages current location information of moving objects and the LLDS manages past location information of moving objects. In this thesis, we implement a monitoring technique for the GALIS prototype, to allow dynamic load balancing among multiple computing nodes by keeping track of the load of each node in real-time during the location data management and spatio-temporal query processing. We also propose a buffering technique which efficiently manages the query results having overlapped query regions to improve query processing performance of the GALIS. The proposed scheme reduces query processing time by eliminating unnecessary query execution on the overlapped regions with the previous queries.

  • PDF

Seed Production and Distribution System Improvement of Medicinal Crop Seeds (약용작물 종자 생산 및 보급체계 개선)

  • Jang, Woo Whan;Park, Jae Sang;Rubenecia, Maria. Rosnah Ultra.;Park, Chung Beom;Ahn, Young Sup;Lee, Sang Chul
    • Current Research on Agriculture and Life Sciences
    • /
    • v.31 no.4
    • /
    • pp.286-294
    • /
    • 2013
  • Increasing concern for the health, well-being, and income of the people has expectedly brought continuous increase in the industrial value of medicinal plants in recent years as these are also used in foods and cosmetics. However, Korea's increased import of these products from China due to the FTA contract causes negative effects on its industrial value. In this regard, various measures for medicinal crop seed development and production, organization and expansion of circulation and forest land use deregulation are needed to promote the agricultural food industry including medicinal plants. As a measure, first, a database of medicinal plants should be built that can help to promote the national medicinal industry and the seed management system. Second, agricultural productivity should be enhanced via the development and supply of varieties of high quality medicinal plants. Third, there should be a good practice of the system maintenance for the production and supply of medicinal crop seeds. Fourth, production and distribution system of medicinal plants should be established by standardization of high quality seeds. Nowadays, the consumption pattern of medicinal crops is changing from direct ingestion to cosmetics, drugs, and food and this is expected to increase continuously. Consequently, the increased production of medicinal crops will support the development policy and the institutional improvement in response to this trend of the positive change of industrialization.

Design and Implementation of Thesaurus System for Geological Terms (지질용어 시소러스 시스템의 설계 및 구축)

  • Hwang, Jaehong;Chi, KwangHoon;Han, JongGyu;Yeon, Young Kwang;Ryu, Keun Ho
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.10 no.2
    • /
    • pp.23-35
    • /
    • 2007
  • With the development of semantic web technologies in information retrieval area, the necessity for thesaurus is recently increasing along with internet lexicons. A thesaurus is the combination of classification and a lexicon, and is the topic map of knowledge structure expressing relations among concepts(terms) subject to human knowledge activities such as learning and research using formally organized and controlled index terms for clarifying the context of superordinate and subordinate concepts. However, although thesaurus are regarded as essential tools for controlling and standardizing terms and searching and processing information efficiently, we do not have a Korean thesaurus for geology. To build a thesaurus, we need standardized and well-defined guidelines. The standardized guidelines enable efficient information management and help information users use correct information easily and conveniently. The present study purposed to build a thesaurus system with terms used in geology. For this, First, we surveyed related works for standardizing geological terms in Korea and other countries. Second, we defined geological topics in 15 areas and prepared a classification system(draft) for each topic. Third, based on the geological thesaurus classification system, we created the specification of geological thesaurus. Lastly, we designed and implemented an internet-based geological thesaurus system using the specification.

  • PDF

Classification of submitted nuclear medicine dissertation and directional consideration (핵의학 투고 논문 분류 및 방향성 고찰)

  • Ho-Yeon, Cho;Yeong-Ran, Woo;Kang-Rok, Seo;Gun-Chul, Hong
    • The Korean Journal of Nuclear Medicine Technology
    • /
    • v.26 no.2
    • /
    • pp.37-42
    • /
    • 2022
  • Purpose Since 1985, the Korean society of nuclear medicine technology (KSNMT) has been engaged in academic activities related to nuclear medicine imaging. From 2017 to 2021, the papers published in the journal were classified by the specific fields to examine the trends in the research and the direction of nuclear medicine in comparison with the papers submitted to the Korean Society of Nuclear Medicine (KSNM) during the same period. Materials and Methods From 2017 to 2021, papers submitted to KSNMT and KSNM were classified and databaseization using the Excel program by submission type, examination equipment, and examination field. Through this data, the number of papers published in journals by year, the number of papers submitted by detailed fields, and key words by era were analyzed and compared. Results The papers included by journal was 57 KSNMT and 280 KSNM. The major large classification of equipment, PET, Planar and SPECT was 26.3%, 21.1%, 19.3% in the KSNMT, KSNM was 49.6%, 6.4%, and 9.3%, with 66.7% and 65.3%, respectively. the major medium classification of equipment, industrial safety, urogenital system, nervous system, and quality control accounted for 54.4% of the total papers of the total ratio in the KSNMT, while the medium classification of oncology, endocrine system, urogenital system, therapy, and nervous system accounted for 61.1% of KSNM. In the major small classification of image acquisition, improvement effect, and exposure management accounted for 70.2% in KSNMT, while the items of image acquisition, report, and improvement effect accounted for 60.7% in KSNM. The major keywords except for equipment-related keywords such as PET/CT, PET/MR, and SPECT were SUV, Planar Image, and Respiration Gating Method in KSNMT and Ga68, Thyroid, and Lymphoma in the KSNM. Conclusion When checking the last 5 years of submissions, we can see that KSNMT is mainly concerned with image acquisition using existing radiotracers, while KSNM has focused on new radiotracers such as 68Ga, 177Lu, etc., and new medical technologies of theranostic. It has been confirmed that more PET-related papers than other examination equipment will account for a greater number of papers, and it is believed that future submissions will also account for a higher proportion of PET-related papers than other equipment.

System Development for Measuring Group Engagement in the Art Center (공연장에서 다중 몰입도 측정을 위한 시스템 개발)

  • Ryu, Joon Mo;Choi, Il Young;Choi, Lee Kwon;Kim, Jae Kyeong
    • Journal of Intelligence and Information Systems
    • /
    • v.20 no.3
    • /
    • pp.45-58
    • /
    • 2014
  • The Korean Culture Contents spread out to Worldwide, because the Korean wave is sweeping in the world. The contents stand in the middle of the Korean wave that we are used it. Each country is ongoing to keep their Culture industry improve the national brand and High added value. Performing contents is important factor of arousal in the enterprise industry. To improve high arousal confidence of product and positive attitude by populace is one of important factor by advertiser. Culture contents is the same situation. If culture contents have trusted by everyone, they will give information their around to spread word-of-mouth. So, many researcher study to measure for person's arousal analysis by statistical survey, physiological response, body movement and facial expression. First, Statistical survey has a problem that it is not possible to measure each person's arousal real time and we cannot get good survey result after they watched contents. Second, physiological response should be checked with surround because experimenter sets sensors up their chair or space by each of them. Additionally it is difficult to handle provided amount of information with real time from their sensor. Third, body movement is easy to get their movement from camera but it difficult to set up experimental condition, to measure their body language and to get the meaning. Lastly, many researcher study facial expression. They measures facial expression, eye tracking and face posed. Most of previous studies about arousal and interest are mostly limited to reaction of just one person and they have problems with application multi audiences. They have a particular method, for example they need room light surround, but set limits only one person and special environment condition in the laboratory. Also, we need to measure arousal in the contents, but is difficult to define also it is not easy to collect reaction by audiences immediately. Many audience in the theater watch performance. We suggest the system to measure multi-audience's reaction with real-time during performance. We use difference image analysis method for multi-audience but it weaks a dark field. To overcome dark environment during recoding IR camera can get the photo from dark area. In addition we present Multi-Audience Engagement Index (MAEI) to calculate algorithm which sources from sound, audience' movement and eye tracking value. Algorithm calculates audience arousal from the mobile survey, sound value, audience' reaction and audience eye's tracking. It improves accuracy of Multi-Audience Engagement Index, we compare Multi-Audience Engagement Index with mobile survey. And then it send the result to reporting system and proposal an interested persons. Mobile surveys are easy, fast, and visitors' discomfort can be minimized. Also additional information can be provided mobile advantage. Mobile application to communicate with the database, real-time information on visitors' attitudes focused on the content stored. Database can provide different survey every time based on provided information. The example shown in the survey are as follows: Impressive scene, Satisfied, Touched, Interested, Didn't pay attention and so on. The suggested system is combine as 3 parts. The system consist of three parts, External Device, Server and Internal Device. External Device can record multi-Audience in the dark field with IR camera and sound signal. Also we use survey with mobile application and send the data to ERD Server DB. The Server part's contain contents' data, such as each scene's weights value, group audience weights index, camera control program, algorithm and calculate Multi-Audience Engagement Index. Internal Device presents Multi-Audience Engagement Index with Web UI, print and display field monitor. Our system is test-operated by the Mogencelab in the DMC display exhibition hall which is located in the Sangam Dong, Mapo Gu, Seoul. We have still gotten from visitor daily. If we find this system audience arousal factor with this will be very useful to create contents.

Case Analysis of the Promotion Methodologies in the Smart Exhibition Environment (스마트 전시 환경에서 프로모션 적용 사례 및 분석)

  • Moon, Hyun Sil;Kim, Nam Hee;Kim, Jae Kyeong
    • Journal of Intelligence and Information Systems
    • /
    • v.18 no.3
    • /
    • pp.171-183
    • /
    • 2012
  • In the development of technologies, the exhibition industry has received much attention from governments and companies as an important way of marketing activities. Also, the exhibitors have considered the exhibition as new channels of marketing activities. However, the growing size of exhibitions for net square feet and the number of visitors naturally creates the competitive environment for them. Therefore, to make use of the effective marketing tools in these environments, they have planned and implemented many promotion technics. Especially, through smart environment which makes them provide real-time information for visitors, they can implement various kinds of promotion. However, promotions ignoring visitors' various needs and preferences can lose the original purposes and functions of them. That is, as indiscriminate promotions make visitors feel like spam, they can't achieve their purposes. Therefore, they need an approach using STP strategy which segments visitors through right evidences (Segmentation), selects the target visitors (Targeting), and give proper services to them (Positioning). For using STP Strategy in the smart exhibition environment, we consider these characteristics of it. First, an exhibition is defined as market events of a specific duration, which are held at intervals. According to this, exhibitors who plan some promotions should different events and promotions in each exhibition. Therefore, when they adopt traditional STP strategies, a system can provide services using insufficient information and of existing visitors, and should guarantee the performance of it. Second, to segment automatically, cluster analysis which is generally used as data mining technology can be adopted. In the smart exhibition environment, information of visitors can be acquired in real-time. At the same time, services using this information should be also provided in real-time. However, many clustering algorithms have scalability problem which they hardly work on a large database and require for domain knowledge to determine input parameters. Therefore, through selecting a suitable methodology and fitting, it should provide real-time services. Finally, it is needed to make use of data in the smart exhibition environment. As there are useful data such as booth visit records and participation records for events, the STP strategy for the smart exhibition is based on not only demographical segmentation but also behavioral segmentation. Therefore, in this study, we analyze a case of the promotion methodology which exhibitors can provide a differentiated service to segmented visitors in the smart exhibition environment. First, considering characteristics of the smart exhibition environment, we draw evidences of segmentation and fit the clustering methodology for providing real-time services. There are many studies for classify visitors, but we adopt a segmentation methodology based on visitors' behavioral traits. Through the direct observation, Veron and Levasseur classify visitors into four groups to liken visitors' traits to animals (Butterfly, fish, grasshopper, and ant). Especially, because variables of their classification like the number of visits and the average time of a visit can estimate in the smart exhibition environment, it can provide theoretical and practical background for our system. Next, we construct a pilot system which automatically selects suitable visitors along the objectives of promotions and instantly provide promotion messages to them. That is, based on the segmentation of our methodology, our system automatically selects suitable visitors along the characteristics of promotions. We adopt this system to real exhibition environment, and analyze data from results of adaptation. As a result, as we classify visitors into four types through their behavioral pattern in the exhibition, we provide some insights for researchers who build the smart exhibition environment and can gain promotion strategies fitting each cluster. First, visitors of ANT type show high response rate for promotion messages except experience promotion. So they are fascinated by actual profits in exhibition area, and dislike promotions requiring a long time. Contrastively, visitors of GRASSHOPPER type show high response rate only for experience promotion. Second, visitors of FISH type appear favors to coupon and contents promotions. That is, although they don't look in detail, they prefer to obtain further information such as brochure. Especially, exhibitors that want to give much information for limited time should give attention to visitors of this type. Consequently, these promotion strategies are expected to give exhibitors some insights when they plan and organize their activities, and grow the performance of them.

Development of Composite Sensing Technology Using Internet of Things (IoT) for LID Facility Management (LID 시설 관리를 위한 사물인터넷(IoT) 활용 복합 센싱 적용기술 개발)

  • Lee, Seungjae;Jeon, Minsu;Lee, Jungmin;Kim, Lee-Hyung
    • Journal of Wetlands Research
    • /
    • v.22 no.4
    • /
    • pp.312-320
    • /
    • 2020
  • Various LIDs with natural water circulation function are applied to reduce urban environmental problems and environmental impact of development projects. However, excessive Infiltration and evaporation of LID facilities dry the LID internal soil, thus reducing plant and microbial activity and reducing environmental re duction ability. The purpose of this study was to develop a real-time measurement system with complex sensors to derive the management plan of LID facilities. The test of measurable sensors and Internet of Things (IoT) application was conducted in artificial wetlands shaped in acrylic boxes. The applied sensors were intended to be built at a low cost considering the distributed LID and were based on Arduino and Raspberry Pi, which are relatively inexpensive and commercialized. In addition, the goal was to develop complex sensor measurements to analyze the current state o f LID facilities and the effects of maintenance and abnormal weather conditions. Sensors are required to measure wind direction, wind speed, rainfall, carbon dioxide, Micro-dust, temperature and humidity, acidity, and location information in real time. Data collection devices, storage server programs, and operation programs for PC and mobile devices were developed to collect, transmit and check the results of measured data from applied sensors. The measurements obtained through each sensor are passed through the Wifi module to the management server and stored on the database server in real time. Analysis of the four-month measurement result values conducted in this study confirmed the stability and applicability of ICT technology application to LID facilities. Real-time measured values are found to be able to utilize big data to evaluate the functions of LID facilities and derive maintenance measures.

Improvement of the Calculation Standard for Prolongation cost of Domestic Public Construction Project (국내 공공 공사 공기연장 간접비 산정 기준 개선방안 - 국가계약법 및 지방계약법 산정기준의 비교 고찰 -)

  • Jeong, Kichang;Lee, Jaeseob
    • Korean Journal of Construction Engineering and Management
    • /
    • v.17 no.4
    • /
    • pp.95-102
    • /
    • 2016
  • Recently, a research regarding calculation of construction time extension-oriented incidental costs has been intensively suggested in quantitative aspect and recent studies on system improvement has been made continuously. In the case of Domestic Public Construction Works, State Contract Act is applied when the client is government whereas Local Government Contract Act is done when the client is local government, but more meticulous study is required because improvement plan is not proposed even there is a clear demand for improvement of these problems on calculation standard. Thus this study suggested appropriate standard by comparing each the calculation standards followed by 'State Contract Act' and 'Local Government Contract Act', considering the problems accorded, and analyzing field cases. Calculation method of other expenses was differently regulated as the revision of each regulation, and this demonstrates that there is a difference of actual cost from 12.37% to 24.95%. It is shown that less cost of construction time were calculated than actual cost according to a problem of calculation method by State Contract Act as the rate at the time of contract to be applied in other expense rate. This study suggested the rate against incidental cost and the rate of other expense per day against total construction cost as an appropriate rate calculation for other expense based on field database.