Dbms Comparisons

Oracle is a very good DBMS, but other options are out there in the market today. While looking for different DBMS I found a web blog of Microsoft SQL Server vs. Oracle stating the same, but different and written by Josh Stansfield. One of the differences of the two DBMS is the languages used between the two. Oracle uses PL/SQL and Microsoft SQL Server uses T-SQL. PL/SQL is a more complex language used, but is more powerful compared to T-SQL but T-SQL is easier to use.

MS SQL Server organizes all objects, including tables, views, and procedures, by the database names. Users have a specific login which has it accesses to certain parts of the database. On the other hand Oracle database is grouped by schemas. Also, everything in the Oracle database is shared, but each user can be limited to certain schemas and tables.

Both DBMS work great and either one would be a good choice but it really depends on what it is used with. Oracle overall has a better transaction system and packages. MS SQL Server is only one language so you don't have to worry about all the languages oracle has. Both are good choices to go with like I said it really depends on what the uses are for.

I personally think both DBMS are great choices from the information I have read and gathered.

I found a list of Data Base Management Systems at the link below. http://cs.fit.edu/~pbernhar/dbms.html

The sites I used for the information about the two DBMS are provided in the links below. http://stackoverflow.com/questions/2322260/basic-differences-between-oracle-and-sql-server

http://www.seguetech.com/blog/2014/03/13/Microsoft-SQL-Server-versus-oracle