Re: RDBMS Server Features Matrix - Beta Draft

In article <1993May24.232720.1603_at_mic.ucla.edu> ddruker_at_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. 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

see GemBase, others...

>
>
>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.

--
--
    Like Entropy, bugs can only be created, not destroyed.

RW Salnick, Spokane,WA  |  Home: salnick_at_dejavu.spk.wa.us
  Amiga 1000, WB 1.3    |  Work: salnick_at_mfgsys.kaiser.spk.wa.us
      WA9BVE            |