I recently wrote a whitepaper, sponsored by Neo4j, on how your master data (think cross-application data like CUSTOMER, PRODUCT, ORGANIZATION, etc.) is much more valuable to your organization if you can leverage the relationships between the data. You might think that relational databases are all about relationships, but they aren’t. The relational in relational database comes from the fact that data is a relation (a table-like structure of columns and rows).
The best thing we have for describing relationships in a relational database is a foreign key (FK). An FK is a constraint between two tables. In a relational database, FKs enforce integrity between exactly two tables. But in the real world, relationships are more than constraints. They are implied, inferred and, maybe even just plausible. That’s not a constraint; that’s a relationship. And these relationships often exist because they span multiple tables. Think about CUSTOMERs that are related because they live at ADDRESSes near each other, they have TRANSACTIONs at the same RETAIL STORE and they buy the same PRODUCTs and SERVICEs. That’s a specific relationship, one that has nothing to do with foreign keys.
You can download my whitepaper at http://neo4j.com/resources/wp-master-data-graph/
Note that while Neo Technology sponsored this paper, they had no editorial control over its content.
This week I’m also doing a webinar about some of the content of the paper. Kamile Nixon of Neo Technology will join me in this discussion. You can register at http://info.neo4j.com/0430-register.html
I think this one will be a lot of fun. Kamile and I have worked together on many things over the years. She and I share the same sort of sense of humour. You have been warned.
Webinar: Your Master Data is a Graph: Are You Ready?
Thursday, April 30 at 09:00 PDT | 18:00 CEST
As you tackle your ongoing Master Data Management challenges, it’s important to keep a few things in mind: Hierarchies don’t really exist Relational isn’t about relationships Foreign keys aren’t relationships, but constraints It’s crazy, isn’t it?
Join Master Data Management expert Karen Lopez and Neo Technology’s Kami Nixon as they discuss today’s MDM requirements and explore the companies that are getting MDM right.
In this webinar, you will learn:
- Why hierarchies aren’t real
- How to choose the right technology for the stories your data wants to tell, so your business can use data in ways it couldn’t do before
- Why relationships are just as important as the things they relate
- What foreign keys really do to your architecture
- How companies like Cisco and Polyvore use graphs to get real business value from Master Data
Karen Lopez, Data Evangelist, InfoAdvisors
Karen Lopez has more than 20 years of data architecture and database design experience. She specializes in the practical application of design approaches, balancing development time frames with the need to deliver solutions that will support business agility and data quality needs. Known for her practical and sometimes snarky views on the data world, Karen works to find the right tools for the job, even if it means learning something new. She wants you to love your data.
Kami Nixon, Senior Product Marketing Manager, Neo Technology
A recipient of the 2012 “Graphie”, Kamille was a fan of Neo4j for several years before she happily joined the team. Kamille has helped several successful database companies (DataStax, Comindware and Embarcadero Technologies) to identify and execute on market trends so they could pull ahead of the pack. Her efforts have led to doubled vertical bookings, increases by 30% to 100% in year-over-year revenue, and several awards. In addition to the Graphie, Kamille has received several other commendations, including co-authoring with Karen Lopez story #5 in Information Management’s Top 10 for 2011, and Best Investigative Journalism in a national competition.
Lara Rubbelke (@sqlgal ) and I recently presented 7 Databases in 70 Minutes, a sort of homage to the book 7 Databases in 7 Weeks. The event was SQLBits, a UK-based SQL Server event. We first gave this talk at the PASS Summit last year.
We don’t talk about the same databases as the book, but the concepts are the same. We cover relational, column family, graph, key value, Hadoop, and document database technologies, focusing mostly on the reasons why you would want to consider these and what a typical create and query statement might look like.
And then we end with 7 reasons why you should start exploring them.
It’s a blast talking about so many things in such a short time frame and it’s fun watching light bulbs go off as people realize these aren’t just silly open source projects, but real, enterprise class solutions for common enterprise processes.
Check out our slide deck.
Have you been looking at non-relational technologies to tell your data stories, too?
This year we had a new item at the 2014 PASS Summit: Speaker Idol. Run by Denny Cherry ( blogs | @mrdenny ), this is a contest where people who have never been selected to speak at Summit get the opportunity to win a golden ticket (an automatic speaking slot) at Summit 2015. To win, speakers must put together a 5 minute lightning talk, then impress the judges more than any other speaker in the competition.
I competed in a similar contest at TechEd two years ago. The difficult part about this is there are no criteria for which you can prepare. You don’t know what the judges think are good habits or what topics they might enjoy. They might even give conflicting advice. It takes a lot of courage to stand up in front of a crowd, give your presentation, then be critiqued by others in front of a crowd.
A few of us judges are blogging today about the things we commented on to the presenters:
Denny Cherry discusses the overall process used to put it all together
Joey D’Antoni focused mostly on physical presence while speaking
If others blog, I’ll update this post with links.
Today I’m going to continue on with Joey’s theme of physical presence.
Move, But Don’t Wander
It’s really difficult when you are stressed or nervous to get the timing and location of moving around right. Some people hug the lectern as if they are on flight experiencing extreme turbulence. Others pace back and forth like a caged animal hungry for fresh meat. At some conferences at Summit, this is compounded by a speaker set up where there’s a table, a lectern and several chairs. The AV equipment is often taped or strapped down so that your laptop must be located on the lectern. I find this annoying because presenting isn’t the same as giving a speech. Presenting and training involve more discussions with the audience and need more engagement than just speaking at a group of people.
The raised podium effect also means that moving around can lead to falling off the stage. Not a good thing.
Joey gave advice to stand with your feet together. I usually give other advice: stand with your feet shoulder’s width apart, then move your feet about 3 inches further apart. This sort of forces you to stay put for a while because it feels slightly off, but not enough to make it feel awkward. It’s harder to move out of that stance and it tends to be a more powerful, competent looking to the audience. Move around to ensure you aren’t blocking the same audience members for your whole presentation. Move to show that you and the audience are working together to learn.
Remember: pacing back and forth is bad, but taking a few steps in a variety of directions can help you engage different members of the audience. Have a purpose when you move.
A Mic Changes Everything
Most speakers would prefer not to use a microphone. A hand mic plus a remote means both our hands are tied up. A lavaliere mic (one that clips on your shirt and has a pack that has to be stuck in a pocket or worn in the back) means everything you do or say is being amplified. But when sessions are recorded, broadcast or in large rooms, audio equipment is mandatory.
One of the more common mistakes the speakers made was leaning forward then turning their heads to read the slides on the screen. This meant that as they were talking, they were talking away from the mic. We judges were in the front row and I had a hard time hearing what was said.
The trick is to turn your whole body when you are mic-ed up. Do this even when you are turning to speak to an audience member and to highlight something on the screen.
Remember: The audio portion of your presentation is just as important as the visuals. Probably even more important.
Don’t Read Your Slides to the Audience
This is a tough habit to break, especially if you are running short on time. It’s the most common feedback I hear from people who are attending sessions and are frustrated by the speaker. This is especially common with lightning talks because time is so limited. If you read your slides to the audience, you are basically showing them that you don’t really need to be there speaking. You could just email blast out your slides and be sitting in the bar enjoying a conference-themed beverage.
One of the ways to break this habit is to have fewer words on your slides. More on this later.
Another way is to have speaker notes that you can see when you are presenting. These should have different words/bullet points and that will force you to explain things in different words. PowerPoint shows these notes when you are in presentation mode.
The best way to break this habit, though, is to not look at your slides when you speak. Look at the audience. Engage with them. Offer insights into what is on the slides, but do that while having a conversation with the audience.
Remember: You are there to give insights and to engage with the audience. Your slides are there to support that, not the other way around.
One of the more interesting things about being a judge is that we all talked about how we are also guilty of many of these speaker vices. We recognized that while we were giving all this advice, we all needed to take care when we presented, too. I’m sure it was difficult for the contestants to be judged in public. It was difficult for us doing that as well.
I’ve blogged about what to do when something goes wrong during your presentation, but I’ll be blogging about those things and more as part of this series. I’ll be talking about equipment, preparation and delivery. Plus being judge-y .
shared some of these on Twitter, but I decided to pull them all together in one place. There’s be a lot of tips shared prior to these events, but I think these haven’t been covered nearly enough.
- Laptop Power cord
- Spare batteries
- USB charger ends
- VGA adapter/dongle
- Presentation clicker
- Presentation on thumb drive
- Compassion for those with difficulties
- Bravery to meet people in person
- Spirit to lift others up
- Daring to try something new
- Firmness to speak up
- Care for not insulting others
- Humility to ask real questions
- Talent to discourage Strutters
- Expertise to think of audience, not self
- Restraint not to sell from the podium
- Civility to be nice to everyone, not just the celebs
- Class not to spam the crowd
- Excellence to understand that not everyone speaks English well.
- Integrity to disclose your biases and affiliations
- Professionalism not to cuss
- Readiness to help others
- Genuineness to show your real self
- Trust that others want you to succeed
- Diligence to keep your promises
- Concern for others who have less experience than you
- Coolness to get through tough discussions
- Kindness for others
- Goofiness to have fun
- Self-discipline to take care of your body
- Prudence to take care of your mind
- Sincerity to admit your mistakes
- Preparedness for your presentation.
- Openness to constructive feedback
- Honesty to admit “I do not know”
- Expertise to answer questions
- Mindfulness to know when you are not helping
- Charity for others who disagree with you
- Expertise to know when to not try to answer questions
- Empathy for others
- Respect for self
- Wisdom to know that you can’t have self respect without empathy for others
- Forethought to pack well
- Vigilance to call out bullying and disrespect
- Courage to meet others who are different than you
- Strength to deal
- Moderation to get to tomorrow
- Stamina for long days
- Thankfulness for volunteers and staff
- Joy for cheering on others
What did I forget on this list?
Many Toronto User Group members will be attending the PASS Summit in November in Seattle Washington, including me. If you work with SQL Server, this is the only community-driven event for SQL Server training, presentations, workshops and networking.
Would you like to join us? Use our PASS Summit Discount code / Coupon / promo code:
You can register now at http://www.sqlpass.org/summit/2014/RegisterNow.aspx and use the code to save $150 off full registrations. If you register before 27 June, you’ll get the best discount you can get right now and the Toronto User Group gets $50 to fund our meetings which start again in September. That’s right: you save some dough and our user group gets funding for our upcoming season that starts in September 2014.
If you can’t register now, no worries. You can still use our chapter code later.
Feel free to share this information with colleagues, even the discount code. The more the merrier. And the better you can love your SQL Server data.
Big data and NoSQL have led to big changes In the data environment, but are they all in the best interest of data? Are they technologies that "free us from the harsh limitations of relational databases?" as I recently blogged about at Dataversity.net?
In this month’s webinar (register now), we will be answering questions like these, plus:
- Have we managed to free organizations from having to do data modeling?
- Is there a need for a data modeler on NoSQL projects?
- If we build data models, which types will work?
- If we build data models, how will they be used?
- If we build data models, when will they be used?
- Who will use data models?
- Where does data quality happen?
- Are there NoSQL technologies for which data modeling will never apply?
Finally, we will wrap with 10 tips for data modelers in organizations incorporating NoSQL in their modern data architectures.
Join NoSQL expert extraordinaire Dan McCreary ( blog ) and others (including YOU!) as we talk about the future of data modeling and data modelers this Thursday, 26 June, at 2PM EDT.
We’ll also have some prizes to give a way, so plan on attending live.
(BTW, don’t get me started on the lame modeling styles/naming standards in stock photography. Maybe I should start making some for Getty Images?)
22 May 2014, 2PM EDT
It’s May, which sets this former Hoosier thinking of racetracks and Indy cars. I’m also a runner and that means I’m always thinking about pace and timings…and feeling guilty about not training hard enough.
This got me musing about how data modelers can speed up the data modeling process — not just during a development projects, but at all points in our work day. So let’s have a discussion about
In this month’s webinar, we’ll talk about:
- The Need for Speed
- Sprints, marathons and training
- Race cars, horses, carts, and feet
- Qualifiers and Races
- Pace cars
- Backseat drivers
- Rules, tickets and enforcement
- Fads, gadgets and automation
- Red, yellow, green and checkered flags
- How do you know when to stop racing?
Joining me in the discussion will be two wonderful panellists:
Donna Burbank, VP, Information Management Services at Enterprise Architects ( @donnaburbank )
Carol Lehn, MDM Database Designer at PepsiCo ( @lehnca )
And as usual, our attendees will have the opportunity to participate via chat and Q&A as our final panellist.
Subscribe via E-mail
- June 2015
- May 2015
- April 2015
- March 2015
- February 2015
- January 2015
- December 2014
- November 2014
- October 2014
- August 2014
- July 2014
- June 2014
- May 2014
- April 2014
- March 2014
- February 2014
- January 2014
- December 2013
- November 2013
- October 2013
- September 2013
- August 2013
- July 2013
- June 2013
- May 2013
- April 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- July 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- September 2010
- August 2010
- July 2010