Monday, August 14, 2006

Comparison to Oracle and Postgres SQL
The system is implemented in two ORDBMS, Oracle and PostgreSQL. According to the needs we choose one of them. But both of them are capable of supporting many of the object relational features. There are some points which were noted while developing the systems. The system is implemented in two ORDBMS, Oracle and PostgreSQL. According to the needs we choose one of them. But both of them are capable of supporting many of the object relational features. There are some points which were noted while developing the systems. Oracle is costly and very heavy DBMS where as PostgreSQL is totally free and consumes lesser sources than Oracle. Installation of PostgreSQL is easier than Oracle and also the code and queries which are written in PostgreSQL are portable.
Postgres was little complex but as Oracle claims to easily take common database beyond ordinary numbers and text. ORDBMS is used only because its good for making data ware house and for data mart. The draw back of using OODMMS for this particular data mart might be able to cause the problems due to its nature of immaturity in using of UML, case tools support, and it is widely varied in its capability, DBMS used here is ORDBMS (Blaha, 1998).

0 comments: