• Title/Summary/Keyword: Table integration

Search Result 84, Processing Time 0.035 seconds

Linking Toponym Database with Digital Map Database (지명 활용을 위한 지명 DB와 수치지도 DB의 연계 방안 연구)

  • Choi, Jinmu;Kim, Min Jun;Choi, Don Gon
    • Journal of the Korean Geographical Society
    • /
    • v.49 no.2
    • /
    • pp.310-319
    • /
    • 2014
  • The purpose of this study was building a new method for map making with a toponym by connecting a toponym DB with a digital topographic map DB. First, the table of toponym history in the toponym DB was revised. Second, a table linking the toponym DB and the digital topographic map DB was added. To integrate the toponym DB and the digital topographic map DB, a loose-coupling method was suggested and the combination of legal Dong and a toponym could be used as ID for liking those two databases. Thus, the method presented in this study would be used for effective map making using a toponym. Through the improvement of a toponym DB, it is expected the active use of the toponym DB such as map making.

  • PDF

Transportation Network Data Generation from the Topological Geographic Database (GIS위상구조자료로부터 교통망자료의 추출에 관한 연구)

  • 최기주
    • Spatial Information Research
    • /
    • v.2 no.2
    • /
    • pp.147-163
    • /
    • 1994
  • This paper presents three methods of generating the transportation network data out of the topological geographic database in the hope that the conversion of the geographic database file containing the topology to the conventional node-link type trans¬portation network file may facilitate the integration between transportation planning mod¬els and GIS by alleviating the inherent problems of both computing environments. One way of the proposed conversion method is to use the conversion software that allows the bi-directional conversion between the UTPS (Urban Transportation Planning System) type transportation planning model and GIS. The other two methods of data structure conversion approach directly transform the GIS's user-level topology into the transportation network data topology, and have been introduced with codes programmed with FORTRAN and AML (Arc Macro Language) of ARC/INFO. If used successfully, any approach would not only improve the efficiency of transportation planning process and the associated decision-making activities in it, but enhance the productivity of trans¬portation planning agencies.

  • PDF

Four-valued Hybrid FFT processor design using current mode CMOS (전류 모드 CMOS를 이용한 4치 Hybrid FFT 연산기 설계)

  • 서명웅;송홍복
    • Journal of the Korea Computer Industry Society
    • /
    • v.3 no.1
    • /
    • pp.57-66
    • /
    • 2002
  • In this study, Multi-Values Logic processor was designed using the basic circuit of the electric current mode CMOS. First of all, binary FFT(Fast Fourier Transform) was extended and high-speed Multi-Valued Logic processor was constructed using a multi-valued logic circuit. Compared with the existing two-valued FFT, the FFT operation can reduce the number of transistors significantly and show the simplicity of the circuit. Moreover, for the construction of amount was used inside the FFT circuit with the set of redundant numbers like [0,1,2,3]. As a result, the defects in lines were reduced and it turned out to be effective in the aspect of normality an regularity when it was used designing VLSI(Very Large Scale Integration). To multiply FFT, the time and size of the operation was used as LUT(Look Up Table) Finally, for the compatibility with the binary system, multiple-valued hybrid-type FFT processor was proposed and designed using binary-four valued encoder, four-binary valued decoder, and the electric current mode CMOS circuit.

  • PDF

A study on the Effects of Input Parameters on Springback Prediction Accuracy (스프링백 해석 정도 향상을 위한 입력조건에 관한 연구)

  • Han, Y.S.;Oh, S.W.;Choi, K.Y.
    • Proceedings of the Korean Society for Technology of Plasticity Conference
    • /
    • 2007.05a
    • /
    • pp.285-288
    • /
    • 2007
  • The use of commercial finite element analysis software to perform the entire process analysis and springback analysis has increased fast for last decade. Pamstamp2G is one of commercial software to be used widely in the world but it has still not been perfected in the springback prediction accuracy. We must select the combination of input parameters for the highest springback prediction accuracy in Pamstamp2G because springback prediction accuracy is sensitive to input parameters. Then we study the affect of input parameters to use member part for acquiring high springback prediction accuracy in Pamstamp2G. First, we choose important four parameters which are adaptive mesh level at drawing stage and cam flange stage, Gauss integration point number through the thickness and cam offset on basis of experiment. Second, we make a orthogonal array table L82[(7)] which is consist of 8 cases to be combined 4 input parameters, compare to tryout result and select main factors after analyzing affect factors of input parameters by Taguchi's method in 6 sigma. Third, we simulate after changing more detail the conditions of parameters to have big affect. At last, we find the best combination of input parameters for the highest springback prediction accuracy in Pamstamp2G. The results of the study provide the selection of input parameters to Pamstamp2G users who want to Increase the springback prediction accuracy.

  • PDF

Data Cleaning and Integration of Multi-year Dietary Survey in the Korea National Health and Nutrition Examination Survey (KNHANES) using Database Normalization Theory (데이터베이스 정규화 이론을 이용한 국민건강영양조사 중 다년도 식이조사 자료 정제 및 통합)

  • Kwon, Namji;Suh, Jihye;Lee, Hunjoo
    • Journal of Environmental Health Sciences
    • /
    • v.43 no.4
    • /
    • pp.298-306
    • /
    • 2017
  • Objectives: Since 1998, the Korea National Health and Nutrition Examination Survey (KNHANES) has been conducted in order to investigate the health and nutritional status of Koreans. The food intake data of individuals in the KNHANES has also been utilized as source dataset for risk assessment of chemicals via food. To improve the reliability of intake estimation and prevent missing data for less-responded foods, the structure of integrated long-standing datasets is significant. However, it is difficult to merge multi-year survey datasets due to ineffective cleaning processes for handling extensive numbers of codes for each food item along with changes in dietary habits over time. Therefore, this study aims at 1) cleaning the process of abnormal data 2) generation of integrated long-standing raw data, and 3) contributing to the production of consistent dietary exposure factors. Methods: Codebooks, the guideline book, and raw intake data from KNHANES V and VI were used for analysis. The violation of the primary key constraint and the $1^{st}-3rd$ normal form in relational database theory were tested for the codebook and the structure of the raw data, respectively. Afterwards, the cleaning process was executed for the raw data by using these integrated codes. Results: Duplication of key records and abnormality in table structures were observed. However, after adjusting according to the suggested method above, the codes were corrected and integrated codes were newly created. Finally, we were able to clean the raw data provided by respondents to the KNHANES survey. Conclusion: The results of this study will contribute to the integration of the multi-year datasets and help improve the data production system by clarifying, testing, and verifying the primary key, integrity of the code, and primitive data structure according to the database normalization theory in the national health data.

A Study on the Spill-over Economic Effect Analysis of Cultural and Creative Industries in Henan Province, China (중국 허난(河南)성 문화창의산업의 경제적 파급효과 분석)

  • Zhang, Binyuan;Jia, Tingting;Bae, Ki-Hyung
    • The Journal of the Korea Contents Association
    • /
    • v.21 no.7
    • /
    • pp.363-373
    • /
    • 2021
  • The purpose of this research is to analyze the Spill-over economic effect of the cultural and creative industries(CCI) in Henan Province, China. The research object is the CCI of Henan Province, which is mainly based on five sectors out of 42 industries in the industrial association table of the Statistical Bureau of Henan Province, China in 2017 (culture, sports; recreation and research sector; experimental development and integrated technical services sector; information transmission, computer services and software sector; education sector, etc), and is analyzed through secondary integration and redefinition of the CCI of Henan Province. Through the analysis of Henan Province Industry Association Table, this paper provides some enlightenment to the future direction of the cultural and creative industries. The main analysis results are as follows. The total production inducement of the CCI in Henan province is 48,848 billion yuan, and in particular, the production inducement coefficient of the industry in Henan province is 2.72809, 2.23909 (total of columns and rows), Index of the power of dispersion is 0.26325, and the index of the sensitivity of dispersion is 0.87535. Income induction coefficient is 0.55211, production tax induction coefficient is 0.09291. Because CCI of Henan Province has full development potential, the government needs to provide active support and policy support, in addition to the need for legal provisions and supervision of market management. In order to improve the innovative development of the CCI, it is necessary to develop a new model of "CCI+X".

Scale and Scope Economies and Prospect for the Korea's Banking Industry (우리나라 은행산업(銀行産業)의 효율성분석(效率性分析)과 제도개선방안(制度改善方案))

  • Jwa, Sung-hee
    • KDI Journal of Economic Policy
    • /
    • v.14 no.2
    • /
    • pp.109-153
    • /
    • 1992
  • This paper estimates a translog cost function for the Korea's banking industry and derives various implications on the prospect for the Korean banking structure in the future based on the estimated efficiency indicators for the banking sector. The Korean banking industry is permitted to operate trust business to the full extent and the security business to a limited extent, while it is formally subjected to the strict, specialized banking system. Security underwriting and investment businesses are allowed in a very limited extent only for stocks and bonds of maturity longer than three year and only up to 100 percent of the bank paid-in capital. Until the end of 1991, the ceiling was only up to 25 percent of the total balance of the demand deposits. However, they are prohibited from the security brokerage business. While the in-house integration of security businesses with the traditional business of deposit and commercial lending is restrictively regulated as such, Korean banks can enter the security business by establishing subsidiaries in the industry. This paper, therefore, estimates the efficiency indicators as well as the cost functions, identifying the in-house integrated trust business and security investment business as important banking activities, for various cases where both the production and the intermediation function approaches in modelling the financial intermediaries are separately applied, and the banking businesses of deposit, lending and security investment as one group and the trust businesses as another group are separately and integrally analyzed. The estimation results of the efficiency indicators for various cases are summarized in Table 1 and Table 2. First, security businesses exhibit economies of scale but also economies of scope with traditional banking activities, which implies that in-house integration of the banking and security businesses may not be a nonoptimal banking structure. Therefore, this result further implies that the transformation of Korea's banking system from the current, specialized system to the universal banking system will not impede the improvement of the banking industry's efficiency. Second, the lending businesses turn out to be subjected to diseconomies of scale, while exhibiting unclear evidence for economies of scope. In sum, it implies potential efficiency gain of the continued in-house integration of the lending activity. Third, the continued integration of the trust businesses seems to contribute to improving the efficiency of the banking businesses, since the trust businesses exhibit economies of scope. Fourth, deposit services and fee-based activities, such as foreign exchange and credit card businesses, exhibit economies of scale but constant returns to scope, which implies, the possibility of separating those businesses from other banking and trust activities. The recent trend of the credit card business being operated separately from other banking activities by an independent identity in Korea as well as in the global banking market seems to be consistent with this finding. Then, how can the possibility of separating deposit services from the remaining activities be interpreted? If one insists a strict definition of commercial banking that is confined to deposit and commercial lending activities, separating the deposit service will suggest a resolution or a disappearance of banking, itself. Recently, however, there has been a suggestion that separating banks' deposit and lending activities by allowing a depository institution which specialize in deposit taking and investing deposit fund only in the safest securities such as government securities to administer the deposit activity will alleviate the risk of a bank run. This method, in turn, will help improve the safety of the payment system (Robert E. Litan, What should Banks Do? Washington, D.C., The Brookings Institution, 1987). In this context, the possibility of separating the deposit activity will imply that a new type of depository institution will arise naturally without contradicting the efficiency of the banking businesses, as the size of the banking market grows in the future. Moreover, it is also interesting to see additional evidences confirming this statement that deposit taking and security business are cost complementarity but deposit taking and lending businesses are cost substitute (see Table 2 for cost complementarity relationship in Korea's banking industry). Finally, it has been observed that the Korea's banking industry is lacking in the characteristics of natural monopoly. Therefore, it may not be optimal to encourage the merger and acquisition in the banking industry only for the purpose of improving the efficiency.

  • PDF

Development of OOKS : a Knowledge Base Model Using an Object-Oriented Database (객체지향 데이터베이스를 이용한 지식베이스 모형(OOKS) 개발)

  • 허순영;김형민;양근우;최지윤
    • Journal of Intelligence and Information Systems
    • /
    • v.5 no.1
    • /
    • pp.13-34
    • /
    • 1999
  • Building a knowledge base effectively has been an important research area in the expert systems field. A variety of approaches have been studied including rules, semantic networks, and frames to represent the knowledge base for expert systems. As the size and complexity of the knowledge base get larger and more complicated, the integration of knowledge based with database technology cecomes more important to process the large amount of data. However, relational database management systems show many limitations in handing the complicated human knowledge due to its simple two dimensional table structure. In this paper, we propose Object-Oriented Knowledge Store (OOKS), a knowledge base model on the basis of a frame sturcture using an object-oriented database. In the proposed model, managing rules for inferencing and facts about objects in one uniform structure, knowledge and data can be tightly coupled and the performance of reasoning can be improved. For building a knowledge base, a knowledge script file representing rules and facts is used and the script file is transferred into a frame structure in database systems. Specifically, designing a frame structure in the database model as it is, it can facilitate management and utilization of knowledge in expert systems. To test the appropriateness of the proposed knowledge base model, a prototype system has been developed using a commercial ODBMS called ObjectStore and C++ programming language.

  • PDF

A Study on Peak Power Reduction using Regenerative Energy in Railway Systems through DC Subsystem Interconnection

  • Jung, Seungmin;Lee, Hansang;Kim, Kisuk;Jung, Hosung;Kim, Hyungchul;Jang, Gilsoo
    • Journal of Electrical Engineering and Technology
    • /
    • v.8 no.5
    • /
    • pp.1070-1077
    • /
    • 2013
  • Owing to the consistent increase in energy efficiency issues, studies for improving regenerative energy utilization have been receiving attention in the Urban DC railway systems, where currently, the utilization of regenerative energy is low due to the lack of a specific plan for using this energy. The regenerative energy in railway systems has a low efficiency problem which results in the increase of the catenary voltage and a possibility to create problems to the electrical devices connected to the system. This paper deals with the power integration of large urban railway subsystems to improve regenerative energy utilization where the railway subsystems are integrated with other railway subsystems to improve the energy efficiency. Through the case studies, to find the realistic effect of integrated operation, the Seoul Metro subsystems, namely Line 5 and Line 7, has been applied. Also, evaluation for the electricity cost saving has been performed by using KEPCO electricity cost table.

Performance Analysis of Autorotation(1) : Analysis Method and the Effect of Aerodynamic table (자동회전의 성능해석(1) : 해석 기법과 공력 테이블의 영향)

  • Kim, Hak-Yoon
    • Journal of the Korean Society for Aeronautical & Space Sciences
    • /
    • v.40 no.1
    • /
    • pp.1-11
    • /
    • 2012
  • Performance analysis was performed for an autorotating rotor. For a given airspeed, shaft angle, and collective pitch, the steady state of autorotation was judged by using the transient simulation method(TSM), then the thrust, lift, and drag coefficient for that state were computed. Average thrust was calculated from the instantaneous thrusts, in which the TSM was used in blade thrust integration. The analysis method was applied to the model rotor that had been tested by wind tunnel. Some comparison between analysis and test was provided. Two types of two-dimensional airfoil aerodynamic data were utilized in analysis, and they were made by Navier-Stokes Solver in terms of Reynolds and Reynolds-Mach number. The quantitative difference of results using two data set was examined and compared.