Browse Prior Art Database

Hierarchical Method of Composing Structured Query Language Statements Utilizing Object Oriented Programming Techniques

IP.com Disclosure Number: IPCOM000117837D
Original Publication Date: 1996-Jun-01
Included in the Prior Art Database: 2005-Mar-31
Document File: 4 page(s) / 110K

Publishing Venue

IBM

Related People

Hagan Jr, JD: AUTHOR [+2]

Abstract

An Object Oriented Program (OOP) is disclosed which has a set of classes involved in accessing Structured Query Language (SQL) database tables organized to take advantage of Object Oriented principles.

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

Hierarchical Method of Composing Structured Query Language Statements
Utilizing Object Oriented Programming Techniques

      An Object Oriented Program (OOP) is disclosed which has a set
of classes involved in accessing Structured Query Language (SQL)
database tables organized to take advantage of Object Oriented
principles.

      The organization of the OOP classes reflects the hierarchical
data structure of the database tables.  The SQL statements utilized
to access the database are actually the result of sending messages to
the class that encapsulate the table of interest in the hierarchy.

      Following is an example structure of the SQL database tables
that the OOP accesses.  These tables are used to hold the basic
account information.

The account tables and their associated columns are as follows:
  FixedTermInvestmentAccount
    ACCOUNT#                 MINIMUMAMOUNT        TERM
    RATE                     INTERESTYTD          PENALTYRATE
    BALANCE
    ORIGINATION
    TAXPAYERID
    PRODUCTNAME
  VariableTermInvestmentAccount
    ACCOUNT#                 MINIMUMAMOUNT
    RATE                     INTERESTYTD
    BALANCE
    ORIGINATION
    TAXPAYERID
    PRODUCTNAME
  FixedUnsecuredLoanAccount
    ACCOUNT#                 SCHEDULEDPAYINTERVAL
    RATE                     SCHEDULEDPAYMENT
    BALANCE                  ORIGINALAMOUNT
    ORIGINATION              LASTPAYDATETIME
    TAXPAYERID               TERM
    PRODUCTNAME
  FixedSecuredLoanAccount
    ACCOUNT#            SCHEDULEDPAYINTERVAL      COLLATERALID
    RATE                SCHEDULEDPAYMENT          COLLATERALDESC
    BALANCE             ORIGINALAMOUNT
    ORIGINATION         LASTPAYDATETIME
    TAXPAYERID          TERM
    PRODUCTNAME

As can be seen from the structure of the tables, all account tables
contain the following columns:
    ACCOUNT#            ORIGINATION
    RATE                TAXPAYERID
    BALANCE             PRODUCTNAME

All account tables dealing with investments also contain the
following columns:
    MINIMUMAMOUNT
    INTERESTYTD

All account tables dealing with loans also contain the following
columns:
    SCHEDULEDPAYINTERVAL
    SCHEDULEDPAYMENT
    ORIGINALAMOUNT
    LASTPAYDATETIME
    TERM

The OOP class hierarchy for accessing the accounts contains classes
to encapsulate each table and super classes to support thestructure
as seen above.  The following is the account class hierarchy:
    Account
      InvestmentAccount
        FixedTermInvestmentAccount
        VariableTermInvestmentAccount
      LoanAccount
        Fixed...