Two examples from my own experience:
A few years ago when I was starting out, I got involved on a database
project where all the constraints were coded rather than declared at
database level (it wasn't Oracle, but the principle remains the same). It
was a relatively small project and the guy
Thanks for all your comments (especially the ones that made me laugh).
Now at least I have some input from experienced people to put before my
boss.
Craig
-Original Message-
From: Craig Healey
Sent: 23 October 2002 18:45
To: Multiple recipients of list ORACLE-L
Subject: Theory v
As this topic just hits my hot button, I'm going to chime in my 2 cents
worth in as well. This in spite of the fact that you have already gotten
some great responses.
I come from an environment where we have distributed data all over creation.
IMS, DB2, Oracle, you name it we have it popping up
To me this comes under the heading of common sense.
My $0.02 worth,
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 24, 2002 9:33 AM
As this topic just hits my hot button, I'm going to chime in my 2 cents
worth
Craig,
No, this is not normal. They have purchased a Caddy so they can push their
grandma to the beauty parlor to get her blue-hair done - they will never
start the car.
Why in the hell did they purchase Oracle in the first place? Talk about a
waste of money!
If you cannot stop them now, then
Craig, i dont know jack about VB but M$ Access wont let you do
updates(according to my sources) unless there is PK or Unique index on
the tables.
joe
Craig Healey wrote:
The developers working on our new VB app are also responsible for
setting up the Oracle DB behind it. The app is for an
Craig,
Unfortuneatly this happens alot. Many developers have an over inflated view of their abilities and think they can write their code good enough to handle this. Every time I have seen this in place I have seen data integrity problems. Some major application vendors do this to provide the
it's not common and you should insist on primary and foreign key
constraints.
all you need is ONE user to hack into the database outside the app and
insert/delete/update rows that violate the integrity constraints and
your app stops working.
--- Craig Healey [EMAIL PROTECTED] wrote:
The
When code is developed to be database generic, developers will steer away from
code for a specific database. However, foreign key and check constraints hardly fall
into this category. I don't use Sqlserver or DB2, but I would guess that they
implement FKs and constraints. Your developers
Craig - I've seen large/busy databases run with RI handled outside the db.
Most common with package apps like Peoplesoft. They do that because they
want to run on many DBMSs and each handles RI differently. To reduce
development cost, they code once to the least common denominator. Thus no
RI
Wow, Life is stranger than fiction!
First of all buy stock in your hardware vendors since every query will
result in a table scan of every table and if you get more than an
intermittant workload on the system, it may very well come down onto its
knee's. indeed they are making it a very expensive
This is VERY wrong.
I know they are perfect, but one bug in the code will cause data loss,
order entries without a correct customer code etc.
Lets say that a year from now one customer complain.
They print a report and see that two entries are missing.
You check for orders with incorrect
recipients of list ORACLE-L
Subject:Re: Theory v Practice
When code is developed to be database generic, developers will steer
away from code for a specific database. However, foreign key and check
constraints hardly fall into this category. I don't use Sqlserver or DB2,
but I would
: Wednesday, October 23, 2002 2:39 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Theory v Practice
it's not common and you should insist on primary and foreign key
constraints.
all you need is ONE user to hack into the database outside the app and
insert/delete/update rows
Can you send them to oracle training in Bethesda, MD or
Reston, VA? Benefits could be multiple, especially for you.
Make sure that they wear clothing in bright colors.
-Original Message-
From: Craig Healey [mailto:C.Healey;hhsuk.com]
Sent: Wednesday, October 23, 2002 1:45 PM
To:
3 yrs after ur developers code the VB app, the original team vanishes(they start
working on .net .. or maybe java)
The new team even after going through the docs and vb application libraries, forget
the right joins and insert invalid data/update rows in the master without taking care
of the
Subject: Re: Theory v Practice
it's not common and you should insist on primary and foreign key
constraints.
all you need is ONE user to hack into the database outside the app
and
insert/delete/update rows that violate the integrity constraints and
your app stops working
-- Make sure that they wear clothing in bright colors.
Not exactly a nice comment Gogala I have friends in that area who are
dealing with the sniper every day I am sure there are others as well.
-Original Message-
Sent: Wednesday, October 23, 2002 2:33 PM
To: Multiple
LMAO!
You are too cruel, Cruella DeGogala!
-Original Message-
Sent: Wednesday, October 23, 2002 3:33 PM
To: Multiple recipients of list ORACLE-L
Can you send them to oracle training in Bethesda, MD or
Reston, VA? Benefits could be multiple, especially for you.
Make sure that they
On Wed, 23 Oct 2002, Mandar A. Ghosalkar wrote:
3 yrs after ur developers code the VB app, the original team vanishes(they start
working on .net .. or maybe java)
The new team even after going through the docs and vb application libraries, forget
the right joins and insert invalid
These developers are wrong, and the problem is far worse than primary /
foreign keys. The fact that your developers would say this indicates they
have no knowledge of even the most basic Oracle fundamentals, so they will
be making other serious mistakes too. If you have even an ounce of personal
...especially if the clothing comes from Target...
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 1:33 PM
Can you send them to oracle training in Bethesda, MD or
Reston, VA? Benefits could be multiple, especially for
Craig,
Wow - You stirred up some emotions with this question. I'm going to play
devil's advocate and say that I have seen instances where RI is not in the
database layer. It's probably more common in warehousing because you have
to load data even if some constraints are violated and then deal
23 matches
Mail list logo