Dismiss
InnovationQ will be updated on Sunday, Oct. 22, from 10am ET - noon. You may experience brief service interruptions during that time.
Browse Prior Art Database

Method for transparent access to various databases on electronic form systems

IP.com Disclosure Number: IPCOM000014007D
Original Publication Date: 1999-Dec-01
Included in the Prior Art Database: 2003-Jun-19
Document File: 2 page(s) / 29K

Publishing Venue

IBM

Related People

Keiko Takeuchi: AUTHOR [+4]

Abstract

Disclosed is a device for access various kinds of data repository transparently from electronic Form Processing system. With this device, any application program component does not need to aware from where and how data can be accessed but only invoke the data access component in some fixed methods. Three components implement this device; Data Object. Directory Manager. Data Access Definition. Relationship of these tree components is figured below; Any application program, servlet etc.

This text was extracted from a PDF file.
This is the abbreviated version, containing approximately 53% of the total text.

Page 1 of 2

Method for transparent access to various databases on electronic form systems

Disclosed is a device for access various kinds of data repository transparently
from electronic Form Processing system. With this device, any application
program component does not need to aware from where and how data can be
accessed but only invoke the data access component in some fixed methods.

Three components implement this device;
- Data Object.

- Directory Manager.
- Data Access Definition.
Relationship of these tree components is figured below;

+---------+

| | Any application program, servlet etc.
+---------+

| Data access request
V

+---------+

| Data |
| Object |
+---------+

     A +------> Repository1
| create DataObject |
+---------+ |
|Directory| ------------------------+------> Repository2
| Manager | |
+---------+ |

| A +------> Repository3
| | get Data Base information |

      V| :
____________ :
/DataAccess/
/Definition/
------------

DataAccessDefinition consists of 2 parts. One is RepositoryDefinition which
defines type of data repository (e.g. RDB, Relational Data Base, or LDAP,
Lightweight Directory Access Protocol), Data Base name, access id/password,
driver name and so on. The other is AccessRuleDefinition which defines table
name, column name, default value, key column name etc. and
RepositoryDefinition Id.

Here is an example of the Data Access Definition;
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

<DataAccessDef>

<AccessRules>

<AccessRule id="UserID" Manager="DEPARTMENT">

     <RepositoryID>RDBx</RepositoryID>
<Column-AttrName>UserID</Column-AttrName>
<RDB_TblName key="UserID">instuser.UserProfile</RDB_TblName>
</AccessRule>
<AccessRule id="MailAddress" Fixed="NO" Protected="NO">

     <RepositoryID>RDBy</RepositoryID>
<Column-AttrName type="CHAR">MailAddress</Column-...