• Title/Summary/Keyword: selected attribute

Search Result 218, Processing Time 0.037 seconds

Materialized View Selection Algorithm using Clustering Technique in Data Warehouse (데이터 웨어하우스에서 클러스터링 기법을 이용한 실체화 뷰 선택 알고리즘)

  • Yang, Jin-Hyuk;Chung, In-Jeong
    • Annual Conference of KIPS
    • /
    • 2000.04a
    • /
    • pp.28-35
    • /
    • 2000
  • In order to acquire the precise and fast response for an analytical query, proper selection of the views to materialize in data warehouse is very crucial. In traditional algorithms, the whole relation is considered to be selected as materialized views. However, materializing the whole relation rather than a part of relation results in much worse performance in terms of time and space cost. Therefore, we present a new algorithm for selection of views to materialize using clustering method in order to improve the performance of data warehouse including this problem. In the presented algorithm, ASVMR(Algorithm for Selection of Views to Materialize using Reduced table), we first generate reduced tables in data warehouse using automatic clustering based on attribute-values density, then we consider the combination of reduced tables as materialized views instead of the combination of the original base relations. We also show the experimental results in which both time and space cost are approximately 1.8 times better than the conventional algorithms.

  • PDF

A Comparison Study between Korean and Foreign Shipping Liners on Logistics Service Attributes and Capability (국적선사와 외국적선사의 물류서비스 속성과 역량에 관한 비교 연구)

  • Lee, Sang-Yoon;Ko, Hyun-Jeung
    • Journal of Korea Port Economic Association
    • /
    • v.22 no.3
    • /
    • pp.141-160
    • /
    • 2006
  • In order to obtain and maintain competitive advantage, under rapidly changing maritime environment, liners should make efforts to reinforce their logistics service capabilities. Most of all, for this, shipping lines should accurately recognize and evaluate their logistics service attributes. In the present research, various logistics service attributes for ocean carriers were selected from previous studies and the observed data for 6 main service attributes were collected through a questionnaire survey to 31 maritime experts. Moreover, shipping lines' relative logistics service capabilities were measured by an additional survey process. The comparative gravity between core evaluation factors were measured by AHP technique and the relative capability levels of 2 Korean liners and 5 foreign shipping companies were assessed by utilizing a fuzzy model. The empirical result presents that Korean liners are superior at customer service capability but inferior at freight rate competitiveness. This research shows that Korean liners are ranked at high position for overall logistics service capabilities and focusing on the differentiation strategy but not on the cost related strategy.

  • PDF

A Standardized Management Plan on the Characteristic Factor of Station to Meet a Customer Service in the Urban Transit (도시철도 고객서비스 만족을 위한 역 특성요소의 표준화 관리방안)

  • Kang, Tae-Soo;Kim, Seong-Ho;Bae, Kyung-Suk
    • Journal of the Korean Society for Railway
    • /
    • v.15 no.3
    • /
    • pp.300-305
    • /
    • 2012
  • The saving of time, which is defined as the demand from passengers and the supply from the urban railway, must be balanced. The selected factors influencing on the balance are the traffic, customer contact facilities, the number of failures, customer complaints(VOC), passenger moving time and transfer stations. Also, the overall ratio of SMRT's 4 lines is generated by differentiating the rate of each attribute in each factor. This is not only to differentiate the stations with peculiar factors but also to standardize criteria of the personalized services. Furthermore, as part of standardization, standard drawings of facility management are prepared for the improvement on the management of human resource and material. The drawings include passenger moving lines, location of safety incidents and also indicate the rating of the factors in each station and overall evaluation rating. In conclusion, this thesis aims to improve customer satisfaction constantly by reducing passenger moving time, through the differentiated management of each station.

Study on the Image of Gyeonggi-do Governor Lee Jae Myeong through Q-methodology (이재명 경기도지사의 이미지에 대한 연구 : Q방법론적 접근)

  • Ahn, Lee-Su
    • The Journal of the Korea Contents Association
    • /
    • v.18 no.11
    • /
    • pp.306-316
    • /
    • 2018
  • This research studies voter's value and attitude reflected by the politician's overall image and scrutinizes the separate structures of the voters' subjectivity on the matter. Objective of the research is to explain the influence that exercises on voters' political actions through this procedure. On this research, there were 32 Q samples that are selected, and they were categorized by a pool of 20 people. Result showed total of 3 different categories of cognition patterns towards Gyeonggi-do Governor Lee Jae Myeong. Of the 3 categories, category 1 (N=4) was a reformer with apparent principles and initiatives, category 2 (N=12) was an efficient tactician with executive ability, and the last category 3 (N=4) was a populist that strives to achieve his political ambition. Opinion of the samples in the first category was that Governor Lee is the right guy for demolishing the barrier between vested class and the non-vesting in the society. Voters in the second category showed expectation for Governor Lee's executive policies that satisfy the voters, given his abilities proven while he was in mayor's office for Seongnam city. People in the pool of category 3 worried that Governor Lee is busy increasing his approval rating and popularity by asserting unrealistic opinions and impractical policies.

Adverse Events of Thread Embedding Acupuncture for the Musculoskeletal Conditions and Diseases: A Narrative Review of Clinical Studies

  • Lee, Ji Sun;Oh, Yoona;Kim, Yeonhak;Lee, Byung Ryul;Yang, Gi Young;Kim, Eunseok
    • Journal of Acupuncture Research
    • /
    • v.39 no.1
    • /
    • pp.10-16
    • /
    • 2022
  • This study aimed to analyze the status of adverse events (AEs) in the treatment of musculoskeletal conditions/diseases using thread embedding acupuncture (TEA). Five electronic databases were searched to retrieve data on clinical studies published in the last 5 years (2016 to 2021). Of the 151 studies retrieved, 22 studies analyzed AEs and were selected for this review. There were no AEs reported in 6 studies (27.3%); of the remaining 16 studies, 4 studies (18.2%) reported AEs that were not related to TEA. The most common AEs reported in the Chinese studies were redness of skin with/without swelling and tingling sensation, and in the Korean studies they were stiffness, a foreign body sensation, and bruising. The percentage of patients with AE experience was 5.1% in the Chinese studies and 19.9% in the Korean studies. The discrepancies between the findings in the Chinese and Korean studies may be attribute to differences in the diameter of needles, thread materials, TEA treatment procedure, and evaluation methods for AEs. Most of the reported AEs were of a mild status and did not last for a long time. However, further research on the clinical course after TEA treatment is needed.

Estimation of Attributes Affecting University Students to Select the Pizza Restaurant by Gender (성별에 따른 대학생의 피자전문점 선택에 영향을 미치는 속성 평가)

  • Kang, Jong-Heon;Jeong, In-Suk
    • Journal of the Korean Society of Food Culture
    • /
    • v.21 no.1
    • /
    • pp.57-64
    • /
    • 2006
  • The purpose of this study was to measure the pizza purchasing behavioral characteristics of respondents and importances of factors affecting pizza purchase, to estimate the effects of attributes on pizza restaurant choice, and to predict probability of selecting a particular pizza restaurant. The questionnaire consisted of two parts: The paired experimental profiles, purchasing behavior and importances of factors affecting pizza purchase. This study generated profiles of 16 hypothetical pizza restaurant based on the seven attributes. The profiles comprised 16 discrete sets of variables, each of which had two levels. For this study, researcher randomly selected 150 students of university as respondents. Twenty students did not complete the survey instrument, resulting in a final sample size of 129. All estimations were carried out using frequencies, $X^2$, independent samples t-test, phreg procedure of SAS package. The results are as follows. Some purchasing behavioral characteristics and importances of factors affecting pizza purchase were significantly different by gender. Based on the estimated models developed for male student group and female student group, the Chi-square statistics were significant at p<0.001. The parameter estimate for late delivery time with male student group was highest, and the parameter estimate for price with female student group was highest. The pizza restaurant that charged \20,000, offered 100% discount on eleventh pizza, promised to deliver pizza in 40 mins, usually delivered the pizza as promised time, offered only 1 type of pizza crust, delivered warm pizza, offered the money-back guarantee was favored by each of male student group and female student group. The results from this study suggested that there was an opportunity to increase market share and profit by improving operations so that customers receive discount and money-back guarantee simultaneously, and by reducing price, delivery time.

Generation of Pseudo Porosity Logs from Seismic Data Using a Polynomial Neural Network Method (다항식 신경망 기법을 이용한 탄성파 탐사 자료로부터의 유사공극률 검층자료 생성)

  • Choi, Jae-Won;Byun, Joong-Moo;Seol, Soon-Jee
    • Journal of the Korean earth science society
    • /
    • v.32 no.6
    • /
    • pp.665-673
    • /
    • 2011
  • In order to estimate the hydrocarbon reserves, the porosity of the reservoir must be determined. The porosity of the area without a well is generally calculated by extrapolating the porosity logs measured at wells. However, if not only well logs but also seismic data exist on the same site, the more accurate pseudo porosity log can be obtained through artificial neural network technique by extracting the relations between the seismic data and well logs at the site. In this study, we have developed a module which creates pseudo porosity logs by using the polynomial neural network method. In order to obtain more accurate pseudo porosity logs, we selected the seismic attributes which have high correlation values in the correlation analysis between the seismic attributes and the porosity logs. Through the training procedure between selected seismic attributes and well logs, our module produces the correlation weights which can be used to generate the pseudo porosity log in the well free area. To verify the reliability and the applicability of the developed module, we have applied the module to the field data acquired from F3 Block in the North Sea and compared the results to those from the probabilistic neural network method in a commercial program. We could confirm the reliability of our module because both results showed similar trend. Moreover, since the pseudo porosity logs from polynomial neural network method are closer to the true porosity logs at the wells than those from probabilistic method, we concluded that the polynomial neural network method is effective for the data sets with insufficient wells such as F3 Block in the North Sea.

Development of Korean Green Business/IT Strategies Based on Priority Analysis (한국의 그린 비즈니스/IT 실태분석을 통한 추진전략 우선순위 도출에 관한 연구)

  • Kim, Jae-Kyeong;Choi, Ju-Choel;Choi, Il-Young
    • Asia pacific journal of information systems
    • /
    • v.20 no.3
    • /
    • pp.191-204
    • /
    • 2010
  • Recently, the CO2 emission and energy consumption have become critical global issues to decide the future of nations. Especially, the spread of IT products and the increased use of internet and web applications result in the energy consumption and CO2 emission of IT industry though information technologies drive global economic growth. EU, the United States, Japan and other developed countries are using IT related environmental regulations such as WEEE(Waste Electrical and Electronic Equipment), RoHS(Restriction of the use of Certain Hazardous Substance), REACH(Registration, Evaluation, Authorization and Restriction of CHemicals) and EuP(Energy using Product), and have established systematic green business/IT strategies to enhance the competitiveness of IT industry. For example, the Japan government proposed the "Green IT initiative" for being compatible with economic growth and environmental protection. Not only energy saving technologies but energy saving systems have been developed for accomplishing sustainable development. Korea's CO2 emission and energy consumption continuously have grown at comparatively high rates. They are related to its industrial structure depending on high energy-consuming industries such as iron and steel Industry, automotive industry, shipbuilding industry, semiconductor industry, and so on. In particular, export proportion of IT manufacturing is quite high in Korea. For example, the global market share of the semiconductor such as DRAM was about 80% in 2008. Accordingly, Korea needs to establish a systematic strategy to respond to the global environmental regulations and to maintain competitiveness in the IT industry. However, green competitiveness of Korea ranked 11th among 15 major countries and R&D budget for green technology is not large enough to develop energy-saving technologies for infrastructure and value chain of low-carbon society though that grows at high rates. Moreover, there are no concrete action plans in Korea. This research aims to deduce the priorities of the Korean green business/IT strategies to use multi attribute weighted average method. We selected a panel of 19 experts who work at the green business related firms such as HP, IBM, Fujitsu and so on, and selected six assessment indices such as the urgency of the technology development, the technology gap between Korea and the developed countries, the effect of import substitution, the spillover effect of technology, the market growth, and the export potential of the package or stand-alone products by existing literature review. We submitted questionnaires at approximately weekly intervals to them for priorities of the green business/IT strategies. The strategies broadly classify as follows. The first strategy which consists of the green business/IT policy and standardization, process and performance management and IT industry and legislative alignment relates to government's role in the green economy. The second strategy relates to IT to support environment sustainability such as the travel and ways of working management, printer output and recycling, intelligent building, printer rationalization and collaboration and connectivity. The last strategy relates to green IT systems, services and usage such as the data center consolidation and energy management, hardware recycle decommission, server and storage virtualization, device power management, and service supplier management. All the questionnaires were assessed via a five-point Likert scale ranging from "very little" to "very large." Our findings show that the IT to support environment sustainability is prior to the other strategies. In detail, the green business /IT policy and standardization is the most important in the government's role. The strategies of intelligent building and the travel and ways of working management are prior to the others for supporting environment sustainability. Finally, the strategies for the data center consolidation and energy management and server and storage virtualization have the huge influence for green IT systems, services and usage This research results the following implications. The amount of energy consumption and CO2 emissions of IT equipment including electrical business equipment will need to be clearly indicated in order to manage the effect of green business/IT strategy. And it is necessary to develop tools that measure the performance of green business/IT by each step. Additionally, intelligent building could grow up in energy-saving, growth of low carbon and related industries together. It is necessary to expand the affect of virtualization though adjusting and controlling the relationship between the management teams.

Building a Web-Based Undesignated Cultural Heritages Management Information System - A Case Study of the Namsan Area in Kyeongju - (웹을 이용한 비지정 문화재 관리 시스템 구축 - 경주 남산 지역을 중심으로 -)

  • Jo, Myung-Hee;Jang, Sung-Hyun;Kim, Hyoung-Sub
    • Journal of the Korean Association of Geographic Information Studies
    • /
    • v.15 no.4
    • /
    • pp.151-161
    • /
    • 2012
  • The purpose of this study was to build a web-server for culture heritages management information system in order to efficiently manage and safely preserve undesignated cultural properties in the Namsan area in Kyeongju, which have been neglected so far. In order to achieve this purpose, data were collected on the basis of undesignated cultural properties in the study area. To acquire the location and range GPS were used and spatial data including geographic coordinates, visual materials and structured interviews were conducted through field survey. In addition, in order to obtained reliable and accurate locations of undesignated cultural properties which are scattered, DGPS(Differential Global Positioning System) were used. The spatial database was constructed based on the standard of cultural properties and attribute data was linked to geo-spatial information(digital map and aerial photographs). This system was built in a web-server environment. The result shows detailed description on the selected output for selected location and property information can be located on the map. In particular, a database to search for the status and modification of cultural properties will provide information to the users.

The Estimation of Tree Form Index for Major Canopy Species in the Natural Deciduous Forest (천연활엽수림(天然闊葉樹林) 주요(主要) 상층(上層) 임관(林冠) 수종(樹種)의 임목(林木) 형질(形質) 지수(指數) 추정(推定))

  • Kim, Ji Hong;Yang, Hee Moon
    • Journal of Forest and Environmental Science
    • /
    • v.15 no.1
    • /
    • pp.1-9
    • /
    • 1999
  • Noticing the intrinsic growing habit variations of hardwood species which is indigenous to the natural deciduous forest, eighteen tree species in overstory were selected for comparative evaluating tree form so as to develop the tree form index (TFI). Selected six tree form attributes were arbitrarily divided four assessment criteria and given appropriate scores. Eighteen tree species were undergone corresponding scores, converted to percentage base, and estimated TFI by the summation of the six scoring values. Cluster analysis was carried out to review which attribute would have been shared among species based on dissimilarity of scores for each pair of species in $18{\times}6$ data matrix. The result showed that Populus davidiana had the highest TFI value of 80.8 and Carpinus cordata had the lowest TFI va1ue of 46.3. The species which received more than 70 of TFI are Populus davidiana, Betula costata, Fraxinus mandshurica, and Ulmus davidiana var. japonica, characterized by the advantage of straight and longer bole, the narrower crown, and the thinner branch. On the contrary, such species as Sorbus alnifolia. Prunus sargentii, Acer mandshuricum, Juglans mandshurica, and Carpinus cordata received less than 60 of TFI, characterized by the disadvantage of the crooked or forked stem. the wider or deeper crown. and the thicker branch. In the dendrogram produced by cluster analysis, arbitrary value of Euclidean distance 10 divided eighteen species into four distinctive groups. and the typical characteristics of each group were discussed.

  • PDF