Ok here are my suggestions:
1. IT departments and firms will always prefer Oracle to MV. Not because of any native benefit from either model but because they get paid far more for Oracle consulting and systems administration than MV. I'm caught in this loop now - my employers have realised that they can charge me out for more money doing Oracle work and I'm fighting to stay in the MV corner.
So I suggest that instead of offering better facilities and improving the product, we should just concentrate on making MV *REALLY* expensive, then people will rush out to recommend it.
2. Regarding security, if I choose to create an SQL table under UniVerse I believe that privileges, data types and constraints should be applied globally. It should NOT be possible to alter anything in that table without these constraits being checked, by any (legitimate) method (ok you can always write a C program and write into the file at an OS level, but you could do the same with any database given the time). This would provide the necessary security.
For UniVerse files, on the other hand: these should be as open as currently. Then it is up to developers to decide which to use, what level of security is suitable for any given circumstance, and legacy systems will be unharmed.
3. Addressing an earlier comment, having strong constraints in the database does not take away the need for verifying in the application. You still need to apply full verification at the input stage, otherwise your updates will fail but you can't tell the operator why! So it helps the DBA but doesn't cut down work for the developer.
Brian
________________________________________________________________________ This email was checked on leaving Microgen for viruses, similar malicious code and inappropriate content by MessageLabs SkyScan.
DISCLAIMER
This email and any attachments are confidential and may also be privileged.
If you are not the named recipient, please notify the sender immediately and do not disclose the contents to any other person, use it for any purpose, or store or copy the information.
In the event of any technical difficulty with this email, please contact the sender or [EMAIL PROTECTED]
Microgen Information Management Solutions http://www.microgen.co.uk ------- u2-users mailing list [EMAIL PROTECTED] http://www.u2ug.org/listinfo/u2-users
