Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 1 down vote favorite

I realise this may be come a subjective mess, but I'm hoping for some objective information on the subject. I also don't want to go shopping, I just want to know 'what to shop for'.

I'm very new to database management. As in I started SQL 4 weeks ago, and using MS Access last week. I'm coming to the end of out perrenial database project using MS Access wherein I've hit up against a lot of the limiations to Access, and I've mentioned that we need something different.

Next time round I'd like full access to the 'database capabilities' such as Union Corresponding, Intersect etc. I'd also like to be able to cursor through the rows if need be and be able to run checks row by row.

It's likely we'll have a handful of tables, but a few hundred thousand entries in the biggest table. I also need to be able to report the data. I also need to be able to import from Agresso.

One did catch my eye, which was the JPQL, in fact I could imagine the example on wikipedia fitting my needs, and I am able to code in Java. But I don't know if it fits the rest of my needs or if the project was handed over to someone not proficient in Java if it would be easily transferred. A GUI is essential.

I'm a little lost having never seen or even heard of RDBMS until last week, and now I need to decide what would work best going forward.

What RDBMS fits my needs to closest? How do I know what to pick?

share|improve this question
3  
If you're starting out, don't dive into something like JPQL...something more well known will be a better fit. But your requirements are kind of non-existent...so anything fits. I'd stick to the major players (Oracle, SQL Server, Postgres, MySQL) and you'll be fine. Generally, there's not near enough information here to actually recommend anything specific. – rfusca Aug 14 '12 at 15:45
@rfusca what would I need to add to get more specific answers? – Pureferret Aug 14 '12 at 16:12
And since you are just learning, you do not want in general to ever cursor through rows. Learn to do things in set-based and more efficient fashion. Looping is one of the worst things you can do in most databases. – HLGEM Sep 7 '12 at 14:03

closed as off topic by Phil, ypercube, Marian, RolandoMySQLDBA, Leigh Riffel Oct 4 '12 at 12:26

Questions on Database Administrators Stack Exchange are expected to relate to database administration within the scope defined in the FAQ. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about closed questions here.

1 Answer

up vote 6 down vote

My recommendation is to start out with Postgres. The advantage is that it has a full feature set and it teaches you good habits from the start. Once you are familiar with it, it is easier to move to up to the Oracle/DB2 approach or down to the MySQL approach easily enough. On the other hand it is an advanced database and you can take it extremely far if you want. And it is open source to boot.

share|improve this answer
+1 Good advice. – AlexKuznetsov Sep 7 '12 at 13:52
I keep clicking the up arrow but only one vote has been cast :) – swasheck Sep 7 '12 at 15:23

Not the answer you're looking for? Browse other questions tagged or ask your own question.