• IE interfaces
• /
• v.10 no.2
• /
• pp.79-90
• /
• 1997

Documents in a traditional PDM(Product Data Management) system have been managed in a form of scanned document files or electronic documents developed by specific tools. Though each tool manages documents with its own systematical methods, it has drawbacks in data search, data integration and interchange, etc. For this reason, in this research we propose an efficient document management system for PDM by using the SGML(Standard Generalized Markup Language), one of CALS and ISO standards for document interchanges. Among documents to be managed in PDM, the engineering change notification (ECN) is taken into account. The DTD (Document Type Definition) has been constucted based on the logical analysis of the documents format, In addition, based on the DTD, DB classes have been designed by object-oriented paradigms and a prototype for document input/output and search has been developed using UniSQL ORDBMS (Object-Relational DBMS) and PowerBuilder under the client/server environment.

• Proceedings of the Korean Institute of Intelligent Systems Conference
• /
• 2008.04a
• /
• pp.89-91
• /
• 2008

엄청나게 쏟아져 나오는 데이터 홍수 속에서 오늘날의 업체와 연구기관에서는 신속하게 의사 결정을 해야 한다. 당면한 문제점들을 해결하기 위하여 접근할 수 있는 수많은 다양한 데이터 속에서 정확하게 경향을 파악하고 그 근본 원인을 찾아내어 신속하고 action을 행하는 것은 어떠한 회사에서도 성공에 있어서 가장 중요한 인자들 중의 하나이다. 초기 아이디어 도출, 연구 개발에서부터 제품의 생산, 판매 및 서비스에 이르기까지 모든 팀원들은 아주 빠르게 고도의 정확성으로 중요한 결정을 할 필요가 있다. 오늘날의 경쟁 시장에서 기업의 성공은 다른 경쟁자들보다 더 빠르게 결정을 할 수 있는 능력에 달려 있다. 이에 Sporfire에서는 사용자가 쉽고 빠르게 데이터를 분석하여 의사 결정을 할 수 있도록 다양한 기능을 제공하고 있다. 사용자가 SQL같은 전문 언어를 사용하지 않고도 다양한 데이터 source에서 쉽게 데이터를 가져오도록 Information Library를 이용할 수 있으며, 데이터베이스에 들어 있는 숫자들의 집합체를 다양한 차트와 도표들을 이용, 그래픽 적으로 제공해 줌으로써 데이터에 대하여 직관적으로 파악하여 신속하게 대응할 수 있도록 도와준다. 또한 그 결과물들을 MS 파워포인트, 엑셀시트, xml 등으로 저장하여 다른 용도로 사용할 수 있도록 하고 있다.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.30 no.2
• /
• pp.1-7
• /
• 2007

재료의 중량과 강도는 기계부품 특히 항공기의 부품에 중요한 요소가 되므로 가볍고 강인한 열처리 강화 알루미늄이나 티타늄 등이 많이 사용된다. 그러나 알루미늄은 용융점이 낮기 때문에 기계 가공 시 발생되는 열에 의해 부품이 얇고 길수록 쉽게 변형된다. 본 연구는 end milling 가공에서 최적의 절삭 parameter를 선정하여 열 변형을 최소화한다. 밀링 가공의 절삭속도, 이송속도, 절삭 깊이를 실험 인자로 정하여 다구찌 방법으로 실험을 계획하고 얇은 시편을 절삭하여 특성을 측정한다. 결과를 분산분석 (ANOVA) 과 signal to noise 비를 (SNR) 분석하여 최소 열 변형의 절삭 parameter를 찾는다. 실험의 data를 SQL database 프로그램화하여 다양한 절삭 환경에서 최소 열 변형과 최소 표면거칠기의 parameter를 찾을 수 있도록 하였다.

• International Journal of Knowledge Content Development & Technology
• /
• v.3 no.1
• /
• pp.65-80
• /
• 2013

Today, citation index information is used as an outcome scale of spreading technology and encouraging research. Article citation information is an important factor to determine the authority of the relevant author. Google Scholar uses the article citation information to organize academic article search results with a rank algorithm. For an accurate analysis of such important citation index information, large amounts of bibliographic data are required. Therefore, this study aims to build a fast and efficient system for large amounts of bibliographic data, and to design and develop a system for quickly analyzing cited information for that data. This study also aims to use and analyze citation data to be a basic element for providing various advanced services to the academic article search system.

• Proceedings of the KIEE Conference
• /
• 2007.10a
• /
• pp.489-490
• /
• 2007

This paper is intended to trace and management of a medical specimen and its report in a hospital. To avoid missing and decaying specimen and to establish of order in the circulation of specimen, at the moment sampling, RFID tags for each are on examiner. And then, specimen is monitored easily, quickly and, correctly. We developed implementation LIS system has better CQI (Continuos Quality Improvement) using RFID and XML, ADO.net, ASP.net, C# 2.0. RFID technology replaces to an existing the bar-code system. Also for more convenience, we used a PDA-RFID module. The LIS system consists of main sorrel, SQL 2005, event display and analysis web page developed using asp.net 2.0 and sharing specimen data information using XML technology.

• Proceedings of the Korean Institute of Building Construction Conference
• /
• 2009.11a
• /
• pp.253-256
• /
• 2009

To the success of the megaproject including various and complex facilities, it is needed to establish a database system. Developments in data collection, storage and extracting technology have enabled iPMIS to manage various and complex information about cost and time. Especially, when we consider that both the go and no go decision in feasibility, Cost is an important and clear criteria in megaproject. Thus, Cost data modeling is the basis of the system and is necessary process. This research is focus on the structure and definition about CBS data which is collected from sites. We used four tools which are Function Analysis in VE, Casual loop Diagram in System Dynamics, Decision Tree in Data-mining, and Normalization in SQL to identify its cause and effect relationship on CBS data. Cost data modeling provide iPMIS with helpful guideline.

• Proceedings of the Korea Society for Simulation Conference
• /
• 1992.10a
• /
• pp.12-12
• /
• 1992

This paper proposes an analysis method of Petri nets (PNs) using the relational algebra (RA). More specifically, we represent PNs in relations of the relational model. Based on such representation, we first develop an algorithms for analyzing properties of PNs, such as boundedness, conservation, coverability, reachability, and liveness. The advantage of this approach is as follows: First, the algorithms represented by RA can be easily converted to a query language such as SQL of the widely used, commercial relational database management systems (DBMSs). Second, we can alleviate the problem of state space explosion because relational DBMSs can handle large amounts of data efficiency. Finally, we can use the DBMS's query language to interpret the Petri nets and make simulation.

• Journal of the Korea Society for Simulation
• /
• v.1 no.1
• /
• pp.37-47
• /
• 1992

This paper proposes an analysis method of petri nets(PNs) using the relational algebra(RA). More wpecifically, we represent PNs in relations of the relational model. Based on such representation, we first develop an algorithm for generating reachability trees of PNs. we then develop an algorithm for generating reachability trees of PNs. We then develop algorithms for analyzing properties of PNs, such as boundedness, conservation, coverability, reachability, and liveness. The advantage of this approach is as follows: First, the algorithms represented by RA can be easity converted to a query language such as SQL of the widely used, commerical relational database management systems(DBMSs). Second, we can alleviate the problem of state space explosion because relational DBMSs can handle large amounts of data efficiently. Finally, we can use the DBMS's query language to interpret the Petri nets and make simulation.

• Proceedings of the Korea Information Processing Society Conference
• /
• 2013.11a
• /
• pp.680-683
• /
• 2013

방화벽, 백신, IPS, 취약점 점검 시스템 등 중요 시스템의 보안을 위해 다수의 소프트웨어들이 운용되고 있다. 그 중 취약점 점검 시스템은 중요 서버의 보안 취약점을 점검하여 사전에 보안 위협을 예방한다는 측면에서 중요하다. 그러나 서버의 취약점을 점검해주는 소프트웨어 자체에 취약점이 존재한다면 취약점 보완을 위해 도입한 시스템이 취약점을 내포하고 있는 모순된 상황을 발생시킨다. 본 논문에서는 취약점 점검 시스템의 매니저와 에이전트의 점검 패킷을 분석하여 데이터 필드에 임의의 값을 주입하는 SPIKE 기반의 퍼즈 테스팅 기법으로 매니저와 에이전트 모두에서 DoS(Denial of Service) 취약점을 발견하였다. 해당 취약점은 다수의 SQL 세션을 생성하고 시스템의 CPU 점유율을 100%로 높여 시스템의 다른 서비스조차 이용할 수 없는 상태를 보였다.

• International journal of advanced smart convergence
• /
• v.11 no.1
• /
• pp.127-133
• /
• 2022

This study aims to find out the associative relationship between dementia and comorbidities. To conduct this study, we used KNHDIS(Korea National Hospital Discharge In-depth Injury Survey) data from 2009 to 2018 provided by the KDCA(Korean Disease Control and Prevention Agency) annually. We used MySQL for data preprocessing and R for data analysis. As a result of applying the Apriori algorithm criteria of support(≥0.01), confidence(≥ 0.6), and lift(>1), seventeen rules related to dementia were discovered. The diseases associated with dementia were diabetes mellitus, hypertension, disorders of lipoprotein metabolism, glomerular disorders in diabetes mellitus, renal diseases, cardiovascular disease, cerebrovascular disease, and other urinary system disorders. This study can be utilized as primary data for the care of patients with dementia and provides implications for improving effective dementia prevention policies.