• Title/Summary/Keyword: 온라인 다차원 분석

Search Result 48, Processing Time 0.023 seconds

A MOLAP Cube Storage Scheme for Fast Query Processing (고속 질의처리를 위한 MOLAP 큐브 저장구조)

  • Lim, Yoon-Sun;Yang, Hye-Yeong;Kim, Myung
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2001.04b
    • /
    • pp.127-129
    • /
    • 2001
  • 데이터 웨어하우스의 데이터를 다차원적으로 분석하여 그 결과를 온라인으로 사용자에게 제공하는 것을 OLAP 이라고 하고, 이 때 데이터를 큐브라고 불리는 배열에 저장해 두고 데이터를 위치정보를 통해 엑세스하는 시스템을 MOLAP 시스템이라고 한다. OLAP 연산 도중에 디스크로부터 읽어야 하는 데이터의 양을 감소시키기 위해 큐브를 압축된 청크 단위로 저장하는 방안이 이미 제안되고 있으나, 큐브의 데이터 분포, 청크와 디스크 블록의 크기 관계 등을 고려하여 디스크 엑세스를 줄이는 방안에 관한 연구는 아직 소개된 바가 없다. 본 연구에서는 청크들을 밀도를 기준으로하여 군집화 하고, 큐브내의 인접 청크들을 가능한 한 동일한 디스크 블록에 속하게 함으로써, OLAP의 주요 연산인 슬라이스, 다이스와 같은 연산의 속도를 향상시키는 방안을 제시한다. 제안한 저장구조는 실험을 통해 그 효율성을 증명하였다.

  • PDF

A Web Services-based Client OLAP API and Its Application to Cube Browsing (웹 서비스 기반의 클라이언트 OLAP API와 큐브 브라우징에의 응용 사례)

  • Bae, Eun-Ju;Kim, Myung
    • The KIPS Transactions:PartD
    • /
    • v.10D no.1
    • /
    • pp.143-152
    • /
    • 2003
  • XML and Web Services draw a lot of attention as standard technologies for data exchange and integration among heterogeneous platforms XML/A, which supports such technologies, is a SOAP based XML APl that facilitates data exchange between a client application and a data analysis engine through the Internet. The fact that the XML format is used for data exchange makes XML/A to be platform-independent. However. client application developers have to go through a tedious Job of treating the same type of XML documents fur downloading data from the server. Also, an XML query language is needed for extracting data from the XML documents sent by the server. In this paper, we present a high level client OLAP API, called DXML, for the client application developers in the windows environment to easily use the OLAP services of XML/A. XMLMD consists of properties and methods needed for OLAP application development. XMLMD is to XML/A what ADOMD is to OLEDB for OLAP. We also present a web OLAP cube browser that is developed using XMLMD. The browser display's data in various formats such as XML, HTML, Excel, and graph.

A Study on the IPTV Use Perception and Factors Influencing IPTV Adoption (IPTV 이용자의 이용인식과 수용결정요인에 관한 연구)

  • Kim, Mi-Sun
    • Korean journal of communication and information
    • /
    • v.52
    • /
    • pp.177-202
    • /
    • 2010
  • IPTV has been drawing attention as a representative convergence media. The analysis of the convergence media, as like IPTV, requires an investigation into the use perception and multidimensional factors. So this research examines the IPTV usage, based on the Technology Acceptance Model. The analysis was made with the 500 users, based on the online survey. The first results is concerned with the user characteristics. A positive influential relationship between the user characteristics and use perception was confirmed, along with the individual attribute and environmental influence. The second, 'perceived ease of use' was found to positively influence 'perceived usefulness' and 'perceived playfulness'. This finding suggests that it is an important diffusion strategy to enhance the ease of use of IPTV. The third is the emphasis of playfulness of IPTV. Since IPTV is multimedia, playfulness played a significant role in diffusing IPTV. The application of the TAM to the media analysis of IPTV, which reflects the environments of the convergence media and use perception, was successful in drawing a significant outcome.

  • PDF

A PIVOT based Query Optimization Technique for Horizontal View Tables in Relational Databases (관계 데이터베이스에서 수평 뷰 테이블에 대한 PIVOT 기반의 질의 최적화 방법)

  • Shin, Sung-Hyun;Moon, Yang-Sae;Kim, Jin-Ho;Kang, Gong-Mi
    • The KIPS Transactions:PartD
    • /
    • v.14D no.2
    • /
    • pp.157-168
    • /
    • 2007
  • For effective analyses in various business applications, OLAP(On-Line Analytical Processing) systems represent the multidimensional data as the horizontal format of tables whose columns are corresponding to values of dimension attributes. Because the traditional RDBMSs have the limitation on the maximum number of attributes in table columns(MS SQLServer and Oracle permit each table to have up to 1,024 columns), horizontal tables cannot be directly stored into relational database systems. In this paper, we propose various efficient optimization strategies in transforming horizontal queries to equivalent vertical queries. To achieve this goral, we first store a horizontal table using an equivalent vertical table, and then develop various query transformation rules for horizontal table queries using the PIVOT operator. In particular, we propose various alternative query transformation rules for the basic relational operators, selection, projection, and join. Here, we note that the transformed queries can be executed in several ways, and their execution times will differ from each other. Thus, we propose various optimization strategies that transform the horizontal queries to the equivalent vertical queries when using the PIVOT operator. Finally, we evaluate these methods through extensive experiments and identify the optimal transformation strategy when using the PIVOT operator.

Effect of User Experience of Smart Learning App on Intention to Continuous Use (스마트러닝 학습앱의 사용자경험이 지속사용의도에 미치는 영향)

  • Park, Joong-Hee;Han, Kwang-Hee
    • The Journal of the Korea Contents Association
    • /
    • v.22 no.8
    • /
    • pp.416-434
    • /
    • 2022
  • This study, for learners using online and offline tools, understood the structural relationship of user experience of smart learning app on continuous use intention through the technology acceptance model, and classified the learning type characteristics. In addition, based on the experience of using the smart learning app, we explored ways to improve the design of the user experience design for learning tools and contents. For this purpose, the usage perception of 84 middle and high school students of the developed smart learning learning app was investigated after using it for 2 months, and the data were analyzed using the PLS structural equation technique. The main results of this study are as follows. First, system and content user experience had a significant effect on perceived usability and perceived ease of use, and the effect on continued use intention through attitude was significant. Second, there was a significant difference in the effect of system user experience on perceived usefulness in multi-group comparative analysis and gender group. In the preferred learning group, it was the path from perceived ease of use and perceived usefulness to attitude and intention to continue using that showed a significant path difference. Third, as a result of classifying the most commonly used learning types by the multidimensional scale method, the types separated into low dimensions were found to be four types: offline sync type, online sync type, ubiquitous learning type, and self-direct learning type.

Impact of Ideological Orientation on Populist Attitude in Korea (한국 대중의 이념 정향이 포퓰리즘 성향에 미치는 영향)

  • Do, Myo Yuen
    • Korean Journal of Legislative Studies
    • /
    • v.27 no.1
    • /
    • pp.117-155
    • /
    • 2021
  • The purpose of this study is to identify the relationship between people's ideological orientation and the populist attitude in terms of demand of populism. The influence of subjective ideology evaluation and political party support on anti-elitism (AE), people centrism (PC) and anti-pluralism (AP) are analyzed in detail. To research this, the socioeconomic factors, democracy recognition and the method of political participation are set as control variables, and the ideologies are classified into extreme conservative, conservative, moderate, progress, and extreme progress. The data are collected through nationwide online survey. The results of the analysis are as follows: First, the powerful affinity between ideological orientation and populist attitude are confirmed. The support for conservative ideology (especially extreme conservative) and the conservative party are affecting the AE and AP, and the ideology of extreme progress and support for the progressive party are influencing the PC and AP. When putting together 3 types of attitude, the conservative (especially extreme conservative) and extreme progressive ideology are the factors that determine the populism attitude. Second, There was no impact of socioeconomic variables except gender (female) and age. Third, populist attitude have a multidimensional nature determined by democratic satisfaction, government trust, external efficacy, voting and non-voting activities.

The Sensibility Engineering D/B of Image Source for the Shoe Design (신발 디자인을 위한 이미지 소스의 감성공학적 D/B)

  • Kang, Jae-Cheol;Lee, Dong-Choon
    • Archives of design research
    • /
    • v.19 no.1 s.63
    • /
    • pp.69-78
    • /
    • 2006
  • Nowadays, the design and development of footwear are focused on not only to protect feet against some injuries also to satisfy its personality and high-quality based on customer' subjective sensibilities. Many image source based human sensibility is needed to establish concept of footwear by new idea in design process. For satisfying costumer's and designer's disires, this study is concerned to evaluate and analyze images using human sensibility and construct image source D/B according to the result. The image evaluation performed by internet is used 1,000 Images classified into four groups(structure or architecture, transportation device, natural articles and home appliance), and 300 subjects are participated. Finally, the web D/B is constructed by the result of image evaluation that is performed statistical analysis(basic statistic, factoranalysis and multi-scaled analysis).

  • PDF

Semantic Web based Multi-Dimensional Information Analysis System on the National Defense Weapons (시맨틱 웹 기반 국방무기 다차원 정보 분석 시스템)

  • Choi, Jung-Hwoan;Park, Jeong-Ho;Kim, Pyung;Lee, Seungwoo;Jung, Hanmin;Seo, Dongmin
    • The Journal of the Korea Contents Association
    • /
    • v.12 no.11
    • /
    • pp.502-510
    • /
    • 2012
  • As defense science and technology are developing, smart weapons are being developed continually. The collection and analysis of the future strategic weapon information from all over the world have become a greater priority because information sharing became active. So, a system to manage and analyze heterogeneous defense intelligence is required. Semantic Web is the next generation knowledge information management technology for integrating, searching and navigating heterogeneous knowledge resource. Recently, Semantic Web is wildly being used in intelligent information management system. Semantic Web supports the analysis with the high reliability because it supports the simple keyword search as well as the semantic based information retrieval. In this paper, we propose the semantic web based multi-dimensional information analysis system on the national defense weapons that constructs ontology for various weapons information such as weapon specifications, nations, manufacturers and technologies and searches and analyses the specific weapon based on ontology. The proposed system supports the semantic search and multi-dimensional information analysis based on the relations between weapon specifications. Also, our system improves the efficiency on acquiring smart weapon information because it is developed with ontology based on military experts' knowledge and various web documents related with various weapons and intelligent search service.

A Study on the Web Based Collaborative Learning Systems (웹기반 협동학습시스템의 활용에 관한 연구)

  • Lee, Dong-Hoon;Lee, Sang-Kon;Lee, Ji-Yeon
    • The Journal of Korean Institute for Practical Engineering Education
    • /
    • v.2 no.1
    • /
    • pp.64-70
    • /
    • 2010
  • The purpose of this study is to understand students' use intentions of Web Based Collaborative Learning (WBCL) system. To meet this purpose, we developed a research model based on the Decomposed TPB. This model contains 5 influencing factors: Explicit social influence(EXSI) and Implicit social influence(IMSI), Perceived Usefulness (PU), Perceived easy of use(PEOU), Perceived Playfulness(PP). Data was collected 254 university students from two different institutions. Also, the analysis is conducted to do the hypothesis testing by using PLS 3.0. The result shows that influence factors except PEOU have a important and significant impact on user Behavior Intention(BI). Using WBCL system and learning tool, team leader(that is referent) and members can be a good interaction. For these same reasons, We found that especialy Explicit social influence(EXSI) and Implicit social influence(IMSI) are special influence factors in reference group.

  • PDF

A latent profile analysis of job performance types based on task performance, contextual performance and counterproductive work behavior (과업수행, 맥락수행, 반생산적 업무행동 기반의 직무수행 유형 분석: 잠재프로파일분석을 중심으로)

  • Yoo, Young-Sam;Kim, Myoung-So;Noh, So-Yeon
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.21 no.4
    • /
    • pp.145-155
    • /
    • 2020
  • Since Campbell (1990) proposed multidimensionality of job performance, unlike the single structure of traditional job performance, it has been largely classified as task performance, contextual performance, and counterproductive work behavior. The objective of this study is to validate the threecriteria currently considered major aspects of job performance, to identify different types of performance based on three dimensions, and to compare the power of personality factors among performance types. A total of 681 employees working at various organizations participated in an on-line survey. The survey included boththe exploratory and confirmatory factor analyses. A 3-factor job performance model consisting of three dimensions was also included. The relationships between performance dimensions and personality factors differedby dimensions of performance, supporting the validity of the 3-factor structure of performance.The results of the Latent Profile Analysis identified four types of performance: exemplary, moderately conscientious moderate, and conscientious, butlow.. The Multinomial logistic regression analysis showed each type differed significantly according to the predictors of personality variables. In conclusion, implications and limitations of the study were noted.