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