Johnny Gay: Data Modeling Tool Tips and Techniques & Gordon Everest: Test your Data Modeling Skills

When
Wednesday, May 21, 2014
8:30 AM - 11:30 AM
Location
Carlson School building. Room 2-219.

Registration

I will attend in Person
I will attend on-line

Registration is closed

Abstract 1 presented by: Johnny Gay

Get some of the most beneficial, time-tested, work-reducing physical data modeling tool tips and techniques. Q-Tips is the tool we use to share our tips and techniques. In this session, PowerDesigner is the data modeling tool and Oracle is the database used to demonstrate many of the techniques.

The sample files shared with attendees are for this environment as well. Nevertheless, many of these ideas can be applied to other tools such as ERwin.

Physical data model templates and macro scripts
Reusable objects
Eliminate redundant data entry
Enable the tool to enforce naming standards
Beyond the tool - reusable SQL queries and scripts

Biography:

Johnny Ray Gay is a super Senior Data Analyst at MoneyGram International, a Dallas based money-transfer company. He has 19+ years of experience in data modeling, and many more years in IT. He has filled many project roles that include: business analyst, data modeler, data architect, developer, and technical project lead. His first five years of experience as a data modeler focused primarily on conceptual and logical data modeling of the business world. He describes this time as heaven on earth! His current focus is on designing OLTP database environments. He says this may be the other place data modelers go when they're bad! He has no hot products or services to sell; no best-selling books to promote; no guru credentials to present; only many valuable lessons learned from real world experiences to share.

Abstract 2 presented by: Gordon Everest

You will be presented with a series of database design problems. Come prepared to vote on your preferred (correct?) solution. There is no planning or preparation required, just bring your vast knowledge of data modeling principles and see how you do.

Biography:

I have been in the computer industry since 1960 when I programmed my first computer... without a symbolic assembler!

Got interested in data management a few years after that with a doctoral dissertation entitled "Managing Corporate Data Resources" (1974) which became a book from McGraw-Hill entitled "Database Management" in 1986 (in print until 2002!). I have been teaching anything to do with data since 1970 at the University of Minnesota and other places/institutions.

Now my goal is to get the whole world of data modeling using Object Role Modeling (ORM) to capture business semantics (rules) and design databases. It is a much better scheme than ER or Relational modeling. Toward that end I am now offering my Advanced Database Design course online to working (or aspiring) IS professionals, particularly interested in data modeling. Go to: http://www.tc.umn.edu/~geverest for more information.

Specialties:My main focus is on Data Modeling using Object Role Modeling (ORM or FOM). Other interests include: data management and DBMS, data warehousing and dimensional modeling, management information systems, legal aspects of computing (data privacy, intellectual property, contracting).

Presentation Slides:

Coming Soon!

Agenda:

8:30 Registration & Networking
9:00 Opening Remarks
9:15 Presentation 1

10:15 Break

10:25 Presentation 2

11:25 Q&A

Venue:

Carlson School of Business, 321 Nineteenth Avenue South, University of Minnesota's West Bank Campus,

Room 2-219

A skyway connects the building to the 19th Avenue Parking Ramp.

Directions:

Powered by Wild Apricot Membership Software

Upcoming events