Data Modeling & Architecture

Enabling Enterprise Agility Through Model-Driven Data Design This is an excerpt from the IDC Technology Spotlight June 2015 report, Enabling Enterprise Agility Through Model-Driven Data Design. This paper examines the growing importance of model-driven processes for database design and management. You can download the entire report here.
Demystifying Macros with ER/Studio In the webinar, Demystifying Macros with ER/Studio, Embarcadero Software Consultant Stanley Chan demonstrated how macros work in ER/Studio. He showed how to use the built-in macros and also shared some custom macros during the session. If you missed the live presentation, you can watch it on demand. There were a lot of great questions during the session, some of which Stan didn’t have time to answer live. So he has provided responses to several of those for this blog. Q: In the color-coding de...
Are You Working on an Agile Project?  Should You Be? At EDW this year Ron Huizenga, Product Manager for ER/Studio, and I led a SIG discussion about working on agile projects...as a data modeler. As usual, this resulted in a lot of frustration being voiced from data modelers about: Not being wanted on the voyage Being treated like obstacles to getting stuff done Being confused by terminology and expectations that differ from 1980s approach to data modeling Being frustrated because perfectly good data models are ignore Being frustrated becaus...
Aligning Your Models for Master Data Management - by David Loshin In my last post, I suggested that the conventional “facet” approach to designing master data models (in which each master domain is modeled, designed, and implemented in isolation from the others in the enterprise) creates gaps in the ability to effectively build applications that facilitate successful execution of end-to-end business processes. For example, the perception (and consequently the definition) of the role of a “customer” changes between the marketing, sales, finance, fulfillment, an...
Video: ER/Studio Support for Hadoop Hive Since data stored in Hadoop is almost always used for analytics, and because of its immense volume and wide variety, the need for data modeling has never been greater. Watch this short video to see how Hadoop Hive tables can be reverse and forward engineered using ER/Studio Data Architect. Click here to learn more about Hadoop Hive support in Embarcadero ER/Studio and try it free! ER/Studio's comprehensive model management and collaboration capabilities simplify the tasks of building and mai...