Data Modeling & Architecture

Model Your Hadoop Hive Databases with ER/Studio With round-trip database support, data modeling professionals can use ER/Studio® Data Architect to easily reverse-engineer, compare and merge, and visually document data assets residing in diverse locations from data centers to mobile platforms. A variety of database platforms, including traditional RDBMS and big data technologies such as Hadoop Hive, can be imported and integrated into shared models and metadata definitions. Click here to download the solution brief Click here for more info...
Webinar: Model Confidence for Master Data Don't miss this great webinar featuring David Loshin on data modeling for MDM. The Quest for the ‘Golden Record’ Thursday, May 14, 201511:00am Pacific / 1:00pm Central / 2:00pm Eastern Although master data management (MDM) systems have been deployed in numerous industries and organizations, the vision of creating an overall “single source of truth” is beginning to yield to a more pragmatic perspective of providing visibility to shared information about uniquely-identifiable entities withi...
Improve Agility and Collaboration with ER/Studio XE7 On April 28, 2015, Embarcadero announced the XE7 release of our award-winning ER/Studio data modeling and architecture suite, with new features to improve agility and collaboration in enterprise data landscapes. Let’s highlight them, and for more details and a demonstration, you can watch the on-demand webinar from April 30th. ER/Studio continues to incorporate new capabilities and features to improve the user experience, enhance the data architecture, and address emerging industry technologies...
Business-Oriented Conceptual Modeling for Master Data Entities - by David Loshin In my previous post, we examined some of the challenges associated with developing data models for master data entities managed within an MDM environment, and I implied that achieving the holy grail of MDM, namely the (elusive, if not purely mythical) “golden record” would first require a practice for business-oriented data conceptual and logical data modeling. We tend to have a “dimensional attitude” about master data, focusing on “customer master” or “supplier master” or “product master” as i...
Lose Data Model Errors with This One Weird Trick Are you tired of people finding errors in your data models once they go to build an application on top of that fine database you designed for them?  Would you like to be in on a secret that others have to spend thousands of hours in the gym to accomplish?  Well I have the solution for you.  All you have to do is call in the next 7:00 minutes with your credit card number handy.   Hold on.   I first heard about this trick during one of my EDW sessions on database desig...