• Proceedings of the Korean Society of Precision Engineering Conference
• /
• 2001.04a
• /
• pp.627-630
• /
• 2001

XML is suitable to integrate various forms of engineering design data since it possesses the characteristics of both documents and data. In this research a web-based design system has been developed, which integrates various gear design data in the form of XML. The system generates XML document containing gear design data and transforms gear design data in the relational database into XML document form automatically. The XML documents are transmitted to gear modeler agent through SOAP, and then the agent is automatically executed and generates CAD model files and VRML files. The designer can check the generated VRML model of gear immediately in the web service.

• Interdisciplinary Bio Central
• /
• v.3 no.3
• /
• pp.9.1-9.5
• /
• 2011

Entity Attribute Value (EAV) is the widely used solution to represent high dimensional and sparse data, but EAV is not search efficient for knowledge extraction. In this paper, we have proposed a search efficient data model: Optimized Entity Attribute Value (OEAV) for physical representation of high dimensional and sparse data as an alternative of widely used EAV. We have implemented both EAV and OEAV models in a data warehousing en-vironment and performed different relational and warehouse queries on both the models. The experimental results show that OEAV is dramatically search efficient and occupy less storage space compared to EAV.

• Journal of Intelligence and Information Systems
• /
• v.10 no.3
• /
• pp.27-37
• /
• 2004

XML has been proposed as a document standard for the representation and exchange of data on the WWW, and also becoming a standard for the search and reuse of scattered documents. When implementing a XML contents management system, special consideration should be imposed on how to model data and how to store the modelled data for effective and efficient management of the semi-structured data. In this paper, we proposed a new data model for the storage and search of XML document data. This proposed data model could represent both of data and structure views of XML documents, and be applied to the new data system for XML documents as well as the existing data systems.

• Journal of Industrial Technology
• /
• v.25 no.A
• /
• pp.123-131
• /
• 2005

Semantic object model has widely been recognized as an alternative data modeling approach to entity-relationship model for database system design. In this study, we have presented a semantic object model for intermediary type shopping mall consisting of multiple buyers and sellers. Essential processes and information with regard to the customer management, product management, price estimation, product order etc. have been considered for this study. Upon careful examination and analysis of them, a detailed semantic objects and attributes have been drawn and structured into semantic object diagrams. The final objects were converted into an entity-relationship diagram so that intuitive comparison could be made for relational database design. The results in this study may form a conceptual framework for both academic concerns and more complicated system applications.

• Journal of KIISE:Databases
• /
• v.31 no.5
• /
• pp.445-456
• /
• 2004

The database schema is assumed to be stable enough to remain valid even as the modeled environment changes. However, in practice. data models are not nearly as stable as commonly assumed by the database designers. Even though a rich set of schema change operations is provided in current database systems, the users suffer from the problem that schema change usually impacts existing application programs that have been written against the schema. In this paper, we are exploring the possible solutions to overcome this problem of impacts on the application programs. We believe that for continued support of the existing programs on the old schema, the old schema should continue to allow updates and queries, as before. Furthermore, its associated data has to be kept up-to-date. We call this the program independency property of schema change tools. For this property. we devise so-called program independency schema evolution (PISE) methodology. For each of the set of schema change operations in the relational schemas, the sketch of the additional algorithms due to the PISE compliance is presented in order to prove the comprehensiveness and soundness of our PISE methodology.

• Journal of the Korea Society of Computer and Information
• /
• v.6 no.1
• /
• pp.38-44
• /
• 2001

Nowadays, the study on XML as a standard method of exchange of information is active as Internet technology develops. This thesis designs and implements XML documents storage system using uniSQL/X in object-relational database. The system takes advantage of the merits of object-oriented databases, so that the structural information of XML documents can be effectively represented. The system uses split-storage method to allow frequent modifications of XML documents and suggests DTD-independent model so that it can store XML documents without DTD. And retrieval speed is improved by solving the issue of data duplication.

• Journal of Korean Society of Industrial and Systems Engineering
• /
• v.19 no.37
• /
• pp.241-249
• /
• 1996

In this paper, a 0-1 integer programming model for solving vertical partitioning problem minimizing the number of disk accesses is formulated and a branch-and-bound method is used to solve the binary vertical partitioning problem. In relational databases, the number of disk accesses depends on the amount of data transferred from disk to main memory for processing the transactions. Vertical partitioning of the relation can often result in a decrease in the number of disk accesses, since not all attributes in a tuple are required by each transactions. The algorithm is illustrated with numerical examples and is shown to be computationally efficient. Numerical experiments reveal that the proposed method is more effective in reducing access costs than the existing algorithms.

• Journal of Information Technology Services
• /
• v.7 no.3
• /
• pp.145-157
• /
• 2008

The existing XML storage methods which use relational data model, usually store path information for every node type including literal contents in order to keep the structural information of XML documents. Such path information is usually maintained by an inverted index to efficiently process XPath queries for large XML documents. In this study, We propose an improved approach that retrieve information from the large volume of XML documents stored in a relational database, while using a segment-based inverted index for path searches. Our new approach can reduce the number of searching an inverted index for getting target path information. We show the effectiveness of this approach through several experiments that compare XPath query performance with the existing methods.

• Proceedings of the Korean Society of Computer Information Conference
• /
• 2012.07a
• /
• pp.325-328
• /
• 2012

본 연구는 사용자가 특정 전문지식에 대하여 검색하는데 있어 관계형 데이터베이스와 온톨로지를 결합해 보다 적합한 검색 결과를 반환하도록 하는 관계형 데이터베이스와 온톨로지 병행모델에 관한 것이다. 데이터나 정보 양의 급격한 증가는 검색 결과의 사용자 확신을 도리어 떨어트리는 big data 문제에 부딪히게 되었으며 모바일 기기의 사용 증가는 검색과 결과의 판단에 있어 인간의 관여를 줄이는 단순성을 높이는 것이 강조되고 있다. 따라서 본 연구는 고수준의 의사결정이 요구되는 분야에 있어서의 검색 성능을 높이기 위해 관계형 데이터베이스로 구성된 데이터에 온톨로지를 결합시켜 사용자에게 적합한 데이터를 반환할 수 있는 모델에 대해 지원해보고자 한다. 본 연구의 검증을 위해 전문 지식이 요구되는 의약품 분야의 데이터베이스를 기준으로 서비스를 제공하는 사이트에서의 검색을 통해 문제점을 제시하고 연구의 필요성을 제시한다.

• Asia Marketing Journal
• /
• v.11 no.3
• /
• pp.31-56
• /
• 2009

As the competition intensifies and the market matures, marketers are more and more concerned with the relationship marketing. Many of the previous researches have pointed out that not all of the consumers are relationship-oriented. But none of the previous research has systematically investigated this issue. This research investigated the relationship among the three concepts: consumers' intrinsic characteristics, perceived importance of relational benefits, and relationship building intention with the salesperson. In this research the perceived importance of relational benefits is treated as mediating variable in the relationship between consumers' intrinsic characteristics and relationship building intention with the salesperson. The conceptual model in this study can be depicted as follows. From the consumers' perspective relational benefits can be defined as "the additional benefits consumers can receive in addition to core services through the long-term relationship with the service provider." And in this study two kinds of relational benefits are adopted by reviewing the previous research: confidence benefits and social benefits. Relational benefit received from the salesperson is very important to predict consumers' relationship building intention with the salesperson. The more relational benefits consumer wants from the salesperson, the more relationship building intention he/she has. From this point two hypotheses are derived as follows. Hypothesis 1: As the perceived importance of confidence benefit from the salesperson increases, the relationship building intention with the salesperson increases. Hypothesis 2: As the perceived importance of social benefit from the salesperson increases, the relationship building intention with the salesperson increases. In this study four individual characteristics(risk taking tendency, variety-seeking tendency, product knowledge, trust orientation) are hypothesized to influence the perceived importance of confidence benefits from the salesperson. And three individual characteristics(interpersonal orientation, price consciousness, trust orientation) are hypothesized to influence the perceived importance of social benefits from the salesperson. These 7 hypotheses are as follows. Hypothesis 3: As the risk taking tendency increases, the perceived importance of confidence benefits from the salesperson decreases. Hypothesis 4: As the variety-seeking tendency increases, the perceived importance of confidence benefits from the salesperson decreases. Hypothesis 5: As the product knowledge increases, the perceived importance of confidence benefits from the salesperson decreases. Hypothesis 6: As the trust orientation increases, the perceived importance of confidence benefits from the salesperson increases. Hypothesis 7: As the interpersonal orientation increases, the perceived importance of social benefits from the salesperson increases. Hypothesis 8: As the price consciousness increases, the perceived importance of social benefits from the salesperson decreases. Hypothesis 9: As the trust orientation increases, the perceived importance of social benefits from the salesperson increases. The whole model in this study can be depicted as follows: Data were collected from the 396 consumers who actually trade stocks through the salesperson and were analyzed using structural equation model. The analysis results show that consumers' perceived importance of relational benefits(confidence benefit and social benefit) play the roles of mediating variables in the causal relationship between consumers' inherent characteristics and their relationship building intention with the salesperson. As for the individual characteristics, the influences of variety-seeking tendency, trust orientation, and price consciousness are statistically significant. It was found that variety-seeking tendency has a significant negative effect on the perceived importance of confidence benefit, and that trust orientation has a significant positive effect on the perceived importance of both of confidence and social benefit. Finally it was also found that, on the contrary to the influence direction suggested in the hypothesis, price consciousness has a significant positive effect on the perceived importance of social benefit.