Re: RDBMS Server Features Matrix - Beta Draft
In article <1993May24.232720.1603@mic.ucla.edu> ddruker@agsm.ucla.edu (Daniel Druker) writes: >Please find below a Beta Quality draft of the RDBMS Feature Matrix I've been >working on. Many thanks to those who sent suggestions for categories, >and to those who supplied answers for some of the categories I was not >up to speed on for all the products. By Beta Quality I mean I have included >all categories suggested by readers of the Alpha posting, have updated >the matrix with new information, and have cleaned up the format a little. > >PLEASE HELP Make this a better document. Send any and all corrections OK... some additions/corrections. It would appear that bundling differences between products have caused you to miss some of Ingres' most powerfull features. > >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.X > >Product O S A I >I. PERFORMANCE >================ >1. Row Level Locking Y N N N >2. No Lock Escalation Y N N N more clearly expressed as a positive: 2. Lock Escalation N Y Y Y >3. No Read Locks Y 1 N 1 What does "1" signify? >4. Dirty Read Mode N N N Y >5. Multi Server Architecture Y Y Y N Other than Ellison's marketing hype, exactly what does this signify? More than one DBMS server on a machine? Ingres has done this for at least 7 years. >6. Symmetric Multi-Processor Support Y Y Y Y >7. Support for Loosely Coupled Systems Y N Y N If here, you mean operation in a cluster, Ingres has done this for 7 years. >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 what does "2" signify? >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 N Ingres Star optimizes based on network cost >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 Ingres supports this via Ingres/Knowledge management >28. Adaptable Datatypes Y Y N N Ingres supports this via Ingres/Objects >29. Null Support Y Y Y Y >30. Database Triggers Y Y Y N Ingres supports this via Ingres/Knowledge (at least!) >31. PRE- and POST- Triggers Y N N Y >32. Per Row Triggers Y N N N Ingres supports this via Ingres/Knowledge >33. Stored Procedures Y Y Y Y >34. Automatic Procedure Recompilation Y Y Y Y >35. User Defined Datatypes N N Y N This is exactly what Ingres/Objects is... user definable datatypes and user defined operators. >36. Event Alerters Y N Y Y >37. Database Events Call C Program Y 3 Y N Ingres database events can call a C program, or make operating system calls, or... >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 Not sure what this means... >49. On Line Recovery Y Y N Y >50. Parallel Backup Y N N N do you mean making a backup while the database is in operation? Ingres has done this for the last two versions. >51. Parallel Recovery Y N N N As above... >52. Multiple Log Files Y N Y N >53. Resource Limiter/Governor Y N N N Ingres supports this via Ingres/Knowledge >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 Not sure what this means. If it refers to the ability to (for example) make a join between a database table and data in an operating system flat file, Ingres makes (for VMS, anyway) operating system files available as if they were database tables (Ingres/Rdb Gateway, Ingres/Star) >60. Synchronous Table Replication Y N Y N Ingres supports this via Ingres/Knowledge >61. Asynchronous Table Replication Y N N N As above... >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 N Very Much!!! >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 ??? exactly what is this? >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. Integr