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?
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.
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..
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.
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
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.
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?
Have you considered HSQLDB?
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..