IDDB

(ITS Distributed DataBase)

What is this ?

IDDB is a Distributed Database Management System (DDBMS).
It integrates some DBMS via their JDBC driver.
And because it was created with Java language, it can run at multi platform.

I success to integrate some DBMS:

•  Access(with JDBC-ODBC Bridge), PostgreSQL(with JDBC-PostgreSQL), Interbase(with InterClient),
   MS SQL-Server(with FastForward), and MySQL(with Mark Matthews' MySQL JDBC Driver)
   with my sample application sis_info_mhsklh.

Download :
Package in Zip file with long file name format :
iddb-0_1_0.zip

Features :
- horisontal fragmentation
- use JDBC standar for driver's interface, so you can use it without change
  and compile again if you create it with JDBC standar.
- SQL minimum grammar
- concurrent control for transaction proccess, with timestamps algorithm
- data replication
- use semijoin algorithm for optimation query process.
- integrated any different type of DBMS via their own JDBC driver.
 

Here are the SQL statements that IDDB supports:

SELECT (with joins)
UPDATE
INSERT
DELETE
CREATE TABLE
DROP TABLE

specific for IDDB :
EXTENDED SITE CREATE
EXTENDED SITE DROP
EXTENDED TABLE CREATE
EXTENDED TABLE DROP
 

Requirements

for running :
- JDK 1.1.X or JRE 1.1.X
- some DBMS software with their JDBC drive
  (examples : PostgreSQL, MySQL, Access (via JDBC-ODBC bridge),
  Oracle, Informix, Sybase, Interbase, etc)

for compiling :
- JDK 1.1.X
- JavaCC 0.7
 

Support

Please wait for documentation of IDDB, I still work for it,
But if you have any questions, not clear about this intruction
or discussion about this IDDB system or distributed database
system, you can reach me via e-mail.

If you have any comments, questions or suggestions about
IDDB, please feel free to write me at:
 

  Junus Junarto D <junus@bigfoot.com>

I cannot guarantee that I will be able to respond to issues
individually, but I would like to know how IDDB is
working or not. Any bug reports or other issues will
eventually be fixed in later releases. For updates,
information on the yet-to-be-created IDDB mailing list,
and other stuff, keep any eye on the main distribution site:

      http://geocities.datacellar.net/ResearchTriangle/Lab/8606/index.html

IDDB Architecture :

Counter :

last update 21 June 1998, (c) Junus Junarto D.