• Title/Summary/Keyword: Relational support

Search Result 239, Processing Time 0.024 seconds

Incremental Maintenance of Horizontal Views Using a PIVOT Operation and a Differential File in Relational DBMSs (관계형 데이터베이스에서 PIVOT 연산과 차등 파일을 이용한 수평 뷰의 점진적인 관리)

  • Shin, Sung-Hyun;Kim, Jin-Ho;Moon, Yang-Sae;Kim, Sang-Wook
    • The KIPS Transactions:PartD
    • /
    • v.16D no.4
    • /
    • pp.463-474
    • /
    • 2009
  • To analyze multidimensional data conveniently and efficiently, OLAP (On-Line Analytical Processing) systems or e-business are widely using views in a horizontal form to represent measurement values over multiple dimensions. These views can be stored as materialized views derived from several sources in order to support accesses to the integrated data. The horizontal views can provide effective accesses to complex queries of OLAP or e-business. However, we have a problem of occurring maintenance of the horizontal views since data sources are distributed over remote sites. We need a method that propagates the changes of source tables to the corresponding horizontal views. In this paper, we address incremental maintenance of horizontal views that makes it possible to reflect the changes of source tables efficiently. We first propose an overall framework that processes queries over horizontal views transformed from source tables in a vertical form. Under the proposed framework, we propagate the change of vertical tables to the corresponding horizontal views. In order to execute this view maintenance process efficiently, we keep every change of vertical tables in a differential file and then modify the horizontal views with the differential file. Because the differential file is represented as a vertical form, its tuples should be converted to those in a horizontal form to apply them to the out-of-date horizontal view. With this mechanism, horizontal views can be efficiently refreshed with the changes in a differential file without accessing source tables. Experimental results show that the proposed method improves average performance by 1.2$\sim$5.0 times over the existing methods.

An Interconnection Method for Streaming Framework and Multimedia Database (스트리밍 프레임워크와 멀티미디어 데이타베이스와의 연동기법)

  • Lee, Jae-Wook;Lee, Sung-Young;Lee, Jong-Won
    • Journal of KIISE:Software and Applications
    • /
    • v.29 no.7
    • /
    • pp.436-449
    • /
    • 2002
  • This paper describes on our experience of developing the Database Connector as an interconnection method between multimedia database, and the streaming framework. It is possible to support diverse and mature multimedia database services such as retrieval and join operation during the streaming if an interconnection method is provided in between streaming system and multimedia databases. The currently available interconnection schemes, however have mainly used the file systems or the relational databases that are Implemented with separated form of meta data, which deafs with information of multimedia contents, and streaming data which deals with multimedia data itself. Consequently, existing interconnection mechanisms could not come up with many virtues of multimedia database services during the streaming operation. In order to resolve these drawbacks, we propose a novel scheme for an interconnection between streaming framework and multimedia database, called the Inter-Process Communication (IPC) based Database connector, under the assumption that two systems are located in a same host. We define four transaction primitives; Read, Write, Find, Play, as well as define the interface for transactions that are implemented based on the plug-in, which in consequence can extend to other multimedia databases that will come for some later years. Our simulation study show that performance of the proposed IPC based interconnection scheme is not much far behind compared with that of file systems.

Study on Resources That Influence Drop - Out Teenage Children's Choices on School Reentry: Central Focus on Family Resources (학업중단 청소년 자녀의 학교복귀 선택에 영향을 미치는 자원에 관한 연구: 가족자원 등을 중심으로)

  • Yun, Nana;Park, Jeongyun;Park, Yeonsuk
    • Journal of Family Resource Management and Policy Review
    • /
    • v.26 no.1
    • /
    • pp.27-42
    • /
    • 2022
  • This study was conducted to examine the resources that influence the choice of drop-out students' reentry to school. A total of five years of panel analysis of 2,553 drop-out teenagers from 2013 to 2017 were utilized. In order to verify the resources that affect the choice of school reentry of teenagers with experiences of suspension of studies to formal middle and high school after July 2012, this study analyzed drop-out teenagers' family resources as well as their psychological, mental, and social-relationship resources. A crossover analysis, t-test, and hierarchical logistic regression analysis were conducted. The major outcomes of this study are as follows: First, the socio-demographic variables among the resources that affected the choice of reentry for school of teenager children were the type of family and number of moves to a new house. Second, the psychological and sentimental variable that affected the choice of school reentry was a decreasing level of positive recognition of the situation of suspension of studies combined with depression, impulsiveness, and perceiving society as one that discriminates based on the level of education. Third, significant family resource variables were the type of family form and parents providing economic support, which is a subfactor of parental attachment. Fourth, the presence of a mentor as a helpful social-relationship resource had a significant effect on relational resources. This study is significant in the sense that the positive family resources that affect the choice of school reentry of drop-out teenage students were determined, and the positive directivity of supportive family resources is presented for parents with teenage children experiencing a suspension of studies.

The Effects of Individuality and Relationship of University Freshman on College Life Adaptation (대학교 신입생의 개별성 및 관계성이 대학생활적응에 미치는 영향)

  • Yoo, Yong-Shik
    • Journal of Korea Entertainment Industry Association
    • /
    • v.13 no.4
    • /
    • pp.271-281
    • /
    • 2019
  • The purpose of this study is to provide basic data for improving the adaptability of college life by examining the effects of individuality and relationship of university freshmen on college life adaptation. The study subjects were 383 freshmen enrolled in a university in Chungbuk C City, and a multiple regression analysis was conducted to examine the factors of impact. The first study found that boys were more individual in genders, depending on the general characteristics. Extroverted students were more relational. In the majors, students in the humanities and social sciences were more related, and students in the natural engineering department were more individual. Second, the lower factors affecting college students' adaptation to college life were found to be autonomous in individuality, and affinity and intimacy in relation. In particular, autonomy has the greatest impact on adaptation to college life, followed by affinity and intimacy. Based on these results, policy suggestions are needed first, it is necessary to balance and balance individuality and relationship. second, it is necessary to create activities and learning environments that you can choose for yourself. third, it is necessary to develop programs to promote affinity and intimacy such as department events and club activities. fourth, emotional and psychological program support through face-to-face contact should be activated to improve individuality and relationship.

Development of Detailed Design Automation Technology for AI-based Exterior Wall Panels and its Backframes

  • Kim, HaYoung;Yi, June-Seong
    • International conference on construction engineering and project management
    • /
    • 2022.06a
    • /
    • pp.1249-1249
    • /
    • 2022
  • The facade, an exterior material of a building, is one of the crucial factors that determine its morphological identity and its functional levels, such as energy performance, earthquake and fire resistance. However, regardless of the type of exterior materials, huge property and human casualties are continuing due to frequent exterior materials dropout accidents. The quality of the building envelope depends on the detailed design and is closely related to the back frames that support the exterior material. Detailed design means the creation of a shop drawing, which is the stage of developing the basic design to a level where construction is possible by specifying the exact necessary details. However, due to chronic problems in the construction industry, such as reducing working hours and the lack of design personnel, detailed design is not being appropriately implemented. Considering these characteristics, it is necessary to develop the detailed design process of exterior materials and works based on the domain-expert knowledge of the construction industry using artificial intelligence (AI). Therefore, this study aims to establish a detailed design automation algorithm for AI-based condition-responsive exterior wall panels and their back frames. The scope of the study is limited to "detailed design" performed based on the working drawings during the exterior work process and "stone panels" among exterior materials. First, working-level data on stone works is collected to analyze the existing detailed design process. After that, design parameters are derived by analyzing factors that affect the design of the building's exterior wall and back frames, such as structure, floor height, wind load, lift limit, and transportation elements. The relational expression between the derived parameters is derived, and it is algorithmized to implement a rule-based AI design. These algorithms can be applied to detailed designs based on 3D BIM to automatically calculate quantity and unit price. The next goal is to derive the iterative elements that occur in the process and implement a robotic process automation (RPA)-based system to link the entire "Detailed design-Quality calculation-Order process." This study is significant because it expands the design automation research, which has been rather limited to basic and implemented design, to the detailed design area at the beginning of the construction execution and increases the productivity by using AI. In addition, it can help fundamentally improve the working environment of the construction industry through the development of direct and applicable technologies to practice.

  • PDF

Factors Influencing the Intention of Knowledge Sharing of Records Management Specialists in Government-affiliated Public Institutions (정부산하공공기관 기록물관리전문요원의 지식공유의도 영향요인에 관한 연구)

  • Kim, Youngeun;Park, Ji-Hong
    • Journal of the Korean BIBLIA Society for library and Information Science
    • /
    • v.33 no.1
    • /
    • pp.47-70
    • /
    • 2022
  • The purpose of this study is to empirically verify the factors(organization managerial factors, relational factors and personal factors) that affect the knowledge sharing intention of records management specialists. A total of 126 responses were used for the final analysis and the findings of this study are as follows: First, managers' interests and supports had a significant positive effect on tacit knowledge sharing intention, but evaluation and compensation system had a negative effect on tacit knowledge sharing intention. Second, job stress was found to have a significant positive effect on the intention of knowledge sharing(tacit, explicit). It is required to form an organizational culture where records management specialists can freely participate in knowledge sharing activities with the interest and support of managers. In addition, the process of continuously improving the causes of one of the causes of job stress, such as awareness improvement and deprivation, should be carried out through records management training for all employees. This study is meaningful in that it provides policy implications for promoting knowledge sharing as a solution to the managerial problems faced by records management specialists by utilizing the current staffing structure.

Educational achievement in Korean society (II): Psychological analysis of academic success of Korean adolescents (한국 사회와 교육적 성취 (II): 한국 청소년의 학업성취에 대한 심리적 토대 분석)

  • Uichol Kim;Youngshin Park
    • Korean Journal of Culture and Social Issue
    • /
    • v.14 no.1_spc
    • /
    • pp.63-109
    • /
    • 2008
  • This article examines psychological factors that contribute to educational achievement of Korean adolescents. By reviewing empirical research, three core areas are outlined. First, positive and negative roles that Korean society play on academic achievement are analyzed. Compared to other countries, Korean society places a high premium, pressure an investment on educational achievement. This has contributed to the rapid economic growth and development, but at the same time it has created numerous social problems. Second, psychological and relational dynamics of investing in and achieving success in education are delineated. Through indigenous psychological analysis, the role parents play in motivating and regulating their children to succeed academically is reviewed. In addition, the role of teachers and friends and the coordinated efforts of Korean society are outlined. Third, future directions and transformations in education that are needed in Korean society are discussed. Although Korean adolescents are high achievers in high school, this is not the case at the university level. Since Korean students are interested in entering a prestigious university, they have developed skills in doing well in standardized tests. Educational reforms need to take into consideration individuals' personal interests, skills and creativity to ensure that the knowledge that they acquired can be used to further their career and improve their subjective well-being. Educational transformation does not imply simply adopting Western models, but developing indigenous models that can maximize human and cultural potential and stimulate curiosity, diversity and creativity that are necessary in the global era.

  • PDF

Student difficulties in constructed-response mathematics assessments: A case study of writing activities for low-performing first-year high school students (수학 서술형 평가의 어려움과 지도 방안: 고교 1학년 노력형 학생의 쓰기 활동 사례 연구)

  • Mihui Bae;Woong Lim
    • The Mathematical Education
    • /
    • v.63 no.1
    • /
    • pp.1-18
    • /
    • 2024
  • This study aims to analyze low-performing high school students' difficulties in constructed response (CR) mathematics assessments and explore ways to use writing activities to support student learning. The participants took CR assessments, engaged in guided writing activities across 15 lessons, and provided responses to our interviews. The study identified 20 types of student difficulties, which were sorted into two main categories: "mathematical difficulties" and "CR difficulties." The difficult nature of mathematics as a school subject included a lack of understanding of mathematical concepts, students' difficulty with mathematical symbols and notations, and struggles with word problems. Challenges specific to CR assessments included students' difficulties arising from the testing conditions unlike those of multiple-choice items, and included issues related to constructing appropriate responses and psychological barriers. To address these challenges in CR assessments, the study conducted guided writing activities as an intervention, through which six themes were identified: (1) internalization of mathematical concepts, (2) mathematical thinking through relational understanding, (3) diverse problem-solving methods, (4) use of mathematical symbols, (5) reflective thinking, and (6) strategies to overcome psychological barriers.

The Determination of Trust in Franchisor-Franchisee Relationships in China (중국 프랜차이즈 시스템에서의 본부와 가맹점간 신뢰의 영향요인)

  • Shin, Geon-Cheol;Ma, Yaokun
    • Journal of Global Scholars of Marketing Science
    • /
    • v.18 no.2
    • /
    • pp.65-88
    • /
    • 2008
  • Since the implementation of economic reforms in 1978, the Chinese economy grows rapidly at an average annul growth rate of 9% over the post two decades. Franchising has been widely recognized as an important source of entrepreneurial activity. Trust is important in that it facilitates relational exchanges by permits partners to transcend short-run inequities or risks to concentrate on long-term profits or gains. In the relationship between the franchisors and franchisees, trust has been described as an important source of competitive advantage. However, little research has been done on the factors affecting trust in Chinese franchisor-franchisee relationships. The purpose of this study is to investigate what factors affect the trust in the franchise system in China, and to provide guidelines and insights to franchisors which enter Chinese market. In this study, according to Morgan and Hunt (1994), trust is defined as the extending when one party has confidence in an exchange partner's reliability and integrity. We offered a conceptual model of the empirical study. The model shows that the factors affecting the trust include franchisor's supports, communication, satisfaction with previous outcome and conflict. We also suggested the franchisor's supports and communication like to enhance the franchisee's satisfaction with previous outcome, and the franchisor's supports, communication and he franchisee's satisfaction with previous outcome tend to decrease conflict. Before the formal study, a pretest involving exploratory interviews with owners from three franchisees was conducted to make sure the questionnaire was relevant and clear to the respondents. The data were collected using trained interviewers to carry out personal interviews with the aid of an unidentified, muti-page, structured questionnaire. The respondents comprised of owners, managers, and owner managers of franchisee-owned food service franchises located in Beijing, China. Even though a total of 256 potential franchises were initially contacted, the finally usable sample consisted of 125 respondents. As expected, the sampling method was successful in soliciting respondents with waried personal and firm characteristics. Self-administrated questionnaires were used for all measures. And established scales were used to measure the latent constructs in this study. The measures tapped the franchisees' perceptions of the relationship with the referent franchisor. Five-point Likert-type scales ranging from "strongly disagree" (=1) to "strongly agree" (=7) were used throughout the constructs (trust, eight items; support, five items; communication, four items; satisfaction, six items; conflict, three items). The reliability measurements traditionally employed, such as the Cronbach's alpha, were used. All the reliabilities were greater than.80. The proposed measurement model was estimated using SPSS 12.0 and AMOS 5.0 analysis package. We conducted A series of exploratory factor analyses and confirmatory factor analyses to assess the convergent validity, discriminant validity, and reliability. The results indicate reasonable overall fits between the model and the observed data. The overall fit of measurement model were $X^2$= 159.699, p=0.004, d.f. = 116, GFI =.879, NFI =.898, CFI =.969, IFI =.970, TLI =.959, RMR =.058. The results demonstrated that the data reasonably fitted the model. We also examined construct reliability and reliability and average variance extracted (AVE). The construct reliability of each construct was greater than.80 and the AVE of each construct was greater than.50. According to the analysis of Structure Equation Modeling (SEM), the results of path model indicated an adequate fit of the model: $X^2$= 142.126, p = 0.044, d.f. = 115, GFI =.892, NFI =.909, CFI =.981, IFI =.981, TLI =.974, RMR =.057. As hypothesized, the results showed that it is strategically important to establish trust in a franchise system, and the franchisor's supports, communication and satisfaction with previous outcome tend to reinforce franchisee's trust. The results also showed trust seems to decrease as the experience of conflict episodes increases. And we also noticed that franchisor's supports and communication tend to enhance the franchisee's satisfaction with previous outcome, and communication tend to decrease conflict. If the trust between the franchisor and franchisee can be established in a franchise system, franchising offers many benefits and reduces many costs. To manage a mutual trust of relationship with their franchisees, franchisor's should provide support effectively to their franchisees. Effective assistant services have direct effect on franchisees' satisfaction with previous outcome and trust in franchisor. Especially, franchise sales process, orientation, and training in the start-up period are key elements for success of the franchise system. Franchisor's support is an accumulated separate satisfaction evaluation with different kind of service provided by the franchisor. And providing support definitely can improve the trustworthy image of the franchisor. In the franchise system, conflicts of interests and exertions of different power sources are very common. The experience of conflict episodes seems to negatively relate to trust. Therefore, it is important to reduce the negative side of the relationship conflicts. Communication actually plays a broader role in reducing conflict and establish mutual trust in franchisor-franchisee relationship. And effective communication between franchisors and franchisees can improve franchisees' satisfaction toward the franchise system. As the diversification of Chinese markets, both franchisors and franchisees must keep the relevant, timely, and reliable communication. And it is very important to improve the quality of communication. Satisfaction with precious outcomes seems to positively relate to trust. Franchisors and franchisees that are highly satisfied with the previous outcomes that flow from their relationship will perceive their partner as advancing their goal achievement. Therefore, it is necessary for both franchisor and their franchisees to make the welfare of partner with effort. Little literature has focused on what factors affect the trust between franchisors and their franchisees in China. This study developed the hypotheses regarding the factors affecting trust in the transaction relationship. The results of data analysis supported the hypotheses strongly. There are certain limitations in this study. First, we may point out that some other factors missed in this study could be significantly important. Second, the context of this study, food service industry, limits its potential generalizability for all franchise systems. More studies in different categories of franchise system are needed to broaden its generalizability. Third, the model was tested empirically in a sample in Beijing, more empirical tests of the proposed model in other Chinese areas are needed. Finally, the analysis in this study was solely based on the perception of franchisees and the opinions of franchisors were not included.

  • PDF

The Factors Affecting on the Franchisor's Performance and Its Intention of Recontracting with Franchisees : Focused on the Chinese Franchise Market (프랜차이즈 본부의 성과 및 재계약의도에 영향을 미치는 요인들에 관한 연구 : 중국프랜차이즈 시장을 중심으로)

  • Shuai, Su;Seo, Sang-Yun;Lee, Hoon-Yong
    • Journal of Distribution Research
    • /
    • v.17 no.3
    • /
    • pp.1-24
    • /
    • 2012
  • Franchises have recently emerged as the most rapidly expanding industry positioned to create a large impact in the domestic economic. The Chinese franchise industry developed rapidly in the period prior and subsequent to WTO accession with more than 50% of new franchises brands emerging since 2000. M&A transactions in the Chinese franchise industry have progressed actively. In the period from 2005-2007, due to the wholesale and retail market opening in accordance with the guidelines laid forth within the MOU by the WTO the Chinese franchise market is now the largest market in the world all despite a short history of only 20 years. The amount of franchise market research on China is disproportional to its current size and development potential. Beginning in the 1990s, market research conducted by the International Franchise Association focused on emerging markets in Eastern Europe and China. While the research dealt with the Chinese investment environment, it insufficiently explained the market region and cultural environment. The purpose of this research is (i) to investigate the determinants of the performance of franchise systems in China and (ii) new contract renewals based on performance factors. This study will complement existing research in terms of the franchisee perspective. This study may also prove of the benefit to the franchise companies entering the Chinese franchise market enabling them to develop an effective strategy. This study shows that support, incentives, and system standardization by franchisor yielded a positive effect on management performance. This is consistent with previous studies by Shin (2000) and Kim (2008) targeting Korean franchises. Therefore, in the Chinese market, the franchisor must focus on support, incentives, and system standardization rather than concentrate only on the recruitment of franchisees in order to improve revenue. Hypotheses regarding franchisor control have been dismissed in existing research, in the opinion of this study, due to their complexity and inability to control the merchant as a one-kind-assessment-standard. Our findings show that the franchisees' financial condition, management ability and entrepreneurial spirit, among franchisee's characteristics, have a positive effect on franchisor's business performance and satisfaction for the franchisee. This is consistent with previous studies on headquarters' management performance of Lussier (1996), Heo and Jang (2008), and franchisees' financial condition, management ability and entrepreneurial spirit effect on franchisor's satisfaction of Weaven and Franzer (2007), Kim (2009), Han (2009), and Yoon etc. (2008). Therefore, when permitting a franchisee, financial condition, management ability, entrepreneurship of the franchisee should be carefully considered. Among relational factors between franchisor and franchisee, trust has the positive influence on the management performance of the franchisor while conflict has a negative effect. However, trust, commitment and conflict factors have been shown not to have any impact on the satisfaction of the franchise headquarters. This result is consistent with the previous studies of Pavlou and Ba (2000), Morrison (1999), Weaven and Frazer (2007), Kim and Park (1994), Sohn (2007) which show that trust between franchisor and the franchisees have a positive effect and that conflict has a negative impact on franchisor's management performance. Other factors causing a negative effective on the franchisor's management performance are a rapid environmental changes and uncertainty in the business. This is consistent with Campbell et al (2007), Kim and Kim (2009), Han and Baek (2008). Finally, the high management performance and satisfaction of the franchise headquarters has a positive effect on the intention of franchise renewal. In the case of large markets such as China, the franchisor's strategy and the role is very important. In this study, we also investigated the characteristics of franchisor and franchisee, relationship, and environmental uncertainty affecting on the management performance and satisfaction of franchisor. Recently, Korean franchises are attempting to enter foreign markets through the rise in popularity of Korean culture and entertainment commonly referred to as the Korean wave. This study provides recommendations for Korean franchises intending on entering the Chinese market. First, in order to achieve stable profits, the franchise corporation needs to support the operation of the individual franchisee through incentives and standardization of services. Second, because trust between the franchisor and franchisee has a positive effect on management performance, on-going discussion and cooperation is necessary to reduce the level of conflict.

  • PDF