How do you create an extensible data model?

Question

I am going to create an e-commerce application with an extensible data model using NHibernate and Fluent NHibernate. Having an extensible data model, I have the opportunity to define a Product object and allow the user in the application to expand it with new fields / properties with different data types, including user data types.

Example: A product may have fields to add, such as: Size - int Color - string Price - decimal Collection ColoredImage - name, image (for example, "Red", red.jpg (binary file))

An additional requirement is the ability to filter products with these additional / advanced fields. How to implement this?

Thanks in advance.

Answer 1

I think this link describes what you want ...

http://ayende.com/Blog/archive/2009/04/11/nhibernate-mapping-ltdynamic-componentgt.aspx

Additional information about the dynamic component:

http://www.mattfreeman.co.uk/2009/01/nhibernate-mapping-with-dynamic-component/ http://bartreyserhove.blogspot.com/2008/02/dynamic-domain-mode-using-nhibernate. html

, , . , . , , , , . , , , ( ).

, , ​​, "attributes", , IN.

Answer 2

- EAV (Entity-Attribute-Value).

, , ( , )

, (sympthoms).

Entity (Id) (, Product) (Id, ColumnName) (EntityId, AttributeId, )

.

, , . : ShortStringValue (EntityId, AttributeId, nvarchar (50)); LongStringValue (EntityId, AttributeId, nvarchar (2048)); MemoValue (EntityId, AttributeId, nvarchar (max)); IntValue (EntityId, AttributeId, int);

: ColorComponentsValue (EntityId, AttributeId, R int, G int, B int);

, EAV . EAV , Product. , EAV.

, . , , . .

, : , , , - , . , .

EAV 20 4 , .

Answer 3

XML XPath/XQuery . XML, ExtendedData, .

Answer 4

- , .

NOSQL (couchDB, mongoDB, cassandre...) propretyfield, , .

Answer 5

N2 CMS (http://n2cms.com), . , . , , , HQL, , , QueryOver/Linq, . ContentItem, DetailCollection, ContentDetail, QueryBuilder/DetailCriteria.