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

load database or not?

 
Ben Zung
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
During implementing the database server, is it acceptable to load the whole database file in memory to do the search/update? (using a RandomAccessFile object).
After read some messages related, I got the hunch that this indeed is acceptable but I am still having doubts. As in practical that would hardly be a solution.
Could someone drop a hint? Thanks
Bing
 
Satish Avadhanam
Ranch Hand
Posts: 697
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Bing, that's right. You can cache the whole database if you want. And as you said as the db grows larger it is'nt a good solution to adopt. But for the scope of the project if you do like this also, you can still defend that.
If you do cache db, then while reading/searching you can do it fast. But while creating/deleting/updating you have to do it both in cache and physically in the file. That's what I observed here.
I think both are acceptable solutions for the scope of exam.
Good Luck.
 
Ben Zung
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Satish, thanks for the confirmation.
Could you please help with another "not sure" thing. The assignement mentioned something about "this interim step will give them(CSRs) a starting point for migrating the system to the web". Why it bother to mention this in a whole paragraph? Does it imply some particular requirments related to web technology should be meet? I am getting confused reading this part after read some messages in the ranch about background information could be a factor of an automatic failure.
I am pasting the related part here:
"Bodgitt and Scarper, LLC. is a broker of home improvement contractors. They take requests from home owners for a type of service, and offer the homeowner one or more contractors that can provide the required services. Curently, Bodgitt and Scarper provides this service over the phone using a team of customer service representatives (CSRs). The CSRs interact with an ageing custom-written application that has been drawing increasing criticism from the CSRs. In the future, Bodgitt and Scarper wants to move into Internet-based marketing, and hopes to be able to provide their services directly to customers over the web.
The company's IT director has decided to migrate the existing application to a Java technology based system. Initially, the system will support only the CSRs, although the hope is that this interim step will give them a starting point for migrating the system to the web. The IT director does not anticipate much reuse of the first Java technology system, but intends to use that system as a learning exercise before going on to a web based system. "
...
 
Satish Avadhanam
Ranch Hand
Posts: 697
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi Bing
Originally posted by Bing Yuen:
Satish, thanks for the confirmation.
Could you please help with another "not sure" thing. The assignement mentioned something about "this interim step will give them(CSRs) a starting point for migrating the system to the web". Why it bother to mention this in a whole paragraph? Does it imply some particular requirments related to web technology should be meet?

My understanding is that its given as an overview to let us know about their background and nothing other than that. We don't need to use any web related technologies like Servlets & JSP.

I am getting confused reading this part after read some messages in the ranch about background information could be a factor of an automatic failure.
I am pasting the related part here:
"Bodgitt and Scarper, LLC. is a broker of home improvement contractors. They take requests from home owners for a type of service, and offer the homeowner one or more contractors that can provide the required services. Curently, Bodgitt and Scarper provides this service over the phone using a team of customer service representatives (CSRs). The CSRs interact with an ageing custom-written application that has been drawing increasing criticism from the CSRs. In the future, Bodgitt and Scarper wants to move into Internet-based marketing, and hopes to be able to provide their services directly to customers over the web.
The company's IT director has decided to migrate the existing application to a Java technology based system. Initially, the system will support only the CSRs, although the hope is that this interim step will give them a starting point for migrating the system to the web. The IT director does not anticipate much reuse of the first Java technology system, but intends to use that system as a learning exercise before going on to a web based system. "
...
Bing see, this is only the general info of the company. We don't need to worry about the "moving into web based system" or "migrating the system to the web". I think this information should have been given in the "Background" section of the instructions right? So as its background information, we don't need to worry much about it. But all of the rest of instructions, each and every line and word are very very important to go through. The thing with Terry & 48hr automatic failure was I would say bad luck. Many did not implement it and still passed. Hope Terry will succeed convincing Sun that's its not a requirement.
By the way, you don't have any constraints like this in your instructions posted above. If your only concern is regarding the web based technologies, don't worry.
Good Luck.
 
Ben Zung
Ranch Hand
Posts: 109
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Thanks a BUNCH!
-Bing
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic