This doesn't address your issue, but it's a side note I thought I would toss in. About a year ago, I worked on a project for a company using a multi-value database. The multi-value industry (Pick, UniVerse, UniData) offers relational databases that violate the first normal form1 and have built-in mechanisms for dealing with it.

Since these databases are not very popular, there was no support for it on CPAN. After posting to a couple of newsgroups, my boss found a guy who had used Perl to write a UniData driver that was perfect for our needs. Of course, he just gave us the driver. Had we gone to the vendor to get one written in C, we could have spent a few thousand dollars (and needless to say, it didn't use DBI).

I love Perl :)

Cheers,
Ovid

1. The first normal form basically states that you shouldn't have repeated data in one field, you should move it to a separate table. A multi-value database allows you to have a table with one person having 17 phone numbers in one field and handles updating and deleting values and their relationships automatically. Such a database is rather nice as linking tables are far less necessary. Unfortunately, I haven't seen any information on how to design these databases.

Join the Perlmonks Setiathome Group or just click on the the link and check out our stats.

In reply to (Ovid) Re: Non-Relational Database Use from Perl by Ovid
in thread Non-Relational Database Use from Perl by princepawn

Title:
Use:  <p> text here (a paragraph) </p>
and:  <code> code here </code>
to format your post, it's "PerlMonks-approved HTML":


  • Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!
  • Titles consisting of a single word are discouraged, and in most cases are disallowed outright.
  • Read Where should I post X? if you're not absolutely sure you're posting in the right place.
  • Please read these before you post! —
  • Posts may use any of the Perl Monks Approved HTML tags:
    a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr
  • You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)
            For:     Use:
    & &amp;
    < &lt;
    > &gt;
    [ &#91;
    ] &#93;
  • Link using PerlMonks shortcuts! What shortcuts can I use for linking?
  • See Writeup Formatting Tips and other pages linked from there for more info.