Comparison Between Sql Server And Oracle Computer Science Essay

Microsoft SQL Server originated in Sybase SQL System, this was the entry to enterprise-level database market for Microsoft who was besides had competition with IBM and Oracle. The first version of Microsoft SQL Server which is V1.0 was released in 1989

Microsoft and Sybase subsequently split up and were besides viing against each other, Microsoft has developed several alterations on their ain such as SQL Server 7.0 which was a revision from the bequest Sybase codification, Microsoft SQL Server 2000 was the follow up on this application

We Will Write a Custom Essay Specifically
For You For Only $13.90/page!


order now

Was foremost used for a attention deficit disorder on for SQL waiter 2000, the first clip it was used as a bundled bundle was with SQL waiter 2005, this service is a tool for bring forthing “ data-driven ” presentments which are so sent to informations presentment endorsers. Subscribers register for a specific event and presentment services will advise them of new happening for that event, the service uses SMTP, SOAP or by composing to a file in the file system to present the presentment message

Full Text Search Service

This is a specialised indexing and questioning service used for unstructured text in a SQL database, the service can be used on any column with character based text

Has support for SQL and allows you to make and debug codification to be executed by SQL, it besides has a information interior decorator to let you to diagrammatically make, edit or position database scheme

SQL Server Management Studio

This is a tool included with SQL waiter 2005 and ulterior editions that has a in writing user interface that allows you to make databases manually or with a built in ace, it besides allows you to pull off you server with built in tools, you can either create and redact your database with SQL command line or with the built in characteristics which is the easiest and quickest manner 90 % of the clip

Comparison Between SQL Server and prophet

Language

Transact-SQL ) is a set of programming extensions from Sybase and Microsoft that add several characteristics to the Structured Query Language including dealing control, exclusion and mistake handling, row processing, and declared variables. Microsoft ‘s SQL Server and Sybase ‘s SQL waiter support T-SQL statements.

This is a list of the types of applications that can bring forth Transact-SQL:

General office productiveness applications

Applications that use a graphical user interface ( GUI ) to allow users choose the tabular arraies and columns from which they want to see informations.

Applications that use general linguistic communication sentences to find what data a user wants to see.

Line of concern applications that store their informations in SQL Server databases. These applications can include both applications written by sellers and applications written in-house.

Transact-SQL books that are run by utilizing public-service corporations such as SQLCMD.

Applications created by utilizing development systems such as Microsoft Visual C++ , Microsoft Visual Basic, or Microsoft Visual J++ that use database APIs such as ADO, OLE DB, and ODBC.

Web pages that extract informations from SQL Server databases.

Distributed database systems from which information from SQL Server is replicated to assorted databases, or distributed questions are executed.

Data warehouses in which information is extracted from on-line dealing processing ( OLTP ) systems and summarized for decision-support analysis.

Environment

Microsoft SQL Server can either be used for personal use or for a little to big company, Microsoft SQL Server can manage big sums of informations and therefore it is ideal for concern use in a big or little corporate environment or at place

MySQL

Introduction

MySQL is relational database direction system that acts as a waiter that provides multi-user entree to a figure of databases, MySQL is an unfastened beginning application which is owned by Sun microsystems a sub division of the prophet corporation

Members of the MySQL community have created several forks such as “ Drizzle ” and “ MariaDB ” because of the fright that prophet would act upon the development of MySQL because it competes with Oracle ‘s other database merchandises

Many web applications use MySQL as the database constituent, it is to the full compatible with PHP, many high traffic sites such as Facebook, You Tube Twitter and Nokia use MySQL to maintain path of user informations entries etc.

Graphical user interface

MySQL is chiefly an relational database direction system, it does n’t come with any GUI tools to pull off a MySQL database or the informations in the database, the included bid line can be used or MySQL Frontends can be downloaded from parties that have developed desktop applications and web applications to pull off the database and the records within the

The official MySQL work bench is a free integrated environment developed by MySQL AB that allows users to diagrammatically pull off and plan MySQL Databases

History

Original development of MySQL was done by Michael Widenius and David Axmark get downing in 1994 MySQL is named after Monty Widenius ‘s girl My.

The first internal release was on 23 May 1995

The Windows version was released on 8 January 1998 for Windows 95 and NT

Version 3.23: beta from June 2000, the production release was January 2001

Version 4.0: beta from August 2002, the production release was March 2003

Version 4.01: beta from August 2003, Jyoti adopts MySQL for database trailing

Version 4.1: beta from June 2004, production release October 2004

Version 5.0: beta from March 2005, the production release was October 2005

Sun Microsystems acquired MySQL AB on 26 February 2008.

Version 5.1: production release was 27 November 2008

MySQL 5.1 and 6.0 showed hapless public presentation when used for informations repositing, likely due to its inability to use multiple CPU nucleuss for treating a individual question

Uses

MySQL is really popular for utilizing with web applications and it besides acts as the database constituent of lamp

Language

MySQL works on ANSI C as its native linguistic communication and besides uses SQL3

The American national criterions institute is a private non-profit institute that produces industrial criterions in the USA

ANSI was founded on October 19, 1918 as the American Engineering Standards Committee and reorganised as the American Standards Association in 1928. In 1966 was reorganised as the United States of America Standards Institute. In 1969 it changed its name to American National Standards Institute.

Environment

MySQL Can be used in any environment large or little, because of major betterments over the old ages MySQL is suited for big concern to utilize on their web sites for database direction or it could b used at place for the same intent

Prophet

Oracle database is a relational database system of the Oracle Corporation, usually used in merchandise and cyberspace bases applications on different platforms

The prophet database system was developed by Larry Ellison along with friends and some former colleagues Bob Miner and Ed Oates who started a consultancy company called Software Development Laboratories ( SDL ) , The finished merchandise they created was called prophet which is named after the CIA-Funded undertaking Code name they worken on at a old employer, Ampex

Data storage construction

Oracles shops informations logically in the signifier of tablespaces, physically it is stored in the signifier of informations files

Tablespaces are created based on the type of informations sections they contain like informations sections index sections and bootstrap sections

History

Software Development Laboratories was founded in 1977. SDL changed its company name to Relational Software, Inc. In 1979

In 1983 RSI was renamed to Oracle Corporation In 1983. Oracle version 3 was released which had been re-written in C Programming Language.Platform support was extended to UNIX

In 1984 Oracle version 4 was released which supported read consistence.

In 1985 Oracle began back uping the Client Server theoretical account, with webs going available in the mid 80s. Oracle version 5.0 supported distributed querying.

In 1988 Oracle version 6 was released with support for PL/SQL, row degree locking and hot backups.

In 1992 Oracle version 7 was released with support for unity restraints, stored processs and triggers.

In 1997 Oracle version 8 was released with support for object oriented development and multimedia applications.

In 1999 Oracle 8i was released which is more supportive with the demands of the

In 2001 Oracle 9i was released with 400 new characteristics including the facilty to read and compose XML paperss.

In 2003 Oracle 10g was releasedVersion enumeration conventions

Database-related applications

Some of the major database related suites of Prophet

Oracle Designer/Developer

Prophet Forms

Prophet Reports

Prophet Applications

Oracle HR

List of Firsts

Prophet is the first database merchandise tested to follow with the ANSI SQL criterion.

Prophet is the first database to integrate a native Java linguistic communication

Prophet is the first commercial relational database direction system to go available on Linux as from August 1999

Language

Prophet uses PL/SQL ( Procedural Language/Structured Query Language ) This is prophet ‘s, execution of SQL, PL/SQL has a large resemblance with ADA, PL/SQL is one of three linguistic communications embedded in the Oracle Database, along with SQL itself and besides Java.PL/SQL was available with prophet since version 7

Environment

Because Oracle Database can manage big sums of informations it is suited to utilize within a big company that requires a big database