[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

278.0. "Is Oracle used at the FDA?" by INFACT::DATZMAN (Indianapolis Field Applications Center) Thu Dec 15 1988 22:14

    Has anyone heard of Oracle being used within the Food and Drug
    Administration (FDA)?   Or, RDB for that matter?
    
    My customer is claiming that Oracle is used a lot at the FDA.  Since
    my customer submits data and reports to the FDA for patent applications
    it is important to comply with the FDA. Any ideas?
    
    
    Dick
T.RTitleUserPersonal
Name
DateLines
278.1What are the FDA's requirements?DEBIT::DREYFUSThu Dec 15 1988 23:0926
>    Has anyone heard of Oracle being used within the Food and Drug
>    Administration (FDA)?   Or, RDB for that matter?
 
I don't know.  Does it really matter?
   
>    My customer is claiming that Oracle is used a lot at the FDA.  Since
>    my customer submits data and reports to the FDA for patent applications
>    it is important to comply with the FDA. Any ideas?
    
What does the FDA require for your customer to do business with it?
If the customer needs to transfer data from his/her database to the FDA's,
the database is unimportant.  All data will be transfered as RMS files
over the network (electronic or mag).  You can extract data from Rdb
into RMS without any problems using 3GL or datatrieve.  You may
even want to look into the ILO::INFOMGR notes file for a SWS tool.

Your customer isn't planning to backup and ship his/her whole database
to the FDA and then expect the FDA to use Oracle's distributed capabilities
to look at the data, is he?


We can discuss this further by phone if you are interested.

-- david
dtn 381-2893
    603 881 2893
278.2Would EDI work ?MDVAX1::DUNCANGGerry Duncan @KCOFri Dec 16 1988 00:386
    Another approach would be to encourage your customer to explore
    EDI (ANSI X12) for dialogue and message exchange.  VAX EDI is not
    too far away and there are other EDI products already on the market.
    
    
--gerry
278.3May need to ship the whole thingINFACT::DATZMANIndianapolis Field Applications CenterFri Dec 16 1988 01:1820
    
> Your customer isn't planning to backup and ship his/her whole database
> to the FDA and then expect the FDA to use Oracle's distributed capabilities
> to look at the data, is he?

  It is possible that a whole database could be shipped as part of the
    validation process.  My customer makes drugs and these drug studies
    last years, so when the customer goes to the FDA for approval, the
    data better be accurate, and in a for the the FDA can handle.
    
    I do not know the exact requirements for the FDA, but it probably
    varies for each study.  I will do some more checking.
    
    Dick
We can discuss this further by phone if you are interested.

-- david
dtn 381-2893
    603 881 2893
278.4Yes, the O word is used (sigh), but so is Rdb!CREDIT::KELLEYConfused, I am so....Fri Dec 16 1988 15:2917
    Dick,
    
    Having been the support person for FDA previously, I will tell you
    that unless things have changed in the last 1.5 years, ORACLE is
    the standard database for FDA.  However, there are a few groups
    inside of FDA which use ACMS/Rdb for their applications.  The last
    time I spoke to the folks at FDA, there was considerable fighting
    about the database.
    
    As for your customer submitting reports and data, I do not know
    of any regulation which says the companies must use the same database
    as FDA.  Afterall, that would mean that all companies which submit
    information would have to do that on VAX and either Rdb, Oracle
    or RMS, depending on who it is submitted to.  I guess you can tell
    that I believe this to be a 'bogus' reason for using Oracle.
    
    chuck
278.5Can software system be imposed?CIM::CHENMon Dec 19 1988 14:405
    From the experience I had in my previous job with another company,
    it seems to me that the Government cannot impose a particular software
    system for reporting, at least this is the case with DoD and DoE.
    However, it may specify some reporting formats and procedures which
    may favor some particular software systems.
278.6Oracle ans PharmaceuticalsPHDVAX::LARSONTue Dec 20 1988 16:1318
     I visited Sterling Drug (Eastman Kodak subsidiary) a couple of
    weeks ago and was told that they were deciding to use Oracle because,
    among other reasons, the FDA uses it.
    
     I agree with Chuck in this being a bogus reason.
    
     Another thing I heard from this customer that I wanted to follow
    up on, was that a popular LIMS product from Nelson or Perkin Elmer
    was being (or has been) ported to Oracle. Appraently, this product
    is very popular with Pharmaceuticals. Anyone know if there are plans
    to port to Rdb/VMS or if there are competitive products? This customer
    same DEC's LIMS/SM and was not impressed (just reporting).
    
     We have several drug companies in my region (Eastern Pa.). Is Oracle
    as popular in Pharmaceuticals as it appears from this viewpoint?
    
    Thanks,
    Bill.                                                   
278.7Nelson / Oracle linkKIKETT::NICHOLSON_PABullfrogs on my mindTue Dec 20 1988 22:0524
>         Another thing I heard from this customer that I wanted to follow
>    up on, was that a popular LIMS product from Nelson or Perkin Elmer
>    was being (or has been) ported to Oracle. Appraently, this product
>    is very popular with Pharmaceuticals. Anyone know if there are plans
>    to port to Rdb/VMS or if there are competitive products? This customer
>    same DEC's LIMS/SM and was not impressed (just reporting).

    Nelson Analytical sells a LIMS product based on Oracle (Nelson was
    recently purchased by PE).  The porting to Oracle is fairly recent;
    originally the LIMS was RMS-based.  Before coming to Digital I
    evaluated the RMS-based product and rejected it due to inflexibility,
    among other reasons.  This was probably 2-1/2 years ago.  Based
    at least in part on my input, Nelson delayed shipment of their LIMS
    to layer it on a database ... but chose Oracle rather than Rdb.
    Why?  I never heard.  I suspect that Nelson is NOT eager to port
    to another database at this time, but you might want to check with
    the product manager at Nelson.  Way-back-when, this was Ed Long.
    
    Nelson/PE was recently named a SCMP.  They also sell laboratory
    data collection/analysis software NOT based on Oracle.  These integrate
    with the LIMS referenced above, but could alternatively talk to
    a Rdb database.
    
    Does this help?
278.8Rdb vs Oracle in PharmaceuticalsLDP::TURKELEd Turkel, Lab Info & Office SystemsThu Dec 22 1988 21:0594
    As the person in the Laboratory Data Products pmg responsible for
    moving more Rdb into the process industries, including pharmaceuticals,
    let me see if I can put some perspective on this.
    
    First, Oracle CURRENTLY has the largest market share for strategic
    databases in the pharmaceutical industry.  A recent survey
    (unpublished, and not particularly scientific, but interesting) of the
    10 largest pharmaceutical companies in the U.K. showed 9 using Oracle.
    The 10th having just recently (since Rdb V3.0 announcment) made a
    corporate decision to use Rdb.  It's very important that we understand
    why.  The pharmaceutical industry is very research intensive, and
    research tends to use the latest technology.  Oracle was very
    successful in promoting their relational product to that industry
    before anyone else.  Now that other products, notably Rdb, are becoming
    mature and Oracle is starting to make mistakes, we are becoming more 
    successful at penetrating pharmaceutical accounts that previously
    used only Oracle.
    
    Another effect of Oracle being there first is that there are many
    more applications used in the pharmaceutical industry that have
    hooks to Oracle.  I am working with DBSG to get more research/lab
    applications onto Rdb.  If anyone has an application that might
    be a candidate for this, let me know.

    Second, the FDA does use Oracle.  However, it is very important
    to remember that the FDA cannot, repeat CANNOT, legislate the use
    of a particular product.  What they can do is ask that the software
    that is used be properly validated.  The best example of this is
    the statistics package SAS.  The statistical algorithms used by
    SAS were validated by the FDA before any other stat system.  After
    that, any company submitting a New Drug Application (NDA) to the
    FDA had to either validate the statististical algorithms they used,
    or use SAS.  Needless to say it's easier to just go with the flow,
    so 100% of the drug companies use SAS.  No database has been validated
    in this way, yet.
    
    What the FDA can do, like any federal agency, is require the use
    of a particular standard.  Thus, they could require ANSI SQL
    complience, and then use data manipulation packages that also use
    the standard.
    
    As far as what the FDA requires of a database used in the development
    or manufacturing of a drug, that is defined by the Good Lab Practices
    and/or Good Manufacturing Practices acts (Federal Laws) and the
    interpretation of those acts by the FDA.  Ultimately, these laws
    specify procedures for data management (among other things) to assure
    that data is recorded and reported accurately.  For a database
    management system, there are two critical issues: 
    
    1. Audit Trails - These laws specify that all data must be tagged
    with the I.D. of the person reponsible for creating the data, and
    the date created.  Than any change to that data must not overwrite
    the original, so that both the original and the modification are
    readable, with the changed data 'signed', dated, and flagged with
    a reason for the change.
    
    2. Software Validation - This is a new area for the FDA, and there
    is much disagreement over what it means.  Most of the industry is
    promoting black-box testing software, essentially what DTM provides
    (in fact DTM is being actively promoted for this).
    
    Oracle does no better than Rdb on auditing.  Both packages require
    that the audit trail be built as part of the application.  An
    unidentified future release of Rdb is planned to provide the right
    solution for this problem.  Call me if you want to talk about it.
    Regarding validation, I think we have a lot to talk about relating
    the robustness of Rdb versus Oracle.

    Regarding specific customers, I would like to talk to Bill (note
    .6) and Dick (note .0) about their accounts.  I'm probably talking
    to the account too.
    
    As far as .7 is concerned - we now have an S/CMP relationship with
    PE/Nelson Systems for their Access*LIMS product, which is built
    on the Oracle database, written mostly in their 4gl, SQL*Forms.
    They have a second LIMS product, LIMS-2000VX, that is being ported
    to Oracle from the SEED database.  If you are interested in discussing
    what PE/Nelson is likely to do in the future, or what LDP is doing
    with them, call the relationship manager, Patrick Chassaigne, or
    myself.  Although it is inappropriate to comment on the contents
    of our negotiations with PE/N, or their future plans, in a notes
    file, I'll simply say that it is considered highly strategic LDP
    and Digtial to have a major LIMS on Rdb.  For the record, there are 
    already two from smaller ISVs:
    
    Encompass from Cheasapeake Software (phone: 302-475-5229) and Astral
    and CAST-VAX from Applied Research Labs (phone: 805-295-0019). For more
    info see the Laboratory and Science Handbook (EB 32105 61/88).
    
    Regards,
    Ed Turkel
    Laboratory Applications Marketing, LDP/Science