I need the help of those in the business of online databases. I am on the tech committee for my local school. I need the following info so i can figure out how much grant money it would cost to a pet project.
As a ballpark estimate, how much would it cost to create a searchable database with the following paramaters
6 fields
accessable to the web
data entry from a computer which is not the server
is there anything else you would need to know to give an estimate?
another info that might help is how much records the database will have.......thousands, millions etc
database will contain info on library books. thousands of entries at best. lest than ten thousand at most
doood mysql all the way, sort the hardware out if yer running those many records. Dont need a great deal but space might be an issue if yer talking millions of records
Any sql database (db) is best run on a mirrored (RAID1) set of disks, DO NOT USE RAID5!!, sql is transaction based and needs to write to the db when the logs get full, make sure you have fast disk access. If possible get a hardware RAID controller with battery backed memory, promise you it will save your life if the server goes pop
Other things to think about are backup, availability and business continuity..basically before you comission a live system, make it fail and what your procedures are to get it back
Man I sound like my old teacher now.....
It is my job, any worries pm me we'll sort it..
good to know, jod......I'll be working on some databases soon as a small part of my next project (prolly Oracle, Teradata and db2) ......now I know where to find ya....
no worries satman, just twat me a pm or msn
