• Title/Summary/Keyword: Table Relationship

Search Result 373, Processing Time 0.027 seconds

A Design Methodology of Relational Database Based on Dataflow Diagram (자료흐름도에 기반한 관계형 데이터베이스의 설계방법)

  • 엄윤섭;권중장;정희석;김창동
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2003.10a
    • /
    • pp.615-618
    • /
    • 2003
  • The design process of a relational database system consists of requirement analysis, conceptual design using ER diagram, logical design, and physical design. In logical design process, the conceptual schema is transformed to relational schema, and relational schema is normalized. This traditional design process is hard to applied in real database design process, since there is an ambiguity in conceptual design process. In this paper, we suggest a new design process, which provides more structural design steps by removing the conceptual design process. In new approach, we produce the data flow diagram by the structural methodology. From the attributes in the data store of data flow diagram, we construct relational table schema, and we normalize relational schema. Finally we produced table relationship diagram in order to figure out relationships between tables.

  • PDF

The Major Ripple Effects of the Logistics Industry (Using a MRIO(Multi-Regional Input-Output) Analysis) (물류산업의 주요 경제적 파급효과분석 (MRIO를 이용하여))

  • Choe, Yeong-Yun;Kim, Chan-Seong;Park, Min-Cheol;Seong, Hong-Mo;Sin, Seung-Jin
    • Journal of Korean Society of Transportation
    • /
    • v.28 no.1
    • /
    • pp.107-114
    • /
    • 2010
  • This study aims to identify the impact of the logistics industry on the Korean national economy. To do this, we used a MRIO table provided by the Bank of Korea which includes inter and intra regional relationship of the production and consumption for 6 areas - the Seoul Metropolitan, Gangwon, Chungcheong, Jeonra, Gyeongbuk, Gyeongnam area, but an original MRIO table was recomposed of 29 sectors focused on logistics industry for the purpose of this study. we analyzed producing-inducing effects, supply-shortage effects and inter-industry linkage effects based on logistics industry by region and industry. As a result, the logistics industry has more supply-shortage effect rather than production-inducing effect and has a higher ripple effect on the automotive in Gyeongnam area and petrochemical industry in Jeonra area. In particular, the ripple effect of th Metropolitan logistic industry was far smaller than that of other areas, because the Seoul Metropolitan industry was identified as the primary and middle demand industry.

Construction of Sequential Digital Systems over Finite Fields (유한체상의 순차디지털시스템 구성)

  • Park, Chun-Myoung
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.14 no.12
    • /
    • pp.2724-2729
    • /
    • 2010
  • This paper presents a method of constructing the sequential digital systems over finite fields. We assign all elements in finite fields to digit codes using mathematical properties of finite fields. Also, we discuss the operational characteristics and properties of the building block T-gate which is used to implement the sequential digital systems over finite fields. Then, we implemented sequential digital systems without feed-back. The sequential digital systems without feed-back is constructed as following steps. First, we assign the states in state-transition diagram to state digit codes, then obtain the state function and predecessor table which is explaining the relationship between present states and previous states. Next, we obtained the next-state function from state function and predecessor table. Finally we realize the circuit using T-gate and decoder. The proposed method is more efficiency and systematic than previous method.

Dynamic Universal Variable Length Coding with Fixed Re-Association Table (고정 재배정 테이블 기반 동적 UVLC 부호화 방법)

  • Choe, Ung-Il;Jeon, Byeong-U;Yu, Guk-Yeol;Cheon, Gang-Uk
    • Journal of the Institute of Electronics Engineers of Korea SP
    • /
    • v.39 no.2
    • /
    • pp.56-68
    • /
    • 2002
  • The Universal Variable Length Coding(UVLC) scheme in H.26L has nice features such as error resiliency and two-way decodability. However, it has lower coding efficiency than the conventional Huffman coding. To improve the coding efficiency of UVLC, we Propose to use a dynamic codeword mapping that changes association between symbols and codewords in order to utilize the statistical characteristics of symbols as much as possible but without losing any features of the UVLC. Both encoder and decoder use the same re-association table, and hence the encoder need not send additional overhead for the re-mapping relationship to the decoder. Simulation results show that without significant change of the current H.26L coding scheme, the proposed method additionally attains up to about 8% and about 5% bit reductions respectively in intra and inter frames over the current H.26L encoding method.

A Study on the Effectiveness of Information Retrieval (정보검색효율에 관한 연구)

  • Yoon Koo-ho
    • Journal of the Korean Society for Library and Information Science
    • /
    • v.8
    • /
    • pp.73-101
    • /
    • 1981
  • Retrieval effectiveness is the principal criterion for measuring the performance of an information retrieval system. The effectiveness of a retrieval system depends primarily on the extent to which it can retrieve wanted documents without retrieving unwanted ones. So, ultimately, effectiveness is a function of the relevant and nonrelevant documents retrieved. Consequently, 'relevance' of information to the user's request has become one of the most fundamental concept encountered in the theory of information retrieval. Although there is at present no consensus as to how this notion should be defined, relevance has been widely used as a meaningful quantity and an adequate criterion for measures of the evaluation of retrieval effectiveness. The recall and precision among various parameters based on the 'two-by-two' table (or, contingency table) were major considerations in this paper, because it is assumed that recall and precision are sufficient for the measurement of effectiveness. Accordingly, different concepts of 'relevance' and 'pertinence' of documents to user requests and their proper usages were investigated even though the two terms have unfortunately been used rather loosely in the literature. In addition, a number of variables affecting the recall and precision values were discussed. Some conclusions derived from this study are as follows: Any notion of retrieval effectiveness is based on 'relevance' which itself is extremely difficult to define. Recall and precision are valuable concepts in the study of any information retrieval system. They are, however, not the only criteria by which a system may be judged. The recall-precision curve represents the average performance of any given system, and this may vary quite considerably in particular situations. Therefore, it is possible to some extent to vary the indexing policy, the indexing policy, the indexing language, or the search methodology to improve the performance of the system in terms of recall and precision. The 'inverse relationship' between average recall and precision could be accepted as the 'fundamental law of retrieval', and it should certainly be used as an aid to evaluation. Finally, there is a limit to the performance(in terms of effectiveness) achievable by an information retrieval system. That is : "Perfect retrieval is impossible."

  • PDF

VHTR Construction Ripple Effect Analysis Using Inter-Industry Tables (산업연관분석을 통한 초고온가스로 건설 파급효과 분석)

  • Lee, Tae-Hoon;Lee, Ki-Young
    • Journal of Korean Society of Industrial and Systems Engineering
    • /
    • v.38 no.4
    • /
    • pp.39-44
    • /
    • 2015
  • The VHTR (Very High Temperature gas-cooled nuclear Reactor) has been considered as a major heat source and the most safe generation IV type reactor for mass hydrogen production to prepare for the hydrogen economy era. The VHTR satisfies goals for the GIF (Generation IV International Forum) policy such as sustainablility, economics, reliability and proliferation resistance and physical protection, and safety. As a part of a VHTR economic analysis, we have studied the VHTR construction cost and operation and maintenance cost. However, it is somewhat difficult to expect the ripple effect on the whole industry due to the lack of information about Inter-industries relationship. In many case, the ripple effect are based on experts' knowledge or uncertain qualitative assumptions. As a result, we propose quantitative analysis techniques for ripple effects such as the production inducement effect, added value inducement effect, and employment inducement effect for VHTR 600MWt${\times}$4 modules construction and operation ripple effect based on NOAK (Nth Of A Kind). Because inducement effect values have been published annually, we predict inducement effect's relation function and estimated values including production inducement effect value, added value inducement effect value, and employment inducement effect value using time series and estimated values are verified with published inducement effects' value. This paper presents a new method for the ripple effect and preliminary ripple effect consequence using a time series analysis and inter-industry table. This ripple effect analysis techniques can be applied to effect expectation analysis as well as other type reactor's ripple effect analysis including VHTR for process heat.

Relationship between needle depth for lumbar transforaminal epidural injection and patients' height and weight using magnetic resonance imaging

  • John, Hyunji;Sohn, Kyomin;Kim, Jae Hun
    • The Korean Journal of Pain
    • /
    • v.35 no.3
    • /
    • pp.345-352
    • /
    • 2022
  • Background: Optimal needle depth in transforaminal epidural injection (TFEI) is determined by body measurements and is influenced by the needle entry angle. Physician can choose the appropriate needle length and perform the procedure more effectively if depth is predicted in advance. Methods: This retrospective study included patients with lumbosacral pain from a single university hospital. The skin depth from the target point was measured using magnetic resonance imaging transverse images. The depth was measured bilaterally for L4 and L5 TFEIs at 15°, 20°, and 25° oblique angles from the spinous process. Results: A total of 4,632 measurements of 386 patients were included. The lengths of the left and right TFEI at the same level and oblique angle were assessed, and no statistical differences were identified. Therefore, linear regression analysis was performed for bilateral L4 and L5 TFEIs. The R-squared values of height and weight combined were higher than the height, weight, and body mass index (BMI). The following equation was established: Depth (mm) = a - b (height, cm) + c (weight, kg). Based on the equation, maximal BMI capable with a 23G, 3.5-inch, Quincke-type point spinal needle was presented for three different angles (15°, 20°, and 25°) at lumbar levels L4 and L5. Conclusions: The maximal BMI that derived from the formulated equation is listed on the table, which can help in preparations for morbid obesity. If a patient has bigger BMI than the one in the table, the clinician should prepare longer needle than the usual spinal needle.

Health-related Community Facility Characteristics Typification and Relationship to Transaction Prices (건강 관련 커뮤니티 시설 특성 유형화 및 거래가격과의 관계)

  • Choi, Won-Joon
    • The Journal of the Korea Contents Association
    • /
    • v.22 no.8
    • /
    • pp.358-366
    • /
    • 2022
  • Recently, 'Apartment community facilities' have emerged as the most optional factor in the apartment market, and their level is becoming very important. Therefore, this study derived each type through latent profile analysis centering on health-related community facilities in 126 domestic main apartment complexes, and as a result of the analysis, it was confirmed that it was divided into a Pilates group, GX and Yoga group, Golf and Table Tennis practice range group, and overall low group. Among the four groups, Pilates, GX, and yoga groups are more likely to belong to Gangnam, Seocho and Songpa compared to complexes with many golf and table tennis practice ranges, and at the same time, the transaction price is also the highest. Through these analysis results, it was suggested that changes in the preference for leisure activities should be reflected when constructing community facilities, and that health-related community facilities should be deeply considered in residential welfare policies in consideration of high preference for fitness facilities in youth housing.

Data Babe Development for Blue Jeans Marketing Strategy(Part ll) - Focused on Young Adult's Brand Awareness, Brand Image and Consumer's Seeking Image in Fall 1997- (진의류 마케팅 전략을 위한 데이타 베이스 구축에 관한 연구(제2보) -1997년 추계 신세대 진바지 소비자의 상표 인지도, 상표 이미지와 소비자의 추구이미지를 중심으로-)

  • 김칠순;이훈자
    • Journal of the Korean Society of Clothing and Textiles
    • /
    • v.22 no.4
    • /
    • pp.503-514
    • /
    • 1998
  • The purpose of this study was to develop a large representative data base for jeans marketing strategy This study was to survey brand features(launching year, launching company, design concept, sales volume, and price zone) in the current market, and was to examine brand awareness and it's relationship to segmented distribution regions, demo- graphic variables(sex, age, monthly household income, and seasonal clothing expenditure). This study was also to analyze brand image and consumer's seeking image. The 660 questionnaires were distributed and 618 reliable ones were used for statistical analysis. A SAS statistical package including frequency table, Chi-square test, factor analysis, analysis of variance(ANOVA), Duncan's multiple range test and paired-t test was used. The results are as follows: 1. Brand awareness involves "brand recall" based on asking a person to name the brand recalled first, and "brand recognition" based on asking to identify brand name from 30 given brands. The result of recall brand test indicated that Levi's was dominant brand. People recognized about 70.8% of brands on the average. Brand recognition was influenced by segmented distribution region and demographic variables. 2. There was significantly positive relationship between brand recognition and purchasing behavior. 3. National brands were more recognized than Licensed brands. 4. The result showed that "Nix" was best represented for sophisticated brand image, "Strom" for characteristic, "Jambangee" for resonable price, and "Levi's" for classic '||'&'||' comfortable brand image. 5. As a result of factor analysis on consumer's seeking image, six factors(characteristic, young, intelligent/sexy, comfortable, exotic and popular) were found. Several factors had a relationship with preferred design, demographic variables, fashion interest, and brand recognition. variables, fashion interest, and brand recognition.

  • PDF

Similarity Relationship between Basic Species of the Oak by the Numerical Method (수치분석(數値分析)에 의(依)한 참나무 기본종(基本種)의 유연관계(類緣關係))

  • Ma, Sang-Kyu
    • Journal of Korean Society of Forest Science
    • /
    • v.21 no.1
    • /
    • pp.47-51
    • /
    • 1974
  • In order to prove the similarity relationships between the basic species of oak through Electronic Data Processing System(EDPS) and numerical analysis, The analized species and datas were selected from the list of morphological observation in the thesis of T.B. Lee, 1961, "Phytogenetic study of the subgenus Lepidobalanus of the genus Quercus in Korea", and were coded by categories shown in Table 1. The value in the list were transformed into hundred percentage to standardize the observational value by each code into dimensionless. The similarity index between species were computed through formula of non-metric coefficient, $N_{jk}=\sum\limits_{i=1}^{n}\(\frac{{\mid}x_{ij}-x_{ik}{\mid}}{x_{ij}+x_{ik}}\)$, using the UNiVAC-1106, at National Computer Center. Quercus aliena, by analysis result, is most similar to Q. mongolica with the similarity index, 71.6 and Q. dentata is most far apart from Q. serrata in the relationship with index, 121.4. The above thesis of Professor, T. Lee, are closely similar with the result of this research study. But, their similar relationship are proved in quantity through numerical method in our research study. In addition, The relationships among Q. mongolica, Q. aliena and Q. serrata are found to be very similar, but Q. dentata to be enough far in similarity to other species by dendrogram shown at Fig. 1. The numerical classification through EDPS is found to be suitable method also applicable to the plant taxonomy.

  • PDF