is Oracle technically better than Ingres ?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • michael newport
    #1

    is Oracle technically better than Ingres ?

    Dear friends of database(s),

    After 13 years of Ingres, I am now using Oracle.

    But is Oracle technically better than Ingres.

    I would be much obliged if anyone could shed some light on the above
    question.

    It would also be helpful if you could 'please' keep your comments on a
    technical level.

    Regards
    Michael Newport
    Tags: None
    • Ed prochak
      #2
      Re: is Oracle technically better than Ingres ?

      michaelnewport@ yahoo.com (michael newport) wrote in message news:<63b202d.0 407260216.34497 df7@posting.goo gle.com>...
      Dear friends of database(s),
      >
      After 13 years of Ingres, I am now using Oracle.
      >
      But is Oracle technically better than Ingres.
      >
      I would be much obliged if anyone could shed some light on the above
      question.
      >
      It would also be helpful if you could 'please' keep your comments on a
      technical level.
      >
      Regards
      Michael Newport
      It's been a long time since I did anything with INGRES so I won't say
      it's better or worse, because I don't know what technology it uses
      now.

      I will say that Oracle's Multiversioning makes systems run a lot
      smoother than DBMS that uses various forms of locks to conrol access.
      It can be more resource hungry, but the ease of use and performance
      more than compensates, IMHO.

      take a look at the Oracle Concepts manual. You'll learn a lot about
      how the system operates and why.

      HTH,
      ed

        Comment

        • Roy Hann
          #3
          Re: is Oracle technically better than Ingres ?

          "michael newport" <michaelnewport @yahoo.comwrote in message
          news:63b202d.04 07260216.34497d f7@posting.goog le.com...
          Dear friends of database(s),
          >
          After 13 years of Ingres, I am now using Oracle.
          >
          But is Oracle technically better than Ingres.
          >
          I would be much obliged if anyone could shed some light on the above
          question.
          >
          It would also be helpful if you could 'please' keep your comments on a
          technical level.
          Anything that implements SQL sucks. Your question therefore is about the
          degree of suckiness exhibited by each product. That's a tough one.

          I like Ingres' ease of management. I like the fact that Ingres DDL is
          "transactional" . I like the ease with which I can create (and destroy) a
          new Ingres database. I like the ease with which I can restore and recover
          an Ingres database. I also like the look of a lot of what is coming in r3.

          On the other hand I like the way Oracle implements the READ COMMITTED
          isolation level.

          As I implied, I'd rather not have to use either of them. But Ingres is the
          least bad IMO.

          Roy Hann (rhann at rationalcommerc e dot com)
          Rational Commerce Ltd.
          Home
          https://www.rationalcommerce.com
          Ingres and OpenROAD® development, tuning, and training experts What you need, where you need it, at the right cost At Rational Commerce we understand how the success of your business depends on the success of your Ingres Database systems and OpenROAD applications. If you are using Ingres you are almost certainly using it in a mission-critical

          "Ingres development, tuning, and training experts"



            Comment

            • Mark D Powell
              #4
              Re: is Oracle technically better than Ingres ?

              michaelnewport@ yahoo.com (michael newport) wrote in message news:<63b202d.0 407260216.34497 df7@posting.goo gle.com>...
              Dear friends of database(s),
              >
              After 13 years of Ingres, I am now using Oracle.
              >
              But is Oracle technically better than Ingres.
              >
              I would be much obliged if anyone could shed some light on the above
              question.
              >
              It would also be helpful if you could 'please' keep your comments on a
              technical level.
              >
              Regards
              Michael Newport
              Michael, I have never worked directly with Ingres, but we had the
              database here once and the two developers who worked with it liked
              Oracle much better. Running the same applications against Oracle
              provided more up time and required less database related maintenance.

              Oracle has advanced greatly since then. There are two different
              independent consulting reports that state that Oracle 10g is easier to
              manage than SQL Server.

              I have wroked with Oracle, SQL Server, DB2 UDB, and mySQL. I like
              Oracle better than the others. I second, Ed's suggestion to look or
              better yet read the Concepts manual. It is the place to start with
              Oracle.

              HTH -- Mark D Powell --

                Comment

                • Mark D Powell
                  #5
                  Re: is Oracle technically better than Ingres ?

                  Mark.Powell@eds .com (Mark D Powell) wrote in message news:<2687bb95. 0407280537.3b00 e3e2@posting.go ogle.com>...
                  michaelnewport@ yahoo.com (michael newport) wrote in message news:<63b202d.0 407260216.34497 df7@posting.goo gle.com>...
                  Dear friends of database(s),

                  After 13 years of Ingres, I am now using Oracle.

                  But is Oracle technically better than Ingres.

                  I would be much obliged if anyone could shed some light on the above
                  question.

                  It would also be helpful if you could 'please' keep your comments on a
                  technical level.

                  Regards
                  Michael Newport
                  >
                  Michael, I have never worked directly with Ingres, but we had the
                  database here once and the two developers who worked with it liked
                  Oracle much better. Running the same applications against Oracle
                  provided more up time and required less database related maintenance.
                  >
                  Oracle has advanced greatly since then. There are two different
                  independent consulting reports that state that Oracle 10g is easier to
                  manage than SQL Server.
                  >
                  I have wroked with Oracle, SQL Server, DB2 UDB, and mySQL. I like
                  Oracle better than the others. I second, Ed's suggestion to look or
                  better yet read the Concepts manual. It is the place to start with
                  Oracle.
                  >
                  HTH -- Mark D Powell --
                  The July 19, 2004 issue of InformationWeek p 46 mentions that after a
                  decade of neglect by CA who had put their attention on Jasmine that CA
                  is showing renewed interest in marketing Ingres. The title of the
                  short article is CA goes open source with Ingres database. The
                  implication is that CA has a lot of work to do to catch up to other
                  relational database products.

                  But how good a database is for you depends a lot on the features you
                  need. Oracle contains a lot of features that many sites do not use,
                  but if you need analytical functions then Oracle has them. If you
                  have very large tables then Oracle has partitoned tables and indexes.
                  With a warehouse operation you might need/benefit from bitmap indexes.

                  If you really want to compare databases you have to make a list of
                  features you need/want and then list what each database offers.

                  HTH -- Mark D Powell --

                    Comment

                    • michael newport
                      #6
                      Re: is Oracle technically better than Ingres ?

                      ....so anyway I have not had time to implement the IOT suggestion
                      (people keep giving me other work !), but its nice to know that I can
                      do the same thing in Oracle that I used to do in Ingres. So thanks for
                      the help.

                      But pre-ordering your data is a handy feature that saves time (during
                      the day) and hassle.

                      But getting back to my original question, "is Oracle technically
                      better than Ingres". I still can not say that it is. I was waiting for
                      a smoking gun from some Oracle people as to why Oracle is better.

                      Furthermore I kept having an Oracle "snapshot too old" problem which
                      meant that after weeks of studiously putting my SQL query together, I
                      am now having to split it up again. Something to do with the query
                      taking too long.

                      regards
                      Mike

                        Comment

                        Previous template Next
                        Working...