San Francisco DAMA Newsletter

Data Management Association, Inc.
San Francisco Bay Area Chapter
268 Bush Street, Suite 2523
San Francisco, CA 94104
http://www.sfdama.org


September 2006 Newsletter
[directions] [presentation] [notices] [resource corner] [schedule]
DAMA Board

PRESIDENT
Francois Cartier
eModelers
(650) 588-2470
president@sfdama.org


MEMBERSHIP DIRECTOR
Lynn Johnston
AT&T
(925) 823-9572
membership@sfdama.org


TREASURER
Thomas Gaffney
State Compensation Insurance Fund
(415) 581-4495
treasurer@sfdama.org


PROGRAM DIRECTOR
Mehmet Orun
Genentech
(650) 225-5221
programs@sfdama.org


RESOURCE DIRECTOR
Raj Manickam
Genentech
(650) 225-8321
resources@sfdama.org


COMMUNICATIONS DIRECTOR
Sandra Gogas
AT&T
(925) 823-1273
communications@sfdama.org


DAMA DAY DIRECTOR
Wendy Wood
AT&T
(925) 823-8042
damaday@sfdama.org



SEPTEMBER 2006 MEETING
Wednesday, September 6, 2006 at:

 Kaiser Permanente
 Conference Room 3000
 4460 Hacienda Drive
 Pleasonton, CA, 94588
 
 AGENDA

 8:30 - 9:00
 Continental Breakfast

 9:00 - 9:15
 Welcoming Remarks

 9:15 - 10:15
  Modeling Baseball Cards: A Case Study

 10:15 - 10:30
 Break

 10:30 - 11:45
 Continued Presentation

 11:45 - 12:00
 Questions and Wrap-Up

 12:00 - Lunch
 Restaurant (to be announced at the meeting)


"They are able because they think they are able."
-Virgil
Information Resource Management: Setting Standards for Excellence


DIRECTIONS


Directions To This Month's Meeting:

Kaiser Permanente
Conference Room 3000
4460 Hacienda Drive
Pleasanton, CA 94588

Kaiser Permanente is located off of 580 in Pleasanton within walking distance of the Dublin/Pleasanton BART station.

Driving From the Oakland:
Take I-880 South to I-580 toward Stockton.
Exit south at Hacienda Drive (approximately one mile east of the I-680 interchange).
Turn right on Hacienda Drive and go through one intersection past Owens Dr.
KP will be the first driveway immediately on your right.
Please sign in and pick up a guest badge at the security desk

Driving From the San Jose:
Take 101 South to I-880 North
Take I-580 East towards Stockton
Exit south at Hacienda Drive (approximately one mile east of the I-680 interchange).
Turn right on Hacienda Drive and go through one intersection past Owens Dr.
KP will be the first driveway immediately on your right.
Please sign in and pick up a guest badge at the security desk


Driving From the San Francisco:
Take 101 South to 92 East over the San Mateo Toll Bridge
Take I-880 North to I-238 East to I-580 East towards Stockton
Exit south at Hacienda Drive (approximately one mile east of the I-680 interchange).
Turn right on Hacienda Drive and go through one intersection past Owens Dr.
KP will be the first driveway immediately on your right.
Please sign in and pick up a guest badge at the security desk

BART:

Walking distance south from the Dublin/Pleasanton BART station.

Dublin/Pleasanton Bart station map


[back to the top]

PRESENTATION


Modeling Baseball Cards:  A Case Study

Robert K. Hay & David C. Hay
Essential Strategies, Inc.

Abstract

Ok, when did you get exposed to data management for the first time?  Your first SQL course?  The time you got dBase II on your first PC?

No, we contend that you became aware of data management problems when you started collecting baseball cards.  First, of course there were issues of storing the physical inventory.  Then, as you looked at the cards, you began to understand the limitations of this medium in truly representing each player's performance.  You saw, for example, that one card per player was ok, but sometimes players changed teams in a season, and that required two cards.  And what happened when they started collecting new statistics?

It turns out that modeling the data on baseball cards is an excellent exercise of data modeling skills.  This presentation will describe the development of a data model as the  modeler achieves successive insights into the subtleties of the underlying data.  Beginning with a simple model of baseball cards themselves, the model will be extended in stages, until it becomes one that can serve as the basis for a true database to capture each player's performance throughout his career.

This will be an example of the way to develop a data model.

Audience

Beginner, intermediate

Speaker's Biography's:

About Robert K. Hay

A recent graduate in philosophy from Columbia University, Bob Hay has since learned data modeling and was involved in both developing and evaluating models at a major U.S. Bank.  He currently develops curricula for an SAT Preparation company.  He began collecting baseball cards when he was eight years old. 

About David C. Hay

A veteran of the Information Industry since the days of punched cards, paper tape, and teletype machines, Dave Hay has been producing data models to support strategic information planning and requirements planning for over thirteen years.  He has worked in a variety of industries, including, among others, power generation, clinical pharmaceutical research, oil refining, forestry, and broadcast.  He is President of Essential Strategies, Inc., a consulting firm dedicated to helping clients define corporate information architecture, identify requirements, and plan strategies for the implementation of new systems.   He is the author of the book, Data Model Patterns: Conventions of Thought, published by Dorset House, and, more recently Requirements Analysis: From Business Views to Architecture, from Prentice Hall.

He may be reached at davehay@essentialstrategies.com,  (713) 464-8316, or http://www.essentialstrategies.com.


[back to the top]

PRESIDENT'S MESSAGE



Dear members,

If you read this message prior to September 7th, I will still be in France at the time, or on my way back. I know you will have an excellent meeting, and I wish I could be with you to listen to David Hay on a great topic.

Related to the drawing I gave you last month (see below for quick reference and see the August Newletter for a complete introduction),  I would like to explain a little bit what it holds. Let's look at the "Data/Information" box for a moment. There is an "about" arrow coming from it, and going back to it: this implies a recursive "about". So, from "Data/Information" we arrive at "Data/Information about Data/Information", which is the "Data/Information" called "Metadata/Meta-information" or data models.

Looping around a second time, we get "Data/Information about Metadata/Meta-information", which is the "Data/Information" called "Meta-metadata/Meta-meta-information" or data models about data model repositories. Are we talking here about metadata models, or data meta-models? As you loop a third time, you get into "data/information" about a higher level of "data/information meta-structure". As you loop a fourth time, it is your own brain that starts spinning out of control into a headache. So, let's stop here with that arrow, for now.

Another box is called "Process/Procedure" and there are two "about" arrows between this box and the "Data/Information" box. So we have processes/procedures about data/information as well as data/information about process/procedures. Remember that loop we went through? That means these include also process/procedures about metadata/meta-information and process/procedures about meta-metadata/meta-meta-information, and so on, as well as metadata/meta-information about process/procedures and meta-metadata/meta-meta-information about process/procedures, and so on.

Oh, wait! There's more! (Don't you like those infomercials?) There is also a recursive "about" arrow going from and to the "Process/Procedure" box, which means... and combined with... OK. I will stop here, for this month. But you can see where I am getting at with this diagram.

Now, did you see what we are planning for the month of October? A regular half-day meeting plus a two day seminar. Who said we had to wait for December to be super-active?

We are now half-way through our membership drive. Renewal invoices have been sent, and thank those who have returned them with their dues payment. If the name of your company has changed recently, we need to know what the old name of the company was, in addition to the new name, so we can tie your payment back to your historical records in our "database. Again, Paypal is the payment method of choice. But if you can't use Paypal for whatever reason, sending your check to our P.O. Box will work as well. 

We now have four speakers planned for DAMAday. If things go as planned, we may need to run two tracks in parallel during one half of the day. When was the last time we had more than one track going during a DAMAday event?

I'll see you in October.

François Cartier President, 
SF DAMA


[back to the top]


OTHER RESOURCES

[back to the top]


2006 SF DAMA Meetings Schedule
(All meetings start at 8:30 a.m. and are at the following location unless otherwise noted.)
Date Topic / Presenter / Location
October 4, 2006 Best Practices for Data Security: Implementing the Missing Piece through Metadata
Jason Tiret, Embarcadero Technologies
TBD
October 10-11, 2006

XML and Data Management Workshop
Peter Aiken
Informatica - Redwood City
November 1, 2006 No Meeting Scheduled
December 11, 2006 SF-DAMA Day 

[back to the top]