468,290 Members | 1,940 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,290 developers. It's quick & easy.

Some general DBMS :( related questions....

AmberJain
884 Expert 512MB
Hello,

My new semester has started and I have a subject named DBMS (Database Management System). This is the first time I'm studying databases and so I'm not feeling very enthusiastic about databases (partly because I already had learnt C/C++ and I feel that programming is a lot easier that DBMS). Nevertheless, I must learn at least one DBMS as it is part of my college course. I'm confused and I want some suggestions:

Que-1: There are a lot of DBMSs out there (e.g. MySQL, Oracle, PostgreSQL). Although I don't exactly know the DBMS that will be part of my present semester, but it will be either SQL or Oracle. Which one is the best DBMS? Why do you prefer a particular DBMS?
Note: I don't love Microsoft and OS specific products. I will prefer using some free DBMS.

Que-2: I am an absolute idiot ;) when it comes to databases and DBMS. Which book will you prefer for the same?

Que-3: @MODS: Where should I post questions related to databases (and not some specific DBMS)?

Que-4: If you are asked to compare difficulty level of programming and learning a DBMS, which one would be lesser difficult (and logical)?

Thanks...
AmbrNewlearner
Jan 28 '09 #1
8 2795
JosAH
11,448 Expert 8TB
I like 'Mimer' a lot; it has a very conforming SQL engine and runs on about everything that can say 'beep'. The bloody thing even runs on a phone. It has all sorts of interfaces (C/C++ Java etc). Give it a try.

Read "Relational DBMSes" by one of the inventors of all this relational algebra misery: Mr. Date.

kind regards,

Jos

ps. you can download a full developer version at http://www.mimer.com
Jan 28 '09 #2
AmberJain
884 Expert 512MB
Hello,
@JosAH
Do you mean this book?

Thanks for your advice...
AmbrNewlearner
Jan 28 '09 #3
JosAH
11,448 Expert 8TB
@ambrnewlearner
It has the word 'relational' in the title if I remember well (I'm not near my pile of books right now). I bet Google can help you here. There were (or are?) two volumes of the book; the second one dealt with the relational model.

kind regards,

Jos

edit: I googled a bit and I think this is a fine book to start with.
Jan 28 '09 #4
Atli
5,058 Expert 4TB
Hi.

I think your DBMS vs programming question isn't really valid. They are two very different things, which are usually meant to work in cooperation.

DBMSs are used to store data, and sure, you can do a certain amount of programming on them, but that is limited at best.
Programming languages are meant to process data, which usually comes either directly from the user, or from some sort of a database.

I would consider it a very very huge gap in a programmer's skill set if (s)he did not at least know the basics of using a database, because at some point, we are all likely to be using a database.

As to which DBMS you should choose.
I recommend trying MySQL. It's free and it's very well documented (you could even check out the source code if the documentation failed you ;P).
A perfect place to start, even if you choose to use another server down the road.

For the basic queries you are likely to use at first, it won't really matter. All the major SQL servers confirm to the standard, at least up to the point where the basic queries will work on them all.

When I first learned SQL, my teacher had us use M$ SQL Server 2003, but I was using Linux so I just used MySQL. The difference was so little that even tho I did everything on MySQL, I got a perfect score for all my projects when they were tested on SQL Server 2003.

Although, getting to know the differences between the data types would be a good idea ;)
Jan 29 '09 #5
dafodil
392 256MB
I first learned MYSQL and PHP. After a while, I went into MS SQL and .Net. MYSQL and SQL are almost the same so I have no problem with that.

You don't need to read the whole book. I suggest read the basics. Start creating programs and apply it. Start with the basic processes like add, edit and delete in your programs. Then do complicated processes one step at a time. You'll notice that you are learning and at the same time enjoying since you are creating your own programs.
Jan 29 '09 #6
ashitpro
542 Expert 512MB
@ambrnewlearner
You should start learning first...It is interesting subject...quite logical if it comes to some concepts like concurrency management..
More precisely ACID properties...
If you feel any confidence over DBMS later, I suggest to start writing some UDF for mysql..

Regards,
Ash
Jan 29 '09 #7
NeoPa
32,066 Expert Mod 16PB
@ambrnewlearner
That should be Misc Questions Ambr (not café). I'll move this one for you.

For future questions of this type (general DB), if you find that they don't get noticed, you can use the Help thread to attract some expert attention. Please use this sparingly, but as an expert yourself, there's no reason why you should not have the benefits of being a member of the team.
Jan 29 '09 #8
AmberJain
884 Expert 512MB
Hello,

My internet connection was down from last few days and so I could not reply back. But, now my connection is up and running again :)

Thank you all for your valuable responses. I now get a feel that databases are not a lot boring as I thought previously.

@NeoPa: Thanks for moving this thread to 'Misc. Questions'. And, I will (try to ;) remember that I need to post such questions to Misc forum.

@JosAh: I have ordered the book that you linked in your last reply. It will take a few days for it to be delivered at my doorstep. And so, till then I'm reading to Introduction to Database Systems by the same author (i.e. C. J. Date) that I found out in my university library. After going through first chapter of this book, I feel that databases are not as un-intuitive as I thought. There is no doubt that books written by C. J. Date are best at explaining the basic concepts.

Thanks to everyone once again...

AmbrNewlearner
Feb 3 '09 #9

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by I.V. Aprameya Rao | last post: by
2 posts views Thread by Steven O. | last post: by
10 posts views Thread by Albretch | last post: by
193 posts views Thread by Michael B. | last post: by
50 posts views Thread by Jatinder | last post: by
30 posts views Thread by GeorgeRXZ | last post: by
3 posts views Thread by =?Utf-8?B?Ymxi?= | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.