What is the defining attribute for an entity?

My question is whether one of the defining attributes could be null?

We can identify a Quote with 'Base Asset + Trade on Market + Quotation Currency + Trade on Sub Market'. When Trade on Sub Market is nullable, whether Trade on Sub Market can be a defining attribute? 


Quote from the principal as below.

Statement:

AnInformation object must not be created nor registered without a set ofattribute values which can be used to uniquely differentiate its existence. 

 

Rationale:

Where there are multiple sources or there is a reliance on 3rdparty content for an information object type, there must be the ability toconcord them and to highlight and reconcile inconsistencies. This will preventcreation of duplicate instances by the Authority.

 

Implications:

Two approaches are recognised in the Content Marketplace:

 

1.      Defining attributes - A set of attributes are selected and used to the same effect as a compositeprimary key. No two registered instances of an object type can have the sameset of defining attribute values. All registered instances are therefore knownto be different.

 

2.      Uniqueness attributes - A set of attributes are selected to be used as the basis forselecting instances (by search or matching algorithm for example). Not allattributes need be present or used, although the more used, the more unique theselection will be. Selection results will comprise a set of instances matchingthe uniqueness attributes used: human or AI intervention may be needed to pickthe intended target from the result set. All registered instances are believeddifferent based on that intervention.

 

When registering new objects, in both cases it is the act of allocation of a uniquePermID to the registered instance that confers uniqueness on that instance. Aunique combination of defining attributes leads directly to the need for a new PermID; using uniqueness attributes often requires an intervention to ascertainwhether a new PermID is needed.


From above description, we can see the defining attributes is in fact a combination PK.

the unique attributes is in fact a combination FK.


  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值