• Title/Summary/Keyword: order selection

Search Result 3,286, Processing Time 0.03 seconds

ASVMRT: Materialized View Selection Algorithm in Data Warehouse

  • Yang, Jin-Hyuk;Chung, In-Jeong
    • Journal of Information Processing Systems
    • /
    • v.2 no.2
    • /
    • pp.67-75
    • /
    • 2006
  • In order to acquire a precise and quick response to an analytical query, proper selection of the views to materialize in the data warehouse is crucial. In traditional view selection algorithms, all relations are considered for selection as materialized views. However, materializing all relations rather than a part results in much worse performance in terms of time and space costs. Therefore, we present an improved algorithm for selection of views to materialize using the clustering method to overcome the problem resulting from conventional view selection algorithms. In the presented algorithm, ASVMRT (Algorithm for Selection of Views to Materialize using Reduced Table), we first generate reduced tables in the data warehouse using clustering based on attribute-values density, and then we consider the combination of reduced tables as materialized views instead of a combination of the original base relations. For the justification of the proposed algorithm, we reveal the experimental results in which both time and space costs are approximately 1.8 times better than conventional algorithms.

사업자 사전 선택제 도입 사례와 시사점

  • 유영상
    • Proceedings of the Korea Technology Innovation Society Conference
    • /
    • 2002.11a
    • /
    • pp.45-57
    • /
    • 2002
  • Since a new entrant in the telecommunications market requires time in order to construct its own network, a requirement on the incumbent operator to implement carrier selection and pre-selection can enable a new entrant to immediately attract customers and earn revenue. Carrier selection can normally be accomplished in two ways, on a call-by-call basis or through carrel pre-selection. Call-by-call selection allows customers to choose a new entrant rather than the incumbent carrier using a specific code designated to the new carrier each time a call is made. Carrier Pre-Selection, on the other hand, allows customers directly connect to the network of one provider to have access automatically to another company's services when they pick up the phone to make certain types of calls. The carrier pre-selection option is generally considered to be a second regulatory step following the implementation of the call-by-call carrier selection option. Carrier pre-selection with the ability to override on a call-by-call basis for long distance, international, local, and fixed-to-mobile calls has now been implemented in many EU countries. This paper attempts to identify the issues in introducing CPS and to draw policy implications from other countries' experiences.

  • PDF

The Effect of Food Service Franchise Selection Factors on Brand Loyalty and Revisit Intention - Focusing on Consumer Survey in Tokyo - (외식 프랜차이즈 선택요인이 브랜드 충성도와 재방문의도에 미치는 영향 연구 -동경(東京)지역 한국 외식 프랜차이즈를 이용하는 소비자 설문조사를 중심으로-)

  • Kim, Seon-Hyen;Hwang, Jae-Hyun
    • Korean Journal of Organic Agriculture
    • /
    • v.25 no.4
    • /
    • pp.663-677
    • /
    • 2017
  • As Korean food service franchise companies sought to advance into around 2,000 new foreign markets, the importance of global management was emphasized. They intensively expanded into Chinese and American markets in 2015 and these two markets account for approximately 40% of total food service franchise companies in foreign countries. Although Japan has huge franchise market, Korean food service franchise companies in Japan only account for 5% of total franchise companies in Asian countries. The purpose of this study is to analyze the relationship between food service franchise selection factors, brand loyalty, and revisit intention of Japanese consumers using Korean food service franchise companies in Japanese food service market, and based on the analysis results, draw the implications for the expansion of Korean food service franchise companies into the Japanese market. Food service franchise selection factors is defined as service and cleanliness, taste, safety and reliability, cost and convenience, and professionalism. The study results can be summarized as follows. First, analysis was performed to identify the effects of food service franchise selection factors on the brand loyalty, it showed that five food service franchise selection factors including professionalism, service and cleanliness, cost and convenience had positive (+) effects on the brand loyalty. One of the most important factors influencing the brand loyalty is professionalism. In order to raise food service franchise's professionalism, it is necessary for the food service franchise companies to establish stronger strategies containing professional operation systems and services compared to general restaurants. Second, analysis was performed to identify the effects of food service franchise selection factors on revisit intention, five food service franchise selection factors, service and cleanliness, safety and reliability, and cost and convenience had positive (+) effects on revisit intention. One of the most important factors influencing revisit intention is safety and reliability. Thus, in order to raise safety and reliability it is important to form trust with consumers by properly utilizing systems of food hygiene and food safety accreditation.

Feature Selection of Fuzzy Pattern Classifier by using Fuzzy Mapping (퍼지 매핑을 이용한 퍼지 패턴 분류기의 Feature Selection)

  • Roh, Seok-Beom;Kim, Yong Soo;Ahn, Tae-Chon
    • Journal of the Korean Institute of Intelligent Systems
    • /
    • v.24 no.6
    • /
    • pp.646-650
    • /
    • 2014
  • In this paper, in order to avoid the deterioration of the pattern classification performance which results from the curse of dimensionality, we propose a new feature selection method. The newly proposed feature selection method is based on Fuzzy C-Means clustering algorithm which analyzes the data points to divide them into several clusters and the concept of a function with fuzzy numbers. When it comes to the concept of a function where independent variables are fuzzy numbers and a dependent variable is a label of class, a fuzzy number should be related to the only one class label. Therefore, a good feature is a independent variable of a function with fuzzy numbers. Under this assumption, we calculate the goodness of each feature to pattern classification problem. Finally, in order to evaluate the classification ability of the proposed pattern classifier, the machine learning data sets are used.

Effect of Menu Reliability on Consumer Satisfaction at Rice Cake Cafe using Domestically Grown Agricultural Products - Focus on Jeonju Hanok Village - (국내산 농산물을 사용한 떡 카페 메뉴에 대한 신뢰가 소비자 만족에 미치는 영향 - 전주 한옥마을을 중심으로 -)

  • Kim, Su In
    • Journal of the East Asian Society of Dietary Life
    • /
    • v.25 no.5
    • /
    • pp.922-931
    • /
    • 2015
  • To investigate and analyze the influence of trust on consumer satisfaction in rice cake cafe menus using domestically grown food ingredients, this study divided selection attributes of rice cake cafe menus into safety, nutrition, ethicality and marketability through an exploratory factor analysis and analyzed reliability and correlation among these variables. As a result, these four factors were adopted as selection factors, and the results of the correlation analysis among the variables showed that the four factors were statistically correlated with trust and customer satisfaction. The result of validity and reliability testing on consumer trust showed that the menus were reliable and trustworthy as they had been made using domestically grown agricultural products. Analysis of how cafe selection attributes affect trust showed that the these variables had a significantly positive influence on trust in the order of safety, marketability, nutrition, and ethicality. The influence of the selection attributes on customer satisfaction was statistically significant, and the independent variables had a significantly positive influence on trust in the order of marketability, ethicality, safety, and nutrition. In verifying the mediation effect of trust on customer satisfaction, the four factors of rice cake cafe selection attributes had statistically significant mediation effects.

Acoustic Signal based Optimal Route Selection Problem: Performance Comparison of Multi-Attribute Decision Making methods

  • Borkar, Prashant;Sarode, M.V.;Malik, L. G.
    • KSII Transactions on Internet and Information Systems (TIIS)
    • /
    • v.10 no.2
    • /
    • pp.647-669
    • /
    • 2016
  • Multiple attribute for decision making including user preference will increase the complexity of route selection process. Various approaches have been proposed to solve the optimal route selection problem. In this paper, multi attribute decision making (MADM) algorithms such as Simple Additive Weighting (SAW), Weighted Product Method (WPM), Analytic Hierarchy Process (AHP) method and Total Order Preference by Similarity to the Ideal Solution (TOPSIS) methods have been proposed for acoustic signature based optimal route selection to facilitate user with better quality of service. The traffic density state conditions (very low, low, below medium, medium, above medium, high and very high) on the road segment is the occurrence and mixture weightings of traffic noise signals (Tyre, Engine, Air Turbulence, Exhaust, and Honks etc) is considered as one of the attribute in decision making process. The short-term spectral envelope features of the cumulative acoustic signals are extracted using Mel-Frequency Cepstral Coefficients (MFCC) and Adaptive Neuro-Fuzzy Classifier (ANFC) is used to model seven traffic density states. Simple point method and AHP has been used for calculation of weights of decision parameters. Numerical results show that WPM, AHP and TOPSIS provide similar performance.

An Efficient Decision Maki ng Method for the Selectionof a Layered Manufacturing (3차원 조형장비 선정을 위한 효율적인 의사결정 방법)

  • Byun, Hong-Seok
    • Transactions of the Korean Society of Machine Tool Engineers
    • /
    • v.18 no.1
    • /
    • pp.59-67
    • /
    • 2009
  • The purpose of this study is to provide a decision support to select an appropriate layered manufacturing(LM) machine that suits the application of a part. Selection factors include concept model, form/fit/functional model, pattern model far molding, material property, build time and part cost that greatly affect the performance of LM machines. However, the selection of a LM is not an easy decision because they are uncertain and vague. For this reason, the aim of this research is to propose hybrid multiple attribute decision making approaches to effectively evaluate LM machines. In addition, because subjective considerations are relevant to selection decision, a fuzzy logic approach is adopted. The proposed selection procedure consists of several steps. First, we identify LM machines that the users consider After constructing the evaluation criteria, we calculate the weights of the criteria by applying the fuzzy Analytic Hierarchy Process(AHP) method. Finally, we construct the fuzzy Technique of Order Preference by Similarity to Ideal Solution(TOPSIS) method to achieve the ranking order of all machines providing the decision information for the selection of LM machines.

Integrated Supply Chain Model of Advanced Planning and Scheduling (APS) and Efficient Purchasing for Make-To-Order Production (주문생산을 위한 APS 와 효율적 구매의 통합모델)

  • Jeong Chan Seok;Lee Young Hae
    • Proceedings of the Korean Operations and Management Science Society Conference
    • /
    • 2002.05a
    • /
    • pp.449-455
    • /
    • 2002
  • This paper considers that advanced planning and scheduling (APS) in manufacturing and the efficient purchasing where each customer order has its due date and multi-suppliers exit We present a Make-To­Order Supply Chan (MTOSC) model of efficient purchasing process from multi-suppliers and APS with outsourcing in a supply chain, which requires the absolute due date and minimized total cost. Our research has included two states. One is for efficient purchasing from suppliers: (a) selection of suppliers for required parts; (b) optimum part lead­time of selected suppliers. Supplier selection process has received considerable attention in the business­management literature. Determining suitable suppliers in the supply chain has become a key strategic consideration. However, the nature of these decisions usually is complex and unstructured. These influence factors can be divided into quantitative and qualitative factors. In the first level, linguistic values are used to assess the ratings for the qualitative factors such as profitability, relationship closeness and quality. In the second level a MTOSC model determines the solutions (supplier selection and order quantity) by considering quantitative factors such as part unit price, supplier's lead-time, and storage cost, etc. The other is for APS: (a) selection of the best machine for each operation; (b) deciding sequence of operations; (c) picking out the operations to be outsourcing; and (d) minimizing makespan under the due date of each customer's order. To solve the model, a genetic algorithm (GA)-based heuristic approach is developed. From the numerical experiments, GA­based approach could efficiently solve the proposed model, and show the best process plan and schedule for all customers' orders.

  • PDF

A Fuzzy TOPSIS Approach Based on Trapezoidal Numbers to Material Selection Problem

  • Celik, Erkan;Gul, Muhammet;Gumus, Alev Taskin;Guneri, Ali Fuat
    • Journal of Information Technology Applications and Management
    • /
    • v.19 no.3
    • /
    • pp.19-30
    • /
    • 2012
  • Material selection is a complex problem in the design and development of products for diverse engineering applications. This paper is aimed to present a fuzzy decision making approach to deal with the material selection in engineering design problems. A fuzzy multi criteria decision-making model is proposed for solving the material selection problem. The proposed model makes use of fuzzy TOPSIS (Technique for Order reference by Similarity to Ideal Solution) with trapezoidal numbers for evaluating the criteria and ranking the alternatives. And result is compared with fuzzy VIKOR (VlseKriterijumska Optimizacija I Kompromisno Resenje in Serbian, means Multi criteria Optimisation and Compromise Solution) which is proposed by Jeya Girubha and Vinodh [2012]. The present paper is aimed to also improve literature of fuzzy decision making for material selection problem.

Design and Analysis of Linear Channel-Selection Filter for Direct Conversion Receiver

  • Jin, Sang-Su;Ryu, Seong-Han;Kim, Hui-Jung;Kim, Bum-Man;Lee, Jong-Ryul
    • JSTS:Journal of Semiconductor Technology and Science
    • /
    • v.4 no.4
    • /
    • pp.293-299
    • /
    • 2004
  • An active RC 2nd order Butterworth filter suitable for a baseband channel-selection filter of a direct conversion receiver is presented. The linearity of the 2nd order Butterworth filter is analyzed. In order to improve the linearity of the filter, the operational amplifiers should have a high linear gain and low 3rd harmonic, and the filter should be designed to have large feedback factor. This second order Butterworth filter achieves-14dBV in-channel (400kHz, 500kHz) IIP3, +29dBV out-channel (10MHz, 20.2MHz) IIP3 and 15.6 $nV/\sqrt{Hz}$ input-referred noise and dissipates 10.8mW from a 2.7-V supply. The analysis and experimental results are in good agreement