Oracle Database is commonly used for running Online Transaction Processing(OLTP),Data Warehousing(DW) and mixed of above two database workloads.
History of the Oracle Database
This is found by Larry Ellison and his two friends and former co-workers,Bob Miner and Ed Oates.First they started a consultancy called Software Development Laboratory(SDL). SDL was developed the original version of the Oracle Software.The name of the company was come from the code name of a CIA-funded project Ellison had worked.At the same time formerly employed by Ampex.
Different between Oracle and MSSQL database
There are so many differences among Oracle database(Relational database management system) and the Microsoft Database.Both of Oracle and MSSQL are widely and most popular databases.How ever,there are some similarities also between those two.And also there are a number of key differences.
When we consider about the language,both systems are used the structured query language or SQL.And also MSSQL is used Transact SQL or T-SQL.It is an extension of the SQL.It has developed by sybase. The Oracle is used PL/SQL .It means Procedural Language SQL.Both languages has same facilities but different syntax and capabilities.The main different of both languages are, store variables,store procedure and the building functions.Oracle can group procedure together from PL/SQL.But MSSQL can't do that option.PL/SQL is complex and more powerful. T-SQL is simple and easier to handle.
When we consider about the Transaction control,it is a very considerable different among both of oracle and the MSSQL. Transaction means,a group of operations or tasks can be get with together as a single unit.SQL queries can modify the records that,updated at the same time,when those are failed to update any single record among the set of data. MSSQL is executed and committed each task individually. And also it is difficult to roll back changes if any errors are occurred.when we think about the Oracle,each new database connection is treated as new transaction.The changes are made only in the memory because queries are executed and commands are issued.There is no committed since an explicit commit statement is given. After commit the next command is issued and the initiated the new transaction.After that the process begins again.It is useful to error control and it is flexible.
When we consider about the Organization of Database Objects, MSSQL is organized all objects,tables,views and procedures by the database name.And also,in SQL server each database has private unshared disk file on the server.When we go to Oracle,all the database objects has grouped by schemas.those are subset collection of database object and and all the database objects are shared among all schemas and users.
Finally we can come to a decision,both Oracle and MSSQL servers are powerful RDBMS options.Both of them can be used in roughly equivalent ways.
When we consider about the Transaction control,it is a very considerable different among both of oracle and the MSSQL. Transaction means,a group of operations or tasks can be get with together as a single unit.SQL queries can modify the records that,updated at the same time,when those are failed to update any single record among the set of data. MSSQL is executed and committed each task individually. And also it is difficult to roll back changes if any errors are occurred.when we think about the Oracle,each new database connection is treated as new transaction.The changes are made only in the memory because queries are executed and commands are issued.There is no committed since an explicit commit statement is given. After commit the next command is issued and the initiated the new transaction.After that the process begins again.It is useful to error control and it is flexible.
When we consider about the Organization of Database Objects, MSSQL is organized all objects,tables,views and procedures by the database name.And also,in SQL server each database has private unshared disk file on the server.When we go to Oracle,all the database objects has grouped by schemas.those are subset collection of database object and and all the database objects are shared among all schemas and users.
Finally we can come to a decision,both Oracle and MSSQL servers are powerful RDBMS options.Both of them can be used in roughly equivalent ways.
Interfaces of the Oracle Database
No comments:
Post a Comment