On 7 Sep 2012, at 14:50, Sandro Hawke wrote:
>>> Taking a step back, and thinking about what we (Experian) actually use bNodes for, to inform our position on the various scope questions.
>>>
>>> Basically, it's just a replacement for auto_increment columns in SQL.
>>
>> I'd like to take this metaphor a bit further.
>>
>> AUTO_INCREMENT is a MySQL-specific feature. It's a way of getting guaranteed unique identifiers within the scope of a MySQL table.
>>
>> The standard SQL equivalent is the SEQUENCE. It's not bound to a specific table, but needs to be created explicitly:
>>
>> CREATE SEQUENCE customer_seq INCREMENT BY 1 START WITH 1;
>>
>> Then when I want to insert a new row into my customer table, I can grab a â€œfreshâ€