• Proceedings of the Korean Operations and Management Science Society Conference
• /
• 1996.04a
• /
• pp.183-186
• /
• 1996

The relational database management systems sometimes require extremely long and complicated queries for a certain retreval. In this case, recursive retirevals are more efficient approach than the usual queries. Many researchers have tried to incorporate semantics in the traditional relational models using artificial intelligence techniques. This new concept becomes a deductive database and sometimes it is also called as a logic programming. However, the designer of a deductive database did not overcome the short of relational database. In this paper, we propose a new way of designing queries for the deductive database. We also provide relations for recursive retrieval in the deductive database. These approaches are applied for the material requirement planning.

• KSII Transactions on Internet and Information Systems (TIIS)
• /
• v.3 no.3
• /
• pp.235-250
• /
• 2009

An understanding of performance of database driven network applications is critical in combating slow performance of e-commerce web sites, besides efficient web page design, and high quality and well-maintained web server equipment. This paper describes a method of measuring performance from the user viewpoint, which can help enormously in making realistic assessment of true performance of database driven applications. The performance measurements were taken at user locations by using several specially designed JavaScript functions along with ASP scripts. A performance study is presented in this paper, comparing performance of data access using stored procedures with the traditional way of querying a database. It is generally believed that stored procedures have performance benefits as they are pre-compiled. However, our study shows that the data access approach using stored procedures provides significant benefits(by about 30%) over the traditional approach for querying a commercial MySQL database, only when retrieving a substantial amount of data(at least 10,000 rows of data).

• Digital Contents
• /
• no.7 s.62
• /
• pp.72-75
• /
• 1998

오늘날 EIS는 한정된 자원을 가지고 최종 사용자에게 강건하며 동시에 유연한 상업적 데이터 마트 배급 구조를 짧은 시간안에 제공해야 한다는 어려움에 봉착해 있다. 마트 배급 구조에서 요구되는 것은 SQL에 관한 상당한 지식을 가지고 있는 전문가들로부터 항상 동일한 형식의 보고서들이나 OLAP 쿼리를 행하고자 하는 순수한 의미의 최종 사용자들에 이르는 다양한 부류의 사용자들을 지원해야 한다. 덧붙여서 이러한 구조는 ROLAP, DOLAP, 엑셀, 스프레드시트 등 모든 파일 형식상에서의 데이터 배급을 지원할 수 있을 만큼 유연해야 한다.

• 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 Institute of Industrial Engineers
• /
• v.41 no.2
• /
• pp.162-172
• /
• 2015

This paper proposes a Product Data Management (PDM) system architecture that supports end-user computing for small and medium businesses (SMBs) in Korea to build and maintain efficient and sustainable information systems for their product development. Its open database with relational tables enables existing common application programs such as Microsoft office suites to access product data in PDM systems. In addition, the interactive query processor provided by database management systems helps design engineers to build ad hoc queries in standard SQL database language to response different data requirements during their product development. The PDM architecture with the open database allows design engineers or technical staffs in SMBs to build and maintain their application programs for product development by themselves. To show the feasibility of the proposed architecture, this study implemented a prototype PDM system based on the architecture and database, and represents real-world product data with the implemented PDM system.

• 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.

• Journal of the Korea Society of Computer and Information
• /
• v.22 no.11
• /
• pp.57-63
• /
• 2017

The recent sudden increase of big data has characteristics such as continuous generation of data, large amount, and unstructured format. The existing relational database technologies are inadequate to handle such big data due to the limited processing speed and the significant storage expansion cost. Thus, big data processing technologies, which are normally based on distributed file systems, distributed database management, and parallel processing technologies, have arisen as a core technology to implement big data repositories. In this paper, we propose a design methodology for large-scale database based on MongoDB by extending the information engineering methodology based on E-R data model.

• KIISE Transactions on Computing Practices
• /
• v.24 no.3
• /
• pp.105-112
• /
• 2018

As data size increase, a single database is not enough to serve current volume of tasks. Since data is partitioned and stored into multiple databases, analysis should also support parallelism in order to increase efficiency. However, traditional analysis requires data to be transferred out of database into nodes where analytic service is performed and user is required to know both database and analytic framework. In this paper, we propose an efficient way to perform K-means clustering algorithm inside the distributed column-based database and relational database. We also suggest an efficient way to optimize K-means algorithm within relational database.

• Proceedings of the Korea Database Society Conference
• /
• 1998.09a
• /
• pp.347-364
• /
• 1998

Oracle's KM Technology ㆍCore Technologies - Oracle Application Server 4.0 JCORBA Cartridge, JTS - Oracle 8.1 JavaVM, Java Stored Procedure, CORBA/ORB, IIOP - ConText Carridge 8.1 - Enterprise Scalability and Performance - Open SQL Query Layer - Fully-Extensible Object Model for custom solutions ㆍNext Plan - Oracle Application Server 4.1 EJB Cartridge(omitted)

• Digital Contents
• /
• no.7 s.74
• /
• pp.33-35
• /
• 1999

데이터 관리 및 교환 분야의 국제 표준화를 추진하고 있는 JTC1/SC32의 총회 및 작업반 회의가 5월24일부터 28일까지 일본 마츠에에서 개최되었다. 이번 총회는 9개국에서 52명의 전문가가 참가하였으며, 텍스트 및 수치 데이터를 포함하여 그래픽 데이터를 처리할 수 있는 새로운 데이터베이스 언어인 SQL3의 국제 표준이 채택되었다.