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.
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.
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.
8:30 Registration & Networking
9:00 Opening Remarks
9:15 Presentation 1
Carlson School of Business, 321 Nineteenth Avenue South, University of Minnesota's West Bank Campus,
A skyway connects the building to the 19th Avenue Parking Ramp.