Choice of a Database System

Hello everyone,

I am in the process of designing a business system (Database System) for a relatively large organization.

This system must be able to enter data, apply conditions and formulas, perform datamining and data warehousing, to name a few of its functions;

It has to be in a location or structure whereby 300+ users can access and operate in its environ. seamlessly without much bandwith or slow down issues.

Can someone suggest the best platform to handle this type of workload? Is it an access db or SQL server? What OS and hardware architecture would be recommended?

I hope this was the correct forum to pose this question.

Thank you all in advance

A...

re: Choice of a Database System

the choice of database for an application depends on some factor such as:

1. the application platform (Window, Linux, Independent or Dependent)
2. the amount of data to be stored on it
3. the user experience
4. the user demand
5. the robustness of the database

if u will be deploying your application on window os, go for SQL Server;
if ur application is going to be written in .NET, SQL Server or Oracle will be better
if ur application will be written in Java, either SQL Server, Oracle, or MySQL will be ok

re: Choice of a Database System

If you are going for enterprise server licensing, check EnterpriseDB

It's cost effective, yet higher performance..

re: Choice of a Database System

Thanks ssnaik84 for the response, we will look into it