Part 1: A simple multi-tiered Oracle package structure

The software architecture below is a basic three tier structure comprising a Table Encapsulation Layer, Object Layer and an Oracle Type (an object).

Note at this point that each of the database objects has a distinct and meaningful function.

Table: stores data
Table Encapsulation Package:
accesses the table using DML (SELECT, INSERT, UPDATE, DELETE)
Object Package:
accesses the Table Encapsulation Package and populates the Object
Oracle Object:
carrier for data to pass up to Java

on to Part 2

Leave a Reply

Your email address will not be published. Required fields are marked *