On Friday 23 March 2001 15:24, Mukund wrote:
> |[2] The database should be network based that is distributed database.. I
> |should be able to access my database from a centralised server from any
> |client, but with appropriate permissions..
>
> Linux is based on network only so every thing under linux is network based
Distributed database is quiet different from accessing database from
anywhere. I hope you understand what you are saying. Why does a university
server needs distributed database? What's your load? You need distributed
database when you need cluster of database servers...
> |[4] and also security is top priority on my mind...Will the database
> | permit view based security like in Oracle. For example students should be
> | able to see only their personal details and not of others.. Also they
> | should not be allowed to look at their internal marks before a certain
> | date.. So i need
> Security is not one time job and one has to keep an eye on exploits.
These are your application requirement so do it in application.
Don't create student users in database. Authenticate them using pam and let
the application decide what to show and what not to.
Oracle 9i provides such features as virtual views etc. But I doubt if you
really want them in database...
>
> |[5] Ease of use.....
>
> The client decides the ease of use.
You should know SQL though..
>
> |[6] Licensing issues.... I know this may not be much of a matter..in
>
> Linux..
>
>
> FREE
Correction... GPL.. It's precise...
> |[8] What are the Hardware capabilities required-- Also what distros to be
> |used.. Can i use Redhat or Suse or Mandrake..???
>
> Secuirity wise debian would be best.
>
Whatever distro you use, use kernel 2.4.x.
You better know requirement so decide hardware yourself.
As a rule of thumb,
Put a loads of RAM like 512MB etc. and big enough harddisk like 20GB,
preferrably SCSI.
Any cpu more than 600 MHz(Not celeron... of course) should be OK. Prefer AMD
cpus if you get a 100MHz FSB with DDR. Duron is cost saver and athlon is
beast. You take a pick...
Shridhar
----------------------------------------------
An alpha version of a web based tool to manage
your subscription with this mailing list is at
http://lists.linux-india.org/cgi-bin/mj_wwwusr
