Q-Tips - Quick Data Modeling Tool Tips
  Johnny Gay   Johnny Ray Gay
Senior Data Analyst
Moneygram International
 


 

Wednesday, April 30, 2014
08:30 AM - 09:15 AM

Level:  Technical (may include code)


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


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.


   
Close Window