• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

URLyBird Database file query

 
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
In the specifications, it says that I need to create the DB file from scratch and ignore the one I got from them(but submit it back to them with the solution)... what's the point of the file then? and how do I create the new one?? should it be in txt format or like the one I got (.db) ?

Any help appreciated.
 
Ranch Hand
Posts: 531
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by M Jay:
In the specifications, it says that I need to create the DB file from scratch and ignore the one I got from them(but submit it back to them with the solution)... what's the point of the file then? and how do I create the new one?? should it be in txt format or like the one I got (.db) ?

Any help appreciated.



Mine says I need to reimplement database code from scratch. Please check your instructions, I bet you have same ones. What I read this to mean is that I need to write a data-management system that can read and write in the datafile format which is provided to me.
 
M Jay
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oh so it means that I still use the provided file, but I reimplement(the existing database code which the company is using which I don't have) from scratch!?!?! that is quite confusing! so basically reimplement the DB interface that I'm provided with! cool!

how do I open and view the supplied .db file? I tried opening it with notepad but it looked quite confusing??

Thanks for the clarification
 
Anton Golovin
Ranch Hand
Posts: 531
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by M Jay:
Oh so it means that I still use the provided file, but I reimplement(the existing database code which the company is using which I don't have) from scratch!?!?! that is quite confusing! so basically reimplement the DB interface that I'm provided with! cool!

how do I open and view the supplied .db file? I tried opening it with notepad but it looked quite confusing??

Thanks for the clarification



I use Notepad to view the text entries. The binary entries show as squares, or not at all. There must be binary viewers out there.
 
M Jay
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Thanks for all of that Anton.

How far are you with your assignment? I got mine two days ago. How did u go about it? did you implement the DB first, then the GUI, then the Network connection? I'm pretty confused at the moment :-S
 
Anton Golovin
Ranch Hand
Posts: 531
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by M Jay:
Thanks for all of that Anton.

How far are you with your assignment? I got mine two days ago. How did u go about it? did you implement the DB first, then the GUI, then the Network connection? I'm pretty confused at the moment :-S



I was the same way you are two days into my assignment. Don't worry, you will do ok. My progression has been: data-management system, local gui, server. Once you write the data management system and test it for concurrency, you are done. The rest is purely elementary. I am done with my assignment save for some code in my RoomTableModel for the GUI and some event-handling code in the GUI. This forum offers a lot of opportunity to ask questions, and it helped me to get the assignment done.
 
M Jay
Ranch Hand
Posts: 66
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Cool so how long did it take you in terms of hours/days? what was the hardest part in your opinion?
 
Anton Golovin
Ranch Hand
Posts: 531
1
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator

Originally posted by M Jay:
Cool so how long did it take you in terms of hours/days? what was the hardest part in your opinion?



I don't have a lot of Java programming experience, so for me, writing the data-management system was the hardest part. I spent about two months on the project, or about 100 hours. Concurrency, actually, was not very hard to write thanks to Java's support for it. What was hard was looking at the scope of things to be done. Finally, I broke the project into parts and did them one by one. That way, I could complete a part, test it, and come away knowing I accomplished something. So I built the project from little bits into a whole.

I would note that overcomplication was the hardest part to deal with. It is possible, of course, to put out a grand application, one which is extensible, maintainable and professional. But the project does not require it. It requires a simple application with rudimentary GUI. What it is looking for, IMHO, is working code and documented problem-solving process.

Of the data class, I would pay special attention to multi-threading behavior of the data logic vs. business logic. Some methods in the data logic do not guarantee correct information when called from methods of the business logic (For instance, find method returns correct record numbers, but by the time these records are read, they are not guaranteed to match the search criteria. Or, the create method may malfunction in some situations, so it finds a record number to overwrite, overwrites it, and, as it turns out, overwrites a valid record.) All of these issues will make you think, and all of them are perfectly solvable in an elegant fashion. Also, this project benefits from simple design patterns, such as Adapter and MVC. I did not use any more design patterns because, in my view, it would overcomplicate the project.

[ September 23, 2004: Message edited by: Anton Golovin ]
[ September 23, 2004: Message edited by: Anton Golovin ]
 
Don't get me started about those stupid light bulbs.
reply
    Bookmark Topic Watch Topic
  • New Topic