• Title/Summary/Keyword: SQL-database

Search Result 428, Processing Time 0.023 seconds

Twitter Issue Tracking System by Topic Modeling Techniques (토픽 모델링을 이용한 트위터 이슈 트래킹 시스템)

  • Bae, Jung-Hwan;Han, Nam-Gi;Song, Min
    • Journal of Intelligence and Information Systems
    • /
    • v.20 no.2
    • /
    • pp.109-122
    • /
    • 2014
  • People are nowadays creating a tremendous amount of data on Social Network Service (SNS). In particular, the incorporation of SNS into mobile devices has resulted in massive amounts of data generation, thereby greatly influencing society. This is an unmatched phenomenon in history, and now we live in the Age of Big Data. SNS Data is defined as a condition of Big Data where the amount of data (volume), data input and output speeds (velocity), and the variety of data types (variety) are satisfied. If someone intends to discover the trend of an issue in SNS Big Data, this information can be used as a new important source for the creation of new values because this information covers the whole of society. In this study, a Twitter Issue Tracking System (TITS) is designed and established to meet the needs of analyzing SNS Big Data. TITS extracts issues from Twitter texts and visualizes them on the web. The proposed system provides the following four functions: (1) Provide the topic keyword set that corresponds to daily ranking; (2) Visualize the daily time series graph of a topic for the duration of a month; (3) Provide the importance of a topic through a treemap based on the score system and frequency; (4) Visualize the daily time-series graph of keywords by searching the keyword; The present study analyzes the Big Data generated by SNS in real time. SNS Big Data analysis requires various natural language processing techniques, including the removal of stop words, and noun extraction for processing various unrefined forms of unstructured data. In addition, such analysis requires the latest big data technology to process rapidly a large amount of real-time data, such as the Hadoop distributed system or NoSQL, which is an alternative to relational database. We built TITS based on Hadoop to optimize the processing of big data because Hadoop is designed to scale up from single node computing to thousands of machines. Furthermore, we use MongoDB, which is classified as a NoSQL database. In addition, MongoDB is an open source platform, document-oriented database that provides high performance, high availability, and automatic scaling. Unlike existing relational database, there are no schema or tables with MongoDB, and its most important goal is that of data accessibility and data processing performance. In the Age of Big Data, the visualization of Big Data is more attractive to the Big Data community because it helps analysts to examine such data easily and clearly. Therefore, TITS uses the d3.js library as a visualization tool. This library is designed for the purpose of creating Data Driven Documents that bind document object model (DOM) and any data; the interaction between data is easy and useful for managing real-time data stream with smooth animation. In addition, TITS uses a bootstrap made of pre-configured plug-in style sheets and JavaScript libraries to build a web system. The TITS Graphical User Interface (GUI) is designed using these libraries, and it is capable of detecting issues on Twitter in an easy and intuitive manner. The proposed work demonstrates the superiority of our issue detection techniques by matching detected issues with corresponding online news articles. The contributions of the present study are threefold. First, we suggest an alternative approach to real-time big data analysis, which has become an extremely important issue. Second, we apply a topic modeling technique that is used in various research areas, including Library and Information Science (LIS). Based on this, we can confirm the utility of storytelling and time series analysis. Third, we develop a web-based system, and make the system available for the real-time discovery of topics. The present study conducted experiments with nearly 150 million tweets in Korea during March 2013.

Development of a Object Oriented Framework for System Design Optimization (최적설계 지원 객체지향 프레임 웍 개발)

  • Chu, Min-Sic;Choi, Dong-Hoon;Lee, Se-Jung
    • Proceedings of the KSME Conference
    • /
    • 2001.06c
    • /
    • pp.369-375
    • /
    • 2001
  • For Optimization technology Was Developed in 1960, the Optimization Technology have grown into a full-featured, robust, highly rated and highly used. And Optimization techniques, having reached a degree of maturity over the past several years, are being used in a wide spectrum of industries, including aerospace, automotive, chemical, electrical, and manufacturing industries. With rapidly advancing computer technology, computers are becoming more powerful, and correspondingly, the size and the complexity of the problems being solved using Optimization techniques are also increasing. But Optimization techniques with analysis solver have many problems. For instance, the difficulties that a particular interface must be coded for each design problem and that the designer should be familiar with the optimization program as well as the analysis program. The purpose of this paper is Optimal Design Framework for Mechanical systems design. This Design Framework has two Optimizers, ADS (local optimizer) and RSM(Response Surface Method), and graphic user interfaces for formulation and optimum design problem and controlling the design process. Current Design Framework tested by two analysis solver, ADAMS and ANSYS. First this paper focused on the core Framework and their conception. In the second of the paper, I cover subjects such as Design Framework Operation. Next, The validity and effectiveness of Design Framework are shown by applying it to many practical design problems and obtaining satisfactory results. Finally, if you are an advanced Operator, you might want to use Response Surface Method, so that cover the result applied by RSM. here.

  • PDF

eCRF use case in Korean Medicine Global Health Business - Focused on Smoking Cessation Program in Vietnam (2017) - (해외 한의약 건강증진사업에서 eCRF시스템 활용사례 - 2017년 베트남 금연사업을 중심으로 -)

  • Mok, Kyungyul;Lee, Eunkyung;Kang, Sohyeon;Park, Jaeeun;Shine, Yong-Cheol;Jang, Bo-Hyoung;Ko, Seong-Gyu
    • Journal of Society of Preventive Korean Medicine
    • /
    • v.22 no.1
    • /
    • pp.91-105
    • /
    • 2018
  • Objectives : The purpose of this study was to introduce the case of using eCRF system in the Smoking Cessation Program project in Vietnam (2017). And aimed to derive the usefulness of the eCRF system and it potential for future global health business. Method : Introduce the smoking cessation program in vietnam (2017). Smoking Cessation was conducted in three provices of central vietnam Tamphu, Binhtu, Duytrinh) and eCRF was developed on the web environment by building AMP(Apache, PHP, MySQL). Dedicated application have also been developed for user. Result : Using the eCRF, the results of the program of the smoking cessation participants were recorded on the Database server. The implemented system focused on the role of a case recording platform that was simplified in function rather than an electronic version of the case report. It was useful for monitoring. Conclusions : The eCRF system was useful in global health business, and upgrading the system to reflect the feedback derived from the project could potentially be used in other projects. In addition, there are few cases where ICT is used in overseas health promotion projects using Oriental medicine, so further research is needed.

A Case Study of Developing XML-based Web Contents Supporting PC and PDA Browser (PC 및 PDA 브라우저 지원을 위한 XML 기반의 웹 컨텐츠 개발 사례 연구)

  • Kim Kyung-A;Yong Hwan-Seung
    • Journal of Digital Contents Society
    • /
    • v.3 no.1
    • /
    • pp.59-74
    • /
    • 2002
  • Due to rapid advance of wireless communication technology and popularization of wireless devices, demand on wireless internet contents is gradually increasing. Therefore, there are many researches and solution developments to provide good qualified contents quickly for wireless internet. For example, researches into converting wired web contents into wireless web contents or using integrated markup language like XHTML basic to make contents. In this paper, I propose a method to develop XML-based web contents which uses PHP language for data fetch from MySQL database. This method use open source software for a cost saving. Due to use of PHP extension as a XSLT engine, this method is very easy to apply. For a example of this method, a web content of movie information is implemented for PC and PDA browser. Developing XML-based web contents is useful not only for supporting devices of multiple type, but also for rapid changes of user interface design and for exchange of contents between web sites.

  • PDF

Ubiquitous Service Model for Information Convergence of Jeju Island Culture, Tourism, Sport and Traffic (제주 문화·관광·체육·교통 정보를 융합한 유비쿼터스 서비스 모델)

  • Lee, Chang-Young;Yang, Jin-Seok;Kim, Do-Hyeun;An, Beongku;Kim, Nam-Soo
    • The Journal of the Institute of Internet, Broadcasting and Communication
    • /
    • v.8 no.4
    • /
    • pp.97-104
    • /
    • 2008
  • Recently the navigation service and LBS (Location based Services) using map supports much information services on mobile terminal. Also Internet Web sites support user much information. But, the user has the difficulty for acquiring the service and the various information based on map because of searching the many Internet sites. Accordingly, this paper supports a convergence information service model of various culture, education, tourism, sport and traffic for accessing synthesizing information based on map. And we design and implement this model using 공개 API. We present a convergence information service model of culture, tourism, sport and bus line information form tour destination and cultural place of Jeju province using the model. Additionally, we develop this service model using apache web server on Linux environment, PHP and JavaScript, MySQL database and Map 공개 API. As this service model supports a convenience action of culture and tourism for Jeju islanders and tourists.

  • PDF

A study for Health Promotion Program of Public Health Center by using CRM (CRM(Customer Relationship Management)기법을 활용한 보건소 건강증진사업에 관한 연구)

  • 강성홍;최순호
    • Korean Journal of Health Education and Promotion
    • /
    • v.20 no.3
    • /
    • pp.125-143
    • /
    • 2003
  • With the shift of cause of death from infection to chronic, the health expenditure has risen dramatically. To curb the increasing health expenditure, programs and campaigns to promote health were proposed and implemented. Most of them, however, were not successful in achieving satisfactory results. Customer Relationship Management has been gradually accepted as an innovative approach to health promotion. The objective of this research was to develop a Customer Relationship Management system for providing comprehensive health care services to the residents in the community. Detailed objectives were as follows: The first objective was the development of the CRM system for health promotion. The second objective was the satisfaction assessment for the health promotion program using the CRM system. The third was the proposal for the effective utilization of the CRM system. The development methodology of the CRM system was Rapid Warehouse Developing Method. As a CRM system equipment, a workstation with GIS of Windows 2000 was selected. SQL Server 2000 was used as a development tool and database. The subjects of study were diabetic mellitus patients, hypertension patients, and vaccin patients. The campaign channel of patients was an autocalling system. For the satisfaction assessment, a survey was performed. The main content of the survey was satisfaction level. The satisfaction level of the health promotion program using CRM system was 79.3%. In consideration of the above findings, we suggested ways of improving the Health Promotion Program by using CRM. The first was the efficient selection of the subjects of the Health Promotion Program. The second was the development for health promotion program using CRM system(life time health of individual etc).

Development of Traffic Prediction and Optimal Traffic Control System for Highway based on Cell Transmission Model in Cloud Environment (Cell Transmission Model 시뮬레이션을 기반으로 한 클라우드 환경 아래에서의 고속도로 교통 예측 및 최적 제어 시스템 개발)

  • Tak, Se-hyun;Yeo, Hwasoo
    • The Journal of The Korea Institute of Intelligent Transport Systems
    • /
    • v.15 no.4
    • /
    • pp.68-80
    • /
    • 2016
  • This study proposes the traffic prediction and optimal traffic control system based on cell transmission model and genetic algorithm in cloud environment. The proposed prediction and control system consists of four parts. 1) Data preprocessing module detects and imputes the corrupted data and missing data points. 2) Data-driven traffic prediction module predicts the future traffic state using Multi-level K-Nearest Neighbor (MK-NN) Algorithm with stored historical data in SQL database. 3) Online traffic simulation module simulates the future traffic state in various situations including accident, road work, and extreme weather condition with predicted traffic data by MK-NN. 4) Optimal road control module produces the control strategy for large road network with cell transmission model and genetic algorithm. The results show that proposed system can effectively reduce the Vehicle Hours Traveled upto 60%.

Development of an OpenGIS Server Supporting the OpenGIS CORBA Specification (OpenGIS CORBA 사양을 지원하는 OpenGIS 서버의 개발)

  • Zhang, Yan-Sheng;Yun, Jae-Kwan;Han, Ki-Joon
    • Journal of Korea Spatial Information System Society
    • /
    • v.2 no.1 s.3
    • /
    • pp.5-16
    • /
    • 2000
  • OGC(Open GIS Consortium) suggests the 'OpenGIS Simple Feature Specification for CORBA' which is the OpenGIS implementation specification for CORBA to specify standard interfaces for reuse and interoperation among distributed heterogeneous GIS resources in the CORBA distributed computing environment. An OpenGIS server that supports this implementation specification moat correctly implement all interfaces defined in the OpenGIS implementation specification to be interoperable with wrapped GISs efficiently. In this paper, we have designed and implemented an OpenGIS server based an object relational GIS, called GEUS that integrates GIS and database technologies to provide spatial data types and spatial operators from the DBMS engine level. In the CORBA distributed computing environment, clients can access geospatial data stored in GIS wrapped by the OpenGIS server through the standard interfaces defined in the OpenGIS implementation specification for CORBA. In addition, clients can use geospatial operation features provided by a back-end GIS and interoperate with other GISs.

  • PDF

Processing large-scale data with Apache Spark (Apache Spark를 활용한 대용량 데이터의 처리)

  • Ko, Seyoon;Won, Joong-Ho
    • The Korean Journal of Applied Statistics
    • /
    • v.29 no.6
    • /
    • pp.1077-1094
    • /
    • 2016
  • Apache Spark is a fast and general-purpose cluster computing package. It provides a new abstraction named resilient distributed dataset, which is capable of support for fault tolerance while keeping data in memory. This type of abstraction results in a significant speedup compared to legacy large-scale data framework, MapReduce. In particular, Spark framework is suitable for iterative machine learning applications such as logistic regression and K-means clustering, and interactive data querying. Spark also supports high level libraries for various applications such as machine learning, streaming data processing, database querying and graph data mining thanks to its versatility. In this work, we introduce the concept and programming model of Spark as well as show some implementations of simple statistical computing applications. We also review the machine learning package MLlib, and the R language interface SparkR.

Four Consistency Levels in Trigger Processing (트리거 처리 4 단계 일관성 레벨)

  • ;Eric Hanson
    • Journal of KIISE:Databases
    • /
    • v.29 no.6
    • /
    • pp.492-501
    • /
    • 2002
  • An asynchronous trigger processor (ATP) is a oftware system that processes triggers after update transactions to databases are complete. In an ATP, discrimination networks are used to check the trigger conditions efficiently. Discrimination networks store their internal states in memory nodes. TriggerMan is an ATP and uses Gator network as the .discrimination network. The changes in databases are delivered to TriggerMan in the form of tokens. Processing tokens against a Gator network updates the memory nodes of the network and checks the condition of a trigger for which the network is built. Parallel token processing is one of the methods that can improve the system performance. However, uncontrolled parallel processing breaks trigger processing semantic consistency. In this paper, we propose four trigger processing consistency levels that allow parallel token processing with minimal anomalies. For each consistency level, a parallel token processing technique is developed. The techniques are proven to be valid and are also applicable to materialized view maintenance.