• Journal of the Korean Society of Systems Engineering
• /
• v.6 no.1
• /
• pp.61-68
• /
• 2010

Generally EPC management system was simply management concept through the normal S/W. Our LNG Plant R&D Center wanted to the excellent management system from the S/W. So We developed the R&D management S/W and EPC management S/W Built in the Microsoft Project Server. Our system made to the customer Requirements. It was just User Interface protocol. But User Interface has more Weak position, because it makes from the MS Project Servers. Ms Projector server make easy to treat the project on the WBS. EPC parts mixed WBS and normally Ms SQL Database. It has very complicated Structures. Now We planed to make the general Database and Ms Project Server, It' means to the S/W Developer and Schedule Manager ability. We will successfully integrate R&D management system and EPC system and other softwares.

• Proceedings of the Korean Information Science Society Conference
• /
• 2000.10a
• /
• pp.311-313
• /
• 2000

인터넷 E-Business를 위한 ASP를 이용한 웹사이트 구축이 급속도로 증가하는 추세로 대화형 서비스를 제공하기 위해 데이터베이스인 MS SQL Server의 적용이 많아졌다. 따라서 본 연구에서는 웹사이트 구축시 데이터베이스의 성능개선을 위한 임시테이블의 램 활용기법에 대한 효율적인 모델을 제안하고 성능을 평가하였다. 이와 같은 결과로 웹서버의 성능개선에 임시테이블의 램 활용에 대한 기법이 유익하게 활용될 것이다.

• Proceedings of the Korea Association of Information Systems Conference
• /
• 2005.12a
• /
• pp.443-454
• /
• 2005

The purpose of this study is to show the operations and implementations of ASP web database which uses open-source web site packages called bighitonline video shop. Some literature reviews have been done to reveal robust theoretical background for this research And also, some basic experiments as Preparatory Processes have also been made by using some softwares such as Windows XP professional, IIS, MS SQL Server and others. The main purpose of these experiments is to show strong theoretical and practical backgrounds. These experimental results in the micro-level showed to be successful to understand the Interrelations of web components and web-site architectures.

• Journal of Korean Academy of Nursing Administration
• /
• v.7 no.3
• /
• pp.425-437
• /
• 2001

This reserch was to develop database software in order to handle a lot of clinical nursing data with nursing diagnoses, related factors, defining characteristics, nursing interventions, nursing activities and nursing outcomes. MS Access2000 and SQL was selected to use a general purpose database logic with an efficiency. MS Visual Basic 6.0 was used to construct the circumstance of Graphic User Interface. The Linkage Database of abdominal surgery patients was constructed from the clinical data and questionnaire. This database system could add related factors, defining characteristics, nursing activities in the database and analyze the statistical results through Access query. In the final stage, end-users satisfaction analysis using 5 points Likert scale was dong with the response of using the database system. The accuracy/trustworthiness of the database system was verified with the highest average scores as 4.42 and also, the efficiency as 4.21, user friendly function as 4.1.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.28 no.3
• /
• pp.115-120
• /
• 2005

In this paper, we propose a personal-computer-based wireless data access system, which use DS/SS(Direct Sequence Spread Spectrum) method and the ISM band of 2.44GHz radio frequency. By applying hi-directional transmission between wireless handy terminals and PCs or servers, it can be easily connected with any kinds of database systems such as Oracle, MS-SQL and MS-ACCESS. Therefore, it could be economically adopted as peripheral equipments for ERP or SCM systems.

• Proceedings of the Korean Information Science Society Conference
• /
• 2001.10a
• /
• pp.4-6
• /
• 2001

In this paper, we designed a system that can mine user's traversal patterns from web log files. The system cleans an input data, transactions of a web log file, and finds traversal patterns from the transactions, each of which consists of one user's access pages. The resulting traversal patterns are shown on a web browser, which can be used to analyze the patterns in visual form by a system manager or data miner. We have implemented the system in an IBM personal computer running on Windows 2000 in MS visual C++, and used the MS SQL Server 2000 to store the intermediate files and the traversal patterns which can be easily applied to a system for knowledge discovery in databases.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.19 no.6
• /
• pp.1301-1306
• /
• 2015

This paper is to automate the intelligent and equipment to recycle the volatile organic compounds in various a gas stations and a laundry, in real life. In addition, based the ZigBee module and TCP/IP communications on ICT technologies, it's propose an integrated management system to monitor and manage an liquid at a remote location.Furthermore, it's propose a service model that can be freely managed from a remote location based on the app on android. In this paper, we present a communication protocol of the bridge modules and a liquefier of intelligent control system based ZigBee and MCU(Micro Controller Unit). Through the development of smart app based android mobile services in an integrated management system, it's represent for liquefier to a DB server for remote management(MS SQL 2012) and a web server (OS: Windows 2008).

• The Journal of Korean Association of Computer Education
• /
• v.7 no.2
• /
• pp.25-34
• /
• 2004

Sixteen provincial Research Institute of Education and Science(RISE) in the country have provided good qualified multimedia educational materials that was produced by some special skilled teachers to elementary, middle and high school teachers using web services. And moreover KERIS and KICE have also produced educational materials and have a plan to integrate distributed multimedia educational materials that RISE produced. The development of KERIS's KEM metadata in 2001 and the making of educational material metadata of RISE is the first step of integration plan. These metadata can be used to make integration plan possible. But before taking integration plan, the study of how to integrate and manage it should be performed. Therefore, this paper introduces the technique of XML web service and JDBC with 3-tier system as the method of integrate distributed educational material metadata. The evaluation shows these two methods have similar response time with MS SQL Server 2000 and Oracle 9i. Thus, we conclude that JDBC and XML web service can be the proper solution to search XML-formatted metadata.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.13 no.4
• /
• pp.828-834
• /
• 2009

To get a better profit, standalone mobile game market shifts network-based mobile game. Currently, most of the game platform are separated into mobile to mobile, desktop to desktop, and console to console. Multi platform network game has a diverse problems including consistency control, object management technique, and bandwidth inconsistency. n this paper, we will introduce a multi-platform arcade game "Push-Push", which is played on desktop to mobile environment. The game guarantees realtime play between heterogeneous machine users and game item sharing between two platforms. e will focus n the issues of the 3rd generation multi platform games and propose some techniques or solving these problems. Our server database is implemented on MS SQL database, also the desktop programming tool is Visual Basic, and WIPI(Wireless Internet Platform or Interoperability) as a mobile platform.

• Journal of Korea Multimedia Society
• /
• v.6 no.5
• /
• pp.909-920
• /
• 2003

Nowadays, IT for CRM has been growing and developed rapidly. Typical techniques are statistical analysis tools, on-line multidimensional analytical processing (OLAP) tools, and data mining algorithms (such neural networks, decision trees, and association rules). Among customer data, web log data is very important and to use these data efficiently, applying OLAP technology to analyze multi-dimensionally. To make OLAP cube, we have to precalculate multidimensional summary results in order to get fast response. But as the number of dimensions and sparse cells increases, data explosion occurs seriously and the performance of OLAP decreases. In this paper, we presented why the web log data sparsity occurs and then what kinds of sparsity patterns generate in the two and t.he three dimensions for OLAP. Based on this research, we set up the multidimensional data models and query models for benchmark with each sparsity patterns. Finally, we evaluated the performance of three OLAP systems (MS SQL 2000 Analysis Service, Oracle Express and C-MOLAP).