• Proceedings of the Korean Information Science Society Conference
• /
• 2003.10b
• /
• pp.106-108
• /
• 2003

XML은 고유의 확장성과 문서 관계성의 우수성을 활용하여 새로운 정보 공유 환경의 표준으로 자리잡고있다. XML 문서의 사용이 많아지면서 대용량의 XML 문서를 효과적으로 저장, 관리 및 검색하기 위한 시스템이 필요하다. 본 연구는 관계 데이터베이스 시스템(RDBMS)을 기반으로 XML 문서를 저장하고 검색할 수 있게 하기 위해서 Numbering 기법에 의한 XML문서 저장 기법을 사용하였다. XQuery 질의를 SQL문장으로 변환시켜서 수행함으로써 XML 데이터에 대한 검색을 가능하게 하였다.

• Proceedings of the KSRS Conference
• /
• 2003.11a
• /
• pp.499-501
• /
• 2003

As semiconductor memory becomes cheaper, the memory capacity of computer system is increasing. Therefore computer system has sufficient memory for a plentiful spatial data. With emerging spatial application required high performance, this paper presents a GIS database system in main memory. Memory residence can provide both functionality and performance for a database management system. This paper describes design of DBMS for storing, querying, managing and analyzing for spatial and non-spatial data in main-memory. This memory resident GIS DBMS supports SQL for spatial query, spatial data model, spatial index and interface for GIS tool or applications.

• Journal of Internet Computing and Services
• /
• v.4 no.6
• /
• pp.33-42
• /
• 2003

A XML Instance repository model based on the Edge-Labeled Graph is suggested for storing the XML instance in Relational Databases, This repository model represents the XML instance as a data graph based on the Edge-Labeled Graph, extracts the defined value based on the structure of data path, element, attribute, and table index table presented as database schema, and stores these values using the Mapper module, In order to support querry, XML repository model offers the module translating XQL which is a query language under XPATH to SQL, and has DBtoXML generator module restoring the stored XML instance. As a result, it is possible to represent the storage relationship between the XML instances and the proposed repository model in terms of Graph-based Path, and it shows the possibility of easy search of specific element and attribute information.

• Journal of Digital Contents Society
• /
• v.4 no.1
• /
• pp.115-126
• /
• 2003

In this paper, an objective of this research is to add convenience to the intranet operating within an educational institution, by setting up a messenger function to enable the faculties and teachers to make better use of the university database via Intranet. With this messenger services, the users can view the information about the members in a group they belong to, and register as friends a group of members they selected from the work group they are in. This function will reduce the cumbersome chores of adding one individual as a friend at a time. This research will enhance the Intranet within an educational institution by integrating new functions. Speciallly, In this paper, it is stored student data by the input form by the JDBC of XML standard data. Also, it is able to search of stored database to web sever from web client by the SQL quary.

• Journal of the Korea Institute of Information and Communication Engineering
• /
• v.7 no.5
• /
• pp.993-1001
• /
• 2003

A RDB Storage Model based on the Edge-Labeled Graph is suggested for store the XML instance in Relational Databases(RDB). The XML instance being stored is represented by Data Graph based on the Edge-Labeled Graph. Data Path Table, Element, Attribute, and Table Index Table values are extracted. Then Database Schema is defined, and the extracted values are stored using the Mapper. In order to support querry, Repository Model offers the translator translating XQL which is used as query language under XPATH, into SQL. In addition, it creates DBtoXML generator restoring the stored XML instance. As a result, storage relationship between the XML instance and proposed model structure can be expressed in terms of Graph-based Path, and it shows the possibility of easy search of random Element and Attribute information.

• Journal of Korea Society of Industrial Information Systems
• /
• v.8 no.2
• /
• pp.98-107
• /
• 2003

The purpose of this study is to propose the schema for process repository that overcomes the limitations of existing process repositories in which it is not easy to compare and analyze such the unstructured data as a process model. To achieve this goal, the previous studies on process repository are reviewed, the schema for process repository is designed, and the tables for relational database are created. For the validation of the schema presented in this paper, the process model stored in relational database is examed using SQL. The contributions of this study are as follows. First, the schema for process repository storing process models is designed and validated. Second, the process model created by the new schema and stored in relational database leads to improve the performance of process analysis.

• Journal of Intelligence and Information Systems
• /
• v.9 no.1
• /
• pp.211-225
• /
• 2003

This paper aims at the design of collaborative architecture for business to business (B2B) applications based on Web service protocol. As different business processes should be interfaced in the B2B environment collaboration is important fur the success of B2B implementation. For the development tools, XML, Web services and ASP.NET were adopted Web services are emerging to provide a systematic and extensible framework for application-to-application interaction. The Web services framework is divided into three areas; communication protocols, service descriptions and Web discovery. Web services such as SOAP, WSDL and UDDI correspond to the three areas respectively. ASP.NET is utilized which corresponds to the component and service set located in the top layer of .NET. For the service of product category and product details, Web service architecture was implemented based upon the SQL server database.

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

• Journal of The Korean Association of Information Education
• /
• v.7 no.2
• /
• pp.199-206
• /
• 2003

XML is becoming a new developing tool of web technology because of its ability of data management and flexibility in data presentation. So it's well researched that the reusability and integration with learning objects such as text, image, sound, video and plug-in programs of web contents in computer education. But the research for storing, extracting and integrating metadata about learning object was needed prior to implementing online learning system to integrate and manage it. Therefore this study propose a new method of using web service of DBMS for extracting learning object's metadata in database server which located in 3-tier system. To evaluate the efficiency of proposed method, The test server and two DBMSs(MS SQL Server 2000 and Oracle 9i) which have 30 metadata was implemented and the response time of it was measured. The response time of it was short, but in order to using this method the additional programming with SAX/DOM was necessary.

• Journal of the Society of Cosmetic Scientists of Korea
• /
• v.29 no.2 s.43
• /
• pp.233-250
• /
• 2003

We often use the KCID(Korean Cosmetic Ingredient Dictionary) and ICID(International Cosmetic Ingredient Dictionary) within cosmetics research and within their export and import. so far, we do not have a database of a cosmetics' raw materials. Because of this, we consume a lot of time to find the raw material data that is needed. This study constructs a cosmetics' raw material database and develops the program to retrieve it. We used a Linux machine as the equipment for this study and we used Apache web server, MySQL database server and PHP as the tools of this study. 11,817 kinds of raw materials data were registered as ICID, 866 kinds of raw materials data were registered as KCID and 28,008 kinds of raw materials data with registered trade name into the database. Also, The database was composed of the database of the association form. The database of the online form could ultimately reduce the task time as soon as it did its purpose. The product of this study can become a good basis of data to reconfigure. In the future, it can become a good database in relation with different databases.