• Journal of KIISE:Databases
• /
• v.34 no.1
• /
• pp.18-34
• /
• 2007

In order to provide various business analysis methods, OLAP(On-Line Analytical Processing) systems represent their data with multidimensional structures. These multidimensional data are often delivered to users in the horizontal format of tables whose columns are corresponding to values of dimension attributes. Since the horizontal tables nay have a large number of columns, they cannot be stored directly in relational database systems. Furthermore, the tables are likely to have many null values (i.e., sparse tables). In order to manage the horizontal tables efficiently, we can store them as the vertical format of tables which has dimension attribute names as their columns thus transforms the columns of horizontal tables into rows. In this way, every queries for horizontal tables have to be transformed into those for vertical tables. This paper proposed a technique for transforming horizontal table queries into vertical table ones by utilizing not only traditional relational algebraic operators but also the PIVOT operator which recent DBMS versions are providing. For achieving this goal, we designed a relational algebraic expression equivalent to the PIVOT operator and we formally proved their equivalence. Then, we developed a transformation technique for horizontal table queries using the PIVOT operator. We also performed experiments to analyze the performance of the proposed method. From the experimental results, we revealed that the proposed method has better performance than existing methods.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.23 no.3
• /
• pp.293-301
• /
• 2005

In case of the roads that pass the mountain area, the cut sections or the tunnels are constructed. And In winter season it appears sunshine few in the specific segment, the shade is continued last and the freezing sections occur. So, the attention is necessary in traffic safety. This study was to evaluate the influence of sunshine and surface freezing sections expected in route plans of roads using GIS and makes alternative ideas in road stability security. After selecting 29 km sections of Donghae highway and creating a 3 dimensional terrain surface through the digital conversion of design plan data, it reflects the road alignment data of the same coordinates and a 3 dimensional road modeling is created. It set shadow time of road surface for the solar trace in the winter solstice in 20 minute interval. Shade areas are displayed and inputed in polygon data by manual vertorizing. Graphic and attribute data of this shade section is constructed in geodatabase of ArcCatalog. And it extracted the freezing section using intersect fuction of the GIS spatial analysis. By analyzing the winter meteorological data of temperature, rainfall, snowfall, humidity, and etc. and grasping dangerous freezing section of the road surface effectively, it will be able to make alternative ideas of the preliminary stability evaluation reflected in basic design.

• Journal of the Korean Society of Surveying, Geodesy, Photogrammetry and Cartography
• /
• v.34 no.3
• /
• pp.329-338
• /
• 2016

As the need of indoor spatial information has grown, many applications have been developed. Nevertheless, the major representations of indoor spatial information are on the 2D or 3D, recently, the service based on omni-directional image has increased. Current service based on omni-directional image is used just for viewer. To provide various applications which can serve the identifying the attribute of indoor space, query based services and so on, topological data which can define the spatial relationships between spaces is required. For developing diverse applications based on omni-directional image, this study proposes the method to generate IndoorGML data which is the international standard of indoor topological data model. The proposed method is consist of 3 step to generate IndoorGML data; 1) Analysis the core elements to adopt IndoorGML concept to image, 2) Propose the method to identify the element of ‘Space’ which is the core element of IndoorGML concept, 3) Define the connectivity of indoor spaces. The proposed method is implemented at the 6-floor of 21centurybuilding of the University of Seoul to generate IndoorGML data and the demo service is implemented based on the generated data. This study has the significance to propose a method to generate the indoor topological data for the indoor spatial information services based on the IndoorGML.

• Journal of the Korea Academia-Industrial cooperation Society
• /
• v.21 no.2
• /
• pp.103-114
• /
• 2020

On-arrival duty free will prevent Korean outbound passengers from keeping the duty free items they purchased at the departure during their travel. Most Korean tourists have requested the airport authority to install on-arrival duty free since the grand-opening of Incheon int'l airport. Considering the fierce hub airport competition in the North East Asian region, the Korean government's decision to install on-arrival duty free is regarded as a well-timed intervention. The purpose of the research was to analyze sales correlation based on a comparison of sales of both departure and on-arrival duty free and to propose an administrative implication. Compared to business conglomerates running departure duty free, on-arrival duty free operators, who are small or medium companies, have weakness in product composition, marketing, and merchandising capabilities. According to the analysis, outbound passengers, who purchased fashion accessories and leather products at the departure duty free, tended to purchase cosmetics/perfume or liquor on the arrival duty free. Such complementary purchasing behavior of passengers showed there is barely a negative correlation between departure and on-arrival duty free.

• Journal of Distribution Science
• /
• v.12 no.2
• /
• pp.49-57
• /
• 2014

Purpose - Theorists and researchers in the area of customer satisfaction generally agree that product satisfaction intervenes between expectancy disconfirmation and various post-purchase cognitive states including attitude and behavioral intention. Studies in a variety of settings have supported the effect of expectation and its disconfirmation on satisfaction, but only a small number of studies address the cognitive consequences of satisfaction decisions and none report data on choice processes such as brand selection. This study examines the influence of satisfaction and its determinants on behavioral intention and product preference in eight coffee shops across the country. Generally it was found in both overall and summed attribute analyses that satisfaction was a function of expectation and disconfirmation, that intention was a function of satisfaction, and that preference was influenced by satisfaction and disconfirmation, the latter having the greater effect. Research design, data, and methodology - The main objective of this study was to assess the dimensions of consumer selection and satisfaction in choosing a coffee shop. In order to achieve this objective, a study of coffee shops across the country was conducted. This study comprised in-depth questionnaires distributed to coffee shop customers. A survey was conducted from September 1, 2011 to September 30, 2011, involving franchise coffee shop, independently owned coffee shop, and roastery coffee shop customers. Results - Hypothesis 1-1, which states that coffee shop choice attributes differ based on the type of coffee shop, is accepted. It has a significance level of 0.05, according to choosing properties of coffee shop by convenience of transportation, varieties of beans, residence of the owner (manager), information, and relationships. Hypothesis 1-2, which states that satisfaction with the choice factor differs depending on the type of coffee shops, is accepted. The P-values for cleanliness and varieties of beans were 0.04 and 0.00, respectively, and have a significance level of 0.05, according to the satisfaction with the chosen coffee shop. Hypothesis 2-1, which states that the importance of the choice attributes in coffee shop selections differs based on the demographic characteristics of the customers, is accepted. According to the t-test result, convenience of parking and residence of the owner (manager) are significant. Hypothesis 2-2, which states that satisfaction with the choice factor will differ depending of the type of coffee shop, is accepted. According to the t-test result, convenience of parking and residence of the owner (manager) are significant. Conclusions - This study has shown that intention to revisit a certain shop is most likely correlated to satisfaction in all cases. In order to offer subsequent developments for coffee shops, this study also identifies relations between customer satisfaction and selection by finding significant factors. In order to maximize customers' satisfaction, coffee shops should analyze and satisfy customers' needs and wants in terms of coffee service. While the findings do not generalize beyond the mall sampling procedure used here, we have hopefully identified a close approximation of the process of satisfaction decisions used by consumers generally.

• The Journal of the Korea Contents Association
• /
• v.20 no.9
• /
• pp.549-557
• /
• 2020

Recently, the number of coffee shops has continued to increase, and information searches have been increasing for consumers who want to visit coffee shops. We wanted to find out the impact on the intention of revisiting a coffee shop by adding information search factors to the existing coffee shop's selection properties and search for the actual selection properties, and summarize the results as follows. The analysis of this study was conducted in two ways, before and after visiting a coffee shop through information search. First, the four factors and optional attributes that are important in information retrieval were the reliability of information (the number of reviews and views by coffee shops, recent postings), physical environment (the proximity of stores, the atmosphere, size, presence of side menus), visuality of information (physical environment, background, design, easy composition), merchantability (the taste of coffee, convenience of parking). In addition, the selection properties for satisfaction after visiting coffee shops through information search were derived from five general characteristics of coffee shops, menu, information consistency, taste of coffee, and convenience of parking, and among them, the consistency of information, taste of coffee, and general characteristics of coffee were found to affect the intention of revisiting again.

• International Journal of Highway Engineering
• /
• v.13 no.1
• /
• pp.1-11
• /
• 2011

This study is aimed at suggesting a plan for creating a landscape environment by grasping a landscape preference according to the change of middle span and sag ratio which is a consideration factor when designing the suspension bridge representing long-span bridges and image property of the bridge while applying SD method to a relation between landscape preference and image factor, and a connection of design element with image factor. An analysis on landscape preference about the bridge landscape showed from what the longer the length of middle span, the extent of sag ratio of preference decreased, the longer the middle span low sag ratio was preferred and the higher the landscape preference became. In landscape preference and image factor, the attribute of sag ratio with high landscape preference was all positively correlated with "stability", "plasticity", and "aesthetic" but an influence of "plasticity" was insignificant. In the relation between design element and image factor, the factor of middle span and sag ratio was more related to the factor of "stability" and the lower the sag ratio and the longer the middle span, the higher the "stability" was rated. This result showed the image property of "plasticity" was insignificant among the one of preference in landscape and to highlight the one of "plasticity" a complementary experiment was done with a change in balance and symmetry elements not in proportional element of middle span and sag ratio. The result showed the image property of "plasticity" was more highlighted in the suspension bridge of 3-tower and different bilateral symmetry at sag, and when designing the landscape of suspension bridge later on, the elements of balance and symmetry as well as the proportional element should be considered and reflected in the design.

• The Journal of Society for e-Business Studies
• /
• v.13 no.4
• /
• pp.111-124
• /
• 2008

The development in information technology allowed most of the information around us into digital information, in other words, a database. The innovation increased the accessibility and helped this society change into an informational age. However, there is a shortcoming of this open source as the users have difficulty in assorting the information that s/he needs and realizing if the information provided is important. Therefore, the need for search engine has risen in such a way to increase the accessibility and facilitation of information provided to the users through searching the necessary information in the database by an easy and accurate way. This aim of study should propose the important design attribute to increase the utilization of search engine through relationship analysis between purpose of user and interface design factors of search engine. In other words, these attributes, as design guideline, could apply to the search engine interface design considering of user's search goal. For this, the purpose in using the search engine and types of search engine interfaces were categorized and correlated the relationships. The search engine interface suggested from the result provides interface that allows efficient search for desired information and embrace a variety in users, eventually increasing the usability in search engine.

• Culinary science and hospitality research
• /
• v.23 no.2
• /
• pp.86-94
• /
• 2017

This study was conducted to derive a positioning map using multidimensional scaling method to understand how the brand image of national foods including Korean food, Chinese food, Japanese food, Thai food, and Vietnamese food is perceived by domestic and foreign tourists. In order to achieve the research purpose, this study collected 250 data through online and offline surveys for potential food tourists who are interested in visiting overseas. Except the unfaithful responses or missing values, 202 data were analyzed. As a result, first, 8 factors which are considered to be important by food tourists were extracted. Second, the result of similarity analysis using ALSCAL and PROXSCAL did not show that the foods of the five countries were very similar, but all countries seemed to be more likely to compete with each other. Third, attribute selection also indicates that mean value of food taste (3.88), national image (3.82), and sufficient food quantity (3.65) had high level of importance, respectively. These results may provide practical implications for development of branding strategy in food tourism.

• Culinary science and hospitality research
• /
• v.17 no.4
• /
• pp.104-120
• /
• 2011

This study is to make an empirical analysis of star marketing used as die means of sales promotion for Christmas cakes regardless of high advertising cos1s, by understanding the influence of attributes of celebrity advertising models for advertisements of bakery companies over die Christmas season on advertising attitude, corporation reputation and reliability which are recognized by consumers. The verification results were judged as important core elements for successful management in bakery industry. Since bakery brands are losing their differentiations in both functional and physical aspects, the study aimed to offer strategic suggestions to bakery industry. The result of study modelling were GFI=0.911, AGFI=0.887, NFI=0.935, CFI=0.979, RMR=.126 at the level of $x^2$=313.294(df-=218, p<0.001). First, model credibility and model attractiveness of advertising models bad a positive(+) influence on advertising attitude. Second, advertising attitude bad a positive(+) influence on corporation reputation and reliability. Third, corporate reputation also bad a positive(+) influence on corporate reliability.