Joy Ruff - All About Data Architecture

Product Marketing Manager for ER/Studio

Read data and database blogs on:
http://community.embarcadero.com/index.php/blogs/blog-menu/categories/listings/database

Embarcadero and the Object/Relational Mismatch - by Robin Bloor The introduction of object-oriented (OO) programming languages provoked an unfortunate schism in the world of software development. Relational databases dominated the database world and Entity Relationship (ER) modeling quickly dominated database design. This determined the target data structure for programmers when they wrote applications. However, OO languages embodied distinctly different views of data. This mismatch might have been brushed under the carpet if object databases had ever gaine...

Posted by on in Data Modeling & Architecture
The Data Model Scorecard Steve Hoberman is a presenter, consultant, and the author of seven books on data modeling, including the bestseller Data Modeling Made Simple. One of Steve's frequent data modeling consulting assignments is to review data models using his Data Model Scorecard® technique. Steve has just published the Data Model Scorecard book, which helps data professionals apply a scoring standard against their data models in order to assess their quality. This scoring tool contains ten categories aimed at impr...

Posted by on in Data Modeling & Architecture
Metadata Market Study Report   Recently, the Competence Center Corporate Data Quality (CC CDQ, a European consortium research program) engaged with Fraunhofer Institute for Material Flow and Logistics to produce a new Market Study report called METADATA MANAGEMENT TOOLS FOR ENTERPRISE DATA MANAGEMENT. This extensive market study describes the role of data management in today’s enterprise and provides a broad overview of over 30 software solutions available, including Embarcadero’s ER/Studio XE7. Embarcadero is honore...
Data Modeling Tip for DBAs - by John Sterrett Database Administrators (DBAs) are given so many different tasks from creating maintenance plans, upgrading databases, fighting performance problems, and more. With so many tasks to be completed, some tasks tend to not get the attention to detail they deserve.  Commonly, I see DBAs making multiple mistakes with table design and data modeling.  Today, I am going to quickly show you an example where poor data modeling can directly impact your application’s performance. We are going to ...
The Hidden Elephant in 'Big Data' Modeling - by Len Silverston The Elephant “We must understand the data and therefore continue to develop data models, even in this 'Big Data' era." exclaimed the data warehouse lead. "You traditional guys! We are in a new age and we have new technologies and tools that allow us to immediately store tremendous amounts of data and use it, without the ridiculous long and expensive cycles of data modeling and design. Wake up and start living in our new world!" said the data scientist. "If you use the data without first unders...
How Do You Collaborate on Enterprise Data? As enterprise data environments become more complex, the need for full understanding of what the data means becomes more apparent. When you’re trying to integrate data from different sources, you have to ensure that information doesn’t get tagged incorrectly, or it may be lost to the business users that needed it. How is your business ensuring that it understands how to interpret corporate data? Are you sure that your business users and your data professionals agree on what specific terms reall...
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...
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...
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...

Check out more tips and tricks in this development video: