开发者

Is there a name for this representation of data?

Suppose you have data for which a normalized view would be something like

ID   First Name      Last Name   Height   
--   ----------      ---------   ------
1      Ann             Jones      63
2      John            Smith      72

But the data comes to us in this representation:

ID    Type         Value
--    ----         ----- 
1    'FirstName'   Ann   
1    'LastName'    Jones
1    'Height'      63
2    'FirstNam开发者_开发百科e'   John
2    'LastName'    Smith
2    'Height'      72

It's sort of a normalized table turned sideways, or an "unpivoted" table.

My question is: is there a NAME for this kind of representation -- these 'ID, Type, Value' triples? (In reality the Type is an integer and maps to a type table, but I made it a string to make it clearer what it represented.)


I suppose this could be considered as close to the EAV (Entity-Attribute-Value) Model

Except you only have the two following tables :

  • Entity
  • Value

And no Attribute table.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜