XML storage in 8i - HELP!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: XML storage in 8i - HELP!

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Management have asked me for opinions on a proposed solution they're looking at. We currently runs applications built in VB using 8i.
    We are tendering for a new system and the cheapest bid so far is for a confusing XML based application that - get this! - stores the data in flat text files as XML. I presume they mean as text documents/files full of XML tags - like an HTML source code file. (!!!).
    As XML is hierarchical in form it can be handled by 8i's object type storage facilities? Correct?
    Has anyone used, or know of, a successful application using 8i that stores 'normal' and XML data? Any ideas or opinions?

    How can I best scare management away from the idea of storing the data in flat text XML format - and not in a relational database (8i)? It's a very cheap bid and if they get sold on the idea then guess who's going to have to make it work?

    Help!

    _________________________

    John

  2. #2
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Cool

    Hi!
    Tell them about the security features in Oracle. Tell them all the good things about an RDBMS. Tel them about the benefits of storing everthing in a centralised space. Tell them about online data retrieval requiremnts and any adhoc changes with a database can only handle.
    There Nothing You cannot Do, The problem is HOW.

  3. #3
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    If management still wants to go ahead with the cheap solution,

    You could propose iFS to store the files instead of a regular file system.

    Regards
    Gert


  4. #4
    Join Date
    Mar 2001
    Posts
    314
    You can store XML docs in CLOB datatypes.
    Processing thru JDBC/PLSQL is available.

    -amar

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width