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.
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.
At the upcoming Enterprise Data World 2014, I’ll be doing a half-day presentation on Driving Development Projects with Enterprise Data Models.
Here are a few teases for what we will be talking about:
Join this session to see how data fits in real-world enterprise development projects. We’ll answer such questions as:
- "Who does what?"
- "Why are we doing this?"
- "Will it slow things down?”
- “Will it work with agile development?”
- "Will I have to actually talk to a data architect?"
- “What about the Cloud?”
- "What are the biggest mistakes teams make?"
- "Will I still have a job?"
The session will feature demos of common data modeling-to-database processes, including reverse engineering, forward engineering, generating DDL, alter scripts, and more. You will leave with 10 tips for making model-driven database development successful in your organization’s culture and environment.
I’ve been attending Enterprise Data World for more than 15 years. This event, focused on data architectures, data management, data modeling data governance and other great enterprise-class methods is part technical training and part revival for data professionals. It’s just that good.
This year the big bash is being held in Austin, TX, a thriving tech-oriented community, 27-April to 1 May. And this year’s theme is “The Transformation to Data-Driven Business Starts Here.”
And right now there’s a $200 Early Bird Discount going…plus if you use coupon code “DATACHICK” you can save $200 more on a multi-day registration or fifty bucks on a one day pass. There. I just saved you $400. And no, I get no kickbacks with this discount code. I don’t need them. I need you to be at this event, sharing your knowledge and meeting other data professionals. I need you to be part of the community of data professionals.
Top 10 Reasons You Need to Go to EDW 2014
- Data is HOT HOT HOT. I deemed 2013 The Year of Data and I see no signs that organizations are going to back to software-is-everything thinking. 2014 is still going to be a year full of data. There’s even an executive, invitation-only CDOvision even co-located.
- Not Just Bullet Points. There are over 20 hours of scheduled networking events for you to chat with other data-curious people. Chatting with other data professionals is my favourite part of this event. Bring your business cards…er… .vcs contact file.
- Lots of Expertise. Not just data celebrities, but also other data professionals with thousands of hours of hands-on experiences, sharing their use cases around data. And not just data modeling. Big Data. Analytics. Methods. Tools. Open Data. Governance. NoSQL. SQL. RDBMS. Fun.
- Certifications. You can take advantage of the Pay-Only-If-You-Pass option for the CDMP on-site certification testing.
- Workshops. I’m doing a half day tutorial on Driving Development Projects with Enterprise Data Models. I’ll be talking about how data models fit within real-life, practical, get-stuff-done development projects. No ivory towers here.
- SIGs. There are special interest groups on data modeling products, industries and methods. You can meet people just like you an share your tips and tricks for data lovin. I will be leading the ER/Studio SIG.
- Ice Cream. This conference has a tradition of the ice cream break on the exhibit floor. Nice ice cream, even.
- Austin. Austin is one of the more vibrant cities in Texas. So cool, it even has a Stevie Ray Vaughan statue. Museums, Theatres, indoor golf, clubs. There’s a reason why SxSW is held here.
- Vendors. Yes, we love them, too. Meet the product teams of the makers of the tools you use every day. Or meet new teams and ask for a demo. They are good people.
- Love Your Data. There’s no better way to show your love than to network with other data professionals and learn from industry leaders.
Come learn how to help your organization love data better. You might even see me in a lightning talk holding a martini. Or taking impromptu pics of @data_model and other data professionals. Or debating data management strategy with people from around the globe. In other words, talking data. With people who love their data. Join us.
On Thursday 5 February at 5:00 PM EST I’ll be moderating a panel on Myths, Misunderstandings and Successes in Data Analytics as part of the PASS Business Analytics 24 Hours of PASS preview. It’s free, but you need to register. And I have a fantastic set of panelists: Stacia Misner, Joey D’Antoni and Lynn Langit.
Duration: 60 minutes
Track: Strategy and Architecture
Big Data, Business Analytics, Data Analytics, NoSQL, Relational . . . do we even agree on what we mean by those terms? In this panel session, industry thought leaders will discuss and debate the most common myths, truths, and mostly-truths of new and traditional approaches for enterprise data management and analytics.
We’ll be leaving time for questions from the audience, so come ready with your myths and stories.
Yes, there’s 24 hours of goodness spread out over 2 days, so check out the other sessions.
What do you think are the minimum skills a person should have before they are allowed to manage a database? Does it matter whether or not it’s a production database? Does it matter how much data is there? What kind of data? Is recovery a goal or a symptom? Does it matter how old you are? Or how old the database is? What is the meaning of all this anyway?
Thomas LaRock ( blog | @sqlrockstar ) and I will be talking about what a Minimalist DBA is, what skills we think they need, and how to ensure that they have them on 3 December at Noon EST for the DBA Fundamentals Virtual Chapter of PASS.
Every profession has a core set of responsibilities that are expected of every practitioner. For anyone that has the letters “DBA” in their job description their job function is a black box to anyone on the outside. "What do you do here?" is a common question for most DBAs.
Some DBAs are a part-time data modelers, SAN admins, VM admins. Sometimes they know all about security, or Active Directory, or .NET. It differs from one shop to another. Whether it is day one or one hundred in your career as a DBA you need to make certain you stay focused on your core duties. If you slip up then you will find out why DBA often stands for Default Blame Acceptor.
Attend this webinar to make sure that no matter what your level of efficiency and laziness you are able to focus on the bare essentials (the minimum) necessary to be a Rockstar DBA."
Karen Lopez is a senior project manager and architect for InfoAdvisors. A frequent speaker at conferences and local user groups, she has 20+ years of experience in project and data management on large, multi-project programs. Karen is a chronic volunteer, a SQL Server MVP, and an active advocate for science, technology, engineering, and mathematics (STEM) education and data quality. She isn’t a DBA, but loves to talk and debate about the effectiveness of lazy DBAs. She isn’t sure if the minimalist thing is a strength or an excuse.
Thomas LaRock is a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and a Microsoft Certified Trainer with over 15 years’ experience in the IT industry in various roles such as programmer, developer, analyst, and database administrator. He is also the author of “DBA Survivor: Become a Rock Star DBA” (http://dbasurvivor.com) and has participated in the technical review of several other books.
Currently, Thomas is a Technical Evangelist for Confio Software. This role allows for him to work with a variety of customers to help solve questions regarding database performance tuning and virtualization. Thomas also serves on the Board of Directors for PASS as Vice President of Marketing. You can find out more information about him at his blog: http://thomaslarock.com/resume/.
You can probably expect our usual level of snark, debate, levity and great info for this presentation. Bring your ideas and snark, too. I always ensure that the audience is part of the presentation, so expect more the a slew of bullet points and demos. And even though this is hosted by a SQL Server organization, all we will be talking about will be applicable to multiple platforms. That’s how real enterprise database systems are anyway, right?
You’ll need to register, but it’s free. By the way, if you also register on that site, you’ll become a member of that chapter. And that’s free, too.
Subscribe via E-mail
- 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