From: | Thomas Schmidt <postgres(at)stephan(dot)homeunix(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Need advise for database structure for non linear data. |
Date: | 2011-01-03 11:26:45 |
Message-ID: | 4D21B275.1060905@stephan.homeunix.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Kellerer | 2011-01-03 11:36:41 | Re: Need advise for database structure for non linear data. |
Previous Message | Andre Lopes | 2011-01-03 11:11:56 | Need advise for database structure for non linear data. |