By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
449,002 Members | 1,290 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 449,002 IT Pros & Developers. It's quick & easy.

Dynamic datastructure of objects

P: 1
Hello,

I would like to disccuss with the following issue:
We want to create database in which we can dynamically add attributes.
The problem is, we do not know the datastructure before. The datastructure has to be defined in some metadata structure.

Example:
OBJECT-->ATTRIBUTES

My suggestion:
OBJECT_META.ID<--OBJECT_ATTRS_META.META_ID

OBJECT_META.ID<--OBJECT_DATA.META_ID
OBJECT_DATA.ID<--OBJECT_DATA_ATTRS.DATA_ID
OBJECT_ATTRS_META.META_ID<--OBJECT_DATA_ATTRS.META_ID
If I do it this way then I cannot imagine, how the response time of SQL statements will look like...

The DATA Tables should have more then 50.000.000 records!

Do you have another idea or experince?

Thank you,

LumirB

PS: I hope you can understand my problem...
May 1 '07 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.