Comparative between DB2, Informix and Oracle
Hi, My company uses Informix as corporative database. As experienced DBA of the company, I have that to make a study comparing Oracle, Informix and DB2 databases and suggesting new alternatives. I have 10 years of experience with Oracle, 2-3 year with DB2 UDB and few experience with Informix (there are anothers DBAs that manage Informix here). Anyone have any kind of comparative ? Or personal opinions that whom good experience with DBs. My objective is not to generate flame wars !!! An argument very used by the development team is the facility use of Informix 4GL, mainly with batch programs. Which are the alternatives to the 4GL for Oracle? Thanks, Marcelo Wotfe DBA Senior S'o Paulo - SP - Brazil
"FireHawkBr'" <firehawkbr@gmx.net> wrote in message news:Xns96357D8B7F30Bfirehawkcom@204.153.244.170... > Hi, > > My company uses Informix as corporative database. > As experienced DBA of the company, I have that to make a study comparing > Oracle, Informix and DB2 databases and suggesting new alternatives. > I have 10 years of experience with Oracle, 2-3 year with DB2 UDB > and few experience with Informix (there are anothers DBAs that manage > Informix here). Anyone have any kind of comparative ? > Or personal opinions that whom good experience with DBs. > > My objective is not to generate flame wars !!! Well, there's a world of difference between intention and effect. As Daniel Morgan said, you might have approached this in a different way. Perhaps you could start by identifying some criteria by which you wish to compare the products: these might be for example scalability, ease of administration, availability of support staff, cost of licensing and support renewal ..... : perhaps even give your own tentative ratings and invite members of each group to comment on what you've written. Even then you're probably going to generate more heat than light.
Neil Truby wrote: > "FireHawkBr'" <firehawkbr@gmx.net> wrote in message > news:Xns96357D8B7F30Bfirehawkcom@204.153.244.170... > >>Hi, >> >>My company uses Informix as corporative database. >>As experienced DBA of the company, I have that to make a study comparing >>Oracle, Informix and DB2 databases and suggesting new alternatives. >>I have 10 years of experience with Oracle, 2-3 year with DB2 UDB >>and few experience with Informix (there are anothers DBAs that manage >>Informix here). Anyone have any kind of comparative ? >>Or personal opinions that whom good experience with DBs. >> >>My objective is not to generate flame wars !!! > > > Well, there's a world of difference between intention and effect. > > As Daniel Morgan said, you might have approached this in a different way. > Perhaps you could start by identifying some criteria by which you wish to > compare the products: these might be for example scalability, ease of > administration, availability of support staff, cost of licensing and support > renewal ..... : perhaps even give your own tentative ratings and invite > members of each group to comment on what you've written. Even then you're > probably going to generate more heat than light. Exactly. How large an installation? What is the quantity and size of transactions? How many users? User interface? Written in what? Connecting through an App Server? Which one? etc. Anything less is just baiting the predators. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)
"FireHawkBr'''''''''''''''''''''''" apparently said,on my timestamp of 12/04/2005 1:20 AM: > My company uses Informix as corporative database. > As experienced DBA of the company, I have that to make a study comparing > Oracle, Informix and DB2 databases and suggesting new alternatives. > I have 10 years of experience with Oracle, 2-3 year with DB2 UDB > and few experience with Informix (there are anothers DBAs that manage > Informix here). Anyone have any kind of comparative ? > Or personal opinions that whom good experience with DBs. > > My objective is not to generate flame wars !!! > An argument very used by the development team is the facility use of > Informix 4GL, mainly with batch programs. Which are the alternatives to > the 4GL for Oracle? You have 10 years of experience with Oracle and you do NOT know what are the alternatives to the 4GL for Oracle??? Me theenks you gotta SIRIUS prob right there... -- Cheers Nuno Souto in sunny Sydney, Australia wizofoz2k@yahoo.com.au.nospam
I think that Oracle Forms/Reports is comparable to Informix 4GL (?). At any rate, Oracle has many options in terms of development tools, take a look at: http://www.oracle.com/technology/products/ids/index.html http://www.oracle.com/technology/products/jdev/index.html As for the database, I never worked with DB2 or Informix, only Rdb and MS SQL Server in the past, so I don't have any comments here.
Em ter 12 abr 2005 10:23:54, Noons <wizofoz2k@yahoo.com.au> disse que: > > You have 10 years of experience with Oracle and you do > NOT know what are the alternatives to the 4GL for Oracle??? Alternativs with GOOD productivity I don't Know. PL/SQL ????