• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Is our DBA out of a job? Best practice questions...

 
Billy Vandory
Ranch Hand
Posts: 57
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

We used Ibatis for years and now we're working on our first JPA project.

A few questions for you JPA folks:

Currently our DBA creates the db model and sends it to us and we generate the JPA entities. However, the db model is always changing during the dev cycle and having to generate and fiddle with the entities everytime there is a new iteration of a db model is quite a pain:

Therefore:

a) What is best practice for creating the DB model and JPA Entities in sync?

1. To create the DB model, and generate the entities?
2. Create the entities and have it generate the db model?

Or, should we even rely on generation?

I find the generated entities are far from perfect, and I have to massage most of them for tuning. I'm finding it really hard to keep the entities and model in synch, i'm double backing and going nuts with this (lack of) process.

b) if we create the entities and it generate the model, does that put the DBA out of a job?


Thank you very much,

Billy





 
Jimmy Clark
Ranch Hand
Posts: 2187
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
A database administrator typically is doing administrative and maintenance tasks. So, having this individual also doing database design for new products and services is questionable. Depends on the skill level of the individual. Usually an organization's Data Architect handles database design and has the DBA on his/her team handle administrative and maintenance tasks.

db model is always changing during the dev cycle


This is a sign that not enough time is being spent on creating a sound relational design for the requirements. Or, the requirements process is not good and your group is having trouble managing the product/service requirements.

The best practice is based on detailed analysis of your organization including skills and roles. It looks like your organization needs to spend more time in design and more time gathering correct requirements.

Maybe you should try designing the relational tables and the object model. Once this is done, pass the relational design to the DBA and have him/her implement the design. Remove his/her authority to make any changes to design without your group's approval.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic