Browse Prior Art Database

Schema Mapping System with Code Abstraction Mechanism for Heterogeneous Computing Environment

IP.com Disclosure Number: IPCOM000115279D
Original Publication Date: 1995-Apr-01
Included in the Prior Art Database: 2005-Mar-30
Document File: 2 page(s) / 33K

Publishing Venue

IBM

Related People

Kosaka, K: AUTHOR

Abstract

Disclosed is a schema mapping system with a code abstraction mechanism, which utilizes a code conversion function provided by a Relational Database Management System (RDBMS).

This text was extracted from an ASCII text file.
This is the abbreviated version, containing approximately 100% of the total text.

Schema Mapping System with Code Abstraction Mechanism for Heterogeneous
Computing Environment

      Disclosed is a schema mapping system with a code abstraction
mechanism, which utilizes a code conversion function provided by a
Relational Database Management System (RDBMS).

      A schema mapping system is a layer between an application and a
RDBMS, which, for example, translates operations to objects in the
application to operations to RDB tables.  When a program stores more
than one data items to a column of a RDB table, the code conversions
cannot always be done by the RDBMS because the column may contain
different type of data items, such as an integer and a string.  In
this case, the proposed system groups the same type of data items and
stores the group to a RDB column with a corresponding data type.

      For example, assume that there are two objects O1 and O2, each
of which contains two data items, an integer and a string.  The
system creates two groups.  One is the group (Gi) containing integers
from O1 and O2, and the other is the group (Gs) containing strings
from O1 and O2.  Then it stores Gi and Gs to RDB columns with the
integer and the string data types, respectively.  If the RDBMS does
not provide an integer array, the system may store Gi to a binary
data column and perform an integer data conversion by itself.  Even
in such case, however, the conversion is relatively easier than the
case of strings.