• Title/Summary/Keyword: Database Management Systems

Search Result 1,027, Processing Time 0.031 seconds

A Study on The Conversion Factor between Heterogeneous DBMS for Cloud Migration

  • Joonyoung Ahn;Kijung Ryu;Changik Oh;Taekryong Han;Heewon Kim;Dongho Kim
    • KSII Transactions on Internet and Information Systems (TIIS)
    • /
    • v.18 no.8
    • /
    • pp.2450-2463
    • /
    • 2024
  • Many legacy information systems are currently being clouded. This is due to the advantage of being able to respond flexibly to the changes in user needs and system environment while reducing the initial investment cost of IT infrastructure such as servers and storage. The infrastructure of the information system migrated to the cloud is being integrated through the API connections, while being subdivided by using MSA (Micro Service Architecture) internally. DBMS (Database Management System) is also becoming larger after cloud migration. Scale calculation in most layers of the application architecture can be measured and calculated from auto-scaling perspective, but the method of hardware scale calculation for DBMS has not been established as standardized methodology. If there is an error in hardware scale calculation of DBMS, problems such as poor performance of the information system or excessive auto-scaling may occur. In addition, evaluating hardware size is more crucial because it also affects the financial cost of the migration. CPU is the factor that has the greatest influence on hardware scale calculation of DBMS. Therefore, this paper aims to calculate the conversion factor for CPU scale calculation that will facilitate the cloud migration between heterogeneous DBMS. In order to do that, we utilize the concept and definition of hardware capacity planning and scale calculation in the on-premise information system. The methods to calculate the conversion factor using TPC-H tests are proposed and verified. In the future, further research and testing should be conducted on the size of the segmented CPU and more heterogeneous DBMS to demonstrate the effectiveness of the proposed test model.

A Location Management Scheme using User Locality in Cellular Communciation Systems (셀룰러 통신 시스템에서 사용자 지역성을 고려한 위치 관리 기법)

  • Yang, Gwon-U;Gil, Jun-Min;Kim, Gi-Beom;Jeong, Sun-Yeong;Hwang, Jong-Seon
    • Journal of KIISE:Computer Systems and Theory
    • /
    • v.26 no.9
    • /
    • pp.1135-1144
    • /
    • 1999
  • 본 논문에서 우리는 셀룰러 통신 시스템을 위한 위치갱신과 위치질의 비용을 줄일 수 있는 새로운 위치관리 기법을 제안한다. 위치갱신 및 위치질의 비용을 줄이기 위하여, 제안한 위치관리 기법은 사용자 지역성을 사용한다. 사용자 지역성은 이동 지역성과 호 지역성으로 이루어진다. 이동 지역성을 갖는 이동단말들을 위한 위치갱신은 지역 PVLR(Proxy-Visitor Location Register) 갱신에 의해 위치갱신 비용을 줄일 수 있다. 호 지역성을 갖는 이동단말들을 위한 위치질의는 지역 PVLR 질의에 의해 위치질의 비용을 줄일 수 있다. 분석 모델을 통하여, 제안한 기법의 성능 분석과 IS-41 표준과 제안 기법과의 성능을 비교한다. 사용된 비교 척도는 네트워크 비용, 데이타베이스 비용 그리고 호 설정 지연이다. 이들 모든 척도들에 대해서, 제안 기법이 IS-41 표준에서 정의된 위치관리 기법보다 더 좋은 성능을 보인다. 또한 비교 결과는 CMR(Call-to-Mobility Ratio)에 상관없이 제안 기법이 IS-41 기법보다 성능이 좋음을 보여준다. Abstract In this paper, we propose a new location management scheme for cellular communication systems with the goal of reducing both location update and query cost. In order to reduce both location update and query cost, the proposed scheme uses user locality. User locality consists of movement and call locality. For mobile terminals with movement locality, location update cost is reduced by local PVLR(Proxy-Visitor Location Register) update. Location query cost is reduced by local PVLR query for mobile terminals with call locality. Through analytical models, we analyze the performance of the proposed scheme and compare it with that of the IS-41 scheme. The measures of comparison used are the network cost, the database cost, and the call set up delay. For all these measures, the proposed scheme performs better than the location management scheme defined in the IS-41 standard. Result comparison also shows that the our scheme performs better than the IS-41 scheme, regardless of CMR(Call-to-Mobility Ratio).

Design and Implementation of A Real Time Process Management System for Telecom Operations and Management (통신망 운용관리를 위한 실시간 프로세스 운용관리 시스템의 설계 및 분석)

  • Chang, Byeong-Yun;Park, Byung-Joo;Hwang, Seung-June
    • Journal of Intelligence and Information Systems
    • /
    • v.15 no.3
    • /
    • pp.103-118
    • /
    • 2009
  • To face with the fast and ever changing telecommunication environments, we need a real time process management system that can detect abnormal events in real time and warn the suspicious events to operations personnel. Additionally, a real time process management system can be adapted fast to various services that are developed by telecom companies. In this paper we develop a real time process management system to monitor and analyze telecom operations and management processes in real time. Toward this, we design application and database architectures of telecom operations and management processes based on Enhanced Telecom Operations Map (eTOM) that is business process framework in telecommunication operations and management field and recognized as an international standard in ITU-T M.3050. With these application and databasearchitectures we implement eight main functions for the real time process management system based on service oriented architecture. Therefore, new services can be applied to these functions fast. Also, the functions can detect abnormal event fast. Finally, since the functions are developed along with the international standard, the system has the flexibility for the development in various situations. Overall, this research can be a good guideline of developing a process management system regarding the telecom operations and management field or other fields that need to manage the processes in real time.

  • PDF

Development of automatic alert populating system of earth structures based on sensor monitoring (센서 모니터링을 활용한 토류구조물 상황전파 자동화 시스템 개발)

  • Kim, Yong-Su;Ahan, Sang-Ro;Jung, Jae-Hyun;Han, Sang-Jea;Jung, Seung-Yong
    • Proceedings of the Korean Geotechical Society Conference
    • /
    • 2009.03a
    • /
    • pp.667-672
    • /
    • 2009
  • Gathering information and systemization of infrastructure disaster management is to reduce uncertainties in making decisions and maximize the number of alternations. The key objects of a sensor-based progress report and propagation automation systems are to provide objective data, realize and support decision making and deliver them to a certain area, department, manager and other people rapidly. The major findings and results of this study are as follows. 1) Application of international standard-based alerting protocol(CAP; Common Alerting Protocol). 2) Development of database of existing progress report and propagation manual in order to achieve networking of safety management on major social infrastructure of the nation. 3) Development middleware application programs to progress report and propagation data using SMS, FAX, EMS, VMS, MMS.

  • PDF

Data Mining for Knowledge Management in a Health Insurance Domain

  • Chae, Young-Moon;Ho, Seung-Hee;Cho, Kyoung-Won;Lee, Dong-Ha;Ji, Sun-Ha
    • Journal of Intelligence and Information Systems
    • /
    • v.6 no.1
    • /
    • pp.73-82
    • /
    • 2000
  • This study examined the characteristicso f the knowledge discovery and data mining algorithms to demonstrate how they can be used to predict health outcomes and provide policy information for hypertension management using the Korea Medical Insurance Corporation database. Specifically this study validated the predictive power of data mining algorithms by comparing the performance of logistic regression and two decision tree algorithms CHAID (Chi-squared Automatic Interaction Detection) and C5.0 (a variant of C4.5) since logistic regression has assumed a major position in the healthcare field as a method for predicting or classifying health outcomes based on the specific characteristics of each individual case. This comparison was performed using the test set of 4,588 beneficiaries and the training set of 13,689 beneficiaries that were used to develop the models. On the contrary to the previous study CHAID algorithm performed better than logistic regression in predicting hypertension but C5.0 had the lowest predictive power. In addition CHAID algorithm and association rule also provided the segment characteristics for the risk factors that may be used in developing hypertension management programs. This showed that data mining approach can be a useful analytic tool for predicting and classifying health outcomes data.

  • PDF

Exploring the dynamic knowledge structure of studies on the Internet of things: Keyword analysis

  • Yoon, Young Seog;Zo, Hangjung;Choi, Munkee;Lee, Donghyun;Lee, Hyun-woo
    • ETRI Journal
    • /
    • v.40 no.6
    • /
    • pp.745-758
    • /
    • 2018
  • A wide range of studies in various disciplines has focused on the Internet of Things (IoT) and cyber-physical systems (CPS). However, it is necessary to summarize the current status and to establish future directions because each study has its own individual goals independent of the completion of all IoT applications. The absence of a comprehensive understanding of IoT and CPS has disrupted an efficient resource allocation. To assess changes in the knowledge structure and emerging technologies, this study explores the dynamic research trends in IoT by analyzing bibliographic data. We retrieved 54,237 keywords in 12,600 IoT studies from the Scopus database, and conducted keyword frequency, co-occurrence, and growth-rate analyses. The analysis results reveal how IoT technologies have been developed and how they are connected to each other. We also show that such technologies have diverged and converged simultaneously, and that the emerging keywords of trust, smart home, cloud, authentication, context-aware, and big data have been extracted. We also unveil that the CPS is directly involved in network, security, management, cloud, big data, system, industry, architecture, and the Internet.

MAINTENANCE COST ANALYSIS FOR LARGE HOSPITAL BUILDINGS

  • Sy-Jye Guo;Tzu-Ping Lo
    • International conference on construction engineering and project management
    • /
    • 2009.05a
    • /
    • pp.310-315
    • /
    • 2009
  • Large hospitals such as medical centers provide not only medical services, but also carry the responsibilities for emergency refuges, medical researches and education. The function of large hospitals is as important as other infrastructure systems such as highways, bridges, and utilities. When disasters occur, the hospitals have to provide emergency medical services for victims and support the patient's needs of health. In order to keep a smooth operation of hospitals, the maintenance management of hospital buildings should be carefully investigated. However, there are few researches focused on maintenance management issues of hospital buildings. This paper investigated the National Taiwan University Hospital (NTUH) and established a maintenance cost database. The NTUH is the best-known and most high-renowned medical center in Taiwan in which more than 4,000 employees serving approximately 2,000 in-patients and 7,000 out-patients daily. The data were collected from the NTUH which consisted of 16,228 maintenance records in the past ten years. This paper analyzed these data to obtain various characteristics of maintenance records, and revealed the key items of maintenance cost for large hospital buildings, which can provide the facility manager of hospital buildings to execute a proper maintenance policy for hospital buildings.

  • PDF

Development of an Application System for Efficient Management of Underground Water Supply Facility - Pilot Study in Chonju City - (상수도 지하시설물의 효율적 관리를 위한 응용시스템 개발 -전주시를 대상으로-)

  • 오권호;진철하;이근상;정승현;조기성
    • Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
    • /
    • v.18 no.2
    • /
    • pp.111-120
    • /
    • 2000
  • Water, waste, electric and gas facilities are urban based facilities that needed in our life and are often located in underground. Therefore, underground facilities are more difficult to manage efficiently than ground facilities. It is needed to carry out survey/probe into underground facilities and to build database in order to prevent city-misfortunes being occurred because of negligent management and in order to minimize budget-waste and a traffic jam according to repetition of road excavation constructions. Also, the development of application system is required to manage efficiently underground facility. Chonju city has launched underground water supply facility computerizing project as a part of National Geographic Information System project until December 1998 and executed survey/probe into 402.89 km water supply that is 80 mm up inside central town area 39.6 $km^2$. Also, chonju city built database into 537 km water supply that is 80 mm below based on water supply card without other survey/probe works. Also, existing work process each department is changed into GIS applied work process and underground water supply facility management system is developed by its work process basis. Water supply underground facility management system that is developed is composed of sub-system like base-map management, water supply inspect, water supply management and water supply inquiry, construction work management, administration management and map management. This research presents the procedure and method of underground water supply facility survey/probe and problem being occurred during survey/probe procedure and also show the functions of each sub-systems composing underground water supply facility management system.

  • PDF

Development of Remote Monitoring and Control Systems in Bottle Cultivation Environments of Oyster Mushrooms (느타리 병버섯 재배사 원격환경 모니터링 및 제어시스템 개발)

  • Lee, Sung-Hyoun;Yu, Byeong-Kee;Lee, Chan-Jung;Yun, Nam-Kyu
    • Journal of Mushroom
    • /
    • v.15 no.3
    • /
    • pp.118-123
    • /
    • 2017
  • This study was carried out to develop the technology to manage the growth of mushrooms, which were cultivated based on long-term information obtained from quantified data. In this study, hardware that monitored and controlled the growth environment of the mushroom cultivation house was developed. An algorithm was also developed to grow mushrooms automatically. Environmental management for the growth of mushrooms was carried out using cultivation sites, computers, and smart phones. To manage the environment of the mushroom cultivation house, the environmental management data from farmers cultivating the highest quality mushrooms in Korea were collected and a growth management database was created. On the basis of the database value, the management environment for the test cultivar (hukthali) was controlled at $0.5^{\circ}C$ with 3-7% relative humidity and 10% carbon dioxide concentration. As a result, it was possible to produce mushrooms that were almost similar to those cultivated in farms with the best available technology.

On Feasibility of Ambulatory KDRGs for the Classification of Health Insurance Claims (KDRG를 이용한 건강보험 외래 진료비 분류 타당성)

  • 박하영;박기동;신영수
    • Health Policy and Management
    • /
    • v.13 no.1
    • /
    • pp.98-115
    • /
    • 2003
  • Concerns about growing health insurance expenditures became a national Issue in 2001 when the National Health Insurance went into a deficit. Increases in spending for ambulatory care shared the largest portion of the problem. Methods and systems to control the spending should be developed and a system to measure case mix of providers is one of core components of the control system. The objectives of this article is to examine the feasibility of applying Korean Diagnosis Related Groups (KDRGs) to classify health insurance claims for ambulatory care and to identify problem areas of the classification. A database of 11,586,270 claims for ambulatory care delivered during January 2002 was obtained for the study, and the final number of claims analyzed was 8,319,494 after KDRG numbers were assigned to the data and records with an error KDRG were excluded from the study. The unit of analysis was a claim and resource use was measured by the sum of charges incurred during a month at a department of a hospital of at a clinic. Within group variance was assessed by th coefficient of variation (CV), and the classification accuracy was evaluated by the variance reduction achieved by the KDRG classification. The analyses were performed on both all and non-outlier data, and on a subset of the database to examine the validity of study results. Data were assigned to 787 KDRGs among 1,244 KDRGs defined in the classification system. For non-outlier data, 77.4% of KDRGs had a CV of charges from tertiary care hospitals less than 100% and 95.43% of KDRGs for data from clinics. The variance reduction achieved by the KDRG classification was 40.80% for non-outlier claims from tertiary care hospitals, 51.98% for general hospitals, 40.89% for hospitals, and 54.99% for clinics. Similar results were obtained from the analyses performed on a subset of the study database. The study results indicated that KDRGs developed for a classification of inpatient care could be used for ambulatory care, although there were areas where the classification should be refined. Its power to predict tile resource utilization showed a potential for its application to measure case mix of providers for monitoring and managing delivery of ambulatory care. The issue concerning the quality of diagnostic information contained in insurance claims remains to be improved, and significance of future studies for other classification systems based on visits or episodes is guaranteed.