Dear ALL, We had application written in perl that create complex data structure for our subscriber (we have move than 4m subscribers).
each subscriber have some conmen fields that are are present in all of them and some other subscriber has missing some.
the data looks like the next:

%subscribers = {
    "user_001" = {
        "name" => "sam",
        "age" => "13",
        "color" =>['red','blue']
        "item"=>{
            "old" =>['PC','pen'],
            "new" =>['tap','car']
        },
    "user_002" = {
        "name" => "ali",
        "age" => "54",
        "color" =>['red','null','green']
        "item"=>{
            "old" =>['phone','TV']
        },
    "user_003" = {
        "name" => "foo",
        "age" => "02",
        "item"=>{
            "old" =>['']
        },
        ....
    }
}

#[our data are more nasty and complex]

[download]

now we try to store these data in DB then do some query in them like get user that have new 'TAPs' in item or there age is larger than 30 years.
what we need to know is:
What is the best method to store the data (as MySQL or Oracle db not option), we need something for semi-structure data.
How to do these queries taken in mind the preformence.

We jast need headline to start our search (and yes we did our homework using Google ^_^).

BR
Hosen

In reply to store/query semi-structure data by Hosen1989

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.