• Title/Summary/Keyword: 데이터웨어하우스

Search Result 294, Processing Time 0.025 seconds

Product Review Data and Sentiment Analytical Processing Modeling (상품 리뷰 데이터와 감성 분석 처리 모델링)

  • Yeon, Jong-Heum;Lee, Dong-Joo;Shim, Jun-Ho;Lee, Sang-Goo
    • The Journal of Society for e-Business Studies
    • /
    • v.16 no.4
    • /
    • pp.125-137
    • /
    • 2011
  • Product reviews in online shopping sites can serve as a useful guideline to buying decisions of customers. However, due to the massive amount of such reviews, it is almost impossible for users to read all the product reviews. For this reason, e-commerce sites provide users with useful reviews or statistics of ratings on products that are manually chosen or calculated. Opinion mining or sentiment analysis is a study on automating above process that involves firstly analyzing users' reviews on a product to tell if a review contains positive or negative feedback, and secondly, providing a summarized report of users' opinions. Previous researches focus on either providing polarity of a user's opinion or summarizing user's opinion on a feature of a product that result in relatively low usage of information that a user review contains. Actual user reviews contains not only mere assessment of a product, but also dissatisfaction and flaws of a product that a user experiences. There are increasing needs for effective analysis on such criteria to help users on their decision-making process. This paper proposes a model that stores various types of user reviews in a data warehouse, and analyzes integrated reviews dynamically. Also, we analyze reviews of an online application shopping site with the proposed model.

Study on the data structure design for the integration of water management database (물관리 데이터베이스 통합을 위한 데이터 구조 설계에 관한 연구)

  • Jung, Ji Won;Jung, Seung Kwon;Kang, Hyun Joong;Gwon, Yong Hyeon
    • Proceedings of the Korea Water Resources Association Conference
    • /
    • 2015.05a
    • /
    • pp.637-637
    • /
    • 2015
  • 2009년 미국에서 처음으로 스마트워터그리드의 개념이 도입된 이후로 국내외 국가 기관뿐만 아니라 민간 기업에서도 스마트워터그리드에 대한 관심이 높아지고 있다. 현재 스마트워터그리드는 IBM의 진출을 시작으로 Veolia, Suez 등 다국적 물관리 기업들이 사업을 추진 중이다. 국내의 ICT기술과 수자원시스템의 융합을 통하여 용수 수요 공급량을 실시간으로 파악하고 관리하여 수자원의 지역적 시간적 격차를 해소하는 스마트워터그리드 연구가 국내에서도 진행 중이다. 물관리 시장 주도권을 확보하기 위해 글로벌 물기업간 경쟁이 심화되고 있으며, 개별플랫폼을 구축 활용하여 신규기업의 물산업 진출을 가로막고 있는 실정이다. 이러한 상황에서 국외 물산업 시장 진출을 위하여 통합플랫폼 개발 및 체계적인 데이터 구조 설계가 필요하며, 본 연구는 스마트워터그리드를 운영하기 위해 여러 곳에 분산되어 관리 운영되어지고 있는 수자원 및 물관리 데이터의 통합을 위한 체계적인 데이터베이스 구조설계에 대한 연구를 수행하였다. 이에 본 연구에서는 스마트워터그리드 도메인 내에 주력하고 있는 통합데이터베이스 구조를 외부 데이터 마이닝과 연계하여 확장하는 구조로 현실적이고 단기적인 데이터 통합효과를 위해 ETL/데이터웨어하우스방식을 적용하여 데이터 통합을 추진하였다. 지자체간 분산되어 있는 데이터베이스간의 연동은 관련 법제도 및 지자체간 협의 등 다양한 문제가 연루되어 있어 단기적으로는 B2B 데이터 연동방식을 응용하여 구성하였다. 광역 중앙 제어를 위한 통합데이터베이스는 가상DB 방식을 고려하였으며, 이는 지자체별로 구성된 통합DB에 대한 인터페이스 및 Wrapper 플랫폼을 적용하였다. 이 플랫폼간의 연동은 WaterML2.0을 적용함으로써 단기간내 구현이 가능하도록 하고 상호운용성에 문제를 해결하며, 실시간 데이터 연계를 추구하였다. 본 연구를 통해서 궁극적으로는 수자원 및 물관리 데이터의 통합을 위해 해당플랫폼에서 스키마 맵핑, 프로토콜 변환 정합 등을 실시하며, 실시간 데이터 마이닝 및 통합이 가능하도록 구성함으로써 향후 스마트워터그리드의 빅데이터 플랫폼 개발까지 확장해나갈 수 있을 것으로 기대된다.

  • PDF

Status of Spatial Data Warehouse in Korea (한국의 공간데이터웨어하우스 기술현황 조사)

  • Kim, Seung-Yong;Yom, Jae-Hong
    • Proceedings of the Korean Society of Surveying, Geodesy, Photogrammetry, and Cartography Conference
    • /
    • 2007.04a
    • /
    • pp.237-242
    • /
    • 2007
  • The NGIS(National Geographic Information System) project is in its third phase currently. To put the produced data to practical use, central and local governments are trying to implement spatial data warehouse(SDW). In this study, status of local and international SDW(Spatial Data Warehouse) technology were investigated. It has been observed that in Korea it was necessary to shift the focus from management of spatial data to servicing of spatial data to information end users. To that end, the following tasks should be pursued : 1) standardization, 2) automatic ways of linking various legacy administrative information, 3) development of customized middleware for spatial data integration and 4) legal system infra structure.

  • PDF

An Architecture for Implementing Executive Information System Using Data Warehouse (데이터 웨어하우스를 이용한 임원정보시스템 구축용 아키텍쳐)

  • Lee, Hui-Seok;Hong, Eui-Gi;Kim, Tae-Hun
    • Asia pacific journal of information systems
    • /
    • v.7 no.1
    • /
    • pp.7-24
    • /
    • 1997
  • Executive information system (EIS) is a computer-based information system that supports decision makings ana management activities for senior executives. Data warehouse is a database that receives data copies from legacy systems and external data sources. Data warehouse is typically optimized for decision supports and can be an attractive solution for EIS implementation. This paper proposes an architecture for implementing EIS by the use of data warehouse. The architecture consists of ten implementation layers. Interrelationships among these layers are investigated for an effective EIS implementation. An EIS prototype for a real-fife enterprise is implemented to demonstrate the usefulness of the proposed architecture.

  • PDF

The Design of Dat8 Warehouse and Data Link System for WAPP ICC (WAPP ICC 데이터 웨어하우스 및 자료연계 시스템 설계)

  • Lee, Kang-Seok;Choi, Seung-Il;Song, Jea-Won;Yun, Byeong-Ju
    • Proceedings of the KIEE Conference
    • /
    • 2008.11a
    • /
    • pp.279-281
    • /
    • 2008
  • 현재 서부아프리카 지역의 경우, 대부분의 발전원은 수력과 화력에 의존하고 있으며 서부 아프리카경제공동체(ECOWAS) 15개 회원국의 전력수급률은 매우 낮은 수준일 뿐만 아니라 국가별 에너지 불균형 또한 심한 상태이다. 이에 서부 아프리카 전력공동체(WAPP)는 지역 간 에너지 불균형 해소 및 국가 간 전력망 연계를 위한 전력거래센터(ICC)의 구축을 추진하고 있다. 본 논문은 향후 WAPP ICC에서 본격적인 전력거래기능을 수행하기에 앞서 각 지역제어센터(CAC)의 전력 정보 수집, 분석 및 공유를 위한 자료연계 방안에 대해 서술하였으며 센터간의 자료연계를 위한 통신 프로토콜은 IEC 60870-6(ICCP) 프로토콜을 이용하였다.

  • PDF

데이터 웨어하우스 구축을 위한 상향식.하향식 접근 방법에 관한 연구 - 방법론적 고찰을 통한 접근

  • 박주석;전대성;박진휘
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 1998.10a
    • /
    • pp.15-18
    • /
    • 1998
  • Recently, domestic datawarehouse marketplaces take up the most important part of information technology investments with ERP(Enterprise Resource Planning), EC(Electronic Commerce) construction projects in spite of a business slowdown for IMF environment. Therefore, in industrial fields as finances, communications, manufactures, distributions, and so on, datawarehouse was constructed or is under construction, and datawarehouse success stories was showed around some enterprises that has constructed previously datawarehouse. This study is intended to be henceforth an index and direction for an actual proof study by discussing a study of methodology for datawarehouse construction in order to compare and analyze Top-down & Bottom-up approach for datawarehouse that has constructed in actual enterprises.

  • PDF

Multi-Dimensional Analysis Method of Maintenance Cost of School Facility (학교시설물 유지관리비용의 다차원분석 방법)

  • Ryu, Han-Guk
    • Proceedings of the Korean Institute of Building Construction Conference
    • /
    • 2014.05a
    • /
    • pp.56-57
    • /
    • 2014
  • As school facilities have been expanding quantity better than quality, efficient school facility management has been focused on from 2001 in domestic. Due to obsolescence of school facility, objective management and maintenance cost of school facility is very important. However LCC(Life cycle cost) analyst, owner, engineer, contractor and facility manager have a difficulty to obtain and facilitate the basic analyzed data required to analyze LCC of school facility and establish maintenance plan. Therefore this research presents muti-dimensional analysis method through data warehouse technique for supplying maintenance cost information of school facility that can trace and accumulate the scattered LCCing data in the perspective of life cycle of school facility.

  • PDF

An architecture for implementing executive information system using data warehouse (데이터 웨어하우스를 이용한 임원정보시스템 구축용 아키텍쳐)

  • 이희석;홍의기;김태훈
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 1996.10a
    • /
    • pp.254-257
    • /
    • 1996
  • Executive information system (EIS) is a computer-based information system that supports decision makings and management activities for senior executives. Data warehouse is a database that receives data copies from legacy systems and external data sources. Data warehouse is typically optimized for decision supports and can be an attractive solution for EIS implementation. This paper proposes an architecture for implementing EIS by the use of data warehouse. The architecture consists of ten implementation layers. Interrelationships among these layers are investigated for an effective EIS implementation. An EIS prototype for a real-life enterprise is implemented to demonstrate the usefulness of the proposed architecture.

  • PDF

공간적 의사결정을 위한 공간 데이터 웨어하우스 설계 및 활용

  • 박지만;황철수
    • Proceedings of the Korean Association of Geographic Inforamtion Studies Conference
    • /
    • 2003.11a
    • /
    • pp.9-14
    • /
    • 2003
  • The major reason that spatial data warehousing has attracted a great deal of attention in business GIS in recent years is due to the wide availability of huge amounts of spatial data and the imminent need for turning such data into useful geographic information. Therefore, this research has been focused on designing and implementing the pilot tested system for spatial decision making. The purpose of the system is to predict targeted marketing area by discriminating the customers by using both transaction quantity and the number of customer using credit card in department store. Focused on the analysis methodology, the case study is aiming to use GIS and clustering for knowledge discovery. The system is a key section of the research of multi-dimensional and spatio-temporal analysis in the internet environment.

  • PDF

A Comparative Test of ETT Tools for Data Warehousing (데이터 웨어하우스 ETT 도구들의 평가 및 검증)

  • Kim, Gi-Un;Suh, Yong-Moo
    • Asia pacific journal of information systems
    • /
    • v.10 no.2
    • /
    • pp.213-236
    • /
    • 2000
  • Many enterprises continue to have an interest in the usage of new information technologies to gain a competitive advantage. In particular, their interest in the data warehouse and the data mining reveals the aspect of such a trend. Although lots of vendors announce a variety of tools for data warehousing, many a enterprise have a difficulty in building a robust data warehouse due to the lack of the ability of selecting an appropriate data warehouse technology options. Therefore, this study presents some evaluation factors, evaluation methods, and evaluation results about ETT tools, mainly in terms of a comparative test for the current available data warehousing ETT tools, Also, this paper suggests some guides about choosing the right ETT tools.

  • PDF