• Title/Summary/Keyword: MS-SQL Database

Search Result 50, Processing Time 0.03 seconds

An XPath Accelerator on Relational Databases: An Implementation and Its Tuning (관계형 데이터베이스를 이용한 XPath Accelerator: 구현과 튜닝)

  • Shin Jin-Ho;Na Gap-Joo;Lee Sang-Won
    • The KIPS Transactions:PartD
    • /
    • v.12D no.2 s.98
    • /
    • pp.189-198
    • /
    • 2005
  • XML is rapidly becoming the standard for data representation and exchange, and XML documents are being adopted in various applications. Since the late 1990s, some native XML database management systems(DBMSs) have been developed. More recently, commercial relational DBMS vendors try to incorporate full functionalities of XML into their products, such as Oracle, MS SQL and IBM DB2. In this paper, we implement a well-known RDBMS-based XML data storage and indexing technique, called XPath Accelerator, and tune it in an industry-leading RDBMS. Our contributions are two-folds: 1) an in-depth implementation of the XPath Accelerator technique and 2) its tuning to exploit the advanced query processing techniques of an RDBMS.

A Seminar Assistant System using IOCP Server Model (IOCP 서버 모델을 이용한 세미나 보조시스템)

  • Ahn, Hyun-Ju;Heo, Da-Jeong;Park, Dong-Gyu;Uh, Yoon
    • Journal of the Korea Institute of Information and Communication Engineering
    • /
    • v.13 no.4
    • /
    • pp.821-827
    • /
    • 2009
  • Currently, with the development of web 2.0 knowledge sharing system became more and more important. In this paper, we proposed and implemented seminar assistant system using database system and knowledge sharing system on public seminar. We recorded speaker's voice and presentation files on our system and user can review past talks on our seminar review systems. Our database system is implemented using MS SQL, and Input/Output Completion Port(IOCP) socket model as our server side network module. Also we used presentation software using Direct Show with MFC and Windows Presentation Foundation(WPF). and our review system is based on WFP programmed with C# language.

ASP 웹 디비의 운영과 실행에 관한 사례연구

  • U, Won-Taek
    • 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.

  • PDF

Development of Hydrologic Data Management System Based on Relational Database (관계형 데이터베이스를 이용한 수문자료 관리시스템 개발)

  • Kim, Hak-Kwan;Park, Seung-Woo;Kim, Sang-Min
    • Journal of Korea Water Resources Association
    • /
    • v.39 no.10 s.171
    • /
    • pp.855-866
    • /
    • 2006
  • In this paper, the Hydrologic Data Management System (HDMS) was developed for the efficient management of hydrologic data. The applicability of the system was demonstrated using the hydrologic data of study watershed located in the southwest from Suwon city MySQL 5.0, relational database management system, and MS Visual Basic 6.0 were used for the development of MS windows based HDMS. The primary components of the HDMS are data search system, data management system, and data analysis system. Data search and management systems provide basic functions for the efficient data search, storage, update and export. Data analysis system enables the users to get the further and diverse hydrologic statistical information from the stored data. Furthermore, the accuracy and quality of hydrologic data was analyzed and evaluated through data analysis system.

The Development of Short-term Load Forecasting System Using Ordinary Database (범용 Database를 이용한 단기전력수요예측 시스템 개발)

  • Kim Byoung Su;Ha Seong Kwan;Song Kyung Bin;Park Jeong Do
    • Proceedings of the KIEE Conference
    • /
    • summer
    • /
    • pp.683-685
    • /
    • 2004
  • This paper introduces a basic design for the short-term load forecasting system using a commercial data base. The proposed system uses a hybrid load forecasting method using fuzzy linear regression for forecasting of weekends and Monday and general exponential smoothing for forecasting of weekdays. The temperature sensitive is used to improve the accuracy of the load forecasting during the summer season. MS-SQL Sever has been used a commercial data base for the proposed system and the database is operated by ADO(ActiveX Data Objects) and RDO(Remote Data Object). Database has been constructed by altering the historical load data for the past 38 years. The weather iDormation is included in the database. The developed short-term load forecasting system is developed as a user friendly system based on GUI(Graphical User interface) using MFC(Microsoft Foundation Class). Test results show that the developed system efficiently performs short-term load forecasting.

  • PDF

The study of EPC System S/W based on the UI (EPC시스템에서 UI기반의 소프트웨어에 대한 고찰)

  • Hwang, Seong Ha;Yoo, Sun Il;Jeong, Jin Su
    • 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.

  • PDF

An Efficient Storing Scheme of Real-time Large Data to improve Semiconductor Process Productivities (반도체 공정의 생산성 향상을 위한 실시간 대용량 데이터의 효율적인 저장 기법)

  • Chung, Weon-Il;Kim, Hwan-Koo
    • Journal of the Korea Academia-Industrial cooperation Society
    • /
    • v.10 no.11
    • /
    • pp.3207-3212
    • /
    • 2009
  • Automatic semiconductor manufacturing systems are demanded to improve the efficiency of the semiconductor production process. These systems include the functionalities such as the analysis and management schemes for very large real-time data in order to enhance the productivities. So, it requires the efficient storage management system to store very large real-time data. Traditional database management systems(e.g. Oracle, MY-SQL, MS-SQL) are based on disk. However, previous DBMS's have the limitation on the low storing performance. In this paper, we propose a compress-merge storing method of very large real-time data using insert transaction of a block unit. The proposed method shows better processing performances compare to conventional DBMS's. Also compress-merge method makes it possible that it can store large real-time data on low storage cost. Therefore, the proposed method can be applied to an efficient storage management system in the semiconductor production process.

Using of RAM for Performance Tuning in Web Database Server (웹 데이터베이스 서버 성능개선을 위한 램의 활용)

  • 이원조;이단영;고재진
    • Proceedings of the Korean Information Science Society Conference
    • /
    • 2000.10a
    • /
    • pp.311-313
    • /
    • 2000
  • 인터넷 E-Business를 위한 ASP를 이용한 웹사이트 구축이 급속도로 증가하는 추세로 대화형 서비스를 제공하기 위해 데이터베이스인 MS SQL Server의 적용이 많아졌다. 따라서 본 연구에서는 웹사이트 구축시 데이터베이스의 성능개선을 위한 임시테이블의 램 활용기법에 대한 효율적인 모델을 제안하고 성능을 평가하였다. 이와 같은 결과로 웹서버의 성능개선에 임시테이블의 램 활용에 대한 기법이 유익하게 활용될 것이다.

  • PDF

Multiplatform Game Development using Wire and Wireless Communication (멀티플랫폼 유무선 연동게임 개발)

  • Kang, Youn-Jun;Park, Dong-Gyu
    • 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.

A Design and Implementation of Physiological Data Measurement System using Ubiquitous Sensor Network (유비쿼터스 센서 네트워크를 이용한 생리학적 데이터 측정 시스템의 설계 및 구현)

  • Min, Gyeong-Woo;Seo, Jung-Hee;Park, Hung-Bog
    • Proceedings of the Korean Institute of Information and Commucation Sciences Conference
    • /
    • 2010.05a
    • /
    • pp.852-855
    • /
    • 2010
  • Based on the rapid development of the computer network technology, the ubiquitous sensor network (USN) was developed to enable us to have access to the communication environment anywhere and anytime without the need for recognizing computers or networks. Moreover, with the increasingly high interest on individual health, the USN technology is being applied to diverse sectors for healthcare and disease prevention. In this paper, a system was designed and implemented using the USN-based RF communication for doctors and nurses who care patients in the hospital to easily measure and control the physiological data on blood pressure and blood sugar. In addition, a database was designed using MS SQL database to store and manage the blood pressure and blood sugar data, which were passively or actively measured from patients. Using the results of this study, the physiological data of patients can be managed in real time and emergency situation can be instantly addressed. It is expected that the healthcare service can be improved and the paradigm of healthcare service environment can be changed.

  • PDF