Software Engineering

Open Access Open Access  Restricted Access Subscription Access
Open Access Open Access Open Access  Restricted Access Restricted Access Subscription Access

Assorted Database Query Methodology in DB2 Universal Data Joiner


Affiliations
1 Department of Computer Science, Rathinam College of Arts and Science, Coimbatore, Tamil Nadu, India
     

   Subscribe/Renew Journal


DataJoiner (DJ) is an assorted database system that provides a single database image of multiple databases.  It provides transparent access to tables at remote databases through user defined aliases (nicknames) that can be accessed as if they were local tables.  DJ is also a fully functional relational database system.  A couple of salient features of the DataJoiner query optimizer are:

  1. A query submitted to DataJoiner is optimized using a cost model that takes into account the remote optimizer’s capabilities in addition to the remote query processing capabilities and
  2. If a remote database system lacks some functionality (eg: arrangement), DataJoiner compensates for it.  In this paper, we present the design of the DataJoiner query optimizer.

User
Subscription Login to verify subscription
Notifications
Font Size

Abstract Views: 184

PDF Views: 0




  • Assorted Database Query Methodology in DB2 Universal Data Joiner

Abstract Views: 184  |  PDF Views: 0

Authors

L. Kathirvelkumaran
Department of Computer Science, Rathinam College of Arts and Science, Coimbatore, Tamil Nadu, India
R. Muralidharan
Department of Computer Science, Rathinam College of Arts and Science, Coimbatore, Tamil Nadu, India

Abstract


DataJoiner (DJ) is an assorted database system that provides a single database image of multiple databases.  It provides transparent access to tables at remote databases through user defined aliases (nicknames) that can be accessed as if they were local tables.  DJ is also a fully functional relational database system.  A couple of salient features of the DataJoiner query optimizer are:

  1. A query submitted to DataJoiner is optimized using a cost model that takes into account the remote optimizer’s capabilities in addition to the remote query processing capabilities and
  2. If a remote database system lacks some functionality (eg: arrangement), DataJoiner compensates for it.  In this paper, we present the design of the DataJoiner query optimizer.