Browsing articles tagged with " data modeling"

Speaking: DAMA Day Nebraska (Omaha) 3 November – Data Modeling Contentious Issues

Oct 24, 2011   //   by Karen Lopez   //   Blog, Data, Speaking  //  No Comments

Contentious Issues Post Its

 

The final stop on my DAMA speaking tour is DAMA Nebraska for their DAMA Day. 

Data Modeling Contentious Issues
A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced data modeling issues, such as:

  • Party/party role
  • Natural vs. surrogate keys
  • Class Models vs. Data Models
  • SOAs, Ontologies, ESBs, New TLAs and Shoe Strings
  • What is Logical? What is Physical? Why Do We Care?
  • Politics vs. Customer Satisfaction

Participants in this session will be presented with an issue along with a range of responses or possible solutions. Participants will vote on their preferred response, then the group as a whole will discuss the results, along with the merits of each possible response. If the specific issue has been discussed in other presentations, a summary of the responses of the other groups will be presented. The goal of this workshop is to help practitioners identify potential points of conflict in data modeling, as well as alternative approaches to resolving the issues.

This DAMA Day is sponsored by Embarcadero and they will be making a presentation as well.  Registration is requested.

Speaking: DAMA MN (Minneapolis) 17 October – Career Success in Turbulent Times + More

Oct 4, 2011   //   by Karen Lopez   //   Blog, Data Modeling, Speaking  //  1 Comment

BarbieEight

The next few weeks are going to be busy for me: I’m speaking at SQLSaturday Oregon (Portland) and then at the PASS Summit in Seattle.  Right after that I’m headed on DAMA chapter speaking tour.  First up on that tour is DAMA MN on Monday, 17 October 8:30 AM – 11:30 AM where I’ll be presenting:

Career Success in Data Management in Turbulent Times

A workshop on issues and ideas that today’s data architects and modelers can do to build their careers and networking skills with other data management professionals.

Workshop topics will include:
• Demonstrating your expertise
• Building a portfolio of your success stories
• Getting others to sell your skills and business value
• Building & extending your data management skill set
• 10 Steps to highlighting you and your work

Bring your thoughts, ideas, and experiences.

You’ve Just Inherited a Data Model:  Now What?

The good news is that someone else has done the hard work of architecting a data model and you just have to take on minor maintenance…or is that the bad news? Or have you been tasked with implementing a pattern or industry standard data model? Perhaps a team member has sent the world’s best resignation letter and won’t be helping you with the model. Learn the 5 steps you MUST take before working with a new data model.

Attendees will also receive a detailed checklist for the 5 steps.

Details about the event are provided on the DAMA MN webpage.  I hope to see you there.

What the Heck is an Entity Instance Diagram?

Jul 27, 2011   //   by Karen Lopez   //   Blog, Data, Data Modeling, Social Networking  //  4 Comments

I was recently contacted by a friend who is taking a database design course for some help in understanding an assignment.  His first task was to create a conceptual data model and then prepare entity instance diagrams for that data model.  He was wondering what an entity instance diagram was.  So was I, as I had not heard that term before.  So I fired off a search and came up with only one hit:

Google Search for Entity Instance Diagram: 1 hit.

 

I’m pretty sure that’s the first time I’ve every unintentionally found only one returned result for a search term before.  Unfortunately that one webpage has broken images, so I couldn’t see what one looked like.  So I told my friend:

Facebook: Karen Lopez quote

 

I was thinking of examples such as the ones in Simsion & Witt’s  Data Modeling Essentials [aff link]:

 

Sample data table from Data Modeling Essentials.

 

I did some more looking around and using Bing, found one more result which pointed to a PowerPoint slide deck by Ellis Cohen from his course on Theory, Practice & Methodology of Relational Database Design and Programming. In this deck I found an example of what he calls an entity instance diagram, which pretty much is what I thought it was.  I’ve been creating an using these sorts of things to explain how a data model should be used but I never had a name for them.  I called them sample data, data prototypes, data validation , worked examples, or just examples.  Now we have a name and a TLA!

In Cohen’s slide, he’s using an Entity Instance Diagram (EID) to to demonstrate weak entities:

 

Weak Entity Instance Diagram

I usually use Excel to prepare these, as I can reuse the data for each one.  I even have an ER/Studio macro to generate the tabs in a spreadsheet (one for each entity/table selected in a submodel). This makes preparing the sample data go much faster. 

So it looks like we have an answer now for what the heck is an entity instance diagram….and I have a name for a technique that I use all the time.  If you have other examples of this term, I’d love to see them.

 

Checklist from 16 June DArchVC Presentation

Jun 16, 2011   //   by Karen Lopez   //   Blog, Data, Data Modeling  //  1 Comment

I’ve uploaded a much more detailed checklist for what to do when you inherit a data model from someone else.

You’ve Just Inherited a Data Model Checklist

What would you add to it?

Speaking: You’ve Just Inherited a Data Model – Now What? 16 June Webinar

Jun 16, 2011   //   by Karen Lopez   //    //  No Comments

On Thursday, 16 June 2011 2PM ET I’ll be presenting a webinar for the Professional Association for SQL Server (PASS) Data Architecture virtual chapter (DArchVC) on working with industry standard data models.  Attendance in the webinar is free.  No pre-registration is required; just put the Live Meeting link on your calendar for 16 June 2011, 2PM EDT.

The DArchVC chapter is fairly new and I have been somewhat involved helping get it set up.   The people doing most of the work are:

From our chapter page:

Data Architecture underpins just about everything we do in IT.  Without a clear understanding of how data is structured, there is no reliable way to derive meaning from it.  Data Architecture drives the design and governance of data systems, and thus should be of interest to any data professional.  Data Architecture provides the blue-prints that we all share, whether we be DBAs, data integration developers, database developers, data warehousing professionals, data presentation developers or client-side application developers persisting data for later retrieval.

The PASS Data Architecture Virtual Chapter will focus on data architecture concerns as they impact users, developers and DBAs on the Microsoft SQL Server platform.  We want to make data architecture accessible to all data practitioners, and drive the point home that Data Architecture is a set of practices and a body of knowledge that overlaps almost all database professionals to some degree.

The session abstract:

You’ve Just Inherited a Data Model – Now What?

The good news is that someone else has done the hard work of architecting a data model and you just have to take on minor maintenance…or is that the bad news? Or have you been tasked with implementing a pattern or industry standard data model?  Perhaps a team member has sent the world’s best resignation letter and won’t be helping you with the model.  Learn the 5 steps you MUST take before working with a new data model.

Attendees will also receive a detailed checklist for the 5 steps.

Karen López is a principal consultant at InfoAdvisors, Inc., a Toronto-based consulting firm. Karen is a frequent speaker at DAMA, SQLSaturdays and PASS conferences, including 24 Hours of PASS, the PASS Summit and PASS SQLRally.  She has 20+ years of experience in project and data management on large, multi-project programs.  Karen specializes in the practical application of data management principles.

Karen is also the ListMistress and moderator of the InfoAdvisors Discussion Groups at www.infoadvisors.com.

As usually, I’ll try to keep track of conversations on Twitter.  Let’s use the hashtag #DArchISDM  Join us on Thursday and come prepared with your comments, observations, and questions about working with third party data models.

Half Day Seminar 7 April #EDW11 – 10 Physical Data Modeling Blunders – Discount Coupon

Mar 30, 2011   //   by Karen Lopez   //   Blog, Data, Data Modeling, Database, Speaking  //  No Comments

imageFor 24 Hours of PASS Virtual conference,  I gave a short, 40 minute overview of 5 Physical Design blunders.  At Enterprise Data World in Chicago on 7 April, I’m giving a half day seminar on 10 Blunders (NOW with 5 BONUS BLUNDERS!).  Unlike the virtual conference, this workshop will have demos and labs – PLUS 5 BONUS BLUNDERS!

If you act quickly, I have a special deal for those of you who want to join me for this event: A discount coupon.  The normal one day admission is $795.  But if you register now, you can register for the Thursday full day, including my seminar, for only $195.  Yes, that’s a $600 savings to be part of the biggest blunderfest best seminar of the conference.

Coupon code DATACHICK for $600 off ($195 net total)

Use this registration link to get yourself set up.  And don’t forget to use the coupon code DATACHICK to save that $600.  There are still great hotel rates, too.

Join me at the world’s largest vendor-neutral data management conference.  See you there!

I’m Speaking at #SQLSat65 Vancouver, BC Database Design Contentious Issues

Feb 26, 2011   //   by Karen Lopez   //    //  1 Comment

 

image

I will be presenting on Database Design Contentious Issues at SQL Saturday 65 on 26 February 2011. Like all SQL Saturdays, this event is free for attendees (with a  fee for a real lunch) due to the support of wonderful sponsors in the SQL Community.

View on Vancouver on October 1, 2005

Database Design Contentious Issues

A highly interactive and popular session where attendees evaluate the options and best practices of common and advanced design issues, such as:

  • Natural vs. Surrogate keys
  • Classwords and other Naming Standards
  • Varchar Minimums
  • Identity Crisis
  • Who Calls the Shots and Who Does What? …and others.

Bring your votes, your debates, and your opinions.

Session Level: Intermediate

This session has been a popular session at all kinds of user group meetings – in fact, it is my favourite presentation.  SQL Saturdays are a great way to get free training and to network with other data professionals including DBAs, Data Architects, Developers and more. Most SQL Saturday registrations are closed well before the date of the event, so hurry up and register now.  Vancouver is a beautiful place.  I hope you can join us for Canada’s first SQL Saturday event.

Enhanced by Zemanta

Subscribe via E-mail

Use the link below to receive posts via e-mail. Unsubscribe at any time. Subscribe to www.datamodel.com by Email


Categories

Archive

UA-52726617-1