RDBMS Server Features Matrix - Beta Draft

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 to me and I will try to verify and include in the upcoming production version. Feel free to suggest additional categories. Also, I would really appreciate it if someone versed in Sybase System 10 would fill in the matrix for that product. If someone out there would like to fill in the matrix for DB2, Interbase, or additional products I will be happy to include and distribute. I welcome any and all suggestions.

Level of comfort: I am pretty confident of the data for Oracle and Sybase, as I have recent manuals and lots of experience with these products. I have an older set of docs for Ingres and Informix and thus would be grateful if someone would review those columns carefully. That is why this is a Beta Document.

I hope this helps someone out there !!!

• Dan

Daniel Druker
Anderson Graduate School of Management at UCLA                    

Disclaimer: None. I'm a student now and I don't care what you think.

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 

1. Row Level Locking Y N N N
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 N
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

	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 N
31. PRE- and POST- Triggers			Y N N Y
32. Per Row Triggers 				Y N N N
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 N
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. Received on Tue May 25 1993 - 08:27:19 CEST