ORACLE vs MS SQL SERVER Database
====================================================================
Base Directory
***************
ORACLE_BASE is an environment variable used as base directory for an OFA(Oracle Flexible Architecture) installation. On Unix systems, this is usually /app/oracle or /u01/app/oracle.
In windows OS,
The values will set in the registry ( command: regedit )
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1
In windows OS,
The values will set in the registry ( command: regedit )
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_OraDb11g_home1
--------------------------------------------------------------------
File Locations for Default and Named Instances of SQL Server
************************************************************
An installation of SQL Server consists of one or more separate
instances. An instance, whether default or named, has its own
set of program and data files, as well as a set of common files shared between all instances of SQL Server on the computer.
Shared Files for All Instances of SQL Server
Common files used by all instances on a single computer are installed in the folder
<drive>:\Program Files\Microsoft SQL Server\120\
where <drive> is the drive letter where components are installed. The default is usually drive C.
====================================================================
Oracle - History
IBM was the first company to develop a RDBMS, however, Oracle Corporation made history in 1980 by releasing its RDBMS, Oracle, for commercial use. Just a few years later the company would release a version of its system for IBM computers. Since its exhibition to the RDBMS market, Oracle has consistently led the way. According to Gartner, Oracle owned nearly 50% of the RDBMS market in 2011. In addition to opening up the commercial market for RDBMS, the Oracle Corporation also was the first company to develop a commercial-level version of SQL that was designed to manipulate data in a RDBMS using (at that time) queries and joins.
--------------------------------------------------------------------
SQL Server - History
Microsoft SQL Server entered the RDBMS market as a serious competitor in the mid 1990s when Microsoft purchased it from Sybase, and then released version 7.0. The companies originally worked together to develop the platform to run on the IBM OS/2 platform. However, Microsoft eventually developed its own operating system (Windows NT), and wanted to work solo to create a database management for it. It would take several years for the Microsoft and Sybase to completely sever their ties. Sybase eventually changed it’s product name so that it would be completely different from the product sold to Microsoft. Microsoft SQL Server version 4.2 was the initial release.
====================================================================
Oracle - History
IBM was the first company to develop a RDBMS, however, Oracle Corporation made history in 1980 by releasing its RDBMS, Oracle, for commercial use. Just a few years later the company would release a version of its system for IBM computers. Since its exhibition to the RDBMS market, Oracle has consistently led the way. According to Gartner, Oracle owned nearly 50% of the RDBMS market in 2011. In addition to opening up the commercial market for RDBMS, the Oracle Corporation also was the first company to develop a commercial-level version of SQL that was designed to manipulate data in a RDBMS using (at that time) queries and joins.
--------------------------------------------------------------------
SQL Server - History
Microsoft SQL Server entered the RDBMS market as a serious competitor in the mid 1990s when Microsoft purchased it from Sybase, and then released version 7.0. The companies originally worked together to develop the platform to run on the IBM OS/2 platform. However, Microsoft eventually developed its own operating system (Windows NT), and wanted to work solo to create a database management for it. It would take several years for the Microsoft and Sybase to completely sever their ties. Sybase eventually changed it’s product name so that it would be completely different from the product sold to Microsoft. Microsoft SQL Server version 4.2 was the initial release.
====================================================================
====================================================================
--------------------------------------------------------------------
--------------------------------------------------------------------
No comments:
Post a Comment