• 제목/요약/키워드: DB Server

검색결과 281건 처리시간 0.031초

An Implementation of Realtime Remote-Monitoring System for Distributed Photovoltaic Power Plants (분산형 태양광 발전 시스템을 위한 실시간 원격 모니터링 시스템 구현)

  • Kim, Chang-Joon;Kim, Jung-Ki;Jang, Kyung-Sik
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • 제19권10호
    • /
    • pp.2450-2456
    • /
    • 2015
  • In this paper, we propose a real-time remote monitoring system for distributed solar power generation system. The proposed system consists of PVC, UTC, OTC and monitoring server. PVC collects the operational information from the PV's inverter via serial interface. The sensing data is transmitted to the server by wireless communications and stored in the DB server. The PV's status is monitored via UTC, and the operating of PVC and UTC are managed by OTC. In addition, by providing information about the power generated by PV system and failure diagnosis in real time, the proposed system shows the possibility of reducing the maintenance costs and improved failure recovery time.

The Development of Real-Time Free Length Monitoring Systems Interlocking with PLC Device (PLC 장비와 연동하는 실시간 자유장 모니터링 시스템 개발)

  • Jung, Jin-uk;Kim, Su-hong;Jin, Kyo-hong
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 한국정보통신학회 2016년도 춘계학술대회
    • /
    • pp.539-541
    • /
    • 2016
  • In this paper, we proposed real time free-length monitoring systems interlocking with the spring free-length sorter which shows the state of production connected to the spring production device. This systems enable the administrator to check the quality or quantity of product and the defect rate, etc., in the remote place. The proposed systems are comprised of the wireless device interlocking with PLC device, the server program, and user GUI program. The wireless device transmits the received data from PLC device to server program using Wi-Fi. Server program represents the data from the wireless device on the screen and insert those data into database. User GUI program shows data stored in database and supports the function which converts the stored data in DB to excel file.

  • PDF

Design of Caching Scheme for Mobile Underground Geospatial Information Map System (모바일용 지하공간정보지도 관리 시스템에서 응답속도 향상을 위한 캐싱 기법)

  • Kim, Yong-Tae;Kouh, Hoon-Joon
    • Journal of Convergence for Information Technology
    • /
    • 제12권1호
    • /
    • pp.7-14
    • /
    • 2022
  • Unlike general maps, the underground geospatial Information is a system made to view underground information in a 3D shape. This system is managed by a tile maps to lighten the data. But there are various underground structures in the basement, and the structures are made of 3D data, so the data size is large. Therefore, when a client mobile program requests a tile map, the service server fetches the requested tile map from the DB server and transmits ti to the client, but there is a transmission delay time problem. In this paper, we design the tile cache method to improve the request response speed for the tile map data provided to the client in the mobile underground geospatial information system. We propose a method in which a service server predicts and prefetchs the next tile map while the client is viewing tile map, and stores the prefetching data in the memory of client mobile terminal. Then, the transmission delay time problem can be solved.

Design and Implementation of MongoDB-based Unstructured Log Processing System over Cloud Computing Environment (클라우드 환경에서 MongoDB 기반의 비정형 로그 처리 시스템 설계 및 구현)

  • Kim, Myoungjin;Han, Seungho;Cui, Yun;Lee, Hanku
    • Journal of Internet Computing and Services
    • /
    • 제14권6호
    • /
    • pp.71-84
    • /
    • 2013
  • Log data, which record the multitude of information created when operating computer systems, are utilized in many processes, from carrying out computer system inspection and process optimization to providing customized user optimization. In this paper, we propose a MongoDB-based unstructured log processing system in a cloud environment for processing the massive amount of log data of banks. Most of the log data generated during banking operations come from handling a client's business. Therefore, in order to gather, store, categorize, and analyze the log data generated while processing the client's business, a separate log data processing system needs to be established. However, the realization of flexible storage expansion functions for processing a massive amount of unstructured log data and executing a considerable number of functions to categorize and analyze the stored unstructured log data is difficult in existing computer environments. Thus, in this study, we use cloud computing technology to realize a cloud-based log data processing system for processing unstructured log data that are difficult to process using the existing computing infrastructure's analysis tools and management system. The proposed system uses the IaaS (Infrastructure as a Service) cloud environment to provide a flexible expansion of computing resources and includes the ability to flexibly expand resources such as storage space and memory under conditions such as extended storage or rapid increase in log data. Moreover, to overcome the processing limits of the existing analysis tool when a real-time analysis of the aggregated unstructured log data is required, the proposed system includes a Hadoop-based analysis module for quick and reliable parallel-distributed processing of the massive amount of log data. Furthermore, because the HDFS (Hadoop Distributed File System) stores data by generating copies of the block units of the aggregated log data, the proposed system offers automatic restore functions for the system to continually operate after it recovers from a malfunction. Finally, by establishing a distributed database using the NoSQL-based Mongo DB, the proposed system provides methods of effectively processing unstructured log data. Relational databases such as the MySQL databases have complex schemas that are inappropriate for processing unstructured log data. Further, strict schemas like those of relational databases cannot expand nodes in the case wherein the stored data are distributed to various nodes when the amount of data rapidly increases. NoSQL does not provide the complex computations that relational databases may provide but can easily expand the database through node dispersion when the amount of data increases rapidly; it is a non-relational database with an appropriate structure for processing unstructured data. The data models of the NoSQL are usually classified as Key-Value, column-oriented, and document-oriented types. Of these, the representative document-oriented data model, MongoDB, which has a free schema structure, is used in the proposed system. MongoDB is introduced to the proposed system because it makes it easy to process unstructured log data through a flexible schema structure, facilitates flexible node expansion when the amount of data is rapidly increasing, and provides an Auto-Sharding function that automatically expands storage. The proposed system is composed of a log collector module, a log graph generator module, a MongoDB module, a Hadoop-based analysis module, and a MySQL module. When the log data generated over the entire client business process of each bank are sent to the cloud server, the log collector module collects and classifies data according to the type of log data and distributes it to the MongoDB module and the MySQL module. The log graph generator module generates the results of the log analysis of the MongoDB module, Hadoop-based analysis module, and the MySQL module per analysis time and type of the aggregated log data, and provides them to the user through a web interface. Log data that require a real-time log data analysis are stored in the MySQL module and provided real-time by the log graph generator module. The aggregated log data per unit time are stored in the MongoDB module and plotted in a graph according to the user's various analysis conditions. The aggregated log data in the MongoDB module are parallel-distributed and processed by the Hadoop-based analysis module. A comparative evaluation is carried out against a log data processing system that uses only MySQL for inserting log data and estimating query performance; this evaluation proves the proposed system's superiority. Moreover, an optimal chunk size is confirmed through the log data insert performance evaluation of MongoDB for various chunk sizes.

A Study on Personalization System Using Web Log and Purchasing Database (웹 로그와 구매 DB를 이용한 개인화 시스템에 관한 연구)

  • 김영태;이성주
    • Proceedings of the Korean Institute of Intelligent Systems Conference
    • /
    • 한국퍼지및지능시스템학회 2003년도 추계 학술대회 학술발표 논문집
    • /
    • pp.23-26
    • /
    • 2003
  • In this paper, a methodolgy for customizing web pages for indivisual users is suggested. It shows an efficient way to personalize web pages by predicting one's site access pattern. In addition, the prediction can reflect one's tendency after actual purchase. By using the APRIORI algorithm, one of the association rule search methods, the associativity among the purchase items can be inferred. This inferrence is based on the log data in a web server and database about purchase. Finally, a web page which contains the relationship, relative links on other web pages, and inferred items can be generated after this process.

  • PDF

A Study on the Development of Integrated Real-time Water Management System (통합 실시간 물관리 운영 시스템 구축 방안 연구)

  • Kim Eugene;Kim Nami IL;Hwang Man Ha;Ko Ick Hwan
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 한국수자원학회 2005년도 학술발표회 논문집
    • /
    • pp.1435-1439
    • /
    • 2005
  • 국내의 효율적인 수자원 관리를 위해서는 수량과 수질을 고려하여 한정된 수자원을 효율적으로 사용할 수 있도록 수자원 계획과 운영상의 문제점을 피드백할 수 있는 유역 단위의 통합 수자원 관리 시스템이 필요하다. 따라서 본 연구에서는 수자원의 효율적인 공급 및 배분을 위해 기상, 유출, 저수지 운영, 수질 모형과 수자원 정보가 통합된 실시간 물관리 운영 시스템을 구축하기 위한 방안을 제시하고자 한다. 본 연구에서 제안하고자하는 통합 실시간 물관리 운영 시스템(IRWMS)은 한국수자원공사의 물관리 운영자를 위한 시스템으로써 이를 이용하는 사용자와 운영 환경, 모의방식 등에 따라 DB & server 시스템, wrapper engine, on-line 시스템, off-line 시스템, 매크로 시스템의 5부분으로 구성된다.

  • PDF

A Design and Implementation of a Web-based DSS for Mathematical Analysis (수리적 분석을 위한 웹 기반 의사결정지원시스템의 설계와 구현)

  • Kim, Sheung-Kown;Kim, Tae-Hyung
    • IE interfaces
    • /
    • 제13권3호
    • /
    • pp.539-547
    • /
    • 2000
  • An architecture of a Web-based Decision Support system for mathematical analysis is presented. Front-end modules provide web-client GUI environment for mathematical analysis. The networking architecture is built upon client/server system by Java socket and accesses database by JDBC in WWW. Back-end modules provide decision supporting service and data management for mathematical programming analysis. In the back-end any analysis tools, such as mathematical optimizer, simulation package, or statistics package can be used. As an application example for this implementation, optimal facility replacement decision problem is selected. In the implementation the optimal facility replacement decision problem is formulated as a shortest path problem. It uses Oracle DB and CPLEX package as the mathematical optimizer. While ORAWeb is designed and implemented on the optimal facility replacement problem, it can easily be extended to any decision supporting problems that would require mathematical optimization process.

  • PDF

The Engineering Change Document Management using SGML in PDM (SGML을 활용한 PDM에서의 설계변경문서관리)

  • Kim, Joon-Oh;Kim, Sunn-Ho
    • IE interfaces
    • /
    • 제10권2호
    • /
    • pp.79-90
    • /
    • 1997
  • Documents in a traditional PDM(Product Data Management) system have been managed in a form of scanned document files or electronic documents developed by specific tools. Though each tool manages documents with its own systematical methods, it has drawbacks in data search, data integration and interchange, etc. For this reason, in this research we propose an efficient document management system for PDM by using the SGML(Standard Generalized Markup Language), one of CALS and ISO standards for document interchanges. Among documents to be managed in PDM, the engineering change notification (ECN) is taken into account. The DTD (Document Type Definition) has been constucted based on the logical analysis of the documents format, In addition, based on the DTD, DB classes have been designed by object-oriented paradigms and a prototype for document input/output and search has been developed using UniSQL ORDBMS (Object-Relational DBMS) and PowerBuilder under the client/server environment.

  • PDF

Development of The Open Mobile E-commerce Platform Using 3D GIS and E-catalog

  • Cho, Jeong-Hyun;Ryu, Hyun-Ki
    • Journal of Korea Society of Industrial Information Systems
    • /
    • 제19권3호
    • /
    • pp.17-23
    • /
    • 2014
  • Recently, E-Commerce demands an integrated solution for online and off-line provided to customers on wired / wireless network and various mobile devices. Our E-commerce platform can use anytime, anywhere, for all consumers. And, it can take convenient and secure E-commerce service in mobile environment. So, we will implement a software platform base on the mobile environment that independent of the mobile OS. Particularly, our E-commerce platform is based on 3D GIS information for 3D electronic map. So, all users (customers) have got the more visible convenience. And, by using the e-catalog DB cloud server, off-line store operators can be built the online home-page easily. From now on our E-commerce platform based on 3D GIS can be usable at various E-commerce areas in the ubiquitous environment.

AHP Model을 이용한 은행 IT System 구축 및 검증 방안

  • Min, Seo-Yeon;Song, Sang-Jun;Jang, Seong-U
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 한국경영과학회 2006년도 추계학술대회
    • /
    • pp.205-208
    • /
    • 2006
  • 최근 전산화를 위한 대형 IT 프로젝트가 증가 하고 있다. IT 프로젝트를 수행하기 위해서 DB, Server 등과 같은 S/W, H/W 제품과 구현을 수행할 SI 업체 등이 사전에 선정되어야 한다. 현재 대부분의 대형 IT 프로젝트의 경우 제품 및 업체를 선정함에 있어서 내부적인 의사 결정 기준을 보유하고 있으나, 이를 외부에 공개하지 않음을 원칙으로 하고 있다. 본 연구에서는 한 은행이 직면한 제품 및 업체 선정 문제 사례에 대해 AHP기법을 적용하여 그 결과를 은행 내부 기준에 의한 의사 결정 결과와 비교해 보았으며, 절대적 측정 방법에 의한 Scoring System을 제시함으로써 향후 유사한 의사결정 문제에 있어서 보다 정확하고 신속한 의사 결정에 기여하고자 하였다.

  • PDF