• Title/Summary/Keyword: Relational View

Search Result 110, Processing Time 0.024 seconds

Estimating Join Selectivity of Global XQuery Queries in Distributed Environments (분산 환경에서 전역 XQuery 질의의 조인 선택치 추정 방법)

  • Park, Jong-Hyun;Kang, Ji-Hoon
    • Journal of KIISE:Databases
    • /
    • v.34 no.6
    • /
    • pp.564-571
    • /
    • 2007
  • One of the methods for integrating XML data in distributed environments is using XML view. User can query toward distributed local XML views by using global XQuery queries in XQuery which is a standard query language for searching XML data. The global XQuery queries naturally contain join operations because of integrating and searching distributed heterogeneous data. Since join operations are generally expensive for processing a query, its processing technique is very important for efficient processing of global XQuery queries. Therefore there are some studies on the efficient processing of join operations and one of these studies is that selects minimum join cost by estimating a join selectivity. In case of SQL, there are already some researches for estimating a join selectivity and join cost of global SQL queries. However we can not apply their methods for estimating the selectivity of join operations in SQL queries into XQuery queries because of the structural difference between relational data and XML data. Therefore this paper proposes a method for estimating a selectivity of join operations in XQuery queries using the information of XML views. Our contribution is three threefold. First, we define the difference point for estimating join selectivity between SQL and XQuery. Second, we estimate join selectivity in XQuery queries by referring XML views. Third, we evaluate our estimating method.

Political Geography of Ulsan Oil Refinery (울산공업단지의 서막, 정유공장 건설의 정치지리)

  • Gimm, Dong-Wan;Kim, Min-Ho
    • Journal of the Korean Geographical Society
    • /
    • v.49 no.2
    • /
    • pp.139-159
    • /
    • 2014
  • This study problematizes the dominance of developmental state theory and its negative influences in the field of Korean studies, in particular, dealing with the industrialization during the developmental era, 1960s~70s. As is generally known, the theory has been in a position of unchallenged authority on the industrialization experience of East Asian countries, including South Korea. However, at the same time, it has also misled us into overlooking strategic relations that had articulated the state forms at multiple scales. This study aims to reconstruct the historical contexts by the theorizing prompted by recent work on state space. I shed light on the multiscalar strategic relations that had shaped the Ulsan refinery plant as a representative state space of the South Korean industrialization during two decades after liberation. Specifically, the study illustrates the features and roles of Cold War networks and multiscalar agnets such as Nam Goong-Yeon. By identifying the plant as a result of sequential articulations between Ulsan and other scales, this study concludes by suggesting to reframing the strategic relational spaces, beyond the view of methodological nationalism, in the perspective of multiscalar approach.

  • PDF

Efficient Management of Statistical Information of Keywords on E-Catalogs (전자 카탈로그에 대한 효율적인 색인어 통계 정보 관리 방법)

  • Lee, Dong-Joo;Hwang, In-Beom;Lee, Sang-Goo
    • The Journal of Society for e-Business Studies
    • /
    • v.14 no.4
    • /
    • pp.1-17
    • /
    • 2009
  • E-Catalogs which describe products or services are one of the most important data for the electronic commerce. E-Catalogs are created, updated, and removed in order to keep up-to-date information in e-Catalog database. However, when the number of catalogs increases, information integrity is violated by the several reasons like catalog duplication and abnormal classification. Catalog search, duplication checking, and automatic classification are important functions to utilize e-Catalogs and keep the integrity of e-Catalog database. To implement these functions, probabilistic models that use statistics of index words extracted from e-Catalogs had been suggested and the feasibility of the methods had been shown in several papers. However, even though these functions are used together in the e-Catalog management system, there has not been enough consideration about how to share common data used for each function and how to effectively manage statistics of index words. In this paper, we suggest a method to implement these three functions by using simple SQL supported by relational database management system. In addition, we use materialized views to reduce the load for implementing an application that manages statistics of index words. This brings the efficiency of managing statistics of index words by putting database management systems optimize statistics updating. We showed that our method is feasible to implement three functions and effective to manage statistics of index words with empirical evaluation.

  • PDF

A Study on Empirical Model for the Prevention and Protection of Technology Leakage through SME Profiling Analysis (중소기업 프로파일링 분석을 통한 기술유출 방지 및 보호 모형 연구)

  • Yoo, In-Jin;Park, Do-Hyung
    • The Journal of Information Systems
    • /
    • v.27 no.1
    • /
    • pp.171-191
    • /
    • 2018
  • Purpose Corporate technology leakage is not only monetary loss, but also has a negative impact on the corporate image and further deteriorates sustainable growth. In particular, since SMEs are highly dependent on core technologies compared to large corporations, loss of technology leakage threatens corporate survival. Therefore, it is important for SMEs to "prevent and protect technology leakage". With the recent development of data analysis technology and the opening of public data, it has become possible to discover and proactively detect companies with a high probability of technology leakage based on actual company data. In this study, we try to construct profiles of enterprises with and without technology leakage experience through profiling analysis using data mining techniques. Furthermore, based on this, we propose a classification model that distinguishes companies that are likely to leak technology. Design/methodology/approach This study tries to develop the empirical model for prevention and protection of technology leakage through profiling method which analyzes each SME from the viewpoint of individual. Based on the previous research, we tried to classify many characteristics of SMEs into six categories and to identify the factors influencing the technology leakage of SMEs from the enterprise point of view. Specifically, we divided the 29 SME characteristics into the following six categories: 'firm characteristics', 'organizational characteristics', 'technical characteristics', 'relational characteristics', 'financial characteristics', and 'enterprise core competencies'. Each characteristic was extracted from the questionnaire data of 'Survey of Small and Medium Enterprises Technology' carried out annually by the Government of the Republic of Korea. Since the number of SMEs with experience of technology leakage in questionnaire data was significantly smaller than the other, we made a 1: 1 correspondence with each sample through mixed sampling. We conducted profiling of companies with and without technology leakage experience using decision-tree technique for research data, and derived meaningful variables that can distinguish the two. Then, empirical model for prevention and protection of technology leakage was developed through discriminant analysis and logistic regression analysis. Findings Profiling analysis shows that technology novelty, enterprise technology group, number of intellectual property registrations, product life cycle, technology development infrastructure level(absence of dedicated organization), enterprise core competency(design) and enterprise core competency(process design) help us find SME's technology leakage. We developed the two empirical model for prevention and protection of technology leakage in SMEs using discriminant analysis and logistic regression analysis, and each hit ratio is 65%(discriminant analysis) and 67%(logistic regression analysis).

A Reconstruction of Area Unit of Elementary Mathematics Textbook Based on Freudenthal's Mathematisation Theory (Freudenthal의 수학화 이론에 근거한 제 7차 초등수학 교과서 5-가 단계 넓이 단원의 재구성)

  • You, Mi-Hyun;Kang, Heung-Kyu
    • Journal of Elementary Mathematics Education in Korea
    • /
    • v.13 no.1
    • /
    • pp.115-140
    • /
    • 2009
  • Freudenthal has advocated the mathematisation theory. Mathematisation is an activity which endow the reality with order, through organizing phenomena. According to mathematisation theory, the departure of children's learning of mathematics is not ready-made formal mathematics, but reality which contains mathematical germination. In the first place, children mathematise reality through informal method, secondly this resulting reality is mathematised by new tool. Through survey, it turns out that area unit of Korea's seventh elementary mathematics textbook is not correspond to mathematisation theory. In that textbook, the area formular is hastily presented without sufficient real context, and the relational understanding of area concept is overwhelmed by the practice of the area formular. In this thesis, first of all, I will reconstruct area unit of seventh elementary textbook according to Freudenthal's mathematisation theory. Next, I will perform teaching experiment which is ruled by new lesson design. Lastly, I analysed the effects of teaching experiment. Through this study, I obtained the following results and suggestions. First, the mathematisation was effective on the understanding of area concept. Secondly, in both experimental and comparative class, rich-insight children more successfully achieved than poor-insight ones in the task which asked testee comparison of area from a view of number of unit square. This result show the importance of insight in mathematics education. Thirdly, in the task which asked testee computing area of figures given on lattice, experimental class handled more diverse informal strategy than comparative class. Fourthly, both experimental and comparative class showed low achievement in the task which asked testee computing area of figures by the use of Cavalieri's principle. Fifthly, Experiment class successfully achieved in the area computing task which resulting value was fraction or decimal fraction. Presently, Korea's seventh elementary mathematics textbook is excluding the area computing task which resulting value is fraction or decimal fraction. By the aid of this research, I suggest that we might progressively consider the introduction that case. Sixthly, both experimental and comparative class easily understood the relation between area and perimeter of plane figures. This result show that area and perimeter concept are integratively lessoned.

  • PDF

Design and Implementation of Database Broker system for Integrated Data Environment of Virtual Enterprises (가상 기업의 통합 데이터 환경을 위한 데이터베이스 브로커 시스템의 설계 및 구현)

  • Yun, Seon-Hui;Jeong, Jin-Uk
    • The Transactions of the Korea Information Processing Society
    • /
    • v.6 no.2
    • /
    • pp.425-438
    • /
    • 1999
  • In recent days network computing technologies have bee developed rapidly and the extended use of Internet applications for enterprises such as internet/extarnet in and between enterprises has been increased enormously. Therefore the business in the future will be executed by virtual enterprise. Virtual enterprises which is based on information sharing between enterprises are composed of work processes related to information exchange between virtual enterprises, the team members who are representatives of the organizations that are participated in the actual business of virtual enterprises, and members who are representatives of the organizations that are participated in the actual business of virtual enterprises, and environment that are provided by supporting CALS(continuous Acquisition and Life cycle Support or commerce At light Speed). Supporting system of IDE(Integrated Data Environment)for CALS implementation that is provided as an environment of virtual enterprises has to ensure the autonomies of local data and to provide the accessibility of heterogeneous database of enterprises on network transparently for giving user a single global view of data. This paper introduce the design and implementation of the database broker system that can be accessed data transparently by the suers of participated enterprises in the integrated data environment supporting virtual enterprises. The system uses java/CORBA technology in Web environment and Object Query language (OQL) to process the queries of relational database system, object-oriented database system, and file information.

  • PDF

A Study on the Reliability and Validity of the Collection of the Ethnography Method of Service Experience Data - Focusing on I know You_AI Service - (서비스경험데이터의 에스노그라피 방식 수집에 대한신뢰성과 타당성 연구 - I know you_AI 서비스를 중심으로 -)

  • Ahn, Jinho;Lee, Jeungsun
    • Journal of Service Research and Studies
    • /
    • v.10 no.4
    • /
    • pp.43-55
    • /
    • 2020
  • Recently, as the importance of experience data increases, there are many attempts to deal with experience data from a data science perspective. In the case of approaching as a collection method of a quantitative survey method that seeks to quantify numerically such as big data, it is difficult to interpret the value of experience in a wide range, and it is relatively expensive and time consuming, and personal information infringement There is a limit to the analysis due to the risk of However, since ethnography, a procedure for collecting experience data based on qualitative research, is mainly carried out in the natural real environment of future customers from the perspective of users, it is possible to confirm the nature that customers face with a small sample. In addition, it is also easy to interpret the relational dimension of the empirical data. Although the ethnography method of collecting experiential data is economical and efficient, it is important to reduce errors in the collection process because the lack of scientific procedures for the data collection process can be a problem. It is important to secure the validity of whether the correct measurement tool is used for ethnography-based experiential data collection and to secure the reliability of the use of a valid measurement tool and method by accurately selecting the measurement target. From this point of view, it is necessary to verify the reliability of the research method that clearly selects the measurement target and secures the validity for the development of the correct measurement method and tool for the collection of ethnography experience data. Therefore, in this study, a verification study was conducted on the data and methodology cases of the'I know you_AI' service that analyzes the customer experience of self-employed based on the ethnography method of collecting experience data..

The Interpretation of Korean Traditional Garden in the View of Complexity Theory - Focusing on Soswaewon Garden - ('복잡성(Complexity) 이론'에 의한 한국 전통정원의 해석 - 한국의 명원 소쇄원을 중심으로 -)

  • Jang, Il-Young;Shin, Sang-Sup
    • Journal of the Korean Institute of Traditional Landscape Architecture
    • /
    • v.28 no.2
    • /
    • pp.75-85
    • /
    • 2010
  • The purpose of this study is to attempt new analysis on Soswaewon Garden(瀟灑園) where is Korea's traditional garden, focusing on which the tendency of its change is a relational-formation tool similar to the Eastern Mode of Thought, with paying attention to conversion as the new view of world. Accordingly, the aim is to reanalyze by connecting with Soswaewon Garden based on the theory of complexity, which tries to look at the whole through relationship rather than characteristics in individual components. Given summarizing findings, those are as follows. First, it was found that complexity shown in space and open system of physical dimension was characterized by 'event(situation)', 'non-determination' and 'homogeneous relationships between part and whole', and a variety of techniques introduced the nature positively. In particular, it was found that there were many cases of topographic usage, since the Soswaewon Garden selected its construction site proactively and was a product from architectural works in compliance with a given flow of natural topography. This has a nature of open text in the situation of emergent behaviors. Second, it was found that complexity shown in experiences and open system on the invisible dimension was characterized primarily by 'event(situation)' and 'relationships of interactive response between actors and environment', and various techniques appeared as a space for interactive combination of nature and daily experiences. This is typical of bilateral harmony based on interactions between subject and object, and between mankind and nature, and becomes also a space to accommodate temporary emergent behaviors in our life. Third, the compositional elements are reconstituted as space of organic property with dismantling steady relations. Especially, 'Soswaewon Garden's 48 poems(瀟灑園四十八詠)' will be the origin of the emotionally spatial experience to the current performers. Ultimately, the performer in the space of Soswaewon Garden simultaneously becomes a creator of space, and will generate new space with intertextuality with environment. Therefore, Soswaewon Garden becomes a place of binding me and the other together while maintaining mutual relationship based on organic thinking between a human being and nature and between the whole and a part.

The social representation and trust of Korean society and people: Indigenous psychological analysis of the perception of Korean adolescents and adults (한국 사회와 사람에 대한 사회적 표상과 신뢰: 청소년과 성인의 지각을 통해 본 토착심리 분석)

  • Uichol Kim ;Young-Shin Park
    • Korean Journal of Culture and Social Issue
    • /
    • v.10 no.3
    • /
    • pp.103-129
    • /
    • 2004
  • This article examines the Korean adolescents and adults' social representation and trust of Korean society and people using indigenous psychological analysis. Respondents were asked to write in an open-ended questionnaire their perception of the following five aspects: Korean politics, economy, society, culture and people. They were then asked to report why they trust or distrust Korean society. A total of 1,064 respondents (218 middle school students, 200 university students, 218 fathers of the middle school students, 218 mothers of the middle school students, and 210 teachers) completed a questionnaire developed by the present researchers. The data were collected during April to June, 2003. The results indicate that 94.5% of Koreans view the existing political system and politicians as being corrupt, inept, factional, and lacking in integrity. A vast majority (84.9%) recognize the existence of systemic problems in the Korean economy. A total of 78.2% see problems in Korean society being dominated by selfishness, factionalism, conservatism, and social uncertainty. For Korean culture, a majority of respondents report being proud of its cultural tradition, accomplishment, and creativity. At the same time, 45.7% report loss of cultural identity and pride due to external influences. More than half of the respondents report negative aspects of Korean people (i.e., selfish, lack of morality, rushed, and overly focused on their social image), while nearly half of the respondents report positive aspects of Korean people as being compassionate, cooperative, good-natured and hard-working. As for reason for trusting Korean society, around a third report "because it is our country," followed by its future potential, and the good-nature and willingness of Korean people to work hard. The reasons for distrusting Korean society is the dishonesty politicians, corruption, institutional ineptness, and economic uncertainty. These results indicate a low level of collective efficacy in influencing and affecting change in Korean society.

  • PDF

Business Relationships and Structural Bonding: A Study of American Metal Industry (산업재 거래관계와 구조적 결합: 미국 금속산업의 분석 연구)

  • Han, Sang-Lin;Kim, Yun-Tae;Oh, Chang-Yeob;Chung, Jae-Moon
    • Journal of Global Scholars of Marketing Science
    • /
    • v.18 no.3
    • /
    • pp.115-132
    • /
    • 2008
  • Metal industry is one of the most representative heavy industries and the median sales volume of steel and nonferrous metal companies is over one billion dollars in the case America [Forbes 2006]. As seen in the recent business market situation, an increasing number of industrial manufacturers and suppliers are moving from adversarial to cooperative exchange attitudes that support the long-term relationships with their customers. This article presents the results of an empirical study of the antecedent factors of business relationships in metal industry of the United States. Commitment has been reviewed as a significant and critical variable in research on inter-organizational relationships (Hong et al. 2007, Kim et al. 2007). The future stability of any buyer-seller relationship depends upon the commitment made by the interactants to their relationship. Commitment, according to Dwyer et al. [1987], refers to "an implicit or explicit pledge of relational continuity between exchange partners" and they consider commitment to be the most advanced phase of buyer-seller exchange relationship. Bonds are made because the members need their partners in order to do something and this integration on a task basis can be either symbiotic or cooperative (Svensson 2008). To the extent that members seek the same or mutually supporting ends, there will be strong bonds among them. In other words, the principle that affects the strength of bonds is 'economy of decision making' [Turner 1970]. These bonds provide an important idea to study the causes of business long-term relationships in a sense that organizations can be mutually bonded by a common interest in the economic matters. Recently, the framework of structural bonding has been used to study the buyer-seller relationships in industrial marketing [Han and Sung 2008, Williams et al. 1998, Wilson 1995] in that this structural bonding is a crucial part of the theoretical justification for distinguishing discrete transactions from ongoing long-term relationships. The major antecedent factors of buyer commitment such as technology, CLalt, transaction-specific assets, and importance were identified and explored from the perspective of structural bonding. Research hypotheses were developed and tested by using survey data from the middle managers in the metal industry. H1: Level of technology of the relationship partner is positively related to the level of structural bonding between the buyer and the seller. H2: Comparison level of alternatives is negatively related to the level of structural bonding between the buyer and the seller. H3: Amount of the transaction-specific assets is positively related to the level of structural bonding between the buyer and the seller. H4: Importance of the relationship partner is positively related to the level of structural bonding between the buyer and the seller. H5: Level of structural bonding is positively related to the level of commitment to the relationship. To examine the major antecedent factors of industrial buyer's structural bonding and long-term relationship, questionnaire was prepared, mailed out to the sample of 400 purchasing managers of the US metal industry (SIC codes 33 and 34). After a follow-up request, 139 informants returnedthe questionnaires, resulting in a response rate of 35 percent. 134 responses were used in the final analysis after dropping 5 incomplete questionnaires. All measures were analyzed for reliability and validity following the guidelines offered by Churchill [1979] and Anderson and Gerbing [1988]., the results of fitting the model to the data indicated that the hypothesized model provides a good fit to the data. Goodness-of-fit index (GFI = 0.94) and other indices ( chi-square = 78.02 with p-value = 0.13, Adjusted GFI = 0.90, Normed Fit Index = 0.92) indicated that a major proportion of variances and covariances in the data was accounted for by the model as a whole, and all the parameter estimates showed statistical significance as evidenced by large t-values. All the factor loadings were significantly different from zero. On these grounds we judged the hypothesized model to be a reasonable representation of the data. The results from the present study suggest several implications for buyer-seller relationships. Theoretically, we attempted to conceptualize the antecedent factors of buyer-seller long-term relationships from the perspective of structural bondingin metal industry. The four underlying determinants (i.e. technology, CLalt, transaction-specific assets, and importance) of structural bonding are very critical variables of buyer-seller long-term business relationships. Our model of structural bonding makes an attempt to systematically examine the relationship between the antecedent factors of structural bonding and long-term commitment. Managerially, this research provides industrial purchasing managers with a good framework to assess the interaction processes with their partners and, ability to position their business relationships from the perspective of structural bonding. In other words, based on those underlying variables, industrial purchasing managers can determine the strength of the company's relationships with the key suppliers and its state of preparation to be a successful partner with those suppliers. Both the supplying and customer companies can also benefit by using the concept of 'structural bonding' and evaluating their relationships with key business partners from the structural point of view. In general, the results indicate that structural bonding gives a critical impact on the level of relationship commitment. Managerial implications and limitations of the study are also discussed.

  • PDF