|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Object | +--EVEDemo.SWEEP.DatabaseInterface
Field Summary | |
(package private) static java.sql.Connection |
con
|
(package private) static int |
cur_cursors
The currend cursor-opened. |
(package private) static int |
cursor_open
The maximum number of statements I can created at the same time. |
(package private) static java.lang.String |
driver
|
(package private) static java.lang.String |
logname
|
(package private) static java.lang.String |
logpass
|
(package private) static int |
unique
|
(package private) static java.lang.String |
url
|
Constructor Summary | |
DatabaseInterface()
|
Method Summary | |
(package private) void |
closeCursor(java.sql.Statement stmt)
closeCursor for this statement. |
void |
createTable(Relation theRelation)
|
void |
createTable(Relation theRelation,
java.lang.String sign)
Add Sign Field SWEEPSIGN. |
void |
createTable(Relation theRelation,
java.lang.String sign,
java.sql.Statement stmt)
Add Sign Field SWEEPSIGN. |
void |
dropTable(Relation theRelation)
|
void |
dropTable(Relation theRelation,
java.sql.Statement stmt)
|
Relation |
executeQuery(java.lang.String Query)
|
void |
executeUpdate(java.lang.String Query)
|
void |
finalize()
|
Relation |
getRelation(java.lang.String RelationName,
int Index)
|
Relation |
join(Relation theView,
Relation theRelation)
Join operation on the remote IS. |
Relation |
joinLocal(Relation theView,
Relation theRelation)
Join on the Local Datawarehouse. |
Relation |
joinLocalOn(Relation theView,
Relation theRelation,
java.lang.String Attr1,
java.lang.String Attr2)
Join on the Local Datawarehouse on the specified Join attributes. |
Relation |
joinOn(Relation theView,
Relation theRelation,
java.lang.String att1,
java.lang.String att2)
Join operation on the remote IS. |
(package private) int |
nextUnique()
|
(package private) java.sql.Statement |
openCursor()
openCursor for this connection. |
(package private) void |
UpdateView(ViewDefinition View,
Relation theUpdate)
This Function will update the View stored on the Oracle by using the Update. |
Methods inherited from class java.lang.Object |
|
Field Detail |
static java.sql.Connection con
static java.lang.String url
static java.lang.String driver
static java.lang.String logname
static java.lang.String logpass
static int cursor_open
static int cur_cursors
static int unique
Constructor Detail |
public DatabaseInterface()
Method Detail |
java.sql.Statement openCursor()
void closeCursor(java.sql.Statement stmt)
public void finalize()
public void createTable(Relation theRelation, java.lang.String sign, java.sql.Statement stmt)
public void createTable(Relation theRelation, java.lang.String sign)
public void createTable(Relation theRelation)
public Relation join(Relation theView, Relation theRelation)
public Relation joinOn(Relation theView, Relation theRelation, java.lang.String att1, java.lang.String att2)
public Relation joinLocal(Relation theView, Relation theRelation)
public Relation joinLocalOn(Relation theView, Relation theRelation, java.lang.String Attr1, java.lang.String Attr2)
public void dropTable(Relation theRelation)
public void dropTable(Relation theRelation, java.sql.Statement stmt)
public Relation getRelation(java.lang.String RelationName, int Index)
public void executeUpdate(java.lang.String Query) throws java.lang.Exception
public Relation executeQuery(java.lang.String Query) throws java.lang.Exception
void UpdateView(ViewDefinition View, Relation theUpdate)
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
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: INNER | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |