You are here:  Home  >  Data Education  >  Big Data News, Articles, & Education  >  Big Data Blogs  >  Current Article

11 Things I Should Have Done in 2011

By   /  January 4, 2012  /  4 Comments

by Karen Lopez

Rather than write about my accomplishments over the last year, I’m going to write about all the things I should have been working on, but didn’t. I have lots of excuses: not enough hours, not enough days or too many other things to take care of.

These are the types of things that Stephen Covey wrote about in First Things First under the theme of “Big Rocks.”  Basically, if I’d spent just a few minutes every day adding these to my schedule, I would have accomplished more.

If I had just added them to my life, I’d be in a much better position sitting here at the end of 2011. I might even be richer, taller and thinner. Maybe even smarter.

1. Read more about Data

I had all these great intentions to read more about Big Data, Data Quality, Data Modeling, Data Visualizations, Data Science…well, you get the idea. I have a pile of such books next to my desk and filling my iPad. I also have subscriptions to digital libraries to many of them, too. So it wasn’t a lack of access that stopped me.

I also should have been more caught up on reading my RSS feeds of other data bloggers. What’s that you say? There aren’t really that many data bloggers? I agree. Why aren’t you blogging so that I can get better at catching up on reading your thoughts about data, life and the world?

2. Learned more French and Hindi

I have lots of resources right at my fingertips for learning French and not because I live in Canada. Here in Toronto French is way down the list of languages spoken by the general population. In fact, it’s 11th on the list after English, other European and several Asian languages.

Since almost all of the projects I’ve worked on in the last few years involved offshore teams, I’ve also been studying Hindi — not because I have to, but because it has been helpful. Did you know that Hindi uses the same word, kal, for yesterday and tomorrow? That explains a lot about some status updates that didn’t really pan out. I recommend you work this concept into your next status meeting.

I’d also like to learn some Mandarin. I’ve read in several places that if one learns Hindi and Mandarin (and sometimes French and Hindi), one can speak with half the world’s population.

Learning about languages helps me in internationalizing data designs. I know now that there are places in the world where people don’t have middle names, half the population has the same last name or where people only have one name. That’s just the tip of the iceberg. Studying other languages and cultures makes my data models better.  While we are on this topic, stop making Postal Code all numeric in your designs.  The rest of the world will thank you.

I should have worked on a Mayan language, given that they are going to bring about the end of the world in late 2012.

3. Run more

Portland Marathon #SQLRunI’ve been an on-and-off runner since embarrassing my middle school track team as an 880 distance runner. Mostly off, I’d say. But a few years ago I decided that I was old enough to not care about how fast I ran and signed up for a few races. This year I ran my second and third half marathons. One of them was with a group of other data professionals, even. My goals for both of them were to just finish upright and smiling. I did, in both races. But I want to start having some time goals and that means training differently. It also means running more and cross training more.  Just like with IT training, I have to train for speed differently than training for completion.

Running has been a good stress-reliever and I certain know that the life of an architect in the fast-paced, agile/SCRUM/anything goes world of what they call system development methods these days leads to a lot of stress. Running is also one of those things that I can do anywhere, even while traveling. I just need a way to fit those giant running shoes in my carry-on bag and I’m set.

I love the gadgets I use when I run: my Garmin GPS watch, my Runmeter app that reads Tweets people are sending me while I run and my fitbit that collects and stores data bout how many steps I took in a day, how far I traveled and how many calories I burned. This helps me measure and monitor my progress and predict future performance. Larry English and his stopwatch would be proud, I hope.

4. Develop a Million Dollar App

It seems that everyone is doing this these days. Even teenagers. If I could just find a way to build an app that ties together data and space together in a way that everyone would want to hand over their hard-earned cash for, then I’d be set. Or I could just write one that lets cats play a game on my iPad. One of those would work and I’m afraid it’s only the cat one.

5. Read the Scriptures

I could probably do with reading all kinds of good books, but here I mean the writings of Codd, Chen, Date and Zachman. I’ve read all these in the past, but I think I may have read too much vendor documentation between then and now. Terminology has been twisted and refactored so much in practice that it pays to go back and read the original theory from time to time. Hear that Microsoft with your “Entity Framework” and Access “database”?

Most of these good works are available at the ACM Library and at Amazon. It’s a much better value to join ACM and sign up for the library subscription that it is to buy them one off at an online bookstore. Also, check out access via corporate subscription services, too.

6. Perfect cloning techniques

Even though I attended many events in 2011 (Enterprise Data World, SQLSaturdays, SQLRally, DAMA Days, PASS Summit, NIEM National Training Event and more), I still missed many of the key data-related conferences like the Semantic Technologies conference that would have exposed me to emerging technologies and best practices. If I could just clone myself I could have been a the many overlapping events that happened in 2011. I think that might have allowed me to complete more of the other items on the list.

7. Install more DBMSs and Technologies

I should have taken the time to play with research the newest versions of SQL Server, DB2, Oracle, MySQL, Postgress, Hadoop, MongoDB, SQL Server Azure and ….well all the 10 million other databases/non-databases out there. Sure, I can’t know them all, but getting hands-on with new tools and features is the best way to understand the Next Big Thing we’ll have to design for. That’s hands-on, working with real, non-trivial problem sets. These technologies are coming to a project near you soon, if they haven’t already. You don’t won’t to be the only one in the room, especially as the data professional, saying “Hadoop? Is that a character from Dr. Seus?”

8. Stalked Astronauts Bought Real Estate in Cocoa Beach

@Astro_Luca, @datachick and @VenusBarbieI actually did do some astronaut stalking this past year. I spent a lot of time in Cocoa Beach, Florida this year, not to mention Cologne, Germany. All these visits were about watching launches of humans and rockets into space…and meeting smart people collecting and using data from beyond Earth’s boundaries.  I think over the year I was fortunate enough to meet more than 25 former and active astronauts, not to mention key members of NASA, CSA, and ESA teams. I even attended, virtually, the NASA IT conference.

Did you know that data.nasa.gov offers more than 1200 data sets for you to use? One of my favorites it the Great Images in NASA (GRIN) data set. Perfect for playing with those new database features in item 5 above.

We are still sending people into space, just not from Florida right now.  Heck, NASA sent 3 more astronauts to the International Space Station just last week.  So while the space coast real estate market is good for buyers right now, there are still unmanned missions launching from there in 2012.  All for collecting massive amounts of data about our world.

 9. Interacted with machines more often, so they know me better when they take over

Sure, I’m known for my love of gadgets. One of my favorites is my Xbox with Kinect. I primarily use it for sports and exercise . And yes, it collects and stores data about my workouts and play.  What I’m most excited about Kinect, though, is the expansion of its controller-less interfaces to other applications.

Imagine zooming in or out or double-clicking to drill down into the metadata of a table without having to use anything but your own hands in front of a projected display of your model. Or laying out your data model by just standing in front of your model and moving the entities with your hands. That’s what I want. When we later find out that Kinect forms a union at Cyberdyne Systems and becomes Skynet, I’ll be ready.

10. Loved My Data More

I think I did a decent job loving the data I was supposed to, but I could have done more. I could have tested more restores of databases (because you don’t really need backups; what you need are restores). I could have done more data profiling to see what data was lurking inside those columns with a name like description or notes. I could have tested my designs more, to ensure that they performed as well as I thought they would and that they could store the data they should have.

11. Kicked my procrastination habit

I’m going to start on this one next. I promise.

Love Your Data

What do all these things have in common? DATA.

Let’s make sure that when we are together again, at the end of 2012 (assuming the Mayans were wrong) that we don’t have a similar long list of regrets. Love Your Data.



About the author

Karen Lopez is Sr. Project Manager and Architect at InfoAdvisors. She has 20+ years of experience in project and data management on large, multi-project programs. Karen specializes in the practical application of data management principles. She is a frequent speaker, blogger and panelist on data quality, data governance, logical and physical modeling, data compliance, development methodologies and social issues in computing. Karen is an active user on social media and has been named one of the top 3 technology influencers by IBM Canada and one of the top 17 women in information management by Information Management Magazine. She is a Microsoft SQL Server MVP, specializing in data modeling and database design. She’s an advisor to the DAMA, International Board and a member of the Advisory Board of Zachman, International. She’s known for her slightly irreverent yet constructive opinions and rants on information technology topics. She wants you to love your data. Karen is also moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com and dm-discuss on Yahoo Groups. Follow Karen on Twitter (@datachick).

  • Mike D

    I’ll be lazy and without creating my own list I will say 1,3 and 4 (especially #3). I injured myself last spring and never got back into the running habit. I started this year off by running a 5K on New Year’s day.

    • I love running on New Year’s Day. Seems to set a good trend for the year. And yet, I haven’t run as much as I should have. I think I need to book a race so that I’ll get out there.

      And I’m betting that if I book some other kind of event, I’ll get to reading those books, too. Funny how having a hard and fast end date makes things happen.

  • Ok here we go:

    1. Write an android app.
    I need to get over my irrelevant hatred of Java an use it.

    2. Write an ASP.NET MCV3 app.
    Nothing stopping me here other than motivation and an app to write.

    3. Read the wealth of nations, and The Theory of Moral Sentiments.
    Adam Smith is a very dry read, but as a die hard capitalists, I should read the first formally observation of the system, and the prequel of it. I’ve gotten at least 100 pages into the wealth of nations on at least two occasions.

    I did read P. J. O’Rourke humorous Cliff Notes take on the book http://www.amazon.com/Wealth-Nations-Books-Changed-World/dp/0871139499. I highly recommend that unless you absolutely can’t stand P.J.

    4. Provide a patch for Mongo SERVER-1227
    I love screwing around in C, and I love figuring out obscure win32 API calls. However, its a tedious process.

    5. Achieve my Competent Communicator badge at Mile Square toastmasters
    This is actually a work goal too. I’ve done two of the ten speeches. I’m having a bit of writers block at the moment. I find it hard to come up with 7 minutes of material that isn’t about programming. One thing I was very good at was memorizing my first two speeches completely. I present at toastmasters with zero notes.

    6. Become a slum lord

    I get laughed at a lot for this, but I want to own rental properties. I don’t want to do HUD housing, I want private tenants. I know its going to cause more stress and give me less money then many other endeavors, but its my dream.

    I’ve not done anything as far as saving specifically for this and producing a business plan that the other shareholders (my wife) would accept.

    7. Bought a 78 firebird or a mid 80s Mercedes 5 cylinder D class

    Those are my two dream cars. The bandit, and a low end small diesel sedan.

    8. Learn to touch type
    Ok I can actually type without looking at a keyboard, I just don’t use proper positioning or my pinkies.

    9. Max out my 401k.

    I cam pretty close though, and that was partially due to my 401k not kicking in at my job until 2 paychecks after they said it would.

    10. Learn Latin

    So, this is a weird one. Yes I am Catholic, and I have gone out of my way to attend mass in Latin on two occasions (once Novo Ordo in Philly and once old Tridentine Mass). However, I’m completely ok with reading along to Latin on the left, English on the right when I do that. My inspiration for learning Latin is from P.J. O’Rourkes Cliff notes on “The Wealth of Nation.” Due to some offhand remarks he makes in in I realized that it was common in the late 1800’s for Professors to lecture in Latin, even in the solidly Protestant United Kingdom. I realized that having a dead language the lingua franca of higher education just seems fairer than English, and would force anyone whose parents want their kids to go to college to be bi-lingual.

    So that’s never going actually happen. However, I believe in being the change I want to see in the world, so I should start with myself. Also, maybe Ulysses would not be as boring to read in its original language.

You might also like...

Webinar: How to Consume Your Data for AI

Read More →