Maybe you’ve been using ER/Studio for years, maybe you’re just getting started. Maybe you don’t even know where to start. You might be a full time data architect or an accidental database designer – either way, you’ll want to know about the settings and features to make your Mondays more tolerable and your Fridays more fun.
In this session, Karen covers her 10 favorite tips and tricks for working with ER/Studio. We’ll look at how to configure ER/Studio to save time, reduce risks and to make your data modeler life less stressful. She will show you features that will make your models more loved and valued by your IT and business team members.
Finally, we’ll wrap up with recommendations for more resources for becoming more productive.
My March Dataversity webinar will focus on one of the most challenging aspects of data governance and data modeling in 2016 — working on agile and other modern development method projects while maintaining data stewardship, data quality and data protection as project teams are sprinting by….with or without you.
Most of us learned data modeling via a waterfall-driven methodology lens. Yet Agile and other modern development methods have for the most part assumed that data governance is an anti-pattern to just getting things (software) done. Well look at questions such as:
- Are Agile and Data Governance Enemies?
- How can we get stuff done AND get systems delivered?
- And what do we do about existing systems delivered without data governance attention?
We’ll also look at how data modeling fits in the answers to these questions.
If you join us live during the webinar, you have the opportunity to engage with all the other attendees, share your stories, ask your questions and be part of the discussion. If you can’t attend the live event, you can still register to get the slide deck and links to the recording when they are available.
You can join a bit early to listen in to the pre-show and stay a bit later when I do off-the-record Q&A. Just between the few of us.
Karen declared 2015 as the Year of Data. And with future outlooks, it’s still looking great for data in 2016. As we start the new year, let’s look at some of the trends and predictions coming from the data industry. We’ll include data modeling topics, but also look to the types of innovations in the data world that will influence our data architectures, jobs and tools.
Some have been around for a while but just now gaining traction and some are just now rolling out: Machine Learning, Internet of Things, New and NoSQL DBs, Data Wrangling, Data Virtualization and more.
The pre-show starts 30 minutes before the official event. Yes, that’s right…as you know, my webinars at Dataversity are interactive: you can chat with other attendees, ask questions and provide your own commentary during the event. This isn’t just a broadcast, it’s about being community of data modelers and sharing our ideas. Even contentious ones, which makes for a good fit for our group here. Yes, you can always catch up via the recordings later, but the fun part of my webinars are the interaction, snark, real-life stories and connecting with others. Start your Year of Data off right and join in on Thursday.
You can also follow along on Twitter via the hashtag #HeartData
My Dataversity Heart of Data Modeling webinar this month was titled The Best Data Modeler is a Lazy Data Modeler.
In this presentation I discuss tips for automating more of the mindless tasks in data modeling (printing, publishing, complex by rote naming of objects and more). My rules for when to automate a task:
- Don’t spend time doing things that a computer is faster and better at
- Automation is your friend
- Don’t try to automate everything at once
- Don’t try to rebuild an entire data modeling tool in a script
- Focus modeling time on mindful things, not mindless ones
- If you’ve automated it, you must ask vendors to make it a feature in their tool
Check out the recording when it goes live this week. And if you have examples of automation that we didn’t cover, let me know. I’d love to talk about them (and use them in my own data modeling activities).
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.
Subscribe via E-mail
- September 2016
- August 2016
- June 2016
- May 2016
- April 2016
- March 2016
- February 2016
- January 2016
- December 2015
- November 2015
- September 2015
- July 2015
- 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
- February 2009