472,958 Members | 2,001 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,958 software developers and data experts.

Some general DBMS :( related questions....

884 Expert 512MB

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)?

Jan 28 '09 #1
8 3002
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,


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

Thanks for your advice...
Jan 28 '09 #3
11,448 Expert 8TB
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,


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

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
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
542 Expert 512MB
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..

Jan 29 '09 #7
32,547 Expert Mod 16PB
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
884 Expert 512MB

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...

Feb 3 '09 #9

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

Similar topics

by: I.V. Aprameya Rao | last post by:
Hi I have to implement a flat file dbms. The basic condition is that relations will be given in files and i will have to run certain select project join queries on those relations. Can...
by: Az Tech | last post by:
Hi people, (Sorry for the somewhat long post). I request some of the people on this group who have good experience using object-orientation in the field, to please give some good ideas for...
by: Steven O. | last post by:
First, this may not be the correct newsgroup. I have some relatively basic questions on SQL. I tried to find a newsgroup that was specifically just about SQL, and was surprised to find that all...
by: Albretch | last post by:
.. Can you define the Character Set for particular tables instead of databases? . Which DBMSs would let you do that? . How do you store in a DBMS i18n'ed users' from input, coming over the web...
by: Michael B. | last post by:
I was just thinking about this, specifically wondering if there's any features that the C specification currently lacks, and which may be included in some future standardization. Of course, I...
by: Jatinder | last post by:
I 'm a professional looking for the job.In interview these questions were asked with some others which I answered.But some of them left unanswered.Plz help. Here are some questions on C/C++, OS...
by: Steve | last post by:
I have read a couple articles online, read my Jesse Liberty book but I am still confused as to just what the best practices are for using exceptions. I keep changing how I'm working with them and...
by: GeorgeRXZ | last post by:
Hi Friends, I have some questions related to C Language. 1What is the difference between the standard C language and Non standard C language ? 2which is better C Lanugage, C under Linux/...
by: =?Utf-8?B?Ymxi?= | last post by:
I am posting to the general discussion group - but I cannot find my postings... or replies...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 4 Oct 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
by: Aliciasmith | last post by:
In an age dominated by smartphones, having a mobile app for your business is no longer an option; it's a necessity. Whether you're a startup or an established enterprise, finding the right mobile app...
by: tracyyun | last post by:
Hello everyone, I have a question and would like some advice on network connectivity. I have one computer connected to my router via WiFi, but I have two other computers that I want to be able to...
by: giovanniandrean | last post by:
The energy model is structured as follows and uses excel sheets to give input data: 1-Utility.py contains all the functions needed to calculate the variables and other minor things (mentions...
by: NeoPa | last post by:
Hello everyone. I find myself stuck trying to find the VBA way to get Access to create a PDF of the currently-selected (and open) object (Form or Report). I know it can be done by selecting :...
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 1 Nov 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM) Please note that the UK and Europe revert to winter time on...
by: nia12 | last post by:
Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of...
by: isladogs | last post by:
The next online meeting of the Access Europe User Group will be on Wednesday 6 Dec 2023 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, Mike...
by: GKJR | last post by:
Does anyone have a recommendation to build a standalone application to replace an Access database? I have my bookkeeping software I developed in Access that I would like to make available to other...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.