Win a copy of Practical SVG this week in the HTML/CSS/JavaScript forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

DBA and Software engineer conflicts

 
Zoe Peng
Ranch Hand
Posts: 112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,
plz share some experience about the communication skills cuz doing J2EE/EJB..it always has relationship with database people.
I have jsp/servlets and bean for my application. I write some sql statement in servlets and create some table for testing.
When I ask my sis(she is a good Oracle DBA) sql question,
she was totally disagree with my database design such as it's not a relataional database...
and I was strongly disagree with her about the data type for the column such as I think it needs to be num instede of var char. ( if it is a num, it is very easy for me to write codes in java.
if it is a char type, she thinks it is a good database)
does anybody have this kind of experience? usually, you vote for
software engineer or DBA? kind of curious..cuz sometimes, it happens @work. (I consider I am a good software eng., too , so, it was a lot of fun to know the difference.)
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What and how data should be persisted is a matter to be discussed in the elaboration phase of the project and usually should involve the analist, achitect and dba.
 
Zoe Peng
Ranch Hand
Posts: 112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Yep. that's true.
they need to communicate "well" first..
 
James Hobson
Ranch Hand
Posts: 140
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have had communications problems with DBAs, however, you have to understand that they are comming at it from another angle, you want a simple, easy to access place to put data; they want a scalable 3rd normal form relational database.
Generally, if you are trying to build any kind of serious enterprise application, you need to listen closely to your DBA, if they say something is up, either they know something you dont, or they are incompetent (not that likely!). You DBA is the data source expert, consider wisely before denormalising, or playing with their datatypes, chances are you will regret it.
The choice of datatype should be made dependent on the type of the data you want to persist, there are a number of reasonably accepted mappings, for example, see:
http://iron.gps.caltech.edu/doc/java.815/a64685/basic3.htm#1001613
 
Zoe Peng
Ranch Hand
Posts: 112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Is that ok to ask DBA or database programmer to write sql statement for you? and then software eng. just need to put the sql stmt into whatever jsp/servet/java ..
 
Matts Smith
Ranch Hand
Posts: 113
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Originally posted by Zoe Peng:
Is that ok to ask DBA or database programmer to write sql statement for you? and then software eng. just need to put the sql stmt into whatever jsp/servet/java ..

It is exactly how it works in my shop. I'm the java guy and the DBA is the DB guy. I decide what happens in my world and he gets the last word in his world. We communicate a lot tough.
 
Zoe Peng
Ranch Hand
Posts: 112
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I bet it's fight a lot..
tnx...I know what am I going to do now..
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!