Recommended database for large commerical database?

ColdAsIce

ColdAsIce

ColdAsIce

Soldato
Joined
26 May 2006
Posts
6,207
Location
Edinburgh
If you were to run a booking system for say a leisure centre. What database system would be required for something of that size?
 
IMO, desktop software such as Access is just a no no. Viable for maybe seeing a system working quickly and designing but for something like this I'd be looking to MySQL

With that in mind, you'd then want something like a VB user interface or a web based (local intranet) system using PHP.
 
Either of the following 3 should do the job

mySQL
SQl Server
Oracle

But would need to know more about your requirements to be more specific.


Taff
 
Supertaff said:
Either of the following 3 should do the job

mySQL
SQl Server
Oracle

But would need to know more about your requirements to be more specific.


Taff
Click to expand...
You can add DB2 to that list as well, I have a feeling that DB2 V9 Express is free these days too.
 
Alright thanks for the feedback. Basically the place were I work have payed for a whole new system to be put into place that will be used to book things like the Swimming pool, squash courts etc. I havn't heard all the details but I had heard the company wanted to use MSDE which if I remember correctly was only for small systems?

This company also couldnt answer any questions on backup solutions etc.
 
ColdAsIce said:
Alright thanks for the feedback. Basically the place were I work have payed for a whole new system to be put into place that will be used to book things like the Swimming pool, squash courts etc. I havn't heard all the details but I had heard the company wanted to use MSDE which if I remember correctly was only for small systems?

This company also couldnt answer any questions on backup solutions etc.
Click to expand...

MDSE or SQL Server 2005 Express will only deal with databases smaller then 2GB in size, so if it's a half decent database you'll need a full SQL server 2005 licence. As for backup, make sure its on a server with a tape drive and use Backup Exec with the SQL add on.

Burnsy
 
A bookings system for a leisure center could easily be run on Access. And would be best served by Access because it can have integrated GUI screens... whereas pretty much any other database system will need substantial further development on top.

If you really do want a full blown RDBMS then just get one of the free ones... MSSQL Express, MySQL etc... some of them may have limits but whatever they are it won't matter. Do you realise how many booking records you can fit in MSSQL Express' 4GB limit?!

LOL @ the people recommending Enterprise database servers :D

Butters said:
MSDE will work reasonably well, but dont expect it to be rapid.
Click to expand...
MSDE is just SQL Server? One of the fastest RDBMS there is? Yes it's capped to 2GB and has a connection limit... but do you honestly think a tiny leisure center database is going to be pushing those boundaries?
 
Another option, use Access for all your forms and reports and use SQL Express to store your data. Get the data in Access using pass through queries. Although I agree with Nathan a leisure centre should be fine with Access.
 
Be very careful of using an Access/SQL Express setup as if you have multiple users you will find that Access locks tables and blocks others with queries.

IF you go down the access route, use two databases, one with the data tables and one with the front end by creating linked tables.

SQL Express with an ASP.NET front end will probably do for a booking system, is easy to maintain and any developments won't need distributing to clients
 
You must log in or register to reply here.
Back
Top Bottom