Re: Generic Database
Date: 2000/07/13
Message-ID: <8kkg1v$5u1$1_at_proxy2.fe.internet.bosch.de>#1/1
Hi Rod,
Rod Moten schrieb in Nachricht <396C7C23.CFB17711_at_cs.colgate.edu>...
>I'm interested in designing a database that contains a single table.
>However each record can represent a different entity. For example, a
>record for representing a bear has the same fields for representing a
>plane. Has anyone wrote any papers about this subject?
a common universal data structure is object-attribute-value triples:
create table knowledgebase
(
object: varchar(80),
attribute: varchar(80),
value: varchar(80)
)
But this design ist very inefficient when implemented in a RDBMS, since it requires one tuple for each attribute. Object-attribute-value triples are a good idea for data stored in RAM only.
Greetings,
Joachim
Received on Thu Jul 13 2000 - 00:00:00 CEST