Technical differences between SQL and Oracle

By
Simonk
0

Technical differences between SQL and Oracle

Oracle DB:

Oracle Corp is the leading supplier for s/w products, headquartered in Redwood shores, California, USA. Now they have 43000 Employees in 150 countries. Oracle is the first s/w company to develop and deploy 100 % Internet-enabled enterprise Software.

Oracle refers to the method used to create the graphical user interface rather than writing numerous lines of code to describe the appearance and location of interface elements. Oracle is fastest and easiest way to create application in MS windows with the ability to store and access data. Whether you are professional or new to windows in programming, Oracle provides you with the complete set of tools to simplify application development.

Microsoft-SQL:

Through SQL Server (originally called Sybase SQL), Microsoft entered the Enterprise database market competing against the SAP, ORACLE, IBM, JAVA and many other operation platforms. Microsoft SQL Server was basically designed for Windows, but now it is supported by other platforms like HP9000 Series, Linux-Intel, AIX-Based. Today SQL Server is most easily available database server in the enterprise resource market. The motive of SQL Server is the provision of self-tuning, self-organization and self-maintenance in affordable budget. It also provides better compression backups, improved scalability, and notion of filtered indexes and transparent encryption of data (TDE) with ADO.NET Entity Framework.

Technical differences:

                             Oracle DB               Microsoft-SQL Server
  • Oracle is built for different platforms (Vendors) and operation (IBM, HP, Linux, Sun-Java, IFS, Flash).
  • Microsoft SQL is also built for different operating system but not compatible with all of them like Java. Some supported platforms for windows are AIX-based, Compaq, Hp9000 series, Linux-Intel etc.
  • Oracle installation process is easy in windows but difficult in other operation systems.
  • Microsoft SQL installation is very easy and understandable for different operation system.
  • Oracle server administration is difficult in all platforms with GUI and command line prompt.
  • Microsoft SQL server administration is easier than Oracle.
  • Oracle is not pure database because it was built with different techniques collaboration.
  • Microsoft SQL is pure database.
  • JDBC & ODBC support is better in Oracle.
  • Microsoft SQL support ANSI methodology.
  • Oracle OLAP sever is very costly and not imbedded in oracle.
  • Microsoft SQL analysis services shows OLAP server is powerful in this technology.
  • Oracle is very costly to purchase.
  • Microsoft SQL is very cheap.
  • Oracle is true enterprise solution because it has very good client/server methodology and ensures data integrity.
  • SQL Server has no multi-version consistency model, which means that “writers block readers and readers block writers” to ensure data integrity.
  • Oracle is very supportive for Parallel and RAC server technique.
  • Microsoft SQL Server is positioned between Microsoft Access and Oracle in terms of functionality, performance and scalability in market.
  • Oracle is much more challenging in test case and database connectivity.
  • Generally testing performance is easy in SQL with easy accessible query plan and statistics.
  • To check Oracle’s reliability and performance, more than 10 million entries have to be entered in database.
  • To check the SQL server performance one million entries have to be entered.
  • If any problem occurs in the database, you can’t find any training or human resource material in limited time frame.
  • If problem arises in SQL Server, you can find material and training resources easily in market.
  • Oracle is given the full control to allocate the cache memory in table spaces. Oracle support partitioning the table in different format.
  • In SQL Server, the DBA has no “real” control over sorting and cache memory allocation.
  • Oracle PL/SQL is more power tool than   T-SQL.
  • T-SQL is less powerful tool than PL/SQL.
  • Oracle supports 1000 columns per table.
  • SQL server supports 1024 columns per table.
  • Oracle9i Enterprise Edition With OLAP and Data Mining price is $2,560,000
  • SQL Server Enterprise Edition price is $639,968.
  • Oracle requires minimum 512 Ram and 4.5GB space for installation in Linux operation (But different in windows).
  • SQL Server requires 128 MB Ram and 270 MB space for installation.
  • Oracle DB Server is supported by Windows 2000 server, Windows 2003 server, Windows XP, Windows vista, Windows 7, AIX-Based, Compaq Tru64 Unix, HP-UX, Linux, Sun Solaris 32 n 64 bit. Oracle DB Server is more supported in Internet base transaction process.
  • MS-SQL server is supported by window 2000 advanced, Windows 2000 Data-Center, Windows XP-Professional, Windows Vista, and Windows 7, Linux-Intel operation system.
  • 32 Number CPU in Oracle Standard edition cost $480,000.
  • 32 number CPU in SQL standard edition cost $160,000.
  • Oracle Server PL/SQL supports B-Tree Indexing, Bitmap, partitioned, Function-based and Domain indexing. It also supports Relational and temporary table format.
  • Microsoft SQL Server only supports B-Tree indexing.
  • Oracle PL/SQL supports before, after and instead triggers.
  • Microsoft SQL server support only after and instead triggers.
  • Oracle PL/SQL procedures support PL/SQL statements, Java methods, Third generation language and 3GL routines.
  • Microsoft SQL supports T-SQL statements.
  • Oracle PL/SQL supports Arrays method.
  • Microsoft SQL server does not support Arrays method.
  • ORACLES DB Server constant string sizes in SELECT statements are 4000 only.
  • In SQL-server constant string sizes in SELECT statement are 16777207.
  • Maximum query sizes in Oracle are 16777216.
  • Maximum query sizes in SQL Server are 16777216.

 

SHARE
SQL-related Stored Procedures (SP) and Dynamic SQL

SQL-related Stored Procedures (SP) and Dynamic SQL

Previous

Terminal Services in Operating Systems

Next
SQL-related Stored Procedures (SP) and Dynamic SQL
Simonk

Related Articles