• Journal of the Korea Society of Computer and Information
• /
• v.12 no.1 s.45
• /
• pp.177-188
• /
• 2007

A star schema consists of a central fact table, which is surrounded by one or more dimension tables. Each row in the fact table contains a multi-part primary key(or a composite foreign key) along with one or more columns containing various facts about the data stored in the row. Each of the composit foreign key components is related to a dimensional table. The combination of keys in the fact table creates a composite foreign key that is unique to the fact table record. The composite foreign key, however, is rarely unique to the fact table retold in real-world applications, particularly in financial applications. In order to make the composite foreign key be the determinant in real-world application, some precalculation might be performed in the SQL relational database, and cached in the OLAP database. However, there are many drawbacks to this approach. In some cases, this approach might give users the wrong results. In this paper, an approach to fact table modeling and related MDX query composing, which can be used in real-world applications without performing any precalculation and gives users the correct results, is proposed.

• Archives of design research
• /
• v.17 no.1
• /
• pp.153-162
• /
• 2004

This paper focused on the effect of Kansei design on the web in branding as well as its influence factors. As a key of this research, it classified web users' Kansei into five categories; 1) functional Kansei, 2) sensoryKansei, 3) psychological Kansei, 4) relational Kansei and 5) cultural Kansei, and organized relevant factors. Online surveys were conducted on seven websites of the fast food brands in Korea (Lotteria, Mcdonald, BurgerKing, Popeyes, KFC, Pizza Hut, Domino's) which are targeting 463 male and females in 20s. As a result, an average of 58% responded that they had a positive Kansei experience and could enhanceits brand preference. Of the sensory Kansei, visual design factors were the one that gave the greatest effect on brand preference enhancement. Regarding the functional Kansei satisfaction, such as user convenience and access speed were also one of the most crucial variables for the whole Kansei satisfaction. Moreover, the preference enhancement brought not only a positive effect on its reliability but also its brand image and consumers' purchasing desire. Based on the survey results, the additional FGI (Focus Group Interview) had been conducted and determined \circled1 what kind of major Kansei that users wanted to have satisfied, \circled2 what type of design can give strong Kansei appeal to its users, and \circled3what design factors gave an effect on sensory emotion. In the course of this research, Itried to renew the awareness of the web importance as a major channel in non-mass interactive marketing, and suggest the effect and its possibility of emotional branding through Kansei design in the web as well as design principles of strategic Kansei design.

• Proceedings of the KOSOMBE Conference
• /
• v.1996 no.05
• /
• pp.315-319
• /
• 1996

We have developed a prototype patient monitoring system including module-based bedside units, interbed network, and central stations. A bedside unit consists of a color monitor and a main CPU unit with peripherals including a module controller. It can also include up to 3 module cases and 21 different modules. In addition to the 3-channel recorder module, six different physiological parameters of ECG, respiration, invasive blood pressure, noninvasive blood pressure, body temperature, and arterial pulse oximetry with plethysmogaph are provided as parameter modules. Modules and a module controller communicate with up to 1Mbps data rate through an intrabed network based on RS-485 and HDLC protocol. Bedside units can display up to 12 channels of waveforms with any related numeric informations simultaneously. At the same time, it communicates with other bedside units and central stations through interbed network based on 10Mbps Ethernet and TCP/IP protocol. Software far bedside units and central stations fully utilizes gaphical user interface techniques and all functions are controlled by a rotate/push button on bedside unit and a mouse on central station. The entire system satisfies the requirements of AAMI and ANSI standards in terms of electrical safety and performances. In order to accommodate more advanced data management capabilities such as 24-hour full disclosure, we are developing a relational database server dedicated to the patient monitoring system. We are also developing a clinical workstation with which physicians can review and examine the data from patients through various kinds of computer networks far diagnosis and report generation. Portable bedside units with LCD display and wired or wireless data communication capability will be developed in the near future. New parameter modules including cardiac output, capnograph, and other gas analysis functions will be added.

• International Journal of Advanced Culture Technology
• /
• v.9 no.3
• /
• pp.92-99
• /
• 2021

In this research, it was investigated the competence of Korean salesmen in the insurance business(B2C, consumer goods marketing) and information communication industry(B2B, industrial goods marketing) at the individual level rather than the organizational level. The salesperson's Guanxi ability means the salesperson's ability to create, maintain, develop the Guanxi ability. Namely, it was investigated whether the Korean salesman's Guanxi ability is the effective and persuasive concept in explaining the sales performance(company performance, business performance). The purpose of this paper was to verify which variables, among Guanxi ability and customer orientation, better explain the sales performance of salespeople. The Western concept of marketing that is closest to Guanxi is the concept of the customer-orientation that is based on the theory of relationship exchange. Confucian culture in the East is the construct concept, Guanxi is the measurement. The relational exchange theory in the West is the construct concept, customer orientation is the measurement. As the result of the analysis, we found that the Guanxi proved a greater correlation with sales performance than customer orientation. In the information technology industry, there was a big difference compared to insurance industry, whereas Guanxi and customer orientation had a similar level of correlation with sales performance. In the case of the insurance industry, we found that the Guanxi and sales performance were significant but the customer orientation and sales performance were not. This means that sales performance can be accurately and sufficiently explained only by adding the Guanxi ability in addition to customer orientation. The result of analyzing the mediating effect of the Guanxi ability between customer orientation and company performance, customer orientation was significant with Guanxi, and customer orientation and company performance were also significant. But, when the Guanxi was used as the parameter, the Guanxi was significant with company performance, but the customer orientation was not. Even when the dependent variable was business performance, when the Guanxi was used as the parameter, we found that the Guanxi was significant with the business performance, but the customer orientation was not. Namely, it proved Guanxi ability and customer orientation are completely independent concepts. In addition, we found that the information technology industry, unlike the insurance industry, mediated the Guanxi ability between customer orientation and sales performance. We confirmed that in the future, salespeople should not only rely on rational methods to maintain and reinforce customer relationships, but must consider the emotional factors through empathy with customers.

• 한국사회정책
• /
• v.25 no.2
• /
• pp.57-91
• /
• 2018

Despite the rapid growth of social care, understanding of care is segmental and caring is still marginalizing. The socialization of caring is actually a 'half-socialization' that is the result of injustice surrounding caring. Therefore, it is necessary to approach the problem of caring in terms of justice. In this paper, I discuss the limitations of social justice based on John Rawls 's social contract theory in the discussion of caring justice through feminists'writings on caring ethics. And then applying Nancy Fraser' s three scales of Justice-redistribution, recognition, and representation, the concept of caring justice has been newly constructed. The concept of caring is defined as a unified concept of caring including the aspect of the social rights of the care recipient as well as the labor rights of the care provider. Based on the analysis of care justice, we derive the ideal types of care policy and then evaluate the long-term care policy for the elderly, which is the central axis of Korean care policy. The results of this study are as follows: First, it is necessary to strengthen the labor rights of care providers especially for the socialization of care responsibilities and the proper allocation of social resources. Second, a service delivery system and care culture are needed to ensure the relational autonomy of care-receivers and care-givers for caring ethics and individualization of care. Third, the issue of care should be treated as the central agenda of politics in order to distribute care responsibility democratically and to distribute legitimate resources. This requires a paradigm shift from marginalization of care to mainstreaming of care. Ultimately, we should aim for a Caring Society.

• Journal of Digital Convergence
• /
• v.17 no.8
• /
• pp.15-26
• /
• 2019

This study was to explore the domestic research trends, and education and operation cases concerned with Korean colleges in the fourth industrial revolution era. It was conducted through the analysis of 114 academic papers registered to the Korea Research Foundation, the newspaper articles, and the main 4-year university homepage from 2016 to April 2019. The results was as follows. Research papers have been increasing since 2016; research were conducted by humanities and social sciences as well as engineering academics interesting in research topics such as technologies, curriculum, and teaching and learning by mainly using quantitative research, literature research. As for the college education, reorganization of the undergraduate and majors centered on the science and engineering field, teaching and learning related with learner's participation and performance, and provide efficient academic affairs management and career guidance using Chatbot or Cloud computing. Industry-academia cooperation was focuses on the field of science and engineering. In future research, it is necessary to explore the research on college students' career and employment, the research on academic affairs management and infrastructure, the relational research considering the variables among college students and faculties, and the qualitative and mixed method approach.

• Journal of Korean Library and Information Science Society
• /
• v.52 no.1
• /
• pp.109-128
• /
• 2021

This paper is to explore considerations in authority control to accommodate LRM nomen entities through the literature reviews, the analysis of RDA rules, and the opinion survey of domestic catalog experts. As a result, for authority control, considerations were proposed in the aspect of nomen's attribute elements, catalog description, and MARC authority format. First, it is necessary to describe in as much detail as possible the category, the scheme, intended audience, the context of use, the reference source, the language, the script, the script conversion as the attributes of the nomen with the status of identification, note, and indifferentiated name indicators added in RDA. Second, the description method of attribute elements and relational elements of nomen can be unstructured, structured, identifier, and IRI as suggested in RDA, and vocabulary encoding scheme (VES) and string encoding scheme (SES) should be written for structured description, Also, cataloging rules for structuring authorized access points and preferred names/title should be established. Third, an additional expansion plan based on Maxwell's expansion (draft) was proposed in order to prepare the MARC 21 authority format to reflect the LRM nomen. (1) The attribute must be described in 4XX and 5XX so that the attribute can be entered for each nomen, and the attributes of the nomen to be described in 1XX, 5XX and 4XX are presented separately. (2) In order to describe the nomen category, language, script, script conversion, context of use, and date of usage as a nomen attribute, field and subfield in MARC 21 must be added. Accordingly, it was proposed to expand the subfield of 368, 381, and 377, and to add fields to describe the context of use and date of usage. The considerations in authority control for the LRM nomen proposed in this paper will be the basis for establishing an authority control plan that reflects LRM in Korea.

• Journal of Digital Convergence
• /
• v.19 no.1
• /
• pp.453-463
• /
• 2021

The purpose of this study was to verify the effect of the implicit narcissism of unmarried men and women in their 20s and 30s on the tolerance of violence in dating and the mediating effect of irrational relationship beliefs. To this end, major variables were measured through survey and statistical analysis was conducted on 215 unmarried men and women in their 20s and 30s who had experience in dating violence. Hierarchical regression was used to analyse the mediated effects of irrational relational beliefs in the relationship between intrinsic self-love propensity and dating violence tolerance, and hypothesis testing showed that introspective self-love affects the tolerance of dating violence. It was also found that irrational relationships were completely intertwined between implicit narcissism and dating violence tolerance. The results of these studies indicate that irrational interrelationships only affect the tolerance of dating violence. The results of this study are suggestive in that it can contribute to the development of counseling and education programs that can prevent dating violence by proving the mediating effect of irrational relationship beliefs about violence tolerance.

• The Journal of the Korea Contents Association
• /
• v.22 no.1
• /
• pp.391-404
• /
• 2022

Actor-network theory (ANT) pays attention to the relational effect between human and non-human actors, and transforms numerous networks between these actors by treating non-humans as human-like actors. This paper investigated various non-human actors related to the context before and after the introduction of NCS-based curriculum through ANT. This approach is because as a new system is introduced, the impact on the existing network and conflict situations can be looked at more closely. To this end, the researcher reviewed data from October 2014, when S College discussed whether to introduce an NCS-based curriculum, to February 2017, when practical operation was carried out and graduates were produced. In order to understand ANT theory, we analyzed based on the four stages of translation as claimed by Callon in the ANT theory. As a result, some meanings were confirmed in the case of reforming the curriculum of S College where the NCS-based curriculum was introduced. First, it is an in-depth analysis of the situation surrounding the curriculum, which has been overlooked by research on the existing curriculum. Second, it contributed to interpreting the 'hidden meaning' beyond the 'superficial meaning' of the curriculum within the university. Third, it was possible to indirectly check the conflicts and conflicts with the existing system that appeared in the process of introducing the new system to the College.

• The Journal of the Korea Contents Association
• /
• v.22 no.2
• /
• pp.173-186
• /
• 2022

The purpose of this study is to investigate the influence of gamification strategies on improving participation and motivation of shared electric scooter users. To this end, this study derived the user type through the first research question of how the shared electric scooter usage behavior and pulse are, and derived user tasks and scenarios. The second research question, a shared electric kickboard app with gamification, was tested by users to see if it helps increase user participation and form motivation. As a result of the analysis, it was found that users were induced to be considerate of other users by using a combination of the motivational, relational, and self-expression strategies of gamification. Second, it was found that the use of motivation, achievement and reward, and reward visualization strategy elements promotes user's voluntary behavior. Third, through relationship, achievement, and reward strategies, users participated to create a positive culture of shared electric scooters, drawing immediate feedback, indicating that convenience has increased. In conclusion, it was found that the user helped to play a positive role in voluntary participation and motivation through the use of the shared electric kickboard service with gamification.