sai rama krishna wrote:I am a java developer, now working on a project with lot of stored procedures, functions, database interactions. I keep getting almost weekly new data model physical, logical diagrams with 50-100 tables in each diagram with lot of interactions between the tables like many-one etc mappings, compound keys, surrogate keys. I am frequently getting referential integrity exceptions, foreign key constraint etc from my java application due to frequent changes on the database side. Please advise me how can i improve my data modelling reading, understanding skills so that i can be on top of the changes and make my java application not to break due to these changes.
Sounds to me like either:
The DBAs (and I was one for 15 years) aren't doing their job properly - ie, they aren't informing you - in a language you can understand - how the changes they have made might affect the structural integrity of their tables. That might cause referential integrity issues.Your programs aren't checking that "links" between tables actually exist. That would cause your "foreign key" issues (although it's also a database issue).
However, it sounds to me as though someone may have decided to "turn off" or (more likely) "turn on" referential integrity for the entire database; though how anybody would have the power to do that on even a moderate-size database that's in production without months of planning, I have no idea.
Are you under new management by any chance?
Winston