Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

multiple databases

 
friso dejonge
Ranch Hand
Posts: 162
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi,
Since eugene's discussion topic is moved to results i like to start a new one regarding multiple databases (for clearing up some issues)
Eugene mentions the following:

.....However, I thought it would be important to design my server so that it can connect to multiple databases (because the requirements imply that multiple database files might be used, and not just db.db)....

Does this mean you are having 5 databases open at the same time ? Where does it mention that you must be able to have multiple databases open ? I am reading through the requirements and i cannot find it. My requirements about the server state that i can have multiple concurrent connections.
eugene could you clear this please, since my design needs some serious rework if this is the case.
thanks,
friso
 
Michael Morris
Ranch Hand
Posts: 3451
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
There is no requirement to be able to connect to multiple databases but my solution also had that capability. I had a singleton class called DataFactory which managed all the open Data objects even though for my project there was never more than one table (database) open. From the same server you could then register different table factories in the RMI registry with appropriate names. I also suggested in my DesignChoices document that a better (albeit more complicated) design would be to have a system-wide registry for DataFactory so that only one Data object per database file could be guaranteed even in different VMs.
Hope this is helpful,
Michael Morris
 
Anonymous
Ranch Hand
Posts: 18944
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't have the reqs in front of me, but I recall an item that spoke to requiring your design to bear extensibility in mind.
A lot of ranchers have taken this to mean that there is a need for the server to have the ability to manage multiple data files. That's how I've proceeded with my implementation.
The system (at present/for the assignment) will only manage the single data file.
e
 
John Smith
Ranch Hand
Posts: 2937
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Here is a quote from the requirement that I believe implies that there might be multiple databases:

These command lines may only take configuration parameters selected from this list:
...
Data file name(s)

It looks like people have passed without the support for multiple databases, but I feel strongly that implementing such a support would provide great value for the project extendibility and therefore to your score.
Eugene.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic