Paul Kiel's Data Integration Blog
Data integration using Xml / Xslt and anything else...







Thursday, January 17, 2008

the "other" Paul Kiel

I've been getting this question lately, so I thought I would clear it up. There is a blogger covering politics who has the same name. This other Paul Kiel is known for his posts on TalkingPointsMemo and TPMMuckraker. I've known many with the name Paul and a couple with Kiel, but never come across one with both. So just for the record, we are not the same person. ;-)

See 2007 post archives.

Tuesday, January 15, 2008

Code lists, parsers, and passes

I was reading about the Genericode work being done and started to get a bit worried. First, the theory of what they are doing is very good. The problem of how to create flexible, validatable, and extensible code lists has been a perennial problem for schema designers. None of the solutions tried have the feel of a "best practice".

What the Genericode folks are saying is that the code lists need to be handled differently. They need to have a design that will take the validation out of the role of the parser and into a second layer of validation. This second layer would be one in which management of code lists could once and for all have a best practice and meet all requirements (flexibility, validatability, and extensibility).

I have no problem with their identification of the problem nor their solution. The problem I had was wondering how my customers would react to the solution. I've heard consistently that they want the parser to do more and to do it in one pass. In short, put as much of the data structure integrity and validation workload on the parser in one pass. This goes against the trend toward two-stage validation as described by Genericode. I had a similar concern years ago when OAGIS proposed two -stage validation as a way to add additional restrictions onto a schema using the Schematron standard.

So I find myself in the unenviable position of liking the thinking behind these trends that are pulling workload away from the parser in order to solve some perennial problems. However, I hear from clients that they are interested in putting more workload onto the parser and would never go to the effort needed to do second stage validation.

Ultimately of course the clients decide for all of us, no matter if they are clients of an individual consultant or one of a large ERP vendor. I think there will need to be some real training before the marketplace will be ready to decide what is right and what is not. In the meantime, I hear a clear message from clients to make the parser do more work and not less.

See 2007 post archives.

Saturday, January 12, 2008

Is an Account a Party?

When modeling data, do you think an account is the same as a party? Many folks believe it is. If I am playing the role of a Supplier in an OAGIS transaction of a Purchase Order, I'll create an account for each Customer. From the Supplier's perspective, an identifier for the Customer's account may seem like the same as the identifier for the Customer themselves. So they conclude that an account is the same as a party. However I don't think this is the case.

A key question to ask is: can I have more than one account for each Customer? If so, then this will cause you to view the Customer ID and the account ID as different, because the account ID is no longer the only unique identifier with respect to the Customer.

An account reflects a relationship between a Customer and a Supplier. The Customer can have many relationships in the form of many accounts. So the concepts are separate.

Conclusion: an account is not a party, but reflects a relationship between parties.

See 2007 post archives.

2007 archive posts

Here is link to the 2007 posts. The URLs remain the same.

See 2007 post archives.

Friday, January 11, 2008

New year, new blog software

In 2007, I used Radio Userland software to manage the blog. I really liked it. I could author offline or on a plane and then post when I wanted to. But when I got a new laptop, and Windows Vista, I was unable to migrate the software. The support was not in the offing, so I've moved to Blogger. Now many folks consider this to be a "cheapie" or newbie blog solution. Well, it may seem cheap, but I found it to be pretty usable. And my blog is simple, so I don't need advanced solutions. I've tried others including WordPress and Windows Live Writer. They were all good, but simplicity is a virtue with me and I didn't need much. So for now, its Blogger.
Hope you have a great and prosperous new year!

See 2007 post archives.

© Copyright Paul Kiel.

Archives:
January 2008 February 2008
2007