Back to School Offer

Get 20% of Your First Order amount back in Reward Credits!

Get 20% of Your First Orderback in Rewards

All papers examples
Get a Free E-Book! ($50 Value)
HIRE A WRITER!
Paper Types
Disciplines
Get a Free E-Book! ($50 Value)

Comparison of Database Systems, Essay Example

Pages: 2

Words: 501

Essay

With various industries, particularly web-based businesses growing at such remarkable rates because of exposure to global markets, managing all of the information that a business receives has become a critical concern. It has simply become impractical to handle databases manually, and so relational database management systems are used to do automate most of the tasks. This essay compares two such software, the SQL Server 2005 by Microsoft and the Oracle 11g, and determines which between the two is best suited to small businesses with less than 50 personnel and which is best for larger businesses.

With the release of SQL Server 2005, Microsoft was able to pick itself up and finally become competitive in the market of database systems (McCown, 2005). Among the main features of this database system are online reindexing, incremental recovery, and database mirroring, which enable the system to provide a highly comprehensive uptime (McCown, 2005). However, SQL Server 2005 still lags behind Oracle 11g in terms of management capabilities, as the system is still unable to manipulate excessively large volumes of data in ways that Oracle 11g and its predecessor, Oracle 10g can (Caton, 2005). According to McCown (2008), the crowning jewel of Oracle 11g is in its Real Application Testing. This feature provides a way “of reproducing production workloads to certify those changes without affecting the production environment” whenever code changes are made in the system (McCown, 2008). Also, Oracle 11g boasts of being one of the pioneers of “green” database management (Lynn, 2008). That is, it is equipped to handle terabytes of data at only a third of the necessary disk space (Lynn, 2008). In terms of cost, SQL Server 2005 is much more manageable than Oracle 11g. SQL Server 2005 costs only $24,999 (McCown, 2005) per processor while Oracle 11g costs $60,000.

Based on these features, it can be inferred that for smaller businesses that consist of only 50 people that handle a relatively lower volume of data, SQL Server 2005 is the better option. Firstly, small businesses can be expected to have lesser staring capital to use for development, making it imperative to go for the more affordable option. Also, a small business would not need all of the features that Oracle 11g offer, which is designed for the management of larger volumes of data. On the other hand, businesses with more than 50 people should consider Oracle 11g over SQL Server 2005, especially if the business is very large. Not only does Oracle 11g offer much greater management flexibility, its advanced data compression feature can generate savings in terms of hardware and physical space, as well as enable the company to boast of having “green” practices.

References

Caton, M. (2005). Change Is Good for SQL Server 2005. Retrieved November 9, 2010 from: http://www.eweek.com/c/a/Database/Change-Is-Good-for-SQL-Server-2005/1/

Lynn, S. (2008). Review: What to make of Oracle 11g. Retrieved November 9, 2010 from: http://www.crn.com/reviews/applications-os/207400344/review-what-to-make-of-oracle-11g.htm?itc=refresh

McCown, S. (2005). SQL Server 2005 piles it on. Retrieved November 9, 2010 from: http://www.infoworld.com/d/data-management/sql-server-2005-piles-it-021

McCown, S. (2008). Oracle Database 11g shoots the moon. Retrieved November 9, 2010 from: http://www.infoworld.com/d/data-management/oracle-database-11g-shoots-moon-041?page=0,0

Time is precious

Time is precious

don’t waste it!

Get instant essay
writing help!
Get instant essay writing help!
Plagiarism-free guarantee

Plagiarism-free
guarantee

Privacy guarantee

Privacy
guarantee

Secure checkout

Secure
checkout

Money back guarantee

Money back
guarantee

Related Essay Samples & Examples

Email and Voicemail Monitoring, Essay Example

When it comes to email and voicemail monitoring, it is important to consider the implications of these actions on behalf of both the employee as [...]

Pages: 1

Words: 340

Essay

Description of Place: A Forest, Essay Example

The logic behind the significance of specific locations to individuals inevitably varies. Some places may hold pertinence since they are the sites of important personal [...]

Pages: 1

Words: 315

Essay

Quality Management System, Essay Example

Customer needs and expectations are the products any customer attaches to a company and knows that he or she will get it when need arises. [...]

Pages: 1

Words: 337

Essay

What Does It Take To Be a Good Parent Assignment, Essay Example

The issue of what does it take to be a good parent is contentious, insofar as the thematic remains susceptible to subjective interpretations. One may [...]

Pages: 1

Words: 330

Essay

Human Rights Violations and the Legal System, Essay Example

The Universal Declaration of Human Rights (hereinafter: UDHR), advanced by the United Nations General Assembly in 1947, was a watershed moment, insofar as with this [...]

Pages: 4

Words: 1122

Essay

The Critical Consulting Firm, Essay Example

Week 5 Issues The CanGo operation provides interesting insights into, unfortunately, how to conduct employee relations poorly. This is obviously not the company’s intent; on [...]

Pages: 5

Words: 1287

Essay

Email and Voicemail Monitoring, Essay Example

When it comes to email and voicemail monitoring, it is important to consider the implications of these actions on behalf of both the employee as [...]

Pages: 1

Words: 340

Essay

Description of Place: A Forest, Essay Example

The logic behind the significance of specific locations to individuals inevitably varies. Some places may hold pertinence since they are the sites of important personal [...]

Pages: 1

Words: 315

Essay

Quality Management System, Essay Example

Customer needs and expectations are the products any customer attaches to a company and knows that he or she will get it when need arises. [...]

Pages: 1

Words: 337

Essay

What Does It Take To Be a Good Parent Assignment, Essay Example

The issue of what does it take to be a good parent is contentious, insofar as the thematic remains susceptible to subjective interpretations. One may [...]

Pages: 1

Words: 330

Essay

Human Rights Violations and the Legal System, Essay Example

The Universal Declaration of Human Rights (hereinafter: UDHR), advanced by the United Nations General Assembly in 1947, was a watershed moment, insofar as with this [...]

Pages: 4

Words: 1122

Essay

The Critical Consulting Firm, Essay Example

Week 5 Issues The CanGo operation provides interesting insights into, unfortunately, how to conduct employee relations poorly. This is obviously not the company’s intent; on [...]

Pages: 5

Words: 1287

Essay

Get a Free E-Book ($50 in value)

Get a Free E-Book

How To Write The Best Essay Ever!

How To Write The Best Essay Ever!