Welcome to the iTechForums.
If this is your first visit, be sure to check out the
FAQ by clicking the link above.
You may have to
register before you can post: click the register link above to proceed.
To start viewing messages, select the forum that you want to visit from the selection below.
To register now click here.
|
Latest Threads
Advertisements
Forum Statistics
Threads:
Posts: 9
Members:
Number of Users Online:
Welcome to our newest member, |
|
 |

05-06-2008, 01:47 PM
|
|
Junior Member
|
|
Join Date: May 2008
Posts: 1
|
|
What is SQL, mySQL, Oracle 10g vs PostgreSQL 8 vs MySQL 5?
What is each of them and what is the difference between them ? I tried to google and confused. hope somebody can clarify this. Thanks
|

05-06-2008, 01:50 PM
|
|
Junior Member
|
|
Join Date: May 2008
Posts: 2
|
|
Each of them is a database management systems:
http://en.wikipedia.org/wiki/List_of_content_management_systems
Oracle is by far the biggest dbase...mySQL is a widely popular and free dbase., same with PostgreSQL.
|

05-06-2008, 01:50 PM
|
|
Junior Member
|
|
Join Date: May 2008
Posts: 1
|
|
http://en.wikipedia.org/wiki/SQL
In a nutshell, SQL is a language for accessing information in a database.
MySQL, Oracle, and PostgreSQL are frameworks for maintaining or managing databases. Oracle is the largest RDBMS (Relation Data Base Management System) in the world and arguably the most advanced. PostgreSQL and MySQL are open-source competitors. Between the two PostgreSQL is more advanced while MySQL is more popular and said to be easier to use.
|

05-06-2008, 01:50 PM
|
|
Junior Member
|
|
Join Date: May 2008
Posts: 1
|
|
All of them are DBMS/RDBMS - Data Base Management Systems/ Relational Database Management Systems which provides facility to Insert, Update, Modify, Delete, Search records using Structured Query Language(SQL/SEQUEL) and integration with various programming languages and platforms(Java, .Net etc).
SQL -Structured Query Language is supported by all RDBMS.
MySQL, MySQL5 are RDBMS product developed according to Standard rules(CODDS Rule+ rules of RDBMS)
Oracle 10g - provides various features for oniline Data Access(Server Client ).
|

05-06-2008, 01:56 PM
|
|
Junior Member
|
|
Join Date: May 2008
Posts: 1
|
|
They are all different types of Databases. MySQL and MySQL 5 is basically a database for web applications. PostgreSQL 8 is an open source database that is supposedly the most state of the art database. SQL is basically a powerful and flexible relational database software language composed of commands that enable users to create database and table structures, perform various types of data manipulation and data administration, and query the database to extract useful information.
|

06-19-2008, 07:33 PM
|
|
Senior Member
|
|
Join Date: May 2008
Posts: 185
|
|
|
|
 |
| Thread Tools |
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
All times are GMT. The time now is 03:26 PM.