I think this blog post is going to be more relevant as NoSQL databases catch on where data is packed in columns. The topic is how to create a multi-valued attribute -- a comma-separated list of values -- from a bunch of rows.
Saturday, March 30, 2013
Monday, March 25, 2013
A reader asked how to extract the bond type "CD" from the following input string: "CD Corporation du 20/12/2010 4.5% à 26 semaines". Although it's easy to grab the first two characters in a tMap using a substring function, there is an off-the-shelf component tExtractRegexFields that can handle varying lengths.
Wednesday, March 20, 2013
SysML 1.3 defines 4 types of properties that can be used by blocks: part, value, reference, and constraints. Ports are handled as a special case. This post demonstrates how part and reference properties are represented in Sparx Systems EA 10.
Sunday, March 17, 2013
Thanks to some great contributions from Stephan Roth, I've revised the SysML BDD and IBD I posted in two previous posts. All diagrams were created using Sparx Systems EA 10. The new BDD version uses aggregation and EA role names are used to ease the transition into the IBD. The IBD features reference properties (because of the aggregation).