Systema: Six Interrogatives and Four Associations

enterpriseassociations2

Since I have been thinking about the dimensionality of Einstein’s universe and the associations within the six interrogatives, it has led me to wonder about how the two fit together.  I have expressed it in the above diagram.  The association types are the rows and the interrogatives the columns.  We immediately have four dimensions for each interrogative.  Food for thought as I think about my current reading on network theory.

This hearkens back to a model I did in June 2007:

enterprisehybrid

You can see by using an association table for each interrogative this model provides for all the possible associations within the ontology.  However, I do not think this model is complete.  I’ll discuss that a bit later.

Icons: SQL DDL and DML

I’ve been playing around with some icon ideas for SQL Data Definition Language (DDL) and SQL Data Manipulation Language (DML) for some time. Perhaps they will give you some ideas.

First are the Basic DML Commands:

Now let’s apply them to Tables:

Tables need Primary Keys:

They may also need Unique Indexes:

We may have to play with the Columns:

Then we should have Views:

And in special cases Triggers:

We should also define Users:

Now we have all the DDL.

Let’s look at the DML:

Having manipulated our data we should either Commit or Rollback:

And that is about how far I’ve come.