This website uses cookies to ensure you have the best experience. Learn more

An Analysis Of The Strengths And Weaknesses Of The Big Six Database Servers

1705 words - 7 pages

Comparison Summary
DBMS Server Comparison Supplement
An Analysis Of The Strengths And Weaknesses Of The Big Six Database Servers.

In 1991 I performed a thorough evaluation and comparison of the four major DBMSs at the time: Informix, Ingres, Oracle, and Sybase. This comparison was done for a client building a huge distributed database application, currently in its second phase of d evelopment, with the first phase running successfully country-wide. At that stage, the distinguishing criteria were query optimizers, triggers, views, and support for distributed databases. Some products had these features, but some others' marketing per sonnel were just talking about them. For example, declarative integrity was a "future" that was at that stage only being phased into most of the DBMS products. It was relatively straightforward to draw up a checklist and fill it in with "yes" and "no" in the various columns.
Now, a mere five years later, these aspects - as well as many new features such as Internet support, remote procedure calls, and support for multiprocessor platforms - are standard items on each product's fact sheet and marketing material. On a very high level, DBMS products are becoming such commodity items in IT shops that it is almost possible to take a one-size-fits-all approach. On a detailed level, however, you must do a much more thorough evaluation. The products are evolving at such a fast pace, and their research and development teams are adding new features at such a rate, that simple yes/no entries in the comparison columns are just not enough. All of the comparisons would be similar, with mostly yes entries in each column and the odd no mar ked with an asterisk referring to a footnote saying, "Scheduled for the next release, currently in beta testing." If you want to do a thorough comparison today, you have to study each feature and check the extent to which it is implemented and the qualit y of the implementation. To explain further, I review a few of the features in this comparison supplement.
Relational Data Model
Although the DBMS products reviewed here can rightfully claim to be relational, their support of the relational data model must be scrutinized closely. Obviously they all support the basic relational concepts, such as data stored in tables and accessed b y high-level set operations, mostly through SQL. However, not one of the Big Six supports domains. It is crucial that these products address this fundamental concept of the relational data model. You must be able to define your domains and then specify y our table columns, and preferably also your stored procedure variables and parameters, in terms of the domains. This process is necessary to ensure tight type-checking, as you can do in some programming languages. If a "small" (in terms of market share) product such as Interbase could implement domains five years ago, surely the Big Six should be able to "get it right" today.
All of the Big Six can rightfully...

Find Another Essay On An Analysis Of The Strengths And Weaknesses Of The Big Six Database Servers

The Strengths and Weaknesses of the Sociocultural Perspective

983 words - 4 pages called guided participation (Sigelman, 2009). His theory was that children develop through interactions with parents, teachers, and other knowledgeable members of the culture and are given tools to adopt the group’s way of thinking. One of the strengths of this perspective is that it recognizes the relationship between cognitive development and the social, cultural, and historical context that an individual is a part of (Sigelman, 2009). This

The strengths and weaknesses of the traditional budgeting

1467 words - 6 pages . But it seems it is more and more unsuitable for the modern business. In this paper, I will give a brief induction for traditional budgeting; and then discuss the strengths and weaknesses of the traditional budgeting; last I will explain and evaluate the alternative.Every business leader wants competitive success, the best management team, continuous innovation, low costs, loyal customers, and high standards of corporate governance and control. The

The Strengths and Weaknesses of Augustine’s and Ireneau's Theodicy

2386 words - 10 pages The Strengths and Weaknesses of Augustine’s and Ireneau's Theodicy ‘Evil did not come from God, since God’s creation was faultless and perfect’ (St Augustine) St Augustine was a man wrote a theodicy about the problem of evil and suffering based on the Creation and Fall of Genesis in the bible, he believed that evil was caused by something that was outside the omnipotence of God. God himself is all powerful but after

The Strengths and weaknesses of Antigone In "Antigone" by Sophocles

560 words - 2 pages Usually, in novels, the main character's strength overshadows his weaknesses. In the Greek tragedy "Antigone", however, the main character of the same name has as many strong points as weak ones. In the next paragraphs, I will point out Antigone's strengths, weaknesses and, finally, the evolution of the character throughout the play.It goes without saying that Antigone is an extremely strong woman for her time and even for ours. She does have

Describe The Main Strengths And Weaknesses Of Utilitarianism

1040 words - 5 pages Utilitarianism was Originally formulated by Jeremy Bentham in the 18th century, and fully developed by John Stewart Mill in the 19th. It Asserts that we should always act so as to produce the greatest ratio of good to evil for everyone concerned with our decision and As with all moral theories, has many strengths and weaknesses.The prominant criticism of Utilitarianism is that it is extremely hard to predict the results of an action. The

Strengths and Weaknesses of Emotion

1262 words - 5 pages and the world, it hinders your perception and judgment as what you may think is right, may be wrong for someone else. This essay will further elaborate on the strengths and weaknesses of emotions in different areas of knowledge. The application of emotions is regarded highly useful when it comes to studying human behavior. The study of human behavior and emotions are connected, as we need to use emotions to understand and communicate non

Weaknesses of the Big Bang Theory

1936 words - 8 pages , for example if a dynamite was to explode in a building, the building would be destroyed and only rubbles would be left standing, however the big bang states the occurrence of a blast created order as the world to some extent is an orderly place, this is also one of the weaknesses upon which the big bang theory can be attacked. Although there is supporting evidence such as the moving of the galaxies at high speed in all directions but that alone

The Strengths and Weaknesses of the Cosmological Argument for the Existence of God

940 words - 4 pages The Strengths and Weaknesses of the Cosmological Argument for the Existence of God The cosmological argument seeks to prove the existence of God by looking at the universe. It is an A posteriori proof based on experience and the observation of the world not logic so the outcome is probable or possible not definite. The argument is in three forms; motion, causation and being. These are also the first three ways in the

The Strengths and Weaknesses of the System of Choosing Presidential Candidates

2656 words - 11 pages The Strengths and Weaknesses of the System of Choosing Presidential Candidates It seems reasonable to conjecture that the Achilles' heel of the modern presidency is one of recruitment. The long-winded delegate nomination process could in theory be replaced by a daylong direct election of presidential candidates. Instead, tradition dictates that the presidential race is drawn out quadrennially over the pre-primary

The Strengths and Weaknesses of Time Management and Their Relationship with Stress in the Workplace

1348 words - 6 pages Introduction I am writing an Assignment for my ILM Level 2 Course - Unit 1 – Managing Yourself. This Assignment will discuss the Strengths and Weaknesses of Time Management and their relationship with Stress in the Workplace, and how Stress affects the achievement of Personal and Team Goals. I intend to show how good time management can reduce stress and will base my findings on information I have gathered and a questionnaire I have written for

Explain the emergence of Left and Right Realist Criminologies and evaluate their strengths and weaknesses

2424 words - 10 pages their own strengths and weaknesses but both sought to develop a pragmatic assessment of crime and a practical response to the associated problems. The emergence of right realist theories was in direct opposition to sociological positivism. Right realists reacted against positivism, seeking to bring back the individual as responsible for his/her actions amidst a growing public concern for law & order in the 1970's and 80's. Positivist theory

Similar Essays

Database Software At Image Stream Overview Of Different Database Types Used At The Company And Their Strengths And Weaknesses

1019 words - 4 pages . Since the company does not run Microsoft Windows or Exchange Server on its servers, the standard central scheduling features of Outlook would normally be disabled. With software from a Norwegian company, ImageStream uses a back-end Microsoft Access database to store central appointments and display them using an Outlook plug-in. The plug-in acts as an abstraction layer, converting Outlook data to the company's Access database format as well as

Assess The Strengths And Weaknesses Of Marx’s Analysis Of Capitalism

1921 words - 8 pages “Capital is dead labor, that vampire-like, only lives by sucking living labor, and lives the more, the more labor it sucks.”This epitomises karl Marx’s representation and analysis of capitalism. Karl Marx has an abundance of theories and analysis for capitalism, for example exploitation and alienation with these possessing plenty strengths and weaknesses, it isn't a wonder why there have been numerous debates on the subject matter. The

Strengths And Weaknesses Of The Ontological Argument

983 words - 4 pages The Strengths and Weaknesses of the Cosmological Argument for the Existence of God The Strengths and Weaknesses of the Cosmological Argument for the Existence of God The Strengths and Weaknesses of the Cosmological Argument for the Existence of God The cosmological argument seeks to prove the existence of God by looking at the universe. It is an A posteriori proof based on experience and the observation of the world not

The Strengths And Weaknesses Of The Articles Of Confederation

894 words - 4 pages Strengths and Weaknesses of the Articles of Confederation The years 1781 to 1789, the years known as the "Critical period" were the reign of the Articles of Confederation... were those years a highlight in American history, or a time that is best to be forgotten? The argument can go either way it really depends on how you look at it. The question is; were the Articles an effective system of government? Well, while something might not be