This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes Developer Certification (SCJD/OCMJD) and the fly likes Design of the DB part Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Certification » Developer Certification (SCJD/OCMJD)
Bookmark "Design of the DB part" Watch "Design of the DB part" New topic
Author

Design of the DB part

Geir Morten Hagen
Ranch Hand

Joined: Apr 05, 2002
Posts: 34
Hi,
I just started the SCJD assignment, and have some questions about the design of the database.
I was thinking of splitting up the data class into two parts; one for the "system" responsibilities, and one for the application spesific responsibilities.
The system part would include functionallity like adding records, deleting records, locking records and so on, while the other part would include the functionality the booking client needs like criteriaFind and bookSeats.
The latter interface will then be used in the rmi-part of the application.
There will be a base Data class which is subclassed by a BookingData class which implements the BookingDataInterface.
These are just some first thoughts about the design. Any comments will be appreciated
And one last question.. I was thinking of letting the Data class issue its own lock request when methods requiring record locking are called from the client. Or do anyone have a good reason why the client should call the lock request instead?
[ April 05, 2002: Message edited by: Geir Morten Hagen ]
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Design of the DB part
 
Similar Threads
Doubts reagarding database operations for Bodgitt and Scarper
Single table / Simple Locking - WeakHashMap vs WeakReferences
I think I got locking to work!
To Terry McKee, Rasika Chitnis and others
More on locking