[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

451.0. "Oracle's Data Dictionary Capabilities" by ANYSID::BUZZERD (Why NOT Rdb ??) Thu Oct 05 1989 21:53

    I'm looking for generic information about Oracle's data 
    dictionary/repository capabilities. Do they have a separate dictionary
    product, or is it integrated with their database product? Does the
    CASE*DICTIONARY tool function as a dictionary?
    
    Thanks for information,
    Pam Buzzerd
T.RTitleUserPersonal
Name
DateLines
451.1PPP (Probably Pretty Proprietary)MAIL::DUNCANGGerry Duncan @KCOFri Oct 13 1989 12:5017
    I don't believe their dictionary product allows you to use the COPY
    function in a 3GL program.  For example I don't believe you can use the
    COPY FROM DICTIONARY function in a COBOL program.  Nor do I believe it
    does binding such as CDD+ where you can query the dictionary to find
    out what programs are compiled against a field or record.
    
    I am quite certain that it does not handle RMS files.  My point
    to a recent customer is that you don't walk into work some morning
    and "poof" suddenly find all your data structures in Oracle.  The
    migration from flat to relational takes planning and discipline
    and our CDD+ can provide and augment both.
    
    In summary, I would expect their dictionary to provide a decent
    level on integration IF the customer only uses their products. 
    Beyond that, all bets are off.  
    
    -- gerry 
451.2More info on CASE*DictionaryANYSID::BUZZERDWhy NOT Rdb ??Wed Oct 18 1989 17:1912
    Re: my note .0. Yesterday I attended one of Oracle's seminars on their
    CASE tools, including CASE*Method, CASE*Dictionary, and CASE*Designer.
    I have to say they SOUND good, but since they are all new
    releases, they are basic offerings, and would have to be well
    managed in a true development environment to keep people from stepping
    on each other's designs. No versioning support yet, for example. 
    
    Specifically in reference to the CASE*Dictionary product, it is NOT
    related in any way to their database dictionary. When designing
    applications against an existing database, updates to the metadata must
    be made in both dictionaries. However, there is a utility to download 
    from the database dictionary to the CASE*Dictionary, according to the rep.