All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class SWEEP.DatabaseInterface

java.lang.Object
   |
   +----SWEEP.DatabaseInterface

public class DatabaseInterface
extends Object
implements Serializable

Variable Index

 o con
 o cur_cursors
The currend cursor-opened.
 o cursor_open
The maximum number of statements I can created at the same time.
 o driver
 o logname
 o logpass
 o unique
 o url

Constructor Index

 o DatabaseInterface()

Method Index

 o closeCursor(Statement)
closeCursor for this statement.
 o createTable(Relation)
 o createTable(Relation, String)
Add Sign Field SWEEPSIGN.
 o createTable(Relation, String, Statement)
Add Sign Field SWEEPSIGN.
 o dropTable(Relation)
 o dropTable(Relation, Statement)
 o executeQuery(String)
 o executeUpdate(String)
 o finalize()
 o getRelation(String, int)
 o join(Relation, Relation)
Join operation on the remote IS.
 o joinLocal(Relation, Relation)
Join on the Local Datawarehouse.
 o joinLocalOn(Relation, Relation, String, String)
Join on the Local Datawarehouse on the specified Join attributes.
 o joinOn(Relation, Relation, String, String)
Join operation on the remote IS.
 o nextUnique()
 o openCursor()
openCursor for this connection.
 o UpdateView(ViewDefinition, Relation)
This Function will update the View stored on the Oracle by using the Update.

Variables

 o con
 static Connection con
 o url
 static String url
 o driver
 static String driver
 o logname
 static String logname
 o logpass
 static String logpass
 o cursor_open
 static int cursor_open
The maximum number of statements I can created at the same time.

 o cur_cursors
 static int cur_cursors
The currend cursor-opened.

 o unique
 static int unique

Constructors

 o DatabaseInterface
 public DatabaseInterface()

Methods

 o openCursor
 synchronized Statement openCursor()
openCursor for this connection.

 o closeCursor
 synchronized void closeCursor(Statement stmt)
closeCursor for this statement.

 o finalize
 public void finalize()
Overrides:
finalize in class Object
 o createTable
 public void createTable(Relation theRelation,
                         String sign,
                         Statement stmt)
Add Sign Field SWEEPSIGN. Now I need this method can support more than one threads call it. So, I need to distinguish the statements each time some threads called.

 o createTable
 public void createTable(Relation theRelation,
                         String sign)
Add Sign Field SWEEPSIGN. Now I need this method can support more than one threads call it. So, I need to distinguish the statements each time some threads called.

 o createTable
 public void createTable(Relation theRelation)
 o join
 public Relation join(Relation theView,
                      Relation theRelation)
Join operation on the remote IS.

 o joinOn
 public Relation joinOn(Relation theView,
                        Relation theRelation,
                        String att1,
                        String att2)
Join operation on the remote IS. It will join on different named attribute. Att1 and att2. This joinOn function will add the relation name to the attribute names of the local relations in the Result.

 o joinLocal
 public Relation joinLocal(Relation theView,
                           Relation theRelation)
Join on the Local Datawarehouse.

 o joinLocalOn
 public Relation joinLocalOn(Relation theView,
                             Relation theRelation,
                             String Attr1,
                             String Attr2)
Join on the Local Datawarehouse on the specified Join attributes.

 o dropTable
 public void dropTable(Relation theRelation)
 o dropTable
 public void dropTable(Relation theRelation,
                       Statement stmt)
 o getRelation
 public Relation getRelation(String RelationName,
                             int Index)
 o executeUpdate
 public void executeUpdate(String Query) throws Exception
 o executeQuery
 public Relation executeQuery(String Query) throws Exception
 o UpdateView
 void UpdateView(ViewDefinition View,
                 Relation theUpdate)
This Function will update the View stored on the Oracle by using the Update. 1. It will project the Update to View Schema.

2. Convert projected Update to Oracle.

Problem: How to delete tuple from oracle for only couple of them, e.g.

Original: (5,6)[5], Delete: (5,6)[3], Result: (5,6)[2]. Solution: delete from where and rownum =1;

 o nextUnique

 synchronized int nextUnique()

All Packages  Class Hierarchy  This Package  Previous  Next  Index