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

12-22-09, 20:49
|
|
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?
|
|

12-23-09, 04:07
|
|
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.
|
|

12-23-09, 04:10
|
|
Registered User
|
|
Join Date: Sep 2009
Posts: 39
|
|
|
|
Quote:
Originally Posted by bharanidharanit
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.
|
|

12-23-09, 07:07
|
|
vaguely human
|
|
Join Date: Jun 2007
Location: London
Posts: 2,519
|
|
Quote:
Originally Posted by dportas
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.
|
|

12-24-09, 03:20
|
|
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.
|
|

12-29-09, 09:37
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,719
|
|
Quote:
Originally Posted by Fakin
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"
|
|

12-29-09, 20:15
|
|
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...
|
|

12-29-09, 21:04
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,516
|
|
Quote:
Originally Posted by sco08y
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...
|
|

12-31-09, 11:36
|
|
Registered User
|
|
Join Date: Sep 2009
Posts: 39
|
|
Quote:
Originally Posted by blindman
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.
|

12-31-09, 11:47
|
|
Registered User
|
|
Join Date: Sep 2009
Posts: 39
|
|
Quote:
Originally Posted by blindman
MySQL is satisfactory for simple database designs.
|
this is wrong!
|
|

12-31-09, 13:29
|
|
World Class Flame Warrior
|
|
Join Date: Jun 2003
Location: Ohio
Posts: 11,719
|
|
Quote:
Originally Posted by Fakin
sql server is very slow in ratio of other databases.
|
Then the problem was with your testing.
Quote:
Originally Posted by Fakin
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
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"
|
|

12-31-09, 13:33
|
|
SQL Consultant
|
|
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,516
|
|
Quote:
Originally Posted by Fakin
this is wrong!
|
don't be ludicrous, you look like a fool

|
|

12-31-09, 15:42
|
|
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"
|
|

12-31-09, 16:47
|
|
Registered User
|
|
Join Date: Oct 2002
Location: Baghdad, Iraq
Posts: 697
|
|
Quote:
Originally Posted by Fakin
I tested sql server, oracle, mysql, postgresql.
|
I'm calling you out. Post your test procedures and results.
|
|

12-31-09, 17:39
|
|
Registered User
|
|
Join Date: Dec 2007
Location: London, UK
Posts: 732
|
|
Quote:
Originally Posted by Fakin
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
|
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|