Mike’s Rule: Know Thy Data


September 30, 2009 by Mike Hillwig

At my former employer, I was hired to do database application support. I spent my first two weeks working with Debbie, our trainer and business analyst. I learned all about our project management system and met the key players.  In retrospect, that was one one of the best things I’ve done in my career. It gave me an appreciation for the business.

Technology people have a tendency to focus on the technology that runs business and ignoring the business. That’s a huge mistake. As I said in a previous post, if you don’t understand the business behind the data, the data is meaningless. In that position, it was especially true. Construction financials are incredibly complex. It’s not just debits and credits. It’s left-side and right-side accounting. I was there four years and the concepts are still a bit blurry to me. Imagine writing a trigger, stored procedure or report against the COR table when you don’t even know what a COR is. (For those unfamiliar with construction, it’s a change order request.)

I’ve seen situations where an IT department will get a request from the business user and just farm out that request to a business partner to develop the situation. The business user knew they needed certain data elements but didn’t know where the data lived in the database. And the business user shouldn’t know, but the IT contact should. This led to countless back-and-forth questions. The time and budget overruns were embarrassing. The next request was mine, and I literally laid out every field, formula, constraint, and specification. The vendor was able to turn that around incredibly quickly with minimal review because they knew exactly what was expected. That was the result of rock-solid specifications by someone who knew the system and how it was being used.

Call me crazy, but I think that as a DBA, we should at least have a slight understanding of the data in our databases.

  • slmnemitunam begam cheghad kaohhslam az ashnai ba adame ghavi mesle shoma,man kheili etefaghi ba webloge shoma ashna shodam ,man alan daram miram sare kar ajale daram ama bayad begam physiotherap hastam va dastane zendegie shama mano motaser kard mesle hameye marizaye digei ke mesle shoma didam va hanuzam baram adi nemishe va shadidan mano motasermikone,faghat mikhastam ye chiziz begam man alave bar inke ye physiotherapam kare faradarmani ham anjam midam ke baram maghdur nis inja tozih bedam mitunam batun tamas begirsm age mayel bashin ya man shomaramo midam shoma tamas begirin harjur shoma rahat bashin,be omide ruzhaye rosha baraye shoma aydaye aziz.______________________________________________آیدا :سلام سمیه ی عزیزم، فیزیوتراپ خوب و گرامیخیلی از آشنایی تون خوشحالم. ممنونم از همه ی لطفتونمن فرادرمانی بسیار کار کردم و نتیجه ای نگرفتم و ترجیه میدم که دوباره امتحانش نکنم.ممنون از لطف و توجه و پیشنهاد کمکتون

  • jackelinePosted on carak filme da hra esse naum sei porq vcs naum consegiram axaibr esse filme axo q falta de sorte mexmo kkkkk pois eu baixei alem da imagem perfeita,o audio ta massaaaa TUDO DE BOM ESSE FILME!!! BJS P VCS.

  • Being forced into marriage is the equivalent of rape.Being forced to marry a cousin is the equivalent of incestuous rape.There are good reasons why such things are taboo in any civilized part of the world.

  • Onna, kiitos hienoista esimerkeistä! Juuri tuollaisen tapaisia juttuja vilisi itsellänikin lukiessa mielessä – Vuonna 1984 ei ole ikävä kyllä ollenkaan vanhentunut teos. Hienoa, että viitsit miettiä ihan esimerkkejä esim. nykykielen outouksista. Ne ovat usein jopa pelottavia, kun oikein alkaa ajatella, mikä valta kielellä on.