All Packages Class Hierarchy This Package Previous Next Index
Class SWEEP.DatabaseInterface
java.lang.Object
|
+----SWEEP.DatabaseInterface
- public class DatabaseInterface
- extends Object
- implements Serializable
-
con
-
-
cur_cursors
- The currend cursor-opened.
-
cursor_open
- The maximum number of statements I can created at the same time.
-
driver
-
-
logname
-
-
logpass
-
-
unique
-
-
url
-
-
DatabaseInterface()
-
-
closeCursor(Statement)
- closeCursor for this statement.
-
createTable(Relation)
-
-
createTable(Relation, String)
- Add Sign Field SWEEPSIGN.
-
createTable(Relation, String, Statement)
- Add Sign Field SWEEPSIGN.
-
dropTable(Relation)
-
-
dropTable(Relation, Statement)
-
-
executeQuery(String)
-
-
executeUpdate(String)
-
-
finalize()
-
-
getRelation(String, int)
-
-
join(Relation, Relation)
- Join operation on the remote IS.
-
joinLocal(Relation, Relation)
- Join on the Local Datawarehouse.
-
joinLocalOn(Relation, Relation, String, String)
- Join on the Local Datawarehouse on the specified Join attributes.
-
joinOn(Relation, Relation, String, String)
- Join operation on the remote IS.
-
nextUnique()
-
-
openCursor()
- openCursor for this connection.
-
UpdateView(ViewDefinition, Relation)
- This Function will update the View stored on the Oracle by using the Update.
con
static Connection con
url
static String url
driver
static String driver
logname
static String logname
logpass
static String logpass
cursor_open
static int cursor_open
- The maximum number of statements I can created at the same time.
cur_cursors
static int cur_cursors
- The currend cursor-opened.
unique
static int unique
DatabaseInterface
public DatabaseInterface()
openCursor
synchronized Statement openCursor()
- openCursor for this connection.
closeCursor
synchronized void closeCursor(Statement stmt)
- closeCursor for this statement.
finalize
public void finalize()
- Overrides:
- finalize in class Object
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.
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.
createTable
public void createTable(Relation theRelation)
join
public Relation join(Relation theView,
Relation theRelation)
- Join operation on the remote IS.
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.
joinLocal
public Relation joinLocal(Relation theView,
Relation theRelation)
- Join on the Local Datawarehouse.
joinLocalOn
public Relation joinLocalOn(Relation theView,
Relation theRelation,
String Attr1,
String Attr2)
- Join on the Local Datawarehouse on the specified Join attributes.
dropTable
public void dropTable(Relation theRelation)
dropTable
public void dropTable(Relation theRelation,
Statement stmt)
getRelation
public Relation getRelation(String RelationName,
int Index)
executeUpdate
public void executeUpdate(String Query) throws Exception
executeQuery
public Relation executeQuery(String Query) throws Exception
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.
if the number of Tuple is positive, we insert this tuple in the Oracle.
if the number of Tuple is negative, we delete it from the 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