grof.TakeThisOut@rogers.com wrote:
[snip]
>> 2. Do these dB have Security features?
>> 2a. If yes, what security features are supported? For instance do they
>> support encryption or SSL connection?
>> 3. How does the database perform and what is the criteria for the
>> performance matrix?
>
> I'll defer these to others with more expertise in the area.
2.) Yes, INGRES has the "standard" DBMS security permissions and
constraints, including password-protected roles. INGRES also provides
auditing, which is complementary to any security implementation.
2a.) Here's a section from the online INGRES documentation regarding
using INGRES with Kerberos
<http://docs.ingres.com/connectivity/ConfiguringIngrestoUseKerberos>.
As an aside, I'm actually tinkering with using SASL with INGRES and have
used SSH port forwarding in other circumstances.
3.) Performance metrics are always loaded with vendor skew and bloat, so
I'll simply say that INGRES performs very well when tuned properly, and
it *can* be tuned properly if one takes the time to appreciate its
multi-threaded architecture, memory management system, storage
structures, and file system-based table implementation.
If you have specific performance considerations there are many that
monitor this list which can answer your questions specifically and with
consummate expertise.
Mark R. Winston
www.datavailable.com >> Stay informed about: Clustering, Security, Performance, Load Balance