• Title/Summary/Keyword: Relational database.

Search Result 576, Processing Time 0.024 seconds

RDBMS Based Efficient Method for Shortest Path Searching Over Large Graphs Using K-degree Index Table (대용량 그래프에서 k-차수 인덱스 테이블을 이용한 RDBMS 기반의 효율적인 최단 경로 탐색 기법)

  • Hong, Jihye;Han, Yongkoo;Lee, Young-Koo
    • KIPS Transactions on Software and Data Engineering
    • /
    • v.3 no.5
    • /
    • pp.179-186
    • /
    • 2014
  • Current networks such as social network, web page link, traffic network are big data which have the large numbers of nodes and edges. Many applications such as social network services and navigation systems use these networks. Since big networks are not fit into the memory, existing in-memory based analysis techniques cannot provide high performance. Frontier-Expansion-Merge (FEM) framework for graph search operations using three corresponding operators in the relational database (RDB) context. FEM exploits an index table that stores pre-computed partial paths for efficient shortest path discovery. However, the index table of FEM has low hit ratio because the indices are determined by distances of indices rather than the possibility of containing a shortest path. In this paper, we propose an method that construct index table using high degree nodes having high hit ratio for efficient shortest path discovery. We experimentally verify that our index technique can support shortest path discovery efficiently in real-world datasets.

The traffic performance evaluation between remote server and mobile for applying to encryption protocol in the Wellness environment (웰니스 환경에서 암호화 프로토콜 적용을 위한 모바일과 원격 서버간 트래픽 성능 평가)

  • Lee, Jae-Pil;Kim, Young-Hyuk;Lee, Jae-Kwang
    • Journal of Digital Convergence
    • /
    • v.11 no.11
    • /
    • pp.415-420
    • /
    • 2013
  • U-WHS refers to a means of remote health monitoring service to combine fitness with wellbing. U-WHS is a system which can measure and manage biometric information of patients without any limitation on time and space. In this paper, we performed in order to look into the influence that the encryption module influences on the communication evaluation in the biometric information transmission gone to the smart mobile device and Hospital Information System.In the case of the U-WHS model, the client used the Objective-c programming language for software development of iOS Xcode environment and SEED and HIGHT encryption module was applied. In the case of HIS, the MySQL which is the Websocket API of the HTML5 and relational database management system for the client and inter-server communication was applied. Therefore, in WIFI communication environment, by using wireshark, data transfer rate of the biometric information, delay and loss rate was checked for the evaluation.

Development of Collecting and Managing System for Terminologies of Korean Oriental Medicine (한의학 용어 수집 및 관리 시스템 구축)

  • Cha, Seung-Jun;Kim, Sang-Kyun;Song, Mi-Young;Choi, Yun-Jeong;Eom, Dong-Myung;Lee, Byung-Wook;Lee, Kyu-Chul
    • Journal of Society of Preventive Korean Medicine
    • /
    • v.14 no.1
    • /
    • pp.59-76
    • /
    • 2010
  • Background : The system for collecting and managing the terminologies of Korean oriental medicine is essential to facilitate researches of developing intelligent information architecture based on ontology. Objectives : The purpose of this paper is to develop system for collecting and managing system for terminologies of Korean oriental medicine. Methods : First we defined roles of users used in this system, and define the system workflow based on them. Then we developed web-based collecting and managing system in which multiuser can work simultaneously, and it is compose of relational database system. Results : The terminologies of Korean Oriental Medicine can be efficiently collected, purified, inspected, and utilized by using proposed system. Conclusions : The system, proposed in this paper, can be used the whole field of oriental medicines for basic technology and has great contributions to make intelligent information architecture of oriental medicine based on ontology concept.

A Storage and Retrieval System for Structured SGML Documents using Grove (Grove를 이용한 구조적 SGML문서의 저장 및 검색)

  • Kim, Hak-Gyoon;Cho, Sung-Bae
    • Journal of KIISE:Computing Practices and Letters
    • /
    • v.8 no.5
    • /
    • pp.501-509
    • /
    • 2002
  • SGML(ISO 8879) has been proliferated to support various document styles and to transfer documents into different platforms. SGML documents have logical structure information in addition to contents. As SGML documents are widely used, there is an increasing need for database storage and retrieval system using the logical structure of documents. However. traditional search engines using document indexes cannot exploit the logical structure. In this Paper, we have developed an SGML document storage system, which is DTD-independent and store the document type and the document instance separately by using Grove which is the document model for DSSSL and HyTime. We have used the Object Store, an object-oriented DBMS, to store the structure information appropriately without any loss of structural information. Also, we have supported a index structure for search efficiency like the relational DBMS, and constructed an effective user interface which combines content-based search with structure-based search.

A Study of Dynamic Web Ontology for Comparison-shopping Agent based on Semantic Web (시멘틱 웹 기반의 비교구매 에이전트를 위한 동적 웹 온톨로지에 대한 연구)

  • Kim, Su-Kyoung;Ahn, Ki-Hong
    • Journal of Intelligence and Information Systems
    • /
    • v.11 no.2
    • /
    • pp.31-45
    • /
    • 2005
  • In this paper, convert in RDF triple and a RDF document through RDF document converters and design metadata schema about a digital camcorder after use Wrapper technology, and acquiring commodity information of a HTML page about the digital camcorder which these papers are defined so as to be different by electronic commerce stores, and is expressed. Save in digital camcorder domain ontology storage that implemented to relational database to DCC knowledge base ontology as convert to OWL Web ontology based on designed metadata schema. Through compare with rdf and DCCKBO, mapping, and inference process, provide to buyers by DCC information of the store that had the commodity purchasing information which is the best, and proposed a dynamic Web ontology guessed to contents of the best commodity purchasing information, and to define domain ontology saved in DCCKBO.

  • PDF

The Effects of Customer Relationship Management on the Management Performance of Senior Club Market-type Senior Jobs in Internet Environment (사물인터넷 환경에서 시니어클럽 시장형 노인일자리사업의 고객관계관리(CRM)가 경영성과에 미치는 영향)

  • Lee, Jin-Yoel;Youn, Ki-Hyok
    • Journal of Internet of Things and Convergence
    • /
    • v.7 no.3
    • /
    • pp.39-46
    • /
    • 2021
  • This study aims to empirically analyze the effect of CRM on the management performance of senior club market type senior job business. The purpose of this study was to provide basic data for the economic income creation of senior club market type senior job project. The results of this study are as follows: First, as a result of verifying the difference in management performance according to sociodemographic characteristics, there was a difference in age, academic background, and monthly average income. Second, the contact service and communication of senior club market type senior job business had a positive effect on the management performance. Based on the results of this study, the following suggestions are made. First, the database(DB) should be constructed reflecting the personal characteristics of consumers and the big data and artificial intelligence analysis should be utilized. Second, education using Internet environment such as YouTube and ZOOM should be strengthened and communication management should be strengthened based on information collected through customer monitoring.

GIS/GPS based Precision Agriculture Model in India -A Case study

  • Mudda, Suresh Kumar
    • Agribusiness and Information Management
    • /
    • v.10 no.2
    • /
    • pp.1-7
    • /
    • 2018
  • In the present day context of changing information needs of the farmers and diversified production systems there is an urgent need to look for the effective extension support system for the small and marginal farmers in the developing countries like India. The rapid developments in the collection and analysis of field data by using the spatial technologies like GPS&GIS were made available for the extension functionaries and clientele for the diversified information needs. This article describes the GIS and GPS based decision support system in precision agriculture for the resource poor farmers. Precision farming techniques are employed to increase yield, reduce production costs, and minimize negative impacts to the environment. The parameters those can affect the crop yields, anomalous factors and variations in management practices can be evaluated through this GPS and GIS based applications. The spatial visualisation capabilities of GIS technology interfaced with a relational database provide an effective method for analysing and displaying the impacts of Extension education and outreach projects for small and marginal farmers in precision agriculture. This approach mainly benefits from the emergence and convergence of several technologies, including the Global Positioning System (GPS), geographic information system (GIS), miniaturised computer components, automatic control, in-field and remote sensing, mobile computing, advanced information processing, and telecommunications. The PPP convergence of person (farmer), project (the operational field) and pixel (the digital images related to the field and the crop grown in the field) will better be addressed by this decision support model. So the convergence and emergence of such information will further pave the way for categorisation and grouping of the production systems for the better extension delivery. In a big country like India where the farmers and holdings are many in number and diversified categorically such grouping is inevitable and also economical. With this premise an attempt has been made to develop a precision farming model suitable for the developing countries like India.

The Modeling of Management Data and Drones Recommendation for Military Operation Support Mission (군 작전지원 임무 수행을 위한 드론 추천 및 관리 데이터 모델링)

  • Park, Keun-Seog;cheon, Sang-pil;Eom, Jung-ho
    • Convergence Security Journal
    • /
    • v.18 no.3
    • /
    • pp.133-140
    • /
    • 2018
  • As the core technology of the 4th Industrial Revolution is applied to drone, the potential for growth in the field of unmanned aerial vehicles is very large, and the utilization of civilian & military fields in the domestic & foreign is increasing rapidly. Because application areas of drone in the civilian field is various, it is excellent in terms of cost effectiveness and high value in utilization when it is used for military operation support mission. Especially, in the case of the Air Force, it is expected that military usage effectiveness will be high if drone replaces various air operations support missions such as aircraft inspection, supply of military supplies, base security. We find out the missions that can utilize drones for military operations support and propose the recommendation and data management plan accordingly. We recommend the most suitable drones and equipment that perform similar missions in the private sector and propose the data modeling of relational database.

  • PDF

Design of The RESTful Heterogeneous Data Service Architecture for Korean e-Navigation Operation System (e-Navigation 운영시스템을 위한 RESTful 이종 데이터 서비스 시스템 아키텍처 설계)

  • Jang, Wonseok;Lee, Woojin
    • The Journal of Korea Institute of Information, Electronics, and Communication Technology
    • /
    • v.12 no.1
    • /
    • pp.49-57
    • /
    • 2019
  • The International Maritime Organization is developing a maritime safety system called eNavigation in order to effectively respond to accidents occurring on board vessels. Korea is actively participating in the development of eNavigation and is developing Korean eNavigation by adding its own concept to eNavigation of the IMO. eNavigation is designed to provide various functions for marine safety. The data required for each function is various such as spatial data, relational data, file, weather grid. Therefore, there is a need for a system that can appropriately provide heterogeneous data suitable for eNavigation to each eNavigation's service system. In this paper, we analyzed the kinds of data needed for e-Navigation and designed the architecture of heterogeneous data service system that could provide these data properly.

Big Data Model for Analyzing Plant Growth Environment Informations and Biometric Informations (농작물 생육환경정보와 생체정보 분석을 위한 빅데이터 모델)

  • Lee, JongYeol;Moon, ChangBae;Kim, ByeongMan
    • Journal of Korea Society of Industrial Information Systems
    • /
    • v.25 no.6
    • /
    • pp.15-23
    • /
    • 2020
  • While research activities in the agricultural field for climate change are being actively carried out, smart agriculture using information and communication technology has become a new trend in line with the Fourth Industrial Revolution. Accordingly, research is being conducted to identify and respond to signs of abnormal growth in advance by monitoring the stress of crops in various outdoor environments and soil conditions. There are also attempts to analyze data collected in real time through various sensors using artificial intelligence techniques or big data technologies. In this paper, we propose a big data model that is effective in analyzing the growth environment informations and biometric information of crops by using the existing relational database for big data analysis. The performance of the model was measured by the response time to a query according to the amount of data. As a result, it was confirmed that there is a maximum time reduction effect of 23.8%.