What's the best way to store custom objects in relational database?

Posted by user342610 on Stack Overflow See other posts from Stack Overflow or by user342610
Published on 2010-05-16T22:25:36Z Indexed on 2010/05/16 22:30 UTC
Read the original article Hit count: 161

Filed under:

entities

|

custom-object

I have my objects with their properties. Objects could change their structure: properties may be added/removed/changed. Objects could be absolutely dropped. So object's metadata (description, classes, call them like you want :) )could be changed.

The database should store objects schemas and instances of these objects.

What's the best way to organise a relational database structure to store data mentioned above?

Currently I see only two ways:

1) Store objects schemas in a few tables: schema general data,schema properties, possible properties types. Store instances in their tables: instance general data, a few tables - per each type from possible properties types table to store instance properties data. And so on. 2) store objects schemas like in p1 but store instances like XML files in one table: one table for general instance info and one table with instance XML.

please, don't ask why/for what I need this. Just need to store custom objects and DB should work fast :)

© Stack Overflow or respective owner

Related posts about entities

C# PredicateBuilder Entities: The parameter 'f' was not bound in the specified LINQ to Entities quer

as seen on Stack Overflow - Search for 'Stack Overflow'
I needed to build a dynamic filter and I wanted to keep using entities. Because of this reason I wanted to use the PredicateBuilder from albahari. I created the following code: var invoerDatums = PredicateBuilder.True<OnderzoeksVragen>(); var inner = PredicateBuilder.False<OnderzoeksVragen>(); foreach… >>> More
Why can't I reference child entities with part of the parent entities composite key

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to reference some child entities with part of the parents composite key not all of it, why cant I? This happens when I use the following mapping instead of that which is commented. I get the following error Foreign key in table VolatileEventContent must have same number of columns… >>> More
Using NHibernate to select entities based on activity of children entities

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm having a case of the Mondays... I need to select blog posts based on recent activity in the post's comments collection (a Post has a List<Comment> property and likewise, a Comment has a Post property, establishing the relationship. I don't want to show the same post twice, and I only need… >>> More
LiNQ to Entities, Include less

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, If you are making a LinQ to entities expression for ClassA where A has a relation to ClassB like this: var temp = from p in myEntities.ClassA.Include("ClassB") where ... select p; You will get a set of ClassA:s with the reference to ClassB loaded. The thing in my case… >>> More
LINQ To Entities - Items, ItemCategories & Tags

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi There, I have an Entity Model that has Items, which can belong to one or more categories, and which can have one or more tags. I need to write a query that finds all tags for a given ItemCategory, preferably with a single call to the database, as this is going to get called fairly often. I currently… >>> More

Related posts about custom-object

Problem with implementing removeAll for List of custom object

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello everyone, I have a scenario in my code where I need to compare two Lists and remove from the first list, objects which are present in the second list. Akin to how the "removeAll" object works for List. Since my List is created on a custom object, the removeAll method won't work for me. I have… >>> More
Salesforce - Update/Upsert custom object entry

as seen on Stack Overflow - Search for 'Stack Overflow'
UPDATE: It's working as expected just needed to pass the correct Id, DUH!~ I have a custom object in salesforce, kind of like the comments section on a case for example. When you add a new comment it has a date/time stamp for that entry, I wanted to update the previous case comment date/time stamp… >>> More
How to pass EventArgument information from view to view model in WPF?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have ListView control in my application which is binded to the collection of CustomObject List<CustomObject. The CustomObject has seperate view. This ListView has seperate view model. The collection List _customobject is containted in the ListView ViewModel class. My Query: I want to invoke… >>> More
VB.Net Custom Object Master-Detail Data Binding

as seen on Stack Overflow - Search for 'Stack Overflow'
Since beginning to use VB.Net some years ago I have become slowly familiar with using the data binding features of .Net, however I often find my self bewildered by it's behavior and instead of discover the correct way it should work I find some dirty work around to suit my needs and continue on. Needless… >>> More
Constant expression with custom object

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to use an instant of a custom class as a template parameter. class X { public: X() {}; }; template <class Foo, Foo foo> struct Bar { }; const X x; Bar<X, x> foo; The compiler states that x cannot appear in a constant expression. Why that? There is everything given to… >>> More