|
I unfortunately work with a legacy system that was written without FKs. The amount of crap data in this DB is enough to make angels cry. This is why I was curious.
It's the classic thinking that you only need to write a DB for the front end's needs without considering that other systems may one day interact with it with their own idiosyncrasies (forget about devs going in and mussing things up directly in the tables).
|
|
|
|
|
Ed Bouras wrote: So to sum it all up it sounds like we have the perception that exorbitant cost of product should equal better coding standards or at least an upgrade to better technology. What's new?
Touché! 
Ed Bouras wrote: I am curious about one aspect though... there was mention of poor referential integrity. Are you saying that there is actually misshapen data like, for instance, orphaned records or data points stored in the wrong fields or invalid values (i.e. an invalid enum value)?
None that I've noticed yet. So I assume (hope) SAP helps enforce it, but there are no such foreign keys in the DB to help enforce it.
Ed Bouras wrote: That would be more alarming.
Finally, someone with experience talking. You're correct. Seeing the lack of foreign keys was what started this whole jaw dropping thing actually. It just went from there.
Jeremy Falcon
|
|
|
|
|
We tell a joke about SAP.
We know many companies who have started migrating to SAP.
A few who have given up,
and NONE who have completed the migration yet!
We finish with...
Rumor has it, SAP is almost COMPLETELY on SAP now! 
|
|
|
|
|
Jeremy Falcon
|
|
|
|
|
You're not the customer. What I've learned the hard way is that business doesn't care that if it's coded well, that's not their problem. What they care about is whether the software helps them solve a problem and ultimately whether it saves or makes them money. It's our job to convince them that good code saves and makes them money!
Idaho Edokpayi
|
|
|
|
|
You are correct sir. It just took me for a surprise after being exposed to it is all. I totally agree with you however.
Jeremy Falcon
|
|
|
|
|
appropriately named SAP because it's for saps
|
|
|
|
|
Jeremy Falcon
|
|
|
|
|
|
Jeremy Falcon
|
|
|
|
|
Some believe that SAP was Germany's revenge for losing the was (WWII). See this [^]
|
|
|
|
|
|
It also amazes me that Citrix got installed in so many places - must be the CEO who bought it on the basis of "zero admin costs" and "reducing PC estate" claims....
Every infrastructure team I've ever spoke to about it HATE it and spend more time supporting it than they ever did with proper PC desktops....
|
|
|
|
|
Having worked with SBO for many years I can tell you that there are plenty more surprises in store for you...
Just wait til you dig deeper and have the pure joy of things like OITM.VatGourpSA (wtf?) or OCPR.E_mailL.
Many field names seem like they ran out of vowels (CIN13.LstPchPrce).
The thing that drive me nuts in the early days was the 4 character table names.
Because, clearly RDR12 is Order Address Extension Data......anyway let me know if you get stuck with anything 
|
|
|
|
|
Man, it's like you know my pains. I may take you up on that offer if you don't mind. Although, we're using a plug-in that adds vendor specific tables into the DB, I'm sure you're knowledge would be invaluable.
Jeremy Falcon
|
|
|
|
|
no worries - drop me a line here or email me anytime.
|
|
|
|
|
Does a jack plug fit all stereotypes?
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
if it's wireless there's no plugs, only sockets
Sin tack ear lol
Pressing the any key may be continuate
|
|
|
|
|
Ugh! We should bayonet you for that.
In this present crisis, government is not the solution to our problem; government is the problem. ~ Ronald Reagan
|
|
|
|
|
Socket to me, baby!
Bad command or file name. Bad, bad command! Sit! Stay! Staaaay...
|
|
|
|
|
Only if the adage of "size does not matter" is true.
Cheers,
Mick
------------------------------------------------
It doesn't matter how often or hard you fall on your arse, eventually you'll roll over and land on your feet.
|
|
|
|
|
|
For them, you'll have to tear them a new one. Which, given the price of Apple's products, is what their customers really enjoy being subjected to.
CALL APOGEE, SAY AARDWOLF
GCS d--- s-/++ a- C++++ U+++ P- L- E-- W++ N++ o+ K- w+++ O? M-- V? PS+ PE- Y+ PGP t++ 5? X R++ tv-- b+ DI+++ D++ G e++>+++ h--- ++>+++ y+++* Weapons extension: ma- k++ F+2 X
If you think 'goto' is evil, try writing an Assembly program without JMP. -- TNCaver
"Go ahead, make my day"
|
|
|
|
|
Tar very much!
veni bibi saltavi
|
|
|
|
|
OriginalGriff wrote: Does a jack plug fit all stereotypes?
There may be some here too young to know what you're talking about. 
Marc
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
