All Access Pass

Several weeks ago there was some back and forward between data management (DM) types on Twitter about a vendor who was using Microsoft Access as a back-end database for a demo of their software product. The question was whether to take the vendor serious if they are using Access. For any number of reasons I won't discuss here, most IT professionals don't consider Access on par with "real" database management systems. Without wading into that discussion, educators preparing students for DM roles should be aware of the perception and select the appropriate tools for the class.

• But wait, there's more. Access is a database management system (dbms), but it is also an application development environment and an ad hoc reporting tool. If you are teaching Access as a software application then you should be giving your students a complete overview of all the capabilities. If, however, it is your intention to teach database design, SQL, etc you had better not have a lesson plan on the Forms builder tool. A DM professional will immediately discount a database class that spends a week making and formatting pie charts in Access. They will also discount the students in that class.
  
• Talk the talk. At it's core, Access is an end-user dbms geared toward non-professionals. As a result, you will come across "end-user friendly" terms for things that have industry accepted names. Don't use the friendly terms and don't let your students use them either. Not knowing the right terminology just confuses the conversation and lowers the student's credibility.
  
• Walk the walk. As with terminology, an end-user dbms will deploy tools that make some tasks easier by either hiding or eliminating complexity. Do your students a big favor and make them get their hands dirty with the complexity. Take the example of creating a table. Access offers a nice interface to quickly type names and select data types (it's in SQL Server too), but I would suggest the students review the equivalent data definition language (DDL) and it wouldn't hurt them to code the DDL from scratch. Same goes for creating queries. It's a real a joy to do a seven table join in a graphical, drag-and-drop tool, but the student is much better off learning to write the SQL now and moving to the graphical tool later.
  

Which brings us back to the perception issue. For an introductory course or for students who aren't specializing in data, Access is an acceptable starting point. For those students who want to focus on data, however, you would be doing them a great disservice by limiting their experience to Access. You should put a significant portion of their work on SQL Server, Oracle, MySQL or any of a number of enterprise-class dbms tools.

Now if you are having some issues creating and managing that type of environment at your school I'd suggest a conversation with the folks at your nearest DAMA chapter.

Tags: Database Access DAMA IT Education

Of pirates and mentoring

Sometime ago Brian Lockwood, educator and IT director at an international school in Yokohama Japan, tweeted a link to an absolutely fantastic TED Talk video from Dave Eggers called Once Upon a School.

Dave created 826 Valencia, a combination publishing house, tutoring center and pirate supply shop (it's hard to explain - you kinda gotta watch the video). The program pairs volunteering writers with the students, providing them support and important 1-on-1 attention. 826 Valencia was spawned other similar organization throughout the county that work on the same model, crazy retail outlet in front, tutoring in back. This includes 826 Seattle and the Greenwood Space Travel Supply company.



Truth be told, I am a complete sucker for stories of the small contributions, the selfless little acts that are soon forgotten by all except the contributor and the recipient. The video highlights the huge difference that hundreds of little differences can make for a team, community, city, state or nation.

So what have you done lately? Dave Eggers closed his presentation with a hope that many more of us would volunteer and share that experience. To that end the Once Upon a School web site was created. You can read the stories of others, share your own or look for volunteer opportunities in your area. Check it out.

Technorati Tags: TED, Dave Eggers, 826 Valencia, Once Upon a School

The Data Model of Dorian Gray

Mrs. AdvisoryBored and I spent the week at the Enterprise Data World conference talking data with friends both new and old. It is a joy to get together with others who want to discuss metadata, data quality, data governance and Twitter names beginning with the word data. Yes, the last one did occur in the wee hours of the morning and yes, it is possible that some consumption of alcohol was involved. Did I mention that it was a data management conference?

A more serious topic of discussion was the concern that data management has become a profession (job, role or set of activities) of older people. I tried to point out that young people such as myself were entering the profession. They were quick to point out that 50 didn't count as young. Who knew!

While I share that concern, I think that there are aspects of the profession that will always skew the age of practitioners toward the "experienced" end of the scale. That would include a focus on:

• data, not on the computers and applications
  
• an enterprise view of the organization, not an operational view
  
• semantics, categorizations, meanings and definitions
• specialized jobs (traditionally found only in larger organizations and consulting firms)
• planning and coordination
  

I lost you at semantics didn't I?

Look, experience need not be synonymous with age, so if we want to bring younger practitioners into the field then we have got to do a few things different.

First we must teach the core competencies that serve as the foundation for data management training later. It parallels the effort to teach computational thinking skills like numbering systems or sorting algorithms without using computers at a young age so they are prepared to learn computer programming later, if they wish. These competencies - things like classification, abstract thinking, information literacy, computer literacy and set theory - ensures students are prepared to learn data management at a more appropriate time. Wax on, Wax off.

Second we must build awareness of data management as an area of study, as a set of skills and as a profession. Most of you are probably thinking database administration when I speak of data management. Fair enough, database administration is certainly part of data management, but so are data modeling, data warehousing, data security and any number of other jobs or roles. Our biggest challenge in this area, as Karen pointed out on numerous occasions at the conference, is to be visible to younger professionals by participating in the communication channels they use. This means we need to be talking data management in blogs (or this one), on Twitter, on LinkedIn, in discussion forums and on wikis.

Finally we must develop, or at least help to develop, curriculum to support the needs of new entrants into the field as well as the ongoing professional development of those who have already chosen data management as a career path. DAMA International made a huge leap in this area last week with the release of The DAMA Guide to the Data Management Body of Knowledge (DM-BOK). The challenge now is for data management professionals to carry this information to local colleges and universities. Additionally, we need to push beyond the basic database training to teach a broader range of data management activities. As Peter pointed out on several occasions, we teach students how to build new databases, but how often do we really do that in our professional lives.

Let me leave you with one final thought. Data management is both a set of activities and a profession. Many people who do the former don't consider themselves the latter. They are, nevertheless, contributing to the body of knowledge, for better or worse, and we need to connect with them just as much as an up-and-coming metadata analyst. Consider the outcomes that Mrs. AdvisoryBored identified in her original proposal for the Business Information Management class (MGMT 215) at Edmonds Community College (see the end of page two). There is no guarantee that the students, particularly those from the Business department, will embrace those data management principles and/or the profession, but she has at least had the opportunity to introduce the concept of data as a managed enterprise resource.

Tags: Enterprise Data World, DAMA, DM-BOK, Data Management

A little piece of americana

Our friend Tim holds concerts of local and visiting musicians in his home 4 times a year. The musicians usually play the didgeridoo, but occasionally they play other instruments associated with the aboriginal people of this continent. A couple of weeks ago we had the opportunity to see Tyler Spencer playing with Shireen Amini like they did in this video from the 2008 Seattle World Rhythm festival.

Shireen played a song that was inspired by watching her cousins as they were updating their social networking pages, text messaging and watching MTV all at the same time. She remarked at being both fascinated and horrified. They were consuming snippets of culture instead of participating in a sustained creative process. They lacked an outlet to guide and encourage inherent creativity.

Shireen highlighted a program called the Americana Project at the Sisters (OR) School District. Students learn to play, write, perform and record. To date, they have released 7 CDs of music created, performed and engineered by the students. I have to think that programs like the Americana Project encourage the passion for creativity while keeping students engaged in school.

In the book "First Break All the Rules" the authors tell us that the best managers don't focus on overcoming an employee's weaknesses, but instead maximizing their strengths and talents. We also learn that the best organizations have staff that consistently answers the question "Do I have an opportunity to do what I do best everyday" in the affirmative.

If it works for creating excellence in the workplace, why not the education setting? As we work to address a 30% high school drop out rate, we might want to ask ourselves if these types of programs will help students to get engaged and stay engaged in school? We might still further ask ourselves if we can expand these types of programs beyond just music or athletics? Other specialized programs, like those at the Sno-Isle Tech Skills Center, are seen as a place to go if you're not good at school (it's not true, but is the perspective of some). Why? Why is the desired to be a great gymnast or saxophonist a good thing and a great welder a bad thing? Some one's got to be the Wynton Marsalis of welding, why not your kid?

Tags: Americana Project, Tyler Spencer, Shireen Amini, Sno-Isle Tech Skills Center,

Olympia Talks College Education

Q13 News reported yesterday that three bills to establish a university in Snohomish county, plus a bill to grant bachelor degrees at Bellevue Community College (BCC), were being discussed in front of the State Senate Higher Education and Workforce committee. As reported, the challenge is not merely sorting out the competing bills, but to face the reality of the budget cuts when considering the cost of construction.



For you interested in the details of those hearings, you can view the committee sessions at TVW and the Senator Hobbs video at YouTube. Further details are available here, here and here. In particular, the second of those three articles seems the most damning. It is clear to me that the supporters of the the competing locations care nothing of education, demonstrating a greed for local construction spending that negates any attempt to appear pro-education. Both sides deserve to get nothing.

But I've ranted on that enough, haven't I? The BCC bill is more interesting as it offers a new model for expanding post-secondary education. Other lower/upper division models exist, including Lake Washington Technical College's Applied Bachelor's in Design and CWU BAS-ITAM. (See background on the proposals and the conflict with the UW here, here and here.) The proposed model for BCC isn't without it's concerns. Community colleges serve a huge range of educational needs. The Eastside won't benefit if BCC promotes the 4-year degree at the expense of their Adult ed, Prof/Tech and worker retraining roles.

Tags: Education, UW North Sound, Bellevue Community College, Lake Washington Technical College, Applied Bachelor's Degree, Central Washington University