Data Modeling News, Articles, & Education

Embarcadero ER/Studio Data Architect Certified for HortonWorks Data Platform and MongoDB Enterprise

emb

by Angela Guess A new article out of the company reports, “Embarcadero Technologies, a leading provider of software solutions for application and database development, today announced that its data modeling tool, ER/Studio® Data Architect version 10.0, has been certified by HortonWorks for HortonWorks Data Platform (HDP) 2.1 and certified against MongoDB Enterprise for versions 2.4…

Big Data Governance, Big Data Modeling

big data modeling x300

by Jelani Harper Prior to recent developments in Big Data Governance and Big Data Modeling, there was a perceived tradeoff between Big Data initiatives and Data Governance. The rapid implementation and generation of business value of the former would innately reduce the efficacy of the latter. According to Danny Sandwell, who works in product marketing…

Presenting Data Models

Michael Blaha

by Michael Blaha So you have prepared a data model. You’re proud of your work. Now how do you explain the model to others? You want them to understand your work and you want their feedback. We can think of three techniques for presenting data models. Use a Data Modeling Tool An obvious approach is…

Designing Better Data Models for NoSQL Databases

books

by Angela Guess Jack Vaughan recently wrote for Search Data Management, “Typically built for speed and designed for specific purposes, NoSQL databases forgo the rigid database schemas of SQL-based relational software. As a result, they can be deployed quickly and adapted on the fly; in addition, they can handle data sets with diverse structures and…

OTLP, OLAP, and Data Culture

dm

by Angela Guess Mark Hargraves recently wrote for Smart Data Collective, “Why is data modeled into different formats?  What we have been told over the years is it is based on the need of the system.  If it is a transactional based system then data needs to be modeled into the OTLP [on line transactional…

Database Archaeology

Michael Blaha

by Michael Blaha Few database projects start with a clean slate. Many operational applications have legacy databases as a source of data and ideas. Analytical applications have the operational databases that are feeding data. Developers often encounter existing databases that are poorly documented and need to figure them out. We use the term database archaeology…