| DBA Desires |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Ÿ | Adhere to rules
of database |
||||||||||||
| – | referential
integrity, stored procedures, sequence numbers etc. |
||||||||||||
| Ÿ | Build the J2EE
application but do NOT expect to change |
||||||||||||
| schema |
|||||||||||||
| Ÿ | Build the J2EE
application but the schema might change |
||||||||||||
| Ÿ | Let DBA
influence/change database calls/SQL generated to |
||||||||||||
| optimize |
|||||||||||||
| Ÿ | Be able to
profile all SQL calls to database |
||||||||||||
| Ÿ | Leverage
database features where appropriate (outer joins, sub |
||||||||||||
| queries,
specialized database functions) |
|||||||||||||