Thread: database design

  1. #1
    Eager young mind
    Join Date
    Jun 2006
    Posts
    342

    database design

    I hope i am posting this in the right place..
    I have to design a database with java as the front-end. What will be my best option when it comes to picking the backend? I am planning on using ORACLE. Is it a good choice? Can some one also guide me about the books that i can use.
    I think i will be working on WIN XP itself for this. SO, which is the latest version of ORACLE that is available for download?
    Last edited by kris.c; 08-26-2006 at 12:46 PM.
    In the middle of difficulty, lies opportunity

  2. #2
    Registered User
    Join Date
    Sep 2004
    Posts
    124
    We use Oracle at work (although the front end is PowerBuilder). It's a very good database, but make sure you have a good DBA to set it up properly for you.
    I think you can put a signature here.

  3. #3
    Eager young mind
    Join Date
    Jun 2006
    Posts
    342
    What are the things that we need to keep in mind while installing it? where can things go wrong?Which version should i install on my comp.. I have already come across 8i,11i, 10g and so on..
    In the middle of difficulty, lies opportunity

  4. #4
    Registered User
    Join Date
    Sep 2004
    Posts
    124
    10g is the release we're about to go to at work, although I think 11 is out.
    Don't go for anything lower than 10g as it will very soon go out of support by Oracle, then you'll be goosed, having to upgrade.

    There are a number of changes in 10g as well. For example, the RBO has been totally removed!!!! It's CBO only now.

    But I'm not big on the DBA side of things. Hopefully there is a DBA in here somewhere who can advise better than I.
    I think you can put a signature here.

  5. #5
    Eager young mind
    Join Date
    Jun 2006
    Posts
    342
    well, we have just had one class on ORACLE .. so, the terminology goes over my head at this stage atleast... thanks for the help anyway
    In the middle of difficulty, lies opportunity

  6. #6
    (?<!re)tired Mario F.'s Avatar
    Join Date
    May 2006
    Location
    Ireland
    Posts
    8,446
    I think Oracle is a bad option. You surely have more cost-effective solutions that don't involve paying a small fortune worth of licenses, DBAs and support contracts. Not at least, for what it seems to be a small project. Although there is always ORACLE 10g Express, which is free and a somewhat interesting entry-level database.

    You have to provide more info. Choosing a database system is highly dependant on the project requirements. Most importantly, perhaps, the amount of data residing on this database and if this will be a busy database. Perhaps these two variables are not so much important these days as they were before. Most DBs these days handle data with with very similar results in terms of performance. But definitely you also need to provide some info as to what system you have some know-how already, if any at all.

    For most cases I would recommend MySQL.
    Originally Posted by brewbuck:
    Reimplementing a large system in another language to get a 25% performance boost is nonsense. It would be cheaper to just get a computer which is 25% faster.

  7. #7
    Eager young mind
    Join Date
    Jun 2006
    Posts
    342
    We are doing a database project as a part of our curriculum.. We have chosen our topic to be product management. We are supposed to finish it in 4 months time.. So, it is a pretty small project when compared to what is actually done in the industry. Its just to give us a feel of the whole thing. I hope this covers all that u wanted to know.
    so, which wud be the best option with java as the front-end?

    oh! and one more thing.. We are supposed to have atleast 7 entities in our DB. That is again a pretty small number when compared to the real-world DB's right?
    In the middle of difficulty, lies opportunity

  8. #8
    C++ Witch laserlight's Avatar
    Join Date
    Oct 2003
    Location
    Singapore
    Posts
    28,413
    Have you considered HSQLDB?
    Quote Originally Posted by Bjarne Stroustrup (2000-10-14)
    I get maybe two dozen requests for help with some sort of programming or design problem every day. Most have more sense than to send me hundreds of lines of code. If they do, I ask them to find the smallest example that exhibits the problem and send me that. Mostly, they then find the error themselves. "Finding the smallest program that demonstrates the error" is a powerful debugging tool.
    Look up a C++ Reference and learn How To Ask Questions The Smart Way

  9. #9
    Eager young mind
    Join Date
    Jun 2006
    Posts
    342
    We were discussing MYSQL.. havent come across this before..
    As i had mentioned.. I havent had any exposure in DBMS.. I wud greatly appreciate it if u cud tell me which wud suit my type of application..
    In the middle of difficulty, lies opportunity

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. literature database: help with planning
    By officedog in forum C++ Programming
    Replies: 1
    Last Post: 01-23-2009, 12:34 PM
  2. Creating a database
    By Shamino in forum Game Programming
    Replies: 19
    Last Post: 06-10-2007, 01:09 PM
  3. Replies: 10
    Last Post: 05-18-2006, 11:23 PM
  4. database app design question
    By MPSoutine in forum Windows Programming
    Replies: 4
    Last Post: 12-02-2003, 10:13 PM
  5. Making a Simple Database System
    By Speedy5 in forum C++ Programming
    Replies: 1
    Last Post: 03-14-2003, 10:17 PM