Re: Matrix and associated comments... (fwd)

SUBJECT: Re: Matrix and associated comments... (fwd) ==================================================== The following corrections were made for Informix and are indicated by "<<<<". If you have comments and or corrections, send them to me. --Bill ----- Begin Included Message ----- > > Feature comparison Matrix: > > Version 0.6 > > > > Product > > O = Oracle7 Version 7.0 > > S = Sybase Version 4.9 > > A = Ask/Ingres Version 6.4 > > I = Informix On-Line Version 5.01 <<<< > > > > Product O S A I > > I. PERFORMANCE > > ================ > > 1. Row Level Locking Y N N Y <<<< > > 2. No Lock Escalation Y N N N > > 3. No Read Locks Y 1 N 1 > > 4. Dirty Read Mode N N N Y > > 5. Multi Server Architecture Y Y Y N > > 6. Symmetric Multi-Processor Support Y Y Y Y > > 7. Support for Loosely Coupled Systems Y N Y N > > 8. Array Interface Y N N N > > 9. Shared Commits Y Y Y Y > > 10. Asynchronous I/O Y Y Y Y > > 11. Shared Log Files Y Y Y Y > > 12. Non-Blocking Queries Y 2 N 2 > > 13. Clustered Tables and Indexes Y Y Y Y > > 14. ANSI Standard Cursor Support Y N Y Y > > 15. Sequence Generator Y N N N > > 16. Intelligent Optimizer Y Y Y Y > > 17. Network Optimization Y N Y Y <<<< > > 18. Cost Based Optimizer Y Y Y Y > > 19. Heuristical Query Optimizer N N Y N > > 20. Stored Procedures in Database Y Y Y Y > > 21. Shared Procedure Cache Y Y Y Y > > 22. Parallel Data Query N N N N > > 23. Parallel Index Build N N N N > > > > > > > > II.INTEGRITY O S A I > > ============== > > 24. Adherence to Industry Standards > > SQL Interface Y Y Y Y > > FIPS 127 Validated Y N Y Y > > SQL2 Compliant Y N Y Y > > 25. Declarative Integrity Model Y N Y Y > > 26. Cascading Updates Y N Y Y > > 27. Cascading Deletes N N N N > > 28. Adaptable Datatypes Y Y N N > > 29. Null Support Y Y Y Y > > 30. Database Triggers Y Y Y Y <<<< > > 31. PRE- and POST- Triggers Y N N Y > > 32. Per Row Triggers Y N N Y <<<< > > 33. Stored Procedures Y Y Y Y > > 34. Automatic Procedure Recompilation Y Y Y Y > > 35. User Defined Datatypes N N Y N > > 36. Event Alerters Y N Y Y > > 37. Database Events Call C Program Y 3 Y N > > 38. Stored Procedures Call C Program Y 3 Y N > > > > > > > > III. DATABASE O S A I > > ============= > > 39. Portable Y Y Y Y > > 40. Automatic Database Recovery Y Y Y Y > > 41. Multiplexed Log Files Y Y Y Y > > 42. Mirrored Databases Y Y Y Y > > 43. Dynamic Database Backup Y Y Y Y > > 44. Dynamic Log Backup Y Y Y Y > > 45. Database Task Control Y Y Y Y > > 46. On-Line Software Diagnostics Y Y Y Y > > 47. Hot Standby Server Y Y Y N > > 48. Full Cluster Utilization Y N Y N > > 49. On Line Recovery Y Y N Y > > 50. Parallel Backup Y N N N > > 51. Parallel Recovery Y N N N > > 52. Multiple Log Files Y N Y N > > 53. Resource Limiter/Governor Y N N N > > 54. DBA Utilities Y Y Y Y > > 55. Database Auditing Y Y Y Y > > 56. Standard (Model) Database Y Y Y Y > > 57. Standard Database Tuning Parameters Y Y Y Y > > > > > > > > IV.DISTRIBUTED RDBMS O S A I > > ====================== > > 58. Distributed Join Y N Y Y > > 59. Heterogeneous Data Support Y Y Y N > > 60. Synchronous Table Replication Y N Y N > > 61. Asynchronous Table Replication Y N N N > > 62. Connections to other Databases Y Y Y Y > > 63. Programmatic Two Phase Commit Y Y Y Y > > 64. Transparent Two Phase Commit Y N Y Y > > 65. Two Phase Commit to Heterogeneous RDBMS Y N N N > > 66. Movable Transaction Coordinator Y N N N > > 67. Remote Procedure Calls Y Y Y Y > > 68. RPC's Protected by Two Phase Commit Y N Y Y > > 69. Procedural Database Gateway Y Y N N > > 70. SQL Based Database Gateway Y Y Y Y > > 71. XA Compliant Y N N Y > > 72. TP Monitor Support Y N N Y > > 73. Distributed Optimization Y N Y Y <<<< > > 74. Multi-Protocol Routing Y N N N > > 75. ODBC Support Y Y Y Y > > 76. SQL Access Group Support Y Y Y Y > > > > > > V. DATABASE SECURITY O S A I > > ====================== > > 77. OS Security Integration Y Y Y Y > > 78. Database Auditing Y Y Y Y > > 79. User Groups Y N Y Y > > 80. User Group Privileges Y N Y Y > > 81. Mandatory Access Control Y N Y Y > > 82. Undergoing for Evaluation by NCSC Y Y Y Y > > 83. Standard Tools with Trusted Product Y N N Y > > 84. Non-Dedicated Trusted Server Y N Y Y > > 85. Product being evaluated at C2 Level Y 4 Y Y > > 86. Product being evaluated at B1 Level Y 4 Y Y > > > > > > > > VI.LANGUAGES & TOOLS O S A I > > ====================== > > 87. SQL Procedural Language Y Y Y Y > > 88. Text/Image Datatypes (BLOBS) Y Y N Y > > 89. Visual Query Language Y Y Y Y > > 90. Union Operator Y N Y Y > > 91. NIST Verified Conformance to Standards Y N Y Y > > 92. Select for Update Y N Y Y > > 93. CASE Tools - Upper and Lower Y Y N N > > 94. Graphics Tools Y Y Y Y > > 95. Mail Systems Integration Y 5 N N > > 96. Office Automation Tools Y Y Y Y > > 97. Bit-Mapped Graphics Y Y Y Y > > 99. GUI Transparency Portability Y Y Y Y > > 99. National Language Support > > European Y Y Y Y > > Semitic Y N N N > > Asian Y N Y Y > > 100. Integration of Tools Y N Y Y > > 101. Precompiler Support > > C Y Y Y Y > > COBOL Y Y Y Y > > ADA Y N Y Y > > Fortran Y N Y Y > > C++ 6 N N N > > Module Language Y N Y N > > 102. Bind Variable Support Y N Y Y > > 103. SQL Generator/Editor Y Y Y Y > > 104. Application Generator Y Y Y Y > > 105. Financial Applications Y Y N Y > > 106. Manufacturing Applications Y N Y N > > > > > > 1,2 Sybase has Browse Mode which does not use read locks. > > Informix has dirty read mode which does not use read locks. > > Neither guarantees consistent or repeatable data. > > > > 3 Through the Open Gateway add on product this functionality > > is available. > > > > 4 Sybase System 10 is under evaluation by the NCSC, but the current > > product is not. > > > > 5 Mail System available from third party > > > > 6 C++ Precompilers are available on DOS/Windows only. ----- End Included Message ----- -- %%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%% William Daul Advanced Support INFORMIX SOFTWARE INC. 4100 Bohannon Dr. (415) 926-64