[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference ulysse::rdb_vms_competition

Title:	DEC Rdb against the World

Moderator:	HERON::GODFRIND

Created:	Fri Jun 12 1987
Last Modified:	Thu Feb 23 1995
Last Successful Update:	Fri Jun 06 1997
Number of topics:	1348
Total number of notes:	5438

305.0. "Rdb V3 vs ORACLE V6 " by PRCSWS::FREEMANYIM () Thu Feb 16 1989 12:09

    Hi, folks,
    
    I was asked to present a topic of "Rdb Vs Oracle". As my info on
    Oracle may be of Oracle V5 and I do not have info on V6, I would
    like to invite some comments/suggestion on the following Rdb, Oracle
    comparision. The comparision statements are extracted from some
    corparation seminar. Thanks in advance.
    
    My question is : are they still valid? 
    
    -------------------------------------------------------------------
    
    	Rdb/VMS	  Wins 	  over     ORACLE
    =======================================
    
               ORACLE				Rdb/VMS
    	       ------				-------
    
    o No control over placement of relations	Full placement control.
      and indexes within a partition over
      many drives.
    
    o Partitions may not be deleted from a      Permits dynamic space
      database					optimization and deletion
    						of area files.
    
    o No HASH index support.			Supports HASH indexes.
    
    o Fixed page size of 2048 bytes with 1972	Supports varible page
      bytes available for data records.		sizes.
    
    o Space on a page is not reused when a	Deleted space re-used
      record is deleted until all records	as necessary.
      on the page have been deleted.		
    
    o No index only retrievals when the index	Indexes always compressed
      is compressed.				and do support index-only
    						queries.
    
    o Indexes are not used in the GROUP BY 	Indexes are used.
      clause.
    
    o AIJ not supported in a cluster.		Full AIJ support in cluster.
    
    o No backup facility.			Include RMU/BACKUP and
    						RMU/RESTORE.
    
    o No SQL Module language support.		Supports SQL Module
    						language.
    
    
    
    I believe the Oracle V6 has overcome some of the above shortcomings.
    Someone knowlegeable there please help.
    
    
    Regards,
    Freeman.

T.R	Title	User	Personal Name	Date	Lines
305.1	DSESG ORACLE vs. Rdb doc?	TRCO01::BROWN	Spring is the time for growth	`Tue May 30 1989 03:00`	6
	I may have missed it while searching the directory but Is there an equivalent doc for ORACLE and Rdb/VMS to the one referenced in note 159 for Ingres and Rdb/VMS? -ian