• 정보기술과데이타베이스저널
• /
• 제1권1호
• /
• pp.9-30
• /
• 1994

The objective of this paper is to give a brief review of relational design methodology, and show how a relational schema can be converted into an object-relational schema. We first introduce relational terminology and describe the relational design process along with its limitations. Next we show how the relational model can be extended to overcome these limitations : these extensions form the core of an object-relational data model ; we use the UniSQL/X data model as an example. We illustrate the process or converting a relational schema into an object-relational schema, and show the benefits of this conversion with respect to queries. The conversion process is then summarized as a set of guidelines. Finally, we make our conclusions.

• Journal of Information Technology Applications and Management
• /
• 제16권4호
• /
• pp.245-261
• /
• 2009

Since XML emerged as a standard for data exchange on the web, it has been widely used for applications like e-Commerce, CRM, and BI. However, it is common that most of business data is stored in relational database systems, and it is expected that business data management would still be centered around the relational database systems. As such, the technique of viewing relational data as XML and processing XML queries against it is required. To meet such a need, in the SQL/XML standard, the functions to publish relational data as XML are provided. In this paper, we propose the techniques of providing an XML view of relational data defined by an SQL/XML statement in DTD(Document Type Definition), and of processing XPath queries against the XML view by translating them into SQL/XML statements, and describe the validation of such techniques through implementation and tests.

• 대한원격탐사학회지
• /
• 제3권2호
• /
• pp.115-119
• /
• 1987

After the introduction of the topologically structured geographic information system(GIS) with relational DBMS, the attribute data can be handled without considering locational data. By utilzing of the characteristic of the relational DBMS, it can be used as an expert system building tool in GIS. The relational DBMS of the GIS furnishes the data needed to perform deductive functions of the expert system, and the rule based approach provides the decision rules. Therefore, rule based approach with the expert judgement can be easily combined with relational DBMS.

• Journal of information and communication convergence engineering
• /
• 제20권4호
• /
• pp.265-272
• /
• 2022

The most effective method to improve information system capabilities is to enable instant access to several relational database sources and transform data with a logical structure into multiple target relational databases. There are numerous data transformation tools available; however, they typically contain fixed procedures that cannot be changed by the user, making it impossible to fulfill the near-real-time data transformation requirements. Furthermore, some tools cannot build object references or alter attribute constraints. There are various situations in which tool changes in data type cause conflicts and difficulties with data quality while transforming between the two systems. The R-programming language was extensively used throughout this study, and several different relational database structures were utilized to complete the proposed study. Experiments showed that the developed study can improve the performance of information systems by interacting with and exchanging data with various relational databases. The study addresses data quality issues, particularly the completeness and integrity dimensions of the data transformation processes.

• 한국전자거래학회지
• /
• 제7권1호
• /
• pp.153-166
• /
• 2002

Nowadays an information exchange on Bn such as B2B electronic commerce is spreading. Therefore the systematic and stable management mechanism for storing the exchanged information is needed. For this goal there are many research activities for connection between XML application and relational database. But because XML data have hierarchical structures and relational database can store only flat-structured data, we need to store XML data in object-relational database that support hierarchical structure. Accordingly the modeling methodology for storing XML data in object-relational database is needed. In order to build good quality application systems, modeling is an important first step. In 1997, the OMG adopted the UML as its standard modeling language. Since industry has warmly embraced UML its popularity should become more important in the future. So a design methodology based on UML is need to develop efficiently XML applications. In this paper, we propose a unified design methodology for In applications based on object-relational database using In. To this goal, first we introduce a XML modeling methodology to design W3C XML schema using UML and second we propose data modeling methodology for object-relational database schema to store efficiently XML data in object-relational databases.

• 한국전자거래학회지
• /
• 제8권1호
• /
• pp.85-102
• /
• 2003

Nowadays an information exchange on XML such as B2B electronic commerce is spreading. Therefore the systematic and stable management mechanism for storing the exchanged information is needed. For this goal there are many research activities for connection between XML application and relational database. But because XML data have hierarchical structures and relational database can store only flat-structured data, we need to make the conversion rule which changes the hierarchical architecture to 2-dimensional information. Accordingly the modeling methodology for storing each structured information in relational database is needed. In this paper, we introduce a XML modeling methodology to design W3C XML schema using UML and we propose a unified design methodology for relational database schema to store XML data efficiently in relational databases. In the second place, in order to verify objectivity of a unified design methodology. By the way of Ronald Bourret, First we introduce the method of the transformation from XML schema to object model and second we translate object model into relational database schema. Therefore we show the mutual consistency between those consequence, and so can verify a unified design methodology.

• 정보과학회지
• /
• 제4권2호
• /
• pp.34-44
• /
• 1986

본 연구에서는 mini computer를 이용하는 relational data base 관리 운영 체제의 실현적인 구현을 위한 시스템 설계를 소개한다.이 시스템은 독자적으로 개발한 간단한 operating system을 이용하며, assembly 언어로 쓰여졌으므로 기 존 assembler를 사용하였다. 시스템 설계방법에 data base가 차지하는 공간 (memory space)의 효율을 주로 고려하였으며, mini computer로는 No.A 840 system을 이용하였다.

• 한국전자거래학회지
• /
• 제8권1호
• /
• pp.103-111
• /
• 2003

Nowadays XML is used for exchanging information in e-Commerce, especially B2B. Necessity of XML DBMS has being increased to efficiently process XML data. So a lots of database products for supporting XML are rapidly appeared in the market. In this paper, we made an XML DBMS system based on Generic Data Model. First we developed XML Adaptor based on Generic Data Model and added it on relational DBMS for developing XML DBMS. XML Adaptor is composed of Query Convertor and XML Repository System. The Query Convertor parse commands that are for XML data manipulation and then call the relevant component of XML Repository System for relational database operation. The XML Repository System handles relational database operations such as create, delete, store, and etc. In this way we can use a relational DBMS for manipulation XML data. Therefor we can build more economically XML DBMS.

• 한국지능시스템학회:학술대회논문집
• /
• 한국퍼지및지능시스템학회 1998년도 The Third Asian Fuzzy Systems Symposium
• /
• pp.128-133
• /
• 1998

This paper aims to present some ideas for implementation of Uncertain Relational Databases (URD) which are extensions of classical relational databases. Our system firstly is based on possibility distribution and probability theory to represent and manipulate fuzzy and probabilistic information, secondly adopts flexible mechanisms that allow the management of uncertain data through the resources provided by both available relational database management systems and front-end interfaces, and lastly chooses dynamic SQL to enhance versatility and adjustability of systems.

• 대한가정학회지
• /
• 제51권2호
• /
• pp.219-228
• /
• 2013

The major purpose of this study was to explore the relation of a child's need for approval, anxiety and anger-in on a child's relational aggression according to gender. The study's participants included 464 boys and girls selected from fifth-and sixth-graders at an elementary school in Busan. A child's need for approval, anxiety, anger-in and relational aggression were assessed with their own self-reports. For data analysis, Cronbach ${\alpha}$, T-test, Pearson correlation coefficients, and Multiple Regression were used. The collected data was analyzed by the SPSSWIN 18.0 program. The major findings were as follows: First, child's anger-in demonstrated a significant difference among sexes. Girls indicated higher points than boys. Second, Boys' need for approval indirectly affected child's relational aggression through anger-in. Boys' anger-in was directly affected by relational aggression. Boys' anxiety was directly affected by anger-in. And boys' anxiety indirectly affected child's relational aggression through anger-in. Third, Girls' anxiety was directly affected by relational aggression. Need for approval and anxiety were directly affected by anger-in. The findings from this study indicates that child's need for approval, anxiety and anger-in are important elements in relational aggression are affected differently depending on the child's gender. Also, this study has meaning in that it can be used as fundamental data to develop a teaching plan and counseling program for children that can decrease relational aggression.