데이터 웨어하우스 설계에서 다차원 모델링에 관한 연구

고석용 제주한라대학 1997 論文集 Vol.21 No.-

The definition of the data warehouse which is proposed is : A corporate data warehouse is a single integrated store of data which provides the infrastructural basis for informational software applications in the enterprise. The Corporate data warehouse may be defined in terms of six key characteristics which differentiate the data warehouse from other database systems in the enterprise. (1) Available entirely for the task of making data available to be interrogated by business users. (2) Separate from the operational system in the enterprise and populated by data from these systems. (3) Integrated on the basis of a standard enterprise model. (4) Time stamped and associated with defined periods of time, i. e. calendar periods or fiscal reporting periods. (5) Subject oriented, most usually on the basis of 'Customer'. (6) Accessible to users who have a limited knowledge of computer systems or data structures. The multidimensional database systems differ from relational database systems in that they are currently highly proprietary in nature, typically do not directly support SQL, and can support significantly less volume of data than even an "average"RDBMS. However, multidimensional database systems may be an excellent option for a departmental instance if the functionality it provides is what the business requirements of the target user demand. In the coming 'Age of Information', data will not just comprise entities in a database which have got attributes and relations but data will have texture through which hidden structures and patterns can be revealed. This will fundamentally transform our understanding of information from 'something we desire to know' to 'something which could never have otherwise been knowable'.

수용성 키틴이 백서 창상치유에 미치는 영향

강장석,조용남,정상훈,유 결,임진수,권 호,조용우,고석원 大韓成形外科學會 2001 Archives of Plastic Surgery Vol.28 No.1

의약품중 잔류유기용매 시험법 확립에 관한 연구

고용석,강찬순,최보경,김혜수,홍정희,최명신,김상현,장성재,김길수 식품의약품안전청 2001 식품의약품안전청 연보 Vol.5 No.-

Headspace-GC(딘5-GC)를 이용하여 ICH 잔류웅매 가이드라인 class 1, 2에 속하는 28종의 잔류유기웅매 분석방법을 연군한 결과 SPB-5, BB-WAX column을 동시 이용하여 각각을 확인, 정량할 수 있었다.또한 염의 참가효과, 평형시간,평형온도가 headspace분석에 미치는 영향을 검토한 결과 평형 시간 30분,평형온도 85℃,Na₂SO₄Ig을 첨가하여 시험할 때 최적 부넉조건을 나타내었다. 회수율은 1,1-achloroethene(68.3%)를 제외하고 90.9 ~ 114.5%로 패체적으로 양호하였다. 따로 HS-GCJECD, DB-524 column을 이용하여 9종의 잔류유기용매에 대하여 각각의 검랸선을 작성하고 검출한계를 구하였다. 실제 의약품 원료 10종및 제제 5종에 적용시킨 결과 모두 불검출되었으며 본 시험법은 의약품중의 잔류유기용매 분석에 적용할 수 있는 방법이라고 판단된다. The headspace-fC/FID(HS -GC/FID) method was performed for test method developnlent of residu;31 organic solvents in pfrarmaceuticals. Using SPB-S and BB-WAXcolumn, 28 kinds of solvents iri ICH residual sof)·ents guidetine class 1, 2 couBd be individuallt-identified and quantitated. The foIBowing residoal soIYents were not detected by the headspaceinjection condition : N,N-Cmethylacetamide, N,N-dimeth)rlformamide, ethyfeneglycol, formamide,2-methoryethanot, N-rnethylpyrrolidone, suBforane. The effects of the addition of salts,equilibration time, and equilibration temperature on headspace analt·sis were invesugated. Theoptimum conditions weiFe obtained with addtion of Ifa2s04 19 as a salt, simultaneously. thetime and temperature of equitibration were 30min and 8i'f, respectivety. The recovery havefound between 90.9 and 114.5% except 1,1-dichloroethene(fi8.3%). Using DB-624 column &HS-GC/:ECD method, 9 kinds of residual solvents could be individually identified andfuantitated. This HS-GC method can be applied to test the residua3 organic solvent in thepharmaceuticals.

공개키 기반 구조에 관한 연구

고석용 제주한라대학 2001 論文集 Vol.25 No.-

Unlike the existing applicable systems, electronic commerce focuses on securing means of identifying a user and verifying data as well as controlling an access to data. It is electronic signature that is an instrument to meet security requirements inherent to electronic commerce. EC also requires a high level of reciprocity among EC-related applicable systems in addition to a strong verification of users. Therefore, security functions need to be installed in a way that supports reciprocity. Fundamental security requirements for electronic commerce are confidentiality, zero-defect, verification, endowment of rights, guarantee and privacy. A framework of information protection for the security of EC needs to be built systematically so that safety and confident in EC can be secured. AS the transaction can not be processed on line without an electronic payment system in EC, an on-line payment system intended to process the transaction money is a significant part in affecting the efficiency of EC

조직간 정보시스템의 전략적 선택에 관한 연구

고석용 제주한라대학 1999 論文集 Vol.23 No.-

This paper discusses two critical strategic choices that a firm must makes in developing inter-organizational information systems(IOIS)-what kind(s) of IOIS(s) to develop, and how to develop the IOIS(s). With respect to the kind of IOIS(s), it proposes a typology of three different types of IOlSs: electronic monopolies, electronic dyads, and multilateral IOISs. The nature of IOIS can be better understood by examining two typologies that have been proposed. Malon et al. describe two types of IOIS, based on whether they electronically facilities hierarchies or markets. In electronic hierarchies between two legally separated firms, managerial decisions control the flow of materials through the value added chain. Information technology has radically altered the management of supply chain operations: many business patterner who are adjacent on the supply chain con gain from entering interorganizational information sharing relationships and sharing information that was previously accessible to only one of them. This situation is typical in retailer-supply logistics management relationships. This study finds that there are four primary policies that firms adopt when they exchange information across the supply chain; these are EDI, vendor management inventory(VMI), continuos replenishment(CR), and category management(CM).

동절기 신관리 석실고분 내부의 온·습도 분포특성

전용두,이금배,김홍기,고석보 공주대학교 문화재보존과학연구소 2004 문화재과학기술 Vol.3 No.1

개방된 고분의 장기보존은 조상의 얼이 담긴 문화재를 길이 후손에 물려주어야 하는 우리들의 시대적 사명이라 할 수 있다. 그런데 고분 내부의 공기조화를 필요로 하는 경우 설비측면에서 고분내부의 공기조화 문제를 검토한 사례는 그 동안 많지 않았다. 특히 고분 내부환경에 관한 온·습도 자료는 매우 제한적으로 알려져 있는 상태이다. 본 연구는 고분의 공기조화와 관련하여 부하산정 등의 기초자료로 활용하기 위한 고분내부의 온·습도자료를 원격측정 기술을 적용하여 획득한 결과를 소개하며, 이를 통하여 고분내부의 실내환경 조건에 대한 일반의 이해를 돕고, 더 나아가 공조기 설치에 필요한 기초자료를 제공하고자 수행하였다. 측정 연구대상은 충남 공주시 신관동에 소재한 신관리석실고분(충청남도 기념물 제 7호)으로서 백제후기의 횡혈식 석실고분으로서 현실의 크기는 폭 1.25m, 깊이 2.73m 그리고 높이 1.50m이며, 현실입구는 개방된 상태에서 실내 5채널 및 실외공기에 대하여 각각 온도와 습도를 측정하였으며, 본 본문에서는 동절기(12월부터 다음 해 3월까지)의 자료를 소개한다. In recent years the importance of the preservation of cultural artefacts like ancient tombs has been widely accepted domestically and internationally as the quality of life improves. However not much attention has been paid for the facilities and systems to preserve those artefacts. Even the general understanding of the preservatory environment of the underground space as tombs is poor. In the present study, the temperature and relative humidity inside a selected artefact, Shinkwan-ri tomb, are monitored to improve the understanding of the indoor thermal environment, which may possibly be used when one consider air-conditioning for preservation. Total of 12 channel data are collected by using remote data acquisition system based on the cdma(Code Division Multiple Access) technology. Three-month-data representing winter season is reported with discussions.

배가스 폐열회수를 위한 히트파이프 적용성 검토

전용두,박기호,고석보 公州大學校 工學硏究院 生産技術硏究所 2005 論文集 Vol.13 No.-

A Series of experiments are performed to investigate the heat transfer characteristics of sintered metal wick heat pipe especially focusing on the operational limit of maximum allowable thermal loads and the effect of inclination slope. Tested heat pipes are composed of copper tube with pure water as a working fluid. The outer diameter of the heat pipe is 6mm and the total length is 300mm, which covers the evaporator section(50mm), adiabatic section(100mm) and condenser section(150mm). respectively. Experimental data of wall temperature distribution along the axial locations are obtained to evaluate the performance of the heat pipe at different slopes. Each test is performed by changing the input thermal loads ranging from 5W to 30W.

공조시스템을 적용한 석실 고분내 온ㆍ습도 분포

전용두,이금배,박진양,고석보,전희호 公州大學校 工學硏究院 生産技術硏究所 2005 論文集 Vol.13 No.-

Although the importance of good conservation of historic sites including ancient royal tombs is well aware, still not much attention has been paid for the facilities and systems to preserve those historic sites, which includes precious artifacts as wall paints and carved works, etc. Even the general understanding about the environment of the underground space of tombs is not satisfactory. In Korea, researchers have recently begun addressing the above issue and are making efforts to develop suitable HVAC(heating, ventilating and air-conditioning) systems for conservation of tombs. An experimental investigation was carried out to study the behavior of the HVAC system installed for a tomb. This tomb resembles in size and shape the original stone built tomb of Baek-je Dynasty, which dates back to 6th Century in southwest part of Korean peninsula. In this study, an HVAC system for a tomb(D×W×H=1.3m×3.0m×1.2m) was installed to maintain sui표 indoor conditions for conservation of tomb. The temperature and humidity inside the tomb were measured different of the setting. Finally, performance of the HVAC system is presented and discussed.

열화상카메라를 이용한 LCD-TV의 열분포 분석 및 방열 성능 향상을 위한 연구

김윤석,김용재,이정권,정두환,고한서 한국비파괴검사학회 2004 학술대회 논문집 Vol.- No.-

In these days, demand of a LCD-TV is remarkably increasing with development of the LCD technology. However, there are thermal problems for improvement of efficiecy for the LCD-TV. Thus, this research analyzed thermal problems such as convection and conduction heat transfer characteristics in the LCD-TV using an infrared (IR) camera. The results using the IR camera have been compared with those using T-type thermocouples. The results of the experiment showed that; 1. surface temperatures of inverter modules, CCFL and electrodes were higher than any other parts in the LCD-TV. 2. temperature distributions of the LCD-TV appeared asymmetrically based on the center line. 3. results of the two testing equipments agreed well.

제주도 연안 갈치 채낚기 어구의 생력화 : 1. 연속식 채낚기어구의 모형 실험

서두옥,정용진,김석종,이창헌,김고환,박용석 제주대학교 해양연구소 2000 해양자원연구소연구보고 Vol.24 No.-

The authors carried out a model experiment of continuous hairtail hand line on the rooftop in order to obtain the fundamental data on elimination of labor with hairtail hand line in the coast of Jeju The results are as follow : 1. The continuous main line was rotated smoothly by driving roller. 2. The branch lines and hooks on a main line which was rotated by rotary machine were entangled slightly. 3. The branch lines attached to rubbered model of hairtails to hooks were rotated continuously by the rotary machine.