Advanced Database Systems for fedulike

RDBMS is a relational database management system. This is a database management system based on relational model. It is used in financial, manufacturing and logistics industry.

DBMS is a database management system. This is a computer software applications that interact with applications, users to capture and analyze data. Examples are: - Oracle, MYSQL, Postgre SQL and others.

MYSQL is an open source relational database management system. It is a client server model and widely used database. MYSQL is used mostly for web applications and Linux Apache open source web applications. Many applications uses MYSQL for example WordPress, Joomla, Drupal, MYBB and many others. It works on many platforms for instance Linux, UNIX, Windows, and OSX etc. MYSQL has a cross platform support, information and performance schema.

MYSQL is easy to use. One can work with it well so long as he or she understand the language. Support is readily available unlike other databases. Lastly, it is popular and cheap to implement. It cost from free to a small fee.

Oracle is an object relational database management system. It stores data logically in table spaces and physically in form of data files. Client can access oracle databases through network sessions using protocols.

Oracle is more portable than any other. It run on more than 100 hardware platforms and 20 networking protocols. It is the largest market vendor for RDBMS. It means Oracle has many users unlike the other databases. Oracle inform its users on any new changes and the happenings. Lastly, Oracle has the best performance and provide backup and recovery support. It gives fault tolerance functionality to its users.

Postgre SQL is a free and open source software. It works on many platforms for instance Linux, UNIX, Windows, and OSX etc. MYSQL has a cross platform support, information and performance schema. It has better support than other databases. The source code of Postgre SQL is available at no cost. It is a cross platform database and can be found on all UNIX. Lastly, it has lot of graphical user interface tools of high quality.

From the three databases, the best and most suitable to use is Oracle because it is has so many benefits than any other database. Among them are, multiple database support, portable, widely used and has declarative integrity. I encourage organization to buy and install Oracle as their database.

In conclusion, RDBMS help to model relational databases. The modern and most frequently used databases are SQL, Oracle and Postgre SQL but the most suitable one for any organization is Oracle.

References

Chorafas, D. N. (1983). DBMS for distributed computers & networks. New York: PBI.

Larson, B. L. (1990). SQL solutions for IBM DBMS. New York, NY: Van Nostrand Reinhold.