IDEA: DB Sequences as 1st Class citizens

[Paolo F Cantoni]

Database sequences (generators of values for use in database keys) are currently handled as byproducts of the database column being marked as Auto Number in the Database Column Properties dialog.

However, in most RDBMSs, sequences are first class citizens, having an identity in their own right.

Creating a Sequence means just creating another classifier of (new) type Sequence.  This would be a stereotyped class (using EA's current technology).   However, what is needed is the ability to attach such a classifier to the autonumber functionality.  Selecting Auto Number should also enable a drop-down with a list of the currently defined Sequences.

Thoughts?  Votes?
Paolo

[size=0]©2007 Paolo Cantoni, -Semantica-[/size]

[Paolo F Cantoni]

So I created a class and stereotyped it «sequence»...

Lo and behold - at no extra charge - I got a glyph in the right hand top (NE) corner that looks a bit like a lifeline.

Not exactly sure of the relationship between a lifeline and sequence... Ideas anyone?

Just another part of EA's UI (Unique Interface), I guess.

What a (literally) amazing product!  

Paolo
Manage Complexity,
  .   .   Reduce Ambiguity,
  .   .   .   .   Eliminate Inconsistency! ^TM