There are many tradoffs when designing solutions around the data in an organization. Anything is possible, but what is normally feasible, requires good analysis and careful implementation to get the business […]

For Target I would ask who will be the consumer of this information. The could be the corporate office, regional managers, store manager and other individuals at the store. However outside producer companies may […]

TUID and AccessNet user name are both unique identifiers that “can” be used as primary keys. However Accessnet usernames allow for alphanumeric characters which is normally a terrible idea for primary keys. When a computer is trying to match strings instead of numbers performance suffers. TUID is a numeric value which should always be unique [...]

I think in the most general case … both of these could result in incorrect information and knowledge created. For some reason the stat concept of type I and type II errors seems to come in here. I guess like in stat, both need to be considered and accounted for in any calculation with the [...]

For a long time the product I work on had problems keeping different modules synchronized. One team would come up with a new framework but it would be spotty if it was adopted by other teams. Senior Developers at my organization decided to form what we now call the ARB (Architecture Review Board). This ARB [...]

My job involves helping pharmaceutical companies submit required paperwork and information to regulatory agencies in order to get drugs approved for sale in countries around the world. Data integrity is very important to our customers as one omission or wrong entry could set a release back months at great cost. As a software developer, I [...]