A Comparative Investigation And Evaluation Of Oracle9 I And Sql Server2000 With Respect To Performance And Scalability

3061 words - 13 pages

A Comparative Investigation and Evaluation of Oracle9i and SQL server2000 with
respect to Performance and Scalability
By Phathisile Sibanda
Supervisor: Mr John Ebden
Computer Science Department, Rhodes University
26 September 2005
Abstract: Performance and scalability are two
omnipotent factors determining database
availability and reliability. This is especially true
for modern computer systems due to the
inclusion of the Internet in Online transaction
processing
(OLTP)
and
E-commerce
applications which use databases. This evolution
gave birth to an enduring need for high
throughput, good response time, excellent data
consistency and concurrency control. This paper
...view middle of the document...

This would be accomplished
through the use of a combination of standard
benchmarks (TPC-C) embedded in third party
software like Quest Central 2005 for Oracle and
SQL server 2000 and performance tuning tools
like System Monitor and Analysis Manager
included with these products. Furthermore,
technical features influencing performance and
scalability in these systems will be examined to
support the benchmark results at the end of this
paper.

2. Motivation
There is a heating debate amongst Database
Administrators as to which DBMS performs
better under certain conditions. Two factors
prompting this debate include the increasing
number of open source databases flooding the

3. Methodology
3.1 Performance and Scalability
Testing Environment
The performance testing environment comprises
of three machines as depicted by Fig1.1 below.
The client machine was used as the controller of
the experiment for remotely managing,
monitoring and controlling both servers.
Processes carried out from this machine included
remote load and data simulation, benchmark
testing using TPC-C1 benchmark embedded in
Quest central software and data capturing for
presentation and analysis. All three PCs are
connected through a 100 Mb cable to the Rhodes
Computer Science LAN. To minimise the effect
of the network latency the author carried out
1

TPC-C stands for Transaction Processing Performance
Council Vision C (Transaction Performance Council,
2005)

1

Fig 1.1 Performance Testing Environment
Experiments during periods of low network
activity
NOTE also that remote monitoring and
performance testing was not used for all
scenarios in which case network sensitivity was
not an issue.
The following provides definitions of two
(functional and performance testing processes)
processes used by the author to perform
performance and scalability testing.

3.2 Functional/Baseline Test
a) Baseline Definition
A baseline is simply "a set of measurements that
tell you how a server behaves while at rest", is
basically a complete record of the system
performance taken immediately after the server
becomes operational, but before the server is put
under any measurable load. The baseline is
taken in a controlled environment, so that

external activities do not impact the baseline
measurements. All significant features of the
system performance are measured against
predefined metrics2 and later recorded and
analyzed.
Functional testing goals include: Telling you all
about the performance of a server under normal
conditions
for
later
comparison
with
performance test results and helping you build
filters to catch “do not respond” situations
before performance testing the servers. This
allows you to respond to problems that need to
be rectified before stressing your application
begins.

3.3 Performance Tests
Performance testing comprised four processes:
a) Load testing.
2

These predefined matrixes are simply...

Other Papers Like A Comparative Investigation And Evaluation Of Oracle9I And Sql Server2000 With Respect To Performance And Scalability

Program Planning And Evaluation Paper

787 words - 4 pages Extension Service set program priorities. * Intent - A plan of work helps communicate to the public what the organization intends to focus on over a specified period of time. * Commitment - The best way to ensure follow through on intentions is to put those intentions in writing. A plan of work makes a commitment to act in accordance with intentions. Program Planning and Evaluation Paper The Santa Rosa Philharmonic Youth Symphony’s

Comparative Study Of The Academic Performance Of Students Who Regularly Eat Breakfast And Those Who Skip Breakfast Among Selected Pupils Of Mauban South Central Elementary School Ii S.Y.2014-2015

9879 words - 40 pages COMPARATIVE STUDY OF THE ACADEMIC PERFORMANCE OF STUDENTS WHO REGULARLY EAT BREAKFAST AND THOSE WHO SKIP BREAKFAST AMONG SELECTED PUPILS OF MAUBAN SOUTH CENTRAL ELEMENTARY SCHOOL II S.Y.2014-2015 A Research Paper Presented to Engr. Elda C. Aranilla Sacred Heart College Lucena, City In Partial Fulfillment of the Requirements for the Subject Advanced Statistics in Education (EDUC 201-1) MAY B. ANARETA HAYDEE D. BELGICA DENISE

Investigation Of Action Of Saliva And 3m Hydrochloric Acid In 2 Carbohydrate Solutions

1828 words - 8 pages FIND_COMBINATION_OF_DATA PROMPT and GET for place_1 PROMPT and GET for place_2 PROMPT and GET for decision CASE OF place_1 Case 1:Kuala Lumpur, Malaysia Case 2:Seoul, Korea Case 3:Paris, France Case 4:Melbourne, Australia Case 5:New Delhi, India Case 6:Milan, Italy Case 7:Moscow, Russia CASE

The Impact Of Crm Capability On Innovation And Performance Advantages

1213 words - 5 pages My presentation that I’m going to show you is about “The impact of CRM capability on innovation and performance advantages”. PRESENTATION My discussion is divided in that part: - Abstract show the motivation of this choose. not only the author’s motivation but also my motivation. - with Teory I would like to give you some key concept like the definition of Innovation and who signify for a firm to bring a new product in the market - Consequently

Kyoto Protocol And Global Warming Evaluation

759 words - 4 pages Kyoto Protocol and Global Warming Evaluation Lisa Kyser University of Phoenix Environmental Economics ECO/370 Neal Johnson August 15, 2011 Abstract Global climate change and global warming are subjects that people either believe is happening or believe is a hoax. The fact that the Earth’s average temperature has risen, suggests that humans have influenced the environment enough to cause changes in the temperature. Global climate

Evaluate The Methods You Used To Collect The Data For A Geographical Investigation. State The Title Of The Investigation

443 words - 2 pages Title: the form of Budleigh Salterton beach is influenced by the processes acting upon it. Budleigh Salterton beach is stated on the south coast of Devon, England towards the western start of the World heritage Jurassic coast. It is a pebbled beach which the shapes of the pebbles being flat and oval as opposed to circular. The investigation was carried out in groups of 4 with individual participants doing different task, which was sorted

An Overview Of The Canadian Health Care System With A Comparison To The United States Heath Care System Canadian And American Health Care

1310 words - 6 pages Running head: An Overview of the Canadian Health Care System with a Comparison to the United States Heath Care System Canadian And American Health Care Parween Nooruddin Stratford University Abstract The reason for this exploration paper is to look at healthcare systems in two very progressed industrialized nations: The United States of America and Canada. The principal piece of the exploration paper will concentrate on the portrayal of

The Working Students And Their Academic Performance

982 words - 4 pages Conceptual Framework Study habits and academic performance of the working students have attracted increased attention among the university teachers and students with the aim of knowing and understanding the reasons, problems and other factors affecting them. This may empower them for lifelong learning to their journey to success hindered by their busy schedules and always no time to their study and academic performance. In Surigao State College

1. Do You Think There Is A Trade-Off Between The Positive (High Performance) And Negative (Increased Stress) Effects Of Stretch Goals?

324 words - 2 pages 1. Do you think there is a trade-off between the positive (high performance) and negative (increased stress) effects of stretch goals? Setting goals is part of organizational life and a powerful way to keep employees aligned and clear about expectations. But how tough should the goals be? How high should you set the bar? Some leaders like to set goals at a low to moderate level, based on the concept that they want everyone to be successful

Leadership Excellence And The “Soft” Skills: Authenticity, Influence And Performance

2778 words - 12 pages for each other’s performance, they need to learn the skills of being confrontational without turning confrontation into personal attacks. Developing such teams requires that leaders learn how to build a climate where important issues are proactively and productively addressed on a routine basis. Leaders must thus have competencies in: Building appropriate norms so that members communicate in a direct and honest way Being comfortable with task

4. Compare And Contrast Gram-Positive And Gram-Negative Cell Walls With Regard To (A) Sensitivity To Antimicrobial Agents, (B) Resistance To Phagocytosis, (C) Chemical Composition, And (D)...

920 words - 4 pages Research paper. NUTRITION FOR THE ELDERLY: Nutrition is the intake of food, considered in relation to the body’s dietary needs. Good nutrition is essential for survival, physical growth, performance, health and well-being across the entire life-span. A good nutrition adequate well balanced diet combined with

Related Essays

Democracy And Development In India: A Comparative Perspective

3182 words - 13 pages Democracy and Development in India: A Comparative Perspective By Pranab Bardhan University of California at Berkeley To most theorists of democracy in the West, India is an embarrassing anomaly and hence largely avoided. By most theoretical stipulations India should not have survived as a democracy: it’s too poor its citizens largely rural and uneducated its civic institutions rather weak. It is a paradox even for those who believe in a

Scenario Of An Employee Who Is Dissatisfied With Her Work Environment Work Ethic, And Needs To Find A Way To File A Formal Complaint With A Government Agency

663 words - 3 pages Abstract In this paper, I will be providing a response to a scenario of an employee who is dissatisfied with her work environment work ethic, and needs to find a way to file a formal complaint with a government agency. Work Ethic Compare and contrast the rights of employees and the responsibilities of employers in the United States and Europe. The United States and Europe have strong laws that protect employees. In the United States

Planning And Measuring Performance Essay

1219 words - 5 pages evaluation is to generate reliable information, which then becomes a valuable experience and is useful for adjusting planning, establishing priorities, and resource allocation. During this whole process specific results are analyzed and compared with goals and objectives and then are adjusted with predetermined standards. Improvement in organizational performance can occur when there is some way of measuring performance, which creates a link between

Customer Satisfaction With Respect To Mobile Phones

7857 words - 32 pages percent). ▪ Brand name and Brand Recommendation seem to be the major influence in the purchase decision of a mobile phone. ▪ Color Screen, Polyphonic Ring Tones and Integrated Camera seem to be the favourites among the customers. CONCLUSIONS & SUGGESTIONS conclusion After carrying out the project "Analysis of Customer Satisfaction with respect to Motorola Mobile Phones", I found that Nokia is still the market leader, but