If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > General > Database Concepts & Design > Confused with databases

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 12-22-09, 20:49
bharanidharanit bharanidharanit is offline
Registered User
 
Join Date: Nov 2008
Posts: 115
Confused with databases

Hi,
I know what is the database is and what is it for. But i can find many databases like sql, oracle, mssql, access and many more. Which of these database is a best one for handling more users for a large organization? Also whats is the difference between mysql and sql?
Which one is giving a free express edition?
What is pc-based databases and others?
Reply With Quote
  #2 (permalink)  
Old 12-23-09, 04:07
dportas dportas is offline
Registered User
 
Join Date: Dec 2007
Location: London, UK
Posts: 732
Are you asking this question in a professional capacity? If so then it seems obvious that you aren't qualified to make such decisions yourself. If you want to develop a database strategy for your company then I suggest you first hire someone to help you. There is no quick answer about which Database Management System (DBMS) is "best" for your circumstances.

Access is not a DBMS. It is an application development tool.

MySQL is just one example of a DBMS that uses the SQL language. Others are Oracle and Microsoft SQL Server. MySQL, Oracle and Microsoft SQL Server all have versions that are free to download.
Reply With Quote
  #3 (permalink)  
Old 12-23-09, 04:10
Fakin Fakin is offline
Registered User
 
Join Date: Sep 2009
Posts: 39
Quote:
Originally Posted by bharanidharanit View Post
Hi,
I know what is the database is and what is it for. But i can find many databases like sql, oracle, mssql, access and many more. Which of these database is a best one for handling more users for a large organization? Also whats is the difference between mysql and sql?
Which one is giving a free express edition?
What is pc-based databases and others?
sql server is microsoft database and only supported platform is windows.
sql server and windosws is not good for handling more users.
sql express have limitations one processor and max database is 4GB.

oracle express have limitations as sql server.
oracle standard edition have limitation about processor(2 or 4), and enterprise edition is very expensive.

in your case I suggest mysql or postgresql and FreeBsd as operating system, because this OS can handling many users.

if you have much money then oracle on solaris.
Reply With Quote
  #4 (permalink)  
Old 12-23-09, 07:07
mike_bike_kite mike_bike_kite is offline
vaguely human
 
Join Date: Jun 2007
Location: London
Posts: 2,519
Quote:
Originally Posted by dportas View Post
Are you asking this question in a professional capacity?
I think he's asking this in a "I'm a student and I want someone to do my homework" capacity.
Reply With Quote
  #5 (permalink)  
Old 12-24-09, 03:20
topcat2 topcat2 is offline
Registered User
 
Join Date: Jun 2008
Posts: 7
The most common RDBMS for large organizations includes Oracle, MySQL, and SQL Server to a smaller extent.

When you are asking about the difference between MySQL and SQL, I am assuming you mean SQL Server, not SQL the query language. If so, the biggest difference is that MySQL is free and can be used on basically all operating systems, while SQL Server is pretty much limited to the Microsoft OS.
Reply With Quote
  #6 (permalink)  
Old 12-29-09, 09:37
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,719
Quote:
Originally Posted by Fakin View Post
sql server and windosws is not good for handling more users.
sql express have limitations one processor and max database is 4GB.
Absolutely false.
SQL Server is capable of handling terabyte-sized databases with hundreds or thousands of users. It is cost-effective and requires minimal administrative overhead.
Please don't make statements about technologies in which you do not have experience.
MySQL requires considerable administrative overhead, similar to Oracle, though both are capable of handling large multi-user applications as well. MySQL is free, but lacks the features of more advanced database servers such as Oracle and SQL Server. MySQL is satisfactory for simple database designs.
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #7 (permalink)  
Old 12-29-09, 20:15
sco08y sco08y is offline
Registered User
 
Join Date: Oct 2002
Location: Baghdad, Iraq
Posts: 697
Quote:
Please don't make statements about technologies in which you do not have experience.
Hold on, now, if we didn't allow people to make completely unfounded sweeping generalizations, we'd have to shut down virtually all of the trade magazines, IT educators, tech blogs...
Reply With Quote
  #8 (permalink)  
Old 12-29-09, 21:04
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,516
Quote:
Originally Posted by sco08y View Post
Hold on, now, if we didn't allow people to make completely unfounded sweeping generalizations, we'd have to shut down virtually all of the trade magazines, IT educators, tech blogs...
not to mention anything ever said by a politician about the difficulties of being homeless or even just out of work, or a "man of the cloth" about marriage problems, et cetera...
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #9 (permalink)  
Old 12-31-09, 11:36
Fakin Fakin is offline
Registered User
 
Join Date: Sep 2009
Posts: 39
Quote:
Originally Posted by blindman View Post
SQL Server is capable of handling terabyte-sized databases with hundreds or thousands of users. It is cost-effective and requires minimal administrative overhead.
about administartion is true.
sql server can handling and more, but you need better and higher hardware in ratio of other database such as oracle.I tested sql server, oracle, mysql, postgresql.
sql server is very slow in ratio of other databases.

in real world max. database on sql server is under 2 TB, because nobody dare using sql server for bigger databases.

most financial institutions using oracle, db2 or sybase.
and for OS using unix.
I don't know, maybe you are MS boy??


Last edited by Fakin; 12-31-09 at 11:43.
Reply With Quote
  #10 (permalink)  
Old 12-31-09, 11:47
Fakin Fakin is offline
Registered User
 
Join Date: Sep 2009
Posts: 39
Quote:
Originally Posted by blindman View Post
MySQL is satisfactory for simple database designs.
this is wrong!
Reply With Quote
  #11 (permalink)  
Old 12-31-09, 13:29
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,719
Quote:
Originally Posted by Fakin View Post
sql server is very slow in ratio of other databases.
Then the problem was with your testing.

Quote:
Originally Posted by Fakin View Post
in real world max. database on sql server is under 2 TB, because nobody dare using sql server for bigger databases.

most financial institutions using oracle, db2 or sybase.
Actually, many financial institutions are moving away from Oracle, usually to SQL Server or MySQL, because of Oracle's recent increase in licensing fees.

Quote:
Originally Posted by Fakin View Post
I don't know, maybe you are MS boy??
SQL Server, Oracle, MS Access, MySQL. From your SIG I can see that you are simply one of the anti-MS crowd. You don't list SQL Server as one of the platforms in which you have experience, but that apparently does not prevent you from making generalizations about it....
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #12 (permalink)  
Old 12-31-09, 13:33
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,516
Quote:
Originally Posted by Fakin View Post
this is wrong!
don't be ludicrous, you look like a fool

__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
  #13 (permalink)  
Old 12-31-09, 15:42
blindman blindman is offline
World Class Flame Warrior
 
Join Date: Jun 2003
Location: Ohio
Posts: 11,719
To be fair, I don't think he actually meant that MySQL is UNsatisfactory for simple designs....
__________________
If it's not practically useful, then it's practically useless.

blindman
www.chess.com: "sqlblindman"
Reply With Quote
  #14 (permalink)  
Old 12-31-09, 16:47
sco08y sco08y is offline
Registered User
 
Join Date: Oct 2002
Location: Baghdad, Iraq
Posts: 697
Quote:
Originally Posted by Fakin View Post
I tested sql server, oracle, mysql, postgresql.
I'm calling you out. Post your test procedures and results.
Reply With Quote
  #15 (permalink)  
Old 12-31-09, 17:39
dportas dportas is offline
Registered User
 
Join Date: Dec 2007
Location: London, UK
Posts: 732
Quote:
Originally Posted by Fakin View Post
about administartion is true.
sql server can handling and more, but you need better and higher hardware in ratio of other database such as oracle.I tested sql server, oracle, mysql, postgresql.
sql server is very slow in ratio of other databases.
Independently scrutinised industry-standard benchmarks contradict you there.
SQL Server 2008: Benchmarks

It's very easy to write your own tests but how many different hardware configurations have you actually tested?

Quote:
in real world max. database on sql server is under 2 TB, because nobody dare using sql server for bigger databases.
That might have been an arguable position 5 years ago, but not today. I know of and have worked with some of those listed here:
SQL Server 2008: Case Studies
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On