Re: Need advise for database structure for non linear data.

  Hello,

Am 03.01.11 12:11, schrieb Andre Lopes:
> Hi,
>
> I need advise about a database structure. I need to capture data from the
> web about one specific subject on few specific websites and insert that data
> to a database. I have done this question here before, but I think I have not
> explained very well.
>
> What I mean with non linear data is the following:
>
>      array(
>            'name' =>  'Don',
>            'age'  =>  '31'
>           );
>
>
>      array(
>            'name' =>  'Peter',
>            'age'  =>  '28',
>            'car'  =>  'ford',
>            'km'   =>  '2000'
>           );
>
> In a specific website search I will store only "name" and "age", and in
> other website I will store "name", "age", "car" and "km".
>
> I don't know If I explain weel my problem. My english is not very good.
>
In theory, using a single table having three columns
(array-id,key,value) will suit your needs.
However, providing a simple key/value store is not the idea behind DBMS
like postgres ...
See:
http://en.wikipedia.org/wiki/NoSQL
http://en.wikipedia.org/wiki/Relational_database_management_system

Thomas